Sub accounting

  • namco
  • Topic Author
  • Visitor
  • 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

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • retired . . . ¯\_(ツ)_/¯
More
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???

Please Log in or Create an account to join the conversation.

More
13 years 7 months ago - 13 years 7 months ago #10985 by dfixx
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.

More
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.'

Please Log in or Create an account to join the conversation.

More
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

Please Log in or Create an account to join the conversation.

More
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.
Last edit: 13 years 7 months ago by durai611.

Please Log in or Create an account to join the conversation.

More
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.

Please Log in or Create an account to join the conversation.

More
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.

More
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

Please Log in or Create an account to join the conversation.

Time to create page: 0.046 seconds