Dormant Account exclude some accounts
- kda
- Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 603
- Thank you received: 3
13 years 11 months ago #9597
by kda
Dormant Account exclude some accounts was created by kda
Dear All,
Please help me urgent, usually dormant account when the accounts do not txn of customer over one year, it will mark as dormant account(over one year) but i want to exclude some accounts or categories of those account not allow them fall into dormant however it has not txn over one year.
Thanks
Please help me urgent, usually dormant account when the accounts do not txn of customer over one year, it will mark as dormant account(over one year) but i want to exclude some accounts or categories of those account not allow them fall into dormant however it has not txn over one year.
Thanks
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
13 years 11 months ago #9605
by jpb
Replied by jpb on topic Re: Dormant Account exclude some accounts
Hi kda,
are you talking about IC.UPDATE.INACTIVE job to set the field INACTIVITY.MARKER in ACCOUNT according to INACTIVITY.MONTH in COMPANY ?
There is no core solution for that, you have to create your own routine.
Beside setting the field in ACCOUNT make sure to update Fxxx.ACCOUNT.INACTIVE
are you talking about IC.UPDATE.INACTIVE job to set the field INACTIVITY.MARKER in ACCOUNT according to INACTIVITY.MONTH in COMPANY ?
There is no core solution for that, you have to create your own routine.
Beside setting the field in ACCOUNT make sure to update Fxxx.ACCOUNT.INACTIVE
Please Log in or Create an account to join the conversation.
- kda
- Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 603
- Thank you received: 3
13 years 11 months ago #9609
by kda
Replied by kda on topic Re: Dormant Account exclude some accounts
yeah, could u explain me
Thanks
Thanks
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired . . . ¯\_(ツ)_/¯
Less
More
- Posts: 2860
- Thank you received: 650
13 years 11 months ago #9612
by jpb
Replied by jpb on topic Re: Dormant Account exclude some accounts
Try this :
Create the record in PGM.FILE (copy IC.UPDATE.INACTIVE) and replace the routine in the BATCH - XXX/ONLINE
IC.UPDATE.INACTIVE.POST has to run as normal, it's updating Fxxx.ACCOUNT.INACTIV
;-)
jpb
SUBROUTINE LOCAL.IC.UPDATE.INACTIVE.SELECT
*********************************************************************
* This is the .SELECT routine of LOCAL.IC.UPDATE.INACTIVE *
*********************************************************************
$INSERT I_COMMON
$INSERT I_EQUATE
$INSERT I_F.ACCOUNT
$INSERT I_F.COMPANY
$INSERT I_IC.UPDATE.INACTIVE.COMMON
*
*---> YINACTIVE.DATE TO BE USED AS COMPARISON TO DATES, IS SET IN .LOAD FROM FIELD IN COMPANY
*
YSELECT.STATEMENT = "SELECT ":FN.ACCOUNT:" WITH CUSTOMER NE ''"
YSELECT.STATEMENT := " AND WITH INACTIV.MARKER EQ ''"
YSELECT.STATEMENT := "AND WITH DATE.LAST.DR.CUST LT ":YINACTIVE.DATE
YSELECT.STATEMENT := "AND WITH DATE.LAST.CR.CUST LT ":YINACTIVE.DATE
YSELECT.STATEMENT := "AND WITH --> YOUR CRITERIA HERE <---"
LIST.PARAMETER = ""
LIST.PARAMETER<1>=""
LIST.PARAMETER<3> = YSELECT.STATEMENT
CALL BATCH.BUILD.LIST(LIST.PARAMETER,'')
RETURN
ENDSUBROUTINE LOCAL.IC.UPDATE.INACTIVE.LOAD
*********************************************************************
* This is the .LOAD routine of LOCAL.IC.UPDATE.INACTIVE *
*********************************************************************
$INSERT I_COMMON
$INSERT I_EQUATE
$INSERT I_IC.UPDATE.INACTIVE.COMMON
CALL IC.UPDATE.INACTIVE.LOAD
RETURN
ENDSUBROUTINE LOCAL.IC.UPDATE.INACTIVE(ACCT.ID)
*********************************************************************
* This is the record routine of LOCAL.IC.UPDATE.INACTIVE *
*********************************************************************
$INSERT I_COMMON
$INSERT I_EQUATE
$INSERT I_IC.UPDATE.INACTIVE.COMMON
CALL UPDATE.INACTIVE.MARKER(ACCT.ID)
RETURN
ENDCreate the record in PGM.FILE (copy IC.UPDATE.INACTIVE) and replace the routine in the BATCH - XXX/ONLINE
IC.UPDATE.INACTIVE.POST has to run as normal, it's updating Fxxx.ACCOUNT.INACTIV
;-)
jpb
Please Log in or Create an account to join the conversation.
- inca
- Offline
- New Member
-
Less
More
- Posts: 3
- Thank you received: 0
13 years 11 months ago #9623
by inca
Replied by inca on topic Re: Dormant Account exclude some accounts
From T24 R10, You could set different INACTIVE.MONTHS for different account group in ACCT.GROUP.CONDITION (field#63)
Please Log in or Create an account to join the conversation.
- kda
- Topic Author
- Offline
- Platinum Member
-
Less
More
- Posts: 603
- Thank you received: 3
13 years 11 months ago #9627
by kda
Replied by kda on topic Re: Dormant Account exclude some accounts
ok
let me try thanks
let me try thanks
Please Log in or Create an account to join the conversation.
Time to create page: 0.043 seconds