Disable printing hardcopy if you print to excel

Hi all,

I tried to print report in excel from NAV, but everytime i print to excel it also prints hardcopy and i dont want that.

How do we stop it or disable it? I tried to debug it and check the code but can’t find anything.

Thank you

Is it the standard report or a customized report ?

Hi there,

It’s a standard report i think… under manufacturing > planning > Reports > stock on hand report


This is not a standard report. To fix this use a command like

IF PrintToExcel THEN

in the OnPreSection of all the section that print

Look at standard report 120 Aged Accounts Receivable for an example of how to do it.

Or just click Preview instead of Print.