Automatic posting of journals

Tags

,

The previous post dealt primarily with the question how the selection and posting of journals can be restricted. Within this post I would like to change the perspective and take a look at a function that allows a periodic posting of a number of journals that have been created.

The “post journals” functionality I refer to here can be found in the General Ledger module in the journal entries section. (In prior Dynamics AX versions it can be found in the periodic General Ledger module section).

As the information that has been provided e.g. on TechNet for the “post journals” functionality is a bit sparse and as several questions in regards to this function have been brought forward recently, I decided summarizing the different setup and processing options in this post.

Note: Please note that the following illustrations and explanations will only refer to posting General Ledger journals. The post journals function is, however, not limited to those kind of journals but can be applied to other journals as well. Please see the following summary.

 

In order to explain the different setup options of the post journals feature, I started setting up some daily General Ledger journals that included either no error (“OK”), some journal lines with errors (“Partly ok”) or only erroneous lines (“Error”). The next screenshot exemplifies the setup of some of those journals used.
EN_127_0005

 

Option 1: Select the journals, and post them
Once all demo journals have been prepared, I opened the post journals window and selected them through the identic button.
EN_127_0010 EN_127_0015
After all journals have been selected, the posting process was initiated by hitting OK button in the post journal form.
EN_127_0020
Result:
The result of this first posting test was that all journals except the ones that contained errors were posted.
EN_127_0025
Newly created journals that did not contain any error remained, however, unposted.

 

Option 2: Select the journals and post them by using a batch job
To get also those journals automatically posted that have been created later on, I deleted all unposted previously generated journals, setup some new ones and selected them as before in the post journals form.
EN_127_0030
This time I changed the posting process by making use of a batch process that runs every some minutes and that does the posting for me.
EN_127_0035
Result:
As before, all journals have been posted except the ones that contained errors.
EN_127_0040
My next step was setting up a new journal (No. 188) that did not contain any error.
EN_127_0045
Because of my posting setup I expected that the batch process will pick up the newly generated journal and post it. Yet, as nothing happened, I finally checked the batch job history window and noticed that the batch job stopped because it could not process the first two journals that contained erroneous lines. Please see the next screen-print.
EN_127_0050

 

Option 3: As option 2 & select the transfer errors checkbox
As processing newly created journals did not work with the previous approach, I repeated the earlier setup steps and created a number of new journals. This time I tried processing them by selecting the ‘transfer errors’ checkboxes (please see below).
EN_127_0055
Result:
As expected, all journals except the ones that contained errors were posted. After setting up a new journal that contained no error I expected that this time the newly created journal will be posted.
EN_127_0060
Yet, unfortunately nothing happened to the newly created journal as the batch job stopped as before after detecting errors.
EN_127_0065
Note: The difference between the 2nd and 3rd setup option is related to the journal that was partly ok. That is, this time all journal lines that did not include an error in the original (partly correct) journal No. 189 were posted and the journal lines that contained errors were transferred to a new journal No. 191 that contains only the erroneous lines.

 

Option 4: As option 3 but with the late selection and transfer errors checkbox activated
Since none of the prior setup options successfully posted the journals that I created subsequently, I changed the setup in the post journals form once again. This time – after selecting the journals that I want to post – the “late selection” and “transfer error” parameters were activated as shown in the next screen-print.
EN_127_0075
Result:
This time all erroneous journals/journal lines remained unposted as before but the journal that I created later on – in my case journal No. 196 – was finally picked up by the batch process and posted automatically as the following screen-prints prove.
EN_127_0080 EN_127_0085
Note: Despite the fact that the newly generated journal was successfully posted, the batch job still continued running (and ending) with errors because of the two journals that contained lines with errors.
EN_127_0090
Even though this issue in not directly related to the journal posting process itself, it can become quite cumbersome, as it might flood your mailbox with error messages / Emails if alerts and/or Email notifications have been setup that control the processing of batch jobs.

Journal restrictions

Tags

, ,

Over the last couple of months I noticed that people often get confused about the setup of journals and posting restrictions. Within this post I aim to shed some light on the following questions that I often came across:

Question 1:
How to ensure that only specific users can select their journals? Example: Only the chief accountant shall be able to create a new General Ledger journal?
Question 2:
How can you prevent others from posting your journal?

In order to answer the first question I setup the following new General Ledger Journal. Please note that this journal is linked to the user group “DOC” that only has a single user assigned to it.
EN_AX7_122_0005
After setting up the new journal, I logged into Dynamics AX with the respective user account (“DOC”) and created a new journal.EN_AX7_122_0010
After logging into Dynamics AX with a different user account I tried to identify the journal that has been created by the chief accountant “DOC”. Yet, after opening the General Ledger journal form I could not identify (and post) the journal because it was setup for the users included in the user group “DOC” only.
EN_AX7_122_0015
Please note that I also could not create a new “DOC” journal, as the “PROF” user account was not included in the respective user group linked to the journal.
EN_AX7_122_0016

For answering the second question, I setup a new journal that I did not link to a user group. Rather than that, I specified that all of my users can only post the journal they created.
EN_AX7_122_0020
After setting up this second journal, I logged into Dynamics AX as chief accountant “DOC” and created a second journal.
EN_AX7_122_0025

After logging off and logging on again with a different user (“PROF”) I could identify the journal that was created by my chief accountant (“DOC”). Yet, once I tried posting the journal I noticed that I could not post it because of the posting restrictions setup.
EN_AX7_122_0030

To sum up, by linking a specific user group in the blocking section of the journal names setup form you can allow only specific people creating and posting specific journals.
The posting restriction feature allows identifying journals that have been created by other users but can prevent other people from posting journals that you created. However, this requires that you specify and select those users that face this restriction as Dynamics AX does by default not restrict any user from posting other people’s journals.

 

Hope that this post shed some light on the setup of journals and posting restrictions and look forward to seeing you in the next posts again.

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (5)

Tags

, , ,

C.6. Sale of goods
Within the last part of this series on the COS & NOE accounting method, the item that has been produced before will be sold for 1000 EUR / pcs through a standard customer sales order shown in the next screen-print.
EN_91neu_0600

The first sales order related voucher is created when the sales order packing slip is posted. In the example used, Dynamics AX created the following voucher:
EN_91neu_0605
As only Balance Sheet accounts are addressed, no influence on the company’s Income Statements can be identified and as a result, no difference between the COS and NOE method arises.

The next and final posting step in my example is related to the sales order invoice. The voucher created when posting the invoice is shown in the next screen-print.
EN_91neu_0610

