Linking Source Journal Entry to Account Code

[infotech2]

I'm building custom revenue reports based on the Accounts Receivable module using Crystal Reports. Unfortunately, when an accountant does a Journal Entry, it throws my numbers off. I need a way to get those Journal Entries linked to an accountkey. I haven't been able to find anything in the SourceJournal table that will allow me to do this and Sage support isn't helpful at all.

Any suggestions would be much appreciated.

Thanks!

 

[BigLouie]

Can you explain which tables you are using and how they are linked.

 

[infotech2]

See the table and links below. Color coded for your viewing pleasure

AR_InvoiceHistoryHeader
InvoiceNo
HeaderSeqNo
CustomerNo

AR_InvoiceHistoryHeader
InvoiceNo
HeaderSeqNo
SalesAcctKey

AR_Customer
CustomerNo

GL_Account
SalesAcctKey

 

[infotech2]

I found the correct tables and am going to list them here just in case anyone ever needs this type of report.

GL_SourceJournalHistory
GL_DetailPosting
GL_Account