Transaction Sales Costs
Last updated
Last updated
When creating a Sales Transaction e.g. Sales Order, the QMC application introduces additional functionality on the TradeQloud tab.
Calculation of Sales Cost Budgets
As transaction lines are entered, any applicable Sales Cost Budgets will be displayed on the Sales Cost Budget field group.
This allows for users to see which sales costs are applicable, before the transaction is saved. Changes can be made as follows:
Sales Costs can be excluded by checking the Apply check-box
Rates / Percents can be modified
Sales Cost Impact
Another field group displays the impact that the Sales Costs have on the rate, as well as the total cost
Item, Quantity, Starting Rate Rate, Amount are all sourced from the transaction
Starting Rate is the starting price for Sales Cost Calculations. This is sourced from the customer or item but could be changed on a transaction.
Net Rate is the rate of selling the item plus/minus all the applicable costs required to deliver it to the customer.
Net Amount is the Net Rate * Quantity
Cost is the cost of the item. The cost is defined as the location average cost.
Total Cost is the Cost * Quantity
Margin is (Net Amount - Cost) / Net Amount
When the transaction is saved, the application will create the TQ Transaction Sales Cost records.
This record represents the application of the cost from the budget record. TQ Transaction Sales Costs can also be added manually to transactions, or existing records can be modified.
Sales Cost Budget Filers are also created as TQ Transaction Sales Cost Filters. Item filters are stored directly on the transaction sales cost creation.
The application will also create a TQ Transaction Sales Cost Allocation record as a child to the TQ Transaction Sales Cost record. The record documents the allocation of each Transaction Sales Cost to individual line items within a transaction. It provides granular details on how sales costs are apportioned across items, ensuring precise cost tracking and financial accuracy in inventory valuation.
The Sales Cost Allocation records cannot be modified by users
If you continue to experience issues after following this guide, we recommend reaching out for further assistance.
Please contact us at support@foodqloud.com with a detailed description of the problem. Our dedicated support team is committed to helping you resolve any challenges you may encounter.