Tuesday, August 13, 2013

General Journal : Some interesting facts about Delete Lines and Lines Limit


Delete Lines after posting : If clicked, then the journal lines are deleted the moment the journal is posted. The journal header still exists in the journal list if the user selects Show : ALL, however if clicked on the Lines button for that journal, then system displays an empty journal without lines.
Such journals will NOT be visible if user selects Show: POSTED, even if the journal is posted.

Lines Limit: This refers to the number of vouchers and NOT physical lines in the journal. For example, if a journal has lines limit of 2 and if the user multiline journal (one debit and several credit lines to balance it). In that case as long as the journal voucher balances, that whole voucher will be considered as one line. Now suppose the user enters two more single line offset vouchers apart from the one multiline discussed above. If the user now tries to post it, AX allows the posting, but because of the lines limit, ONLY 2 lines are posted for that journal and the remaining one line is poste in another journal. The infolog displayed after the posting, gives this message to the user.

Interesting thing to note here is that the next journal that is created for that one line also has a lines limit of 2. So to test this I created one more journal with lines limit of 2 and created 5 lines (vouchers, mix of single line and multiline). This time after posting I got an infolog saying that the 2 lines are posted in the current journal, while the next two lines are posted in the next sequential journal and the remaining one line is posted in yet another sequential journal. This was an interesting yet un-important fact to know...!

Thanks!

AXAPTAMANIAC
 

General Journal : Detail Level - Details OR Summary


While creating the General Journal, in the Header, there is one parameter which affects the manner in which the transaction is posted.

As per the explanation in the AX Training Manuals:

Details: Every instance of the account number in the journal lines is posted as separate account transaction.

Summary: A summation of journal lines into one transaction is performed automatically during posting if voucher with date, account number, dimension and currency code contain the same value.

I decided to test this, by passing following transaction via general journal, once by selecting Details and the second time by selecting Summary.

Dr      Expenses   700
          CR     Petty Cash    300
          CR     Petty Cash    200
          CR     Petty Cash    150
          CR     Petty Cash      50

After I posted the transaction, I saw the voucher from the Inquiries section and this is what I found.

By selecting Details:

 
By selecting Summary:



Hope this helped to clarify the difference.

Thanks!

AXAPTAMANIAC
 

General Ledger Parameter : Accouting Distributions OR Source Document


General Ledger Parameters has one of the most important parameter called, "Value Used for Summary Account", and the options are:

  1. Source Document
  2. Accounting Distributions

What happens when either of the one is selected ?? Lets see...

This parameter is set at the beginning of the company setup, before any transactions are posted. This can be changed later, system allows it. But it is advisable that it shouldn't be changed, as it will mess up the entire reporting for the transactions.

This parameter decides whether the amount posted to the summary / control account should be distributed amongst the Financial Dimensions or not. This is very useful decision, as some companies might track the finances as per the financial dimensions (for e.g. Department, Cost Centre etc.) while some may not.

To understand this myself, I first created a purchase order and then added some charges to it by using the "Manage Charges" and "Allocate Charges" feature. Just before invoicing the PO, I changed the dimension of the charges line by using the "View Distributions" and "Distribute Amounts"  feature. And then posted the invoice. I performed the same steps for both the settings, namely "Source Document" and "Accounting Distributions".

Source Document: When the setting was "Source Document", even after me manually distributing the charges amount to different financial dimension (Business Unit, in this case), the entire amount (the invoice amount + the charges) were posted collectively ones to the summary / control account (the Accounts Payables account). This setting followed the dimension of the header of the PO.

Accounting Distributions : When the setting was "Accounting Distributions", after I manually distributed the charges amount to different financial dimension (Business Unit, in this case), the invoice amount was posted separately to the summary / control account (the Accounts Payables account) with the dimension it was supposed to be posted AND the charges amount was posted separately to the summary / control account (the Accounts Payables account) with the other dimension which was manually changed by me . This setting followed the dimensions that were given by the user. In this case the amount was posted to the summary / control account itself, but the only difference was, the amount was bifurcated to different financial dimensions. Hence now if the user wish to find out the charges per dimension, he can easily find out the dimensions consuming the least and the most charges. This can help him make better decisions.

For e.g.: The Invoice Amount = 302.71 USD and the Charges = 50 USD

Source Document


Accounting Distributions


 Please note these distributions to different financial dimensions are to be done manually.

Thanks!

AXAPTAMANIAC
 

Saturday, August 3, 2013

