Skip to main content
Solved

Stock items - first sale date

  • August 16, 2024
  • 1 reply
  • 18 views

Forum|alt.badge.img

Hi team, is there by default, or has anyone had success customizing a ‘first sale date’ on the stock item profile? This would function as the date of the first sales order released which contained that SKU. 

 

The idea being we could use this to report on product lifecycles. For instance, products are tagged as ‘Launch’ if their first sale date is <12months ago. We would then run a scheduled automation monthly to switch SKUs into the next sales phase at 13 months.

Thanks!

Best answer by dcomerford

Not done it before but should be straight forward

  1. Add a new datetime field to the Item table
  2. Create a GI to show lines on a sales order or invoice where the date time field is not populated on the item
  3. Create a Business Event with condition of Record inserted based on this GI which runs an import scenario to update the datetime field on the item.
View original
Did this topic help you find an answer to your question?

1 reply

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • 643 replies
  • Answer
  • August 16, 2024

Not done it before but should be straight forward

  1. Add a new datetime field to the Item table
  2. Create a GI to show lines on a sales order or invoice where the date time field is not populated on the item
  3. Create a Business Event with condition of Record inserted based on this GI which runs an import scenario to update the datetime field on the item.

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