• Home
  • About
  • Contact
  • German

Dynamics 365FO/AX Finance & Controlling

Dynamics 365FO/AX Finance & Controlling

Tag Archives: Purchase Order

Challenges for trading companies using the project module

01 Tuesday Mar 2016

Posted by Ludwig Reinhard in Project

≈ 2 Comments

Tags

Inventory valuation, Project module, Purchase Order, Sales order

Using the project management and accounting module in companies that are not primarily operating in the business project area but rather in trade or manufacturing can be beneficial due to the numerous additional analysis options available in the project module. Those advantages do however come at a price especially in regards to a more complex inventory valuation. Within the following, I will illustrate you those difficulties and provide you some hints on how to overcome them.

The starting point for the next illustrations are time and material (T&M) projects that have been setup with profit and loss (P&L) and balance sheet (BS) posting project groups in order to show you the difference in the usage of the one and the other project group.
EN_83_0005
Note: For reasons of simplicity the project with the BS posting is referred to as “WIP” project while the project with the P&L posting is referred to as “ordinary” or “non-WIP” project.

From a financial accounting perspective, the following ledger accounts have been setup.
EN_83_0010
Note: All ledger accounts setup for the “WIP” posting types are Balance Sheet accounts and all ledger accounts setup for the “Cost” posting types are Profit & Loss ledger accounts.

With this setup in place, I created the following two T&M projects that are used for recording an ordinary process cycle of a trading company that starts with the creation of the purchase order and ends with invoicing the customer. This process cycle will be illustrated step-by-step in the subsequent sections.
EN_83_0015

 

Step 1: Create Purchase Order
At the time the purchase order is created, Dynamics AX does not create any inventory / ledger transaction. Yet, depending on the setup of the project module, a so-called item requirement is created that allows you identifying and estimating the forthcoming costs.

 

Step 2: Post product receipt
The next step in my process cycle is recording the product receipt for the items ordered (100 pcs * 10 EUR/pcs).

For the WIP project, Dynamics AX generates the following two vouchers:

  • The voucher highlighted in red color is the one created at the purchase order level and represents the usual inventory product receipt.
  • The second voucher highlighted in blue color represents the project voucher created at the project level. Please note that this voucher directly reduces the company’s inventory and transfers those costs to the WIP ledger account (154600).
    EN_83_0020

For the project with the P&L posting, the following vouchers are generated:

  • The voucher highlighted in red color is the one created at the purchase order level and represents the usual inventory product receipt.
  • The voucher highlighted in yellow color represents the project voucher created at the project level. As you can identify, this voucher directly reduces inventory and posts all costs on the project cost account (540500).EN_83_0025

The next screenshot shows you the inventory value report that was run after the product receipts were posted for the WIP and ordinary T&M project:
EN_83_0030
Note: The first item (“L13100”) was used for the WIP project while the second item (“L13200”) was used for the ordinary T&M project.
What you can identify from the physical inventory section of the inventory value report (highlighted in red color) is the purchase order packing slip transaction that increases inventory.
At the same time, AX created a financial inventory transaction that reduced inventory by the very same amount resulting in an overall inventory quantity and amount of 0.
In other words, even though the items have not been sold / invoiced to the customer, you cannot identify them in your inventory anymore as they are already consumed for your project.

 

Step 3: Post purchase order invoice
The next step in my process cycle is posting the purchase order invoice. This posting generates the following voucher for the WIP and the ordinary T&M project:
EN_83_0035
After the purchase order is invoiced, the inventory value report shows the following outcome: EN_83_0040
As you can identify from the screen-print above there is no inventory left despite the fact that the items have not been shipped / invoiced to the customer.

If the items have not been shipped and invoiced to your customer the question arises how you could identify and report on your inventory?

One possibility to do that is by referring to the project WIP report that is shown in the next screenshot. EN_83_0045
What you can identify from this report is that it works only for the WIP project but not for the ordinary project with P&L posting.

An alternative is the project actual transaction report that allows you flipping between the different project types by changing the project statement focus.
EN_83_0050
Yet, in both cases you only get financial amounts but no quantities. Let’s continue by having a look at what happens if you invoice your customer a part of the items purchased.

 

