Finding all sales-related GL Entries

afarr

Our client wants a report of the balance of all sales-related GL Entries (grouped by GL account).

The process for a given Customer Ledger Entry, is to bring up the Applied Entries, and then Navigate to the GL entries.
The report should do this for each Customer Ledger Entry, but it takes several minutes in a company with 70,000 Cust. Ledger Entries and 800,000 Gen. Ledger Entries.

I can think of two alternative methods. I think that Method 1 would give the same set of GL Entries as the method above, but Method 2 probably wouldn't.
Can anyone tell me if this is so?

Method 1. List all GL Entries with Source Type = Customer.

Method 2. List all GL Entries where we can Navigate to an associated Customer Ledger Entry (i.e. where there exists a Customer Ledger Entry with the same posting date and same document no.).

Thanks,
Alastair

ssingla

Try one of my favourite:

viewtopic.php?f=7&t=17097&hilit=daily+invoicing

G/L entry have source code and Source no of the customer and a filter on document type of Invoice will give you the required info.

Alex_Chow

afarr

Thanks for the replies.

I found that Method 1 (described above) is NOT in fact equivalent to the original method I described.
That is, the original method (from Cust LEs, find the Applied Entries and then Navigate to the GL Entries) will bring up several GL Entries that do NOT have Source Type = Customer.

I haven't checked Method 2, as I'm pretty sure that this would also give a different set of GL Entries.

Alastair