Skip to main content
Solved

Tracking of Inventory ID Default Price (Daily)

  • October 24, 2022
  • 2 replies
  • 147 views

Does anyone have any idea whether Acumatica stores the default price associated with an item and its changes over time or what the default price was on a given day? such as Item 123 was $18.75 on April 15 was changed$ 20.00 on October 2 and changed to $ 22.50 on October 15.  We are trying to compare our default prices versus our unit prices  in our sales orders over a given period of time.  

I have a reasonable plan or solution on how to handle moving forward but I am wondering if I could use the line level fields (Manualprice = 0 and discpct = 0) or something similiar to identify where unit price = defaultprice on old sales orders?

Any ideas and thoughts are welcome

Best answer by Naveen Boga

Hi @hmarambio  Have you configured the Sales Prices like below? 

If yes, it would be easy to track to the details.  If not you can check like below and hope that helps

Manualprice = Unchecked at Line level

Default Price = UnitPrice at line level

Also, check Audit History for the Stock Item screen, when the default price changed and accordingly you can check and get the data from Sales Order Lines

 

 

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

2 replies

Forum|alt.badge.img+1
  • Jr Varsity II
  • 33 replies
  • October 29, 2022

You should try audit but getting access to the underlying tables is hard if not impossible on a SaaS deployment. With audit, you could manually track changes to this field.


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3404 replies
  • Answer
  • October 29, 2022

Hi @hmarambio  Have you configured the Sales Prices like below? 

If yes, it would be easy to track to the details.  If not you can check like below and hope that helps

Manualprice = Unchecked at Line level

Default Price = UnitPrice at line level

Also, check Audit History for the Stock Item screen, when the default price changed and accordingly you can check and get the data from Sales Order Lines

 

 


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