Where is Begin Balance of LD for CRB.
- Otono
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 1
13 years 9 months ago #9970
by Otono
Where is Begin Balance of LD for CRB. was created by Otono
Hello,
Anyone can please help me where is Beginning Balances of LD123456 that CRB get data from?
Everyday CRB has LD123456 balances is -500 I want to reduce it to zero.
---
In our CRB has:
3699 Account receivable
LD123456..............USD..............Customer XYZ...............-500.........-500
EB.CONTRACT.BALANCES has
@ID........ LD123456
CLOSE.BAL.. 0
This LD info was all in HIST tables - it's reverted.
--
Anyone can please help me where is Beginning Balances of LD123456 that CRB get data from?
Everyday CRB has LD123456 balances is -500 I want to reduce it to zero.
---
In our CRB has:
3699 Account receivable
LD123456..............USD..............Customer XYZ...............-500.........-500
EB.CONTRACT.BALANCES has
@ID........ LD123456
CLOSE.BAL.. 0
This LD info was all in HIST tables - it's reverted.
--
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 9 months ago #9972
by jpb
Replied by jpb on topic Re: Where is Begin Balance of LD for CRB.
Hi Otono,
what release are you on?
I've never seen CLOSE.BAL in EB.CONTRACT.BALANCES, or do you have a local field there ???
Not sure where the balance is taken from, but have a look at Fxxx.LMM.ACCOUNT.BALANCES (append 00 to the LD-Id).
But why do you want to manipulate it, your LINE doesn't look like it's a difference.
Have you checked RE.STAT.MISMATCH and/or RE.STAT.BAL.REC for 3699?
what release are you on?
I've never seen CLOSE.BAL in EB.CONTRACT.BALANCES, or do you have a local field there ???
Not sure where the balance is taken from, but have a look at Fxxx.LMM.ACCOUNT.BALANCES (append 00 to the LD-Id).
But why do you want to manipulate it, your LINE doesn't look like it's a difference.
Have you checked RE.STAT.MISMATCH and/or RE.STAT.BAL.REC for 3699?
Please Log in or Create an account to join the conversation.
- Otono
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 1
13 years 9 months ago #9975
by Otono
Replied by Otono on topic Re: Where is Begin Balance of LD for CRB.
Sorry, I made mistake.
EB.CONTRACT.BALANCES: I mean CLose.Bal = open value + credit mvt + debit mvt in EB
EB balannce = 0 but in CRB its not. Mismatch is ok.
I tried to delete entries in past days. CRB become 0 after COB. So CRB will calculate base on Entries in STMT.ENTRY, CATEG.ENTRY in past???
EB.CONTRACT.BALANCES: I mean CLose.Bal = open value + credit mvt + debit mvt in EB
EB balannce = 0 but in CRB its not. Mismatch is ok.
I tried to delete entries in past days. CRB become 0 after COB. So CRB will calculate base on Entries in STMT.ENTRY, CATEG.ENTRY in past???
Please Log in or Create an account to join the conversation.
- durai611
- Offline
- Elite Member
-
Less
More
- Posts: 300
- Thank you received: 51
13 years 9 months ago - 13 years 9 months ago #9978
by durai611
Replied by durai611 on topic Re: Where is Begin Balance of LD for CRB.
Hi Otono,
CRB report contains the details of individual contracts and accounts as well that make up each line. The balances for each contract and it's asset types are extracted from EB.CONTRACT.BALANCES. These details are built in a work file (RE.CRF.XXXX, XXXX - is the report name) while running the service RE.RETURN.EXTRACT, which is later used by the enquiry to generate the CRB report.
Regards,
Durairaj.
CRB report contains the details of individual contracts and accounts as well that make up each line. The balances for each contract and it's asset types are extracted from EB.CONTRACT.BALANCES. These details are built in a work file (RE.CRF.XXXX, XXXX - is the report name) while running the service RE.RETURN.EXTRACT, which is later used by the enquiry to generate the CRB report.
Regards,
Durairaj.
Last edit: 13 years 9 months ago by durai611.
The following user(s) said Thank You: Otono
Please Log in or Create an account to join the conversation.
- Otono
- Topic Author
- Offline
- Junior Member
-
Less
More
- Posts: 25
- Thank you received: 1
13 years 9 months ago #9979
by Otono
Replied by Otono on topic Re: Where is Begin Balance of LD for CRB.
Hi all,
Thank you for your support.
I wonder, what is problem if one LD was reversed but Accurred Interest Receivable account is still in CRB balance.
I tried deleted all related entried in tables: STMT.ENTRY / RE.SPEC.CONSOL / CATEG.ENTRY and delete EB.Contract.Balance record. After COB, CRB balance is right = 0, it has mismatches because EB is missing. ESS is fine = 0. So what is better solution?
Thank you for your support.
I wonder, what is problem if one LD was reversed but Accurred Interest Receivable account is still in CRB balance.
I tried deleted all related entried in tables: STMT.ENTRY / RE.SPEC.CONSOL / CATEG.ENTRY and delete EB.Contract.Balance record. After COB, CRB balance is right = 0, it has mismatches because EB is missing. ESS is fine = 0. So what is better solution?
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2859
- Thank you received: 650
13 years 9 months ago #9982
by jpb
Replied by jpb on topic Re: Where is Begin Balance of LD for CRB.
Sorry to say, but the better solution would have been to ask helpdesk.
As mentioned in other topics, at least in solving mismatches the support has always been OK.
As mentioned in other topics, at least in solving mismatches the support has always been OK.
The following user(s) said Thank You: Otono
Please Log in or Create an account to join the conversation.
Time to create page: 0.043 seconds