Step 4: Invoice customer for a bundle of 30 pcs
After the purchase order invoice has been recorded, the customer is invoiced for a part (30 pcs * 100 EUR) of the goods via an ordinary project invoice.

This generates the following voucher for the WIP project:
EN_83_0055

The invoice for the ordinary project results in the following voucher:
EN_83_0060

Given those invoices 70 pcs of the item with a total inventory value of 700 EUR remains. The previously used project WIP report shows this amount for the WIP project but not for the ordinary T&M project.
EN_83_0065
Unfortunately, the second alternative report used before – the project actual transaction report – is not able to show you the inventory value, neither for the WIP, nor for the ordinary project and thus leaves you with the requirement of setting up a specific project related inventory value report.
EN_83_0070

 

Summary:
Overall it can be summarized that the use of the Dynamics AX project module can have several advantages for companies not primarily operating in the business project area. Yet, you have to be aware that recording ordinary purchase and sales orders through this module can cause issues when it comes to inventory valuation especially in situations where products are not purchased and sold within the same accounting period. From this perspective, the use of projects with WIP (Balance Sheet postings) seem to be better suited. Notwithstanding this preference of the author, it seems very likely that your auditors will ask for a specialized inventory value report that you need to create yourself to fulfil reporting / auditing requirements. This (cost) disadvantage needs to be weighed against the potential advantages that the project module offers for trading companies.

Vendor prepayments (4)

22 Friday Jan 2016

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor prepayments (4)

Tags

Dynamics AX, Prepayments, Purchase Order, Tax

Within the previous posts on vendor prepayments the major focus was on tax issues and how to ensure that they are posted correctly when recording vendor prepayments.

In this post I would like to focus on the disclosure of prepayments in a company’s balance sheet and the differentiation between requested and paid prepayment amounts.

That is, at the time vendor prepayment invoices are recorded in AX they do not constitute a right/receivable against the vendor who sent the prepayment invoice, as no exchange of goods/services occurred.

The right (receivable) that your company has against the vendor arises at the time when the payment to the vendor is actually made.

For that reason, some companies prefer separating “requested vendor prepayments” – that do not establish a right against your vendor – from “realized” vendor prepayments that constitute a legal claim against your vendor, as the prepayment invoice has been paid.


Problem:
The problem with the separation of requested from actually made vendor prepayments is that Dynamics AX does not provide a functionality that automatically generates a corresponding voucher at the time the prepayment is made. The following illustration that is based on the examples used in the previous posts explains the issue.
EN_64_0005
What you can identify from the illustration above is that an additional ledger transaction that debits the vendor prepayment account and credits the requested vendor prepayment account is required at the time when the payment of the prepayment invoice is made.

As the standard Dynamics AX features do not support the required Transaction, you can either implement a system modification or use one of the following workarounds.


Workaround (1):
A first option for separating requested from made prepayments is creating a manual General Ledger entry based on an inquiry of the prepayment transactions recorded. The following example demonstrates this procedure.

Example:
For the following illustrations, three purchase orders with prepayment amounts of 5000 EUR (5950 EUR), 2000 EUR (2380 EUR) and 6000 EUR (7140 EUR) are recorded in Dynamics AX. (Note: the amounts included in brackets represent the gross prepayment amounts incl. 19% VAT).

The prepayment invoices are recorded as described in the second post on vendor prepayments by using two service items (“ANZ” and “ANZVERR”) as illustrated in the next screenshot.
EN_64_0010
Please note that the service prepayment items (“ANZ” and “ANZVERR”) are setup with their item number as financial dimension value.
EN_64_0015
Also note that the ledger setup of the first service item differs from the earlier posts and does now refer to the requested prepayment account no. 132201.
EN_64_Extra

The next screen-prints shows the prepayment invoice amounts posted together with the corresponding amounts that have been paid to the vendor.
EN_64_0020 EN_64_0030
Against the background of this summary and the transactions recorded in AX, 6000 EUR need to be transferred from the “requested prepayment” account No. 132201 to the ordinary prepayment account No. 132200. The amount that needs to be transferred can be identified from the sum of the ledger accounts 130850, 132201 and 200100 filtered by the “ANZ” item financial dimension. The next screenshot shows the necessary (manual) ledger transaction that needs to be posted.
EN_64_0040

