Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 1.05 » View Incident Report |
Serious |
Reported By: Abdulaziz Jasser Reported On: 9/25/2007 For: Version 1.05 Build 2 |
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
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |