Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JustMark2015

    Accpac Net Quantity Sold in Excel

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

    Accpac Net Quantity Sold in Excel

    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)...
  3. JustMark2015

    Accpac Net Quantity Sold in Excel

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

    Accpac Net Quantity Sold in Excel

    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 -...
  5. JustMark2015

    in Accpac 6.0A, where is Base Price located?

    Ahh, I see now. Unit price IS the base price. Makes sense. Thank you Ettienne for the quick response!
  6. JustMark2015

    in Accpac 6.0A, where is Base Price located?

    The ICPRIC table does not include Base Price in Accpac 6.0A. Could someone let me know where I can locate base pricing? Thank you in advance.

Part and Inventory Search

Back
Top