Overwrite Item Details
YouTube: How to Overwrite Item Details in Import PUV Configuration?
How to Overwrite Item Details in Import PUV Configuration?
In this tutorial, we will learn how to use the "Overwrite Item Details" feature while importing a Purchase Voucher from an external file in Logic ERP.
This feature allows the system to update existing item details with the corresponding values provided in the external file during the import process.
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:
"Overwrite Item Details"
Before enabling this option, let's first understand its default behavior.
Review the Existing Item Details
Before importing the Purchase Voucher, let's review the relevant item in the Item Master.
Open the Item Master.
Search and select the required item.
Check its existing item details.
Current Setup
As you can see, the HSN Code is currently not defined for the relevant item.
Now, let's proceed with importing the Purchase Voucher.
Import the Voucher with the Option Disabled
Keep "Overwrite Item Details" disabled.
Import the Purchase Voucher using the external Excel file.
System Behavior
As you can see, the HSN Code provided in the Excel file is visible in the import details.
However, when the document is imported, the system does not overwrite the existing item details in the Item Master.
Let's verify this in the Purchase Voucher module.
Open the imported Purchase Voucher.
Check the HSN Code for the relevant item.
Result
Since "Overwrite Item Details" is disabled, the system does not update the item's existing HSN Code with the value provided in the external file.
Enable Overwrite Item Details
Now, let's enable the feature and observe the difference.
Return to the Import Purchase Vouchers from External File configuration.
Enable "Overwrite Item Details".
Save the configuration changes.
Import the same Excel file again.
Verify the Updated Item Details
Now, let's verify the result in the Purchase Voucher module.
Open the newly imported Purchase Voucher.
Check the HSN Code for the relevant item.
System Behavior
As you can see, the HSN Code has now been successfully overwritten with the value provided in the external Excel file.
The system has updated the existing item details according to the information available in the imported document.
Configuration Summary
Configuration
System Behavior
Overwrite Item Details – Disabled
Existing item details are not overwritten
Overwrite Item Details – Enabled
Existing item details are updated with values from the external file
Final Outcome
By enabling "Overwrite Item Details", Logic ERP can update the existing item details with the corresponding information provided in the external file during Purchase Voucher import. This helps keep item information, such as the HSN Code, synchronized with the imported purchase data.
Last updated