For reasons of clarity and traceability, the vouchers created when posting the sales order packing slip and sales order invoice, have been summarized in the next illustration.
EN_91neu_0615

  • Similar to the previous chapters, all transactions that offset each other have been highlighted in grey color. In the example used, the packing slip voucher is reversed with the posting of the sales order invoice.
  • All accounts highlighted in green color represent Balance Sheet accounts that debit a receivable account and credit the inventory account that traces the stock reduction due to the sale of the finished item.
  • The first yellow highlighted Income Statement account no. 40500 records the sales revenue of 1000 EUR. This transaction is self-explanatory. The posting on the second Income Statement account no. 50500 on the other hand requires some explanation, as it is used and interpreted differently from a COS and NOE accounting perspective. That is, from a COS perspective the amount recorded on ledger account no. 50500 is included in the cost of sales section and directly influences (reduces) a company’s profit. The reduction in a company’s profit does also occur when the NOE method is applied. Yet, for the NOE method this account represents a stock variation account and consequently needs to be included in the stock variation section of the company’s income statement.

The following financial statements summarize the sales order related transactions resulting from the sales order invoice posting.
EN_91neu_0620

 

D. Summary
Within this series on the COS and NOE accounting method I demonstrated that Dynamics AX can be setup in a way to generate financial statements that follow both accounting methods in parallel. This also holds for situations where other inventory valuation principles, such as standard costs, moving average costs, etc. are used.

Irrespective of those valuation principles and differences thereof, the key to a successful parallel implementation of both principles is a “correct” setup of your chart of accounts and related account structures.

 

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (4)

Tags

, , ,

C.5. Production of goods
Probably the most complex part when it comes to setting up the COS and NOE method in parallel is related to the production of goods. That is mainly because the production posting setup does not only require a setup of the inventory posting matrix but – depending on the parameter setup – also makes use of other accounts that are setup e.g. at the resource level, production category level and in the costing sheet.

Notes:

  • It is not feasible showing you all possible ways for setting up production related postings. Rather than trying to do that I will exemplify the setup based on a simple production item. You can use this basic setup then and apply it to more complex production scenarios.
  • To keep things as simple as possible, I do not create transactions that result in production related variances e.g. due to additional raw material consumption, changed execution times and so on.
  • All production postings illustrated in the following are based on the ledger principle “item and resource” that can be found in the production control parameters form.

Irrespective of the specific ledger setup for production related postings, the basic production process in Dynamics AX follows a three step procedure that begins with the start of a production order, continues with reporting the production order as finished and finally ends with the closing or “costing” of the production order. Those basic production steps and the related postings executed are illustrated in the next diagram, which will be used as a guideline for the subsequent illustration of the production related postings for a production item.
EN_91neu_0500
The structure of the production item I referred to above can be identified in the next screen-print.
EN_91neu_0505
The cost price calculation screen shown above illustrates that the production item (FG2000) consists of two raw materials (RM300 and RM400) that have a cost price of 10 EUR / pcs each. For the production of this good one piece of the first raw material (RM300) and two pieces of the second raw material (RM400) are required. In addition, for the assembly of the product a worker has to work one hour on a machine that has a total cost price of 270 EUR / hour. Based on those data a total production cost price for the production item of 300 EUR / pcs arises.

 

C.5.1. Production step 1: Start
For reasons of simplicity, the production parameters used in this example have been setup in a way that the material consumption (BOM) and route consumption are immediately posted when the production is started. The next screen-print shows the vouchers that have been created through the posting of the BOM and route journals.
EN_91neu_0510
The effect that these vouchers have on the financial statements of the company can be identified in the next illustration.
EN_91neu_0515
From a Balance Sheet perspective, the production start related postings are reflected in changes that can be observed on the WIP accounts no. 13430 and 13440. For the raw material consumption another Balance Sheet account (no. 13150) has been used as the offset account and the offset account for the route consumption has been posted on an Income Statement account (no. 60110).

 

Given that the NOE accounting method typically uses stock variation accounts for each and every change recorded in the company’s stock level, the question arises how the raw material related postings that were executed with the start of the production order can be explained / justified?
I will try answering this question based on the following illustration that shows the recorded accounting transactions in the upper part and the missing “in between” stock variation accounts in pink color in the lower part.
EN_91neu_0520
What becomes obvious from this illustration is that the approach followed here is not fully correct in the sense that the pink transactions highlighted above are missing.
An important question at this point is whether those missing transactions result in a critically wrong illustration of a company’s financial position or not.
From the author’s perspective the “missing” pink transactions are not critically important as they do not distort the financial position of a company that follows the NOE accounting method. That is because the NOE Income Statement does on the one hand side summarize all stock variation transactions into a single line. On the other hand side, one has to remember that the pink highlighted lines add up to zero and do thus have no impact on the company’s financial position.

 

The second transaction I would like to discuss in more detail here is the route related voucher that credits an Income Statement account (no. 60110 “production wages clearing”) and thus affects the profit of the company.
From a NOE accounting perspective this account / transaction can be explained by stating that the clearing account used represents a part of the stock variation of the company. In other words, the increase in semi-finished products for the route consumption part on account no. 13440 is offset by the “stock variation” recorded on account no. 60110. For that reason, the production wage clearing account has been assigned to the stock variation section in the Income Statement that follows the NOE accounting method.
If you take a look at the Income Statement that follows the COS method, you can identify that the very same account no. 60110 has been included in the section that incorporates the production wages recorded before. Irrespective of the whether the name and the section where those accounts have been assigned to is correct, the question that arises how one can justify the assignment of the production wages clearing account there?
From the authors perspective this assignment can be justified by interpreting the transaction recorded on the production wages clearing account as a kind of allocation that shifts a part of the total production wages from the company’s Income Statement into its Balance Sheet.
Stated differently, the production salary / wages posting recorded before immediately reduces a company’s profit. The start of the production on the other hand side creates a tangible value for the company in form of a (semi-) finished product and thus increases its overall wealth. This wealth increase is reflected on account no. 60110 in the company’s Income Statement.

 

C.5.2. Production step 2: Report as Finished (RAF)
The next production step consists of reporting the production as finished. Executing this production step results in the following voucher that debits and credits a Balance Sheet account with the total production cost amount of the item.
EN_91neu_0525
As only Balance Sheet Accounts are used for recording the RAF transaction, no difference between the COS and NOE method arises.
EN_91neu_0530

 

C.5.3. Production step 3: End the production order
The last production step ends the production order and ensures that the realized production costs get posted. Dynamics AX realizes this by reversing and replacing all prior production postings that have been recorded based on planned cost values with postings that are based on realized ones, that is, actual cost values. In the example used, the following costing voucher results.
EN_91neu_0535
Note: The lines that have been selected in the prior screen-print reverse the prior postings that have been created during the first two production steps.
The outcome of the production postings generated can be identified in the financial statements illustrated next.
EN_91neu_0540

Interpretation of the production costing posting created

Lines highlighted in light green color
* The amount of 300 EUR recorded on ledger account 13470 represents the stock increase resulting from the production of the finished good.
* The negative amount of 30 EUR that Dynamics AX credits on ledger account no. 13160 represents the reduction in raw materials that have been used for producing the finished good.

Lines highlighted in yellow color
* The three ledger accounts no. 53420, 53410 and 53170 are Income Statement accounts that – from an overall perspective – offset each other. That is, the total amount posted on those accounts adds up to 0 EUR.
* A first reason why these accounts were setup this way is to get the production costs – of 270 EUR for the production worker and 30 EUR for the raw materials consumed – transferred into the cost accounting module for subsequent cost analysis.
* A second reason for using this specific production posting setup is related to the NOE method as the accounts highlighted in yellow color represent stock variation accounts. The next illustration exemplifies this in detail by showing that those accounts are used “in between” each and every stock transaction.
EN_91neu_0550

Lines highlighted in white resp. orange color
* The lines highlighted in white color in the first screen-print of this section – resp. the orange line in the illustration above – shows the production costing voucher which posts 270 EUR on ledger account 60120 that arose for the assembly of the production item.
* As explained further above, from a NOE perspective, this account represents a stock variation and is consequently included in the cost variation section of the company’s Income Statement following the NOE accounting method.
* For the COS method reference can also be made to the interpretations from production step 1. That is, the amount recorded on ledger account 60120 represents an amount that allocates costs from the company’s Income Statement into its Balance Sheet and offsets the value increase caused by the production of the finished good.

 

To be continued in part (5)

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (3)

Tags

, , ,

After analyzing purchase related transactions in the previous chapter we will now move on and take a look at the other business areas where differences between the COS and NOE accounting method can be identified.

C.2. Inventory adjustments
The next area where such differences can be recognized is related to adjustments of a company’s inventory. Whether or not the COS and NOE accounting method can also be applied in parallel for inventory related adjustment transactions will be investigated next based on the following sample transactions.
EN_91neu_0200
Note: Transfer orders within and between sites/warehouses and other item related transactions that do not generate ledger vouchers will not be analyzed in the following.

For reasons of brevity, no Dynamics AX screen-prints of the created inventory adjustment postings will be provided but rather a summarized overview of the ledger postings created when recording those transactions (please see the next illustration).
EN_91neu_0205

Note: The main accounts required to be setup for the inventory adjustment transactions recorded can be found in the inventory section of the inventory posting matrix shown in the next screenshot.
EN_91neu_0210

Once all four inventory adjustments are posted, the following result can be observed in the company’s financial statements:
EN_91neu_0215
In the prior illustration one can see that the Income Statement that follows the COS method incorporates the inventory profit and inventory loss accounts (no. 53150 & 53160) in the cost of sales section. Whether or not those accounts are better assigned to another Income Statement section – such as the other operating expense section – is not important for the general question whether or not the COS and NOE accounting method can be applied in parallel for inventory adjustment transactions.
What is important though is the question where to incorporate the inventory profit and inventory loss accounts according to the NOE method. Against the background of the explanations provided before, this question can be answered by stating that those accounts need to be incorporated into the stock variation section of the company’s Income Statement. That is because those inventory adjustments represent nothing else than “small” stock adjustment transactions that replace the “large” month-end stock variation transaction required for the NOE method.

 

C.3. Salary/wages & other operating expenses
Within this subchapter I will deal with the question how to record and disclose salary/wage & other operating expense related transactions in the financial statements that follow the COS and NOE accounting method.
The major difference to what has been shown previously is that the separation of the transactions according to their function of expense is now made through referencing the financial cost center dimension as exemplified in the next illustrations.
EN_91neu_0300 EN_91neu_0305
The financial statements resulting from the transactions recorded can be identified in the next screen-print.
EN_91neu_0310
An investigation of the Balance Sheet related transactions does not bring a specific notable outcome to light that deserves special attention. That is because the amounts shown on the other liabilities & accounts payable accounts (no. 22600 and 22500) increase due to the salary/wage & electricity expense transactions recorded.
What is notable though are the account balances shown in the Income Statements for the COS and NOE accounting method. In this respect it can be observed that the COS Income Statement shows the different amounts split up by functions (cost centers) whereas the NOE Income Statement shows those amounts on a summarized basis. Another disadvantage of the NOE method is thus that this method does not provide users with the same level of detailed information as the COS method.

 

C.4. Fixed asset acquisitions & depreciations
Recording and disclosing fixed asset related transactions does – in principle – not differ from the salary/wage & other operating expense transactions shown in the previous chapter. That is because also for fixed asset related transactions a separation of the different transactions through the use of a financial dimension is necessary in order to generate the Income Statement for the COS method.
EN_91neu_0400
Within the example used in this subchapter, several fixed assets have been setup and acquired first (please see the next screen-print) …
EN_91neu_0405
… before the related depreciation expense transactions were recorded.
EN_91neu_0410
The outcome of those transactions can be identified in the next Management Reporter report that shows the fixed asset acquisition and fixed asset accumulated depreciation accounts in the company’s Balance Sheet on the left-hand side.
In the middle part of the report one can identify the Income Statement that follows the COS method. From there it can be observed that the depreciation expense is split up by corporate functions by making use of the recorded financial (cost center) dimensions.
The Income Statement following the NOE method illustrated on the right-side does – on the other hand – summarize those transactions in a single line and does thus not allow an immediate analysis of the expenses recorded.
EN_91neu_0415

 

Intermediate result
In addition to the purchase related item transactions shown in the previous part, it can be summarized that also transactions related to inventory adjustments, salary/wages and other operating expeses as well as fixed asset related transactions can be posted in a way that allows the parallel generation of Income Statements that follow the COS and NOE method.
Please not that you can of course also use separate “function-related” ledger accounts – rather than financial dimensions – for separating the different corporate functions in the COS Income Statement report.
Yet, irrespective of what approach you chose for separating the different corporate functions (financial dimensions or separate ledger accounts), the most important thing that you have to take care of is that a consistent and integrated approach is followed in your company which ensures that the financial reports according to both accounting methods can be generated out of the box.

 

To be continued in part (4)

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (2)

Tags

, , ,

Posting 01 January: Packing slip raw material 1
The packing slip transaction for the purchase of the first raw material results in the following voucher.
EN_91neu_0045
This voucher debits a product receipt account for the purchased material (account no. 13110) and credits the purchase accrual account (no. 22550). As both accounts are Balance Sheet accounts, no effect on the company’s Income Statement can be identified.
The following illustration summarizes the company’s Balance Sheet and its Income Statements according to the COS and NOE method and demonstrates that the packing slip transaction does not affect the company’s profit.

Outcome – after packing slip posting
EN_91neu_0046

 

Posting 02 January: Vendor invoice raw material 1
The next step in the purchase process is related to recording the vendor invoice. The invoice voucher created does first reverse the previous packing slip transactions. At the same time a stock increase (on account no. 13120) and an increase in vendor liabilities (on account no. 22500) is recorded.
Because of the automatic charge code that has been setup, an additional transaction equivalent to the item purchase amount is recorded on the raw material expense and stock variation accounts no. 53130 and 53140. The next two screen-prints summarize the voucher created and show its influence on the company’s financial statements according to the different accounting methods.
EN_91neu_0050

Outcome – after invoice posting
EN_91neu_0051
Note: As the raw material expense and stock variation account are both assigned to the cost of sales section of the company’s Income Statement that follows the COS method, no effect on the company’s profitability, KPI’s, etc. results.

 

Posting 03 January: Packing slip raw material 2
The voucher generated with the packing slip posting for the second raw materials purchase is identical to the one created for the first raw material. For that reason, everything that has been mentioned before for the first raw material purchase also applies here. The next screen-prints detail the resulting packing slip voucher and financial statements.
EN_91neu_0065

Outcome – after packing slip posting
EN_91neu_0066

 

Posting 04 January: Vendor invoice raw material 2
As also the invoice voucher for the second raw material debits and credits the same ledger accounts that have been used when the posting the vendor invoice for the first raw material, reference can be made to what has been mentioned above.
The only major difference between the first and second raw material purchase is reflected in the invoice voucher. That is, for the purchase of the second raw material the slightly higher purchase price of 12 EUR / pcs. results in a stock increase of 12000 EUR that is recorded on the respective ledger account no. 13120.
In line with this stock increase, an equivalent transaction on the raw material expense and stock variation accounts can be identified. For details, please see the postings on accounts no. 53130 and 53140 and the resulting financial statements shown next.
EN_91neu_0070

Outcome – after invoice posting
EN_91neu_0071

 

Posting 05 January: Packing slip vendor return raw material 1
The return of the first raw materials that did not pass our quality tests results in vouchers that are – except for the sign – identical to the one’s recorded before. For that reason, reference is made to the previous explanations.
EN_91neu_0085

Outcome – after packing slip posting
EN_91neu_0086

 

Posting 06 January: Vendor invoice vendor return raw material 1
What has been mentioned for the packing slip voucher generated also applies for the credit note “invoice” voucher. In this respect I would especially like to draw your attention on the parallel raw material and stock variation posting created for the vendor credit note shown in the following screen-print.
EN_91neu_0090
The overall result from all of the transactions recorded within this subsection can be identified in the next screen-print that summarizes the effects of the postings on the company’s financial statements according to the COS and NOE accounting method.

Outcome – after invoice posting
EN_91neu_0091

 

Note:
Dynamics AX uses the so-called running average cost price when issuing goods. With the recording of the vendor return transaction such an issuance occurs. As the running average cost price cannot directly be influenced by users and regularly differs from the price that our vendor credits for the item return, a temporary difference between the stock and stock variation accounts might result.
In the long-term this (temporary) variance will be offset through the transactions recorded when closing the company’s inventory. However, in the short-term an additional transaction on the “purchase expenditure, un-invoiced” resp. “purchase expenditure for product” accounts might occur.
The next screen-prints exemplify such a situation, where the amount credited by the vendor (10 EUR) differs from the running average cost price (11,83 EUR).
EN_91neu_0105
EN_91neu_0110
To ensure an always consistent and correct illustration of the company’s Income Statement according to the COS and NOE method it is thus recommendable to setup…

  • the same ledger accounts in the “cost of purchased materials received” and “purchase expenditure, un-invoiced” section and to setup…
  • the same ledger accounts in the “cost of purchased materials invoiced” and “purchase expenditure for product” section.

Please note that this setup is not obligatory but can make the analysis and interpretation of transactions recorded in Dynamics AX easier. The following screen-print shows the setup just described for the first two account sections mentioned.
EN_91neu_0115

 

Intermediate result
The following illustration summarizes all ledger postings created within this subsection.
EN_91neu_0125
Notes:

  • Transactions that offset each other are highlighted in grey color. Transactions that do only affect the company’s Balance Sheet are highlighted in green color and the Income Statement related transactions required for the NOE accounting method are highlighted in yellow color.
  • In order to follow up the different transactions, the posting types used have been entered in square brackets just below the ledger accounts used.
  • Tax related transactions are disregarded in order to keep things as simple as possible.

 

Based on the transaction summary shown in the previous illustration it can be concluded that the COS and NOE accounting methods can be applied in parallel in standard Dynamics AX. In this respect is has been shown that the shortcoming of the standard AP parameter “post to charge account in ledger” can be overcome by using an automatic charge code.

 

To be continued in part (3)

Parallel accounting according to the “Cost of Sales” and “Nature of Expense” accounting method (1)

Tags

, , ,

International operating companies are often required to prepare financial statements that follow different accounting methods/regulations.

Especially local units of international business conglomerates that operate in a foreign country regularly have to prepare financial statement in one format for local accounting standard setters and in a different format for corporate headquarters.

In the European Union you will often face situations where companies have to prepare financial statements according to the so-called “Cost of Sales” (COS) Method for corporate headquarters and according to the “Nature of Expense Method” (NOE) for local accounting bodies / tax offices.

Within the following subsections I will illustrate how both methods – the COS and the NOE method – can be setup in parallel in Standard Dynamics AX.

Before digging into details, let’s have a look at the major differences between the COS and NOE accounting method.

 

A. Overview major differences between the COS and NOE accounting method
In the European Union (EU) different regulations are applicable when it comes to the use of COS and the NOE accounting method. As an example, the EU directive 2013/34 specifically describes both methods in detail by referring to the “Function of Expense” (COS) and “Nature of Expense” (NOE) method. Similar regulations can be found e.g. in Germany and Austria where legal regulations detail the differences and requirements of both methods. Irrespective of differences in the nomenclature, the major differences between the COS and NOE method can be recognized in the structure of a company’s Income Statement. The next screen-print compares those structures by showing the COS method on the left and the NOE method on the right.
EN_91neu_0005

Despite the summarized comparison of the different Income Statement formats, major differences can be identified in the inventory, human resource and fixed asset sections.

From a finance & controlling perspective, an important difference between the COS and NOE method is related to the data sources required for generating both financial statement formats. That is, while the NOE method does only require data from the accounting department, the COS method also requires cost / management accounting information in order to break down the costs by functions.

