| Description |
*This issue relates to i21 Help Desk ticket:* [ HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-234198]
*This issue relates to i21 Help Desk ticket:* [ HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-234198]
This issue relates to i21 Help Desk ticket. Click the link below to go to Help Desk ticket.
[HDTN-234198 - Open Clearing Detail report gives inaccurate results|https://helpdesk.irely.com/iRelyi21live//#/HD/Ticket/?ticket=HDTN-234198]
Example - TRA-335
!pastedImage_d148507_0.png|height=437,width=865!
IR-32840 is one of the IRs from the delivery sheet for 1015-19062.
!pastedImage_d148507_1.png|height=739,width=850!
The cost used by IR-32840 is $5.2725
!pastedImage_d148507_2.png|height=422,width=850!
APC is booked at $5.2725
!pastedImage_d148507_3.png|height=251,width=850!
However, TRA is using a cost of $5.85 putting the APC and Inventory out of balance.
!pastedImage_d148507_4.png|height=252,width=850!
Example of problem
# IR-1 (DP) = 1,000 bu x $5
## Dr Inv $5,000
## Cr APC $5,000
# TRA-1 (DP to OS) = 1,000 bu x $6 (current avg cost)
## Cr Inv $6,000
## Dr APC $6,000
# APC is out of balance by $1,000
Acceptance -
# DP to OS transfer should create adj entries for APC for the difference in cost.
# Adj Cost = Cost from DP receipt - current avg cost
Example of fix
# IR-1 (DP) = 1,000 bu x $5
## Dr Inv $5,000
## Cr APC $5,000
# TRA-1 (DP to OS) = 1,000 bu x $6 (current avg cost)
## Cr Inv $6,000
## Dr APC $6,000
## Cr APC $1,000 (adj for the difference in cost)
## Dr Inv Adj $1,000 (adj for the difference in cost)
# APC is in balance
|