Do Not Create Items
YouTube: How to Disable Item Creation in Import PUV from External File Configuration?
How to Disable Item Creation in Import PUV from External File Configuration?
In this tutorial, we will explore the Do Not Create Items option while importing a purchase voucher from an external file in Logic ERP.
This option allows you to control whether new items should be created automatically during the import process. When enabled, the system will only consider items that already exist in the Item Master.
Open Import Purchase Vouchers from External File
Import Purchase Vouchers from External File → Configuration
Open the Import Purchase Vouchers from External File module.
Click on the Configuration option.
Locate and enable the option labeled as:
"Do Not Create Items"
Save the configuration.
Verify Items in the Excel File
Before importing the purchase voucher, let's check the Excel file containing the purchase voucher details.
The top three items in the Excel sheet are new items.
These items are not currently available in the Item Master.
Search for each item in the Item Master to verify their availability.
Current Setup
As you can see, none of these three items are available in the Item Master.
Therefore, these items will be treated as invalid during the import process.
Import the Purchase Voucher
Return to the Import Purchase Vouchers from External File module and proceed with the import process.
Invalid Document Status
In the Header Details section, the Invalid Doc column displays Yes.
This indicates that the document contains one or more invalid items.
Check Invalid Item Details
Open the Invalid Item Details tab.
Here, you can see all three new items listed as invalid.
The Invalid Remarks column displays the reason:
Item Not Found in Database.
System Behavior
Since Do Not Create Items is enabled:
The system does not create the missing items automatically.
Items that are not available in the Item Master are marked as invalid.
The purchase document cannot be imported until all items are valid.
Allow New Items to Be Created
Now, let's see what happens when the Do Not Create Items option is disabled.
Return to the Configuration option.
Disable Do Not Create Items.
Save the configuration.
Import the Purchase Voucher Again
Import the same purchase voucher once again.
Valid Document Status
In the Header Details section, the Invalid Doc column now displays No.
This indicates that the document contains no invalid items and is ready for import.
The three previously invalid items are now displayed in the Valid Item Details tab.
Import the Document
Proceed with importing the purchase document.
Once the import is completed, open the Purchase Voucher module.
Verify the Imported Purchase Voucher
The imported purchase document is now successfully available in the Purchase Voucher module.
The three new items are also displayed in the imported purchase voucher.
Verify Items in Item Master
Open the Item Master.
Search for the three newly imported items.
As you can see, all three items have been successfully created and are now available in the Item Master.
Key Benefits
Prevents unwanted item creation during import.
Ensures only existing Item Master items are imported when the option is enabled.
Helps identify invalid or missing items before importing the document.
Provides flexibility to automatically create new items when required.
Final Outcome
The Do Not Create Items option provides control over item creation during purchase voucher imports. When enabled, missing items are marked as invalid and are not created automatically. When disabled, new items can be created automatically during the import process.
Last updated