Skip to main content
Answer

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

  • May 18, 2023
  • 3 replies
  • 75 views

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 

3 replies

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

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
  • May 20, 2023

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