• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Monthly Archives: May 2017

Vendor invoice recording (Part 4)

24 Wednesday May 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ 5 Comments

Tags

invoice, invoice recording, signing limits, workflow

In the previous posts, the responsible for approving the vendor invoice was identified by the approver expenditure reviewer group, which was specified in the approval workflow step. For details, please see the next screen-print.

205_p4_0005new

While the previously used setup allows the identification of a single invoice approver, it does not help much in companies that make use of hierarchical signing limits.

How hierarchical signing limits can be incorporated into the invoice workflow will consequently be investigated in this post.

The next screen prints show the changes that have been made to the workflow setup in order to get the hierarchical signing limits incorporated.

205_p4_0010new

For that purpose, the second workflow step (singing limit based approval) has been changed and does no longer refer to the assignment type participant but rather to the assignment type hierarchy, as exemplified in the next illustration.

205_p4_0015new

A major issue in regards to the selection of a hierarchical assignment is that the hierarchy can either start from the workflow owner – which refers to a ‘static’ user– or to the workflow originator.

205_p4_0020new

Provided that an accountant – who is not included in the managerial hierarchy of the persons involved in the review and approval process – initiates the workflow, i.e. acts as workflow originator, the line manager of the accountant and not the manager of the orderer would get the approval workflow step assigned. To avoid such wrong assignments, a new position hierarchy (LRE signing) is setup, which starts with the accountant (Phyllis Harris) that records the invoice in Dynamics AX/365 for Operations. The following hierarchical levels are determined by the operative management (Benjamin Martin), the executives (Julia Funderburk) and finally the president of the unit (Charlie Carson). For details, please see the next screen print.

205_p4_0025new

This position hierarchy needs then to be associated with the workflow through the associate hierarchy button shown in the next illustration.

205_p4_0030new

Once this is done, the condition for identifying the correct person to approve the invoice can be specified.

205_p4_0035new

The next setup required consists of specifying the signing rules for the different positions respectively levels. The rules used for the following examples are shown in the next figure.

205_p4_0040new

With the modified workflow and the signing limits in place, an invoice for a total of $47500 is recorded in the pending vendor invoice form by Phyllis, the accountant.

205_p4_0045new

To clearly differentiate the workflow from what has been shown in the previous posts, only the orderer (Nicole Holiday) is entered in the financial dimension worker field. A cost center has, however, not been specified.

205_p4_0050new

Irrespective of whether and which cost center is entered, Dynamics AX/365 for Operations finds the correct approver by successively working through the signing limits that have been setup. The next screen print shows the users that are addressed by the workflow for the $47500 invoice.

205_p4_0055new

As one can identify from the previous illustration, Nicole Holiday is the first user addressed by the workflow in order to review the vendor invoice.

Thereafter, Benjamin Martin, Julia Funderburk and Charlie Carson need to approve the invoice before it can be posted. Even though Benjamin Martin and Julia Funderburk do not have a sufficiently large signing limit, they still need to approve the invoice because of the workflow setup.

warningsignganzklein The successive assignment of the invoice approval can be cut short by defining that only the last user retrieved, that is the one with a sufficiently high signing limit, shall get the task assigned. The next screenshot exemplifies this.

205_p4_0060new

This slight modification in the workflow setup results in a situation where Benjamin Martin and Julia Funderburk are skipped from the approval task for the $47500 invoice, which is directly assigned to the person with the appropriate signing limit (Charlie Carson).

205_p4_0065new

Now let’s modify the example in a way that the materials are ordered by Michael Redmond and need to be approved by his line manger (Kevin Cook).

205_p4_0070new

For that reason, another vendor invoice, this time for $2000 is entered in the vendor invoice workbench. Different from what has been shown before, this time, Michael Redmond – the orderer – is entered in the worker financial dimension field.

205_p4_0075new

After Michael Redmond reviewed the invoice, the invoice approval is assigned to Benjamin Martin and not Kevin Cook, which can be identified from the next screen print.

205_p4_0080new

The underlying reason for this outcome is the position hierarchy that has been assigned to the workflow and which does not include Kevin Cook. For details, see further above.

