Query with travel advances approved and not posted in FI

[Former Member]

Hello,

We had implemented Travel Management and we want to make a query with travel advances approved and not posted in Financial Accounting. Do you know in what tables this information is stored?

Can you help me, please?

Thanks

ML

[Former Member · Accepted solution]

Select all trips with status approved and <= settled (but not posted). A query will not help - because posting data is set in cluster segment ROT

[Former Member · Accepted solution]

Hello Siegfried!

In what transaction code? I only want to see the advances not posted, not all trips (without advances). There is a report with advances amount?

Thanks very much,

ML

[Former Member · Accepted solution]

try transaction S_AHR_61016402

[Former Member · Accepted solution]

This transaction doesn´t work for these cases. Because we are talking about trip advances (before the trip) and not trip receipts (after the trip).

Do you know another transaction for listing trip advances?

Thank you.

[Former Member · Accepted solution]

Hi Monica,

What about using report PTRV_PAYMENT_HISTORY?

In the "Status" tab:

Request/Trip Ind. = 2

Settlement Status = 2

In the "Totals" tab:

Advance Amount = $1 to e.g. $10 000

Hope this helps,

Anri

[Former Member · Accepted solution]

You are right. Even Advances are stored in a expense type (VORS) this wont be selected

So take the transaction S_AHR_61016405

Here you select your status properly and the tab Totals as you require...