• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: workflow

Vendor invoice recording (Part 7)

17 Saturday Jun 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor invoice recording (Part 7)

Tags

invoice, invoice recording, purchase requisition, workflow

A major problem with the invoice process shown in the previous post is that the materials were ordered by Email without a formal process behind. If the manager does not approve the vendor invoice and the purchase of the goods or services, it is often too late to stop or revoke the delivery and the whole purchase.

To avoid such unpleasant situations, the approval steps can already be executed before the goods or services are ordered from the vendor. The Dynamics AX/365 for Operations instrument that supports those early approvals are purchase requisitions, which allow users specifying what they require before things are ordered from vendors. The next screen print summarizes the different steps and responsible persons involved in the example that will be illustrated in the following.

205_p7_0005

The sample process starts with the preparation of the purchase requisition by Nicole Holiday.

Thereafter, a group of purchasing agents has been defined that is responsible for reviewing the purchase requisition to ensure that the requisitions are complete and do not include errors.

The next process step consists of an approval of the manager of the cost center for which the materials are ordered.

Once the cost center manager approved the requisition, the goods can be ordered through the creation of a purchase order.

To ensure that the goods or services arrived, a formal receipt process step has been built in.

The process finally ends with the recording of the vendor invoice. Because of the early approvals and provided that there is no difference between the price and quantity ordered and invoiced, the vendor invoice can automatically be posted. If, on the other hand side, a price or quantity variance exists, an additional approval from the cost center manager is required.

 

Please note that the process steps illustrated above are supported by two different workflows, which can be identified from the next illustration.

205_p7_0007

The next subchapter details the setups required for the implementation of the sample process steps / workflows. Thereafter, the whole process will be illustrated based on an example.

notesign Due to the number of steps and setups involved, only the first three steps of the sample process will be included in this post and the remaining steps will be explained in the next one.

 

Process step 1:
The first process/workflow step starts with the creation of a purchase requisition. As the purchase requisition is created manually, no specific setup is required.

 

Process step 2:
As mentioned above, the second process step consists of a review of the purchase requisition by a group of purchasing employees. This process step is incorporated in Dynamics AX/365 for Operations through the purchase requisition workflow illustrated in the next screen print.

205_p7_0010

The first workflow step (‘Review purchase requisition’) is thereby implemented through the selection of a ‘participant’ assignment type that is linked to a specific user group. For details, please see the next screen print.

205_p7_0015

For the sake of this example, Phyllis and Susan have been promoted to purchasing employees and connected to the user group that is responsible for reviewing the purchase requisitions.

205_p7_0020

 

Process step 3:
The third process/workflow step requires the cost center managers to approve the purchase requisition.

205_p7_0025

This workflow step is assigned to the purchase expenditure reviewer group ‘AppREQ’.

205_p7_0030

Please note that this reviewer group refers to the cost center owners (managers) and consequently requires that a cost center financial dimension is specified with the purchase requisition.

205_p7_0035

 

Example:
Based on the previously setup workflow steps and the following organizational chart, Nicole Holiday prepares a purchase requisition for a software training on behalf of her colleague Susan Burk.

205_p7_0040

205_p7_0045

Because Susan’s employee record is linked to the cost center she works for, the required cost center information is automatically transferred to the purchase requisition. Please note that this transfer is important for the subsequent identification of the approver of the purchase requisition. This is exemplified in the next screen print.

205_p7_0050

After submitting the purchase requisition, the first review task is assigned to all users that are included in the purchase requisition reviewer group.

205_p7_0055

If Phyllis decides to take ownership of the task…

205_p7_0060

… she has to review the requisition and verify that all necessary information have been provided.

205_p7_0065

Once the review step is completed, the next workflow step is assigned to Kevin Cook, the cost center manager of Susan.

205_p7_0070

notesign Please note that the cost center that is assigned to the requester and not to the one of the preparer of the purchase requisition determines the cost center manager that is responsible for approving the purchase requisition.

 

After the cost center manager approves the requisition, …205_p7_0075

… its status changes to approved, which ends the purchase requisition workflow and allows the creation of a purchase order.

205_p7_0080

This workflow step concludes this post. The remaining workflow steps are illustrated in the next post. Till then.

 

Vendor invoice recording (Part 6)

06 Tuesday Jun 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor invoice recording (Part 6)

Tags

invoice, invoice recording, project expense invoice, signing limits, workflow

This post extends the previous one in a way that a project related expense invoice is recorded, which requires an explicit review of the project manager. To realize this, an additional project manager review step (PM review) is included in the invoice workflow. For details, please see the next illustration.

205_p6_0005

Please note that the expenditure reviewer group ‘approver’ has been assigned to the PM review step…

205_p6_0010

… which refers to the project manager as the one that has to review the invoice.

205_p6_0015

To ensure that the workflow can also handle ordinary vendor invoices, the PM review workflow step is setup with an automatic action that completes the PM review step if no project number is provided. In other words, the PM review step is skipped for ordinary invoices.

205_p6_0020

For the illustration of the next example, it is important to note that Susan Burk has been assigned as project manager for the project that is addressed in the vendor invoice.

205_p6_0025

205_p6_0030

With the project number specified in the invoice, the workflow is consequently assigned to the project manager (Susan Burk) after the orderer (Nicole holiday) has reviewed the invoice in a first step.

205_p6_0035

If a project number is not specified, the additional review step is skipped and identical to what has been shown in the previous post.

 

This post ends the section on manually entered expense invoices that need to be reviewed and approved by two or more people.

At this point it can preliminary summarized that the standard Dynamics AX/365 for Operations workflow functionalities appear able to handle a wide variety of expense invoice scenarios. From the author’s perspective, the only thing missing is an overview form that provides more information about the status, the current assignee, etc. of a workflow. That is mainly because the standard workflow history form does – from a finance and accounting perspective – not provide users with sufficient information that can be accessed at a glance.

The next posts will continue this series by showing how to integrate purchase requisitions for expense related invoices, which is also a common scenario in many companies. Till then.

Vendor invoice recording (Part 5)

01 Thursday Jun 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor invoice recording (Part 5)

Tags

invoice, invoice recording, signing limits, workflow

This post builds upon the previous one in a way that Michael Redmond, the account manager, now orders the marketing materials and that the invoice needs to be approved by his line manager Kevin Cook, as exemplified in the following organizational chart.

205_p5_0005new

To realize this, another position hierarchy (LRE Signing 2) has been specified, which includes Kevin Cook as one of the responsible approvers.

205_p5_0010new

This newly setup position hierarchy is then linked to a newly created invoice workflow…

205_p5_0015new

… that is setup in the very same way as the previously used one except for the activation of the workflow, which is based on the condition that employee 000050 (Michael Redmond) is entered in the financial dimension worker field.

205_p5_0020new

After making those modifications, two invoices are recorded. The first one that has Nicole Holiday specified in the financial dimension worker field and a second one that has Martin Redmond specified.

In line with the setup of the position hierarchies and the workers assigned, the correct line managers are always identified as the ones that need to approve those invoices. For details, please have a look at the following screen prints.

205_p5_0025new 205_p5_0030new

From what has been shown in this and the previous post, it can be summarized that the standard application can handle even complex multi-branch signing limit structures even though this requires the setup of separate position hierarchies and invoice workflows.

Another issue that has not been discussed so far is the fact that typically numerous accountants record and initiate the invoice workflow. This results in different workflow originators that are not incorporated into the position hierarchy shown above. To avoid that one has to setup numerous position hierarchies and invoice workflows, one single accountant – in the example Phyllis – can be setup in the position hierarchies. If the very same person is specified as the workflow owner…

205_p5_0035new

…from which the workflow starts, this issue can be overcome.

205_p5_0040new

The next post continues this one by investigating how project related invoices can be incorporated into invoice workflows that make use of signing limits. Till then.

← Older posts
Newer posts →

Microsoft BizApps Deutschland Podcast

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 Artificial Intelligence Bank reconciliation Budgeting Controlling Cost accounting Cost accounting module Cost center accounting customer D365 D365FO Dynamics 365 Dynamics AX Dynamics AX 2012 Electronic reporting Email Environment Fixed asset statement General Ledger journal Global Warming intercompany Inventory Inventory reconciliation invoice invoice recording IOT Management Accounting Management Reporter Modern Finance MS Flow MT940 PowerApps PowerAutomate PowerPlatform Project Project module 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

  • March 2023
  • February 2023
  • 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 575 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...