Hello,
I have been looking on this forum for a solution concerning the invoicing of service contracts every year, but did not find it so far.
The case is: a customer buys an article and every year the article needs to be serviced. For this service he pays u20AC 100,- every year. This service is for 5 years. So every year, at the date he bought the article originally, we have to send the customer an invoice of u20AC 100,-.
I created a query which showing us the service contracts which need to be invoiced that certain day.
SELECT T0.ContractID, T0.CntrcTmplt, T0.CstmrCode, T0.CstmrName, T0.StartDate FROM OCTR T0 WHERE T0.CntrcTmplt = '49.VIP.0002' OR T0.CntrcTmplt = '49.VIP.0002I' AND day(T0.StartDate) = day(getdate()) AND month(T0.StartDate) = month(getdate())
To be sure that the contract is invoiced every year I need some kind of check (using a query). I cannot link the OINV and OCTR table.
Has anyone any experience with such a kind of invoicing and how did you solve it.
Thanks,
Tim