error message:
"Cannot select a record in Inventory transactions originator (InventTransOrigin). Reference: Sales order.
The SQL database has issued an error."
“SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name ‘MODIFIEDDATETIME’.”
“SQL statement: SELECT T1.INVENTTRANSID,T1.REFERENCECATEGORY,T1.REFERENCEID,T1.ITEMID,T1.ITEMINVENTDIMID,T1.PARTY,T1.RECVERSION,T1.RECID,T2.ITEMID,T2.STATUSISSUE,T2.INTERCOMPANYINVENTDIMTRANSFERRED,T2.DATEPHYSICAL,T2.QTY,T2.COSTAMOUNTPOSTED,T2.CURRENCYCODE,T2.INVOICEID,T2.VOUCHER,T2.DATEEXPECTED,T2.DATEFINANCIAL,T2.COSTAMOUNTPHYSICAL,T2.STATUSRECEIPT,T2.PACKINGSLIPRETURNED,T2.INVOICERETURNED,T2.PACKINGSLIPID,T2.VOUCHERPHYSICAL,T2.COSTAMOUNTADJUSTMENT,T2.SHIPPINGDATEREQUESTED,T2.SHIPPINGDATECONFIRMED,T2.QTYSETTLED,T2.COSTAMOUNTSETTLED,T2.VALUEOPEN,T2.ACTIVITYNUMBER,T2.DATESTATUS,T2.COSTAMOUNTSTD,T2.DATECLOSED,T2.PICKINGROUTEID,T2.COSTAMOUNTOPERATIONS,T2.RETURNINVENTTRANSORIGIN,T2.PROJID,T2.PROJCATEGORYID,T2.INVENTDIMID,T2.MARKINGREFINVENTTRANSORIGIN,T2.INVENTDIMFIXED,T2.DATEINVENT,T2.TRANSCHILDREFID,T2.TRANSCHILDTYPE,T2.TIMEEXPECTED,T2.REVENUEAMOUNTPHYSICAL,T2.PROJADJUSTREFID,T2.TAXAMOUNTPHYSICAL,T2.INVENTTRANSORIGIN,T2.MODIFIEDDATETIME,T2.RECVERSION,T2.RECID,T3.NAME,T3.RECID,T3.RECVERSION,T3.INSTANCERELATIONTYPE,T4.INVENTTRANSID,T4.RECID,T4.RECVERSION,T5.INVENTTRANSID,T5.RECID,T5.RECVERSION,T6.INVENTTRANSID,T6.RECID,T6.RECVERSION,T7.INVENTDIMID,T7.INVENTBATCHID,T7.WMSLOCATIONID,T7.WMSPALLETID,T7.INVENTSERIALID,T7.INVENTLOCATIONID,T7.CONFIGID,T7.INVENTSIZEID,T7.INVENTCOLORID,T7.INVENTSITEID,T7.RECVERSION,T7.RECID FROM INVENTTRANSORIGIN T1 CROSS JOIN INVENTTRANS T2 LEFT OUTER JOIN DIRPARTYTABLE T3 ON (T1.PARTY=T3.RECID) LEFT OUTER JOIN INVENTTRANSORIGIN T4 ON ((T4.DATAAREAID=?) AND ((T2.INVENTTRANSORIGIN=T4.RECID) AND (T2.INVENTTRANSORIGIN=T4.RECID))) LEFT OUTER JOIN INVENTTRANSORIGIN T5 ON ((T5.DATAAREAID=?) AND ((T2.MARKINGREFINVENTTRANSORIGIN=T5.RECID) AND (T2.MARKINGREFINVENTTRANSORIGIN=T5.RECID))) LEFT OUTER JOIN INVENTTRANSORIGIN T6 ON ((T6.DATAAREAID=?) AND ((T2.RETURNINVENTTRANSORIGIN=T6.RECID) AND (T2.RETURNINVENTTRANSORIGIN=T6.RECID))) CROSS JOIN INVENTDIM T7 WHERE ((T1.DATAAREAID=?) AND (T1.ITEMID=?)) AND ((T2.DATAAREAID=?) AND (T1.RECID=T2.INVENTTRANSORIGIN)) AND ((T7.DATAAREAID=?) AND (T2.INVENTDIMID=T7.INVENTDIMID)) ORDER BY T1.ITEMID DESC,T2.DATEPHYSICAL DESC”
I am getting above errors when i tries to add date feature in AOT for reporting purpose using ssrs and changed the modified date and time property in inventtrans table and now when i try to access the table it gives me following error. any help