Edidlinv Batch Generating Wrong Flat File When RTV's With Multiple Tax Rates
Last updated on OCTOBER 03, 2016
Applies to:Oracle Retail Invoice Matching - Version 11.0 and later
Information in this document applies to any platform.
This article will be updated as official patch information becomes available.
Edidlinv batch generating wrong flat file, when Return To Vendor (RTV's) with multiple tax rates is processed.When attempting to upload the same wrong EDI file the following error occurs.
Steps To Recreate:
1. Created an RTV for 3 item, all three items belong to different vat rates.
2. Ship the RTV.
3. Run edidlinv batch, flat file is generated as below:
THEAD00000000020000000001DBMQ AUTH#123451 SUPP 123451 2007112900000000001360121000000001S1 20071129000000 USD000000020000-00000000000001800000-00000000000001152000+000000050000+000000000000 NN Y
TDETL00000000030000000001 100019008 +000000010000-00000000000000360000S 00000000200000000000+00000000000000000000
TDETL00000000040000000001 100019016 +000000020000-00000000000000360000Z 00000000000000000000+00000000000000000000
TDETL00000000050000000001 100019024 +000000020000-00000000000000360000BP 00000000100000000000+00000000000000000000
From the above it is evident that TVAT is being updated as same cost for every line which will lead to error in Retail Invoice Matching (ReIM) while uploading the file.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms