Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Valarie Wiles]

It was recently discovered the our remaining quantity column in the item ledger entry table reflects mostly 0’s for all items with the exception of items received on a Purchase order.  Where do I look into why this column is not calculating the correct item quantity.  

Note, when I look at the applied entries  for a particular transaction in the item ledger entry table, I see the quantity and remaining quantity reflect a value.  It’s just not showing up in the item ledger entry list. 

Thanks.

——————————
Valarie Wiles

——————————

[Jamie Constantine]

what version are you working in.   what type of entry (purchase, sale, adjustment, etc)  has a zero remaining qty?  can you take a screen shot?   the remaining qty is a flow field from the value entries (applied entries).  It is calculated because you sold a purchsae product or adjusted in through a journal.

——————————
Jamie Constantine
Senior Consultant
Columbus Global
——————————
——————————————-

[Valarie Wiles]

NAV 2018.  It looks like it’s consumption and sale entries that are all 0.

——————————
Valarie Wiles
Goodwill Southeast Georgia
Savannah GA
——————————
——————————————-

[Andrew Good]

You are seeing expected behavior. That is, after a Sales or Consumption transaction is completed there is not Remaining Quantity since inventory is no longer available (it has been consumed into production or shipped out). 

You will see Remaining Quantity for transactions that bring inventory in to NAV (e.g. Purchase Receipt, Positive Adjustment, Sales Return Order, Production Output, Transfer Order Receipt) if the inventory has not been used up.

——————————
Andrew Good
President
Liberty Grove Software
Oakbrook Terrace IL
——————————
——————————————-

[David Wiser]

As Andrew stated, this is normal functionality.  Remaining Inventory is usually shown for “inbound” item entries (e.g. purchases, production output, etc.)  When “outbound” item entries are posted (e.g. sales, consumption, etc.), BC/NAV will automatically apply these outbound transactions to inbound entries, usually on a FIFO basis (unless applied to a specific inbound entry).  The Application Worksheet can be used to help correct applications if done improperly.  Therefore, the remaining quantity for outbound entries is usually zero, while the remaining quantity for inbounds entries will have a balance until the quantity on that line is fully applied to outbound entries.  Hope this helps.

——————————
David Wiser
Sr. Solution Consultant
Tigunia
2019-2020 Board of Advisors
BCUG|NAVUG All-Star
——————————
——————————————-