Skip to Content
0
Former Member
Jan 11, 2011 at 03:51 PM

Invoicing a contract every year

39 Views

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