-
How do we get costs on RMAs for drop ship items?
When we have RMAs attached to Sales Orders that were Drop Shipped, there is no cost associated and the GL impact is blank. How can we have costs applied to these transactions?
-
Invoice Created > GL Impact changes after saved removing Cost of Sale amounts for Inventory items
When we create Invoices with Inventory Items with Cost Estimate Type set to Average Cost there are GL Impact changes against the Invoice that end up removing the Cost of Sale for certain Items. It seems that it happens when the line item's quantity causes the Item's Location Qty on hand to go to 0. If the inventory isn't…
-
gl account entries turning into items
Hello, we are inputting AP invoices in NS and seeing for each item booked to a gl, it is turning into an "item" overnight when we choose a gl# from our COGS group of accounts. We see that every gl account is attached to an item for COGS. This is causing an issue for us with syncing Bill.com. When we look in Bill.com COA,…
-
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…
-
FIFO Cost Tracking
Hello NetSuite Experts/Gurus! We want to track the FIFO Costing of an item. We tried to utilize the Inventory Activitiy Detail report but we couldn't display or pull out the Purchase Cost. Just wondering if you have an idea on how we could effectively generate that kind of report?
-
How to revalue item cost without affecting quantity, losing SO/PO connections?
Hi Gurus, I have a customer asked: how to revalue item cost without affecting quantity, losing SO/PO connections. I know we can do this via inventory adjustment. But we lose the connections with other transactions after the inventory adjustment. For example, we have lot-numbered electronic components near expiration date.…
-
What are the methods of cost calculation for Kit/Package items?
Cost calculation method for kit/package items What methods are available for calculating the cost of a kit/package item? We are having trouble figuring out how to calculate the cost of a kit/package item because the cost and quantity of the breakdown items differ for each item. Should we use a saved search to create the…
-
Reclassify COS or Expense Account of Item per Transaction
Is it possible to change the selected COS or Expense Account of an Item per Transaction (Fulfillment / Bill Record)? Is it doable in Scripting? I have done SuiteGL before. I think the tricky part for this if we want to implement reclassing of Sales/ COGS in transaction level, is if the transaction is cancelled. Then we…
-
Unbalanced inventory in transit
I reconciled my Inventory in Transit account by following the SuiteAnswer Id: 37836. The result was a number of transfer orders that were fulfilled and received with different amounts on the Inventory in Transit account. Why does this happen? As a result I get a higher inventory cost in the receiving location than it…