web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Accural Scheme -Payment to vendor

(0) ShareShare
ReportReport
Posted on by 8
Hi All
I have a question regarding the Accural schemes and please share your thoughts .
Accural Schemes  - Ledger accruals redistribute the costs or revenues of a journal line so that the costs and revenues are recognized in the appropriate periods.
I know how the Standard Ax accural schemes funcitonality works .
My scenerio is as a best practice what ever payment client do outside , they treated as a vendor .
Now client has to payment the insurance amount for the Financial year 2014-2015. This amount is applicable for whole year , that means when entry posted system should automatically split the amount month wise.( How the normal accural scheme does )
Client Entry  :
 Type             Debit                   Credit
Vendor      - 1,20,000                                - This amount should split automatically as how Ax does when select Main Acc.
Bank         -                              1,20,000
So in one shot system should post entries to vendor account , bank and insurance expense entry should split to 12 months .
But in AX we do not have the option to select the vendor in Accural scheme only supports the Ledger account only.
How to get the expected result as mentioned above?

*This post is locked for comments

I have the same question (0)
  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hi Lally, maybe prepare your postings for the different periods in Excel and import them via the Excel add-in. Ludwig

  • lally Profile Picture
    8 on at

    Thanks for the reply Ludwig,

    You mean that there is no option to create the above transaction in Ax 2012 R2 ?

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Lally,

    Well, if you post a vendor account in debit and a bank account in credit in the way you describe it, the standard accrual feature won't work to my knowledge.

    Yet, what I experienced in practice is that you typically have two transactions:

    (1) Post vendor invoice against an expense account and

    (2) Pay the vendor invoice later on

    For the first transaction you can certainly make use of accrual functionality even in accounts payable invoice journal. Simply enter your vendor invoice as usual and then select "Functions-Ledger Accruals.

    Hope it helps.

    Ludwig

  • lally Profile Picture
    8 on at

    Thanks Ludwig for the reply.

    Now i understood how Ax works.. in this scenario

    a) In the Accural scheme what would be the debit account and credit account ?

    b) When passing the vendor transactions in AP invoice journal , i will select the account type as vendor , but what about the offset account type i need to select ?

    Can you explain with an example ?

  • Verified answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello lally,

    Here is a simplified example:

    Step 1: Setup accrual schemes

    2538.Step1.png

    Step 2: Record vendor invoice
    (Debit account =  Expense account, Credit accout = Vendor account)

    Step 3: Select “Functions-LedgerAccruals” and select the accrual scheme

    By selecting transactions, you can preview the accruals that AX is doing

    Step 4: Post the journal

    If you select “Inquiries-Voucher” you will notice that AX posted the invoice against the account setup in the accrual window.

    This account is offset on a monthly basis. So, what you have at the end are the following transactions

    Date

    Account debit

    Account credit

    Amount debit

    Amount credit

    Invoice date
    (02 January)

    200190 (Accrual account)

    200110 (Vendor liability)

    1200

    1200

    Jan

    618900 Expense

    200190 (Accrual account)

    100

    100

    Feb

    618900 Expense

    200190 (Accrual account)

    100

    100

    Mar

    618900 Expense

    200190 (Accrual account)

    100

    100

    Apr

    618900 Expense

    200190 (Accrual account)

    100

    100

    May

    618900 Expense

    200190 (Accrual account)

    100

    100

    June

    618900 Expense

    200190 (Accrual account)

    100

    100

    July

    618900 Expense

    200190 (Accrual account)

    100

    100

    Aug

    618900 Expense

    200190 (Accrual account)

    100

    100

    Sept

    618900 Expense

    200190 (Accrual account)

    100

    100

    Oct

    618900 Expense

    200190 (Accrual account)

    100

    100

    Nov

    618900 Expense

    200190 (Accrual account)

    100

    100

    Dec

    618900 Expense

    200190 (Accrual account)

    100

    100

    Hope it helps.

    Ludwig

  • lally Profile Picture
    8 on at

    Thanks ,

    But Accural schemes functionality is not available in AP invoice journal only for General Journal ?

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at

    Hello Lally, The functionality is available in AP invoice journals at least in a AX2012 R2 and R3 Environment. Best regards, Ludwig

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Sukrut Parab Profile Picture

Sukrut Parab 2 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans