N03B0046
Finance Charge Processing
Functional Description
Purpose
The purpose of the business function is to determine the finance changes to be applied.
When the Collection Manager Approval Required flag is turned off (in the fee policy)
In Final Mode (Processing Mode (MODE) = 1)
Journal History Detail (F03B23) file. It also updates the Last Fee Calculated Date (LFCJ) with the
Date Age As Of for the invoice or payment record that finance charge applied in F03B11 (Customer
Ledger) or F03B14 (A/R Check Detail File).
When the Processing Option is a 2, the program inserts the finance charge record into F03B11.
Journal History Detail (F03B23) file. The Date Last Fee Calculated will not be updated.
When the Processing Option is a 2, no record will be inserted in F03B11.
When the Collection Manager Approval Required flag is turned on (in the fee policy)
In Final Mode
Journal History Detail (F03B23) file. It also updates the Last Fee Calculated Date (LFCJ) with the
Date Age As Of for the invoice or payment record that finance charge applied in F03B11 or F03B14.
When the Processing Option is a 2, the program will not insert the finance charge record to
F03B11.
Journal History Detail (F03B23) file. The Date Last Fee Calculated will not be updated.
When the Processing Option is a 2, no record will be inserted in F03B11.
Setup Notes and Prerequisites
Processing Option:
2 = Write the Finance Charge Invoice (Document Type RF) record to the F03B11 table.
3 = Close the batch.
Technical Specifications
Parameters
Item DescriptionI/OReq?Notes
AN8 Address NumberIYes
CO CompanyIYes
UKID Unique Key IDIYes
PLY Policy NumberIYes
LNID Line NumberIYes
EV15 Processing OptionIYes
NAPR Notification ApprovalI/ONoNAPR is an input and
required, when Processing Option is a 2
ASDE1 As Of DateIYes
DCT Document TypeIYes
KCO Document CompanyIYes
PA8 Parent NumberIYes
PST Pay Status CodeIYes
CRCD Currency Code FromINo
BCRC Currency Code BaseIYes
ALPH Name AlphaIYes
DOC Document NumberIYes
SFX Document Pay ItemIYes
DGJ Date for G/L and VoucherIYes
MODE Processing ModeIYes
CPAD Calc on Paid Late AmountINoIf not calculate fee on
late payment
PYID Payment IDINoIf not calculate fee on
late payment
RC5 File Line IDINoIf not calculate fee on
late payment
RNID Batch Run IDIYes
DFEE Amount Delinquency FeesI/OYesDFEE is an input, when
Processing Option is a 2
ASLC Amount Subject to Fin ChargeIYes
FFEE For Amount Del. FeeINo
FSLC For Subject to Fin ChargeINo
CRR Currency Conversion RateINo
CRRM Currency ModeINo
DDJ Date DueIYes
LFCJ Date Last Fee CalculatedIYesRequired if not the first
time the fee is calculated
ICU Batch NumberINo
PTC Payment Terms CodeINo
TXA1 Tax AreaINo
EXR1 Tax Explanation CodeINo
EV01 Everest Event Point 1INo
GENLNG Generic LongI No
EV02 Error FlagONo
Related Tables
F03B22A/R Fee Journal History
F03B23A/R Fee Journal History Detail
F03B11Customer Ledger
F03B14A/R Check Detail File
F0911Account Ledger
Related Business Functions
B03B0029Calculate Finance Charge from Rules
B03B0165 F03B22 Fetch Next Unique ID
B9800100 Get Audit Info
B03B0116 F03B23 Write Fee Journal History Detail
X0903 Return FYPN
B0100042 Customer Master -MBF
B0400037 Default Due Date
B0000055 Validate AAI Completely
B03B0011 Acct Rec FS Begin Doc
B03B0011Acct Rec FS Edit Line
B0900049 F0911 FS Begin Doc
B0900049 F0911 FS Edit Line
B03B0011 Acct Rec FS Edit Doc
B0900049 F0911 FS Edit Doc
B0900049 F0911 FS End Doc
B03B0066 F03012 Get Policy Number
B03B0071 F0010 Get Serk Number
B03B0068 F03B31 Write Activity Records
X0010X0010 - Get Next Number
Processing
If Processing Option = 1
Run F03B22 Fetch Next Unique ID
Run Get Audit Information
Run F03B23 Write Fee Journal History Details to write F03B23
policy) is required
2 (Approved) when in Final Mode and the approval is not required
4 (Proof) when in Proof Mode (Processing Mode = 0))
If Processing Option = 2
If Notification Approval (NAPR) = 2 (Approved)
Run X0010 Get Next Number
Run Invoice Data, Set from Customer Master
Run Due Date Set
Run F0012 Get AAI Account Number
If Error Flag != 2 (2 means error, AAI is not found)
Run F03B11 Edit Line
Run F0911 Begin Document
Run F0911 Edit Line
Run F03B11Edit Document
Run F0911 Edit Document
Run F03B11 End Document
Run F0911 End Documents
Run F03012 Get Policy Number
Run F0002 Get Activity ID
to F03B31
If Error Flag != 2
Run F0010 Get Company Name
Run Set Level Finance Charge Customer Error
Run Process batch errors to the JDEM system
D03B0046 - Finance Charge Journal Processing
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | 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
| ||||
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
| ||||
mnUniqueKeyIDInternal | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnPolicyNumber | PLY | MATH_NUMERIC | NONE | NONE |
A number that the system assigns to each policy record to identify it. | ||||
mnLineNumber | LNID | MATH_NUMERIC | NONE | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
cProcessingOption | EV15 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cNotificationApproval | NAPR | char | NONE | NONE |
A system-assigned code that indicates the status of a statement, deliquency notice, or delinquency fee. Valid values
| ||||
jdAsOfDate | ASDE1 | JDEDATE | NONE | NONE |
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
szDocumentCompany | KCO | char | NONE | NONE |
A number that, with the document number, document type and G/L date, uniquely identifies an original document, such as invoice, voucher,
| ||||
mnAddressNumberParent | PA8 | MATH_NUMERIC | NONE | NONE |
The address book number of the parent company. The system uses this number to associate a particular address with a parent company
| ||||
cPayStatusCode | PST | char | NONE | NONE |
A user defined code (00/PS) that indicates the current payment status for a voucher or an invoice. Examples of codes include:
A
Approved
| ||||
szCurrencyCodeFrom | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
szCurrencyCodeBase | BCRC | char | NONE | NONE |
A code that represents the currency of the company for a transaction. For a foreign currency transaction, this is the currency code of the
| ||||
szNameAlpha | ALPH | char | NONE | NONE |
The text that names or describes an address. This 40-character alphabetic field appears on a number of forms and reports. You can enter
| ||||
mnDocumentNumber | DOC | MATH_NUMERIC | NONE | NONE |
A number that identifies the original document, such as a voucher, invoice, or journal entry. On entry forms, you can assign the document
| ||||
szDocumentPayItem | SFX | char | NONE | NONE |
A number that identifies the pay item for a voucher or an invoice. The system assigns the pay item number. If the voucher or invoice has
| ||||
jdDateforglandvoucherjulian | DGJ | JDEDATE | NONE | NONE |
A date that identifies the financial period to which the transaction will be posted. You define financial periods for a date pattern code that you
| ||||
cProcessingMode | MODE | char | NONE | NONE |
The processing mode used in Purchase Order Consolidator to signify when specific orders are being processed. | ||||
cCalculateOnPaidLateAmounts | CPAD | char | NONE | NONE |
An option that specifies whether the system calculates delinquency fees on invoices that are paid after their due dates. The system uses
| ||||
mnPaymentID | PYID | MATH_NUMERIC | NONE | NONE |
A number that the system assigns from Next Numbers to identify and track payment records. | ||||
mnFileLineID | RC5 | MATH_NUMERIC | NONE | NONE |
This field is used to create a unique key within a file and should be used with a next number approach. | ||||
mnBatchRunID | RNID | MATH_NUMERIC | NONE | NONE |
This is an internally assigned number that groups transaction records with a batch header record based on a particular execution of the G/L
| ||||
mnAmountDelinquencyFees | DFEE | MATH_NUMERIC | NONE | NONE |
The total amount of the delinquency fee invoice records (RF). The system displays this information from either the A/R Statistical Summary
| ||||
mnAmntSubjectToFinC | ASLC | MATH_NUMERIC | NONE | NONE |
The sum of the open amount of the invoices on which the delinquency fee is based. | ||||
mnFrgnAmountDelinquencyFees | FFEE | MATH_NUMERIC | NONE | NONE |
The foreign currency amount of a delinquency fee. | ||||
mnFrgnAmntSubjectToFinC | FSLC | MATH_NUMERIC | NONE | NONE |
The sum of the past-due open invoices in the currency specified in the Currency Code field. This amount does not include invoices with
| ||||
mnCurrencyConverRateOv | CRR | MATH_NUMERIC | NONE | NONE |
A number (exchange rate) that a foreign currency amount is multiplied by to calculate a domestic currency amount.
The number in this field
| ||||
cCurrencyMode | CRRM | char | NONE | NONE |
An option that specifies whether the system displays amounts in the domestic or foreign currency.
On
The system displays amounts in the
| ||||
jdDateDueJulian | DDJ | JDEDATE | NONE | NONE |
In Accounts Receivable, the date that the net payment is due.
In Accounts Payable, the date that the payment is due to receive a discount
| ||||
jdDateLastFeeCalculated | LFCJ | JDEDATE | NONE | NONE |
The most recent date on which the fees were calculated. The system uses this date for further fee calculations, by determining the number
| ||||
mnBatchNumber | ICU | MATH_NUMERIC | NONE | NONE |
A number that identifies a group of transactions that the system processes and balances as a unit. When you enter a batch, you can either
| ||||
szPaymentTermsCode01 | PTC | char | NONE | NONE |
A code that specifies the terms of payment, including the percentage of discount available if the invoice is paid by the discount due date.
| ||||
szTaxArea1 | TXA1 | char | NONE | NONE |
A code that identifies a tax or geographic area that has common tax rates and tax authorities. The system validates the code you enter
| ||||
szTaxExplanationCode1 | EXR1 | char | NONE | NONE |
A hard-coded user defined code (00/EX) that controls the algorithm that the system uses to calculate tax and G/L distribution amounts. The
| ||||
cEverestEventPoint01 | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
idGenLong | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cErrorFlag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cCashReceiptTranCode | TYIN | char | OPT | NONE |
A user defined code (03B/TI) that indicates the type of receipt record in the Receipts Header (F03B13) and Receipts Detail (F03B14)
| ||||
cFeesCurrency | ABCO | char | OPT | NONE |
A code that specifies whether to associate the beneficiaries with individual benefit plans. Valid values are:
1 Associate beneficiaries with
|
None |
None |