At this point, one might think to simply add Kevin Cook in the signing position hierarchy. The major problem with this approach is that Dynamics AX/365 for Operations currently only allows a single relationship between the different positions included in the hierarchy. In other words, position hierarchies that include more than a single branch, such as for Kevin Cook (the sales manager) and Benjamin Martin, (the marketing manager) that both report to Julia Funderburk, (the marketing executive), require some additional setups, which will be explained in the next post.

Vendor invoice recording (Part 3)

17 Wednesday May 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ 1 Comment

Tags

invoice, invoice recording, project expense invoice, workflow

This post extends the previous one in a way that this time a project related expense invoice is recorded and posted. The major difference to the example shown in the previous post is related to the expenditure reviewer setup that needs to be made in a separate project distribution tab, which is illustrated in the next screen print.

205_p3_0005

Please note that the setup of the ‘orderer’ expenditure reviewer group is made in the same way that has been shown for ordinary expense related invoices in the organization distributions tab.

The setup of the ‘approver’ expenditure group differs from what has been shown in the previous post because the project manager is now defined as the responsible person for approving the vendor invoice. For details, please see the following screen print.

205_p3_0010

Please note that the sample invoice recorded below is for project no. 000188, which has Kevin Cook assigned as the project manager.

205_p3_0015

Also note that Kevin Cook is not a line level manager of Nicole Holiday who once again ordered the goods. This can be identified from the next organizational chart.

205_p3_0020

Against the background of all this information, another expense invoice for advertising materials is recorded in the pending vendor invoice form.

205_p3_0025

This time, with a project is specified in the project invoice line details tab.

205_p3_0030

The financial dimensions invoice line tab is filled with the same financial dimension values that have been used in the prior post. That is, Nicole Holiday – the worker who ordered the goods – is recorded in the financial worker dimension field and cost center 008 – that has Benjamin Martin assigned as the cost center owner – is recorded in the financial cost center dimension field.

205_p3_0035

Because of the project relationship, the respective project manager (Kevin Cook) and not the cost center owner is identified as the one who has to approve the vendor invoice before it can be posted. The next screen print illustrates this.

205_p3_0040

As the remaining process steps are identical to what has been shown in the previous post, they are skipped here for reasons of brevity.

The next post will build upon this one and illustrate how different signing limits can be incorporated into the vendor invoice workflow. Till then.

Vendor invoice recording (Part 2)

09 Tuesday May 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ 1 Comment

Tags

invoice, invoice recording, workflow

Within this second part of the series on vendor invoice recording, we start with a process where a marketing employee (Nicole Holiday) orders some marketing materials via Email.

After the materials have been received by Nicole Holiday, the vendor invoice arrives and is manually entered in the pending vendor invoice form. After recording all invoice related data, the AP clerk initiates the invoice workflow.

Within the first workflow step, the one who ordered the materials (Nicole Holiday) needs to review the invoice and confirm that all ordered materials arrived in good condition.

Thereafter, the cost center manager (Benjamin Martin) needs to approve the expense amount before it can be posted and paid later on.

The next flowchart summarizes the different process steps that will be investigated in more detail from a Dynamics AX/365 for Operations perspective.

205_p2_0005

The following organizational chart highlights the employees/positions involved in the process in light brown color. Note that this chart will also be used for the subsequent posts on vendor invoice recording.

205_p2_0010

Based on findings that have been made by other Dynamics AX/365 for Operations experts – please see the following post / video – the invoice approval workflow has been set up in a way that makes use of two different expenditure reviewer groups.

The first expenditure reviewer group – denominated as orderer – thereby makes reference to the financial dimension worker and automatically assigns the workflow work-item task to the worker specified in the financial dimension worker field. For details, please see the following setup.

205_p2_0015

warningsignganzklein Getting the invoices correctly assigned to the person who ordered it, requires setting up all employees with their own financial dimension. In addition, each employee must be specified as the owner of this financial dimension because the financial dimension owner defines the person who has to review the vendor invoice. The next screen print shows this setup for Nicole Holiday who ordered the marketing materials.

205_p2_0020

The second expenditure reviewer group – denominated as approver – references the cost center financial dimension.

205_p2_0025

The person responsible for approving the invoice is consequently the one that is setup as the owner of the respective cost center. In the example illustrated, this is Benjamin Martin as the head of cost center 008.

