Back Orders for ERP: data model references ?
- by Patrick Honorez
I have built an ERP using Sql Server as a back-end.
These are the different types of Client documents (there are also Supplier Docs):
Order -- impact: BO
Delivery Note (also used for returns, with negative quantity) --impact: BO, Stock
Invoice --impact: accounting only
Credit Note --impact: accounting, BO
I use a complex system of self joins (at detail level) to find out the quantities in each OrderDetail that still have a backorder (BO). It'd like to simplify this using a [group] field that could be used through all detail line related to an original order.
There are many difficult things to trace: a Return of a product may be due to a defect and thus increase the BO, or it can be just a return, joined with a Credit Note, and then has no impact on BO.
My question is: do you know of any real good reference (book, web) for this matter ?