Employers must reimburse employees for business expenses no matter how long it takes them to be entered into AX. According to existing functionality, the "Transaction Date" in the expense report line is used for determining which period the expense report line should be posted. If the period is closed, the expense report cannot be posted. As a work around, the expense report transaction dates could be changed to a current date, but this will make reconciliation by travelers far too tedious and will result in differences between attached receipts and the report itself. This is not acceptable from a regulatory perspective. Is there some way to post an expense report with transactions from a prior period into a current one while retaining the correct transaction date?
Did you ever solve this one? We're running into the same issue.
Hello, We have logged a bug and Product Development asked some questions about a proposed resolution. Apparently we were not the first ones to have this issue so hopefully they will provide a fix in a reasonable timeframe.
Expenses should be booked on a daily basis by the employees for reimbursement of the same. In an actual scenario, this cannot be implemented due to many reasons. So customize by including an actual date of travel on the form and the date expense report was submitted without any validation with the transaction period. Date of submission of expense report will be the actual date on which it can be posted.
Barry, adding a field for tracking the transaction date doesn't work for accrual accounting. Expenses should be posted to the period in which they were incurred. Adding an additional column doesn't fix the problem with expense transactions posting to the wrong period. This is a Microsoft bug that needs to be fixed.
Dear Jim and Shantanoo, Thank you for your comments. If Microsoft does not fix this, we plan to do something similar to what Shantanoo (a.k.a. Barry) describes. This is the least invasive customization to fix a major design flaw and is in-line with what Microsoft suggested too. Microsoft admitted that they dropped this functionality from 2009 due to resource constraints.
This is today's update to the recorded bug, so I will continue to hope for resolution within 4-6 weeks, but may need to prepare for customizing:
"Unfortunately, Development is still figuring out what they want to do with this one. We have actually had 3 incidents open reporting this same problem since you came in so we have active discussion going on how to handle all the scenarios that are possible with automatic posting, workflow, etc….
We are making progress and something will be done to allow you to post into the open period rather than get an error but we are still discussing how it will handle."
Did you get the resolution for this issue. Can you please share this with me.
Microsoft provided a hot fix, but it has not been tested yet; see note from Microsoft:
The hot fix for your issue has been packaged and placed on an HTTP site for you to download.
WARNING: This fix is not publicly available through the Microsoft website as it has not gone through full Microsoft regression testing. If you would like confirmation that this fix is designed to address your specific problem, or if you would like to confirm whether there are any special compatibility or installation issues associated with this fix, you are encouraged to speak to a Support Professional in Product Support Services.
KB Article Number (s) : 2852252
Language: All (Global)
Location: ( hotfixv4.microsoft.com/.../463989_intl_i386_zip.exe )
NOTE: Be sure to include all text between '(' and ')' when navigating to this hot fix location!
Thanks for the response. Actually what is our requirement is that the posting date should be the date on which the automatic posting workflow post the expense report. Can you suggest any easy way of achieving it?
Thanks in advance,
No, I do not know, but if the hot fix does what it is supposed to then it should be pretty close to what you are looking for.
has anyone tried the hot fix?
The hot fix works but be careful and review your license configurations. When we installed ours it made a change to the licensing configuration and I was prevented from editing an address within the HR module for an employee. Also they provide a nice report that lets you see the original transaction date and the posting date for reconciliation purposes. The only problem is they did a poor job naming the report on the report menu.
I have a slightly different question that I was hoping someone could reply to. I agree that the transaction date on the expense report line is the date used when posting to the ledger in an open period becuase it is in agreement with accounting principles. However our company fiance VP is asking to have the date that the AP clerk actually posts the expense report to be the posting date on the ledger. This is slightly different than the hot fix solution which allows you to post an expense report in an open month for transaction dates that are within closed periods. Does anyone have an idea how to go about this?