Jiwa6&7 DB_trans SourceID link to Sales Order lines

[lennykp]

Hi
Each snapshot of a sales order corresponds to a so_history record, when processed, creates a DB_Trans record for that delivery.
Wouldn't it better if DB_Trans.sourceid be the so_history.invoicehistoryid instead of so_main.invoiceid ?

Lenny
Attkey Computer Solutions

[Mike.Sheen]

Hi
Each snapshot of a sales order corresponds to a so_history record, when processed, creates a DB_Trans record for that delivery.
Wouldn't it better if DB_Trans.sourceid be the so_history.invoicehistoryid instead of so_main.invoiceid ?

Lenny
Attkey Computer Solutions

Hi Lenny,

We'd need to redo the sales order system to separate an order from a goods issue note and tax invoice to make this work (which is planned). This way the debtor transaction sourceID would be the Tax Invoice, not the sales order - we'd dispense with snapshots, but probably still have a way of seeing what was delivered and invoiced so far from the sales order.

The fundamental problem is the source document for a debtor transaction is identified by a source and sourceID. The source is the name of the form the transaction originated from (eg: "JiwaFinancials.Jiwa.JiwaSalesUI.SalesOrder.SalesOrderEntryForm") and the source ID is the ID used to read that document. As our standard business logic pattern is to have a Read method which is passed a RecID, it gives us a consistent interface so we, or anyone else can introduce a new debtor transaction source, and everything will "just work" - including drill-downs.

Mike