Remittances Extra Ref-Batch Invoice(showing) vs Update Ledger(not showing)
Posted: 11 Jul 2018, 12:58
Hi Bruce,
Since working with the Extra Ref field we gave our remittance templates a makeover to suit our visual needs. Nothing changed in the joins etc.
Part of this work was to bring the Extra Ref field in from the Remittances table, so we could see our purchase order number and the suppliers invoice number on the report.
This works fine for the invoices (it appears) that are processed through the Batch Invoice function, but it seems that the Extra Ref is missing when we use the Update Ledger method. I do not work the accounts, so i'm a little unfamiliar with the two different methods.
I had a quick look at the joins and "just for fun" i added the audit split table in and joined the account ref field on inner joins to the Purchase Ledger table, and ran it - so of course it returned a lot of duplicated lines, but as a test, in that run, it worked, the Inv Ref and the Extra Ref appeared at some point together as the layout would want.
So, the question is, is this the right approach? to add in the Audit Split table too? have it on it's own and remove the remittance table ?
If i add it in, of course i would need to work out how to stop the duplication etc.
Just wondered if this has been asked before ?
thanks
Paul
Since working with the Extra Ref field we gave our remittance templates a makeover to suit our visual needs. Nothing changed in the joins etc.
Part of this work was to bring the Extra Ref field in from the Remittances table, so we could see our purchase order number and the suppliers invoice number on the report.
This works fine for the invoices (it appears) that are processed through the Batch Invoice function, but it seems that the Extra Ref is missing when we use the Update Ledger method. I do not work the accounts, so i'm a little unfamiliar with the two different methods.
I had a quick look at the joins and "just for fun" i added the audit split table in and joined the account ref field on inner joins to the Purchase Ledger table, and ran it - so of course it returned a lot of duplicated lines, but as a test, in that run, it worked, the Inv Ref and the Extra Ref appeared at some point together as the layout would want.
So, the question is, is this the right approach? to add in the Audit Split table too? have it on it's own and remove the remittance table ?
If i add it in, of course i would need to work out how to stop the duplication etc.
Just wondered if this has been asked before ?
thanks
Paul