205_p2_0030

warningsignganzklein It is the financial dimension owner and not the manager of the corresponding operating unit that is referenced through the expenditure reviewer group.

warningsignganzklein The way how the setup is made requires that the expense invoice is entered with the financial dimension worker, which defines the orderer who is responsible for verifying that the ordered materials arrived. In addition, the respective cost center needs to be entered because it determines the manager that is responsible for approving the invoice.

 

After describing the elements required for the invoice workflow, let’s have a look at the different workflow steps and the overall setup of the sample workflow used in this post, which is illustrated below.

205_p2_0035

The following two screen prints show the setup of the first workflow step (review invoice) that requires Nicole Holiday reviewing whether all materials have been delivered by the vendor. Please note that Nicole holiday is not directly addressed in the first workflow step but rather the workflow participant ‘orderer’. As the expenditure reviewer group ‘orderer’ links to the financial dimension ‘worker’, the person who ordered the materials needs consequently be entered in the financial dimension worker field at the time the invoice is entered. This will be shown further below.

205_p2_0040 205_p2_0045

The second workflow step – the invoice approval step – is also assigned to a workflow participant. This time, the approver, as illustrated in the next screen prints.

205_p2_0050 205_p2_0055

With this setup in place, let’s record the expense invoice for the marketing materials. The next illustration shows the vendor invoice recording, which makes use of the ‘advertising’ procurement category that defines the ledger account that will be used for posting the invoice.

205_p2_0060

warningsignganzklein Please note that the orderer (Nicole Holiday) is entered in the financial dimension worker field. The person that needs to approve the invoice is determined by the owner of the cost center entered in the cost center financial dimension.

205_p2_0065

After all invoice details are entered, the workflow process is started by the accountant Phyllis Harris. Based on the workflow setup, Nicole Holiday is the first one that gets a workflow item-task assigned. Please see the next screen print.

205_p2_0070

If Nicole opens the assigned work item, she can inspect the invoice recorded by the AP clerk. Provided that everything is ok, she can then complete her review task.

205_p2_0075

warningsignganzklein If Nicole Holiday rejects the review, the invoice will be returned to the AP clerk who can then clarify with the vendor how to deal with the invoice received. Provided that the invoice is unjustified, the AP clerk has the option to recall the workflow and delete the record from the pending vendor invoice form until a new or corrected invoice from the vendor arrives. Another available workflow action for Nicole is to delegate the workflow task to another user who will then become responsible for finalizing the invoice review workflow step.

Once Nicole has completed her review task, the workflow assigns another work-item to Benjamin who has to approve the amount to be spend.

205_p2_0080

Benjamin can similarly choose among different workflow actions, such as approve, reject, etc.

205_p2_0085

warningsignganzklein In addition to approving the invoice Benjamin Martin has the option to reject the invoice, which returns it to the AP clerk – the workflow originator – who can then decide how to proceed. Delegating the approval step assigns the invoice approval to another user. The same applies to the request change workflow action, which allows specifying a user that has to make some changes – for example to the sales tax – before the invoice workflow can continue.

Once Benjamin Martin approved the expense invoice, all workflow steps are completed …
205_p2_0090

… and the invoice becomes available for posting.

205_p2_0095

warningsignganzklein Provided that all invoice details have already been entered in the first place and against the background that the invoice has been reviewed and approved by two different people, it can be posted automatically from the author’s perspective, which can be realized by including an automatic posting step in the workflow. The next screen print illustrates this.

205_p2_0100

Posting the vendor invoice ends this second post on vendor invoice recording. The next posts will successively extend the sample invoice workflow process illustrated here. Till then.

← 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
  • Project
  • Sustainability
  • Uncategorized

Tags

Advanced bank reconciliation Allocations Bank reconciliation Budgeting Controlling Cost accounting module Cost center accounting Cost of Sales Method customer Dynamics AX Dynamics AX 2012 Earned Value Analysis Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming indirect costs intercompany Inventory Inventory reconciliation invoice invoice recording Management Accounting Management Reporter MS Flow MT940 Nature of Expense Method Posting setup PowerApps PowerAutomate PowerPlatform Profit & Loss Statement Project Project controlling Project module Purchase Order Resource scheduling 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

  • 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 551 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...