SAP B1 -Duplicate Invoice Entries

[denisecechini]

Our SAP B1 is not checking for duplicate invoices when we are posting invoices from vendors. We now have had several duplicate entries that all have the same invoice number, invoice date and dollar amount.

Doesn't SAP B1 have the ability to check for duplicate invoice entry?

[narayanis]

Hi,

There is a field given vendor reference "NumAtCard" at header level. You can use this field to maintain the vendor invoice reference number and date. SAP B1 handles duplication on this field in following ways: -

1. Data entered here will be disallowed if duplicated irrespective of vendor and financial year.

2. Data entered here will be disallowed if duplicated for the same vendor and in same financial year.

3. If you have any other requirements, you can handle this through TN.

Configuration related to this is available under

Administration - System Initialization - Document Settings - Per Document - A/P Invoice

Please check that. I am not able to share the screen shot due to server constraints.

Hope this helps.