Availability Total GI

Yes, you can use the INSiteStatus table to separate out the availability of items by transaction type. You will need to identify what columns match their availability formula.

Hi ​@aminerd ,

You can see these details on the Qty by Plan Type tab of the Inventory Allocations Details screen.

Hope this helps!

Laura

Hi ​@lauraj46, thank you for the reply! I looked on the Inventory Allocations Detail screen as you had mentioned and am still not sure this will work for the user. Here is the information from that screen:

But when I look at the Inventory Summary for this item, the availability quantity does not align with this information. Here is the Inventory Summary Screen:

Is there anything else that could explain this number? 

aminerd wrote:

Hi ​@lauraj46, thank you for the reply! I looked on the Inventory Allocations Detail screen as you had mentioned and am still not sure this will work for the user. Here is the information from that screen:

But when I look at the Inventory Summary for this item, the availability quantity does not align with this information. Here is the Inventory Summary Screen:

Is there anything else that could explain this number? 

Qty available is...

= [qty on hand] - [All deductions included] + [all additions included]

= qty on hand - so booked - so allocated - so shipped - so back ordered - in issues - kit assembly demand + purchase prepared + purchase orders + po receipts + in receipts

Qty available is defined on the availability calculation rules screen

Hi ​@aminerd ,

If you have recently changed the availability calculation rule, you should use the ‘Recalculate Inventory’ screen to update the Available quantity.  

Hope this helps.

Laura

​@lauraj46 Thank you! I actually ran this a few minutes before your reply and wanted to ask what other possible explanations there could be for this inconsistency? We are not aware of any changes made by the user for the availability calculation since it had been originally set. Are there other instances you are aware of that could have an effect on this total?

Thank you for your help ​@lauraj46 and ​@bwhite49!!

If you double click on the “UNASSIGNED” on the inventory summary screen, it will bring you to the correct allocation screen. It’s hard to know what is going on with that inventory ID and why it’s not showing you the correct info for that item from screenshots.

This has been an issue forever.  Sometimes the inventory summary gets out of whack with the Allocations details and usually the recalc inventory balances fixes it and sometimes it does not. In most cases the Allocations details are correct and the summary is wrong but I have had cases where invoiced sales orders still appear in the allocations and show as demand in MRP.  The issue cascades when you have lot/serial tracked items or project tracked inventory.  It has been suggested the issue is caused by return transactions; returns to vendor, customer returns, and/or production returns updating the summary or changing a warehouse location to check/uncheck include in available.

The allocation records are in INItemPlan.  Join to INPlanType to get the description.

​@dgodsill97 Thank you for this clarification. I will pass this information along to the user, as hopefully it provides some explanation for this issue. Other than creating a GI - have you found an effect way to keep up the correct amounts or is this something that needs to be checked/monitored by the user often? 

Not really, the potential inaccuracy of the Inventory Summary is why the Allocation Details is now used in sales orders.  We have also have had ISV’s mess it up where they do an inventory transfer from one bin to another. I wrote a help article a few years back to explain the manufacturing allocation and I had to dig around the other allocation types during the testing to make sure both the Inventory Summary and Allocation Details were updated correctly.  Most allocations are updated as soon as you change the status of the sales, purchasing, and/or production documents.