AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
Update the Unit Rat...
 
Notifications
Clear all

Questions Update the Unit Rate for Existing Project Templates

 
Everything Else
Last Post by Tim Rodman 2 months ago
2 Posts
2 Users
0 Reactions
299 Views
RSS
Retha
Posts: 12
 Retha
Topic starter
March 6, 2026 6:00 am
(@retha)
Active Member
Joined: 6 years ago

I want to update the Unit Rate for Existing Project Templates.

Update done to screen ID pm208000, Project Template

Only require update to the Revenue Budget Tab

The result is that the Project template is updated with the Revenue budget Project task, but a new Inventory ID is created with the new rate. Hence, I am unable to update the Project Task and Inventory ID combination

Example of import scenario. 

 

Error on import:

Violation of PRIMARY KEY constraint 'PMBudget_PK'. Cannot insert duplicate key in object 'dbo.PMBudget'. 

Any suggestions?

image

 


Topic Tags
Import scenario Project T
1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
March 10, 2026 8:54 pm
(@timrodman)
Famed Member
Joined: 11 years ago

The following worked for me.

 

Here's the Data Source in Excel:

image

 

Here's the setup of the Import Scenario:

image

 

Here's what the Project Templates (PM208000) screen looked like BEFORE running the Import Scenario:

image

 

And here's what the Project Templates (PM208000) screen looked like AFTER running the Import Scenario:

image

Reply
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  Import scenario Project T (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,532 Topics
  • 11 K Posts
  • 29 Online
  • 2,420 Members
Our newest member: Katerina Pawlowski
Latest Post: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

 No online members at the moment

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×