A1.84 : Sales: Apply formula for Subtotal causing incorrect Unit Price
Question : I have created UDF_CurrRate at Invoice detail and set a formula for Subtotal.
Formula : Subtotal = d_Qty *d_UDF_CurrRate * d_UnitPrice
But when I key in CurrRate = 2 and Unit Price = 100, the Unit Price will change to 200 and Subtotal become 400?
Possible Reason :
There is an option to calculate unit price from subtotal, which is enabled by default.
Solution :
If you set a formula for Subtotal, you must disable this option.
Go to Tools > Options > Invoicing > Document Control, uncheck Calculate Unit Price from Subtotal and click on OK.
Now, your formula should run correctly.
--Source from AutoCount Wiki --
Related Articles
A1.88 : Sales: Item Selling Price did not follow Multi Pricing
Question: I have set the debtor AAAA using Multi Pricing 2 and Price 2 for ITEM 1 is 1.50, but when create Invoice, why the unit price is 3.00? Found out that it was following Item Price Book. Possible Reason : You didn’t enable Use Multi Pricing or ...A1.7 : Purchase: Decimal setting for qty & unit price in purchase invoice
Question: Can I adjust the decimal places of Quantity and Cost in Purchase Invoice? As for now I only can key in 2 decimal points for Unit Price but not for Quantity. Version: 1.8 / 1.9 / 2.0 Answer: Yes. System provides a flexibility for you to ...A1.66 : How to set the formula with Operators (If)
Question : My Unit price is calculated using formula = d_UDF_UP * d_UDF_W * d_UDF_H. But sometimes the value of UDF is empty, it causes the Unit price becomes 0. How can I set the Formula, so that when the value of UDF is null, it will be counted as ...A5.71 : Sales - Transactions : Credit Note
This function allows you to manage your Credit Notes. Credit Notes is usually to record any goods return or further discount. *Credit Note will increase your stock quantity and amount will be posted into your accounts which will affect your Stock and ...A2.142 : How to add unit price column at second customer display?
Question : How to add unit price column at second customer display? Solution : 1. First, login POS Front End program and stay at the login screen page. 2. Then switch to the second screen display page 3. Right click on the Column Tab and click on ...