Skip to main content
Answer

Can I autoincrement a Project ID on import scenario

  • April 29, 2024
  • 3 replies
  • 89 views

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

3 replies

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • 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
  • May 2, 2024

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


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

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