Skip to main content
Solved

Opportunities upload missing Manual Price column


We want to be able to use the file uploader to add parts to an opportunity details. In order for the pricing of the parts to not default back to the parts original value in inventory pricing the Manual Price check box need to be set to True. This column is not available as an option in the upload tab. Can it be added?

 

 

Best answer by benlane25

I would like to notify you that
Acumatica 2023 R1 Update 16 (build 23.116.0019) is now available for download. The issue mentioned in the case has been fixed in the new build.

It’s published in the community and shown up inside Acumatica under the “Apply Updates” page.
https://community.acumatica.com/supported-releases-67/acumatica-2023-r1-update-16-build-23-116-0019-22916
                 
Release Notes:
https://acumatica-builds.s3.amazonaws.com/builds/23.1/ReleaseNotes/Release_Notes_for_Acumatica_23_116_0019.pdf


AC-299922: If a user was uploading lines from an Excel file to the Details tab of the Opportunities (CR304000)
form, the Manual Price column could not be selected as a target column for the data import.

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

9 replies

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

Hi @benlane25 

As long as you have a price in the EXT. Price, it will mark the Manual Price check box. 

 


  • Author
  • Freshman II
  • 7 replies
  • July 10, 2023

I am including Ext. Price. I am importing the 6 columns I listed in that picture above.  


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

Hi @benlane25 

Are you only giving the discount or are you actually changing the price?


  • Author
  • Freshman II
  • 7 replies
  • July 10, 2023

Yes, changing the Unit Price and the Ext. Price and the Discount Amount


  • Author
  • Freshman II
  • 7 replies
  • July 10, 2023
Example upload

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2547 replies
  • August 9, 2023

Hi @benlane25 were you able to find a solution? Thank you!


  • Author
  • Freshman II
  • 7 replies
  • August 9, 2023

.@kandybeatty49  Which version are you on?

 

I have not been able to be successful with the same process so maybe this was something that has been fixed in a newer version? I am on Build 22.106.0015


  • Author
  • Freshman II
  • 7 replies
  • Answer
  • March 22, 2024

I would like to notify you that
Acumatica 2023 R1 Update 16 (build 23.116.0019) is now available for download. The issue mentioned in the case has been fixed in the new build.

It’s published in the community and shown up inside Acumatica under the “Apply Updates” page.
https://community.acumatica.com/supported-releases-67/acumatica-2023-r1-update-16-build-23-116-0019-22916
                 
Release Notes:
https://acumatica-builds.s3.amazonaws.com/builds/23.1/ReleaseNotes/Release_Notes_for_Acumatica_23_116_0019.pdf


AC-299922: If a user was uploading lines from an Excel file to the Details tab of the Opportunities (CR304000)
form, the Manual Price column could not be selected as a target column for the data import.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2547 replies
  • March 22, 2024

Thank you for sharing the solution with the community @benlane25!


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