Item Availability only from Item Ledger Entry

selece28

Hi Nav Masters,

I have a question regarding item availability on Sales Order.
Lets say i have inventory Item A in my warehouse = 10
Then i create a PO for Item A for 5 with expected receipt date is today, i just create without posting anything.

Then i check in my SO the availability is 15 if my planned shipment date is bigger than my expected receipt date on my PO

My question is why is my availability is 15 instead of 10?
The thing is my inventory is should be 10 because i haven't posted receive the PO

Can i change so my availability always get the REAL item ledger entry?
I mean i only get all items in that exist in item ledger entry?

Can anyone suggest me another way to do it?

Thanks in advance,
Hendra

Joeri

This is because NAV keeps track of your orders. If you have a purchase order, but haven't received anything yet, you still have an expected receipt date. That means, it is expected you have +5 items on that date, so your expected inventory is 15 (on that date).

If you're on a sales order, and on the line with Item A you'll see on the right side your Item Information. When you push on the link "Availability" you'll see how NAV calculates it.

selece28

Yes i know about this.
Is there anyway to setup so that it only calculates the item that is already in my warehouse physically, in other words, i already receive it.

I think i have to make some customization on this. Any suggestion?

Thanks

idiot

Create another flowfield calculating the sum from the Item Ledger Entry

selece28

Hi,
i think i can't do that, coz it needs to handle the availability qty when creating SO or TO.
So i decided to modify Codeunit 5790 in function CalcScheduledReceipt.
I make the return value to exclude "Qty. on PO"

Is it ok to mod like that? Is it gonna effect anything?

Any idea?

Thanks

David_Singleton

selece28 wrote:

Hi,
i think i can't do that, coz it needs to handle the availability qty when creating SO or TO.
So i decided to modify Codeunit 5790 in function CalcScheduledReceipt.
I make the return value to exclude "Qty. on PO"

Is it ok to mod like that? Is it gonna effect anything?

Any idea?

Thanks

This will totally mess up planning, so you absolutely should not do this. Instead create a new function.

selece28

What if my client don't use item planning?
Can i still do that?
I just modify so that the availability on SO didn't include Qty on PO. because the business process of my client is they only want the item agreed as inventory is the item that they have received.

Alex_Chow

Yes you can. But your client has the liberty to use the planning function in Navision in the future without asking to make any changes.

To avoid problems, create a new quantity field based on what your customer is expecting and properly train them on how Navision is working out of the box.

selece28

correct, i agree with you.
Thanks for the suggestion, i will discuss with them again how they want it.

Thank You All