In my travel and expense module, the invoices generate just fine but post to the employee's vendor account as one invoice per expense line? I would prefer one invoice per expense report with the GL detail split out into separate offsets. Is anyone aware of a way to configure the system in this way?
For all the expense lines of the expense report, system will create one line for the Vendor transaction(Liability) and individual debit lines for the expenses. See screen below.
Is this not happening in your system ? Can you send me a screenshot of your expense report and the voucher after posting it ?
Your screen shot is how I would want my system to behave. Is there also only one open invoice on the vendor in your case as well? That is what I really want so an AP person does not have to manage multiple payments.
The below postings show that for one expense report (CORP-000005) with 2 lines, there are separate vouchers and separate payables. I am curious now as if this is because the expense lines have a different date. Employees are entering the actual date of the expense so a one week trip will have many lines. I am going to test this now but think that must be it. Do you advise people to enter one date for all transactions?Thank you very much for leading me to the solution.John
I see your scenario now. If the expense lines are on different dates, then system will create different vendor invoices. From system's point of view, this is correct also, as the amounts needs to be accounted on correct dates. Also system cannot know on which date to create the single vendor invoice line.
But I agree in terms of the AP users that they will need to make multiple payments for the same expense reports.
Per my knowledge, there is no parameter controlling this. Let others share if any one has come across any such parameters.
Thanks again. I agree with the system logic and do not think there will be a parameter for it.
I am surprised that there is not a standard functionality for 2 dates on the line, one for "expense date" which is informational and one for "transaction date" which drives the postings. You could have a parameter to have the transaction date default to the expense date or the date of physical entry.
Maybe we will see that in a future release!
From an accounting point of view, an expense needs to be recorded in the books when the expense has been uncured, so I don't think there is anything wrong with recording the expense/invoice for the date it is reported on.
However, having multiple invoices does not mean there need to be multiple payments.
If you set all these invoices with a Method of Payment, where period field is set to "Total", then when you perform your payment run, all these "invoices" will be accumulated into a single payment for the total amount.
uncured >> incurred (darn auto spell correct!)
Yup Zvika. Your recommendation is correct. It all depends on the Method of Payment configuration.
No argument from me on the accounting priciples of recording the expense on the day it occured, and paying all open invoices with one payment makes sense.
The only thing we run into is the reality that people don't always do their expenses on time and may be turning in expenses that occured in a closed accounting period. In this case, it would be nice to have a "expense date" and a "posting date".
I just discovered another thread for the same issue.
Apparently, Microsoft is recognizing there is a design flaw here, and some people managed to get a hotfix
The Employee Portal is creating a new invoice for each employee expense line item regardless of the date. We tested this using multiple lines with the same date. Multiple invoices were still created. Any other ideas?
How did you fix this issue? I am facing the same issue on AX2012 R3 now.. We are supposed to have one invoice on vendor for one expense report and not the number of lines the user entered on enterprise portal..
Please let me know how you handled this?
How to setup in expense so that we can get above posting journal. I have setup main account in expense category but not sure what parameter to set in payment method so that it create journal in AP as outstanding invoice.
Is employee to be set as vendor or something else I am missing.
If you could share your thoughts that will be great.
Each employee (for whom the expense report created / to be paid) should be associated with Vendor. I hope that you would have done this setup. Please confirm.
Yes I am testing expense for my ID and my ID is set to one of the vendor. I have tested all possible combination with payment terms but not able to figure out what is failing to create vouchers.
Thanks for feedback.
Have you posted the expense report...???