| Description |
This issue relates to i21 Help Desk ticket: [HDTN-239007 - Open Clearing Report: Report Out of Balance with GL|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-239007]
Open Clearing and Open Clearing Details Show total Clearing amount of 2,632,225.23 As of 10/31/19. GL AP Clearing Account 200100-02-000 shows ending balance of 1,868,882.66 as of 10/31/19.
Problem-
# Grain discounts billed twice
# Grain discounts billed more
# Grain discounts not billed. Not available in Add Payables to create voucher.
# Grain discounts partially billed. Not available in Add Payables to create vouchers for the remaining.
# IR has multiple bills. Grain discounts billed to full in all bills
Solution:
* BL should reverse the grain discount APC entries made by IR exactly.
* If the grain discounts are not billed or partially billed, the remaining should show in Add Payables.
Fixes -
# Fix the program
# Find the total dollar amount for the mismatches.
# Do not need a data fix. These are closed periods. Only journal entries can be made.
# Data fix required to add the remaining open grain discounts to Add Payables
#1 Grain discounts billed twice
!pastedImage_d134928_0.png|height=312,width=1484!
#2 Grain discounts billed more
!pastedImage_d134928_1.png|height=66,width=1482!
#3 Grain discounts not billed. Not available in Add Payables to create voucher.
!pastedImage_d134928_2.png|height=559,width=1583!
#4 Grain discounts partially billed. Not available in Add Payables to create vouchers for the remaining.
!pastedImage_d134928_3.png|height=143,width=1567!
#5 IR has multiple bills. Grain discounts billed to full in all bills
!pastedImage_d134928_4.png|height=193,width=1527!
|