You’re offline. This is a read only version of the page.
160
Hi Expert!
I have issues in applying cash advance to expense report
Travel and expense manual describe the applied cash advance to expense report as following:
Share
ReportCash advances are automatically applied to expense reports. The user does not
have to manually reference the cash advance on the Expense entry form. The
system automatically calculates the balance. If the cash advance is less than the
actual expense incurred, the employee is reimbursed for the balance. If, on the
other hand, the cash advance is more than the actual expense, the employee must
return the excess cash advance to the company. To return the excess amount, the
employee must add a line of the cash advance return category to an expense
report.
unfortunately, when I register an expense report, the system doesn’t credit the cash advance account as mentioned in the previous paragraph. in all cases the system debits the expense account and credit account that assigned to the method of payment and don't take in consideration that the worker already has an advanced payment.
this the steps that I did:
1- cash advance request.
Dr. cash advance account 5000
Cr. Employee account (Ledger or Vendor) 5000
2- Payment
Dr. Employee account (Ledger or vendor). 5000$
Cr. Bank 5000$
3- expense report (this is the issue)
according to the travel and expense manual the system should credit the cash advance account if the expense is less than the cash advance amount and generate the following entire
Dr. Expense Category 4000$
Cr. Cash advance account 4000$
unfortunately, the system generates the following:
Dr. Expense Category 4000$
Cr. Worker account (Ledger or Vendor) 4000$ // this account change depending on the method of payment but on my case I have one method of payment which assigned to worker account..
please advise
*This post is locked for comments
Based on the payment method, we have the following transaction:
Expense owner = Company
Offset account type = Worker
Dr-Expense
Cr-Worker account (Ledger or Vendor)
Expense owner = Employee
Offset account type = Worker
Dr-Expense
Cr-Advance to employees
Hi every one
When the expense report is less than the cash advance balance amount, the following voucher is issued
Dr-Expense
Cr-Cash advance account
The following voucher is issued when the expense report is greater than the cash advance balance amount
Dr-Expense
Cr-Cash advance account = (cash advance balance amount)
Cr- Worker account (Ledger or Vendor) = (Expense-cash advance balance amount)
thanks anyway.
unfortunately no
Hi Mohammad,
I've got the same error on D365FO. Did you get the solution on that ?
Regards,
unfrotunately
Hi,
Here is a blog post for D365fO. about this topic
Can you check if what is described there answers your question?
Best regards,
Ludwig
Hi Mohammad, I think we both have the same issue. Did you find out how to solve this?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (