-
Landed Costs on Multiple Item Receipts
A customer using WMS mobile in a space-constrained warehouse needs to receive and putaway purchase orders line by line, creating one item receipt (IR) per PO line. This allows for immediate putaway without having to receive the entire PO at once. However, they also need to track landed costs. How can we apply landed costs…
-
NSC | Understanding GL Impact of Manual Landed Costs and Vendor Bills
Scenario: The user manually entered landed costs on Item Receipts for freight charges while also receiving a weekly vendor bill from the freight provider covering multiple shipments. The concern was whether entering landed costs manually and then recording the related vendor bill would result in duplicated GL impact or…
-
Landed Cost per Item
My customer uses Landed Cost on the Item Receipt, I could create a analytics workbook to have the costs breakdown by item. However my customer wants this breakdown based on the Item fullfiments, so he can get the cost of COGS. I checked and I dont see any correlation between the purchase and the fulfillment, or with the…
-
Landed Cost per Item - Saved search/Analytics/ Report
Hi, my customer needs something to view the item cost, spliting the landed costs per item. Here is an example: Item 1: 26.75 - 17.00 PO cost + 7.65 duties+ 2.1 freight Item 2 : 26.78 - 18.25 PO cost + 7.65 duties+ 0.88 freight The items do not have serie/lot number so I dont know if it is possible to breakdown the landed…
-
WATCH: Saved Search to Show Landed Costs Associated to Item Receipts
This video is on how to create a saved search that shows the landed costs associated to item receipts. Here's the formula used in the search: WITH BREAKDOWN PER LANDED COST CATEGORY Amount per Landed Cost Category = CASE WHEN ({memo} LIKE '%XXXX%') THEN {amount} else 0 END Note: Replace XXXX with the name of the Landed…
-
Landing Cost Category
Hi Team, We would like to know if it’s possible to add the Landing Cost Category field to Journal Entry transactions. Currently, some expenses are recorded through journals, and since the field is not available, we’re unable to link these entries to the corresponding Goods Receipt Notes. As a result, we’re entering the…
-
REST API to apply landed cost to an item receipt
Hello, everyone. I really hope someone can help me with this. Is it possible to apply landed cost to an item receipt using the REST API? I've tried searching for information on this but haven't found anything yet. I tried with the fields id and the API response is 204, but when i see headers response i found message…
-
Double entry of landed costs - GL Impact
Hello, Our freight service provider provides us a single invoice once a week for clubbing together various shipments. In these cases, for recording landed costs, I manually enter the cost. When I do this, I see that there is a GL impact, crediting freight (expense account) and debiting inventory (other current asset…
-
NSC | Landed Cost > Variance Account GL Impact
Scenario User is managing a standard cost inventory item in NetSuite. When they allocate landed costs (e.g., shipping, customs duties) to this item through item receipts or vendor bills, they observe that these costs are posted to the price variance GL account rather than being added to the inventory asset account. They…
-
NSC | Preferred Landed Cost template Is Not Loading on a Purchase Order
Scenario User is experiencing an issue where their preferred landed cost template is not loading on a purchase order. Solution Below is a step-by-step guide to resolve the issue and ensure your landed cost template populates automatically on purchase orders again: Navigate to Scripted Records: In your system, go to…