Microsoft Dynamics AX (Archived)

Cash Advance Posting

(0) Share

Report

Posted on by Bekir KATRANCI

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

All responses (13)

Answers (0)

Suggested answer

Darshan Jog 35 on at

Like (0)

Report

RE: Cash Advance Posting

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

Like (0)

Report

RE: Cash Advance Posting

Did anyone finally conclude on this? I am in a similar situation and stuck here.
sumit0417 2,890 on at

Like (0)

Report

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 on at

Like (0)

Report

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 25 on at

Like (0)

Report

RE: Cash Advance Posting

Hi,

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

thanks.
Community Member on at

Like (0)

Report

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 25 on at

Like (0)

Report

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 on at

Like (0)

Report

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 25 on at

Like (0)

Report

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 on at

Like (0)

Report

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