Reversals in Dynamics AX 2012


I tried searching for the reversal process in AX 2012 for the following:

  1. AP Invoice Reversal
  2. AR Invoice Reversal
  3. AP Payment Reversal
  4. AR Payment Reversal
  5. GL Journal Reversal
But I could not get proper explanation and the process details for all the above reversals neither on google nor in the Dynamics AX training manuals. Hence I tried and researched them all in AX 2012 VPC. This is what I found. Please correct me if I am wrong in any of the interpretations that I have posted here.

AP Invoice Reversal

I created a AP invoice by posting a normal AP Invoice Journal. I wanted to reverse that, however there is no functionality in AX 2012 to reverse the AP Invoice Journal. Atleast I could not find it. The only option that I as left with to reverse this transaction, was to pass a reverse transaction .i.e. AP Invoice with a negative value. I mean this a very regular and general scenario wherein you have keyed in a wrong invoice information and posted it and now you want to reverse it. However for this I need to create another AP invoice journal with negative values and then reduce the AP (Trade Creditors) balance in the system.

AR Invoice Reversal

Free text invoice can be corrected but cannot be reversed. By this I mean, that if I have posted a free text invoice for some customer and then I realised that I shouldn't have raised an invoice for that customer but it should have been for some other customer. Then in that case I need to raise a free text invoice with a -ve value and reduce the AR (Trade Debtors) account accordingly. There is no functionality to reverse a free text invoice in AX 2012.


AP Payment Journal Reversal

If the payment journal is posted using the Settlements. If Yes, then the next question is whether it is made by check or by other methods. If it done by check, then the user will have to first reverse the transaction from the Closed Transaction Editing form and then reverse the check from the Checks form in the Bank Management module. This will reverse the entire payment. OR If the user directly reverses the check from the bank management, then also the entire payment is reversed, without going to the Closed Transactions editing form of the vendor.

Remember: If the Reconcile check box is selected on the reversal form during the reversal, the check is reconciled and it will not be displayed in the Bank Account reconciliation form.

If the payment is done by other payment method (Wire Electronic etc), then the user will have to first reverse the transaction from the Closed Transaction Editing form and then pass a -ve payment journal. Then from the Settle Transactions screen, the user will have to manually select the +ve and -ve payments and then settle them.

If only payment was made, without selecting the Settlement, then the user will have to just pass a -ve payment journal. Then from the Settle Transactions screen, the user will have to manually select the +ve and -ve payments and then settle them.

This will reverse the AP payment journal.

AR Payment Journal Reversal

 If the payment is done using Settlements, then the user will have to first reverse the transaction from the Closed Transaction Editing form and then pass a -ve payment journal. Then from the Settle Transactions screen, the user will have to manually select the +ve and -ve payments and then settle them.

If only payment was made, without selecting the Settlement, then the user will have to just pass a -ve payment journal. Then from the Settle Transactions screen, the user will have to manually select the +ve and -ve payments and then settle them.

This will reverse the AR payment journal.

GL Journal Reversal

The GL journal involving the account type of Ledger can only be reversed and any other type of transactions posted from the GL General Journal cannot be reversed. A manual entry with reverse values needs to be posted to reverse those transactions.


Please do let me know if any of the information here is mis-leading or not correct. But from what all research that I have done, I have made the above conclusions.

Thanks !

AXAPTAMANIAC
 

Sunday, July 28, 2013

Deferrals and Accruals


Dictionary meaning of Deferrals is Delays, Postponements and the dictionary meaning of Accruals is Accumulations, Additions etc. Inline with these meanings, I am going to explain these terms in conjunction with two other terms, namely COSTS / EXPENSE and REVENUE / INCOME.
 I am actually going to show the double entry for both, as eventually everything boils to that only and that's what matters in the end!

Deferred Cost and Accrued Cost

Deferred Cost

Deferred Cost / Expense can be any expense which is paid in advance or a purchase made in advance. This literally means that you are deferring (Delaying) the entry in actual cost account in general ledger, as the timing for booking the cost does not match the event. But since you are making that cost, it has to be recorded somewhere in the books and that's where the Deferred Cost / Expense account comes into picture. Deferred Cost / Expense account can be  Prepaid Insurance, Prepaid Rent etc.

Now the cost has already hit the cash / bank account, but the actual cost has not been booked in the account that is specifically selected for that purpose. For e.g. Rent. Insurance etc. So how does this work. Suppose you have made the prepayment for the entire year for Insurance and you want to book the cost of that insurance expense every month. In this case, you pass an entry for the Prepaid Insurance and then reverse the deferrals each month. Enough of talk, lets do the double entry:

