Splitting Z file processes

[jimmymac]

We process incoming transactions through the use of Z files in AP and GL. Coming up soon, we may need to revise our process since in the incoming files which currently includes multiple companies. We may need split that data so that two batches are created. Say one batch for company A and another batch for company B. This is to allow different accounting staffs to post their respective companies independently.

One option to come up with a batch for each company, would be to modify our PSFT process that sends us an interface file, so that it would send separate files for each company, and then we could process them separately and end up with separate batches. Modifying the PSFT process is something we want to avoid.

So it occurred to me that even though data for both companies would come into the Z file, if we had versions of the voucher or batch processor jobs that selected on company, we would end up with separate batches so that they could be posted separately without changing the upstream PSFT jobs.

We are on E1 9.0, and looking for any ideas on how to have a single file come in a Zfile, but then create multiple batches based on Company.

Any ideas would be appreciated.

 

[jdelisths]

Both A/P and G/L Z processes start a new batch on EDI User ID (EDUS) and EDI Batch Number (EDBT). It is general practice to specify a different batch number to start a new batch. For example:


VNEDBT
---------------
4684
4684
4684
4684
4697
4697
4697

In this case, records associated with #4864 will create one batch and #4697 will create another batch. You need to make sure that these batches are in balance, etc.

 

[peterbruce]

Jimmy,

To get different batches all you need to do is have different values for the xxEDBT column. Look at your AP manual in the appendix (A) that sets out the mapping for the batch voucher input tables. The detail for EDI - Batch Number VLEDBT says:

[ QUOTE ]
This field also serves as a level break and causes the assignment of a new JD Edwards EnterpriseOne batch number each time that the value changes.

[/ QUOTE ]