MIS Department Policy & Procedure 

Accounting JDE Transfers

 This is used mainly for transferring data from the iSeries to JDE (Cash Receipts & Bank Reconciliation). 

 Most of the other transfers JDE to iSeries (Accounts Payable, Address Book & Payroll) are backups in case the JDE versions written by AMX for positive pay do not work. 

 The last transfer is run on occasion, when Accounting adds a new account number in JDE.  This transfer moves all the account numbers from JDE to the ASI cash system.  Before this is run there are special instructions that have to be completed first.  (Bottom of this document)

• Log into OENT

• Start SQL Server Management Studio

• When the window pops up click on connect

• If the SQL Server Management Studio comes up in default (Database) mode then connect to Integration Services.

• Server Type should be:  Integration Services

• Server Name should be:  OENT

This should be all you have to do.  If Accounting gets an error it is usually that Integration Services didn't start.  

If Accounting still cannot transfer data continue with the following:

Once Connected to Integration Services - go to Stored Packages\MSDB\ and the appropriate transfer you want to do. 

Right click on the transfer you want to complete and select run package.

Then click on execute.

 The transfers are:

 Cash - Iseries to JDE Cash Receipts – this moves the daily cash data from the ASI system to JDE (F0911Z1).  This transfer should only take a few seconds to complete.

 Bank Reconciliation – Before Accounting starts the Bank Reconciliation process they call MIS to clear the two JDE SQL tables (F075611 & F095051). 

Documentation for this can be found in Public Folders – MIS – Procedures – JDE – Clear JDE – SQL tables for Accounting.

 There are two transfer packages

Iseries to JDE Accounts Payable RECON – this moves AP data downloaded from the bank via the Iseries to JDE (F095051).  Note the number of rows transferred.

Iseries to JDE Payroll RECON – this moves payroll data downloaded from the bank via the Iseries to JDE (F075611).  Note the number of rows transferred.

Positive Pay – Backup processes to current JDE processes – Need to execute the appropriate package as well as the Address Book package.

Accounts Payable 

JDE to Iseries Accounts Payable (40 minutes) – this transfers the payables history table (F0413) to the Iseries.

JDE to Iseries Address Book – this transfers the address book table (F0111) to the Iseries.

Once this data is on the Iseries the Treasury Departments runs programs to build the positive pay file and FTP’s it to the bank.

Payroll

JDE to Iseries Payroll (50 minutes) – this transfers the payroll history table (F06156) to the Iseries.

JDE to Iseries Address Book – this transfers the address book table (F0111) to the Iseries.

Once this data is on the Iseries the Treasury Departments runs programs to build the positive pay file and FTP’s it to the bank.

Account Master

JDE to Iseries Account Master – this transfers the data from the JDE GL Account Master table (F0901) to the Iseries corresponding file.  Thus allowing ASI to do account verifications in the cash receipting system.

Before you do the transfer you have to clear this file on the iSeries.  To clear the file on the iSeries do the following:

• First verify that no one has a lock on the file by doing this command on iSeries

• WRKOBJLCK, then press F4 for interactive command processing

• In OBJECT field enter F0901

• In LIBRARY field enter ASIPE

• In OBJECT TYPE field enter *FILE

• Hit ENTER then hit F6 to see how has a lock on the file

• Get those users back to a menu screen on their AS400 emulation session.

• Once they are out of file you can clear it with step below and then do the transfer.

• Go to an iSeries command line and type in the following command to clear the file.

• clrpfm asipe/F0901   press enter