Landed Cost Budgets
Last updated
Last updated
Please complete the first before proceeding with creating Landed Cost Budgets
When all required setup is finalized Landed Cost Budget records can be created. There are different sources where the Budget records can be created.
Vendor Landed Cost Budgets
Are Landed Costs to be applied to a single Vendor. To create the Vendor Landed Cost Budget record -
Open a Vendor Record > Navigate to TradeQloud > TQ Landed Cost Budget > New TQ Landed Cost Budget
Item Landed Cost Budgets
Are Landed Costs to be applied to a single Item. To create the Item Landed Cost Budget record -
Open an Item Record > Navigate to TradeQloud > Landed Cost Budget > New TQ Landed Cost Budget
Generic Landed Cost Budgets
Navigate TradeQloud > Landed Cost > TQ Landed Cost Budget > New
When creating a Landed Cost Budget record the following data fields are available.
Auto-Apply Transactions
Specify transaction types to which the budget record should be automatically applied.
No
Vendor
Identifies the primary vendor associated with the goods or services being procured. This field is defaulted and shown as inline text when created from Vendor record.
No
Item
Identifies the specific item within transactions that the landed cost is associated with. This field is defaulted and shown as inline text when created from Item record.
No
Landed Cost Vendor
Designates the vendor responsible for additional landed costs. This can be the same as the Vendor.
Yes
PO Creation Method
Defines the approach for generating Purchase Orders for landed costs.
Yes
Description
Provide an overview or details about the budget record. This is shown on the Landed Cost Purchase Order.
No
Primary Landed Cost Variance Method
Select a Primary method for handling discrepancies between estimated and actual landed costs.
No
Secondary Landed Cost Variance Method
Select a Secondary method for handling discrepancies between estimated and actual landed costs. This is mandatory if the primary method is Update Inventory Cost (Open Period Only)
No
Landed Cost Item
Specifies the item which is used on the landed Cost Purchase Order.
The item must be Other Charge for Purchase and the native field ‘Can Be Fulfilled / Received’ should be set to FALSE.
Yes
Landed Cost Category
This is the landed cost item category. This is sourced from the landed cost item
No
Calculation Method
Describes the method used to allocate landed 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 landed costs, relevant for certain calculation methods.
No
Currency
Specifies the currency in which the landed costs are calculated and applied.
Yes
When a Landed Cost Budget record is saved additional filters for the cost application can be added by creating a TQ Landed Cost Filter record. The Landed Cost Filter record is designed to enhance the filtering capability of Landed Cost Budget records that are applied from Entity or Item to the Transaction during the Landed Cost process.
On creation of this records the fields under the Landed Cost Budget Information Field Group are inherited from the Landed Cost Budget Record. Additional data to be provided is based on the selected Filter Type. The following options are available
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 if required.
When the Filter is saved, the application will automatically create TQ Landed Cost Filter Item Application Records. This record is designed to enhance the Item filtering capability on the Landed Cost Filter.
After selecting 'Apply' and saving the filter, a TQ Landed 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 Landed Cost Filter Item Application Record.
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 Landed 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
If you continue to experience issues after following this guide, we recommend reaching out for further assistance.
Please contact us at with a detailed description of the problem. Our dedicated support team is committed to helping you resolve any challenges you may encounter.
