[Holly Kutil]

We are running NAV 15 and also have Auto Adjust turned on.

We purchased parts, sold some of the parts, received a discount of 20% after the fact, if we do a purchase credit for the 20% and revalue the parts to the lower correct price will it adjust the cost of all the parts on the purchase order both sold and still in inventory? If not then how do we adjust the parts correctly?

——————————
Holly Kutil
American Ring/NAV Admin
Solon, OH 44139
**Great Lakes Chapter**
?? Women In Dynamics ??
——————————

[David Wiser]

If you code your discount to the G/L and do a revaluation journal, it will only revalue the inventory on hand at the time and not the inventory sold.  The best option is to post the credit memo using the Charge(Item) option and assign the line to the inbound product.  Adjust cost will then pick up this adjustment and automatically revalue the inventory and push the adjustment for the sold item through to the value entry table (which updates the item ledger entry).  Be aware that this will NOT impact the unit cost amount on the posted sales invoice tables.  Reply back if you need help setting up the Item Charges.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Marguerite Manelski]

We did the revaluation and it worked but how to we correct the unit cost on the sale of those parts.

——————————
Marguerite Manelski
Junior Purchasing Agent
American Ring
Solon OH
——————————
——————————————-

[Joe Shields]

Hi Marguerite,

Did you select the applies to entry of the receipt you wanted to revalue when you did your revaluation? This is required for NAV to update the costs on items that have been sold and invoiced.

——————————
Joe Shields
Advanced Media Technologies
——————————
——————————————-

[Crystal Tollison]

In addition to Dave’s suggestion of using Item Charges, or you can use the Revaluation Journal.  The Reval Journal has two options when selecting the date on which your revaluation is done. You can  select the original receipt entry of the item ( Applies-to Entry field) which will use that date in the journal or you can use the Calculation step which will use today’s date and only revalue the current remaining quantity.

If you select the Original positive entry (Purchase, Output, etc.) it will also post revised cost values for anything sold or consumed since the original date however, the entry will be posted on that original receipt date.  This means if that accounting period is not still open, you may only want to adjust the cost for the remaining quantity.

——————————
Crystal Tollison
Consultant
ArcherPoint Inc.
Lawrenceville GA
——————————
——————————————-

[Joe Shields]

Hi Holly,

Since you want to cost of items that have already been sold the invoices posted to be adjusted, Crystal’s suggestion of using the revaluation journal is the way to go.

I can confirm that when you select the applies to entry of the receipt for the items you want to revalue, after you post the revaluation NAV will change the cost on the inventory still in stock and also that has been sold.

You can look at the posted invoice statistics after doing the reval to confirm:

Or in the Value Entries Table:

——————————
Joe Shields
Advanced Media Technologies
——————————
——————————————-

[Holly Kutil]

Thank you everyone for the great input and help.  We were able to complete this task on our own with your assistance!

It takes a tribe!  Thanks for being our tribe!

——————————
Holly Kutil
American Ring/NAV Admin
Solon, OH 44139
**Great Lakes Chapter**
?? Women In Dynamics ??
——————————
——————————————-