The next subsection details the sample data used for the illustrations shown in this post. This section is followed by a in depth specification of setups required in Dynamics AX and their effects on corporate financial statements.

 

B. Sample data
To illustrate you the differences between the COS and NOE method, a number of transactions have been recorded that are based on the following process flow:
EN_91neu_0010
The process flow that you can identify from above starts with the purchase of raw materials, which are later on partly returned to the vendor (due to quality problems). The next transactions are related to inventory adjustments in the warehouse. Thereafter, several transactions originating from the non-operating/administrative areas will be illustrated before the differences in the production process of finished goods will be explained in detail. The process flow finally ends with the investigation of the differences in regards to the sale of the produced goods.

 

C. Process illustrations
In the following, each of the different colored elements shown in the prior process flow diagram will be analyzed and explained in separate sub-chapters.

C.1. Purchase & return of materials
For purchase related material transactions, the major difference between the COS and NOE method is that the COS method does not affect a company’s Income Statement and thus its profit whereas the NOE method initially expenses the complete purchase of the materials. As a result, the company’s profit instantly decreases when the NOE method is applied.

If nothing else happens with the materials (that have been purchased) over the period, the profit reduction is subsequently offset by an adjustment (so-called “stock variation”) transaction. The next screen-print illustrates the differences between both methods just described in an accounting like format.
EN_91neu_0015
What can be identified from the COS method transactions shown on the left-hand side of the prior illustration is that the purchase of materials does only affect the company’s Balance Sheet (BS). The NOE method related transactions do on the other hand side – at least temporarily and depending on changes that occurred to stock levels over the month – also influence a company’s Income Statement (IS).

From what has been said so far, two major disadvantages of the NOE method can be identified.

  • The first disadvantage is that you cannot control and analyze your inventory values within a financial period as the financial inventory values are only correct after the adjustments (“stock adjustment/variation transactions”) have been recorded at the end of the month.
  • The second major disadvantage of the NOE method is that the stock variation postings at the end of the month are typically done on a summarized basis, which prevents you from running detailed item related product Analysis out of the box.

 

Irrespective of the disadvantages mentioned and against the background of the accounting transactions illustrated in the prior screen-prints, the question arises how the COS and NOE method can be aligned with each other in a way to get both Income Statement formats out of Dynamics AX in parallel?

The following illustration tries answering this question by showing you that both accounting methods can be aligned with each other through an additional and parallel expense and stock variation transaction (highlighted in yellow color). Please see the lower part in the next illustration.
EN_91neu_0020
Given that our company creates two purchase orders – one for 2 TEUR and a second one for 3 TEUR – two additional “stock variation transactions” are recorded. The major difference to what has been explained before is thus the number of stock variations recorded. That is, rather than posting a single “large” stock variation transaction at the end of the month, several “small” stock variation transactions are recorded with each and every purchase.

A major advantage of this procedure is that there is no need for a (manual) analysis and recording of stock variations at the end of the month, which frees up some time for doing other things during the often busy month end closing period.

Note: The ledger accounts used for the additional material expense and stock variation postings debit and credit Income Statement accounts. As a result, no effect on a company’s profit arises. For the preparation of an Income Statement according to the COS method this result thus implies that assigning both accounts to the same Income Statement section will not influence a company’s profitability, KPI’s, etc.

 

After investigating how the COS and NOE method can be aligned with each other in a way to generate the transactions required for both accounting methods, the questions arises how to setup Dynamics AX in order to get those additional material expense and stock variation postings automatically recorded? From a “technical” Dynamics AX perspective, the following two options might help getting those additional postings recorded.

Option 1: Activate the “post to charge account in ledger” AP parameter
The first option makes use of the “post to charge account in ledger” parameter that can be found in the Accounts Payable parameters form. Activating this parameter results in an additional charge (expense) and stock variation posting on the ledger accounts specified in the respective sections of the inventory posting matrix illustrated below.
EN_91neu_0025
On first sight, this seems to be exactly what is needed for a parallel use of the COS and NOE method. Yet, a detailed investigation of this functionality shows that the additional posting triggered through the activation of this parameter only applies to ordinary purchase related transactions but not to vendor return transactions. Because of this shortcoming, this first setup option won’t be used in the following.

 

Option 2: Make use of automatic charge codes
Due to the limitations of the first option, an automatic charge code is used instead. The next screen-prints illustrates the setup of this charge code that debits an expense account and credits a stock variation account.
EN_91neu_0030
Once the charge code is setup, it is linked to an automatic charge in order to generate an additional posting equivalent to the one created for the materials purchased. This requires that an automatic charge percentage of 100% is applied, as illustrated in the next screen-print.
EN_91neu_0035

 

In order to enable you tracking what has been mentioned above, the following purchase order related transactions are recorded in a Dynamics AX demo environment:

  • First, on 1st and 2nd January, the packing slip and vendor invoice for the purchase of a first raw material. In total 1000 pcs of the material are purchased for a price of 10 EUR / pcs.
  • Second, on 3rd and 4th January, another 1000 pcs of a second raw material item are purchased. This time the purchase order packing slip is posted with the price the materials were ordered for (10 EUR / pcs) whereas the vendor invoice is recorded with a slightly higher price of 12 EUR / pcs.
  • Finally, on 5th and 6th January, a vendor return order is created for 50 pcs of the first raw material that did not pass quality tests.

The following illustration chronologically summarizes the transactions that will be illustrated and analyzed next.
EN_91neu_0040

 

To be continued in part (2)

Duplicate vendor invoices

Tags

, ,

A general problem when recording and paying vendor invoices is the question how to ensure that invoices are not entered and paid more than once. What sounds like common sense can involve a lot of practical problems especially when it comes to recording and paying expense related vendor invoices that are not linked and tracked through purchase orders.

Imagine the following scenario where an employee orders some advertising material (brochures) for the next trade fair. As the total order value is quite small and given that the costs for the brochures are going to be expensed directly, the advertising material is ordered straightaway via Email without making use of the purchase requisition / purchase order process.

If the vendor sends a copy of the invoice together with the shipped advertising material and the original invoice via Email, an invoice – and copies thereof – arrives several times in a company.

For the sake of this demonstration let’s further assume that the invoice copy is forwarded from the warehouse agent to the employee who ordered the goods. After checking and approving the invoice it is then forwarded to the Accounts Payable department where it is recorded by an AP clerk for the first time in the ERP system with invoice no. “INV1234”.

