Last updated on MAY 23, 2017
Applies to:Oracle Retail Invoice Matching - Version 14.0.1 and later
Information in this document applies to any platform.
reimposting batch adjusting amounts incorrectly when header doesn't match detail lines
Make sure you have CURRENCY_COST_DEC as 2 for USD in im_currency_locale.
1- Create an Order
2- Create an obligation (non-merch) for the order header with the below 2 lines
i- component 1 value 234.625
ii- component 2 value 66.2259
Total as 300.8509 USD.
4- Download invoice using edidlinv
5- upload invoice to reim using reimediinvupload
6- Check im_doc_head for the total 300.8509
7- Check im_doc_non_merch for the 2 components with the above values
8- Run reimposting
Reimposting puts 2 warnings in IM_POSTING_DOC_ERRORS:
(A/P Header - total detail amounts) <= balancing tolerance of 1. IM_AP_STAGE_DETAIL entry for TRAN_CODE NMRCH, LINE_TYPE_LOOKUP_CODE MISCELLANEOUS, and SEQ_NO 1002 was adjusted by .01 from the original amount of 234.63.
(A/P Header - total detail amounts) <= balancing tolerance of 1. IM_AP_STAGE_DETAIL entry for TRAN_CODE NMRCH, LINE_TYPE_LOOKUP_CODE MISCELLANEOUS, and SEQ_NO 1002 was adjusted by .02 from the original amount of 234.64.
Obviously in the first line the adjustment is correct of 0.1, but it is added instead of subtracting so the difference grew by 0.2, as per the second line.
As per im_ap_stage_detail the amounts are 234.66 and 66.23
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms