Version Management

We are continually improving TradeQloud Apps for NetSuite to:

• Add new features / modules

• Improve existing performance

• Implementing bug fixes

New versions will be communicated via e-mail supported by release notes and version highlights.

Release Notes can be found here: Release Notes.

Installation

You will then be required to provide administrator access to the TradeQloud deployment team. Your account manager will let you know which email address to use.

Once access has been provisioned, TradeQloud will then install the Setup application, along with the TradeQloud Apps that you have purchased.

Post Installation

After installation, a Center Tab will be added to your NetSuite account titled TradeQloud. Under the Center Tab, a link is provided to the Setup page.

The TradeQloud Setup includes two basic modules.

Supply Order

Enable this feature to track inventory from procurement (via purchase order or work order) to final sale using Supply Orders (a custom record/segment).

Once enabled, a custom record and segment will be generated for each supply order and supply order line.

Demand Order

Enable this feature to track inventory from estimate to invoicing using Demand Orders (a custom record/segment).

Once enabled, a custom record and segment will be generated for each demand order and demand order line.

Short text on what the optimization tends to do

1. Step by Step guide to implement the optimization

2. Step 2 of the guide

Optimization 2

Short text on what the optimization tends to do

1. Step by Step guide to implement the optimization

2. Step 2 of the guide

Tips & Tricks

Tip/Trick #1

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Praesent quis hendrerit urna. Curabitur aliquet efficitur est, nec finibus erat consequat et. Orci varius natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus.

Still experiencing issues?

The following NetSuite features are required if using Landed Costs

The following NetSuite Accounting Preferences are required if using Landed Costs

The following TradeQloud Setup (TradeQloud -> Setup -> Setup) is required:

• Enable Supply Order Creation

• Supply Order Transactions = Purchase Order, Vendor Bill

Sales Costs

The following NetSuite features are required if using Sales Costs

The following TradeQloud Setup (TradeQloud -> Setup -> Setup) is required:

• Enable Demand Order Creation

• Demand Order Transactions = Sales Order, Invoice

Steps in FQ Internal NetSuite

• Create Customer Record

• Create Customer Licensed App Record

Customer Account

• Install application

• Configure Custom GL Plug-In

Need Assistance?

Here is an example of the accounts on an item:

And here is an example of a Sales Cost using Custom GL Posting:

Create Sales Cost Items (Other Charge / Service Items for Resale)

Sales Cost Items are used to include additional charges on sales orders and invoices. These items should be setup as either Other Charge or Service Items for Resale. These items can be used on the following Sales Cost Processing Methods:

• Add as Line Item - Grouped

• Add as Line Item - Individual

• Change Rate

• Change Rate and Custom GL Posting

• Custom GL Posting

• No GL Posting

For more information

Create Discount Items

Discount Items are used when using Sales Cost Processing Method = Add as Discount Item.

This processing method aligns to standard NetSuite Discount Items., and inserts a discount line underneath each applicable line item. This can be an increase or decrease.

Update Existing Items

Tracking Sales Costs for Items being Sales must be enabled on Item records.

To enable the Tracking of Sales Costs on Items set the Item field "Track Sales Cost" to Yes.

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.

Need Assistance?

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.

Default Sale Cost PO Creation Method The Cost PO Creation Method defines the standard procedure for generating Purchase Orders (POs) for costs. This setting determines the default value on Customer / Sales Cost Budget / Transaction Cost records but can be changed as required. For more information, click here.

Default Sales Cost Processing Method The Sales Cost Processing defines the strategy for how the Sales Cost Record is transacted. For more information on each method, please refer to the User Manual. For more information, click here.

Default Sales Cost Custom Price Handling 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. For more information, click here.

Default Percentage Rate Calculation Method With this setting you can set the default value that's used as the starting value when a percentage Sales Cost is used to increase/decrease the rate. For more information, click here.

Automatically Process Sales Cost Variance This setting allows you to automatically create a Journal when a Sales Cost PO with a variance is billed.

Setup - Landed Costs

Enable Landed Costs Enables the Landed Cost Functionality

Landed Cost Transactions Select the supply transactions to which sales costs can 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 to a transaction.

Landed Cost Subsidiaries Select the Subsidiaries that Landed Cost should execute on.

Landed Cost Locations Select the Locations that Landed Cost should execute on.

Landed Cost Rounding Allows 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.

Update IR Rate Saved Search

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

Update IR Rate based on Vendor Bill Rate

