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) / AX : Travel & Expe...
Microsoft Dynamics AX (Archived)

AX : Travel & Expense Posting

(0) ShareShare
ReportReport
Posted on by Santosh 766

Hi,

I would like to setup expense system in such a way that it create following entry after posting expense claims.

After Expense Posting

Expense Category Dr and AP Control Account Cr.

After Payment Posting

AP Control Account Dr and Bank Account Cr.

I have done following setup

1. On Expense Category > Main Account : Expense account is set

2. Payment type as Company and offset account as employee ( I have doubt and not clear on this.)

After posting expense Journal is not getting created in AP or GL.

There is no issue on expense workflow and it is working fine. We have AX 2013 R3.

What payment method we have to set so that we can get above distribution and open journals created in AP and show transaction in GL.

Thanks in advance.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    RamK Profile Picture
    RamK 2,580 on at

    Create and Associate a vendor with Employee to make the payment.  Refer blogs.msdn.com/.../link-the-workers-to-the-vendors-in-order-to-manage-the-expense-reports-in-ax-2012.aspx

  • Santosh Profile Picture
    Santosh 766 on at

    Hi Ram, Thanks for sharing this. but distribution is not getting created only debit account is created ie account taking from expense cost catg. (main account).

  • Santosh Profile Picture
    Santosh 766 on at

    This is outcome by different option

    Pymt Method Expense Owner Offset Acc Type Result

    Test Company Worker Fail to create credit entry

    Test Company Ledger Pass

    Test Company Bank Pass

    Test Company Supplier Fail to create credit entry

    Test Employee Worker Fail to create credit entry

    Test Employee Ledger Pass

    Test Employee Bank Pass

    Test Employee Supplier Fail to create credit entry

    None of the above created AP entry and GL entry

  • RamK Profile Picture
    RamK 2,580 on at

    Are you getting any error message while posting...?  I guess that your AP posting profile is not correct.  Can you please verify the Vendor group associated with Vendor and AP posting profile setups...?

  • Santosh Profile Picture
    Santosh 766 on at

    Hi, Just found... Account is not picking up from Vendor Group. When I have Payment source is setup as Company and offset account as "Workers".. Contoso I have checked it is perfect but on our UAT is not behaving correctly.

  • RamK Profile Picture
    RamK 2,580 on at

    Can you please tell us what is the type of main account you have associated with your posting profile...? In the Main account, in Administration tab, "Do not allow manual entry" check is enabled...? Are you sure that your main account is part of the active Chart of account...? Do you have any advanced rule defined for this account...?

  • Santosh Profile Picture
    Santosh 766 on at

    Hi Ram, Thanks for your time and understanding my issue.

    • Main account associated with your posting profile  - Yes
    • "Do not allow manual entry" check is enabled  - Yes Enable
    • main account is part of the active Chart of account  - Yes within the range
    • any advanced rule defined for this account  - No Advance rule

    Infect when I am changing offset account from worker to Ledger (the same account is set in Vendor Posting profile) it is picking up. Below I have inserted picture of payment terms and posting profile.

    Is there any other checking I need to place?

     

     Pynt-Term-and-Posting-Profile.jpg

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