jimmymac
Reputable Poster
We have an existing Table Conversion to bring in expense GL transactions into the F0911Z1. However we do need now to exclude certain record types. I have tried to use the Data Selection in our existing TC to exclude records based on a value in the incoming flat file.
For example, the data selection is IC-126 Pay Code NE 'IBCP', which stands for Individual Billed Company Paid. The data selection basically though seems to be ignored and the code in the TC is getting data regardless of whether or not the value is IBCP.
To get around this I have just put in an If statement in the Advanced ER in the TC where all logic is based on this field being NE to IBCP. That works but I don't see why the data selection on the TC doesn't do what it should.
Any others have issues with table conversion data selection. Or have any ideas on my issue?
Any thoughts would be appreciated.
Thanks.
For example, the data selection is IC-126 Pay Code NE 'IBCP', which stands for Individual Billed Company Paid. The data selection basically though seems to be ignored and the code in the TC is getting data regardless of whether or not the value is IBCP.
To get around this I have just put in an If statement in the Advanced ER in the TC where all logic is based on this field being NE to IBCP. That works but I don't see why the data selection on the TC doesn't do what it should.
Any others have issues with table conversion data selection. Or have any ideas on my issue?
Any thoughts would be appreciated.
Thanks.