Guest Posted January 30, 2010 Share Posted January 30, 2010 As far as I can see sales data is stored as Net Sales and the tax and gross are calculated on the invoice sub total. Unfortunately, when a new product is entered the gross amount (to two decimal places) viz dollars and cents is converted to net and stored as 'products_price' and/or 'final_price' (to four decimal places). The existing php script exports the Net Amount of an order on a line by line basis, and the Gross for the whole invoice total to two decimal places. Rounding by mySQL means that when the individual lines are multiplied back to obtain a Gross Line figure we run into errors that the accounting software will not tolerate. I am not a php programmer and would appreciate guidance on how the full detail shown on the standard invoice could be incorporated into the export file generated by exportorders.php Regards, peter_of_stirling Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.