| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-258926 - AP Clearing Account is out of balance|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-258926]
*Reproduction Steps:*
1. Run Open Clearing Report.
*Issue:*
1. It shows Report vs GL difference as 17.08
!pastedImage_d157705_0.png|height=439,width=1096!
*Expected Result:*
1. APC account should be balanced i.e. GL vs Report balance shold be same.
*Note:*
APC_Result file is also attached which is emailed from scheduled job.
Solution -
#1 Returns will not have cost adjustment. Book the difference in cost between receipt and voucher in the inv adj account.
!pastedImage_d157705_1.png|height=365,width=505!
#2
APC1 fixes
These records have unwanted GL entries. Those should be marked as ysnIsUnposted = 1
!pastedImage_d157705_2.png|height=853,width=507!
All GL entries from the highlighted and below are wrong
!pastedImage_d157705_3.png|height=519,width=1096!
#3 Opening balances are wrongly booked in APC account. This is reversed through GJ. However, it has to be corrected for the transactions for the test scripts to stop returning bad results.
Excel attached
Total wrongly booked in APC
!pastedImage_d157705_4.png|height=451,width=1079!
Example
!pastedImage_d157705_5.png|height=270,width=1142!
This is corrected in a GJ
!pastedImage_d157705_6.png|height=420,width=1133!
To fix this -
* Use APC Conversion account 20002-00-0000
* Correct it in all voucher detail records
* Correct it in all APC GL entries made by the vouchers
* Correct GJ-1 and GL entry. Update the AP Clearing account with the AP Conversion account.
The net of all these fixes will not change the balances of APC and APC Conversion GL accounts.
#4 User created GJ's for balancing AP Clearing at the end of the month.
Reverse these $0.07 to
* 20001-00-0000 AP Clearing
* 20002-00-0000 AP Conversion
|