web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Closed and closedQty i...
Microsoft Dynamics AX (Archived)

Closed and closedQty in inventsum table

(0) ShareShare
ReportReport
Posted on by kongyu 420

 Hi,

I would like to ask, do anyone know what AX mean for the  Closed and closedQty in inventsum table?

When Ax will update it?

If a record show Closed = no and CloseQty = Yes, this mean what?

 

Pls advice. Thanks very much.

Regards,

kongyu

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: Closed and closedQty in inventsum table

    Thanks both for the valuable answers.  Now its more clear.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: Closed and closedQty in inventsum table

    Hi,

    ClosesQty is true if all qty fields are zero.

    The qty fields are shown in InventSum.isAllQtyFieldsZero() method:

    public boolean isAllQtyFieldsZero()

    {

       return (this.PostedQty          == 0  &&

               this.Deducted           == 0  &&

               this.Picked             == 0  &&

               this.Received           == 0  &&

               this.Registered         == 0  &&

               this.ReservPhysical     == 0  &&

               this.ReservOrdered      == 0  &&

               this.OnOrder            == 0  &&

               this.Arrived            == 0  &&

               this.Ordered            == 0  &&

               this.QuotationReceipt   == 0  &&

               this.QuotationIssue     == 0 );

    }

    Closed is true if ClosesQty is true and all value fields are zero.

    The value fields are shown in InventSum.isAllValueFieldsZero() method:

    public boolean isAllValueFieldsZero()

    {

       return (this.PostedValue        == 0  &&

               this.PhysicalValue      == 0);

    }

    Regards, Dirk

  • Community Member Profile Picture
    Community Member on at
    RE: Closed and closedQty in inventsum table

    Hello Fedotenko,

    Could you please explain that what do you mean by all quantities. If you mentioned quantity fileds name so it will be very helpful for me. Thanks.

  • Community Member Profile Picture
    Community Member on at
    Re: Closed and closedQty in inventsum table
    Hi ! The closedQty flag informs that all quantities for given inventory item and inventory dimension set to zero. No item in stock, no item in process of receiving/shipping, also item is not expected to be sold/purchased/produced. The closed flag informs that the monetary balance for given item and inventory dimension is zero. Basically it means that all the costs related to given item was written-of from inventory account to COGS/WIP etc. Usually, the closed flag is set by inventory closing. (But in simple cases it can be set immediately during posting of inventory issue). Regards, Denis

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans