Skip to main content
Solved

Can I autoincrement a Project ID on import scenario

  • Apr 29, 2024 8:04 PM UTC
  • 3 replies
  • 150 views
  • Translate All

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

3 replies

Forum|alt.badge.img
  • Author
  • Semi-Pro II
  • Answer
  • May 2, 2024 7:54 PM UTC

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

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • May 2, 2024 8:02 PM UTC

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

Translate

Forum|alt.badge.img+8
  • Semi-Pro I
  • May 2, 2024 10:25 PM UTC

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

 

Translate