Pick External Bill Number
YouTube: How to Pick the Bill Number from the External File in Import Sale Configuration?
How to Pick the Bill Number from the External File in Import Sale Configuration?
In this tutorial, we will learn how to use the "Pick External Bill Number" option while importing Sale Bills from an external file in Logic ERP.
This option allows the system to use the Bill Number provided in the external file instead of automatically assigning the next available Bill Number from the selected Bill Series.
Access to the Import Configuration
Navigate to the Import Sale Bills from External File module.
Open the Configuration window.
Locate the option labeled as:
"Pick External Bill Number"
Before enabling this option, let's first understand its default behavior.
Check the Next Available Bill Number
Let's first verify the next available Bill Number for the selected Bill Series.
Open the Sale Bill module.
Check the next available Bill Number for the relevant Bill Series.
Current Setup
As you can see, the next available Bill Number for this Bill Series is R-129.
Now, let's review the external Excel file that we are going to import.
As you can see, the file contains the following Bill Numbers:
R-500
R-501
R-502
Let's see how the system handles these Bill Numbers when the option is disabled.
Import with Pick External Bill Number Disabled
Return to the Import Sale Bills from External File module.
Keep "Pick External Bill Number" disabled.
Import the Sale Bill Excel file.
System Behavior
The Sale Bills have been imported successfully.
Let's verify the imported documents in the Sale Bill module.
As you can see, the system has not picked the Bill Numbers from the external file.
Instead, it has assigned the next available Bill Numbers from the selected Bill Series.
This means that the Bill Numbers 500, 501 and 502 provided in the Excel file are not used.
Let's Enable Pick External Bill Number
Now, let's enable the option and observe the difference.
Return to the Configuration window.
Enable "Pick External Bill Number".
Save the configuration changes.
Import the same Excel file again.
Verify the Imported Bill Numbers
Now, let's verify the imported Sale Bills in the Sale Bill module.
System Behavior
As you can see, the system has successfully picked the Bill Numbers 9546 and 9547 directly from the external file.
Instead of assigning new Bill Numbers from the selected Bill Series, Logic ERP has used the Bill Numbers provided in the imported file.
Configuration Summary
Pick External Bill Number – Disabled
System assigns the next available Bill Number from the selected Bill Series
Pick External Bill Number – Enabled
System uses the Bill Number provided in the external file
Final Outcome
By enabling "Pick External Bill Number", Logic ERP allows the Bill Number specified in the external file to be used during the Sale Bill import process. This is useful when you need to retain the original Bill Numbers from an external system or source file.
Last updated