Skip to main content
Microsoft Dynamics NAV forum
Suggested answer

Sorting cannot be done based on the Amount field(s) in Purchase Header table. [NAV 2018 AU]

editSubscribe (0) ShareShare
ReportReport
Posted on by 240

Hi All,

When I click on any Page ie. [Purchase Invoices (9308)]  and Click on Amount Field  for sort it Gives the Following error

05.png

I am also referring "https://community.dynamics.com/nav/b/navmarkbrummel/posts/tip-56-fix-error-sorting-cannot-be-done-based-on-the-xx-field-s". but It for Own Customized field.

and I having an error on the standard table field. Amount. 

Please Help me with that Issue. 

  • Suggested answer
    Bilal Haider Profile Picture
    Bilal Haider 2 Super User on at
    RE: Sorting cannot be done based on the Amount field(s) in Purchase Header table. [NAV 2018 AU]

    Hi,

    Looks like there is some kind of customization in Purchase Header table. Correct it and If there is no customization then try to replace the Purchase Header table object from a standard DB (of same version) and synchronize schema and then try again.

    Regards,

    Bilal

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Sorting cannot be done based on the Amount field(s) in Purchase Header table. [NAV 2018 AU]

    Hello  - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans