Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Cash Advance Posting

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

  • Suggested answer
    Darshan Jog Profile Picture
    Darshan Jog 35 on at
    RE: Cash Advance Posting

    Yes: after step one you have to post a Vendor payment journal to settle the $450 vendor balance.

  • AX Aspirant Profile Picture
    AX Aspirant 25 on at
    RE: Cash Advance Posting

    Did anyone finally conclude on this? I am in a similar situation and stuck here.

  • sumit0417 Profile Picture
    sumit0417 2,890 on at
    RE: Cash Advance Posting

    Hi Dwij,

    I am still confused on the Cash Advance process. This is what I am doing in AX:

    1. Create a Cash Advance for $450. This is the postings:

    DR - Employee cash advances - $450

    CR - Employee vendor account - $450

    So my Vendor Balance is showing Credit $450(-$450)

    2. Now I post an expense report for $450 and these are my postings:

    DR - Ledger account defined in the expense categories

    CR - Employee vendor account - $450

    So now my Vendor Balance becomes Credit $900(-$900)

    Now should I post a manual payment journal after step 1 to debit the Employee Vendor account and then post a manual payment journal after step 2 to debit the Employee Vendor account.

    In the realistic scenario the Expense report should automatically settle against the Cash advance amount and I should not post any payment journals manually.

    Thanks in advance.

    Sumit Potbhare

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Advance Posting

    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.

  • Cherry Profile Picture
    Cherry 25 on at
    RE: Cash Advance Posting

    Hi,

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

    thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Advance Posting

    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
    Cherry 25 on at
    RE: Cash Advance Posting

    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
    Community Member Microsoft Employee on at
    RE: Cash Advance Posting

    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
    Cherry 25 on at
    RE: Cash Advance Posting

    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.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Cash Advance Posting

    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

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans