Skip to main content
Skip table of contents

Change Key-Obj Combination - GLUTSUMC

This function will change Key-Object combination(s) in ALL subsystems excluding flat files. This utility is similar to GLUTSUMO and GLUTSUMP. It will change combinations from one value to another based on the GL ledger associated with the user. The utility will prompt for the subsystems to change.

Below is the list of tables and column names changed by GLUTSUMC, GLUTSUMO and GLUTSUMP:

Table

Columns

GLK-KEY-MSTR

GLK-KEY

GLK-LINK-DTL

GLK-KEY

GLO-OBJ-MSTR

GLO-OBJ

GLO-LINK-DTL

GLO-OBJ

GLBA-BUDACT-MSTR

GLBA-KEY, -OBJ

GLM-MO-MSTR

GLM-KEY, -OBJ

GLC-BUDG-DTL

GLC-FROM-KEY, -OBJ

GLQ-QUICK-MSTR

GLQ-KEY, -OBJ

GLF-FULL-MSTR

GLF-KEY, -OBJ

GLT-TRNS-DTL

GLK-KEY, GLO-OBJ

GLD-DEF-DTL

GLD-MAP-GL-KEY, -OBJ, GLD-GL-KEY, -OBJ

GLG-GEN-MSTR*

GLG-INTRA

GLR-RULE-DTL*

GLR-VAL

GLK-KEY-MSTR

GLK-OVER-KEY

OH-DTL

OH-GL-KEY, -OBJ

OHB-SET-DTL

OHB-GL-KEY, -OBJ

OHC-CLASS-DTL*

OHC-ADD-QUAL

EN-DTL

EN-GL-KEY, -OBJ

ENT-TTL-DTL*

ENTF-KEY, -OBJ

POI-ITEM-DTL

POI-JL-KEY, -OBJ

PON-EN-DTL

PON-GL-KEY, -OBJ

POC-CLASS-DTL*

POC-ADD-QUAL

SIT-TRANS-DTL

SIT-GL-KEY, -OBJ

SIM-ITEM-DTL

SIM-GL-KEY, -OBJ

SI-WHSE-MSTR

SI-WHSE-GL-KEY, -OBJ

SIC-CLASS-DTL*

SIC-ADD-QUAL

CD-CODES-MSTR

CD-ASSOC-CODE(1), (2)

US-DB-DTL*

US-DB-SEL-CD1, -CD2

PYN-NUM-DTL

PY-CHR-CD

PYM-CDH-DTL*

PYM-KEY(1), (2), PYM-OBJ(1), (2)

AR-TRNS-DTL

AR-GL-KEY, -OBJ

AR-CODE-MSTR

ARC-PROJ, ARC-OBJ, ARC-DIV-PROJ, ARC-DIV-OBJ

PE-PROD-MSTR*

PE-OBJ, PE-OBJ2

*Skipped by GLUTSUMC

Optionally, this process will only change detail transactions for a selected date range. When this option is chosen, only entries in the ARTRNS- DTL, EN-DTL, GLT-TRNS-DTL, GLA-TRNS-DTL, OH-DTL, OHB-SET-DTL, and SIT-TRANS-DTL with a posting date in the entered date range will be updated. All other datasets will not be changed. This option is useful to change current year entries, but leave prior year entries with their existing account numbers for reporting and audit purposes.

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.