search

murad073 / SmartAccount

This project is for small business accounting system
http://smartaccount.dyanit.com/
11 stars 3 forks source link

Database issues #48

Closed jakaria42 closed 12 years ago

jakaria42 commented 12 years ago

Issue 1: See public IList GetLedgerBook(): IList records = _recordRepository.Get() returns records for the selected project. But it returns 0 (zero) debit/credit for all the records which have LedgerType == LedgerBook. This is why we see 0 amount in the ledger view / voucher view tab.

Issue 2: In public IList LedgerDataGrid, how can we get the cheque no field from BankRecord table for a particular record?

Also similar to this: I need all the fields of the BankRecord table for a particular record in public IList VoucherDataGrid.

jakaria42 commented 12 years ago

For issue 2: In the BankRecord table in the database, the field Record_ID is null. That is, there is a foreign key problem. I think, that's why the lambda expression is not working.

murad073 commented 12 years ago

issue 1 is solved. I am now on issue 2.