Calculations groups
In the calculation groups it is setup how BTA should calculate and with which agreement line fields. Below the most important features are described.
Code and Description
If you have many types of calculation, it helps to keep track of the difference, if descriptive accurate code and description is used.
Use Source Quantity and Amount
If one or both of these is checked, it means that the amount and/or quantity is used in the calculation.
Quantity is used to calculated an total amount that are based on some kind of quantity and amount. It could be weight, quantity, QOM or some other quantity field times the rate. Which quantity is specified in the field Quantity Field Code.
An example could be a tax that are based on weight times a fixed rate.
Amount is used to calculate an amount that are based on the amount. Which amount is specified in the field Unit Price Field Code.
An example could be a bonus of some kind where Percentage Rate is used.
Amount can be used together with Quantity and will give a calculation that is based on amount, but the quantity will also be showed.
An example of this could be Bonus. Instead of accruing 1x100 Euro Bonus. It will accrue the quantity times a unit bonus like 5x20 Euro Bonus. The end amount is the same, but the quantity is different.
Reclass and Recalculate
These two are only used for settlement agreement lines. Which means if accrue is used at least one calculations group with reclass needs to be made.
Reclass means that it will change the accrued amount to a settlement amount.
Recalculate gives the possibility to recalculate an accrued amount. An example could be that 2% bonus has been accrued, but the customer has a bonus that is turnover dependent and should now receive 2,5% bonus. This can be handled with Recalculate.
How to setup Settlement calculations groups
To make a calculations group that settle the accrued amount, only Use Source Amount and Reclass need to be check. Besides that, Posting Frequency need to be Start.
If an accrued amount should be Recalculate, Recalculate also need to be check and Line Discount/Charge % need to be specified to the Percentage Rate.
Quantity and Unit Price Field Code
Quantity and Unit Price Field Code is used to specified, which fields to use in the calculation.
See Agreement line Fields Setup for more information.
Use Measure Field Code
Use Measure Field Code is used to make agreement lines that are dynamic on a certain value. In Use Measure Field Code it is specified which total amount or quantity that should be calculated. This can then be used on agreement lines to filter into divided groups. This could be freight cost that are divided in different prices(rates) based on weight.
Posting Frequency
The Posting Frequency controls when the BTA Documents lines will be posted.
- First is designed to be used with settlement. Frequency First will post the full BTA Amount first time the order document is posted.
- Last is designed for fee or charges that is not based on source amount or quantity. An order fee will be an example of this. Frequency Last will post the full BTA Amount after the last quantity is shipped/received and next time the document is invoiced.
- Partial will post a partial amount that is based on first the posted source amount or secondly the posted source quantity.
Note
With Posting Frequency Last there can be cases where not BTA amount is posted. This happen, if there is a partial posting on the order document. After this posting the quantity is change to the quantity already posted. In this case, the order document is finished without the "Last" posting. It is also possibility that the BTA amount is posted before the last posting, if the order document is change after all quantity is shipped/received.
Note
With Posting Frequency Last and Use Source Amount the source amount will be calculated on the last posting and not the whole order document. Which means this open will not be feasible to agreements like bonus and taxes.
