System Options INCL_DOC_YEAR_FOR_DUPL_CHECK and INCL_DOC_DATE_FOR_DUPL_CHECK Are Not Considered When Creating Single Entry and Group Entry Invoice (Doc ID 2306024.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

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

Symptoms

The system options INCL_DOC_YEAR_FOR_DUPL_CHECK and INCL_DOC_DATE_FOR_DUPL_CHECK values are not taken into consideration while creating single invoice and group entry invoice.

Steps To Recreate:

Scenario#1:

INCL_DOC_YEAR_FOR_DUPL_CHECK=Y, INCL_DOC_DATE_FOR_DUPL_CHECK=N
1.Create a invoice for the PO "110002".
2.Enter Document as INV1111 for supplier 2400 for date in 27-JUL-2017.Give necessary details .Click Save.
3.Create another invoice for the PO "110002".
4.Enter Document  as "INV1111" for supplier 2400 for date in 28-JUL-2017.Give necessary details .Click Save.

Error "Duplicate Vendor Document Number" is displayed.

Scenario#2:

INCL_DOC_YEAR_FOR_DUPL_CHECK =N, INCL_DOC_DATE_FOR_DUPL_CHECK=Y

1.Create a invoice for the PO "110002".

2.Give Document as INV222 for supplier 2400 for date in 27-JUL-2017.Give necessary details .Click Save.

3.Create another invoice for the PO "110002".

4.Give Document as "INV222" for supplier 2400 for date in 28-JUL-2017.Give necessary details. Click Save.

Error "Duplicate Vendor Document Number" is displayed .

Scenario#3:

INCL_DOC_YEAR_FOR_DUPL_CHECK=Y, INCL_DOC_DATE_FOR_DUPL_CHECK=N

1.Create a invoice for the PO "110002".

2.Give Document as INV1111 for supplier 2400 for date in 27-JUL-2016.Give necessary.Click Save.

3.Create another invoice for the PO "110002".

4.Give Document as "INV1111" for supplier 2400 for date in 27-JUL-2017.Give necessary details. Click Save.

Error "Duplicate Vendor Document Number" and "Document date is Invalid" is displayed .

Cause

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