web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Cash Advance Posting

(0) ShareShare
ReportReport
Posted on by 205

Hello,

I searched the forums but I couldn't find an answer.

 

When I post (pay and transfer) the cash advance request the Bank account defined in the Cash Advance Accounts is debited and the vendor account related with the employee is credited. This doesn't show any meaning to me because when the money goes from bank to employee, bank should be credited.

Employee: Credit

Bank: Debit

Also when I post an expense report to an employee the same vendor account is credited again, which is correct. So how can I settle the expense report against the cash advance when both transactions in vendor account (cash advance payment and expense report posting) are credit type entries?

Employee: Credit

Expense Account: Debit

Thanks in advance.

Bekir

*This post is locked for comments

I have the same question (0)
  • Cherry Profile Picture
    25 on at

    i am having the same problem as well....how can i see the set up?thanks

  • Suggested answer
    Community Member Profile Picture
    on at

    I think above is an issue of incorrect setup and AX's misleading configuration screen. Setup and process according to me should be as follows to have right financial flow:

    1. For the cash advance accounts by the currency - Bank should not be selected. This is the misleading configuration which will lead to the issue stated as above. Here select the ledger account, which should be a ledger account say "Employee cash advances".

    2. The Travel & Exp GL journal - you could define the default offset account a vendor. This will result in:

    DR - Employee cash advances

    CR - Employee vendor account.

    3. You make a payment to employee using vendor payment journal

    DR - Employee vendor account

    CR - Bank account.

    Accordingly the setup should be done in Expense categories of type return cash advance to settle the Employee cash advance account.

  • Cherry Profile Picture
    25 on at

    hi.

    Thanks for the information but can you provide into details on how to set up for cash advances like in your number 1 because i am new in this module in ax 2012.

    Thanks for the help.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Cherry,

    For the step 1, go to Travel & Expense > Setup > Cash advance > Cash advance accounts.

    For more details on the module, I would recommend you to download the partner training materials from the partnersource.

    Regards,

    Dwij

  • Cherry Profile Picture
    25 on at

    Hi,

    I've followed your instruction in the set of cash advance accounts but still the debit is still on the bank. Is there any set up i've missed to check?

    Thank you.

  • Community Member Profile Picture
    on at

    Hi Cherry - If you follow the setup exactly as I mentioned in my 3 step approach it should not be the case. My point no. 1 is the main setup. Could you confirm for the applicable currency the account type is a ledger account which is not a Bank ledger account?.

    Also are you testing it in AX 2012 R2 CU6 and above?

  • Cherry Profile Picture
    25 on at

    Hi,

    yes i followed all those necessary set up. i am just on the procedure of pay and transfer in cash advance. yes the account type that i choose is a ledger and not a bank ledger account. i am just wondering why the bank is being debited.

    thanks

  • Community Member Profile Picture
    on at

    Hi,

    Could you tell me following to help you further?

    1. What is the default offset account and its type in the Journal Name for the Travel & Expense GL journal?

    2. Are you testing it in AX 2012 R2 CU6 and above?.

    Regards,

    Dwij

  • Cherry Profile Picture
    25 on at

    Hi,

    the debit is bank and the credit is vendor. yes i'm using it.

    thanks.

  • Community Member Profile Picture
    on at

    There is only 1 default offset account possible for a journal. Please check that for the journal that is being used in the Travel & Exp setup.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans