When running the below query I got an error "Invalid Pointer Operation".  You can try it from the EDB Manager.  I will send you the tables.

SELECT
R.BranchSysNo,
0,        
R.InvoiceSysNo,        
R.StoreSysNo,        
R.ItemSysNo,        
R.UnitSysNo,        
R.ReturnPrice,        
R.ReturnQuantity,        
CAST(R.ExpirationDate AS CHAR(8)),        
R.ReturnReasonType,        
R.ReturnReason,        
R.PurchasePrice,        
R.ItemCost,        
I.ItemNo,        
I.ItemName_A,        
I.ItemName_E,        
I.HasExpirationDate,        
S.StoreName,        
U.UnitName,        
U.UnitFactor

FROM TB_Return R

INNER JOIN TB_Items I
ON   I.YearSysNo    = 0
AND  I.BranchSysNo  = R.BranchSysNo
AND  I.StoreSysNo   = R.StoreSysNo
AND  I.ItemSysNo    = R.ItemSysNo

INNER JOIN TB_Stores S
ON   S.BranchSysNo  = R.BranchSysNo
AND  S.StoreSysNo   = R.StoreSysNo

INNER JOIN TB_Units U
ON   U.BranchSysNo  = R.BranchSysNo
AND  U.UnitSysNo    = R.UnitSysNo

WHERE R.BranchSysNo  = 1
AND   R.InvoiceSysNo = 173

GROUP BY I.ItemNo,R.UnitSysNo,R.ReturnQuantity,R.ReturnPrice

Abdulaziz,

<< When running the below query I got an error "Invalid Pointer Operation".
You can try it from the EDB Manager.  I will send you the tables. >>

Do I already have the correct database catalog file for these tables ?  If
not, then I need the catalog file.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<Do I already have the correct database catalog file for these tables ?>>

Yes.

Abdulaziz,

<< Yes. >>

I need your latest database catalog file - the metadata version number for
the TB_Return table doesn't match the database catalog that I have.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<I need your latest database catalog file - the metadata version number for
the TB_Return table doesn't match the database catalog that I have.>>

I have sent you the tables and the catalog again.

Tim,

Any news?

Abdulaziz,

<< Any news? >>

Sorry for the delays - I found the issue and a fix will be in 1.06.
However, you can workaround the issue by moving this expression:

I.YearSysNo    = 0

into the WHERE clause instead.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<I found the issue and a fix will be in 1.06.>>

How far is 1.06 from now?

Abdulaziz,

<< How far is 1.06 from now? >>

It's getting there.  I should know a more exact date by the weekend.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

<<It's getting there.  I should know a more exact date by the weekend.>>

Any news?