Partial Payments Using Accounting Priority
To book holding amounts based on a priority, each holding distribution code must be assigned an Accounting Priority. When a partial payment is posted, only part of the holding amount will be transferred to the payable amount (proportional to the amount of receivables reduced by the payment). When the holding amount consists of various holding distribution codes with different accounting priorities, the amount to transfer is allocated as follows:
Holding distribution codes associated with the oldest debt are settled first
Within the same debt age, holding distribution codes with a higher accounting priority are booked first. If more than one distribution code shares the same priority, the settlement is distributed among them in proportion to the holding account balance
The above logic is handled by the payment segment FT creation algorithm C1-FTGL-PSAC. As an example of how these rules apply, let's assume an implementation practices cash accounting; i.e. revenue, taxes and other third party liabilities are not recognized until payment is received. Also assume the following distribution codes have been configured:
Holding Distribution Code
Description
Cash Accounting Distribution Code
Accounting Priority
HLD-LPC
Late Payment Charge
R-MISC
10
HLD-RGEN
Revenue - Generation Charge
R-GEN
20
HLD-RDIS
Revenue - Distribution Charge
R-DIST
30
HLD-RTRN
Revenue - Transmission Charge
R-TRAN
30
HLD-THRD
3 rd Party Charges
R-THRD
40
HLD-VAT
VAT
A/P-VAT
90
Assume a customer has an outstanding third party charge with an arrears date of 2/Jan/2009:
Event
GL Accounting
SA's Payoff Balance
Holding Balances
HLD-LPC
HLD-RGEN
HLD-RDIS
HLD-RTRN
HLD-THRD
HLD-VAT
Unpaid Amount
A/R 50
HLD-HRD <45>
HLD-VAT <5>
50
0
0
0
0
(45)
(5)
A bill is created for a customer and the result of the bill's financial transactions (an LPC adjustment in the amount of 10 and a bill segment in the amount of 127) include the following FT GL lines (both financial transactions have an arrears date of 15/Jan/2009):
Event
GL Accounting
SA's Payoff Balance
Holding Balances
HLD-LPC
HLD-RGEN
HLD-RDIS
HLD-RTRN
HLD-THRD
HLD-VAT
Bill segment created
A/R 127
HLD-RGEN <15>
HLD-RDIS <20>
HLD-RTRN <55>
HLD-THRD <10>
HLD-VAT <27>
177
0
(15)
(20)
(55)
(55)
(32)
Adjustment created
A/R 10
HLD-LPC <10>
187
(10)
(15)
(20)
(55)
(55)
(32)
No payment is received prior to the next bill. The result of the next bill's financial transaction (a bill segment in the amount of 100) includes the following FT GL lines (this financial transaction has an arrears date of 16/Feb/2009):
Event
GL Accounting
SA's Payoff Balance
Holding Balances
HLD-LPC
HLD-RGEN
HLD-RDIS
HLD-RTRN
HLD-THRD
HLD-VAT
Bill segment created
A/R 100
HLD-RGEN <15>
HLD- RDIS <20>
HLD- RTRN <45>
HLD- THRD <10>
HLD-VAT <10>
287
(10)
(30)
(40)
(100)
(65)
(42)
The following shows the result if a customer makes a payment on 20/Feb/2009. At payment time we'll build a table of holding amounts by accounting priority and debt age as follows:
Distribution Code & Priority
HLD-LPC
(10)
HLD-RGEN
(20)
HLD-RDIS
(30)
HLD- RTRN
(30)
HLD-THRD
(40)
HLD- VAT
(90)
Debt Age
4 days old
(15)
(20)
(45)
(10)
(10)
36 days old
(10)
(15)
(20)
(55)
(10)
(27)
49 days old
(45)
(5)