I have an Agent and agent line table relationship similar to Sales header and line, during agent commission posting there is also tax calculated based on agent line and inserted into tax table. The posting is working well, my problem is on the report section, the report printed from posted agent documents it pools report similar to sales invoice but also needed to bring all taxes related to this Agent. On the report, I added I have three Dataitems 1. Header 2.Line 3. Tax History and the header and line doing what I need which is printing calculated the current commission information for the given document No. and the on the tax history Dataitem section the report is required to bring all the Taxhistory within the current Month of the Document posting date Eg. Document Posted on Jan 30 and Doc report printed it needs to pool all tax history from Jan 1..30 the whole commission tax will be calculated for the month.
and I put
Tax History - OnPreDataItem()TaxHistory.RESET;TaxHistory.SETFILTER( "Posting Date",'%1..%2',StartDate,EndDate); and this filter doesn't seem to be working.
StartDate and EndDate is on Requestpage;
Thanks in Advance
Set debugger on the "TaxHistory.SETFILTER( "Posting Date",'%1..%2',..." line and see that data the StartDate and EndDate and why filters do not work..
It is the way only to receive a real answer without guessing.