Featured Post

Dynamics GP 2019 is now Released

It is now released, Microsoft Dynamics GP 2019 which moves the system to the modern product life cycle   " Beginning with the October...

Saturday, January 6, 2018

Dynamics GP 2018 - Sorting Options on Inquiry Windows

Another interesting feature that has been introduced with the release of Dynamics GP 2018 is the ability to sort results of the inquiry windows in both; the accounts receivable and the payable. The sorting option has been added to the following inquiry windows:

  • Receivable Transaction by Customer | Inquiry > Sales > Transaction by Customer
  • Receivable Transaction by Document | Inquiry > Sales > Transaction by Document
  • Payable Transaction by Vendor  | Inquiry > Purchasing > Transaction by Vendor
  • Payable Transaction by Document | Inquiry > Purchasing > Transaction by Document





On both of the windows above, the sorting options which are available are:
  • Sort by Type
  • Sort by Document Number
  • Sort by Document Amount
  • Sort by Amount Remaining
  • Sort by Document Date
The most important point to be considered here is that when sorting by the "Document Type", the numerical values in the RM Key table. Document types are

1 – Sale / Invoice
2 – Reserved for scheduled payments
3 – Debit Memo
4 – Finance Charge
5 – Service / Repair
6 – Warranty
7 – Credit Memo
8 – Return
9 – Payment


Furthermore, there are addition options to choose the sorting type, whether it is to be Ascending or Descending.

On the payable module, there are other two inquiry windows which have got new sorting options as illustrated below:




On both windows above, here are the sorting options available:

  • Sort by Document Number
  • Sort by Document Type
  • Sort by Document Amount
  • Sort by Unapplied Amount
  • Sort by Document Date
Another important piece of information is that when sorting by the document type, the inquiry window will sort by the numerical values in the PM key table which are illustrated below:

1 – Invoice
2 – Finance Charge
3 – Misc Charge
4 – Return
5 – Credit Memo
6 – Payment

Again, there is an option to specify whether sorting is to be applied on an Ascending or Descending type.


Further Dynamics GP 2018 features will be illustrated in the upcoming posts.


Best Regards, 
Mahmoud M. AlSaadi

1 comment:

  1. BE SMART AND BECOME RICH IN LESS THAN 3DAYS....It all depends on how fast 
    you can be to get the new PROGRAMMED blank ATM card that is capable of
    hacking into any ATM machine,anywhere in the world. I got to know about 
    this BLANK ATM CARD when I was searching for job online about a month 
    ago..It has really changed my life for good and now I can say I'm rich and 
    I can never be poor again. The least money I get in a day with it is about 
    $50,000.(fifty thousand USD) Every now and then I keeping pumping money 
    into my account. Though is illegal,there is no risk of being caught 
    ,because it has been programmed in such a way that it is not traceable,it 
    also has a technique that makes it impossible for the CCTVs to detect 
    you..For details on how to get yours today, email the hackers on : (
    atmmachinehackers1@gmail.com ). Tell your 
    loved once too, and start to live large. That's the simple testimony of how 
    my life changed for good...Love you all ...the email address again is ;
    atmmachinehackers1@gmail.com

    ReplyDelete