Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Unanswered

Added new field to Invoice now need new Restrictions

Posted on by 22,647

Client wants to add Tax Registration and Tax Exempt number from the Cusomer Master table to the SOP Blank Invoice and SOP Blank Quote documents.

I was able to add the Customer Master to the Tables attached to the Invoice and the Quote

I was able to add the required fields and I was able to print them.

When I put the changes into production the users reported the following message

"Inconsistant restrictions/sort expression.  Please add the following restriction 'D02382ListPrice = D02382ListPrice'

So, in the Restrictions I added a new restriction ListPrice that was two constants D02382ListPrice = D02382LIstPrice

Then I tried to print and got a new message - well same message, just different restriction => D00837Payment Term

I have added both to the restrictions and when I try to print the QUOTE the system still presents the same message.

Question: I made the expression as two constants 'string' expressions with the equal sign in the middle.  Should I make the whole expression one string?

What else am I mssing?

  • DexDev Profile Picture
    DexDev 100 on at
    RE: Added new field to Invoice now need new Restrictions

    This needs could not be done by only report writer, you need report writer+dexterity combination for this modfication.

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Added new field to Invoice now need new Restrictions

    Just an update - so the connection of the Customer Master to the RM Sales Header Temp was not a sucess after all.  The report writer was able to allow us to make the change, it allowed me to put the fields onto the report.  But when we attempted to generate the reports in TEST application the system generated the errors mentioned above as well as creating a duplicate key warning when the user attempted to print the Quote.

    After removing the the Customer Master from the SOP Sales Header Temp, the fields were removed from the report the the users were allowed to print the documents as before.

    I was able to allow the Customer Master to be linked to the RM Customer Address Master, getting the same access to the Tax fields stored on the Customer Master Card.

    Question still stands - do I need to find a different means to connecting the Customer Master to the Quote or Invoice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,556 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,625 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans