# Landed Cost Budgets

{% hint style="warning" %}
Please complete the [setup ](https://docs.tradeqloud.com/qloud-margin-control/using-qmc/setup-guides/landed-costs-setup)first before proceeding with creating Landed Cost Budgets
{% endhint %}

{% embed url="<https://lucid.app/documents/embedded/cee78239-bcf0-47fb-b96d-b6b256b4f9d4>" fullWidth="false" %}

### Create Landed Cost Budgets <a href="#create-landed-costs-budgets" id="create-landed-costs-budgets"></a>

When all required setup is finalized Landed Cost Budget records can be created. There are different sources where the Budget records can be created.&#x20;

<table data-full-width="false"><thead><tr><th width="269">Type</th><th>Description</th></tr></thead><tbody><tr><td>Vendor Landed Cost Budgets</td><td><p>Are Landed Costs to be applied to a single Vendor.<br>To create the Vendor Landed Cost Budget record -</p><p>Open a Vendor Record > <strong>Navigate to TradeQloud > TQ Landed Cost Budget > New TQ Landed Cost Budget</strong></p></td></tr><tr><td>Item Landed Cost Budgets</td><td><p>Are Landed Costs to be applied to a single Item.<br>To create the Item Landed Cost Budget record -</p><p>Open an Item Record > <strong>Navigate to TradeQloud > Landed Cost Budget > New TQ Landed Cost Budget</strong></p></td></tr><tr><td>Generic Landed Cost Budgets</td><td>Navigate <strong>TradeQloud > Landed Cost > TQ Landed Cost Budget > New</strong></td></tr></tbody></table>

When creating a Landed Cost Budget record the following data fields are available.&#x20;

<table data-full-width="false"><thead><tr><th width="150">Field Name</th><th width="477">Description</th><th>Mandatory</th></tr></thead><tbody><tr><td>Auto-Apply Transactions</td><td>Specify transaction types to which the budget record should be automatically applied.</td><td>No</td></tr><tr><td>Vendor</td><td>Identifies the primary vendor associated with the goods or services being procured. <mark style="color:orange;"><strong>This field is defaulted and shown as inline text when created from Vendor record.</strong></mark></td><td>No</td></tr><tr><td>Item</td><td>Identifies the specific item within transactions that the landed cost is associated with. <mark style="color:orange;"><strong>This field is defaulted and shown as inline text when created from Item record.</strong></mark></td><td>No</td></tr><tr><td>Landed Cost Vendor</td><td>Designates the vendor responsible for additional landed costs. This can be the same as the Vendor.</td><td>Yes</td></tr><tr><td>PO Creation Method</td><td>Defines the approach for generating Purchase Orders for landed costs.</td><td>Yes</td></tr><tr><td>Description</td><td>Provide an overview or details about the budget record. This is shown on the Landed Cost Purchase Order.</td><td>No</td></tr><tr><td>Primary Landed Cost Variance Method</td><td>Select a Primary method for handling discrepancies between estimated and actual landed costs.</td><td>No</td></tr><tr><td>Secondary Landed Cost Variance Method</td><td>Select a Secondary method for handling discrepancies between estimated and actual landed costs. <mark style="color:orange;"><strong>This is mandatory if the primary method is Update Inventory Cost (Open Period Only)</strong></mark></td><td>No</td></tr><tr><td>Landed Cost Item</td><td><p>Specifies the item which is used on the landed Cost Purchase Order.</p><p>The item must be <strong>Other Charge for Purchase</strong> and the native field <strong>‘Can Be Fulfilled / Received’</strong> should be set to <strong>FALSE</strong>.</p></td><td>Yes</td></tr><tr><td>Landed Cost Category</td><td>This is the landed cost item category. This is sourced from the landed cost item</td><td>No</td></tr><tr><td>Calculation Method</td><td>Describes the method used to allocate landed costs to items/transactions.</td><td>Yes</td></tr><tr><td>Rate</td><td>Indicates the rate to use in the cost calculation.</td><td>No</td></tr><tr><td>Percent</td><td>Denotes the percentage used in the calculation of landed costs, relevant for certain calculation methods.</td><td>No</td></tr><tr><td>Currency</td><td>Specifies the currency in which the landed costs are calculated and applied.</td><td>Yes</td></tr></tbody></table>

### Create Landed Cost Budget Filters <a href="#create-landed-cost-budget-filters" id="create-landed-cost-budget-filters"></a>

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

#### Items  <a href="#tq-landed-cost-filter-item-application-records" id="tq-landed-cost-filter-item-application-records"></a>

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.&#x20;

<div data-full-width="false"><figure><img src="https://3422641029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMzVAkLHuKD7fofWoLeMK%2Fuploads%2FLasjkGKTFchdsswV8rLa%2Fimage.png?alt=media&#x26;token=ad88d112-e5bc-41b5-b6c8-654e33e2fd77" alt=""><figcaption></figcaption></figure></div>

After selecting 'Apply' and saving the filter, a **TQ Landed Cost Filter Item Application Record** will be created:

<div data-full-width="false"><figure><img src="https://3422641029-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FMzVAkLHuKD7fofWoLeMK%2Fuploads%2FBdHbO0ojtFogpKbS3EbE%2Fimage.png?alt=media&#x26;token=e0ff59a4-2843-48fb-9cd7-b0411cc8a3fc" alt=""><figcaption></figcaption></figure></div>

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.**

#### 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.&#x20;

<table data-full-width="false"><thead><tr><th width="220">Field Name</th><th>Description</th></tr></thead><tbody><tr><td>Record Types</td><td>Select the transaction types the Landed Cost Budget should be applied to.</td></tr><tr><td>Field Name</td><td>Select the desired Transaction field (Body or Line) to be filtered on. </td></tr><tr><td>Value List</td><td>If applicable, join values are shown to specify the filter value</td></tr><tr><td>Field Data Type</td><td>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. </td></tr><tr><td>Operator</td><td><p>Provides options on how the filter is to be applied. Examples are:<br>Field Name = Class<br>Value List = Class  </p><p>Operator Options: ANYOF, NONEOF, ISEMPTY, ISNOTEMPTY</p><p></p><p>Field Name = Amount</p><p>Value List = NONE</p><p>Operator Options: EQUALTO, NOTEQUALTO, GREATERTHAN, LESSTHEN, etc. </p></td></tr><tr><td>Value</td><td>Value(s) with which the Operator will use to filter</td></tr></tbody></table>

***

## Need Assistance?

{% hint style="success" %}
If you continue to experience issues after following this guide, we recommend reaching out for further assistance.&#x20;

Please contact us at <support@tradeqloud.com> with a detailed description of the problem. Our dedicated support team is committed to helping you resolve any challenges you may encounter.
{% endhint %}