• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: customer

Do you know how to configure number sequences for customer/vendor groups?

28 Tuesday Apr 2020

Posted by Ludwig Reinhard in Miscellaneous

≈ 3 Comments

Tags

customer, group, Number sequence, number sequence by group, Vendor

 

Invoice search AX2012 vs. AX7 (Part 2)

01 Friday Apr 2016

Posted by Ludwig Reinhard in Accounts Receivable

≈ Comments Off on Invoice search AX2012 vs. AX7 (Part 2)

Tags

customer, customer invoice search, invoice, search

Part 2: Invoice search AX7
Now let’s have a look at the invoice search capabilities in the new Dynamics AX 7.

Option 1: Invoice journal inquiry form
The first option available to search for customer invoices is the invoice journal inquiry form. In this form, a new search field has been introduced that does – on first sight – not seem to be able to search for invoices by using wildcards. Example:
EN_120_0100
An alternative to searching for the invoice number through the new search field is using the new filter options illustrated in the next two screen-prints.
EN_120_0105
EN_120_0110
Compared to the AX2012 filter options, those two filters seem inferior, as the use of wildcards is (currently) not possible.

Because of the numerous search results that I received from my prior searches I tried using the advanced filter options in addition …
EN_120_0115
… and noticed that the use of wildcards in the advanced filter form is possible and helps identifying the invoice I am searching for quickly. For details, please have a look at the following two screen-prints. EN_120_0120 EN_120_0125
Note: A major difference and advantage compared to AX2012 is the ability to search for the customer name … EN_120_0130
… and several other criteria in the standard search field available.
EN_120_0131

 

Option 2: Customer list page
An alternative to searching for invoices in the invoice register inquiry form is an invoice search via the “all customers” list page. Searching for invoices via the customer list page follows the same principles as in AX2012. That is, you need to apply an advanced filter first by adding joined table relations…
EN_120_0135
EN_120_0140
…before you can apply the search filter and identify the customer with the respective invoice record.
EN_120_0145
Once you have identified the respective customer account you need to apply a second filter in order to extract the invoice information you are looking for.
EN_120_0150

 

Option 3: Open customer invoice list page
Invoice searches in the open customer invoice list page work the same as in AX2012 except for the way how you enter filters. Please note that this form will show you only open invoices and if the invoice you are searching for is already paid, no invoice is filtered.
EN_120_0155

 

Option 4: Collections window
Searching for a specific customer invoice via the collection windows – note the new AX7 term “aged balances” – is identical to the search in AX2012.
EN_120_0160
That is, you have to use an advanced filter first to get your customer selected …
EN_120_0165
…and then apply a second filter in the collections form for the very customer you have selected.
EN_120_0170

 

Option 5: Customer service form
Searching for customer invoices in the customer service form works exactly as in AX2012.
EN_120_0175
Interestingly, AX7 supports the use of wildcards in the customer service form to identify the customer record … EN_120_0180… and the invoice one is looking for.
EN_120_0185

 

Option 6: Enterprise Portal search functionality
As the Enterprise Portal is not an element of the new AX7 system, searching for invoices through the Enterprise Portal is not possible anymore.

 

Option 7: Enterprise search functionality
What has been said for the Enterprise Portal search also applies for the global enterprise search. That is, as the global enterprise search functionality is not part of the new AX7 version it cannot be used for invoice searches anymore.

 

If you have some additional hints on how to search for customer invoices in AX2012 and/or AX7, feel free to leave a comment on this site to help also other users that might have similar problems. Thank you very much and till next time.

Invoice search AX2012 vs. AX7 (Part 1)

01 Friday Apr 2016

Posted by Ludwig Reinhard in Accounts Receivable

≈ Comments Off on Invoice search AX2012 vs. AX7 (Part 1)

Tags

customer, customer invoice search, invoice, search

Especially employees working in the Sales and/or Accounts Receivable department regularly need to search for customer invoices and related customer payments. Within this post I want to show you different ways how one can search for customer invoices in order to give customers a quick feedback about their invoices and their account status.
This post is separated into two parts. Within the first part I will show you different ways how to search for customer invoices in AX2012. The second part does the same but for the new Dynamics AX7.
Note: The AX7 version used for this post is the so-called RTW (Ready to Web) version that was released on 24. February 2016.

 

Part 1: Invoice search AX2012
For the following illustrations and examples, I will search for customer invoice no. “CIV-000015”.

Option 1: Invoice journal inquiry form
A first option to search for customer invoices is the invoice journal inquiry form available in the Accounts Receivable module.
EN_120_0005
Searching for invoices through this form allows an easy and fast drill down into the customer transactions and the related customer settlements form as exemplified in the next screen-print.
EN_120_0010
Please be aware of the following limitations (disadvantages) of this form:

  • The invoice journal form does not show you customer invoices that have been created through the project module,
  • It is not possible to search for the customer name in this form.

 

Option 2: Customer list page
An alternative option to search for customer invoices is the “all customers” list page.
EN_120_0015
In this form you can make use of the advanced filter options to search for invoice numbers. Please see the next screen-prints for an example.
EN_120_0020
EN_120_0025 EN_120_0030
If you are using the all customers form to search for customer invoices you have to be aware of the following:

  • The invoices you are looking for are not shown in the customer list page directly. You rather need to open the customer transactions window and apply a second filter.
  • An invoice search in the customer list page may not always result in a single outcome. The next screenshot shows you an example where two customer records have been found that include an invoice ending with “*015”.

EN_120_0035
Note: The underlying reason for this search result is a project invoice ending with “015” that has been recorded for another customer. A small modification of the filter applied can help you overcoming this issue. Please see the next screen-print.
EN_120_0036

 

Option 3: Open customer invoice list page
The third option available that allows searching for customer invoices is the open customer invoices form.
EN_120_0040
This form will, however, only show you open invoices. If the invoice is already paid, no invoice is filtered in this form.
EN_120_0045

 

Option 4: Collections window
The fourth option to search for customer invoice is the collections list page. Users can apply advanced filters in this list page similar to the one shown previously for the “all customers” list page (option 2).
EN_120_0050
What has been mentioned for the customer list page above also applies here. That is, your search might result in more than a single customer record and …
EN_120_0055
…you might need making use of a second filter in the collections details form to find the invoice you are looking for.
EN_120_0060
Note: In my example I even had to change the transaction filter via the “show” button to identify the invoice I was looking for as this invoice had already been settled.

 

Option 5: Customer service form
If you are using the Dynamics AX retail features you can alternatively make use of the invoice filter functionalities available in the customer service form of the Call Center module. Please see the next screen-prints for an example.
EN_120_0065 EN_120_0070
Please note that you can easily open the customer invoices through clicking on the hyperlinks provided in this form. Example:
EN_120_0075
Note: The customer service form does not include project invoices as the invoice journal inquiry form shown above (option 1).

 

Option 6: Enterprise Portal search functionality
Another way to search for customer invoices is the invoice journal site available in the Dynamics AX Enterprise Portal.
EN_120_0076
A major advantage of this site are the manifold search options available (please see the next screen-print for details).
EN_120_0077
Please note that the limitations mentioned for the customer service form and invoice journal inquiry form do also apply if you are searching for invoices through this Enterprise Portal site.

 

Option 7: Enterprise search functionality
A final option to search for customer invoices is the so-called global search functionality. Example:
EN_120_0080
The major advantage of this search feature is that you are able to define what you want to search for through an individualized search configuration.
EN_120_0085
Before you are able to make use of this feature you have to make sure that your search queries do have the searchable property activated and that they do not infringe any best practice rule.
EN_120_0090
In addition, a periodic search process interval needs to be setup.
EN_120_0095
Additional information can be for the global search functionality can be found on the following sites: site1, site2.

← Older posts

Communities4Future

Dynamics UserGroup Deutschland

Project Accounting Book – Part 2

Project accounting book

Categories

  • Accounts Payable
  • Accounts Receivable
  • Bank Management
  • Book reviews
  • Budgeting
  • Cost accounting
  • Fixed Assets
  • General Ledger
  • Inventory
  • Management Reporter
  • Miscellaneous
  • Podcast
  • Project
  • Sustainability
  • Uncategorized

Tags

Advanced bank reconciliation Allocations Bank reconciliation Budgeting Controlling Cost accounting Cost accounting module Cost center accounting customer D365 D365FO Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming indirect costs intercompany Inventory Inventory reconciliation invoice invoice recording IOT Management Accounting Management Reporter Modern Finance MS Flow MT940 PowerApps PowerAutomate PowerPlatform Project Project module Purchase Order Resource scheduling Sensor settlement SharePoint Sustainability Sustainability Accounting Tax time recording timesheet Vendor invoice recording Vendor payments WBS workflow

Important Websites

  • Dynamics AX/365FO Links

Legal

  • Disclaimer

Subcribe

  • RSS - Posts
  • RSS - Comments

Enter your email address to follow this blog and receive notifications of new posts by email.

Archives

  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • November 2019
  • October 2019
  • September 2019
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • March 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • August 2016
  • July 2016
  • June 2016
  • May 2016
  • April 2016
  • March 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • October 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • May 2015
  • April 2015
  • March 2015
  • February 2015

Blog at WordPress.com.

  • Follow Following
    • Dynamics 365FO/AX Finance & Controlling
    • Join 569 other followers
    • Already have a WordPress.com account? Log in now.
    • Dynamics 365FO/AX Finance & Controlling
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...