Skip to main content
Solved

Can I autoincrement a Project ID on import scenario


Forum|alt.badge.img

I have a very simple Import scenario where I want to create a list of Projects with only 4 columns of data.
ProjectID, ProjectClass, CustomerID, TemplateID

My import scenario works perfectly; IF I pre-populate the “ProjectID” column in the source spreadsheet with a projectID that increments.

Is there a way to have leave that column blank and have the import scenario “automatically auto-increment” the projectID in Acumatica?

 

Best answer by NetAdmin42

Well, I found out that it does not necessarily matter what value you put into that import column.  As long as there is some kind of value there, the import will auto-increment

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 62 replies
  • Answer
  • May 2, 2024

Well, I found out that it does not necessarily matter what value you put into that import column.  As long as there is some kind of value there, the import will auto-increment


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2620 replies
  • May 2, 2024

Thank you for sharing your solution with the community @NetAdmin42!


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • May 2, 2024

@NetAdmin42 The catch is that the number should be unique for each project.

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings