Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Expense management: Ta...
Finance forum
Answered

Expense management: Tax distribution using wrong main account

Posted on by 11
Hi,
 
Entering an expense report for Office Supplies 100$, with 13$ Tax. Total is 113$ as expected but both expense category and tax portion are posting to the same Main Account tied to the expense category. The expectation is to see Office supply category post to Office supply main account and the Tax portion to post to the Tax payable main account. 
 
Is there a setting to enforce that? The behavior should be the same as when creating a vendor invoice, in which the item and tax amounts are recorded under their respective main accounts. 
 
Thanks in advance for the help.
 
Y.K
 
  • Verified answer
    YK-06062335-0 Profile Picture
    YK-06062335-0 15 on at
    Expense management: Tax distribution using wrong main account
    Microsoft was able to help with this issue that was caused by how Sales Tax were setup under the General Ledger parameters. The highlighted fields below needed to be adjusted/turned on. Ensure that your environment parameters are matching the screenshot below.
     

     
    Additionally, the expense report seems to be using the main account defined under "Use Tax expense" on the Ledger posting groups. See below.
     

  • YK-06062335-0 Profile Picture
    YK-06062335-0 15 on at
    Expense management: Tax distribution using wrong main account
    Thanks Adis and Andre Arnaud. I will try the delete Ledger posting setup row, although I am not using Project on my expense report.
     
    To Andre Arnaud, see screenshots below for the Tax Ledger posting. It is clearly not going to that GL account. Thanks!
     
     
  • Adis Profile Picture
    Adis 256 on at
    Expense management: Tax distribution using wrong main account
    Hey,
     
    I would suggest to go to the ledger posting setup, select your desired line, delete it and create a new one with the same setup as before deleting. In case you recently changed something on the line, it can be buggy. We havent figured out when it happens, but it does and deleting the line solved the issue. It didnt happen when creating a line without changing it. 
     
    Kind regards, Adis
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    Expense management: Tax distribution using wrong main account
    Hi Y.K.,
     
    Yes, the screenshots are visible now. Can you also check what main account is set up on the Tax ledger posting group linked to the Tax code that is used for the combination of the Tax group and Tax item group?
  • YK-04061943-0 Profile Picture
    YK-04061943-0 11 on at
    Expense management: Tax distribution using wrong main account
    Anyone with a suggestion regarding this issue? Are you able to see the screenshots now? Thanks!
  • YK-04061943-0 Profile Picture
    YK-04061943-0 11 on at
    Expense management: Tax distribution using wrong main account
    That makes sense. I just updated by taking actual screenshots and pasting them. Can you guys see the images now? Thanks!
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    Expense management: Tax distribution using wrong main account
    I got a quick reply that there should not be an issue. We checked the page source and it looks like you shared an URL to an image that is within your own email attachments. This is visible for you, but not for us as we don't have access to your email folder.
    Can you try to post the images in a different way?
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 287,696 Super User on at
    Expense management: Tax distribution using wrong main account
    Unfortunately, I'm not able to see the screenshots. I will try to contact the administrator of this forum to check if there is a known issue.
  • YK-04061943-0 Profile Picture
    YK-04061943-0 11 on at
    Expense management: Tax distribution using wrong main account
    I do see the screenshots. Initially, one of them didn't upload but I can actually see all of them. 
     
    Y.K
  • Hana Xue Profile Picture
    Hana Xue Microsoft Employee on at
    Expense management: Tax distribution using wrong main account
    Hi,
    Not sure if other people can see the screenshots, but for me, the screenshots did not display properly on the forum. This may be a problem with the forum, please try to upload it again to see if it works.

    Best Regards,
    Hana

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans