Sub accounting
- namco
- Topic Author
- Visitor
-
14 years 3 weeks ago #9292
by namco
Sub accounting was created by namco
Globus G:13
Hi Guys
Am trying to setup subaccount on g13. i did the following
1. Set the MAX.SUB.ACCOUNT TO 4 for the account
2.Created a AC.AUTO.ACCOUNT record as below
RULES AUTO CREATION OF SUB A/CS SEE
CATEGORY.......... 5910 REMITTANCES
2 NEW.NUMBER.RULE... NEXT
21 CURR.NO........... 1
22. 1 INPUTTER....... 22_GSS.N.NAMACHA
23. 1 DATE.TIME...... 31 OCT 11 14:05
24 AUTHORISER........ 22_EOD.OP04
25 CO.CODE........... NA-001-0001
26 DEPT.CODE......... 1
But when a tranaction hits this account am getting the below fatal error. Did i miss something
** FATAL ERROR IN (CDT) **
EB.RTN.DATE
Hi Guys
Am trying to setup subaccount on g13. i did the following
1. Set the MAX.SUB.ACCOUNT TO 4 for the account
2.Created a AC.AUTO.ACCOUNT record as below
RULES AUTO CREATION OF SUB A/CS SEE
CATEGORY.......... 5910 REMITTANCES
2 NEW.NUMBER.RULE... NEXT
21 CURR.NO........... 1
22. 1 INPUTTER....... 22_GSS.N.NAMACHA
23. 1 DATE.TIME...... 31 OCT 11 14:05
24 AUTHORISER........ 22_EOD.OP04
25 CO.CODE........... NA-001-0001
26 DEPT.CODE......... 1
But when a tranaction hits this account am getting the below fatal error. Did i miss something
** FATAL ERROR IN (CDT) **
EB.RTN.DATE
Please Log in or Create an account to join the conversation.
- mahmoudy
- Offline
- New Member
-
Less
More
- Posts: 14
- Thank you received: 0
14 years 2 weeks ago #9371
by mahmoudy
Replied by mahmoudy on topic Re: Sub accounting
Hello,
We must have a master account like USD59100001 for this you have to specify the number of subaccount in the field 160 MAX.SUB.ACCOUNT.
Best Regards
We must have a master account like USD59100001 for this you have to specify the number of subaccount in the field 160 MAX.SUB.ACCOUNT.
Best Regards
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
14 years 2 weeks ago #9377
by jpb
Replied by jpb on topic Re: Sub accounting
I don't know if the field exists in G13, but INT.ACC.TYPE (field 10) should be set to SUFFIX if present on AC.AUTO.ACCOUNT.
Do you have a check digit rule (ACCT.CHECKDIG.TYPE) defined in COMPANY that works with date???
Do you have a check digit rule (ACCT.CHECKDIG.TYPE) defined in COMPANY that works with date???
Please Log in or Create an account to join the conversation.
- dfixx
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago - 13 years 7 months ago #10985
by dfixx
Hi jbp/All,
If you dont mind my continuation of this issue, in response to your last question on check digit; yes we have defined ACCT.CHECKDIG.TYPE in our company record, our requirement is to enable the Sub accounts for our All in one account development. This has been setup in .
Unfortunately the sub accounts are not being created for our AZ.DEPOSITS products during repayments. hence the tables
AZ.ACTIVE.SUB.ACC &
AC.SUB.ACCOUNT
are not updated with sub account records because sub accounts are not being created (the 2 tables above were being partially updated with Master account record ID only see below)
From experience where else can we look to generate the sub accounts with the above scenario properly.
note: , ACCOUNT.CLASS, AZ.PRODUCT.PARAMETER etc have been setup BUT the sub account is not being created still.
Screenshots
TEST AREA AZ.ACTIVE.SUB.ACC - Default List
ID AZ.SUB.ACC FUNCT.
1 71992348889 <<EMPTY>> <== this is not ok
LIST OF ACTIVE SUB-CONTRACTS SEE
AZ.MAIN.ACCOUNT... 71992348889 JOHN
AZ.SUB.ACC is EMPTY <== this is not ok
Replied by dfixx on topic Re: Sub accounting
Do you have a check digit rule (ACCT.CHECKDIG.TYPE) defined in COMPANY that works with date???
Hi jbp/All,
If you dont mind my continuation of this issue, in response to your last question on check digit; yes we have defined ACCT.CHECKDIG.TYPE in our company record, our requirement is to enable the Sub accounts for our All in one account development. This has been setup in .
Unfortunately the sub accounts are not being created for our AZ.DEPOSITS products during repayments. hence the tables
AZ.ACTIVE.SUB.ACC &
AC.SUB.ACCOUNT
are not updated with sub account records because sub accounts are not being created (the 2 tables above were being partially updated with Master account record ID only see below)
From experience where else can we look to generate the sub accounts with the above scenario properly.
note: , ACCOUNT.CLASS, AZ.PRODUCT.PARAMETER etc have been setup BUT the sub account is not being created still.
Screenshots
TEST AREA AZ.ACTIVE.SUB.ACC - Default List
ID AZ.SUB.ACC FUNCT.
1 71992348889 <<EMPTY>> <== this is not ok
LIST OF ACTIVE SUB-CONTRACTS SEE
AZ.MAIN.ACCOUNT... 71992348889 JOHN
AZ.SUB.ACC is EMPTY <== this is not ok
Last edit: 13 years 7 months ago by dfixx.
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 7 months ago #10997
by durai611
Replied by durai611 on topic Re: Sub accounting
Hi dfixx,
Have you checked the set up in AZ.PRODUCT.PARAMETER & AC.AUTO.ACCOUNT?
Also the trigger for sub account creation in AZ is based on draw down. If you have user guide kindly check the set up information in that. Following is an extract from the user guide of AZ,
'Apart from the Set-up, draw down is the trigger to the creation of AZ sub a/c. Now when a draw down
is made – the system reads the APP code in a/c – looks up APP record to see if REPAYMENT.TYPE
is CREDIT.CARD, verifies that field MULTI and ACCT.SYNC as YES-then a sub a/c is created.'
Have you checked the set up in AZ.PRODUCT.PARAMETER & AC.AUTO.ACCOUNT?
Also the trigger for sub account creation in AZ is based on draw down. If you have user guide kindly check the set up information in that. Following is an extract from the user guide of AZ,
'Apart from the Set-up, draw down is the trigger to the creation of AZ sub a/c. Now when a draw down
is made – the system reads the APP code in a/c – looks up APP record to see if REPAYMENT.TYPE
is CREDIT.CARD, verifies that field MULTI and ACCT.SYNC as YES-then a sub a/c is created.'
Please Log in or Create an account to join the conversation.
- dfixx
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago #11007
by dfixx
Replied by dfixx on topic Re: Sub accounting
Thanks for your response durai611 these two table has been configured as shown below.
AC.AUTO.ACCOUNT
TEST AREA RULES AUTO CREATION OF SUB A/CS SEE
CATEGORY.......... 1191 AZ Deposits
1 DESCRIPTION....... AZ Multi Savings Plan and Deposits
2 NEW.NUMBER.RULE... NEXT
3. 1 INHERITED.FIELD
4. 1 FIELD.NAME.....
5. 1 FIELD.VALUE....
6 CREATION.RTN......
7. 1 EXCLUDE.SYS.ID.
8. 1 EXCLUDE.TXN....
9. 1 LOCAL.REF......
10 INT.ACC.TYPE......
AZ.PRODUCT.PARAMETER
=====================
TEST AREA ALL IN ONE PRODUCT PARAMETER SEE
PARAMETER.NO...... SAVSPLAN
1. 1 GB DESCRIPTION. SAVSPLAN
2 LOAN.DEPOSIT...... DEPOSIT
3 ALLOWED.CATEG..... 1191 AZ Deposits
4 DR.TXN.CODE....... 39 AZ - Deposit Debit
5 CR.TXN.CODE....... 42 AZ - Deposit Credits
8 MINIMUM.AMOUNT.... 1,000.00
9 MAXIMUM.AMOUNT.... 1,000,000.00
10 INT.BASIS......... B 366/360
16 INT.FIXED.RATE.... 1.00
20 MULTI............. YES
21 ACCT.SYNC......... YES
28 APPLY.PENALTY..... N
41 REPAYMENT.TYPE.... SAVINGS-PLAN
54 OD.CATEGORY....... 11421 AZ O/D Category
Remarks
=======
And I think in my opinion the problem might be because of 2 areas...
1 the Check digit mentioned above (by jbp) and
2 NEW.NUMBER.RULE (NEXT) in the AC.AUTO.ACCOUNT table. (As you mentioned above too)
Note that the check digit in company is required for creation of account no for all customers in our implementation because if we remove the check the digit its creating sub accounts.
My question is what are the available options with guides/docs for the creation of the sub accounts in this scenario with check digits...??
Thanks
R08 jbase 5 win 2k3
AC.AUTO.ACCOUNT
TEST AREA RULES AUTO CREATION OF SUB A/CS SEE
CATEGORY.......... 1191 AZ Deposits
1 DESCRIPTION....... AZ Multi Savings Plan and Deposits
2 NEW.NUMBER.RULE... NEXT
3. 1 INHERITED.FIELD
4. 1 FIELD.NAME.....
5. 1 FIELD.VALUE....
6 CREATION.RTN......
7. 1 EXCLUDE.SYS.ID.
8. 1 EXCLUDE.TXN....
9. 1 LOCAL.REF......
10 INT.ACC.TYPE......
AZ.PRODUCT.PARAMETER
=====================
TEST AREA ALL IN ONE PRODUCT PARAMETER SEE
PARAMETER.NO...... SAVSPLAN
1. 1 GB DESCRIPTION. SAVSPLAN
2 LOAN.DEPOSIT...... DEPOSIT
3 ALLOWED.CATEG..... 1191 AZ Deposits
4 DR.TXN.CODE....... 39 AZ - Deposit Debit
5 CR.TXN.CODE....... 42 AZ - Deposit Credits
8 MINIMUM.AMOUNT.... 1,000.00
9 MAXIMUM.AMOUNT.... 1,000,000.00
10 INT.BASIS......... B 366/360
16 INT.FIXED.RATE.... 1.00
20 MULTI............. YES
21 ACCT.SYNC......... YES
28 APPLY.PENALTY..... N
41 REPAYMENT.TYPE.... SAVINGS-PLAN
54 OD.CATEGORY....... 11421 AZ O/D Category
Remarks
=======
And I think in my opinion the problem might be because of 2 areas...
1 the Check digit mentioned above (by jbp) and
2 NEW.NUMBER.RULE (NEXT) in the AC.AUTO.ACCOUNT table. (As you mentioned above too)
Note that the check digit in company is required for creation of account no for all customers in our implementation because if we remove the check the digit its creating sub accounts.
My question is what are the available options with guides/docs for the creation of the sub accounts in this scenario with check digits...??
Thanks
R08 jbase 5 win 2k3
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 7 months ago - 13 years 7 months ago #11025
by durai611
Replied by durai611 on topic Re: Sub accounting
Dear dfixx,
Have you checked the repayment type? It's mentioned that to be CREDIT.CARD.
Kindly check with the set up. Also I would like to ask one question, did the customer know that other than main account, they have sub accounts created by system?
If you share your idea on sub account, it would be helpful for me to explain some more in detail.
Have you checked the repayment type? It's mentioned that to be CREDIT.CARD.
Kindly check with the set up. Also I would like to ask one question, did the customer know that other than main account, they have sub accounts created by system?
If you share your idea on sub account, it would be helpful for me to explain some more in detail.
Last edit: 13 years 7 months ago by durai611.
Please Log in or Create an account to join the conversation.
- dfixx
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago #11026
by dfixx
Replied by dfixx on topic Re: Sub accounting
Thank you very much for your response.. as you can see from above I have used SAVINGS-PLAN in field 41 above instead of CREDIT.CARD you mentioned this is was done based on the configurations observed for savings plan even in the model bank. however you have mentioned CREDIT-CARD which also an option in Repayment.Type.. is this required for savings plan could you share more light on the use of CREDIT.CARD option please?
Secondly in AZ.PRODUCT.PARAMETER for multi savings deposits sub accounts is required. see below
"In a Multi Deposit, every installment of deposit is kept in a separate Sub account and treated as separate deposit with different value date" also "Wherever partial withdrawal is permitted, Sub accounts are required".
These are the reasons we are considering sub accounts and of-course the bank will deal with the aspect of collaborating with customer on multiple accounts creation.
Thank you
email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Secondly in AZ.PRODUCT.PARAMETER for multi savings deposits sub accounts is required. see below
"In a Multi Deposit, every installment of deposit is kept in a separate Sub account and treated as separate deposit with different value date" also "Wherever partial withdrawal is permitted, Sub accounts are required".
These are the reasons we are considering sub accounts and of-course the bank will deal with the aspect of collaborating with customer on multiple accounts creation.
Thank you
email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Please Log in or Create an account to join the conversation.
- dfixx
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago - 13 years 7 months ago #11027
by dfixx
Replied by dfixx on topic Re: Sub accounting
To add further all the customer need to know is their main account, they do not have to know about the sub accounts
Last edit: 13 years 7 months ago by dfixx.
Please Log in or Create an account to join the conversation.
- dfixx
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago #11040
by dfixx
Replied by dfixx on topic Re: Sub accounting
All,
Can anyone assist with a sample routine to be used in
NEW.ACCOUNT.RULE OR
CREATION.RTN fields
Thanks
Can anyone assist with a sample routine to be used in
NEW.ACCOUNT.RULE OR
CREATION.RTN fields
Thanks
Please Log in or Create an account to join the conversation.
Time to create page: 0.046 seconds