Adding information to Debtors Reports
Posted: 23 Aug 2018, 10:59
I have no Sage/accounts training so please forgive my ignorance...
We run accounts for two sides of the business so we sometimes need to add 'our ref' and 'their ref' to invoices, I have added INVOICE.ORDER_NUMBER as their ref as we use that most often and our ref as NOTES_1.
I want to include the info from NOTES_1 in the debtors report next to the TYPE-DATE-Inv no. information under the ACCOUNT_REF Header. The Group expression for this is SALES_LEDGER.ACCOUNT_REF.
I have tried to add it in in various ways which either give me 'no report data' or I get 649 lines duplicated (we have 649 invoices) under each account with the reference I want appearing once.
Hope this makes sense!
Thanks
Sage version 18.1.0.20
Reports Designer version 1.3.2011.25
OS Windows 10 64bit
We run accounts for two sides of the business so we sometimes need to add 'our ref' and 'their ref' to invoices, I have added INVOICE.ORDER_NUMBER as their ref as we use that most often and our ref as NOTES_1.
I want to include the info from NOTES_1 in the debtors report next to the TYPE-DATE-Inv no. information under the ACCOUNT_REF Header. The Group expression for this is SALES_LEDGER.ACCOUNT_REF.
I have tried to add it in in various ways which either give me 'no report data' or I get 649 lines duplicated (we have 649 invoices) under each account with the reference I want appearing once.
Hope this makes sense!
Thanks
Sage version 18.1.0.20
Reports Designer version 1.3.2011.25
OS Windows 10 64bit