In the beginning of the year the entire insurance amount is paid:

DR Prepaid Insurance         1200 INR
      CR   Bank                                      1200 INR

Then in each month, following entry is made hitting the actual expense account:

DR Insurance Expense        100 INR
       CR Prepaid Insurance                  100 INR

In this way the entire deferral amount is cleared by the year end the appropriate expense is booked in the actual expense account at the appropriate time.

In effect the entry after the Prepaid Insurance is knocked off, is:

DR Insurance Expense        1200 INR
       CR Bank                                        1200 INR

Remember : Deferred Cost account is an Asset account.

Accrued Cost (Cost Accruals)

Cost Accruals is nothing but a provision made so that the accounting is accurate and the financial statements reflect the actual picture. There are certain scenarios where the cost has to be accrued.

For e.g. Year end is 31st Dec, but the salary day is 5th of every month, then for the accounts to reflect the correct figures the cost will have to be accrued on 31st of Dec. The entries will be as follows:

DR Wages Expense       100,000 INR
     CR Wages Payable                      100,000 INR ( Cost Accrual)

On the salary day,

DR Wages Payable       100,000 INR (Accrual Reversal)
      CR Bank                                     100,000 INR

In-effect the entry after the Wages Payable is knocked off, is:

DR Wages Expense       100,000 INR
      CR Bank                                     100,000 INR

Remember : Accrued Cost is a Liability account.

Deferred Revenue and Accrued Revenue

These terms are exactly the opposite of what is explained above.

Deferred Revenue

Deferred Revenue is the revenue which is received in advance. Hence while entering this in the books, it should be entered in such a fashion so that the picture that the financial statements display should be neat and accurate. Example of Deferred Revenue is Advance Payment. The double entry for this will be:

DR Bank           50,000 INR
      CR Deferred Revenue (Pre-payment)  50,000 INR

However when the work / service is delivered in parts or in whole, then accordingly the actual revenue will be recognized. The entry for it will be as follows:

DR Deferred Revenue    10,000 INR (1)
      CR Revenue                          10,000 INR (1)

DR Deferred Revenue    10,000 INR (2)
      CR Revenue                          10,000 INR (2)
.
.
.
DR Deferred Revenue    10,000 INR (5)
      CR Revenue                          10,000 INR (5)

This is how the revenue will be recognized in parts as and when the work / service gets delivered. And if it is decided that the revenue is to be recognized at the end of the work / project, then only one entry will be passed .i.e.:

DR Deferred Revenue    50,000 INR
      CR Revenue                          50,000 INR

In effect the entry after the Deferred Revenue is knocked off, is:

DR Bank       50,000 INR
       CR Revenue 50,000 INR

Remember : Deferred Revenue is a Liability Account.

Accrued Revenue (Revenue Accruals)

The need for the Revenue Accruals arises when the revenue (amount) in theory should have hit the bank account, but has still not. But from the standpoint of accurate accounting (matching principle)
for the given period the appropriate provision should be made to reflect the actual revenue for that period, even if the bank has still not received the money. The entry will be as follows:

DR Accrued Revenue       30,000 INR
      CR Revenue                                  30,000 INR

Now when the money starts hitting the bank account; either periodically or in lump-sum, the Accrued Revenue will be reversed.

DR Bank      10,000 INR (1)
CR Accrued Revenue     10,000 INR (1)
.
.
DR Bank      10,000 INR (3)
CR Accrued Revenue     10,000 INR (3)

OR if all the revenue is to be recognized all at once, then:

DR Bank      30,000 INR
CR Accrued Revenue     30,000 INR

In effect the entry after the Accrued Revenue is knocked off, is:

DR Bank       30,000 INR
       CR Revenue 30,000 INR

Remember : Accrued Revenue is an Asset Account.

Thanks !

AXAPTAMANIAC

 

Intercompany Accounting in Dynamics AX 2012



