x Want to participate? Join the group to interact
New

Add links between Sales transactions and SOP invoices, Purchase transactions and POP invoices

It's not unusual to want to drill down from a sales or purchase invoice/credit note to the SOP/POP invoice.  At present, the database structure makes this difficult or impossible as it depends on the transaction reference - which can be amended.

A simple way to implement this would be to write the transaction URN back to the SOPInvoiceCredit / POPInvoiceCreditLine table when a SOP/POP invoice is posted.  And of course, the implementation of a POPInvoiceCredit table, not just POPInvoiceCreditLine, would also help.

Geoff Turner

  • Geoff, a better idea would be to have a set of linkage tables for this sort of thing. URNs are not always good enough and the same problem arises with SL/PL xtions to NL postings. If there were a set of linkage tables to join the dots between the modules using the identity column, this would solve your problem and my problem with ledgers to NL, and with a little more thought, it would go a long way in making partial exempt VAT schemes a whole better experience. Potentially all this additional linkage could be added using the messaging framework but that also assumes that all the processes also and subscribable messages!

*Community Hub is the new name for Sage City