Backup of TQ Setup
Landed Costs
Enable Landed Costs
Enable this feature to enhance the standard NetSuite landed cost functionality. Once enabled, it is possible to establish vendor landed cost budget records linked to vendors (master data).
Landed Cost Transactions
Select all supply transactions to which landed costs are to be applied. After selection, the application will generate Transaction Landed Cost Budget records on the record, or it will offer users the option to add these manually
It is recommend that Purchase Order is populated in the Landed Cost Transactions field
Landed Cost Rounding
Landed Cost Rounding allows for specifying the decimal rounding precision for calculated landed cost values. This setting determines how the system rounds off the final amounts of landed costs allocated to each item or transaction line, ensuring consistency and accuracy in financial reporting.
Landed Cost Subsidiaries
Select the Subsidiaries that Landed Cost should execute on.
Landed Cost Locations
Select the Locations that Landed Cost should execute on.
The recommend Landed Cost Rounding is 3 decimals
Update IR Rate Based on Vendor Bill Rate
If this is checked, when a Vendor Bill is saved , the application will compare the rates Vendor Bill and Item Receipt rates. If there is a variance, the rate will be updated on the Item Receipt.
It is recommend to enable this feature
Update IR Rate Saved Search
Select the saved search used to identify any variances between the Item Receipt Rate and the Vendor Bill Rate. The saved search results identify which receipts are to be updated.
It is recommended selecting the default saved search FQ APM - Update Rate, unless there are specific requirements for Item Receipts that should not be updated
Default Landed Cost PO Creation Method
Defines the standard action for generating POs (Purchase Orders) for Vendor, Item or Transaction Landed Costs (Budget) records. On individual records this setting can be changed as required.
Default Primary Landed Cost Variance Method
Select a Primary method for handling variances (i.e. discrepancies) between budgeted and actual landed costs.
Default Secondary Landed Cost Variance Method
Select a Secondary method for handling variances (i.e. discrepancies) between budgeted and actual landed costs. In case the Primary method is Update Inventory Cost (Open Period Only), this setting is mandatory.
It is recommended to select Update Inventory Cost (Open Period Only) as Default Primary Landed Cost Variance Method
It is recommended to select Journal to COGS as the Default Secondary Landed Cost Variance Method field
Automatically Process Landed Cost Variance
The application will when checked, after a Landed Cost Vendor Bill is processed, compare the rates between the Vendor Bill and Item Receipt.
If there is a variance, the variance will be automatically handled based upon the variance method on the transaction landed cost.
It is only recommend that the Automatically Process Landed Cost Variance is enabled after one month of transacting using QMC to ensure results are understood before impacting the general ledger
Sales Costs
Enable Sales Costs
Enable this feature to track sales costs in addition to the cost of goods sold. Once enabled, it is possible establish Sales Cost Budget records (master data).
Sales Cost Transactions
Select the demand transactions to which sales costs can be applied. After selection, the application will generate Transaction Sales Cost Budget records on the transaction, or it will offer users the option to add these manually to a transaction.
It is recommend that Sales Order & Invoice is populated in the Sales Cost Transactions field
Sales Cost Subsidiaries
Select the Subsidiaries that Sales Cost should execute on.
Sales Cost Locations
Select the Locations that Sales Cost should execute on.
Sales Cost Rounding
Allows specifying the decimal rounding precision for calculated sales cost values. This setting determines how the system rounds off the final amounts of Sales Costs allocated to each item or transaction line, ensuring consistency and accuracy in financial reporting.
The recommend Sales Cost Rounding is 3 decimals
Default Sales Cost PO Creation Method
Defines the standard action for generating POs (Purchase Orders) for costs.
This setting determines the default value on Customer, Item or Transaction Sales Costs (Budget) records. On individual records this setting can be changed as required.
Default Sales Cost Processing Method
The Sales Cost Processing defines the strategy for how the Sales Cost Record is transacted.
The available options for Sales Cost Processing Methods are:
Add as Line Item - Individual
Will add each sales cost budget as a separate line item on the transaction.
Add as Line Item - Grouped
Will group each sales cost budget per sales cost and combines into a transaction line.
Add as Discount Item
Applies the sales cost as a discount item, inserting a discount line underneath each applicable line item. This can be an increase or decrease.
Change Rate with Custom GL Posting
Adjusts the rate on the transaction and posts the sales cost as a custom GL posting based on the item selected.
Change Rate
Changes (i.e. increases or decreases) the rate on the transaction to include the sales cost, directly altering the transaction amount.
Custom GL Posting
Posts the sales cost to the general ledger based on the item selected, without altering the transaction amount or rates.
No GL Posting
Processes the sales cost without posting any entries to the General Ledger, ensuring no financial impact.
It is recommended that Change Rate and Custom GL Posting is set as the Default Sales Cost Processing Method
Default Sales Cost Custom Price Handling Method
Allows for the differentiation between custom pricing derived from customer master data versus custom pricing set on a transaction (by a user or via integration e.g. EDI). This setting only applies when:
The transaction line has the price level set to ‘Custom’
A Sales Cost applies that has ‘Change Rate’ set to TRUE
The following Custom Price Handling Methods options are available:
Always Change Custom Rate
Sales Cost will modify the rate in all scenarios.
Change Manually Entered Rates Only
Sales Cost will modify the rate if a user/integration or script has (manually) changed the rate on the transaction.
Change Customer/Item Specific Custom Pricing
Sales Cost will modify the rate if the rate is sourced from the Customer Item Pricing record.
Never Change Custom Rate
Sales Cost will never modify the rate.
It is recommend that Always Change Custom Rate is set as the Default Sales Cost Custom Price Handling Method
Default Percentage Rate Calculation Method
Select the default value to use as the starting value when a percentage Sales Cost is used to increase/decrease the rate.
For above percentage rate calculation methods following options are available:
Starting Rate
is the price (custom or price level) entered on the transaction line during creation of the transaction
Rate
is the calculated price after all sales costs set as 'Change Rate' = TRUE have been applied to the starting rate
Net Rate
is the calculated net margin after all sales costs set as 'Change Rate' = FALSE have been applied to the starting rate
It is recommended that Starting Rate is used in Default Percentage Rate Calculation Method fields
Automatically Process Sales Cost Variance
When a Sales Cost PO is billed, if there is a variance the script will automatically create a Journal for the variance.
Need Assistance?
If you continue to experience issues after following this guide, we recommend reaching out for further assistance.
Please contact us at [email protected] with a detailed description of the problem. Our dedicated support team is committed to helping you resolve any challenges you may encounter.
Last updated