Skip to main content
Solved

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


rwhetsell77
Freshman II
Forum|alt.badge.img

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

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 
View original
Did this topic help you find an answer to your question?

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

Hi @rwhetsell77 

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


Anacarina Calvo
Pro I
Forum|alt.badge.img+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
Freshman II
Forum|alt.badge.img
  • Author
  • Freshman II
  • 39 replies
  • May 20, 2023

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


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