I have big problem. [:’(] my customer want filter “Currency Code” and “Dimension Code” from Aged Account Payable. Then i change some modification on this report. Before I change only this code:
Now i want filter currency code and Dimension code then i change this modification on my database /NAV DB/:
Its fine working . i think. And I also import to SQL Database this fob. But it didn’t work. What happening… I don’t know.
How can i filter “Currency Code” and “Dimension Code” from Aged Account Payable report. Maybe I write Any Code on this report or any way?
Thank you your reply. I use filter from Vendor Ledger Entry table. Maybe sometimes this filter working sometimes this filter didn’t work. how can i fix? plz…
You are applying the filter to one dataitem but the values on the report are calculated using the two Vendor Ledger Entry dataitem so try coping the filters from one to the other.
Aside: I hope this is demo/test data as your company/client would probably not want this published on the Web.
Thank you your reply. Your advise very helpful. I did filter in 2 Vendor Ledger Entry’s dataitem. Its fine working. But i don’t want 2 tabs. i show you screenshot.
You only need to use one tab (use the first and remove the ReqFilterFields on the second) and then in the OnPreDataItem of the second dataitem copy the filters applied to the first dataitem with the COPYFILTERS command.
even though you have answered the question, I do doubt that the correct question was asked, and thus is this really the solution the customer wanted. [:’(]
