Участник
Регистрация: 30.05.2004
Адрес: Atlanta, GA, USA
|
Вот мои результаты с запросами.
Цитата:
Info SQL statement SQL statement: (InventTrans) SELECT A.ITEMID,A.STATUSISSUE,A.INTERCOMPANYINVENTDIMTRANSFER3,A.DATEPHYSICAL,A.QTY,A.COSTAMOUNTPOSTED,A.CURRENCYCODE,A.TRANSTYPE,A.TRANSREFID,A.INVOICEID,A.VOUCHER,A.INVENTTRANSIDTRANSFER,A.DATEEXPECTED,A.DATEFINANCIAL,A.COSTAMOUNTPHYSICAL,A.INVENTTRANSID,A.STATUSRECEIPT,A.PACKINGSLIPRETURNED,A.INVOICERETURNED,A.PACKINGSLIPID,A.VOUCHERPHYSICAL,A.COSTAMOUNTADJUSTMENT,A.SHIPPINGDATEREQUESTED,A.SHIPPINGDATECONFIRMED,A.QTYSETTLED,A.COSTAMOUNTSETTLED,A.VALUEOPEN,A.DIRECTION,A.ACTIVITYNUMBER,A.DATESTATUS,A.COSTAMOUNTSTD,A.DATECLOSED,A.PICKINGROUTEID,A.INVENTTRANSIDFATHER,A.COSTAMOUNTOPERATIONS,A.ITEMROUTEID,A.ITEMBOMID,A.INVENTTRANSIDRETURN,A.PROJID,A.PROJCATEGORYID,A.INVENTDIMID,A.INVENTDIMFIXED,A.DATEINVENT,A.CUSTVENDAC,A.TRANSCHILDREFID,A.TRANSCHILDTYPE,A.TIMEEXPECTED,A.REVENUEAMOUNTPHYSICAL,A.ASSETID,A.PROJADJUSTREFID,A.TAXAMOUNTPHYSICAL,A.ASSETBOOKID,A.INVENTREFTRANSID,A.PROBABILITYID,A.RECVERSION,A.RECID FROM INVENTTRANS A WHERE ((DATAAREAID=?) AND (INVENTTRANSID=?)) [ID=445, Reused=No]
Info SQL statement SQL statement: (InventTrans) SELECT SUM(A.QTY) FROM INVENTTRANS A WHERE ((DATAAREAID=?) AND ((INVENTTRANSID=?) AND (((STATUSISSUE=?) OR (STATUSISSUE=?)) OR (STATUSISSUE=?)))) [ID=446, Reused=No]
Info SQL statement Кеширование не отключали. DisableCache = false Количество -5.00
Info SQL statement SQL statement: (InventTrans) SELECT SUM(A.QTY) FROM INVENTTRANS A WHERE ((DATAAREAID=?) AND ((INVENTTRANSID=?) AND (((STATUSISSUE=?) OR (STATUSISSUE=?)) OR (STATUSISSUE=?)))) [ID=447, Reused=No]
Info SQL statement Отключили кеширование. DisableCache = true Количество -5.00
Info SQL statement SQL statement: (InventTrans) SELECT A.ITEMID,A.STATUSISSUE,A.INTERCOMPANYINVENTDIMTRANSFER3,A.DATEPHYSICAL,A.QTY,A.COSTAMOUNTPOSTED,A.CURRENCYCODE,A.TRANSTYPE,A.TRANSREFID,A.INVOICEID,A.VOUCHER,A.INVENTTRANSIDTRANSFER,A.DATEEXPECTED,A.DATEFINANCIAL,A.COSTAMOUNTPHYSICAL,A.INVENTTRANSID,A.STATUSRECEIPT,A.PACKINGSLIPRETURNED,A.INVOICERETURNED,A.PACKINGSLIPID,A.VOUCHERPHYSICAL,A.COSTAMOUNTADJUSTMENT,A.SHIPPINGDATEREQUESTED,A.SHIPPINGDATECONFIRMED,A.QTYSETTLED,A.COSTAMOUNTSETTLED,A.VALUEOPEN,A.DIRECTION,A.ACTIVITYNUMBER,A.DATESTATUS,A.COSTAMOUNTSTD,A.DATECLOSED,A.PICKINGROUTEID,A.INVENTTRANSIDFATHER,A.COSTAMOUNTOPERATIONS,A.ITEMROUTEID,A.ITEMBOMID,A.INVENTTRANSIDRETURN,A.PROJID,A.PROJCATEGORYID,A.INVENTDIMID,A.INVENTDIMFIXED,A.DATEINVENT,A.CUSTVENDAC,A.TRANSCHILDREFID,A.TRANSCHILDTYPE,A.TIMEEXPECTED,A.REVENUEAMOUNTPHYSICAL,A.ASSETID,A.PROJADJUSTREFID,A.TAXAMOUNTPHYSICAL,A.ASSETBOOKID,A.INVENTREFTRANSID,A.PROBABILITYID,A.RECVERSION,A.RECID FROM INVENTTRANS A WHERE ((DATAAREAID=?) AND (INVENTTRANSID=?)) [ID=445, Reused=Yes]
Info SQL statement Кеширование не отключали. Создан RecordViewCache по второму лоту DisableCache = false Количество -5.00
Info SQL statement SQL statement: (InventTrans) SELECT SUM(A.QTY) FROM INVENTTRANS A WHERE ((DATAAREAID=?) AND ((INVENTTRANSID=?) AND (((STATUSISSUE=?) OR (STATUSISSUE=?)) OR (STATUSISSUE=?)))) [ID=447, Reused=Yes]
Info SQL statement Отключили кеширование. Создан RecordViewCache по второму лоту DisableCache = true Количество -5.00
Билд у меня:
5.0.436.0
На 4ке проверять не буду - если там это не пофиксино, то единственный способ добиться, чтобы пофиксили - через службу поддержки их долбить.
|