We are getting an error for the below Item for our retail store.
The error is not allowing us to post to the Retail statement..
Item is correctly set up, and there is still stock at the retail store.
Any suggestions?
Error Posting\Sales order: SO000485324\Item: MLB300 Variation 1=L,Variation 2=HM AN
Cannot select a record in Locations (WMSLocation). Location: SALESFLOOR, RS001.
The SQL database has issued an error.
Info Posting SQL error description: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'TEMAXQTY'.
Info Posting SQL statement: SELECT TOP 1 T1.POSITION,T1.LEVEL_,T1.RACK,T1.INVENTLOCATIONID,T1.WMSLOCATIONID,T1.CHECKTEXT,T1.SORTCODE,T1.MANUALSORTCODE,T1.MANUALNAME,T1.MAXVOLUME,T1.AISLEID,T1.MAXWEIGHT,T1.LOCATIONTYPE,T1.HEIGHT,T1.WIDTH,T1.DEPTH,T1.VOLUME,T1.INPUTLOCATION,T1.ABSOLUTEHEIGHT,T1.LOCPROFILEID,T1.ZONEID,T1.MCRRESERVATIONPRIORITY,T1.LASTCOUNTEDUTCDATETIME,T1.LASTCOUNTEDUTCDATETIMETZID,T1.TEMAXQTY,T1.RECVERSION,T1.PARTITION,T1.RECID FROM WMSLOCATION T1 WHERE (((PARTITION=5637144576) AND (DATAAREAID=N'ted')) AND ((WMSLOCATIONID=?) AND (INVENTLOCATIONID=?)))
*This post is locked for comments
I have the same question (0)