I am trying to generate a report by vendor which shows Both entries to the GL of each invoice. Expense and balance sheet. I have used the NL function with the G/L Entry table but it only returned the trade creditor code.
Does anyone know how I can pull the opposite entry?
The purpose is to see how much we have paid to our lawyer in the past year by activity. The various activities are posted to different expense codes.
Thanks in advance
Hello Nicola -
If you look at the G/L Entry table, what field(s) in a record distinguishes the one record from the other? That is what you would use for filtering your NL function(s).
Thanks, I have the report pulling through the amount and the GL code I just need it to pull through all the lines on the invoice. At the moment I am only getting one line per invoice No. when there may be 2 or 3
Hi Nicola -
It sounds like you want to create a "Grouping Report" where the first NL function will pull the invoice number and then the other NL function will pull all the lines for that invoice.