Create Contract Invoices - Print Only issue in NAV 2009

hav

Hi,
I have upgraded a NAV 4 GB database to NAV 2009 R2 GB.

After the upgrade, when i run 'Create Contract Invoices' report from Periodic Activities of Service menu and set 'Invoice to Date' as today on Options tab of request form (Contract Invoicing), select Print Only and click Ok.....it does not show any output.

If i do the same in old database, it shows list of many contracts that expires by the 'Invoice to Date' i enter.
I know that the Service module has been totally changed from earlier version but i am not sure what condition is failing to print the output.

After comparing the report 5984 -Contract Invoicing in NAV 2009 with NAV 4, i noticed that the below line of code skip the record from printing

OnAfterGetRecord()
...........
IF ("Starting Date" = 0D) OR ("Expiration Date" = 0D) THEN
      CurrReport.SKIP;
..............

I have many contract records that has Starting Date set but no Expiration Date.
Does this mean that the contract records are getting skipped due to above condition for expiration date not being set?
Do i need to mandatorily set the Expiration Date for each contract record?
What else is causing the problem?

Please help.

udayrmer

Yes From your above details, you should have expiration Date to your record.

aseigle

Had this problem before. There is a KB article for it.

https://mbs2.microsoft.com/Knowledgebase/kbdisplay.aspx?wtntzsmnwukntmmyvorspqlqqyotvqpuoqxxywvuwmyrznnp

hav

Many thanks aseigle. =D>
I applied the hotfix and it worked well.

Thanks once again.

Regards,
Hemant