With this setting, when a Vendor Bill is saved, the rate between the Vendor Bill and the Item Receipt will be compared. Any variance rates will be updated on the Item Receipt.

Default Landed Cost PO Creation Method The Cost PO Creation Method defines the standard procedure for generating Purchase Orders (POs) for costs. This setting determines the default value on Vendor / Landed Cost Budget / Transaction Cost records but can be changed as required. For more information, click here.

Default Primary Landed Cost Variance Method The Primary method for handling variances (i.e. discrepancies) between budgeted and actual landed costs.

For more information, click here.

Default Secondary Landed Cost Variance Method The 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.

For more information, click here.

Automatically Process Landed Cost Variance This setting allows you to automatically create a Journal when a Landed Cost PO with a variance is billed.

Need Assistance?

Nothing!

☢️ Impact

Profit insights for everyone!

Other Current Liability Account

This account is used on the following master data records:

• Landed Cost Category

• Service Item

When an Item Receipt is processed and a Landed Cost is applied, this account is credited. For example, if an Item Receipt is created, and two Landed Costs are Applied (Customs and Transportation):

The following GL Impact will occur:

When the Vendor Bill is then processed for the Landed Costs, this account is debited.

The following GL Impact will occur:

COGS Account

This account is used when posting variances for landed costs to the COGS account. Examples provided here.

Variance Account

This account is used when posting variances for landed costs to the variance account. Examples provided here.

Setup Cost Categories

Landed cost categories identify the expense account costs are posted to when the category is selected. For each landed cost type that will be tracked, a landed cost category is required to be setup.

Below an example of a cost category for 'LC - Transport' using the same account defined above

Create Landed Cost Items (Service Items for Resale)

Landed Cost Items are used to include additional charges on purchases orders and vendor bills as separate line items. For example, you use a transport company to deliver items you need. Two bills are received:

• One from the vendor that charges you for the items.

• One from the transport company that charges you only for transporting the items.

When entering the bill for transport, you must select an item to associate the transport expense as a landed cost. Since the transport bill is not associated with an inventory item, you must create a landed cost item record for transport.

Update Existing Vendors

Changes to be made to existing vendor records is limited. On vendor level the Cost PO creation Method is to be determined. The Cost PO Creation Method defines the standard procedure for generating Purchase Orders (POs) for costs associated with this particular vendor. This setting determines the default value on Cost Budget / Transaction Cost records but can be changed as required.

The Cost PO Creation methods application hierarchy is as follows.

Update Existing Items

Tracking Landed Costs for items being purchased must be enabled on Item level. To activate Tracking of Landed Cost set the Item field "Track Landed Cost" to Yes.

Need Assistance?

Need Assistance?

Need Assistance?

Stand-Alone Bill Processing

Vendor Bills can be entered for Landed Costs without any Purchase Orders. If a Bill is entered that has an Item with a Landed Cost Category selected, a new button will appear on the Vendor BIll Allocate Landed Cost Bill

After selecting the button, a new page will appear where a user can allocate each Vendor Bill Line. The following fields are required to be populated:

• Calculation Method

• Allocation Method

• Primary Variance

• Secondary Variance

Item Receipts can then be filtered on the next page and selected by clicking the 'Add Line'

After selection, the system will automatically calculate the New Total Cost for the item.

Once Submitted, the system will create the appropriate Transaction Landed Cost and Transaction Landed Cost Allocation records, and either update the Item Receipt selected, or process the variance.

Need Assistance?

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

TQ Transaction Sales Cost

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.

TQ Transaction Sales Cost Allocation

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.

Need Assistance?

Update existing Items and ensure 'Track Landed Cost = T' (for inventory items)

Set Default Sales Cost PO Creation Method = No PO

Update Items

Update existing Items and ensure 'Track Sales Cost = T'

On the TradeQloud tab you will see the available Sales Cost.

Landed Cost Management

Sales Cost Management

Can't find your question?

When creating a Landed Cost Budget record the following data fields are available.

Create Landed Cost Budget Filters

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

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.

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.

Need Assistance?

Create Sales Cost Budgets

When all required setup is finalized, Sales Cost Budget records can be created. There are different sources where the Budget records can be created.

When creating a Sales Cost Budget record, the following data fields are available

Create Sales Cost Budget Filters

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.

Creating a Transaction e.g.. Sales Order

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

TQ Transaction Sales Cost

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.

TQ Transaction Sales Cost Allocation

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.

Billing a Sales Cost Purchase Order / Variance Management

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.