My Oracle Support Banner

Due Date On Invoice is Not Getting Calculated on the Basis of Invoice Terms (Doc ID 2421585.1)

Last updated on JULY 26, 2018

Applies to:

Oracle Retail Invoice Matching - Version 13.2.4 and later
Oracle Retail Merchandising System - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

Due date on Invoice is not getting calculated on the basis of Invoice terms after processing the Return To Vendor(RTV) information.

When RTV is created and shipped, entry made to INVC_HEAD with current date and due date as of sysdate. Even if the terms are of 30 days, and same gets integrated to ReIM.
i.e, if RTV is created on 14th March,
Invoice Date = 14 March
Create Date = 14 March
Due Date = 14 March
Invoice Terms = 30 days


Steps To Recreate:
1. Create a RTV is Retail Merchandising System(RMS) with Supplier terms as 30 days.
2. Approve and Ship it.
3. Entry is made in INV_HEAD table.
4. Check invoice date is same as due date.
5. Run edidlinv batch which generates EDI file.
6. Run reim edi invoice upload batch using the above EDI file.
7. Entry is now made in Retail Invoice Matching System(ReIM) with terms as 30 days but due date as same of invoice creation date.
8. Ideally due date should have been invoice create_date + 30 days.
 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.