Skip to main content

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!

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


Terms & ConditionsCookie settings