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
Hi Shabir,
Those Batch orders are not Ended. They have Status = Report as Finished.
Hi Guy Terry,
Batch orders are ended check in the screen and the item model group is weighted avg.
Thanks and Regards,
Shabir Ahmad.
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.
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
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
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.
QianQW,
Please check the transaction image for the item 100019 row with non quantity.
Best Regards,
Shabir Ahmad
Hi Shabir,
Please show me the transaction for the marked line.
Regards,
QianQW
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156