-
How to fix Sales Orders that are fulfilled but never get invoiced (causing a cost with no matching r
Explanation of the case: Goods (an order) were shipped from Subsidiary A's warehouse to Subsidiary B's warehouse, via a Sales Order that was fully fulfilled — meaning the goods physically left inventory. The problem: When the goods were shipped (Fulfillment), the system recorded the cost (COGS) directly against Subsidiary…
-
Item Fulfillment COGS lines show consistent ~0.012% (1.00012x) discrepancy between raw GL_IMPACT deb
We're building custom reporting directly against NetSuite Analytics Warehouse (NSAW) fact tables and reconciling COGS figures back to native NetSuite GL reports (Account 4001 – Cost of Goods Sold, Subsidiary Context = Consolidated, Primary Accounting Book). On multiple Item Fulfillment transactions, we're seeing a small…
-
Amount Debit foreign currency is empty in Item Fulfillment saved search
A saved search is created to show item fulfillments created from sales order, along with the sales order amount in base currency and consolidated, COGs amount in base currency and consolidated and the consolidated exchange rate. The issue is the formula used to calculate the consolidated exchange rate is Formula (Currency)…
-
Saved Search COGS & Invoice Amount Not Matching with Trial Balance ?
I need a Saved Search that includes the following details: Sales Order Document Number Related Item Fulfillment COGS Amount Invoice Amount The total COGS Amount and Invoice Amount should match the Trial Balance report. However, when I tried creating the Saved Search, the totals are not matching with the Trial Balance…
-
[COST OF GOODS SOLD]Advise Needed to Adjust COGS after the period is closed
Hi GURUS, I have an scenario where i would like to seek suggestion and advise from the Gurus: ** For your information, we are setting our item's Costing Method = "Group Average Cost". During end of JANUARY 2026, we have created a Purchase and Item Receipt with below information: Quantity = 5 Rate = $5 per unit Once the…
-
Missing COGS in Cash Sale
Hello, We have cash sale records created from Shopify in NetSuite. There are no sales orders or item fulfillments. We noticed that on some cash sale records we are missing COGS for inventory items. Then noticed that those inventories were missing cost in the respective locations. To test the process, we made an inventory…
-
Saved search with Item Fulfillments not returning today's transactions without COGS line
I have a saved search that we use to research any transaction affecting an item. I have it set up as a sublist on the item record. Among the transactions it returns is Item Fulfillment. I've set up the saved search to filter out Main Line, Tax Line, Shipping Line, and COGS Line, so we just see one line for each…
-
COGS and Item names
Is there a report that I can create to see the item names on the cost of goods sold general ledger accounts? Under Setup>Accounting>Accounting Preferences>General Tab, Expand Account Lists is enabled. All the Inventory general ledger accounts show the item name when a search or reports is generated. I have a request from…
-
Is it possible to calculate a dynamic COGs based on sales order sales price?
Hi NS Community! My company does something a bit unique, (at least i think it is) and I'm not sure if the way we handle it in NetSuite is the correct way. Let me explain... We sell "products" on behalf of our partners for a 10% commission. We also pay about a 10% fee in order to "ship" the products. The inventory is not…
-
System-Generated Translations: COGS Line
Hi, We built a customization/solution that depends on the Memo field of a COGS line, however this Memo field value is generated by the system depending on the user's language preference. This can be checked by viewing the GL Impact of a transaction. Where can one find the system-generated translations for lookup in the…