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 :
Microsoft Dynamics AX (Archived)

On Hand Report

(0) ShareShare
ReportReport
Posted on by 997

Hi all,

I want to know meaning of columns in On hand Reports (Physical reserved, available physical..)

Who can help me.

path (inventory management > inquiries > On-hands)

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at
    RE: On Hand Report

    hi

    the physical reserverd means that it is ordered and on the other hand available physical means that it is available but not dispatch.

    i hope you got it?

    Hassan

  • Suggested answer
    Prashant Singh Profile Picture
    8,802 on at
    RE: On Hand Report

    To understand it better

    1. Physical reserved : Reserved against sales or transfer order

    2. Available Physical : Physically available for  ales or transfer order

    blog.mohamedaamer.com/.../inventory-management-inventory-descriptions

  • Cam Phung Profile Picture
    997 on at
    RE: On Hand Report

    Prashant Kumar.

    Thank you. I also find answer the same as link you give me. community.dynamics.com/.../inventory-management-inventory-descriptions

    But I confuse something. Can you explain to me

    1. Ordered in total

    2. Ordered reserved

    3. On order in total

  • Suggested answer
    syed baber Profile Picture
    11,633 on at
    RE: On Hand Report

    Hi Phung,

    Below are the answers:

    1. Ordered in total: Total quantities you ordered through a purchase order. Haven't received yet.

    2. Ordered reserved: Total quantities reserved from purchase orders using Inventory -> reservation option on PO line level. Haven't received yet.

    3. On order in total : Total quantities in open Sales order. Means that you have created Sales order with 'x' amount of quantity, but it is not yet delivered to the customer or the delivery note has not been posted for those items.

    Please let me know if you have further queries.

    Thanks,

    Baber.

  • Verified answer
    Prashant Singh Profile Picture
    8,802 on at
    RE: On Hand Report

    1. Ordered in total : Qty in total ordered or arrived

    All purchase order item ordered or arrived on your dock and All transfer order qty not received to another warehouse.

    2. Ordered reserved : Qty reserved on qty ordered.

    All qty reserved against any sales order or transfer order (manually or automatic)

    3. On order in total: Summarized qty from all  that is ordered.

    Lets take a scenario to understand it in better way:

    Suppose we have a transfer order of qty 10

    Warehouse 11   from

    Warehouse 12   To

    So

    You will find for warehouse 11

    On order    10 from   and On order in total 10

    And for warehouse 12

    Ordered in total 10 and Available for reservation 10

    Same thing will applied in case of sales and purchase also. Its just a matter to understand the issue from and receipt transaction.

  • Verified answer
    Cam Phung Profile Picture
    997 on at
    RE: On Hand Report

    Hassan. Thank you very much. I got it :D.

  • Cam Phung Profile Picture
    997 on at
    RE: On Hand Report

    Baber.

    1. Ordered in total. I think it also include quantities you movement or transfer (gain) but not posted.

    2. On order in total. I think it also include quantities you movement or transfer (loss) but not posted.

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

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans