Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

how to hide row with blank Quantity on On-Hand form

Posted on by 3,024

On_2D00_Hand-Form.png

Dear Experts,

I have an issue here on On-hand form, here in our warehouse quantity from the same batch\control number is in two warehouses namely, warehouse 101 and 102. Now the quantity in 102 is available but 101 is blank, can i hide 101(blank warehouse). I mean to say the form will show only the warehouse which will have quantity. Please check in above image.

Thanks and Regards,

Shabir Ahmad

  • Guy Terry Profile Picture
    Guy Terry 28,604 Super User 2024 Season 2 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Hi Shabir,

    Those Batch orders are not Ended. They have Status = Report as Finished.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: how to hide row with blank Quantity on On-Hand form

    B_2D00_001946.pngB_2D00_002040.pngB_2D00_002044.pngweighted-avg.pngB_2D00_002043.png

    Hi Guy Terry,

    Batch orders are ended check in the screen and the item model group is weighted avg.

    Thanks and Regards,

    Shabir Ahmad.

  • Guy Terry Profile Picture
    Guy Terry 28,604 Super User 2024 Season 2 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Hi Shabir,

    Regarding the screenshots for your 100019 item. How is this item costed (i.e. what is the Inventory model on the Item's Item model group?)?

    Are you saying that you have run Inventory close, and the On-hand clean-up jobs? You have some Production orders which are not Ended (on your transactions screen they are the Deducted lines). I would not expect Inventory close / Clean-up to be able to tidy lines related to production orders which are not Ended, and Purchase/Sales orders which are not Invoiced.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Quantityhide.pngTransactionfor101.png

    Hi Guy Terry,

    Please check the images i did as you suggest, still, blank warehouse with zero quantity is showing blank.  Further, we are already using the inventory management module and warehouse management module will not be run on the same time with the inventory management module

    Best Regards,

    Shabir Ahmad

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: how to hide row with blank Quantity on On-Hand form

    on-handtab1.pngon-handtab2.pngTransactionforblankQuantity.png

    Hi All,

    check the above on hand tab on On-Hand form for blank quantity and with quantity as well as transaction form for blank quantity..

    Best Regards,

    Shabir Ahmad

  • Guy Terry Profile Picture
    Guy Terry 28,604 Super User 2024 Season 2 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Hi Shabir,

    Use Dimensions display. Make sure Closed transactions is un-ticked. Make sure Quantity <> 0 is ticked.

    I suggest this is all you try to do to hide lines where there is no quantity. It will not hide them all, but it may hide some.

    Select the line which has no quantity. Click on the On-hand tab. You will probably see that, although the Quantities are empty, there is a Physical cost amount or Financial cost amount. This is the reason the line exists. Explain this to your users; explain that the reason that they see it is a boring technical reason related to inventory costing. Tell them that you can tidy them so they don't get out of hand, but you can't stop them from appearing completely.

    You should be using the Inventory close function, probably every month. Make sure you do this. Also consider testing the On-hand cleanup jobs. I find different one's are useful, depending on which costing method (inventory model) you are using, and whether you have enabled the Warehouse management module. You'll find them at Inventory management -> Periodic -> Clean up. Any of the one's with 'on-hand' in the name might be useful. Try them in a test environment first. I normally set them to run once a week, at the weekend. If you do these things, AX will tidy these zero quantity lines. In my view, this and education is the best solution.

    Finally, if you are fighting a losing battle with your users, and if you have AX 2012 R3, try Warehouse management -> Inquiries -> Physical on-hand inventory. It never shows zero quantity lines.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: how to hide row with blank Quantity on On-Hand form

    item100019hide.png

    QianQW,

    Please check the transaction image for the item 100019 row with non quantity.

    Best Regards,

    Shabir Ahmad

  • qianwang Profile Picture
    qianwang 7,151 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Hi Shabir,

    Please show me the transaction for the marked line.

    4111.png

    Regards,

    QianQW

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,024 on at
    RE: how to hide row with blank Quantity on On-Hand form

    Dr. Ludwig Reinhard,

    No, i want to hide the row, for that warehouse which will be zero for any item. in above image 2 rows are there 1 for warehouse 101 and second for again warehouse 101 blank (zero ) quantity warehouse 101 should be hide.

    Thanks and Regards,

    Shabir Ahmad.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: how to hide row with blank Quantity on On-Hand form

    Hello habir Ahmad,

    What you are interested is the code that automatically hides the columns people don't want to see when they open this form.

    Is that right?

    Best regards,

    Ludwig

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,902 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,297 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans