Setting up sales and purchase condition calculations
The Sales and Purchase Calculation codes represent the type of conditions that are applicable in your company. These conditions can be:
- Price discounts or charges (amount per unit); on invoice or periodic.
- Fixed Price discounts or charges (amount per item or document); on invoice or periodic
- Gross % discounts or charges (a percentage calculated on the price of products); on invoice or periodic.
- Net % discounts or charges (a percentage calculated on the price of products minus other discounts or charges); on invoice or periodic.
- Promotions (Discount) (buy quantity X get quantity y); on invoice
- Promotions (Free Item) (buy product A, get product B for free); on invoice.
The calculation codes only represent your type of conditions. They don’t include the rules that explain how and when they are applied, or what the amount or percentage is that should be applied. These parts of the setup are done in the Condition Rules and Condition Rates. One condition calculation code can have multiple condition rules.
-
Select the Search icon
, enter Sales and Purchase Condition Calculations, and then choose the related link.
The Sales and Purchase Condition Calculations page opens. -
On the action bar, select New.
-
Enter the required information in the fields.
-
Select the Use Calendar Period checkbox to specify that the periodic condition should end on the last day of the calendar period. When the Use Calendar Period checkbox is cleared, the calculation is based on the Starting Date field value on the Sales and Purchase Condition Rule page. The Suggest Periodic Journal Lines action on the Condition Periodic Settlement Journals page generates lines according to the Calculation Period Type field value defined on the Sales and Purchase Condition Calculations page, even if no starting date is specified in the sales and purchase condition rule.
-
Select the Ignore Item Line Discount checkbox to exclude the line discount applied to the item from the net percentage discount calculation. This checkbox is editable only when the Calculation Method Type field value is set to Net% and the Calculation Period Type field value is set to Order.
You can select the Period option in the Calculation Period Type field to define calculation periods based on predefined accounting periods from the Accounting Periods page.
Hover over a field to read a short description.