Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Clint Meade]

Hello Group,

I’m in the process of exploring Expense Management and it’s ability to replace Concur for our travel and expense management needs. While I’ve become fairly acclimated to Expense Management in D365FO, I’ve run into a strange posting situation. It seems I’m unable to post an approved expense report due to error “The transactions on voucher do not balance as per <date>” which makes sense based on what I’m seeing happen in the subledger journal (see attached). 

I seem to have the “payment methods” (see attached) and “expense categories” (attached) all configured correctly, however, when posting this one rogue entry ends up in the journal (see attached). No matter if it’s a “cash” or “credit card” payment method this “21500…..” ledger account keeps ending up in the journal and also seems to end up with the dimensions for my offset account wherein the source dimensions should end up on the line associated with ledger account “20300…..”, not this other rogue account that’s coming from who knows where.

This seems like some sort of weird GL issue but I’ve looked at everything I can thing to look and still unsure why my reports are trying to post to this account and ultimately throwing off my balance causing reports to not post.

Any thoughts or inputs are appreciated.

#FinanceandOperations
#ExpenseManagement
#D365FO

????

——————————
Clint Meade
Thruline Marketing, Inc.
Lenexa KS
——————————

[Kerstin Newman]

Hi Clint,
It looks like you have something set up in the GL module that automatically creates an “interunit” post? Did you create that expense we see in the voucher in a way that another unit should be carrying the expense rather than the one you entered it into? I am not sure if that is even possible, but that’s the only thing I can think of that might make sense?

——————————
Kerstin Newman
Business Analyst
StarTech.com
London ON
——————————
——————————————-

[Sharon Nolan]

?Hi Clint:
Have you checked your Accounts for Automatic Transactions (GL > Setup > Posting)?  It appears, based on your screenshots, that you have a Posting Type of Interunit-Credit set up here and possibly this is where the 21500 account is coming from.  We do not use interunit functionality in AX2012 so I’m unable to pass along much on that topic.  I believe there is also additional setup for this functionality on the Ledger (GL > Setup > Ledger).

Hope that might point you in the right direction.

Thank you

——————————
Sharon Nolan
Senior ERP Business Analyst
Bay Industries Inc.
Green Bay WI
——————————
——————————————-

[Clint Meade]

Thanks for the response Sharon and Kerstin. After a bit more digging, I found that one of my dimensions in play in the expense report is set as our “balancing financial dimension”. As best as I can tell, this is getting invoked and pulling in the the account from “Accounts for Automatic Transactions” due to the source dimensions, including the one set as the “balancing financial dimension”, not getting applied to the offset account. Just for kicks, I went ahead and removed the dimension from the “balancing financial dimension” (in sandbox of course) and sure enough the interunit automatic transaction no longer appears, however, my offset account still isn’t picking up the dimensions from the source account.

So, it seems the actual issue here is that the source dimensions aren’t being applied to the offset account. Anyone ever see this before? And since my “account structure” for my offset account (20300) requires all the same dimensions applied to the source account, the report still won’t post.

Thanks,

——————————
Clint Meade
Thruline Marketing, Inc.
Lenexa KS
——————————
——————————————-

[Clint Meade]

I think I’ve gotten to the bottom of this but not sure I like my findings, however, it seems like the behavior is likely by design. For the “Report heading fields”, I’ve hidden everything except for “Description” as that’s really the only thing we supply in Concur when creating a new report. For the “Expense line fields” I’ve set the normal fields to display, including dimensions. It is at the line item level that I’ve been attributing dimensions to transactions and since I’ve not been displaying “dimensions” as a “Report heading field”, I’ve not been attributing dimensions at the report level upon creating a new expense report.

I decided to show dimensions in the “Report heading fields” and went ahead and attributed dimensions. Voila, dimensions appeared in the offset account as I’d expect them too based on what I entered during the creation of the expense report. Also noticed these same dimensions carried over to each of the transactions as well. Assuming this is “by design”, why wouldn’t the dimensions I set for each transaction carry over rather than using the dimensions set at the expense report level? This means I would have to select similar unattached expenses per report to ensure expenses are getting the correct dimensions under the offset account. Not ideal. Also means I have to clutter up the “New Expense Report” form with our extensive list of dimensions.

Any thoughts on this behavior? Am I the only one experiencing this?

Thanks,

——————————
Clint Meade
Thruline Marketing, Inc.
Lenexa KS
——————————
——————————————-