Skip to Content
avatar image
Former Member

Posting in FI with different GL code in Travel Management

Dear Experts

I have created travel expense types  for travel management for Bangladesh. I need to do FI posting based on trip activity types & trip location.

There is different GL codes-

GL Account Number      Description

611069                         Training & Development- International

611070                         Training & Development- Local

621141                         Board Meeting Expense

621120                         Travelling & Lodging - Local

621121                         Travelling & Lodging - International

113112                         Cash Advance

Trip activity types-

1. Training

2. Board meeting

3. others

Travel expense types-

1 Travel fare Local 2 Airfare International 3 Airfare Local paid 4 Board Meeting Expense 5 Breakfast 6 Dinner 7 Entertainment 8 Hotel Expense  Paid 9 Hotel Expense 10 Travel fare – International 11 Laundry 12 Lunch 13 Other 14 Other Paid 15 Parking, Tolls 16 Private Share, Paid 17 Pay Back Private Share 18 Car Rental 19 Taxi,Bus,Local Conveyance 20 Telephone, Fax 21 In city allowance for training 22 Out city allowance fr training 23 Rail Expense  Paid 24 Train Expense 25 Mile/Km Flat Rate 26 Company Vehicle 29 Hire Vehicle 30 Personal Vehicle 31 Accomodation Per Diem 32 Meals per diem 33 Cash Advance Payment 34 Advance

Now my client wants to FI posting based on trip activity types & Location of trip


Point1. If i am travelling to International for training  then all the travel  expense type will get posted in  611069

Point 2: if i am travelling to local for training then all my travel  expense type will get posted in 611070

Point 3: if i am travelling to local for others reson then all my expense type will get posted in 621120

Point4: if i am travelling to international for other reason then all my  expense types will get posted in 621121

Point5. for board meeting all the expense types will get posted in 621141

I want to use BADI TRIP_POST_FI   for the posting in FI.

Kindly suggest me , how to write logic for this or any other way  which can be posted in FI in different GL code based on trip activity types & trip location

Best regards

Anwar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 14, 2013 at 03:31 AM

    Anwar,

    You can change the G/L account by using the method MODIFY_PTRV_DOC_IT method of the TRIP_POST_FI BADI.

    Let me know if this is answer is helpful and do let me know if you need more info.

    Thanks,

    Sreekanth

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Anwar,

      I guess we should be approaching this problem in a technical way.

      These are the things you might want to do.

           1. Let the system take whatever GL account it is using right now.

           2. Create a table to maintain Gl account, location and other details.

           3. Implement the BADI TRIP_POST_FI and inside that, change the GL account used by the system to your new GL account (from the custom table).

      Hope this helps.

      Thanks,

      Sreekanth

  • avatar image
    Former Member
    Jan 16, 2013 at 02:45 PM

    There is a standard for your need:

    The value of the formal parameter USERS in the routine FORM EXB706K in include RPREX010 of RPRFIN00 is used to read table T706K. Since the parameter USERS is initial in the standard system, the field T706K-USERS also has to be initial in the standard system.

    You have the option to use the user exit in this routine to set values for the formal parameter USERS (for example, depending on trip data) which are used when table T706K is read. This makes it possible to differentiate the symbolic account assignment to a greater extent than in the standard system.

    Add comment
    10|10000 characters needed characters exceeded