Accpac Net Quantity Sold in Excel 1

[JustMark2015]

I need to populate an excel spreadsheet to show sales quantities (by item) for the last 5 years. I have queries in place to access our accpac tables but I'm having difficulty finding which table(s) produce the results that match our BI reporting. Initially I tried using ICSTATI.SALESQTY - ICSTATI.SALERTNQTY but this isn't correct. I read somewhere I need to use QTYSHIPPED - QTYRETURN but I'm not sure which table or how to sum the results among the period/location and other details. Can anyone point me in the right direction? What table(s) do I need to access? Advice?

Thanks in advance!

 

[JustMark2015]

Sage ERP Accpac 500 (Version 6.0A)...

 

[Jay Converse]

Pull from OEAUDD.

 

[JustMark2015]

Thanks Tuba! The OEAUDD table contains the QTYSHIPPED I was looking for. My problem now is: I was using ICSTATI to pull the SALERTNQTY but I don't know how to make this work with the OEAUDD table. Do I need a key? Where else would I find SALERTNQTY/QTYRETURNED?

Keys available (It seems):
DAYENDNUM - OEAUDD_KEY_0
ENTRYNUM - OEAUDD_KEY_0
LINENUM - OEAUDD_KEY_0
TRANSTYPE - OEAUDD_KEY_0

Thanks in advance!

 

[Jay Converse]

I never use ICSTAT for any reports, so I don't konw.

 

[DjangMan]

Go for OESHDT.

 

[ettienne]

OESHDT shows sales vs returns.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[JustMark2015]

Hi Gents, OESHDT had the info I was looking for. Thanks for your help!