Microsoft Dynamics GP (Archived)

Quantity on hand & quantity available

(0) Share

Report

Posted on by Community Member

Guyz can anyone tell me why is it so ?? why both the quantities are different

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Community Member on at

Like (0)

Report

this is happen when some Qty is already allocated to site.

To check where that Qty is allocated then follow the following path and click on allocate

Inventory>Inquiry>item

Thanks

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Quantity Available = Quantity On Hand - (Quantity Allocated + Quantity Committed)

Hope that helps.

Was this reply helpful? Yes No
Suggested answer

Romryan on at

Like (0)

Report

Rabia,

Quantity Available=Quantity on hand-Quantity Allocated- Quantity Committed.

When you enter an inventory transaction sales,receipt,adjustment,transfer,variance etc and you leave them unposted. The quantity in batches will show as allocated until its posted and therefore the quantities available will be the quantity on hand minus that quantity that's being allocated.

RomRyan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Would some expert be able to explain the difference or relationship between quantity-on-hand and transaction quantity?

Thanks. email Lance55@digis.net

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (1)

Report

Quantity on Hand is what is physically sitting on your shelf. Now you can have orders for those quantities but those orders have not yet shipped and the goods have not yet been pulled off the shelves. Now the transaction quantity would be what is on the sales or purchase order. So if you 100 deluxe widgets sitting on your shelf with sales orders for 25 you still have 100 deluxe widget sitting on your shelf until you invoice those 25. In this case the allocated quantity is 25 and you quantity available would be 75. Your quantity on hand is still 100.

Qty on Hand     Qty Allocated   Qty Available

100                     25                         75              these are the quantities before invoicing

75                       0                           75              these are the quantities after invoicing

So you can see the net qty available remains the same but the qty on hand goes down by 25 as does the qty allocated because once you invoice they are pulled from the shelves.

Was this reply helpful? Yes No