Announcements
No record found.
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, Have you tried using a grid filter (CTRL+G) and used something like
!""
or
!0
Best regards,
Ludwig
Hi Shabir,
Please ensure all transactions for this item in warehouse 101 are financially settled (having a financial date in the line). For example, sales orders need to be invoiced, purchase orders need to be invoiced/paid. And production orders need to be ended. You can open transaction history to check it.
Regards,
QianQW
Dr. Ludwig Reinhard,
Thanks for your reply, i want logic or code where if "Total Available" Qty is zero(Blank) in any warehouse and Batch Number are the same. As in this case, we have one batch number 6RM00879 and warehouse are two 101 and102. Both the warehouse are showing 101 and 102 in this case but 101 is blank and i don't want to show that bank 101 warehouse as shown in the image. So i think it would be possible to write some code to the Total Available (Quantity)field. Or write a new method which will hide all warehouses which don't have quantity...
Best Regards,
QianQW ,
,
Thanks for your suggestion, why you want to be closed all transaction for this item, well, you elaborate, please?? Because i need to hide 101 warehouses because it doesn't have inventory and making confusing because the Batch number for warehouse 101 and warehouse 102 is same 6RM00879
?The blank lines are an indication that there are transactions that aren't financially settled. I don't mean that you need to close all transactions for this item, but you need to ensure all transactions in this warehouse are finished.
Dear both,Sorry for the wrong information provided to you. Now our warehouse is saying the blank warehouse should not be shown (hide)for the one item. Example is item number 100019 is shown in 101 two 2 times in one warehouse 101 quantity is blank that blank 101 must be hidden please check the image.
Best 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?
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.
Shabir Ahmad.
Please show me the transaction for the marked line.
QianQW,
Please check the transaction image for the item 100019 row with non quantity.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 688
André Arnaud de Cal... 524 Super User 2026 Season 1
CP04-islander 301
