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

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Carole Collins 260 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Carole Collins 260 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Richard Wheeler 75,850 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Carole Collins 260 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Thomas Weaver 125 on at

Like (0)

Report

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

Was this reply helpful? Yes No

Community site session details

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.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Community site session details

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 msg.

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

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.