Share
ReportHello,
I have several questions on PVrec import. (Dynamics SL 2011)
1. When the PVrec record length to import is too long, "PVREC.exe" runs into error with the message "PVREC.exe has stopped working. Windows is checking for a solution to the problem..." Because of this, I have to shorten the field header name. Is this a designed behavior and no work around? (Pasted at the bottom, actual record that gives the error.)
2. What is the stored procedure that has the same name as PVID for? The code in the SP does not seem to affect the result even if I modify it or even delete the SP ifself. What is the purpose of having SP besides the SQL statement included in PVrec to import?
Thanks for your help!
--PVRec------------------------------------------
"ADG_LotSerMst_ProjLot","","","SELECT * FROM LotSerMst INNER JOIN LocTable l on l.SiteID=LotSerMst.SiteID and l.WhseLoc=LotSerMst.WhseLoc Left Join fc_vw_package v ON LotSerMst.InvtId=v.InvtId AND LotSerMst.LotSerNbr = v.LotSerNbr Left Join v_plot p ON LotSerMst.InvtiD=p.InvtId AND LotSerMst.SiteId=p.SiteID AND LotSerMst.WhseLoc=p.WhseLoc AND LotSerMst.LotSerNbr=p.LotSerNbr AND p.Projectid=@ProjectID AND p.TaskID=@TaskId WHERE LotSerMst.InvtID LIKE @InvtID AND LotSerMst.SiteID LIKE @SiteID AND l.SalesValid <> 'N' AND LotSerMst.LotSerNbr LIKE @LotSerNbr AND LotSerMst.LotSerNbr <> '*' AND LotSerMst.Status='A' AND (LotSerMst.QtyAvail + IsNull(p.qty,0)) > 0 ORDER BY LotSerMst.LotSerNbr","Lot/Serial Number","LotSerMst.LotSerNbr;LotSerNbr;0;0","fc_vw_package.User2;Package;0;0","LotSerMst.WhseLoc;Whse BinLoc;0;0","LotSerMst.QtyAvail;Qty Avail;0;0","v_plot.qty;Proj QtyAllocated;0;0","LotSerMst.QtyOnHand;Qty OnHand;0;0","LotSerMst.QtyAllocSO;SO L/S Alloc;0;0","LotSerMst.QtyAlloc;On OpenShippers;0;0","LotSerMst.QtyShipNotInv;Qty Shipped NotInvoiced;0;0","LotSerMst.ExpDate;ExpDate;0;0"
-------------------------------------------------------
*This post is locked for comments
All responses (
Answers (
291,269
