B03B0062
Calculate Account Action
Functional Description
Purpose
This function determines if an activity message record needs to be written in F03B31, if a workflow
message needs to be sent to the work center, and if the Hold Invoice flag and the Temporary Credit
Message field need to be updated in Customer Master Information (P03013).
The activity messages that can be written in F03B31 are 'Credit Review Required' (activity 20), and
'Over Credit Limit' (activity 21). The workflow messages that can be sent to the work center are
'Collection Review Required', 'External Collection Recommended.'
Setup Notes and Prerequisites
Special Logic
Technical Specifications
Parameters
ItemDescriptionI/OReq?Notes
AN8Customer NumberIYes
COCompanyIYes
PLYPolicy NumberIYes
DAGAs of DateIYes
FURFuture Amount IYes
CURRCurrent Amount DueIYes
AG1Amt Aging Categories 1IYes
AG2Amt Aging Categories 2IYes
AG3Amt Aging Categories 3IYes
AG4Amt Aging Categories 4IYes
AG5Amt Aging Categories 5IYes
AG6Amt Aging Categories 6IYes
AG7Amt Aging Categories 7IYes
ACLAmount Credit LimitIYes
AOCLAmount Over Credit LimitIYes
RVDJDate Recall For ReviewIYes
PARTPart Child RelationshipIYes
CRCDCurrency CodeIYes
TSTATemp Credit MessageIYes
CMGRCredit ManagerIYes
CLMGCollection ManagerIYes
Related Tables
F03B25A/R Delinquency Policy Table
Related Business Functions
N0100041Address Book MBF
N0100042Customer Master MBF
B03B0049F03B26 Get Notification Policy
B03B0068F03B31 - Write Activity Record
N03B0164SendMessageCollectionReview
B9800100Get Audit Information
Processing
If the Company is 00000,
If Amount Over Credit Limit is greater than zero,
Call F03B26 Get Notification Policy. Some of the outputs to this call are cSendtocollections,
cNotitifycollectionmanager, and cAgingcategory.
If cSendtocollections is equal to a '1' or cNotifycollectionmanager is equal to a '1',
oldest aging category. This amount will be sent with the workflow message.
If cSendtocollections is equal to a '1',
Call SendMessageCollectionReview to send a workflow message to the work center.
Call Customer Master - MBF (action code I).
If Line ID Number is equal to '0' and Policy Number is not equal to '0',
If the flag is equal to a '1',
Message.
If Temp Credit Message (passed in) is different from Temporary Credit Message (fetched from F03B25),
table.
If cArHoldInvoices is equal to a '1',
Call Get Audit Information.
Call Customer Master - MBF to update the Temporary Credit Message and Hold Invoices.
D03B0062 - Calculate Account Action
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnCustomerNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnPolicyNumber | PLY | MATH_NUMERIC | NONE | NONE |
A number that the system assigns to each policy record to identify it. | ||||
jdDateAgeAsOf | DAG | JDEDATE | NONE | NONE |
A date that the system uses to determine the aging category to which to assign an invoice. The system compares the aging date to the
| ||||
mnAmountFuture | FTR | MATH_NUMERIC | NONE | NONE |
The total amount of the invoices that is due prior to the first aging category defined when the Credit Analysis Refresh program (R03B525)
| ||||
mnCurrentAmountDue | CURR | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the current aging category as defined in either the Accounts Receivable constants or the
| ||||
mnAmtAgingCategories1 | AG1 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the first category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories2 | AG2 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the second category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtAgingCategories3 | AG3 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the third category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories4 | AG4 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fourth category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtAgingCategories5 | AG5 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the fifth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories6 | AG6 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the sixth category as defined in either the Accounts Receivable constants or the processing options
| ||||
mnAmtAgingCategories7 | AG7 | MATH_NUMERIC | NONE | NONE |
The total open invoice amount that is in the seventh category as defined in either the Accounts Receivable constants or the processing
| ||||
mnAmtOverCreditLimit | AOCL | MATH_NUMERIC | NONE | NONE |
The portion of a customer's total amount due that exceeds his available credit limit. | ||||
cParentChildRelation | PART | char | NONE | NONE |
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent
| ||||
szCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
szTempCreditMessage | TSTA | char | NONE | NONE |
A user defined code that identifies a temporary credit status. Generally, you assign the code when an account becomes past due. The
| ||||
szCreditManager | CMGR | char | NONE | NONE |
The name of the credit manager responsible for approving changes to the credit limit. You must set up the credit manager in the address
| ||||
szCollectionManager | CLMG | char | NONE | NONE |
The name of the collection manager responsible for managing this customer's account. You must set up the collection manager in the
| ||||
mnAmountCreditLimit | ACL | MATH_NUMERIC | NONE | NONE |
The total amount that you allow the customer to spend on purchases before the system sends a workflow message. This value is used
| ||||
jdDateRecallForReview | RVDJ | JDEDATE | NONE | NONE |
The review date for the customer's credit information. | ||||
cLineOfBusinessFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cAgingCategory | AGC | char | OPT | NONE |
A number that represents an aging category or severity level depending on the setting of the Determine Severity Level processing option
| ||||
mnCurrentAgingDays | AGR8 | MATH_NUMERIC | OPT | NONE |
The specified number of days for the Accounts Receivable aging report. | ||||
mnAgingDaysCategory1 | AGR1 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with CRDY and AGR2 to define the current and first aging categories. | ||||
mnAgingDaysCategory2 | AGR2 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR1 and AGR3 to define the first and second aging categories. | ||||
mnAgingDaysCategory3 | AGR3 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR2 and AGR4 to define the second and third aging categories. | ||||
mnAgingDaysCategory4 | AGR4 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR3 and AGR5 to define the third and fourth aging categories. | ||||
mnAgingDaysCategory5 | AGR5 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR4 and AGR6 to define the fourth and fifth aging categories. | ||||
mnAgingDaysCategory6 | AGR6 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR5 and AGR7 to define the fifth and sixth aging categories. | ||||
mnAgingDaysCategory7 | AGR7 | MATH_NUMERIC | OPT | NONE |
A value used in conjunction with AGR6 to define the sixth aging category. | ||||
cAgingMethod | AGEM | char | OPT | NONE |
A code that designates which aging categories the system uses to assign invoices. The system uses the date specified in the Age as of
|
B03B0049 F03B26 Get Notification Policy | ||||
B03B0068 F03B31 - Write Activity Record | ||||
B9800100 Get Audit Information | ||||
N0100041 Address Book MBF | ||||
N0100042 Customer Master -MBF |
F03B25 Delinquency Policy |