Difference between revisions of "Information Systems:Cannot Close Period"

From uniWIKI
Jump to navigation Jump to search
(Created page with "Check SROBTR and SROOVF. If an update does not complete properly, sometimes orphaned transactions are left behind. For example, we have a custom system to receive transact...")
 
Line 1: Line 1:
  +
A period cannot be closed if there are outstanding transactions that have not yet been posted.
Check SROBTR and SROOVF. If an update does not complete properly, sometimes orphaned transactions are left behind.
 
  +
 
Use [[DFU]]to look at files SROBTR (Accounting transactions created in ASW-DIS) and SROOVF (G/L Input transactions). If an update does not complete properly, sometimes orphaned transactions are left behind.
   
 
For example, we have a custom system to receive transactions from the bank and post them to the store’s accounts receivable (see Bank EDI). Sometimes this leaves transactions in SROOVF. We can’t do anything but manually delete them, and do a journal entry.
 
For example, we have a custom system to receive transactions from the bank and post them to the store’s accounts receivable (see Bank EDI). Sometimes this leaves transactions in SROOVF. We can’t do anything but manually delete them, and do a journal entry.

Revision as of 17:09, 17 November 2015

A period cannot be closed if there are outstanding transactions that have not yet been posted.

Use DFUto look at files SROBTR (Accounting transactions created in ASW-DIS) and SROOVF (G/L Input transactions). If an update does not complete properly, sometimes orphaned transactions are left behind.

For example, we have a custom system to receive transactions from the bank and post them to the store’s accounts receivable (see Bank EDI). Sometimes this leaves transactions in SROOVF. We can’t do anything but manually delete them, and do a journal entry.

  • I can see only one place where this could be happening, but I haven’t figured out why. BERUP075 (BED -- Post A/R payment G/L corrections to ASW) calls GCFC851 (Interface accounting transfer), which calls GCFR851 (Interface accounting transaction transfer). If field &GRIW is returned as blank, FMC050 (G/L update transactions and balances) is not run.
  • Nancy seems to have found the problem and a solution. We have changed the job queue QBATCH to run two jobs at a time. If Nancy waits until one card type (Visa, Master Card, etc) completes before starting the next, the problem doesn’t seem to happen.