Notifications
Announcements
No record found.
Hi All,
Is there a way to get the system to automatically allocate the next number when importing documents such as sales invoices using configuration package?
Thanks
If you leave the No. field blank it should auto-assign that value. Did you try that?
Hi Anita,
Yes it is possible. Fill the excel template with data and just keep the field No. empty. Import the sheet and documents will be created.
Make sure:
No. Series exist and it is mentioned in Sales & Receivables setup e.g. for Sales Orders give value in Orders in Numbering tab of Sales & Receivables setup
Ok thanks but where's the link between header and line files (records)considering we have many invoices in one batch?
I imported sales invoices and one thing I have noticed is that the next number does not get updated after the import, so the system still keeps the old number from manual creation. But interestingly you can reuse the same number - what this means is provided you don't have any unposted sales invoices you can have any number on unposted document and posted invoice will take the next number as per system logic. However I'm not sure if there are other issues and surely other have the same issue
Has anyone imported more than one invoice with autonumbering using configuration packages? I cannot see the logic for this in the structure of the two worksheets generated for header and line tables
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
OussamaSabbouh 3,226
Jainam M. Kothari 2,047 Super User 2025 Season 2
YUN ZHU 1,257 Super User 2025 Season 2
