Home > Item Management > Items > Concepts > Cost Components > Calculating Service Fees and Ullage

Calculating Service Fees and Ullage

For clarity of reading, Service Fees only are explained. However, the same principle applies to Ullage.

First of all, the product is retrieved from the Items form.

If the Service Fee flag (in the Supplier Details section) is checked off, the service fee is zero and no further calculations are required.

If the flag is checked on, the details for the supplier associated with the product are retrieved. The supplier fees are obtained for this supplier.

The system finds the most appropriate fee by checking location, department/category/group and classification. It starts by checking fees for the specific location, if none are available it looks at the location’s parent and continue until all locations are checked. If the system finds fees for a valid location, it will check the department/category/group and classification of the fee with the supplier’s department/ category/ group and classification recorded against the product (obtained from Items). If a suitable match is made the fee is accepted. If no match is found the system then looks for a fee where the department/category/group matches, then the department/category, and then the department.

At this point the ‘fee’ is just a number. We need to check the calculation method to determine what to do with this number. If the method is charge per carton, the number is the actual Service Fee to be added to the Cost Ex Tax. (Remember Cost Ex Tax is already a carton cost.) If the method was a percentage, the number is divided by 100 and multiplied by (Cost Ex Tax - Deals) to produce the Service Fee. Easy!

Invoices are used to record the amount that a supplier has billed for items shipped to a location (such as a store or warehouse). The fees that can be added at the bottom of the invoice and distributed amongst all the items in the invoice are distributed based on the 'invoiced' quantity. If you have invoiced all the items in an earlier invoice, then the distribution will not work as expected in any subsequent invoice. Use the Extra Invoice Costs function to record additional costs in association with an invoice.

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)