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
  • Billing a Landed Cost Purchase Order / Variance Management
  • Stand-Alone Bill Processing
  • Need Assistance?
Export as PDF
  1. Qloud Margin Control
  2. Using QMC
  3. Examples
  4. Landed Costs

Landed Cost Billing & Variance Management

PreviousTransaction Landed CostsNextSales Costs

Last updated 18 days ago

Billing a Landed Cost Purchase Order / Variance Management

When Landed Cost Purchases Orders are billed, if any variances are identified, the application will use the Primary Landed Cost Variance Method (and if necessary the Secondary Landed Cost Variance Method) to determine how the variance should be handled. The options are as follows:

Update Inventory Cost (Open Period Only)

If the related Item Receipt is in an Open Period, it adjusts the landed cost on the Item Receipt to reflect the actual landed cost. This method ensures that the landed cost recorded on the Item Receipt matches the actual cost incurred, providing accurate cost tracking for inventory items.

If the related Item Receipt is in a Closed Period, no further action is processed.

When selecting this option. Selecting a Secondary Method is mandatory.

Update Inventory Cost (Open & Closed Period)

If the related Item Receipt is in an Open Period, it adjusts the landed cost on the Item Receipt to reflect the actual landed cost. This method ensures that the landed cost recorded on the Item Receipt matches the actual cost incurred, providing accurate cost tracking for inventory items.

If the related Item Receipt is in a Closed Period, an inventory adjustment will be created to account for the variance.

Journal to COGS

Creates a journal entry to adjust the Cost of Goods Sold (COGS) account for the landed cost variance. This method directly impacts the income statement by recognizing the variance as an expense, ensuring accurate profit and loss reporting.

Journal to Variance

Creates a journal entry to a specific variance account to record the landed cost variance. This method segregates the variance from regular COGS and inventory adjustments, allowing for detailed tracking and analysis of landed cost discrepancies.

Do Nothing

No action is taken to address the landed cost variance. The variance remains unadjusted in the system, allowing users to manually review and handle discrepancies as they see fit.

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?

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.

💰
support@tradeqloud.com