Skip to main content
Solved

Imported Project Quotes error on submit (1st record works)

  • September 6, 2022
  • 12 replies
  • 264 views
  • Translate All

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

Hi,

I am trying to import in project quotes and getting an issue I can't seem to resolve any help will be appreciated.

Autonumbering is turned on for Projects  and turned off for Project Quotes (as migrating old quotes need to keep old numbers)

Import scenario as below:

The quotes import in with no issues or errors, when I try to submit a project quote, that’s been imported and was the first record to be created it works no issues.

If I try to submit any other quotes that have been imported I get the following error

Error: Updating  'Project Quote' record raised at least one error. Please review the errors.

Before I try and submit it has <NEW> in the Project ID as I would expect

After I click Submit

If I go back into the quote it has <new> back in the project ID field but still will not submit.

The Trace shows

Error: Updating  'Project Quote' record raised at least one error. Please review the errors.

'New Project ID' cannot be empty.

 

I have tried to import the quotes in a different order and the first quote created always works as expected all the others fail to submit quote as mentioned above.

If I enter the same information manually it works

Any ideas?

Best answer by gauravsharma96

Acumatica have advised this will be fixed in 2023R1 at the earliest, If you need to import project quotes in the meantime you can log a support case and they have a fix they can deploy after the project quotes have been imported.

View original

12 replies

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

2022R1 -Build 22.110.0018

Translate

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

Hi @gauravsharma96 Is it possible to share the Import scenario XML format, So that we can check and provide you an update

Thanks

Translate

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

Hi @manikantad18 , thanks for looking at this file attached

Translate

DConcannon
Varsity II
Forum|alt.badge.img+2
  • Varsity II
  • September 6, 2022

@gauravsharma96 Just a quick check here, have you verified that the segmented key for PROJECT is also checked for Auto Number? It is strange that the first one works and subsequent ones do not.

Translate

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

@gauravsharma96Just a quick check here, have you verified that the segmented key for PROJECT is also checked for Auto Number? It is strange that the first one works and subsequent ones do not.

Hi

 

Yes have double checked it is very strange first one works then does not

 

 

Translate

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

 

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

HI @gauravsharma96 

Along with the Numbering Sequence, what are your segmented keys and segmented values?

 

 

Translate

gauravsharma96
Jr Varsity III
Forum|alt.badge.img

Thanks for the help everyone, Acumatica have come back and confirmed this as a known issue and investigating it further 

Translate

Kandy Beatty
Captain II
Forum|alt.badge.img+18

Thanks for the help everyone, Acumatica have come back and confirmed this as a known issue and investigating it further 

Thanks for the update. 

Translate

gauravsharma96
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • September 13, 2022

Acumatica have advised this will be fixed in 2023R1 at the earliest, If you need to import project quotes in the meantime you can log a support case and they have a fix they can deploy after the project quotes have been imported.

Translate

Manikanta Dhulipudi
Captain II
Forum|alt.badge.img+16

Acumatica have advised this will be fixed in 2023R1 at the earliest, If you need to import project quotes in the meantime you can log a support case and they have a fix they can deploy after the project quotes have been imported.

Thank you for the update, Really helpful.

Translate

Forum|alt.badge.img
  • Varsity I
  • September 13, 2022

@gauravsharma96 

thanks for the update, that is a disappointing answer. Project quotes are already very very limited in their functionality. Functioning as a landing spot for imports from a dedicated estimating software is the only use I saw for them. 

Translate