I was going through the requirements for the client that I am working for and it so happened that they require the intercompany functionality. I have never before done this, hence started playing around with the AX 2012 R2 system in my oracle virtual box. This is what I concluded.

  1. Create the Receivables and Payables Ledger accounts in the Chart of Accounts of all the involved companies.
  2. Create the Customer and Vendor posting profiles. There should be separate lines for all the intercompany Customers and Vendors, if the client wants to track the intercompany funds separately for each company.
  3. In step 2, select the accounts defined in step 1 for each individual line in the setup section of the posting profile record.
  4. You are ready to go for intercompany Sales Orders and Purchase Orders now. The settings are such that the transactions will be tracked individually for each associate company.
  5. The same settings work well when used for Free Text Invoice. Out client wanted invoice to be created for any non-trade transaction between the two associate companies. Free text invoice was a very good suggestion in that case.
  6. Now suppose the companies are passing intercompany journals as well, then they can do so by passing a General Journal, but selecting the different company while defining the offset account.
  7. However this  ONLY works when the Intercompany Accounting setup is defined in the GL module.
  8. Navigate to GL > Setup > Posting > Intercompany Accounting and define the same payables and receivables account for the appropriate companies that were created in step 1 above. Also the user needs to define the journal that will be automatically posted, from the drop down. This can be a normal General Journal
  9. Some may also insist creating a separate Intercompany Journal, so that its easy for tracking. Imagine all types of journals being posted as General Journal. Its difficult to track the purpose. Hence it is advisable to create a separate Intercompany Journal.
  10. But remember the same setup has to be done in all other associate companies so that this functionality works well.
  11. Once the setup is complete and the General Journal is posted, the system posts two vouchers one in the parent company and other in the associate company.
For e.g.:

Company A has to book some expense on Company B, then a General Journal can be created in Company A:

Dr  Car Expense 120 (Company B)
   Cr  Bank 120 (Company A)

When the above journal is posted, then system automatically posts two transactions:

Company A:

Dr Receivables from B  120
    Cr Bank 120

Company B:

Dr Car Expense 120
   Cr Payable to A 120

This can then be settled by passing a payment journal OR this can be settled by a similar reverse journal from Company B.

As far as the intercompany Sales and Purchase orders are concerned they will behave exactly same as the normal trade Sales and Purchase orders, only difference being there amounts will be tracked separately in the summary / control accounts defined in the customer and vendor posting profiles. Also the payments will also be done through the normal payment journals.

Thanks!

AXAPTAMANIAC


 

Foreign Currency Revaluation in Dynamics AX 2012



I tried to run through this process in Dynamics AX 2012 R2 and following was the process and related findings.

  1. First I setup all the accounts namely:
    1. Unrealized Profit (Asset)
    2. Unrealized Loss (Liability)
    3. Realized Profit (Revenue)
    4. Realized Loss (Expense)
  2. Then I created a foreign currency in the system and also entered the exchange rates for the same for few days.
I basically wanted to see when these accounts are hit when the transactions related to foreign currency are posted. I did post two type of transactions namely:

  • One without using the Unrealized Profit/Loss accounts
  • One with Unrealized Profit/Loss accounts
Now what does this mean. This means that I tried the foreign currency transactions one with Foreign Currency Revaluation Process and one without Foreign Currency Revaluation Process.

For the transactions where I did NOT ran the foreign currency revaluation process, the Realized Profit / Loss accounts were direct hit. for e.g.:

I posted an AP Invoice journal in foreign currency. Then immediately after that I posted the AP Payment journal for the same, but on a different date with different exchange rate. This time the transaction was posted but directly hitting the Realized Profit and Loss accounts.

Then I tried to change the process a bit, by introducing the Foreign Currency Revaluation process in it. This time I posted an AP Invoice Journal and then I ran the Foreign Currency Revaluation process for a different date with different exchange rate. The posting that happened this time hit the Unrealized Profit / Loss accounts. Accordingly they also hit the control accounts (Trade Creditors in case of Vendor Account and Trade Debtors in case of Customer account). After this I posted the AP payment journal. After the payment journal was posted, it hit the Realized Profit / Loss account and at the same time reversed the entries in the Unrealized Profit/Loss account.

So the conclusion is the entries registered in the Unrealized Profit  / Loss accounts are nothing but a provision to accommodate the fluctuating exchange rate. This also makes the Balance sheet more accurate, as you have made a provision for the potential profit and loss that may or may not occur in future due to change in exchange rate.

It is not mandatory to use the Unrealized Profit / Loss accounts on a monthly basis during the monthly closing. Some companies only use Realized Profit / Loss accounts for the entire year and at the end of the year they will run the Foreign Currency Revaluation to make provision for the unrealized profit and loss.

Hope this was useful enough. Till next time happy exploring new things in AX.

Thanks!

AXAPTAMANIAC