I have a large entry to make in Job Posting Entry. I took a shot at building a CSV file in excel and I created a Visual Integrator Job using the file JC.POSTCST. My CSV contains the following fields:
CREDIT GL ACCOUNT | JOB NUMBER | COST CODE | TRANS DATE | COMMENT | UNIT COST | UNITS |
9999-0-00-00 | 2014125 | LBRSUPV00 | 7/31/2015 | Correct miscode | 440.92 | (1.00) |
9999-0-00-00 | 2014125 | LBRIRHL00 | 7/31/2015 | Correct miscode | 146.97 | 1.00 |
9999-0-00-00 | 2014125 | LBRDRHL00 | 7/31/2015 | Correct miscode | 146.97 | 1.00 |
9999-0-00-00 | 2014125 | LBRSPRY00 | 7/31/2015 | Correct miscode | 146.98 | 1.00 |
When I run the job it imports some of the fields but not all. Nothing fails but when I run Job Posing Entry there are no batches there to update. Is what I want to do possible? What am I missing? Thanks.