Reading through Infors Business Engine guide it says to join FGLEDG to FBAKEY. Low and behold no common columns to join on. Has anyone experienced this and found a work around?
I do not join FGLEDG d to FBAKEY. You create records in FBAVAL in M3 (GLS215/GLS690) that create summaries of FGLEDG at the various levels you want, i.e. a sum of dimension 1-4, and another one that is a sum of dimension 1-5). These summary totals in FBAVAL have to be joined to FBAKEY. I put an example below. FGLEDG is the detail that feeds into the summary records in FBAVAL which join to FBAKEY.
SELECT FBA.RVCONO AS Company, FBA.RVYEA4||'-'||right(concat(0,FBA.RVPERI),2) AS PERYR, FBA.RVACAD + FBA.RVACAC AS Rec_Amt, FBA.RVCUAD + FBA.RVCUAC AS For_Amt, FBA.RVACQD + FBA.RVACQC AS Qty, FBA1.RKDIVI AS Division, FBA1.RKBIT1 AS GL, FBA1.RKBIT2 AS Cost_Center, FBA1.RKBIT3 AS Dept, FBA1.RKBIT4 AS Prod_Grp, FBA1.RKBIT5 AS BusLn_MachFROM M3DJDPRD.FBAKEY FBA1, M3DJDPRD.FBAVAL FBA WHERE FBA1.RKCONO=FBA.RVCONO AND FBA1.RKPTID=FBA.RVPTID AND FBA.RVCONO = 999 AND FBA1.RKDIVI = '240' AND FBA1.RKBAKY = 15 AND FBA.RVYEA4 = 2011 AND FBA.RVPERI = 0AND FBA.RVVTYP = 0
Is that the route you go for a full detailed trial balance report?
I run a report in RGS600 (based on the values of our Financial reporting) then i use a report in AHS110 to see all details included in the line. The report is based on FFRPCI. What you can do in RGS600 you can create a report with all your accounts and the balance key necessary for those account and then use the table FFRPCI to see all details.
If it helps i can show how it is setup in our environment. We are multitenant customer
I will take you up on that. I can't believe M3 doesn't have an OOTB Trial Balance Detailed Report!