Dynamics Community Forum Thread Details

I created a PO to receive in several items. RCT0782 was generated when the items arrived. I went to bill one of the items and systems says it is not there. I have attached pics of the Rct created and of the SQL query I believe shows it coming in. I ran a Smart List Purchase Receipt Report and it is not listed. Item is ST3581420SW. Where did it go?

POP Receipt Number POP Type Item Number Item Description QTY Shipped QTY Invoiced Unit Cost Extended Cost Vendor ID Vendor Name Actual Ship Date BOL_PRO Number Based On Invoice Total Batch Number Batch Source Capital Item Comment ID Cost Category ID Cost Code Cost Code Type Created Date Currency ID Currency Index Decimal Places Currency Decimal Places QTYS Denomination Exchange Rate Exchange Rate GL Posting Date Inventory Index Invoice Return Number Item Tracking Option Job Number Landed Cost Landed Cost Group ID Location Code Modified Date Non IV Originating Decimal Places Currency Originating Extended Cost Originating Tax Amount Originating Unit Cost PO Number Posted Date Posted User ID Posting Status Product Indicator Project Number Purchase IV Item Taxable Purchase Item Tax Schedule ID Purchase Price Variance Index Purchase Site Tax Schedule ID QTY Invoice Reserve QTY Matched QTY Rejected QTY Reserved Rate Calc Method Receipt Date Receipt Line Number Receipt Return Number TRX Source Tax Amount Tax Date Total Landed Cost U Of M U Of M QTY In Base User To Enter Vendor Document Number Vendor Item Description PO Line Number Item Number For Drillback PO Number For Drillback Vendor ID For Drillback

------------------ ---------------------------------------------------------------------------------------------------- ------------------------------- ----------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------- ----------------------------------------------------------------- ----------------------- ------------------------------- ---------------------------------------------------------------------------------------------------- --------------- --------------- ---------------------------------------------------------------------------------------------------- --------------- ---------------- --------------------------- -------------- ----------------------- --------------- -------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- ----------------------- --------------- --------------------- ---------------------------------------------------------------------------------------------------- ----------------- ---------------------------------------------------------------------------------------------------- -------------------- ------------- ----------------------- ------ ---------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ----------------- ----------------------- --------------- ---------------------------------------------------------------------------------------------------- ----------------- --------------- ------------------------ ----------------------------- ----------------------------- ----------------------------- --------------------------------------- --------------------------------------- --------------------------------------- --------------------------------------- ---------------------------------------------------------------------------------------------------- ----------------------- ------------------- --------------------- ------------- --------------------------------------- ----------------------- --------------------------------------- --------- --------------------------------------- --------------- ---------------------- ----------------------------------------------------------------------------------------------------- -------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

RCT07892 Shipment ST3581420SW Stud 3 5/8" 14' 20 GA 30.00000 0.00000 7.94000 238.20000 STUDCO1 STUDCO 1900-01-01 00:00:00.000 No sa *Rcvg Trx Entry No 0 2014-11-11 00:00:00.000 0 0 NULL 0.0000000 2014-11-11 00:00:00.000 50 None No MAIN 2014-11-11 00:00:00.000 1 1 238.20000 0.00000 7.94000 PO04197 2014-11-11 00:00:00.000 sa Posted 0 2 100 0.00000 0.00000 0.00000 0.00000 2014-11-11 00:00:00.000 49152 RECVG00002571 0.00000 1900-01-01 00:00:00.000 0.00000 EACH 1.00000 sa PL-36454 49152 dgpp://DGPB/?Db=&Srv=MARY-GBM&Cmp=SBM01&Prod=0&Act=OPEN&Func=OpenItemNmbr&ITEMNMBR=ST3581420SW&LOCNCODE=MAIN&CallID=0&FocusWindow=true dgpp://DGPB/?Db=&Srv=MARY-GBM&Cmp=SBM01&Prod=0&Act=OPEN&Func=OpenPO&POSTATUS=0&VENDORID=STUDCO1&PONUMBER=PO04197&DOCTYPE=1&ActID=-1&MenuID=2&CurncyView=1 dgpp://DGPB/?Db=&Srv=MARY-GBM&Cmp=SBM01&Prod=0&Act=OPEN&Func=OpenVendorID&VENDORID=STUDCO1

(1 row(s) affected)