Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Analytical Account food for thought

Posted on by

Dear All,

I have a question. My client captures expenses prepaid as he waits for an invoice in order to pay expenses.(shown in the figure below)

On Payment Entry Transaction on payables, he captures the first part, and then the second part is usually a recurring batch.

He wants when he do the analysis (Analytical Accounting) in the first part i.e. on prepayment then the same analysis happens on part 2 (Expense and prepayment) instead of repeating the same analysis on the recurring batch transactions.

Which approach should I take? Any ideas 5850.AA.png

RomRyan

*This post is locked for comments

  • Romryan Profile Picture
    Romryan on at
    RE: Analytical Account food for thought

    Mahmoud Saadi,

    Thanks for the update.

    Unfortunately my client doesn't use expense and deferral module.

    My client also requires the prepayment account to be analyzed on both occasions but the analysis on the GL recurring batch plus apportionment of amount needs to be done automatically based on analysis on the prepayment payable transaction.

    He uses payable invoice with lump sum amount and GL recurring batch containing the lump sum amount dividend into monthly units until its exhausted by the last posting of the recurring batch that recur until the the number of postings is done.

    Interestingly I didn't know expense and deferral module can achieve this.

    RomRyan

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Analytical Account food for thought

    Hello again Romryan

    There is something which I don't clearly understand about your situation, why is your client filling the AA analysis details on the prepaid-expenses account then refiling again on the expense account !

    I believe the process of prepaid expenses is supposed to go as follows:

    An invoice is posted with the total amount of the prepaid expense (let's say Rent), which could be automated with the expense and deferral module. Once used, the same invoice will create a number of journal entries to close the total of the prepaid amount in the associated expense. Analytical accounting analysis are usually filled on the expense account level, such as expense allocation, type ..etc.

    Lets consider a simple example, you are recording an invoice for a whole year rent, a total of $ 12000

    I will suppose that you are using the revenue and expense deferral module to automate this process, so once creating the invoice, the following journal entries are to be posted:

    Account                       Dr                   Cr

    Prepaid Expense          12000              0

    Accounts Payable         0                     12000

    According to the deferral configuration, I would suppose that a 12 journal entries will be created, to allocate the expense throughout the 12 periods.

    Date 1/1 (for instance)

    Account                       Dr                   Cr

    Rent Expense                1000                0             >> AA is to be associated, right ?

                  Prepaid Expense          0                        12000

    I would suppose that the analytical details are to be associated with the expense account, which is the rent account in this case, right ?

    If you are to follow this process, please be aware that AA integration with Revenue and Expense Deferral is limited, and you may have to consider one of three manual options illustrated in knowledge base Article ID: 3006081

    These options are "as derived from support article above"

    "

    Option 1 - Post the deferral in GL. Then click on Transactions, point to Financial, point to Analytical Accounting, and click on Edit Analysis. Select the Journal Entry of the deferral and proceed to add/edit the AA data.
    Option 2 - Stop the batch in GL and add the AA codes to the transactions in the GL work batch.
    Option 3 - Enter default AA codes in the Trx Dimension Code Default fields on the Accounting Class, and these codes will get automatically assigned to the deferral entries. However, you would still have to use one of the other options if you want to change any of the codes.

    "

    Your feedback is highly appreciated,

  • Romryan Profile Picture
    Romryan on at
    RE: Analytical Account food for thought

    To all,

    Any idea from Community?

    RomRyan

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans