Re: [Axapta-Knowledge-Village] How to get all offset account information from a vendor?

2004-11-11 Thread Girish B
if you want the corresponding data (of the LedgerTrans table) from LedgerJournalTrans table. then in the LedgerTrans the "Posting" has to be ledgerJournal and then get the match using the journalNo and the voucher of both the tables. Butif the voucher nos are the same on multiple lines then it wil

[Axapta-Knowledge-Village] How to get all offset account information from a vendor?

2004-11-10 Thread hfmadcr
Hello. I'm making a report listing all offset account of a vendor. To get all offset account I extract the information from the "LedgerTrans" table, but I need show in some cases the Invoice number or cheque number. The problem is that I don't know how get the Invoice Number or Cheque Number fr