Solved

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

  • 18 May 2023
  • 3 replies
  • 35 views
rwhetsell77
Rank
Userlevel 3
Badge

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.

icon

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

View original
Regards, Robert Whetsell

3 replies

Kandy Beatty
Rank
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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Anacarina Calvo
Rank
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 
rwhetsell77
Rank
Userlevel 3
Badge

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

Regards, Robert Whetsell

Reply


Terms & ConditionsCookie settings
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