Sales Order Tax & Totals Algorithm

I am trying to replicate the way MAS 200 calculates sales order totals and taxes.

We are integrating our website with eBusiness Web Services and we need to know the correct amount to charge the customer's credit card before we send the order to MAS. I believe that I am very close, but would really like to know the exact way they do it so I can run some automated tests.

Does Sage publish this information? 

Does anyone have any good links they can share about how to replicate this functionality?

Any help would be appreciated!

  • 0

    The common issue is that you are not calculating the sales tax as one figure. You are actually breaking it out and calculating per code and not per schedule. For example say you have a schedule that is made up of 3 codes, state, county and city. You multiple the order total by the state rate, the order total by the county rate and the order total by the city rate and then add them all together rather than multiplying the order total by the total rate.

  • 0 in reply to BigLouie

    I have already reverse engineered the tax complete calculation function. What I really need is the way the totals are calculated.

  • 0 in reply to nbirkes

    Not sure where your confusion lies?

    sum of taxable items from lines tab  - discount (pro-rata) =  taxable sales

    sum of non-taxable items from lines tab - discount (pro-rata)  = non-taxable sales

    order total = taxable sales + non-taxable sales + freight + sales tax = order total

    order total - deposit = net order