TM1 Forum

Hi All, Below jstrygner has written: "Anyway maybe this hint will help you. In your SQL you can write something like: Code: Select all select COL_MONTH, COL_REGION, COL_PRODUCT, ... from FACT_TABLE where COL_MONTH in ('?sMonthList?') and COL_REGION in ('?sRegionList?') and COL_PRODUCT in ('?sPr...

I asked our ERP system guys to create a view of the "other side" of every cash transaction in our ERP system. This involved, for instance, tracing a payment from the bank account to creditors, seeing which invoices that payment was for and recording the general ledger account coding/s for ...