490
Hello Team,
Kindly Let me know the datasource for Physical Inventory by Inventory Dimension Report Datasource. We want to remove unwanted data printed on report. Attached snap for your reference. Kindly support
Ok, thanks.
Now I also noticed that your question is about AX2009, not AX2012.
Take a look at InventDimPhys report in AOT. In method fetch, before super() call, you should be able to add code, which does following:
Iterate InventSumDateTrans table, using the same ParmId that the report is using. For each item id that has positive financial qty, check if there's a record that has negative financial qty. If yes, then add range to the report query, excluding that item id. Or, perhaps even delete those records from the table (all records for the used ParmId will anyway be deleted once the report is printed).
Hello Nikoloas,
Yes we want to hide Financial Qty from this report which are having positive and negative financial qty. Thank You.
I'm sorry but I don't understand what you mean by "+ve" and "-ve" lines transactions.
Do you mean that you want to hide all records, which have positive and negative financial quantity, even if the sum of the positive and negative quantity is not 0?
Financial quantity is the last column on the right in your screenshot.
Hello NiKoloas,
In attached screenshot, item numbers 1701-2109-P001,1710-116,174003,192305 etc. are shown with +ve and -ve lines transactions. We dont want that lines to be displayed on report. The Stock for these items in system is Zero.
What do you mean by "encircled type of transactions"? How would you determine the type of the transaction?
Do you perhaps mean "If sum of financial quantity across all inventory dimensions for this item is 0, don't show this item"? Or something else?
Hello Spike Wang,
We dont want to show both the transaction for +ve and -ve for the encircled type of transactions in the screenshot. We have near about 200 Lines which are displayed on report. How can we eliminate these items from the report? Can you please let us know. Thank You.
Hi Senthil,
(1) what data you want to show,positive or negative?
(2) you can modify the report to add link to table of on-hand inventory,or you can change the logic of the report to let the record where items does not have stock not to show.
Hello Nikoloas,
Yes we want here two things, First we have many lines as present in the screenshot positive and negative Qtys being displayed. we want to eliminate all those items from the report and yes second requirement is hide all the items which dont have stock in the system.
Ah, or did you mean that you want to hide all items which don't have stock in the system?
But in your screenshot you had many such cases, and yet only one item was marked by you.
It's really important to define (and describe) your requirement in a clear way - that's the prerequisite for starting technical design for the solution.
#1
André Arnaud de Cal...
291,735
Super User 2024 Season 2
#2
Martin Dráb
230,466
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
