Go to Stock > Stock Options and click on the Pricing tab.

Use this option if you want to round up or down all the inclusive prices in your database.

Hover the mouse over the different menu options. If the cursor changes to a hand (Hand_Cursor), then click to go to the subject.

Suppliers With Stock To OrderHelpSecurity SetupTabsUnlock MonitorQuick AddCalendardashboardCompanyEmployeeQuoteWorkshopSupplierCustomerLedgerInvoiceFileRTS LookupGoods ReceivingGRN LookupPO LookupNew RTSNew POPurchase PlanningExtraStock GroupsStock TakeStock AdjustmentsStock OptionsStock TurnoverItem LookupExtended Item LookupStock DetailNew ItemStock Main Menu

                                                                                                                                                                                                                                                                                                                                                                    Arrow_Blue

Low Stock Level for PricingLocalSpecial as Line Discount %Volume DiscountStock_Options_Pricing

 

Once you have Selected all the amounts for the Rounding Rules - select Recalculate Prices Now.

Remember - if you want to round down, use negative numbers.

 

In the above example, the Upper Threshold of 5 and rounding of 0.05 means that all inventory items with a price between 0 and 5 will be rounded to the nearest 5 cent.

The next upper threshold of 100 and rounding 0.5 means that all inventory items with a price between 5.01 and 100 will be rounded to the nearest 50 cent.

 

If you don't want to round all the prices in the database, but only during invoicing then you can set it under Invoice > Invoice Options and ignore this form.

 

Example of calculations - Always Use Inclusive Prices

Cost

Mu %

Exclusive selling price

VAT @ 15%

Total

Rounded Up

Exclusive price

18.6

30

24.18

3.36

27.81

28.00 (Price customer will pay)

28 - (28x15/115) = 24.35








Example of calculations - Round exclusive price

Cost

MU %

Exclusive selling price

Rounded UP

VAT

Total


18.6

30

24.18

25.00

3.75

28.75 (Price customer will pay)


Round exclusive prices will normally only be used for example in business to business transactions where it is important to use rounded exclusive prices.

 

Special as line discount %

Instead of printing the special price on the invoice, the original price will be used and the special price will be shown as a discount.

 

Volume Discount: Use each quantity.

For example, If you use volume discounts and the discount is set that if you sell 5 or more beers a discount of 15% can be given. If you now sell a six pack (6 beers), no discount is given unless you have checked the 'Volume Discount: Use each quantity' option.

 

Low Stock level for pricing.

Set the stock level number.

This option will come into play if you had selected the Pricing Method as 'If low stock USE supplier list ELSE avg. cost' in the Cost and Selling Prices tab.

 

Keywords: Always use inclusive prices,Low Stock Level For Pricing,Price rounding,Rounding,Special Price as Line Discount %,Volume Discount: Each Qty.