Friday, November 6, 2009

Using the Adjust Costs inventory Utility

Adjust Costs.

It looks like a simple enough tool and it does exactly what you tell it to do. However, read on, what it does may not be exactly what you want it to do. Here's what it does. Say you have a purchase receipt that went through the system at $1465. Several of the items were sold but now the inventory is obsolete and the powers that be task you to write it off. They still want the items in inventory in case they can sell them later, but the carrying value should be zero. No Prob! you say. You open up the adjust cost screen and take each of the receipts that have not been completely sod and adjust the cost to zero. A bunch of reports print, you check that your stock status shows zero and you think you are done.

Not so fast. When you make a cost adjustment to a receipt in the Adjust Cost window you are telling the system that the entire receipt had a bad cost, not just the items left over. Dynamics GP will go back and attempt to adjust the cost on the posted sales from this receipt to the new cost (in our case $0). You may not want that. If all you are trying to do is write the current inventory down to zero cost, make Inventory Transaction Entries. First, a negative entry which will pull the correct cost. This will give you your 'write off' journal entry. Next do an increase adjustment at $0.00 cost. Now you have written off exactly the inventory you want and the carrying value is zero.

You can go home fulfilled from a good writeoff :)

Until Next Post

Leslie

3 comments:

Gijeet said...

Hello, very informative post. Can you please go into more detail regarding creating a negative entry first then an increase adj. Let's say I have 365 items I want to write off. Thanks.

Gijeet said...

Hello, very informative post. Can you please go into more detail regarding creating a negative entry first then an increase adj. Let's say I have 365 items I want to write off. Thanks.

Dynamics Confessor said...

Gijeet,
To make the negative entry, simply open the item transaction entry window and then put a negative amount for the quantity. The system will pull the items actual cost according to your FIFO layers and reduce your inventory by that amount.
You then create a positive adjustment and enter the qty with whatever cost you want.
If you need to write off a bunch of items at once, the easiest way to do it is with a Stock Count Entry. Put the items in a stock count schedule, and then start the count. Go into stock count entry and then check all of the verify boxes with the qty of zero. The system will create an item transaction bringing the qty and cost to zero. You can then create a positive inventory adjustment to bring the quantity and cost up to the appropriate level.
If you have the correct cost in the current cost field on the item card, then you can just do another stock count with the new quantity.
I find that using the stock count schedules make this process much easier.
Hope this clears things up for you.
Kind regards,
Leslie