Profit Centers

[Former Member]

Hi All,

we had created Dimesions for Location, since my client has multi location and needs to track the expenses.

Now the issue is when raising a Incoming or Outgoing Payment there is no option to select the location, with which the balance for Location-wise is going for a toss.

is there any work around where in when passing the Incoming or Outgoing Payment location to be selected.

Currently i had a work around, once i enter the transaction it will be updating in Journal Entry, then i go that particular Journal and enter the location. this is a temporary solution and is very tedious for the client, as they pass around 50 transactions a day.

Please suggest me on how to resolve this.

Regards

Shanker

[Former Member · Accepted solution]

Hi

Your issue can be addressed in 2007 Version onwards.

Regards

Rashid

[former_member187989]

hi sankar,

Profit centres will be available in 2007 Versions.

As a work around try to retrieve JE's created from outgoing/incoming payments using SQL Query,

then update JE'S using DTW oJournalEntries templates.

Select T0.TransId,T0.TransType,T0.RefDate,T0.Account,T0.Debit,T0.Credit,T0.ProfitCode 
From JDT1 T0
Where
T0.TransType IN (24,46) AND T0.RefDate BETWEEN '[%0]' AND '[%1]'

Transaction Type - 24 - Incoming Payments

Transaction Type - 46 - Outgoing Payments

Since you have 30 transactions at end of the day you can update JE's profit centres easily thru DTW.

Try it and let me know.

Hope problem will solve.

Jeyakanthan

[Former Member]

Hi All,

Thanks for the suggestion.

Let me have a test run and verify that, i thing it will be little cumbersome process.

Anyways let me try that and get in touch with you all.

Regards

Shanker

[Former Member]

Hi Shankar,

If your GL accounts is fix for specific Profit Center then you can assign distribution rule to that account in Chart of Accounts.

Regards,

Abhishek