REFRESHING OF CONSOL.KEYS
- chipom
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
14 years 7 months ago #6797
by chipom
REFRESHING OF CONSOL.KEYS was created by chipom
I have an account with a balance of $1.14 and its marked SUSPENSE on INT.NO.BOOKING field. if i check on CONSOLIDATE.ASST.LIAB record for the key is as shon below
18. 4 TYPE........... DEBIT
19. 4 BALANCE........ -2.69
22. 4 LOCAL.BALANCE.. -2.69
18. 5 TYPE........... SUSPENS
19. 5 BALANCE........ 3.83
22. 5 LOCAL.BALANCE.. 3.83
The net of the DEBIT and SUSPENSE balances is equal to the balance of the only account reporting on this key.
See account record below
ACCOUNT.NUMBER.... 043-996881-101
21 CONDITION.GROUP... 55 FCA STAFF ACCOUNTS
23 OPEN.ACTUAL.BAL... 1.14
24 OPEN.CLEARED.BAL.. 1.14
25 ONLINE.ACTUAL.BAL. 1.14
26 ONLINE.CLEARED.BAL 1.14
27 WORKING.BALANCE... 1.14
Can some one explain how Globus refresh these keys because when i extract a report of overdrawn accounts the the GL is reporting more than actual balancde of the account.
18. 4 TYPE........... DEBIT
19. 4 BALANCE........ -2.69
22. 4 LOCAL.BALANCE.. -2.69
18. 5 TYPE........... SUSPENS
19. 5 BALANCE........ 3.83
22. 5 LOCAL.BALANCE.. 3.83
The net of the DEBIT and SUSPENSE balances is equal to the balance of the only account reporting on this key.
See account record below
ACCOUNT.NUMBER.... 043-996881-101
21 CONDITION.GROUP... 55 FCA STAFF ACCOUNTS
23 OPEN.ACTUAL.BAL... 1.14
24 OPEN.CLEARED.BAL.. 1.14
25 ONLINE.ACTUAL.BAL. 1.14
26 ONLINE.CLEARED.BAL 1.14
27 WORKING.BALANCE... 1.14
Can some one explain how Globus refresh these keys because when i extract a report of overdrawn accounts the the GL is reporting more than actual balancde of the account.
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
14 years 7 months ago - 14 years 7 months ago #6799
by jpb
Replied by jpb on topic Re: REFRESHING OF CONSOL.KEYS
Hello chipom,
looking thru the helptext of ACCOUNT (field INT.NO.BOOKING and ACCR.xRx.SUSP) and ACCT.SUSP.SETTLE the logic becomes clear.
Check also the contents of ACCT.SUSP.ENTRIES / ACCT.SUSP.ACT, maybe it helps.
(We stopped using 'SUSPENSE' years ago.)
rgds,
jpb
looking thru the helptext of ACCOUNT (field INT.NO.BOOKING and ACCR.xRx.SUSP) and ACCT.SUSP.SETTLE the logic becomes clear.
Check also the contents of ACCT.SUSP.ENTRIES / ACCT.SUSP.ACT, maybe it helps.
(We stopped using 'SUSPENSE' years ago.)
rgds,
jpb
Last edit: 14 years 7 months ago by jpb.
Please Log in or Create an account to join the conversation.
- chipom
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 26
- Thank you received: 0
14 years 7 months ago #6800
by chipom
Replied by chipom on topic Re: REFRESHING OF CONSOL.KEYS
Thanks jpb but nothing is logged in ACCT.SUSP.ACT and ACCT.SUSP.ENTRIES
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
14 years 7 months ago #6801
by jpb
Replied by jpb on topic Re: REFRESHING OF CONSOL.KEYS
As far as I remember everthing is updated when ACCT.SUSP.SETTLE is entered and the same processed during COB.
Whether ACCT.SUSP.ENTRIES / ACCT.SUSP.ACT are still used I don't know.
Whether ACCT.SUSP.ENTRIES / ACCT.SUSP.ACT are still used I don't know.
Please Log in or Create an account to join the conversation.
Time to create page: 0.036 seconds