Sales Costs
Last updated
Last updated
Create Sales Cost Budget records against customers, items or generic costs
Automatic application of budget records to transactions, with the ability to add new or modify budget records on a transaction
Create or add Sales Costs to new or existing Sales Orders
Automatic application of Costs to Sales Orders and Item Fulfilments without user intervention
Automatic variance handling and reconciliation
When all required setup is finalized, Sales Cost Budget records can be created. There are different sources where the Budget records can be created.
Customer Sales Cost Budgets
Are Sales Costs to be applied to a single Customer?
Open a Customer Record > Navigate to TradeQloud > TQ Sales Cost Budget > New TQ Sales Cost Budget
Item Sales Cost Budgets
Are Sales Costs to be applied to a single Item ?
Open an Item Record > Navigate to TradeQloud > TQ Sales Cost Budget > New TQ Sales Cost Budget
Generic Sales Cost Budgets
Navigate TradeQloud > Sales Cost > TQ Sales Cost Budget > New
When creating a Sales Cost Budget record, the following data fields are available
Auto-Apply Transactions
Specify transactions to which the budget record should be automatically applied to.
No
Customer
Identifies the customer associated with the goods or services being sold.
No
Item
Identifies the specific item within transactions that the sales cost is associated with.
No
Sales Cost Processing Method
The Sales Cost Processing defines the strategy for how the Sales Cost Record is transacted.
Yes
Description
Provide an overview or details about the budget record. This is shown on the Sales Cost Purchase Order. This is shown on the Sales Cost Purchase Order.
No
Sales Cost Item
Specifies the item to be used for costing. This item will appear on transactions and impacts the general ledger.
The item must be Other Charge for Resale OR Service for Resale and the native field ‘Can Be Fulfilled / Received’ should be set to FALSE.
Yes
Calculation Method
Describes the calculation method used to calculate sales costs to items/transactions.
Yes
Allocation Method
Describes the calculation method used to allocate sales costs to items/transactions.
Yes
Rate
Indicates the rate to use in the cost calculation.
No
Percent
Denotes the percentage used in the calculation of sales costs, relevant for certain calculation methods.
No
Currency
Defines the currency to use when transacting.
Yes
Custom Price Calculation Method
This setting allows for the differentiation between custom pricing derived from customer master data and custom pricing set on a transaction by a user.
No
Percentage Rate Calculation Method
Select the default value to use as the starting value when a Sales Cost is used to change the rate.
No
Automatically Process Sales Cost Variance
When a Sales Cost PO is billed, if there is a variance (and the above field is checked) then automatically create a Journal for the variance.
For the Automatic Variance to trigger, this feature must be enabled in TradeQloud Setup too.
No
PO Creation Method
Defines the approach for generating Purchase Orders for sales costs.
No
Sales Cost Vendor
Designates the vendor responsible for additional sales costs. This can be the same as the Vendor.
No
When a Sales Cost Budget record is saved additional filters for the cost application can be added by creating a TQ Sales Cost Filter record. The Sales Cost Filter record is designed to enhance the filtering capability of Sales Cost Budget records that are applied during the Sales Cost process.
On creation of these records the fields under the Sales Cost Budget Information Field Group are inherited from the Sales Cost Budget Record. Additional data to be provided is based on the selected Filter Type. The following options are available
Items
When this filter type is selected, the Item Filter - Field Group is enabled. This filter type requires an Item Saved Search as basis for filtering. Based on the Saved Search Criteria, the results are shown in a data table. In this data table, the users can select or unselect items from the filtering as required.
When the Filter is saved, the application will automatically create TQ Sales Cost Filter Item Application Records. This record is designed to enhance the Item filtering capability on the Sales Cost Filter.
After selecting 'Apply' and saving the filter, a TQ Sales Cost Filter Item Application Record will be created:
If new items are created that match the saved search criteria, the system will automatically create a new TQ Sales Cost Filter Item Application Record.
Transaction Body Field / Transaction Line Field
When either of the Transaction Field filter types is selected the Transaction Filter - Field Group is enabled. Following fields can be configured to create the desired filtering.
Record Types
Select the transaction types the Sales Cost Budget should be applied to.
Field Name
Select the desired Transaction field (Body or Line) to be filtered on.
Value List
If applicable, join values are shown to specify the filter value
Field Data Type
Will show the field type for the selected field based on the Value List. The field will show as Disabled in case a single option is available. Field as Country of Origin or Item will provide multiple options such as List/Record or Multiselect.
Operator
Provides options on how the filter is to be applied. Examples are: Field Name = Class Value List = Class
Operator Options: ANYOF, NONEOF, ISEMPTY, ISNOTEMPTY
Field Name = Amount
Value List = NONE
Operator Options: EQUALTO, NOTEQUALTO, GREATERTHAN, LESSTHEN, etc.
Value
Value(s) with which the Operator will use to filter
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.
REPLACE SCREENSHOT ONCE 5892 is resolved
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
REPLACE SCREENSHOT ONCE 5892 is resolved
Item, Quantity, 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.
SC Impact is ....
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
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 (if applicable). 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.
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
When Sales Cost Purchases Orders are billed, if any variances are identified, and the Sales Cost Budget has 'Automatically Process Sales Cost Variance' set to TRUE, the application will automatically create a Journal for the variance.
For the Automatic Variance to trigger, this feature must be enabled in TradeQloud Setup
