Can the "Sold Since" date in the "Add Items" window be defaulted for a different amount of time?

Userlevel 3

I realize that the “Sold Since” date defaults to three months from the current date:


Is there a way to default this to a different amount of time? A client may want to go back further, say six months, and not have to change this date every time.


Best answer by Anacarina Calvo 18 May 2023, 18:26

View original

3 replies

Userlevel 7
Badge +16

Hi @rwhetsell77 

This would need to be a customization to default to a longer period. The out of the box is 3 months. 

Userlevel 6
Badge +4

Hi @rwhetsell77 
To default the Sold Since date do as follows: 

  • Create a Customization Project
  • Under Screens, use action of Customize Existing Screen and select Sales Orders (SO.30.10.00) 
  • Expand the added screen and go to Fields
  • Use action of Add New Record
    1. On Container, select sitestatusfilter: 1 (Inventory Lookup -> Selected Mode)
    2. Select the checkbox for Field Name HistoryDate
    3. Use action of Add and Close
  • To default the date use formula =DateAdd( date, interval, number ), for example  =DateAdd( Today(), 'd', -30) 
  • Publish the customization 
Userlevel 3

@Anacarina Calvo That’s fantastic! Published, working as expected. Thank you soooo much!


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved