Skip to main content
Answer

Max Costs Adjustment

  • May 28, 2025
  • 5 replies
  • 58 views

chrislower
Jr Varsity III
Forum|alt.badge.img

Hi everyone,

I’m looking for some advice on how to handle a Max Cost issue in Acumatica related to a bad receipt entry.

Here’s the situation:

  • We use Max Cost for quoting purposes in our system.

  • Unfortunately, one part was received with an incorrect unit cost (~$1,041 instead of ~$45), and this error was not corrected at the time.  Long story short, someone used the wrong part number to order a part and receive. 

  • As a result, our Max Cost is now significantly inflated, and we need to correct this so our quoting reflects the true cost.

I experimented with doing a return on that po receipt, hoping that would purge it from the list of actual costs but that did not seem to do the trick.  

Appreciate the help!

Best answer by chrislower

@rfairchild58 , we are pulling in directly into the quote when a new item is added  through a customization code.  

I was thinking of creating a new UDF/Attribute as Max Costs Override and if that value is null then utilize standard max costs but if a value is present then utilize the “override”.  I assume that is achievable but I have not spoken with my developer yet.  I was hoping there might be an easy fix that was built in, that doesn’t appear to be the case.

 

Thanks, Chris

5 replies

Adelina Basyrova
Acumatica Moderator
Forum|alt.badge.img+1

@chrislower , in the Acumatica core product, the project actuals are updated with the AP documents, so the purchase return should be pushed to AP debit adjustment to update the actuals. However, the integration logic piece can’t be commented.

Thank you!


chrislower
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • June 3, 2025

@AdelinaBasyrova75 Not sure if this still applies, but I am looking at Inventory Max Costs instead of project actuals.  You may be referencing the same thing but wanted to make sure.


rfairchild58
Varsity I
Forum|alt.badge.img+1

How are you retrieving the Max Cost of the item? In my experience you will most likely have to create a workaround for this “bad” receipt.  I have some ideas but need to know how you are pulling the Max cost.


chrislower
Jr Varsity III
Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • Answer
  • June 10, 2025

@rfairchild58 , we are pulling in directly into the quote when a new item is added  through a customization code.  

I was thinking of creating a new UDF/Attribute as Max Costs Override and if that value is null then utilize standard max costs but if a value is present then utilize the “override”.  I assume that is achievable but I have not spoken with my developer yet.  I was hoping there might be an easy fix that was built in, that doesn’t appear to be the case.

 

Thanks, Chris


rfairchild58
Varsity I
Forum|alt.badge.img+1
  • Varsity I
  • June 10, 2025

@chrislower 

 

If you have someone who can do that customization for you, I will agree that your idea solves the problem.