Let’s continue the scenario by assuming that the original invoice is sent to the Accounts Payable department where another AP clerk forwards the invoice to the marketing manager for approval. If the marketing manager does not coordinate with his employee who placed the order, the invoice might get approved and recorded a second time in the system e.g. with invoice no. “INV 1234”. Please note that this time the invoice is recorded with a blank before the number and as a result, the invoice is not identified as a duplicate invoice by the ERP system, as the invoice numbers “INV1234” and “INV 1234” differ from a technical perspective.

At this point three questions arise:

  1. How to identify that an invoice has been recorded more than once in the system?
  2. How to avoid paying the vendor twice? and
  3. How to avoid double entries of invoices altogether?

Within the following subsections I will try answering those questions by referring to Dynamics AX standard features.

 

Q1: How to identify that an invoice has been recorded more than once in the system?
In order to answer the first question, I will slightly modify the scenario portrayed in the beginning of this post. To understand and follow up the example, it has to be noted that the AP parameter “reject duplicate” invoices is activated. Please see the next screen-print.
EN_125_0001
Next, two invoices are recorded in a vendor invoice journal. The first invoice is entered with invoice number “INV1234” and the second one with invoice number “INV 1234”. That is, the second invoice is recorded with a blank between the term “INV” and the invoice number. Because of that blank, Dynamics AX treats both invoices as distinct records.
EN_125_0025
Referring back to our scenario introduced above – and different from the illustration in the previous screen-print – the first and the second invoice would have been entered by different AP clerks in different vendor invoice journals. Because of a (“human”) typing error, Dynamics AX cannot identify that the same invoice has been entered twice.

Now let’s extend the scenario by recording another two invoices with invoice numbers “INV.1234” and “INV1234.” in the vendor invoice workbench. That is the invoices are entered with a dot in between respectively behind the invoice number. Please see the next screen-print.
EN_125_0030
Due to the blank and dot characters used, the invoice was finally recorded four times in Dynamics AX. This can be identified from the vendor invoice journal form illustrated next. EN_125_0035

After entering those four invoices we will now try identifying the duplicate invoices by making use of the audit policy feature available in the audit workbench module. (In AX2012 the same functionality can be found in the compliance and internal controls module).

The first thing that needs to be setup in this module is a policy rule type that makes use of a predefined query (“vendor invoice”) that is incorporated into standard Dynamics AX. The query type used is “duplicate” as we want to search for invoices that have been entered more than once. (Additional information on the available query types can be found on the following TechNet site).
EN_125_0005
Next, an audit policy needs to be setup and linked to an organization. Please see the next screen-print for an example.
EN_125_0010
The last and most important setup required is the specification of an audit policy rule that identifies the duplicate invoices. Example:
EN_125_0015
The criteria that the audit policy rule uses to identify (potentially) duplicate invoices are entered in the “group by” filter tab. In my example, I specified that invoices with the same amount and date for the same invoice account are potentially duplicate invoices.
EN_125_0020
Please note that the invoice number cannot be used as a criteria, as all the invoice numbers that we entered differ.

Once the audit policy rule is established, a batch job needs to be setup which analyzes all vendor invoices for potentially duplicate records based on the criteria that we specified before.
EN_125_0050
If the invoice batch search process finds duplicate records, it creates a case where it lists the potentially duplicate invoices as illustrated in the next screen-print.

Note: A prerequisite not explicitly mentioned/illustrated here is the setup of an audit type case category in the organization administration module. Details for this setup can be found on the following TechNet site.
EN_125_0055
If you take a close look at the duplicate vendor invoices identified above, you will notice that Dynamics AX only listed the invoice numbers with the dot characters in the audit case window. On the other hand, the invoices that were entered in the vendor invoice journal are not picked up and identified as duplicates.

The underlying reason for this standard behavior is the Dynamics AX policy framework. That is, only those invoices that do – among others – have a source document header and source document line associated are picked up by the audit policy check. As the invoices recorded through vendor invoice journals do not have this association they are not taken into consideration by the audit policy rule.
EN_125_0060

This standard behavior of the audit policy rules does have three major implications:

  • If you want to make use of the audit policy rule functionality, vendor invoices cannot be recorded through vendor invoice journals.
  • Alternatively, a comprehensive system modification needs to be implemented, and
  • Given that users are still allowed entering invoices through vendor invoice journals, manual checks for duplicate vendor invoices are required to avoid double payments.

From the authors perspective the first implication that requires entering all vendor invoices through the vendor invoice workbench seems to be superior as it provides one single point of entry for vendor invoices irrespective of whether those invoices are linked to a purchase order or not.

What is more, recording expense related invoices by referring to descriptive categories rather than a multi-digit ledger accounts reduces the risk of typing/posting error especially if temporary employees or trainees are recording vendor invoices in the system. Example:
EN_125_0070
Please note that users still have the chance to overwrite the ledger account that is linked to the category if necessary, as illustrated in the previous screen-print.

Even if users are familiar and used to entering vendor invoices through the Dynamics AX vendor invoice journals, a process change towards entering all invoices through the vendor invoice workbench might be beneficial. That is not only because of the audit policy functionality mentioned before but also because of the standard Excel-import and workflow processes that can be associated with the invoice workbench resulting in an overall streamlined and simplified invoice recording process.

 

Q2: How to avoid paying the vendor invoice twice?
Based on what has been said before, you can setup and process an audit policy rule for duplicate vendor invoices before you start making vendor payments to minimize the risk of making double payments. As mentioned previously, this requires that all invoices are entered through the vendor invoice workbench. Otherwise your only option is executing manual checks for potentially duplicate invoices that might require a lot of time and resources.

 

Q3: How to avoid double entries of invoices altogether?
The audit policy process introduced in this post helps you identifying whether an invoice has been entered more than once. That is, the feature is able to identify with hindsight that something went wrong that needs to be cured.

As prevention is usually better than cure, the question arises how one can prevent similar scenarios as the one described in the introduction of this post?

From the author’s perspective the best and safest way for avoiding duplicate vendor invoice records is a complete and consistent use of the Dynamics AX purchase order process for each and every purchase that is made in your company. This requires that also expense related and often small value purchases are processed through purchase orders. Especially for small- and medium-sized companies this might sound like taking a sledgehammer to crack a nut. However, I made the experience that especially small- and medium-sized companies are the ones that do not have the most stringent organizational business processes in place and as a result are the most likely ones running into the risk of entering and paying invoices double.

 

I hope you enjoyed reading this post and would be happy if you could share your experience with the AX community on how to prevent duplicate vendor invoices & payments in Standard Dynamics AX. Thank’s and till next time.

“Shadow Accounting” in Dynamics AX using the example of silent factoring

Tags

, ,

Within this post I want to demonstrate you the use of a shadow accounting system based on the example of silent factoring. What makes silent factoring special is the fact that a company sells its receivables, which consequently disappear from its books. At the same time the company still needs to manage and track the receivables and payments made by their customers in their (accounting) system.

How Dynamics AX can support you in implementing such a shadow accounting system will be exemplified next based on the following process flow:

  • Step 1: Post customer free text invoice for 100 EUR
  • Step 2: Transfer of the open customer position to the “shadow accounting book”
  • Step 2a: Process allocation request to balance original and shadow accounts
  • Step 3: Record the 90 EUR payment receipt of the factoring company for the sale of the receivables
  • Step 3a: Process allocation request to balance original and shadow accounts
  • Step 4: Customer transfers 95 EUR to our company’s bank account
  • Step 5: We transfer the customer payment received to the factoring company

The following illustration summarizes the different process steps and postings in T-account form.
EN_126_0010
Notes:

  • Balance sheet accounts are illustrated in blue color, profit & loss (P&L) accounts in red color and shadow accounts in black color.
  • The 4-digit main accounts used in this demonstration are shown in square brackets.
  • The numbers shown next to the amounts recorded on the different main accounts refer to the process flow steps shown above.
  • The process flow steps and the way how the shadow accounting books are illustrated in this blog do only represent one option how a shadow accounting system can be implemented in Dynamics AX.

Now let’s have a look at the different transactions and the setup required in Dynamics AX to implement such a shadow accounting system.

 

Step 1: Post customer free text invoice for 100 EUR
Initially, a free-text invoice for a total amount of 100 EUR is recorded in Dynamics AX. Recording this invoice generates postings on ledger accounts no. 1400 (Accounts Receivables) and ledger account no. 5000 (Sales revenue) within the original accounting books.
EN_126_0015

 

Step 2: Transfer of the open customer position to the “shadow accounting book”
The next process step involves the transfer of the open customer position to a dummy customer account. As the dummy customer account is setup with a summary account (no. 9499) that belongs to the shadow accounting system, the open customer position disappears from the company’s books.
EN_126_0020
The transfer of the open customer position to the shadow accounting books can be identified in the next screen-print by the green and grey highlighted lines.
EN_126_0025
A detailed investigation of the accounts illustrated in the above screen-print shows that the original and shadow accounting books do not match. That is, the total of all accounts in the original and shadow accounting books do not add up to zero.

 

Step 2a: Process allocation request to balance original and shadow accounts
What is missing in the previous screenshot is an expense transaction that offsets the reduction in the open customer position (receivable). The same holds for the transaction that is recorded in the shadow accounting book.
To get the missing transaction into Dynamics AX, the following allocation rule is setup:
EN_126_0030

  • The source of the allocation rule are the transactions recorded on main account no. 9499, which is setup as the summary account for the transactions on the dummy (shadow) customer account.
  • The same amount that is posted on account no. 9499 is also posted on main account no. 6250 (“destination”). The latter account is used for posting the missing expense transaction in the original accounting books.
  • The offset account for the transaction generated is main account no. 9999 from the shadow accounting system that ensures that also the shadow account book balance.

EN_126_0035
Processing this allocation rule results in the following voucher …
EN_126_0040
… and the following account statement.
EN_126_0045
The screen-print above shows that the original and shadow accounting books are now balanced.

 

Step 3: Record the 90 EUR payment receipt of the factoring company for the sale of the receivables
The third process step is related to the receipt of the amount that the factoring company pays us for the sale of the receivable. In the example used, a total of 90 EUR is paid by the factoring company and posted on our bank account. The offset account used is the dummy factoring account from the shadow accounting book. For details, please see the next screen-print.
EN_126_0050
After recording the money received from the factoring company, the original and shadow accounting books do – once again – not balance and show a total amount of +90 EUR respectively -90 EUR.
EN_126_0060

 

Step 3a: Process allocation request to balance original and shadow accounts
To align both accounting worlds – original & shadow accounting – another allocation rule is setup and processed. This second allocation rule uses the transactions recorded on the factoring bank account no. 1801 as the basis for generating a posting on the shadow clearing account no. 9999.
EN_126_0065
The offset account is the P&L account no. 6250 that was already used in the first allocation rule before. That is because the receipt of the money from the factoring company does not only result in an increase of your bank account balance but does also require a corresponding offset P&L account transaction. Otherwise the expense amount of 100 EUR recorded with the first allocation rule would not correctly represent the “loss” (10 EUR) that we make from selling a 100 EUR receivable for 90 EUR.
EN_126_0070
Based on the setup shown above, the second allocation rule results in the following voucher…
EN_126_0075
… that ensures that both accounting worlds do again balance.
EN_126_0080
(Note: If you post the transfer of the open customer invoice to the shadow accounting books (step 2) and the payment receipt from the factoring company (step 3) at the same time, the setup and processing of the first allocation rule is sufficient to get the original and shadow accounting books balanced. In the example used two allocation rules are required because of a timing difference between step 2 and step 3. Whether you will need to setup a single or several allocation rules thus depends on the specific organizational process flow in your organization).

 

Step 4: Customer transfers 95 EUR to our company’s bank account
After a while the customer finally makes a payment of 95 EUR to our ordinary bank account.
EN_126_0085
As we record this receipt on main accounts that do all belong to the original accounting book, both accounting worlds balance.
EN_126_0090

 

Step 5: We transfer the customer payment received to the factoring company
The last process step involves forwarding the money we received to the factoring company. As this final transaction involves once again only accounts from the original accounting system, everything balances. For details, please see the next screen-prints.
EN_126_0095 EN_126_0100

 

Summary
The shadow accounting example illustrated in this post can be used for several other accounting scenarios. The important thing to make this work is setting up and processing allocation rules. Whether one single allocation rule – that is processed e.g. at month-end – is sufficient or whether several allocation rules are required highly depends on your organizational process flows and time gaps that might exist between the different process steps.

Foreign currency revaluation

Tags

, , ,

This post deals with the foreign currency revaluation feature available in the Accounts Payable (AP) module and illustrates the effect that different parameter settings have on the foreign currency revaluation calculation and ledger posting. Please note that the examples and explanations made in the following do also apply for the Accounts Receivable (AR) module as the foreign currency revaluation functionality in AR is basically identical to the one in AP.

The examples below are all recorded in the Contoso DEMF company that uses the EURO as accounting currency. All sample vendor invoices are recorded in USD in January and February 2022. For those months/days, the following currency exchange rates apply:
EN_121_0005
The post is separated into four parts. The first part starts with an analysis of the different currency revaluation methods. This part is followed by a subsection on the different financial dimension options available for foreign currency revaluation postings. Part 3 deals with the posting profile parameters and part 4 concludes this post by having a look at the different dates that can be selected when running the foreign currency revaluation process.
EN_121_0010

 

