error in equationILLEGAL SYNTAX when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error msg.

(0) Share

Report

Posted on by Carole Collins

260

We received this error when user tried to print from the Payables Transaction Entry Zoom screen and then click on Print. 'Error in equation***ILLEGAL SYNTAX*** '.
This error appears for all users. Go to Inquire>Purch>Trans by vendor>choose vendor and then find a transaction type = inv>click on Document Number>click on Print and that's when you get the error.

We don't believe this is a modified report and the "sa" user also gets the error. Does anyone know what's happening and how to fix it?

*This post is locked for comments

All responses (8)

Answers (1)

Thomas Weaver 125 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

Thanks Carole! This just happened to us and your solution from Microsoft worked perfectly. Tom
Carole Collins 260 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

Open up your PM Blank Document report within Report Writer.

Click on the drop down menu in the toolbox, and select "Calculated Fields"

Click "Tax Heading" and then the "Open" button.

Click the "Constants" tab and then enter 1 n the constant field.

Click on the ) in the True case area, and click add.

This should make the true case end in: "TaxDetailHeading 4 1 )" without the quotes.

We did the above at the suggestion of MS when we opened a ticket and we re-imported the report and it now works.
Community Member Microsoft Employee on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

Can you please verify if the vendor or the document you are selecting includes an apostrophe on any of the string fields? like vendor ID, vendor name, invoice number document number

If so, that maybe breaking the sql instruction generated by the code and breaking the logic

Please let us know
Richard Wheeler 75,730 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

OK, assuming you use a shared reports dictiionary, can you pick one workstation and have it point to the local drive not your shared reports dictionary? Try point someplace where REPORTS.IDC does not even exist. Then print the report.
Carole Collins 260 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

There is no period before or after the form name in any of this flow. We do have some modified forms and I have seen the period before the form name on those screens. It's just not the case on this one?
Richard Wheeler 75,730 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

Are you licensed for Modifier or at least the Client Access Modification? I am wondering if there is some VBA code behind the scenes here. Is this a modified form? Do you see a period period or after the form name in the upper left-hand corner of the screen.
Carole Collins 260 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

I tried that and it doesn't make any difference if I take it off of modified or not.
Verified answer

Richard Wheeler 75,730 on at

Like (0)

Report

Re: error in equation***ILLEGAL SYNTAX*** when we try to print from the Payables Transaction Entry Zoom screen. We go to Inquire$Purch$Transaction by Vendor$choose a vendor$find an invoice$click on Document Number and then on Print and we get the error ms

Go first into Tools->Setup->System->Alternate Forms and Reports and choose the Purchasing Series and Reports and make sure you are not using a modifed version of this report. Most likely you are and there is an error in the report.