TM1 Forum

Hi Experts,

I would personally request you to provide me sample TM1 model related to Finance (Which can figure out Net Profit out of Business transactions).

Please, kindly note that i'm having very urgent project requirement where I need to present infront of my officials.

Please..please kindly understand my situation and provide me atleast one model.. so that I can build logic to create the model.

Thanks a lot in advance.

Regards,
Madhu

madhucogtm1 wrote:Hi Experts,

I would personally request you to provide me sample TM1 model related to Finance (Which can figure out Net Profit out of Business transactions).

Please, kindly note that i'm having very urgent project requirement where I need to present infront of my officials.

Please..please kindly understand my situation and provide me atleast one model.. so that I can build logic to create the model.

Thanks a lot in advance.

Regards,
Madhu

TM1 comes with a few sample databases, all of which are absolutely terrible and completely undersell the product but if you need to show something urgently and don't have the time to create something better yourself then that is probably your best bet.

Hi Experts,

It would be really helpful, if you can provide me atleast flow chart/diagram model to get an idea actually to start up with building model.

Please do the needful.

Regards,
Madhu

Below is my Requirement:
---------------------------------
Journal = Journal entry number
Blanace sheet = Left hand side or Debit side is Liabilities and Right hand side or Credit side Assets
Inventory = Closing stock
Financial Debt (Long Term) = Loan (Long term loans from banks or intuitions or other)
Gross Profit = Debit side (opening stock, purchases and freight (transport) - Credit side (sales)
Net Profit = Total Income - Total Expenses

-          Data source need to be use ms access
-          Dimenson need to use TI (Not manually)
-          Cube (may be one cube)

Can someone help me over here please.... pls any suggestions.

Regards,
Madhu

So, you want someone to just plain give you their intellectual property so you can pass yourself off to someone else as being qualified as a TM1 developer? I doubt you are going to have any takers on this one. You're best bet is going to be one of the IBM Blueprint models. If you are a licensed user of TM1, which I'm sure you are ( ), then your IBM rep can give you a link to the blueprints, as well as the password on the zip files.

madhucogtm1 wrote: Gross Profit = Debit side (opening stock, purchases and freight (transport) - Credit side (sales)
Net Profit = Total Income - Total Expenses......
Can someone help me over here please.... pls any suggestions.
Madhu

I think you need to check your sign conventions: for "Gross profit" you are using dr-cr, for "Net Profit" you have cr-dr which is inconsistent. HTH

stephen waters wrote:

madhucogtm1 wrote: Gross Profit = Debit side (opening stock, purchases and freight (transport) - Credit side (sales)
Net Profit = Total Income - Total Expenses......
Can someone help me over here please.... pls any suggestions.
Madhu

I think you need to check your sign conventions: for "Gross profit" you are using dr-cr, for "Net Profit" you have cr-dr which is inconsistent. HTH

I was more intrigued by this bit:

Blanace sheet = Left hand side or Debit side is Liabilities and Right hand side or Credit side Assets

Clearly accounting theory has changed somewhat since I studied it.

But then of course I did study in the same class as Luca Pacioli.

The other requirement that I found quite fascinating was:

Journal = Journal entry number

Mmm, transactional level storage in TM1. I suspect that anyone here who charges money for their expert services will see a flaw in this methodology.

Alan Kirk wrote:

Blanace sheet = Left hand side or Debit side is Liabilities and Right hand side or Credit side Assets

Clearly accounting theory has changed somewhat since I studied it.
But then of course I did study in the same class as Luca Pacioli.

Oooh, didn't spot that. But I was taught "Debits by the window, credits by the door" (copyright John Moffat 1980) so maybe I was just sitting the wrong way round.

Looks like your not going to get a straight answer to this question

If it were me, I'd start with creating a few dimensions around your Accounts, Period, Cost Centres etc that you would report by. Apply your Chart of Account structre to your account dimension and you'd be somewhat on your way there.

As the guys have alluded to here, maybe go talk to the accounting team for clarification on how it should work.