Skip to main content
Solved

How the system calculate sales price

  • 16 September 2022
  • 5 replies
  • 353 views

Hi All,

I got 1 item that has no customer price class, no customer price, and only 1 base price - 1 carton = 3 usd.

item convert - 1 carton = 3 cans

when I create SO and pick 1 can - it will automatically key unit price = 1usd even though I haven't imported that price.

So it means when I update the sale price for 1 unit, and that item has more than 1 convert, the system will auto calculate the sale price I import to other converts.

Thanks for your advise,

Yên Chi

Best answer by PatrickSchlenker90

Hi @chidao 

maybe this help article will help you → https://help.acumatica.com/(W(138))/Help?ScreenId=ShowWiki&pageid=e0863703-06d1-415e-8e5a-c736fc4a965f

or this video → Kudos to cloud9 ;)

https://www.youtube.com/watch?v=VNh4EvJIA08

 

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

5 replies

PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

  • Author
  • 111 replies
  • September 19, 2022

Thanks @PatrickSchlenker90 so much! This article is really helpful.

The example from the articles said that the system will automatically generate the price of that item has the convert unit

Ex: Current Price: 1 PIECE = $16.60

Create SO has UOM BOX, the system will auto-generate $99.60 ($16.60 x 6) for BOX

So Is there any way we can turn off this auto-generate on the system?

 


PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

Hi @chidao 

i am not sure if i catch what you want to achieve.

If you have different UOM for some stock items, you can create different sales prices in AR202000. So in your case you can create for each UOM separated prices:

1 Piece = 16,60$

1 Box (=6 Pieces) = 90$

 

This is how it explained in https://help.acumatica.com/(W(144))/Help?ScreenId=ShowWiki&pageid=e2309109-4546-4c44-85d9-7b19d03dbd8c


  • Author
  • 111 replies
  • September 19, 2022

Hi @PatrickSchlenker90 ,

Let me make it clear to you.

Currently, on the system, we have only 1 price valid on the current business date ($16.60) and the UOM (PIECE)

In the conversion table of that stock item, we have one box containing 6 pieces

So when we create SO using UOM BOX, the system will auto-generate the unit price of the UOM Box is equal to $99.60 ($16.60 x 6).

But we don't want the system auto to generate like this. Is there any way we can turn it off or change it?

Thanks in advances!


PatrickSchlenker90
Jr Varsity I
Forum|alt.badge.img+1

@chidao 

i don’t know a way to switch this off. The question is: why should  it switched off? Which price should the system use instead of the current implementation? As i mentioned before, you are able to define for the Box UOM another price like you have for the Piece UOM...


Reply


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