Sage 300

 View Only

  • 1.  Accpac v5.6A I need help! On site ... What table

    Posted 11-19-2014 14:14
    Accpac v5.6A I need help! On site ... What table and field contains the inventory item List Price / Retail Price / Base Price?


  • 2.  RE: Accpac v5.6A I need help! On site ... What table

    Posted 11-19-2014 14:17
    @DougHiggs - The table you want is ICPRICP


  • 3.  RE: Accpac v5.6A I need help! On site ... What table

    Posted 11-19-2014 14:19
    It's further defined by a field in the DPRICETYPE which has 6 entries 1= Base Price Quantity, 2 = Sale Price Quantity, 3=Base Price Weight, 4 =Sale Price Weight, 5=Base Price using Cost and 6 = Sale Price Using Cost


  • 4.  RE: Accpac v5.6A I need help! On site ... What table

    Posted 11-19-2014 14:21
    @DougHiggs if you search Google for AOM 5.6 (substitute the version you are working with if not 5.6) you will find that numerous consultants have put the Accpac Object Model (the equivalent of the Sage 100 file layouts) online.


  • 5.  RE: Accpac v5.6A I need help! On site ... What table

    Posted 11-19-2014 16:31
    @LloydSmith Thank you!!... That is what I needed. @PhilMcIntosh Thanks for the info.... I have a file layout and I spent a lot of time putting fields from various files on a crystal report but it was a time consuming crap-shoot. Just converted a user today from Accpac to Sage 100 and the pricing is customer price levels ... price is discounted on retail.


Related Content