The Sales Effective Date on the Sales Order is a standard field. If the Invoice is created from the Sales Order, the Sales Effective Date on the Invoice automatically populates on the day that the Invoice is created and does not populate the value from the Sales Order.
For example, the Sales Order has a Sales Effective Date - May 10, 2022. If the Invoice is created on May 20, 2022, the Sales Effective Date will be populated with the value May 20, 2022.
In order for us to populate it with the value on the Sales Order/'s Sales Effective Date, we need to follow the steps below:
1. Create a Saved Search to get the value of the sales effective date from SO
1. Navigate to Lists > Search > Saved Searches > New
2. Click Transaction
3. Search Title: Enter Title
Example: Sales Effective Date from SO to Inv
4. Click Criteria
5. Click Standard
6. Filters:
Note: Always click Add once Filter selected and adjusted as needed.
1. Select Type
§ Any of: Sales Order
2. Select Main Line
§ Is True
7. Results
§ Field: Sales Effective Date
§ Summary Type: Maximum
8.Available Filters
§ Internal ID : checkmark on Show in Filter Region
Note: Make Save & Run option appear when hover over the arrow-down icon next to the Save button.
2. Create Custom Body Field
1. Navigate to Customization > List, Records and Fields > Transaction Body Fields > New
2. Under Transaction Body Field
○ Label: Sales order Effective Date 1
○ Type: Free-Form Text
○ Store Value: Unchecked
3. Under Applies To
○ Sale: Checked
4. Under Display
○ Subtab: Main
5. Under Validation & Defaulting
○ Select the Saved Search created above
6. Click Save
Lastly, create a Workflow and follow the screenshots below:
Feel free to share us about your thoughts and tips 😊