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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Expense allocation to ...
Microsoft Dynamics AX (Archived)

Expense allocation to different cost centers while booking vendor invoice through vendor journal

(0) ShareShare
ReportReport
Posted on by Community Member

We need to enter the following entry though vendor invoice journal

 Credit   Offset-Account   Cost Center 
Vendor 001            50,000  Repair Expenses   CC001 
Vendor 001            50,000  Repair Expenses   CC002 

However, vendor open balance should be shown as 100,000 in one line. How can we handle this?

*This post is locked for comments

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

    Hello Ruwan,

    One possibility is to setup an allocation rule at the repair expense account level in your chart of account where you can define that a split of 50:50% shall be made to the cost centers CC001 and CC002.

    Another option is the use of the ledger allocation rule functionality in GL, which can do the same but runs the allocation in the form of a batch job e.g. at the end of a day, week, month, etc.

    Best regards,

    Ludwig

  • Community Member Profile Picture
    Community Member on at

    Thanks Ludwig,

    But the issue is, it is not a predefined rate of allocation always. It is different from an invoice to invoice. Also, one invoice may be relevant to 5 or 6 cost centers. I believe we can first account the expense as a total amount to the expense account through AP Journal, and later allocate the total amount to different cost centers using General Journal. But our users prefer it to be handled using AP journal.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ruwan,

    How do you know the cost centers the invoice amount has to be allocated to?

    Does this always depend on the invoice?

    If so, users have to record the different cost centers and the way how they want to have the cost allocated when they record the invoice. In other words, they would need to do this manually.

    Best regards,

    Ludwig

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Ruwan,

    Have you been able to get this resolved in the meantime?

    Best regards,

    Ludwig

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Yes Ludwig

    We credited vendor account for the total in a separate line and added ledger accounts as separate lines and selected different cost centers. It worked. Total amount was posted to vendor account in a single line and the total amount has been allocated to different ledger accounts.

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans