How to allocate 1 credit card transaction to many expense types

[Former Member]

Hi experts,

Is it possible to link many line items with the different expense types (in receipts tab in PR05) to the one credit card transaction?

For example, the employee paid only once when checking out by using credit card with amount 1000 USD.

It consists of

500 USD for accommodation

300 USD for meal

200 USD for transportation

Since the company has the different G/L account for each expense type, and does not want to combine all transactions into accommodation.

If we adjust manually in PR05, it seems that only 1 item link to credit card data.

Thanks,

[Former Member · Accepted solution]

The user can use the Receipt Wizard to allocate the expense across mulitple expense types. The original expense type that is defaulted for the expense must be configured to be able to use the wizard. You can check this setting in T706B1. Field is REWIZ.

[Former Member · Accepted solution]

This is the exactly what I need. Thanks.

[Former Member]

Hi Chupong,

Have you maintained the entries for the above mentioned 3 expense types in V_T702B table?

If possible kindly share the V_T702B table entries screenshot.

Regards,

Narayana

[Former Member]

Dear Venkat,

Yes we did it, below are the example entries in this table.

VI Visa International	HOTEL.....	01.01.1996	31.12.9999	HTL	10
VI Visa International	HOTEL.....	01.01.1996	31.12.9999	HTLP	10
VI Visa International	TRANS.....	01.01.1996	31.12.9999	TRAN	10
VI Visa International	TRANS.....	01.01.1996	31.12.9999	TRAP	10
VI Visa International	MEALS.....	01.01.1996	31.12.9999	ENT	10
VI Visa International	MEALS.....	01.01.1996	31.12.9999	MELP	10

When the employee used hotel's limo, had meal in hotel and paid all expenses when checked out. The credit card company send the VCF file to us only 1 transaction and all amount go to Hotel accommodation. And we want to allocate to the correct expense type.

Best regards,

[Former Member]

By seeing the V_T702B table entries, there is no problem with this table. Can you write down the steps which you made towards the Credit Card Clearing configuration with screenshots. May be I will get some clue to point-out the issue.