Skip to main content
Solved

Document Templates not working as expected with Manual Price flag on Sales Order

  • June 27, 2023
  • 18 replies
  • 416 views
  • Translate All

variuxDavidE
Varsity I
Forum|alt.badge.img

I created a template for adding specific line items to a sales order. When the line items are added, I want the Manual Price flag to be unchecked. I marked the manual price flag as False in the template. However, when the template is applied, the manual price checkbox is marked as true. 

 

Best answer by variuxDavidE

Hi everyone,

I’ve made the GitHub repository for this fix public so the community can benefit from it. This solution addresses the issues with document templates and the Manual Price flag on Sales Orders, and it’s the first in a series of enhancements I’ll be releasing soon.

You can check out the package here:
https://github.com/variuxinc/acumatica-document-template-manualprice-truefalse

I’d love to hear your feedback or any issues you encounter with the package or its functionality. Your input will help make future enhancements even better!

Thank you,
David

View original

18 replies

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • June 27, 2023

Hi @variuxdavid ,

I have tried the same. It works when the Manual Price checkbox is set to false and then changed to true. However, it does not work in reverse.

You can set the checkbox to false and save the template. It should work.

 

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

@jinin It seems like your suggestion is what I was already doing. However, I tried again to validate. The Manual Price checkbox is ALWAYS true regardless of the values set in the template. I also tested the Free Item checkbox, and that one worked perfectly. It seems like this issue only affects the Manual Price checkbox.

 

Translate

jinin
Pro I
Forum|alt.badge.img+12
  • Pro I
  • June 28, 2023

Hi @variuxdavid ,

Yes, I have also checked with a few other fields, and they worked as well.

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@variuxdavid  Yes, It is working for the FREE ITEM and MANUAL DISCOUNT fields but not working for the MANUAL PRICE field.

I recommend submitting a Acumatica support case to ensure that the Acumatica team can incorporate this fix into future builds

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

In case others run into this issue or have any details, here is some more information. I was able to reproduce this issue in the original enviroment:

Acumatica Cloud ERP 2022 R1
Build 22.114.0029 +

And then in a base demo install of:

Acumatica Cloud ERP 2022 R1
Build 22.116.0029

 

I also create a video and posted it for others to get a better idea of this issue.

 

Please let me know if anyone knows a work around for this. I’ll update this forum once I get any updates from Acumatica or otherwise. 

 

 

Translate

Naveen Boga
Captain II
Forum|alt.badge.img+20

@variuxdavid  Thanks a lot for creating the video on Youtube and raising the Acumatica support.

Please share the update with us as soon as you receive the solution from Acumatica.

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • July 10, 2023

Hi @variuxdavid were you able to get a solution from Support? Thank you!

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

Hi @Chris Hackett I can confirm that support responded. However, according to these two emails it is “not a bug” with the statement.

Development has reviewed the issue and was able to confirm that this is not a bug and expected system behavior that Manual Price will stay checked automatically. The order is expected to be copied as is and Manual Price checkbox will prevent Unit Price from being re-defaulted. 

See below:

 

 

I replied to the support agent today with the following

Thank you for the update. The true/false flag is clearly not working as expected. I am confused how this behavior is "expected behavior" when the template preferences are being overridden.

 

What is the proper way to get this escalated or reviewed as a bug?

 

 

 

Translate

dnavasardyan37
Jr Varsity I
Forum|alt.badge.img+4

Hello @variuxdavid 

While creating templates for adding line items to a sales order, it's important to understand that setting Manual Price to False just indicates that you want the system to automatically calculate the price based on the pricing setup, rather than manually entering it.

But if your system settings or configuration has been set up to always enable manual pricing by default on sales orders, then even if you set Manual Price to False in your template, it may still appear as True when you apply the template. This might be happening due to certain default settings or price classes that are set to manually adjust pricing.

I would suggest you to check your configuration and settings for any such defaults. If everything seems correct there, and you're still encountering this issue, it could be a bug. In such a case, it would be best to reach out to Acumatica support for further assistance.

 

Translate

Forum|alt.badge.img
  • Freshman I
  • April 9, 2025

Any update on this Case? I am running into the same issue! I want to just use the inventory ID in the template and then be able to automatically bring in that price on the inventory item. This allows for updates to happen to the item price and never have to update the templet.

 

Many thanks,

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

Any update on this Case? I am running into the same issue! I want to just use the inventory ID in the template and then be able to automatically bring in that price on the inventory item. This allows for updates to happen to the item price and never have to update the templet.

 

Many thanks,

I can confirm the issue still persists on Acumatica Cloud ERP 2024 R1 Build 24.116.0026. We have to uncheck “Manual Price” after adding the item via Document Template

Translate

Forum|alt.badge.img
  • Freshman I
  • April 15, 2025

The issue is still present on 2024 R2 as well

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

Hello @variuxdavid 

While creating templates for adding line items to a sales order, it's important to understand that setting Manual Price to False just indicates that you want the system to automatically calculate the price based on the pricing setup, rather than manually entering it.

But if your system settings or configuration has been set up to always enable manual pricing by default on sales orders, then even if you set Manual Price to False in your template, it may still appear as True when you apply the template. This might be happening due to certain default settings or price classes that are set to manually adjust pricing.

I would suggest you to check your configuration and settings for any such defaults. If everything seems correct there, and you're still encountering this issue, it could be a bug. In such a case, it would be best to reach out to Acumatica support for further assistance.

 

I spent time looking for settings that could be contributing to this. However, I didn’t find any. Did you have a specific setting/screen in mind? According to Acumatica support, this is working as designed (see my previous response from support).

Translate

Forum|alt.badge.img
  • Freshman I
  • April 15, 2025

We are trying to utilize it when creating a sales order. We wanted a shortcut to brining in specific inventory items into a sales order instead of having to look them up individually. We are trying to use the template to just bring in the inventory ID and the Project task that the item is mapped to.

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

​@fkrug I had my dev team create an customization to force the expected behavior. This is an Alpha release, but if you would like access, I can invite you to the github to review. DM me. 

Thanks - David

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

Actually, I made a short demo video showing how it works. If anyone is interested to give it a try they can DM me or contact me at my email or LinkedIn: 

 

Translate

variuxDavidE
Varsity I
Forum|alt.badge.img

Hi everyone,

I’ve made the GitHub repository for this fix public so the community can benefit from it. This solution addresses the issues with document templates and the Manual Price flag on Sales Orders, and it’s the first in a series of enhancements I’ll be releasing soon.

You can check out the package here:
https://github.com/variuxinc/acumatica-document-template-manualprice-truefalse

I’d love to hear your feedback or any issues you encounter with the package or its functionality. Your input will help make future enhancements even better!

Thank you,
David

Translate

Forum|alt.badge.img
  • Freshman I
  • May 2, 2025

Hi everyone,

I’ve made the GitHub repository for this fix public so the community can benefit from it. This solution addresses the issues with document templates and the Manual Price flag on Sales Orders, and it’s the first in a series of enhancements I’ll be releasing soon.

You can check out the package here:
https://github.com/variuxinc/acumatica-document-template-manualprice-truefalse

I’d love to hear your feedback or any issues you encounter with the package or its functionality. Your input will help make future enhancements even better!

Thank you,
David

David, in my initial testing, this has worked just as you have shown it! Thank you for taking the time to develop something for this. 

Translate