Expense posted to same GL to be bifuracted

[nitin_jain35]

Hello Gurus,

Please help me with following requirement:

Business Scenario:

Staff Welfare is used to post expenses pertaining to Tea/Coffee AND expense for B'day/ snacks / other parties AND Trophies/ Certificates. Without creating new GLs for seperate expenses, user needs the expenses to be bifurcated (eg. Tea/ Coffee expenses only). Curently only identifier is Header Text field. So the bifuraction activity is done manually every month.

Note:  The cost centers already exist for combination of Co. Codes, Department & locations.

Please guide (what other options are available through Configuration for bifurcating expenses posted to same GL)

[Former Member · Accepted solution]

Hello Nitin

Use Assignment field at the time of posting entry's .

[suma_mani · Accepted solution]

Hello Nitin,

Either you have to use assignment field / any other fields like ref1,2 & 3 or else you must use statistical internal order's to differentiate the transactions. You have to enter cost center as real object & IO as statistical object.

Regards

Mani

[nitin_jain35 · Accepted solution]

Hello Mani,

Thanks for your response.

We are already using Internal Orders (statistical) for CAPEX & OPEX reporting purposes. Can't use IO for this purpose.

[nitin_jain35 · Accepted solution]

Thanks Soma for suggestion.

I am trying the Assignment (not sure how it will be different from Reference field- which is being used currently). As of now it seems even after using Assignment field, the report will have to be manually prepared. But, let me test and will update then.

[nitin_jain35 · Accepted solution]

@ Soma,

I have tried Assignment field and asked business users to do testing too. The only problem we are facing is that because it is a text field and because of multiple users in multiple locations- the chances of manual text entry being different is quite high, which is unacceptable to business. So looking for any other alternatives/ suggestions.

[Former Member · Accepted solution]

Hi Nitin

You can have validations (GGB0) in place for that field with Text seperately stored in Customisable Z Table and then system comparing the fields and if ok, allowing the user to post the document. For this you may need user exit

Alternatively, you can make use of Statistical WBS / IO.

Regards

Mustafa

[nitin_jain35 · Accepted solution]

Pls give me some time to validate...

[subhadeep_das]

Hi,

can you pls check the usage of functional area. I dont remember the exact configuration.

best regds

Subha

[nitin_jain35]

Thanks Subha for the functional area suggestion. This was rejected by business users even before and they are not in favour of an additional field (in addition to existing Cost Center/ WBS Element, Internal Order, Business Area, Company Code- already in use).  Moreoever they are of opinion that this bifurcation is needed only for a single GL and if functional area is implemented, users will have to enter it for all other entries too (Will lead to lot of garbage data W/o concern for functional area in case of other GLs).

[former_member222241]

Hi,

Do you want this bifurcation while booking expenses booked through Cash Journal.

Regards,

Tejas