Item Availability

Horse06
Horse06 Member Posts: 496
edited 2009-05-29 in NAV/Navision Classic Client
I found a problem in the item availability of the sales order form. The Error trigger form is based on this number on the availability. I checked all the quantity of all the locations, purse line, but the numbers are not correct on some of our items. From the testing, the formula for availability is quantity on hand + purchase line - qty on the sales order. Any good advice? Appreciate it!

Comments

  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    It checks this value only IF NewItemNetChange >= 0 which means if after filling this order ur net change is < 0 then only u will get this warning. Now what net change is

    Per : Location, Variant, Bin) [Item Qty on hand + Purchase Receipt (in line to your shipment date, means planned purchase receipt date should be before your planned shipment date)] - [Qty on Sales Order (includes old reservation if there are any) + Reserved outbound transfer order lines + Reserved Qty against a production line (if item is component as well and meant for consumption) ].

    Just check if u have reserved qty on any outbound transfer lines that may be reason for u getting this message even after having inventory.
    Kapil Khanna
  • Horse06
    Horse06 Member Posts: 496
    Could you please let me know what reserved qty on any outbound transfer lines. Appreciate it!
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    This means u have filled in some lines on Transfer order and have reserved them. This is something u do before posting your shipment (Transfer Order).

    Means u know u will be shipping the material on e.g. 05/16/2009 and u fill in the data today i.e. 05/14/2009 and u don't want that particular quantity to be used anywhere else (for example: that shudn't be sold) so after filling in the data u will reserve the line on Transfer Order. So when u will create Sales Order and if u have reserved outbound transfer order line system will show u this message even when u know, u have inventory somewhere visible in database.

    But it all considers what qty u have reserved if u have 10 on sales order and "on hand" 20 and reserved is 10 (on outbound transfer lines) then u wont get this message.
    Kapil Khanna
  • Horse06
    Horse06 Member Posts: 496
    Where does the schedule receipt for the check avaialabilty error trigger form come from? I found for some of our items, the numbers are not correct, sometimes we are out of stock, the error form does not pop up , but sometimes, we have stock, the error form pops up. I checked all the numbers from all the locations in our database and cannot find the numbers mentioned in the avalilability. Could you let me know where I can find the numbers? Appreciate it and thank you for your time!
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    Sorry for the delayed reply.

    Ur scheduled receipt date comes when u have items lying on purchase orders. And this is based on quantity on purchase order when the "Expected Receipt Date" is earlier than "Expected Shipment Date" of sales order.
    Kapil Khanna
  • Horse06
    Horse06 Member Posts: 496
    Our problem is there is no message when we are out of inventory. I read your lines, but the message does not show up. Please help!
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    Make sure that "Stockout Warning" is checked in Sales and Receivables setup menu. If this is checked and if ur onhand inventory is not able to satisfy the quantity required by sales order system will give u the message.
    Kapil Khanna
  • Horse06
    Horse06 Member Posts: 496
    Actually the message has been setup already. But the problem is the number of the availability changing all the time. e.g. We have an item which has negative 200 in stock, but when we see the availability of this item from different open sales order, the availability number is different. When we place a new sales order, the availability is even 1000. I went deep inside from the location of this item and found none of open sales order of this item has been deducted from the inventory, which keeps the original number of 1000. So only when we entered 1001, the warning message popped up. Please help! Thanks!
  • kapil4dynamics
    kapil4dynamics Member Posts: 591
    We have an item which has negative 200 in stock, but when we see the availability of this item from different open sales order, the availability number is different

    It can be show available on any location if Quantity on Hand is -200(on Item Card) sorry i can't be believe the later part (Quoted Below).
    But it can be -ve for one location and have available on another location for same item.
    When we place a new sales order, the availability is even 1000. I went deep inside from the location of this item and found none of open sales order of this item has been deducted from the inventory, which keeps the original number of 1000. So only when we entered 1001, the warning message popped up. Please help! Thanks

    I hope u have posted the shipment , because just creating a Sales Order will not deduct it from inventory. But if u keep all ur qty (available on hand per location ) on sales order e.g. on one sales order 1000 and put even 1 in next sales order u will get this error.

    But i am answering u keeping standard NAV in mind i hope u don't have any customization.
    Kapil Khanna

Categories