Chain VI Import Jobs

SOLVED

I am working on building two VI Jobs that will automate our Cash Receipts Entry process. The first job inserts into the AR_CashReceiptsDeposit table, the second will insert to AR_CashReceiptsHeader so our AR Manager can simply spot check for accuracy and post as one batch. 

I'm wondering how, if possible, can I pull fields in the second job from the first. For example: DepositNo I have set to "Next", in the Deposit job, and I want to pull that field in the Header job, since it doesn't exist in the import file.

Or would I have to Export from the first job, set that file to the second import? This is my first time chaining jobs, so I'm a bit lost.

Parents Reply
  • 0 in reply to Kevin M

    Ok this has been a big help. The first job to the Deposit table works like a charm, the job to the Header is getting caught on CustomerNo. It's throwing an error that the CustomerNo isn't on file, when it 100% is. I went through the manual process to verify, and the import file has the CustomerNo pulled from the database with zero transformation applied to that field. What could be causing that?

Children