Delete List Price Job

(0) Share

Report

Posted on by jczarni

Hi and thanks for taking the time to read my question!

I'd like to create a nightly DB job (SQL Server 2016), for a single company, to delete an item's list price if it hasn't been set within 6mo of the last time it was received. I'm hoping somebody has something similar and I don't need to recreate the wheel.

IF Last Received date >= (List Price date + 6mo)

THEN Delete List Price

All responses (2)

Answers (0)

jczarni 5 on at

Like (0)

Report

RE: Delete List Price Job

Looks that way - unfortunately there is no "List Price Date" in any tables related to an inventory item, so I need a trigger and a new table to store dates as well
miguelbeja on at

Like (0)

Report

RE: Delete List Price Job

Hi,

You will need to create the code, not easy to find something already done with the specifics that you want.