Received Items on Purchase Orders

seanl

HI there

I have a question with regards to Receiving Items on a purchase order.
I will use the following example:

Details on a single Purchase Order line:
Type = Item
No = Item currently setup
QTY = 1
Line amount = 100

I then receive the item but not invoice. The item then enters into the Item Ledger Entry where the Cost Amount (Actual) shows zero.

I then sell the item via the Item Journal applying the sale to the original item purchased. (This Item journal is created automatically using a report where I get the details from the original item purchased), therefore the Unit Amount and Amount fields within the Item Journal Line are zero)

If I then go back to the Purchase Order, and update the Line Amount due to Vendor Cost changes and Invoice it, the cost updates to the original Item Purchased within the Item Ledger Entry, but not the Sale.

How does Navision handle this with regards to the cost of sale?

Any ideas on how I can get the cost to fill in on the Item Ledger Entry without creating a new value entry. Does the Adjust Cost - Item Entries batch complete this for me?

golfer

Yes the batch-job will do the trick for you. However there has been a lot of issues concerning this and it depends on which version you´re on. Make sure you have the latest hotfixes installed.

seanl

Many thanks for that, I have tested this and yes found out that there were quite a few bugs of which I had to fix using some updated Hotfixes.

The version that we are using is 3.6.