Travel and Expense Management

(0) Share

Report

Posted on by Ethan Ong

Disappointment for the above!

I mapped my employee/worker as Vendor to better track the employee expenses. Also, I would have to ensure these reimbursement can be net off against any cash advance to the same employee if any.

Hence, the mapping with Vendor Account created and linked to Expense Management in Human Resource. In addition I create my Staff Advance using Ledger account for Cash Advance. Subsequently I mapped my Reimbursement expenses (Payment Method) as Worker.

The testing give me a disappointing cash advance where Debit: Staff Advance (Ledger Type) | Credit: Vendor (Staff). Instead it should be Debit Vendor | Credit Bank

Conversely, the posting transactions for ExpenseReports was satisfactory.

Can anyone advice?

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

Hi,

I think you have not properly configured your payment method. In your payment method please make sure that you have selected the Bank as offset account type. Also, in case of cash advance, the ledger which gets debited is actually the accounts receivable and the credit is cash or bank. This is how the cash advance posting works in AX.

Was this reply helpful? Yes No
Ethan Ong on at

Like (0)

Report

Hi,

I need to know the configuration for Cash Advance,

At this moment I set my employee as Vendor in the Expense Management, whereas the Cash Advance in the Travel and Expense Setup, I had configured as Ledger Staff Advance.

When posted, the results end up Debit Staff Advance and Credit my Employee.

Was this reply helpful? Yes No
Raul Cardin 5 on at

Like (0)

Report

HI, We are also having problems with the acoounting logic and the journals that generates the system, for example in the first movement.

Cash Advance: The first thing we did was to assign a vendor account to the employee, After that i request a cash advance in the enterprise portal, once authorizde the application the system sends the request to the module of travel and expense, so i select the cash advance y pay it, but the system generates a journal that affect on the Credit the account of the employee/vendor and Debit to the bridge account that we have to create as "Cash Advance", so we had to make a manual journal that affect the Debit (Employee/Vendor) and Credito to the Bank, whit this movement we acctually pay to the employee, But there some issues, first of all someone would have to make this journal manually and what happend if the employee dont make the expense report, how can you identify that the employee owns the cash in advance. ¿?

Return of Cash Advance in the Expense Report: If we make the expense report and registred a return of the cash advance, the system generates voucher that affect in the debit Vendor and credit my bribge account "Cash advance", so we had to make another manual journal, that affects the credit of the vendor and the debit my account Bank. But also this have to be manually and there is no way to track this kinds of journals whit the expense report, Is there any other option that simplify this steps ¿?

Expense Repor: Whe i report an expense for example "Hotel" that all ready configurate as Expense Category whit the account of "Expense1", if i registrate that my "Payment Metod" was "Cash", The system generates the journal That affects the debit of Cash and the credit of "Expense1", so i think this account works also as a bridge.

Finally to gets the bridges account to zero, i had to registred another manual journal that affecting with the same amount of the expenses reported, This journal affects in the Debit "Cash" and credit "Cash Advance", whit this steps the account Bank gets the amount in credit and "Expense1" in the debit.

Movements:

D / C

1.- Request Cash Advance "System" $200 (Cash Advance / Vendor)

2.- Pay of the Cash Advance "Manual" $200 (Vendor / Bank)

3.-Return Cash Advance "System" $50 (Vendor / Cash Advance)

4.-Expense Report "System" $150 (Expense1 / Cash)

5.-Pay the Return to Bank "Manual" $50 (Bank/Vendor)

6.-Liquidation Bridge Account "Manual" $150 (Cash/Cash Advance)

Can you help me if im doing well ?.

Was this reply helpful? Yes No
Ethan Ong on at

Like (0)

Report

Hi Raul,

Your concept works, but it induces more labor tasks rather than having it automated. I was made to believe having the functions to map my workers to vendor and configuring my cash advance ledger to a designated account would able to assist in delivering immediate posting once the cash had been physically disbursed and vice versa.

I believe the similar functions that Microsoft had created was the Prepayment whereby once the payment journal has been indicated as prepayment, the entries should had been reversed and captured immediately as Debit Vendor/Worker | Credit Bank (during Cash Advance) and Reversed to Matched against expenses and remaining returned to bank.

Hence, need to look for the trigger point for the same "Prepayment" Mechanism (if any).

As for normal expense report I would to assume this as Normal Business (in Malaysia) practise where employees carried out claims ONE month before actual disbursements. Hence, I had actually configured the Payment Method as Cash, but belongs to Company's expenses and associated with specific company's bank account. In this case is no longer Accrual Accounting but Cash Accounting.

Open to more suggestions.

Was this reply helpful? Yes No
Aida Barajas 210 on at

Like (0)

Report

Hey Guys,

I don't know if someone can help me with the next, I just set up the employee exenpeses.

But once I try to Access to Employee Portal to test, the coming msj comes up. And I don't know how I can acces..

Tks for your help...

Was this reply helpful? Yes No
Ethan Ong on at

Like (0)

Report

May I know the exact message?

Was this reply helpful? Yes No
Aida Barajas 210 on at

Like (0)

Report

Sure,

I just setup travel expenses, once I get to Employee Portal in order to tests it.

I cannot access, The system shows the coming message: Your are not currently mapped to an employee record in Microsotf Dynamics AX. You do not have Access to enter expenses report.

Is the first time I am using Employee Portal,

Thank you very mucho for you help

Aida B

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

check privileges, seems like you don't have rights to access portal.

Was this reply helpful? Yes No
Aida Barajas 210 on at

Like (0)

Report

Thanks Bashir for your friendly answere.

Let me ask you something where should I check privileges ?? on AX ???

The user I am using on Employee Portal is the Administrator, how can I set up on AX ??

Thanks !!

Aida B

Was this reply helpful? Yes No
Suggested answer

Bashir Ahmad 5,248 on at

Like (0)

Report

Go to your user record, select the user relations button, link it to the employee you have created.

Was this reply helpful? Yes No