• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: purchase requisition

Vendor invoice recording (Part 9)

01 Saturday Jul 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ 1 Comment

Tags

invoice, invoice recording, purchase requisition, signing limits, workflow

The purchase requisition and invoice workflows used in the previous post assigned the approval tasks to the cost center manager of the person that requested the goods or services irrespective of the singing limit of that manager.

To incorporate the signing limits into the purchase requisition workflow approval step, I tried to modify this step in a way that it refers to a hierarchy. Unfortunately, this hierarchy selection did not allow me starting the workflow from the requester, as illustrated in the next screen print.

205_p9_0015

Applied to the example that was used in the previous post, the available ‘start from’ selection options do not allow assigning the approval task to Susan’s cost center manager unless Susan would submit the purchase requisition herself.

205_p9_0020

 

Setup Modification A:
To get this issue resolved, the purchase requisition workflow has been setup as a purchase requisition line review workflow, because this line-workflow type allows to be started from the requester. For details, please see the next screen prints.

205_p9_0021 205_p9_0025

notesign In prior versions, the standard purchase requisition workflow could be started from the requester. This option has, however, been removed and as a result, a purchase requisition line-item workflow needs to be used to achieve the same.

To get the line-item workflow running, it must be incorporated into the ordinary purchase requisition workflow. This is achieved through the following setup.

205_p9_0030

 

Example:
In the following, a purchase requisition for a training course with a total value of $10000 is submitted to the workflow. Because of the changes that have been implemented, the approval task is now assigned to the marketing executive Julia because she has a sufficiently large signing limit. For details, please have a look at the following screen prints.

205_p9_0035 205_p9_0040 205_p9_0045

 

Setup Modification B:
In line with the changes that have been made to the purchase requisition approval step, also the invoice review & approval matching step has been modified in a way that it starts from the workflow owner.

205_p9_0060

notesign Similar to what has been shown in the previous posts; Phyllis the accountant has been setup as the workflow owner and has been incorporated into the position hierarchy. For that reason, the correct person that is required for approving the invoice deviations can be identified.

 

Example:
If we continue the example and record a vendor invoice for $10900, that is an invoice with a price deviation of >5%, the review & approval task is directly assigned to Charlie, the president, as he has a sufficiently large signing limit.

205_p9_0070 205_p9_0075

 

 

Summary Expense Related Invoice Workflows:
This post ends the series on expense related vendor invoices. Based on what has been shown in the previous posts, it can be summarized that Dynamics AX/365 for Operations ships with a powerful and flexible workflow engine that can handle various invoice review and approval scenarios.

Setting up the different workflow steps might not always be as easy and straightforward as one can find this in specialized workflow add-on’s to Dynamics AX/365 for Operations. In addition, the previous posts showed that the pending vendor invoice form needs some modifications in order to allow users identifying the current workflow step and responsible at a glance.

Against the background of those ‘disadvantages’, the reader should be able to assess whether those enhancements can be built into Dynamics AX/365 for Operations oneself for the same or a cheaper price than a specialized invoice workflow add-on.

Vendor invoice recording (Part 8)

22 Thursday Jun 2017

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor invoice recording (Part 8)

Tags

invoice, invoice recording, purchase requisition, workflow

This post continues the previous one that ended with the approval of the purchase requisition.

205_p8_0003

 

Process step 4:
After the purchase requisition is approved, the requisition is converted into a purchase order, as illustrated in the next screen prints.

205_p8_0005 205_p8_0010

notesign Dynamics AX/365 for Operations includes a separate workflow for the creation of the purchase order. This workflow is not used here because the creation of purchase orders is not the major focus of this post.

 

Process step 5:
To ensure that the ordered goods or services have been received, a category policy rule for the ordered training courses has been setup, which requires a three-way match and an explicit receipt posting before the vendor invoice can be posted.

205_p8_0015

 

Process step 6:
The last process step is supported by the following invoice workflow.

205_p8_0020

This invoice workflow starts with a verification whether matching differences exist.

205_p8_0025

If no matching differences exist, i.e. if the purchase order, the product receipt and the vendor invoice match, the invoice is posted automatically. Otherwise, a separate invoice review by the cost center manager is required.

Please note that this additional review step refers to the vendor invoice expenditure reviewer group ‘Approver’, which assigns the workflow task to the cost center manager that was responsible for approving the purchase requisition.

205_p8_0030 205_p8_0035

notesign To avoid that small price differences require an explicit review and approval of the cost center manager, a 5% total invoice matching tolerance has been setup, in the AP module parameters form.

205_p8_0040

When setting up this price tolerance, it is important that the ‘post invoice with discrepancies’ parameter is set to ‘allow with warning’. If this is not the case, the cost center manager does not only need to review and approve the workflow step but also needs to manually set the following matching parameter in the invoice matching details form.

205_p8_0041

Because the cost center manager already approves the variance through the workflow, an additional requirement of setting the matching parameter in the invoice matching details form is a duplicate and consequently unnecessary step.

 

Example:
In the example illustrated here, a vendor invoice with a price variance of 8% is recorded.

205_p8_0045

As a result, the workflow does not directly post the invoice but rather assigns it to the cost center manager Kevin Cook for review/approval.

205_p8_0050

Provided that the ‘post invoices with tolerances’ parameter is set to ‘allow with warning’, the invoice is automatically posted, once Kevin completes his review step.

205_p8_0055

Posting the invoice ends the invoice workflow and this post. Within the next post, we will have a look at how signing limits can be incorporated into the different workflows used. Till then.

 

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.

 

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