Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Adjust Inv Wksht, Devalue Inv.
Ok, so when I have an item that i need to devaluate, i would normally use the Inv Adjustment WKSHT and enter the same qty as what I have on hand, but change the total value.
The problem I'm having is, it's adjusting the qty's of Purchases that haven't been received yet.
for example, I have item x. AS of 12/18/06 I have 50 On hand at $2 a unit.
on 12/19/06 I enter that we have a purchase coming in for 500 units of item X with a ETA of 1/19. I don't receive this or bill this.
When I go to adjust the inventory/cost, it shows me what I have on hand, which is 50 units. So I enter 50 Units at the new value 50$. The value of those 50 units is now 1$ a piece.
0