Result:
After posting the manual prepayment transfer, the trial balance list page shows the following data:
EN_64_0045
In the previous screenshot, the lines highlighted in blue color represent the prepayment invoice payments made to the vendor (6000 EUR net + 1140 EUR VAT = 7140 EUR) that allow a VAT deduction of 1140 EUR. The lines highlighted in yellow color represent the prepayment invoices posted but not paid. For that reason, the VAT related to those invoices cannot be deducted yet.


Workaround (2):
If you do not like creating manual journal entries, you can setup an allocation rule as shown in the next screen-prints that does the calculation and posting job for you.
EN_64_0050 EN_64_0055 EN_64_0060
EN_64_0065
The outcome of the second workaround that uses the allocation rules for making the transfer postings is of course identical to the one realized via the first workaround. Yet, the second workaround allows you repeating the allocation transaction as often as required with almost no effort required. EN_64_0045

This post concludes (for now :-)) the posts on vendor prepayments. I hope you enjoyed the series and look forward to seeing you in the next posts.

Vendor prepayments (3)

17 Sunday Jan 2016

Posted by Ludwig Reinhard in Accounts Payable

≈ Comments Off on Vendor prepayments (3)

Tags

Dynamics AX, Prepayments, Purchase Order, Tax

Within this post I want to introduce you another alternative approach for recording vendor prepayments in Dynamics AX. This approach differs from the ones introduced in the earlier posts by the fact that no prepayment invoice is recorded initially but that the process starts directly with the payment of the prepayment amount requested by the vendor.

Setup
In order to make this approach work, I setup the following new vendor posting profile (“PRE2”).
EN_63_0005
What you can identify from this newly setup posting profile is that the prepayment balance sheet account (“132200”) is entered in the summary account and sales tax prepayment section.

Process
Step 1: Setup purchase order
As mentioned initially, the alternative prepayment process illustrated here does not require entering a prepayment invoice and thus starts with the setup of an ordinary purchase order and the payment of the prepayment amount to the vendor.

Step 2: Pay prepayment amount to vendor
The payment of the prepayment amount to the vendor does not differ from the payments shown in the earlier posts …
EN_63_0010
…except that the newly setup posting profile is used when the prepayment journal voucher check box is activated.
EN_63_0015
The outcome of this payment transaction is the following voucher that debits the prepayment balance sheet account no. 132200 with a total amount of 5000 EUR (5950 EUR – 950 EUR).
EN_63_0020
What you can also identify from the voucher is that only the ordinary (deductible) VAT account is used, which allows deducting this amount directly.

Step 3: Post final vendor invoice
The third and final step requires that you select the prepayment made in the open transaction form of your purchase order.
EN_63_0025
Please note that Dynamics AX indicates that the payment marked for settlement is a prepayment.
EN_63_0030
Once the open transaction is marked for settlement, the final vendor invoice can be posted.
EN_63_0035
After posting the final vendor invoice, the following vouchers result:
EN_63_0040
The first voucher shown in the upper part of the screen-print records the final vendor invoice and posts a total VAT amount of 4370 EUR. This amount is offset by the related voucher created that offsets 950 EUR VAT.

As before, the following illustration summarizes all transactions posted during the prepayment process illustrated.
EN_63_0045
What you can identify from the posting summary is that no temporary (non-deductible) VAT account is recorded. Instead, all VAT transactions are recorded directly on the ordinary (deductible) VAT account no. 130800. For that reason, also this approach ensures that the VAT is posted and deducted at the right time.

 

Summary
A major advantages of the prepayment approach demonstrated in this post is its comparative lower complexity and its conciseness.
Those advantages do, however, come at the price of several disadvantages. The first disadvantage is that you need to generate an internal document for accounting & auditing purposes to document the prepayment made to the vendor. The second disadvantage with this approach is that you cannot directly identify the prepayments that get deducted when posting the final vendor invoice. As a result, marking all prepayment(s) made for settlement with the final vendor invoice needs to be done with utmost care.

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