Hi all, we have a website build in Magento, every ...
# general
d
Hi all, we have a website build in Magento, every order created in the website will be auto created into NS via Restlet. Prices in website are tax included. When it comes into NS, Restlet will recalculate back the prices excluding tax before creating the Sales Order. Example: (We are using Indonesian Rupiah (IDR) as main currency) Website = Shipping Cost = IDR 50,000 including tax Netsuite = after recalculation in Restlet, price before tax = IDR 45,454.54 We have shippingcost, discountrate, and line items rate recalculated like the above. After suming up all, the Sales order total ended up, for example IDR 999,999 which is not a valid amount in IDR, the amount should be IDR 1,000,000 which is the same as in the website and what the customer paid The error during creation of the Sales Order is
Copy code
"Transaction was not in balance. Total = -1.0"
Probably what we're doing is not the following the best practice, any suggestion how should we fix this, or maybe different approach should be taken ? Thanks