-
History of Average Cost of Items
How do I find Average Cost of an Item at a given point in time? As per the definition below from Netsuite, since the Average Cost changes based on the new purchase costs and Inventory, we would like to see how the Average Cost is changing over a period of time. Reason is, we use Average Cost for spend reports and they can…
-
How do I add the average cost of an item on the Inventory Turnover
I am having trouble adding the Average Cost of an Item to the Inventory Turnover. It shows up as a field to add, but then they all come through blank. This is a request from our Supply Chain Team. I was able to bring in the Purchase price, but can't get the Average cost.
-
Manually Update Average Cost
Hi All Strange issue. We had a unit of stock receipted at the wrong cost. I have changed the cost on the PO and the related Goods Receipt Note. The Value and Last Purchase Prices have all updated, however the Average Cost still has the higher price even though we only have 1 of these On Hand which was receipted at the…
-
When I make a Vendor Return, does the Item Fulfillment transaction change my Item Average Cost?
Hi community. We have a PO with the same item in two lines. The first time the item was Received with a Unit Rate of 2.3 and the second time the Unit Rate was 46. This is affecting my item average cost and my stock valuation. This was a mistake in operations and to reconcile the A/P we created a Vendor Return Authorization…
-
Update of Average Cost on Work Order Completions/Build/Close
Hi All, I am currently setting up NetSuite for a client who is using WIP. We have loaded assembly items, however NetSuite does not allow you to upload the average cost therefore we have left this at Zero. When we are doing Routing Completions and subsequent marking the Work Order Built and Closed we expect to see the…
-
AE: Transfer order is not picking up the correct price
Dear Gurus, We have one customer, and they are using transfer order module to transfer inventory from one location to another. But when they are doing the transfer it does not pick up the correct cost and there is always a difference in the purchase price and transfer price in decimal value. This gives them the wrong…
-
AE: Average Price is missing from many items for one of our customer
Dear Gurus, One of our customer is having a blank average cost for the multiple items even though this items are having the purchase. Can you please help us out how can we fix the issue that provides correct average price. For your reference, ii have attached the item list showing blank average price. It will be a great…
-
Inventory Worksheet Tutorial
Is there a how to video or posting detailing how to create a new Inventory Worksheet? I have several items that are incorrectly costed and this seems to be the only way to reset costings.
-
Correcting purchase order receipts at the wrong value
I am requesting information about the best practice for handling a receiving scenario in NetSuite. We use a handheld to receive inventory off purchase orders. When receiving with the handheld, there is no way to see the cost of the item that is received; it is simply received at the amount on the purchase order. We have…