Part 1: Foreign currency revaluation method
Let’s start by having a look at the different currency revaluation methods (standard, invoice date and minimum) that can be selected in the foreign currency revaluation parameters form. For that purpose a vendor invoice with a total amount of 1000 USD has been recorded on 1 January when the exchange rate between the USD and EUR stood at 1,00.
EN_121_0020
In order to illustrate the different foreign currency revaluation method options, three currency revaluations will be run on 28 .January and 31. January respectively, where the following currency exchange rates between the USD and EUR apply:
EN_121_0015

 

The first currency revaluation is run on 28 January with the “Standard” method.
EN_121_0025
Because of the appreciation of the USD, an unrealized foreign currency loss of 250 EUR arises that is shown in the following revaluation report.
EN_121_0030
The unrealized loss is posted on the account for unrealized currency losses and increases the vendor liability expressed in EUR currency correspondingly.
EN_121_0035

 

Next, a foreign currency revaluation with the „Invoice date” method is run.
EN_121_0040
Please note that selecting this method does not allow you changing the date value shown in the “Date of rate” field. As the “Considered date” value can be changed, I entered 31 January to identify the effect that this change might have on the transactions generated.

Result:
The revaluation report and the corresponding voucher show that the invoice method reverses the previous foreign currency revaluation. If you have a look at the voucher date then you can identify that the date value entered in the “considered date” field is used as the posting date for the foreign currency revaluation voucher.
EN_121_0045 EN_121_0050

 

The third foreign currency revaluation is run with the “Minimum” method. This time, the considered date and date of rate values are set to 31 January.
EN_121_0055
Result:
This time, Dynamics AX does not record any foreign currency revaluation adjustment and does not create a voucher. That is because the “Minimum” method does not record a foreign currency gain as it would result in an unrealized exchange rate profit that some countries – such as Germany – do not allow to report in corporate financial statements.
EN_121_0060
EN_121_0065

 

Part 2: Foreign currency revaluation dimensions
After having a look at the different method options available for foreign currency revaluations, the financial dimensions parameter is investigated next. To do that, let’s first have a look again at the invoice voucher that has been recorded on 1 January.
EN_121_0070
The invoice voucher illustrated in the previous screen-print shows that the vendor invoice is recorded with the financial dimension “Business Unit 002”.

 

Against the background of the invoice voucher generated, let’s have a look at the foreign currency revaluation voucher that is generated when “None” is selected in the dimensions parameter field.
EN_121_0075
If the foreign currency revaluation process is started with this parameter setup, Dynamics AX shows the following message:
EN_121_0080
If you confirm this message with Yes and run the foreign currency revaluation, a voucher similar to the one shown in the next screen-print results:
EN_121_0085
As one might expect, the foreign currency revaluation adjustment is recorded without any financial dimension value.

 

To identify what difference the selection of any other dimension parameter makes, the previous foreign currency revaluation is first reversed by using the invoice date method shown above and then run again by selecting “Posting” in the dimension parameter field. Please see the following screen-print for details.
EN_121_0090
Result:
This time, the foreign currency revaluation voucher is generated with the financial dimension that has been used for posting the vendor invoice.
EN_121_0095

 

To see what difference the last dimension parameter (“Table”) makes, the previous foreign currency revaluation is cancelled again by using the invoice date method and run once again with the following settings:
EN_121_0100
Result:
This time, the foreign currency adjustment voucher is generated with the financial dimension “Business Unit 001”.
EN_121_0105
Please note that the financial dimension value “Business Unit 001” is taken from the vendor master record as exemplified in the next screen-print.
EN_121_0110

 

Part 3: Foreign currency revaluation posting profile
In this this part I want to focus on the difference that the selection of a specific posting profile makes to the foreign currency adjustment voucher. To do that, the previous foreign currency revaluation was first reversed by using the Invoice date method shown previously and then re-run with the following parameter settings:
EN_121_0115
Please note that the “FX” posting profile is setup with a different summary account.
EN_121_0120
Result:
Different from what one would expect from the parameter settings shown above, the foreign currency adjustment voucher still uses the same vendor summary account (No. 200100) for recording the unrealized foreign currency gain. Please see the next screen-print.
EN_121_0125
The underlying reason for this behavior is that the dimension setting “Posting” overwrites the posting profile parameter setting.

In order to verify this system behavior, the previous foreign currency revaluation is reversed (by using the Invoice date method) and re-run with “Table” selected in the financial dimensions field.
EN_121_0130
Result:
This time, the unrealized foreign currency revaluation gain is recorded on the summary account that has been specified in the “FX” posting profile.
EN_121_0135
Note:
Using a separate posting profile for recording unrealized foreign currency profits can help companies in two ways.
First, through an easy identification of a company’s foreign currency exposure and the related risks. That is, while the unrealized foreign currency gain/loss accounts do not differentiate between group internal and external currency risks, the use of a separate posting profile with vendor/customer group specific summary accounts for foreign currency adjustments, can help companies assessing whether or not the use of foreign currency hedging instruments might be beneficial. The consideration behind this statement is that only risks from external currency fluctuations should be hedged while group internal currency risks do not require costly hedging instruments.
Second, the separation of currency revaluation effects on separate ledger accounts can alleviate the financial consolidation process.

 

Part 4: Foreign currency revaluation dates
After reversing the previous foreign currency revaluation once again, a second vendor invoice for 2000 USD is recorded on 1st February. On this date, the USD/EUR exchange rate stood at 1,00. For details, please see the next screen-prints.
EN_121_0140 EN_121_0145
With the two vendor invoices posted in Dynamics AX, a first foreign currency revaluation was run with the following setting:
EN_121_0150
Result:
Dynamics AX generates a foreign currency adjustment based on the exchange rate valid on 28 February (0,6 EUR/USD or 1,6667 USD/EUR). Because the considered date (31 January) is before the date the second vendor invoice was posted (1 February), only the unrealized foreign exchange rate gain for the first invoice is taken into consideration.
EN_121_0155
After reversing the previous foreign currency revaluation, the revaluation process is re-run with a considered date value that is after the date on which the second vendor invoice was recorded.
EN_121_0160
Result:
This time, both invoices are included in the foreign currency revaluation process for recording the unrealized foreign exchange rate gain.
EN_121_0165
[Invoice 1: 1000 USD, Invoice 2: 2000 USD => Total: 3000 USD * Exchange rate as of 28 February (1,6667 USD/EUR) = 5000 EUR => 2000 EUR unrealized foreign currency exchange rate loss]

 

Hope you found some useful information in this post. Till next time.

Follow

Get every new post delivered to your Inbox.

Join 99 other followers