Item Availability only from Item Ledger Entry

selece28selece28 Member Posts: 316
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
______________

Regards,
Steven

Answers

  • JoeriJoeri Member Posts: 75
    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.
  • selece28selece28 Member Posts: 316
    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
    ______________

    Regards,
    Steven
  • idiotidiot Member Posts: 651
    Create another flowfield calculating the sum from the Item Ledger Entry
    NAV - Norton Anti Virus

    ERP Consultant (not just Navision) & Navision challenger
  • selece28selece28 Member Posts: 316
    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
    ______________

    Regards,
    Steven
  • David_SingletonDavid_Singleton Member Posts: 5,479
    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.
    David Singleton
  • selece28selece28 Member Posts: 316
    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.
    ______________

    Regards,
    Steven
  • Alex_ChowAlex_Chow Member Posts: 5,063
    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.
  • selece28selece28 Member Posts: 316
    correct, i agree with you.
    Thanks for the suggestion, i will discuss with them again how they want it.

    Thank You All
    ______________

    Regards,
    Steven
Sign In or Register to comment.