Ignore Duplicate

YouTube: How to Ignore Duplicate Item Rows in Import PUV Configuration?

How to Ignore Duplicate Item Rows in Import PUV Configuration?

In this tutorial, we will learn how to use the "Ignore Duplicate" feature while importing a Purchase Voucher from an external file in Logic ERP.

This feature allows the system to ignore duplicate item entries during the Purchase Voucher import process and consider only the first occurrence of the item.

---

Access to the Import Configuration

To access the required option:

• Navigate to Import Purchase Vouchers from External File.

• Open the Configuration window.

• Locate the option labeled as:

"Ignore Duplicate"

Before enabling this option, let's first understand its default behavior.

---

Review the Purchase Excel File

Before importing the document, let's review the Purchase Excel file.

As you can see, the file contains duplicate entries for the same item.

For example:

• First entry: Quantity = 50

• Duplicate entry: Quantity = 20

Now, let's import the Purchase Excel file while "Ignore Duplicate" is disabled.

---

Import with Ignore Duplicate Disabled

• Keep "Ignore Duplicate" disabled.

• Proceed with importing the Purchase Excel file.

System Behavior

As you can see, since the "Ignore Duplicate" feature is disabled, the system considers both entries for the same item.

The quantities are added together:

50 + 20 = 70

Therefore, the final quantity for the item is 70.

---

Let's Enable Ignore Duplicate

Now, let's enable the feature and observe the difference.

• Return to the Configuration window.

• Enable "Ignore Duplicate".

• Save the configuration changes.

• Import the same Purchase Excel file again.

System Behavior

• As you can see, after enabling "Ignore Duplicate", the system ignores the duplicate item entry and considers only the first occurrence of the item from the Excel file.

• In this example, the system considers the original quantity of 50 and ignores the duplicate quantity of 20.

---

Verify the Imported Purchase Voucher

Now, let's proceed with importing the document.

• Complete the import process.

• Open the Purchase Voucher module.

• Open the imported Purchase Voucher.

• Verify the item quantity.

Result

As you can see, the purchase details have been successfully reflected in the Purchase Voucher, with the duplicate item entry ignored.

The system considers only the first occurrence of the item, with a quantity of 50.

---

Final Outcome

By enabling "Ignore Duplicate", Logic ERP prevents duplicate item entries from being considered during Purchase Voucher import. This ensures that only the first occurrence of a duplicate item from the external file is included in the imported purchase details.