Microsoft Dynamics Support Forum Index Microsoft Dynamics Support
Visit the Microsoft Dynamics newsgroups and exchange ideas with a community of business professionals and product experts from around the globe.
 
   ProfileProfile   Log in to check your private messagesLog in to check your private messages  |  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups Log inLog in   RegisterRegister 

What does the PhysicalInvent column in InventSum represent

 
Post new topic   Reply to topic    Microsoft Dynamics Support Forum Index -> Microsoft Dynamics AX Database
Author Message
Vusi
Guest
PostPosted: Mon Apr 14, 2008 8:01 pm    Post subject: What does the PhysicalInvent column in InventSum represent Reply with quote
Hello everyone,
Please could someone explain what the physicalinvent coulmn in the inventsum
table "mean"?

Does this column represent the following formula:
PhysicalInvent = PostedQty + Received - Deducted + Registered - Picked.

Thanks
Back to top
Khue Trinh
Guest
PostPosted: Sat Apr 19, 2008 1:02 pm    Post subject: RE: What does the PhysicalInvent column in InventSum represe Reply with quote
Hi,

If you can open Item Master and On-hand form, it will give you the answer.
Thanks.
--
Khue Trinh


"Vusi" wrote:

Quote:
Hello everyone,
Please could someone explain what the physicalinvent coulmn in the inventsum
table "mean"?

Does this column represent the following formula:
PhysicalInvent = PostedQty + Received - Deducted + Registered - Picked.

Thanks
Back to top
Necmi GÖCEK
Guest
PostPosted: Thu May 01, 2008 1:07 pm    Post subject: Re: What does the PhysicalInvent column in InventSum represe Reply with quote
Hi,

Your formula is right. I just want to add the difference between
PhysicalInvent and AvailPhysical fields on InventSum table.
PhysicalInvent = PostedQty + Received - Deducted + Registered - Picked
AvailPhysical = PhysicalInvent - reservPhysical
Back to top


Display posts from previous:   
Post new topic   Reply to topic    Microsoft Dynamics Support Forum Index -> Microsoft Dynamics AX Database All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
eXTReMe Tracker