Forget OEINV* and OECRD*, use only OEAUDH and OEAUDD

Please explain why.  I am a bit new and cannot see why these tables would be different.  If using OEAUDH and OEAUDD do I ignore credits and debits? Are these figures accurate?  Will they match "O/E Sales Statistics" -> "Net Invoice Amount"

Also, thank you for the fast response!

The reason why, is because these are the tables that those of us who have been using this product for 15 years use.  Search the Sage 300 forums for Application Object Model (AOM) to get table/field layouts.

My issues with the AOM is that it does not explain or show how the data actually flows.

When I look at (OEAUDH with TRANSTYPE=1) it does match "O/E Sales Statistics" -> "Net Invoice Amount"

Am I to assume that when a credit is posted pertaining to an Invoice it also effects the rows in OEAUDH and OEAUDD for TRANSTYPE=1 that had (before the credit was posted) applied to the given invoice?  Does it remove them? or change them....or something else.

My issues with the AOM is that it does not explain or show how the data actually flows.

When I look at (OEAUDH with TRANSTYPE=1) it does match "O/E Sales Statistics" -> "Net Invoice Amount"

Am I to assume that when a credit is posted pertaining to an Invoice it also effects the rows in OEAUDH and OEAUDD for TRANSTYPE=1 that had (before the credit was posted) applied to the given invoice?  Does it remove them? or change them....or something else.

OESHDT = OE sales history detail

OEAUDD and H are Audit tables - therefore once posted, they will never be changed or deleted as part of a transaction.  

I think I speak on behalf of most of us 'old' consultants in that the object models are 100% accurate, but the relationships between associated tables (audit and history) are not documented anywhere and I don't think anyone on the forum could tell you exactly how all the relationships work.  You should learn them the same way we did:  create a new customer, post some transactions and monitor the tables.  With that approach, you will own the relationships when you are done.

Note: The thing you have to be careful about is that in many cases in Sage, Credits are not stored as negatives, the are just flipped to a negative based upon the TRANSTYPE.

OESHDT stores credits as negatives :)