Where is the Recon table for Inventory WIP reconciliation report?

[b.huang (Ben Huang)]

Below is a query in Inventory WIP reconciliation in which a table called Recon is used. Anyone knows where the Recon table? Thank you for your help.

=“SELECT T1.AccountDesc,T1.AccountNum,T1.BookID,T1.CRTranAmt,T1.DBTranAmt,T1.TmpJobNum,T1.TmpPartNum,T1.TmpReference,T1.TrnDate,T1.SysDate,T1.TrnPosted,T1.TrnType,T1.Calc_BookDesc,T1.Calc_BookID,T1.Calc_CurrCode,T1.Calc_CurrDesc,T1.Calc_TranTypeText,T1.Calc_JobNumText, T1.PartDescription
FROM Recon_” + Parameters!TableGuid.Value + " T1"

[Matt_Belshaw]

Hi Ben,

I am not an expert on this side of Epicor but Calvin’s post on an early topic seems relevant as i cannot see that table in my install and that the Table name includes a GUID:

Using another report with different RDD as a subreport

The way RDD based reports work is that the RDD generates a temporary dataset consisting of tables with a suffix (the GUID) tacked on to their name. When the report tries to render, it reads that dataset. Subreports are passed the GUID from the main report. If you tried to use an existing RDD based report as a subreport, the tables needed for that sub wouldn’t exist. Unless you need the magic of the RDD, I’d suggest you make a subreport from scratch, linking it directly to the DB, bypassing t…

[MihaiDorin (Mihai Dorin Tanase)]

Hi Ben,

the Recon table actually does not exist - it is a temporary table used just to store the COS&WIP Reconciliation report data before being shown on the screen.

Best regards,
Mihai