Is it possible to view original data which were updated from backend
Respected Experts,
I have an invoice amount 60000.00 prepayment applied 59999.99 (3 prepayments lines in distribution) I DONT KNOW the other 2 prepayment distributions amount except 1 distribution which was -22727.27
When i updated from mentioned update query :
Update AP_INVOICE_DISTRIBUTIONS_ALL
2 Set amount = -22727.28
3 where invoice_id in (82303)
4 and invoice_distribution_id in(503960)
5 AND LINE_TYPE_LOOKUP_CODE = 'PREPAY'
6 and org_id = 84;
Updated successfully distribution should be equal to 60000.00 BUT system randomly added extra amount of 9090.91 in distributions (Other 2 prepayment distribution lines)
Now i want to know that how can i view the previous amounts of other 2 prepayments distribution lines amounts
Why system behave like this any idea ?