Dynamics Community Forum Thread Details

My question has two parts:

1) How are other customers reconciling their ledger during month end for the main account used for cash advances? The balance sits in the EM module as a balance on the cash advance but we are not seeing a report available to reconcile ledger and as part of month end processes finance are instructed to reconcile sub-ledger to ledger.

2) See full process below for cash advance through to liquidation process and the expectations from finance for the cash advance return category functionality. The expectation is around the GL account is not being met , how are other companies managing this step? Enhancement or should this be considered an issue with the base product?

1. User creates cash advance in EM module
  1. Cash Advance posts to AP- vendor as balance owed to employee (invoice)
  2. Cash Advance posts to EM as an advance with a balance
  3. Cash Advance posts to GL advance account
2. Payment for the invoice is made in AP
  1. Cash Advance is cleared out of AP module, removed from the vendor
  2. Cash Advance remains as a balance in EM
  3. Cash Advance remains as a balance in GL
3. User creates an expense report to liquidate the cash advance
  1. Scenario 1 - advance and expense report match 1:1
    1. cash advance fully liquidates in EM module
    2. GL advance account balance reduced to zero
  2. Scenario 2 - Advance taken was less than expenses
    1. Cash advance fully liquidates in EM module
    2. GL advance account balance reduced to zero
    3. Additional expenses post to AP - vendor as a balance owed to employee
  3. Scenario 3 - Advance taken is more than expenses and employee owes company money
    1. Cash advance in EM Module is fully liquidated
    2. GL advance account is reduced to zero
****Finance is expecting the advance account to be partially liquidated since we have yet to receive the funds from the employee at the initial step of posting the expense report

iii.Balance due to company sits in AP as money owed from the vendor/employee against the liability GL account

****Finance does not want this sitting on the liability account. They want it to still show on the advance account until the funds have been received by the employee