You’re offline. This is a read only version of the page.
35
Hi,
I was reviewing the possible use of the standard jobs module for a specific case (NAV2015).
When creating a purchase order for an item with setup inventory value zero = true, you will see the outstanding order amount on project level.
Next, when you post the purchase order for receipt, the amount will move to the received not invoiced section on the job task view. So far so good.
Then, when you invoice this purchase, a job ledger gets created, but with cost 0. So the cost for this purchase will eventually be zero on the project, which is not the desired outcome.
This doesn't seem logic to me. Does anyone ran into the same problem or knows how to solve/interpret this?
Thanks in advance.
Bjorn
Bjorn,
When you posted the Purchase Invoice, did you have on the Purchase Line for the Item a Job No., Job Task No., Job Line Type, Job PLanning Line No.? These field link the PO to the Job. Without these fields no Job Ledger Entry will take place. Try using a Sandbox to recreate there and make sure these fields are populated and see what happens after you Post Invoice.
Thanks,
Steve
Hi Steve,
Thanks already for the answer.
I would expect that the inventory value zero would translate into having no stock value indeed when having such items in stock, which is the case.
But apart from that, when the purchase invoice is posted you do get a cost in your P&L, so why shouldn't it assign that cost to the job ledger when you post it with job no. & job task no.
It's not that the inventory value is zero that no cost should get assigned to the job ledger from that point of view.
We can set it up as inventory value zero = yes, but we don't want to have inventory values assigned to this item in case the item is not related to a job.
To give more information about the specific case, it's an item which actually relates to services and therefore is set up with inventory value zero. (In NAV2015 unfortunately the item type 'service' is not present yet).
Bjorn,
The Inventory Value Zero field on the Item Card allows you to have items with no inventory values, this is useful if you managing inventory on the behalf of someone else or if you want to keep track of material that you have expensed (like packaging materials, etc..).
An Item setup like this can be transacted like any other item in Dynamics NAV, except it can not be produced. If you try to enter a production order with an item flagged as ‘Inventory Value Zero’ you will get an error message saying ‘Inventory Value must be equal to ‘No’ in Item: XXXX’ when you refresh the production order. When purchasing an item flagged as ‘Inventory Value Zero’ you will not get any inventory related transactions in the G/L, only the Purchase transaction in the P&L and the AP transaction in the BS.
I think in your case why do did you set the flag if you expect the Purchase Invoice cost to appear on the Job Ledger? I think you might have mistaken the field and need to uncheck the box.
Thanks,
Steve
#1
Sohail Ahmed
2,655
#2
Mansi Soni
1,574
#3
YUN ZHU
1,453
Super User 2025 Season 1
Share
Report
All responses (
Answers (
