Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Syntax error and Creat...

Syntax error and Create a calcuated field for discount

(0) Share

Report

Posted on by Community Member Microsoft Employee

I have a form, SOP Historical Blank Invoice Form, that I have modified. I tried to create a calculated field for the SubTotal Discount. When I tried to print the invoiceI got and error saying I had an Illegeal field, improper syntax.

I deleted the calculated field and am STILL getting the error message. Could someone e-mail me so I could send you the package to look at? I have been going around with this for days.

Mary

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

L Vail 65,271 on at

Like (0)

Report

Re: Syntax error and Create a calcuated field for discount

The error was because the Currency Index and the (C) Currency Index field were both deleted from the report footer. The formula for the (C) Currency Index field used the Currency Index field that previously existed in the Report Footer.

The formula was showing [Not found] for one of the calculation conditions. That is what was causing the error. If you put the Currency Index fields back in the report footer (make them invisible), and then fix the formula in the (C) Currency Index field, you should be good to go.

Kind regards,

Leslie