TradeQloud Apps for NetSuite
  • 👋Welcome to TradeQloud
  • Quick Start
  • Setup & Version Management
  • 🎚️TradeQloud Setup
    • Introduction
    • Administrator's Guide
      • License Validation
      • User Roles & Permissions
      • Custom Objects
        • Transaction Line Fields
        • Transaction Body Fields
        • Workflows
        • Other Record Fields
        • Custom Center / Category / Tabs
        • Custom Records
  • 💰Qloud Margin Control
    • Introduction
    • Getting Started
      • Prerequisites
      • Installation Guide
      • Sales Cost - Quick Start
      • Landed Costs - Quick Start
    • Using QMC
      • Setup Guides
        • TQ Setup
        • Landed Costs Setup
          • PO Creation Methods
          • Landed Cost PO Creation Methods
          • Primary Landed Cost Variance Method
          • Secondary Landed Cost Variance Method
        • Sales Costs Setup
          • PO Creation Methods
          • Sales Cost Processing Methods
          • Sales Cost Custom Price Handling
          • Sales Cost Percentage Change Method
          • Sales Cost Variance Handling
        • Custom GL Plug-in Setup
        • Filtering
      • Examples
        • Landed Costs
          • Landed Cost Budgets
          • Transaction Landed Costs
          • Landed Cost Billing & Variance Management
        • Sales Costs
          • Sales Costs Budgets
          • Sales Cost Budget Filters
          • Transaction Sales Costs
    • Administrator's Guide
      • User Roles & Permissions
      • Custom Objects
        • Transaction Line Fields
        • Transaction Body Fields
        • Entity Fields
        • Custom Lists
        • Item Fields
        • Custom Records
        • Workflows
      • NetSuite Components
    • FAQ and Troubleshooting
      • Common questions
      • Optimizing Performance
    • Release Notes
      • v1.0 (Nov 2024)
Powered by GitBook
LogoLogo
On this page
  • Setup GL Accounts
  • Setup Cost Categories
  • Create Landed Cost Items (Service Items for Resale)
  • Update Existing Vendors
  • Update Existing Items
  • Need Assistance?
Export as PDF
  1. Qloud Margin Control
  2. Using QMC
  3. Setup Guides

Landed Costs Setup

PreviousTQ SetupNextPO Creation Methods

Last updated 18 days ago

The following setup is required before the application can be utilized:

Setup GL Accounts

General Ledger accounts are required to be created to ensure accurate postings to the general ledger.

For each landed cost category utilized, three accounts should be setup, being

  • Other Current Liability Account

  • COGS Account

  • Variance Account

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.

It is recommended to use Summary Accounts in the General Ledger. For example


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.

Name
Description

No Cost PO

This option indicates that no Purchase Order will be created. This is typically used for internal costs.

Create Individual Cost PO

This option indicates that a new Purchase Order will be created specifically for this cost.

Create Grouped Cost PO

This option indicates that the costs will be grouped together with other costs for the same entity on a Purchase Order .

Add to Source Transaction

This option indicates that the costs will be added to the Source Transaction, merging the costs into a single transaction.

Add to existing PO

This option indicates that the landed cost should be added to any existing (Cost/Source) Purchase Order. If selected, the Purchase Order must also be selected .

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.

Once setup has been completed, landed cost budgets can now be created.


Need Assistance?

If you continue to experience issues after following this guide, we recommend reaching out for further assistance.

Please read for more detail.

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.

💰
Using the Application - Landed Costs
support@tradeqloud.com