Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Help how to PO receipt...
Microsoft Dynamics GP (Archived)

Help how to PO receipt reversed to free stuck serial numbers

(0) ShareShare
ReportReport
Posted on by xverci101 58

Hi all, 

Sorry if this seems stupid but i newbie. i'm running GP2013 SP2  and sql Server 2012 SP2

After a disconnection failure, a PO never posted completely, causing the item serial numbers stuck and not available for new use, how can I fix this and make available once again the serial numbers?

I've tried running a reconciliation for the item number GPALA574BGLLR4 , with no success.

1.- I WAS ABLE TO TRACK DOW A RECEIPT NUMBER (RCT40005806) using this query:

select * from pop30330 where serltnum in (
'014913009839190',
'015295001987840',
'015295003346094')

The result

Results:  POPRCTNM RCPTLNNM SLTSQNUM SERLTNUM SERLTQTY DATERECD DTSEQNUM UNITCOST TRXSORCE ITEMNMBR QTYTYPE BIN MFGDATE EXPNDATE DEX_ROW_ID
RCT40005806 16384 113 014913009839190 1.00000 2019-06-13 00:00:00.000 0.00000 39.99000 RECVG00002710 GPALA574BGLLR4 1 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 2169905
RCT40005806 16384 220 015295001987840 1.00000 2019-06-13 00:00:00.000 0.00000 39.99000 RECVG00002710 GPALA574BGLLR4 1 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 2170012
RCT40005806 16384 342 015295003346094 1.00000 2019-06-13 00:00:00.000 0.00000 39.99000 RECVG00002710 GPALA574BGLLR4 1 1900-01-01 00:00:00.000 1900-01-01 00:00:00.000 2170134

2.-Using the following queries  was able to find the order number  ORDER11191911    

SELECT * FROM POP10100 WHERE PONUMBER
=(SELECT DISTINCT PONUMBER FROM POP10500 WHERE POPRCTNM = 'RCT40005806' )
SELECT * FROM POP10110 WHERE PONUMBER
=(SELECT DISTINCT PONUMBER FROM POP10500 WHERE POPRCTNM = 'RCT40005806' )
SELECT * FROM POP10300 WHERE POPRCTNM = 'RCT40005806'
SELECT * FROM POP10310 WHERE POPRCTNM = 'RCT40005806'
SELECT * FROM POP10500 WHERE POPRCTNM = 'RCT40005806'

The results

POP10100

PONUMBER POSTATUS STATGRP POTYPE USER2ENT CONFIRM1 DOCDATE LSTEDTDT LSTPRTDT PRMDATE PRMSHPDTE REQDATE REQTNDT SHIPMTHD TXRGNNUM REMSUBTO SUBTOTAL TRDISAMT FRTAMNT MSCCHAMT TAXAMNT VENDORID VENDNAME MINORDER VADCDPAD CMPANYID PRBTADCD PRSTADCD CMPNYNAM CONTACT ADDRESS1 ADDRESS2 ADDRESS3 CITY STATE ZIPCODE CCode COUNTRY PHONE1 PHONE2 PHONE3 FAX PYMTRMID DSCDLRAM DSCPCTAM DISAMTAV DISCDATE DUEDATE TRDPCTPR CUSTNMBR TIMESPRT CREATDDT MODIFDT PONOTIDS_1 PONOTIDS_2 PONOTIDS_3 PONOTIDS_4 PONOTIDS_5 PONOTIDS_6 PONOTIDS_7 PONOTIDS_8 PONOTIDS_9 PONOTIDS_10 PONOTIDS_11 PONOTIDS_12 PONOTIDS_13 PONOTIDS_14 PONOTIDS_15 COMMNTID CANCSUB CURNCYID CURRNIDX RATETPID EXGTBLID XCHGRATE EXCHDATE TIME1 RATECALC DENXRATE MCTRXSTT OREMSUBT ORSUBTOT Originating_Canceled_Sub ORTDISAM ORFRTAMT OMISCAMT ORTAXAMT ORDDLRAT ODISAMTAV BUYERID ONORDAMT ORORDAMT HOLD ONHOLDDATE ONHOLDBY HOLDREMOVEDATE HOLDREMOVEBY ALLOWSOCMTS DISGRPER DUEGRPER Revision_Number Change_Order_Flag PO_Field_Changes PO_Status_Orig TAXSCHID TXSCHSRC TXENGCLD BSIVCTTL Purchase_Freight_Taxable Purchase_Misc_Taxable FRTSCHID MSCSCHID FRTTXAMT ORFRTTAX MSCTXAMT ORMSCTAX BCKTXAMT OBTAXAMT BackoutFreightTaxAmt OrigBackoutFreightTaxAmt BackoutMiscTaxAmt OrigBackoutMiscTaxAmt Flags BackoutTradeDiscTax OrigBackoutTradeDiscTax POPCONTNUM CONTENDDTE CNTRLBLKTBY PURCHCMPNYNAM PURCHCONTACT PURCHADDRESS1 PURCHADDRESS2 PURCHADDRESS3 PURCHCITY PURCHSTATE PURCHZIPCODE PURCHCCode PURCHCOUNTRY PURCHPHONE1 PURCHPHONE2 PURCHPHONE3 PURCHFAX BLNKTLINEEXTQTYSUM CBVAT Workflow_Approval_Status Workflow_Priority Print_Phone_NumberGB PrepaymentAmount OriginatingPrepaymentAmt DEX_ROW_TS DEX_ROW_ID
ORDER11191911 5 2 1 DHuert 2019-06-12 0:00:00 2019-06-12 0:00:00 1900-01-01 0:00:00 2019-06-12 0:00:00 2019-06-12 0:00:00 2019-06-12 0:00:00 1900-01-01 0:00:00 0 19995 0 0 0 0 TRACF001 TRACFONE WIRELESS, INC. 0 PRIMARY 1 PRIMARY PRIMARY
Rush Star Wireless Inc.
 1124 Bay Blvd. Suite B Chula Vista CA 91911 US United States 87748878740000 Net 30 0 0 0 1900-01-01 0:00:00 2019-07-12 0:00:00 0 0 2019-06-12 0:00:00 2019-06-24 0:00:00 1363515 0 2393 0 44 0 277 0 0 0 1363516 0 0 0 0 0 USD 1008 0 1900-01-01 0:00:00 1900-01-01 0:00:00 0 0 0 0 19995 0 0 0 0 0 0 0 0 0 0 1900-01-01 0:00:00 1900-01-01 0:00:00 0 0 0 0 0 0x12000000 4 3 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1900-01-01 0:00:00 0
TRACFONE WIRELESS, INC.
9700 NW 112TH AVE,
 MIAMI FL 33178 US United States 94974864640225 0 0 9 2 0 0 0 2019-06-24 21:00:26 5535

POP10110

PONUMBER ORD POLNESTA POTYPE ITEMNMBR ITEMDESC VENDORID VNDITNUM VNDITDSC NONINVEN LOCNCODE UOFM UMQTYINB QTYORDER QTYCANCE QTYCMTBASE QTYUNCMTBASE UNITCOST EXTDCOST INVINDX REQDATE PRMDATE PRMSHPDTE REQSTDBY COMMNTID DOCTYPE POLNEARY_1 POLNEARY_2 POLNEARY_3 POLNEARY_4 POLNEARY_5 POLNEARY_6 POLNEARY_7 POLNEARY_8 POLNEARY_9 DECPLCUR DECPLQTY ITMTRKOP VCTNMTHD BRKFLD1 PO_Line_Status_Orig QTY_Canceled_Orig OPOSTSUB JOBNUMBR COSTCODE COSTTYPE CURNCYID CURRNIDX XCHGRATE RATECALC DENXRATE ORUNTCST OREXTCST LINEORIGIN FREEONBOARD ODECPLCU Capital_Item Product_Indicator Source_Document_Number Source_Document_Line_Num RELEASEBYDATE Released_Date Change_Order_Flag Purchase_IV_Item_Taxable Purchase_Item_Tax_Schedu Purchase_Site_Tax_Schedu PURCHSITETXSCHSRC BSIVCTTL TAXAMNT ORTAXAMT BCKTXAMT OBTAXAMT Landed_Cost_Group_ID PLNNDSPPLID SHIPMTHD BackoutTradeDiscTax OrigBackoutTradeDiscTax LineNumber ORIGPRMDATE FSTRCPTDT LSTRCPTDT RELEASE ADRSCODE CMPNYNAM CONTACT ADDRESS1 ADDRESS2 ADDRESS3 CITY STATE ZIPCODE CCode COUNTRY PHONE1 PHONE2 PHONE3 FAX ADDRSOURCE Flags ProjNum CostCatID Print_Phone_NumberGB DEX_ROW_TS DEX_ROW_ID
ORDER11191911 16384 5 1 GPALA574BGLLR4 GPALA574BGLLR4" ATT TRACF001 GPALA574BGLLR4 GPALA574BGLLR4" ATT 0 RSW-CA Each 1 500 0 0 0 39.99 19995 619 2019-06-12 0:00:00 2019-06-12 0:00:00 2019-06-12 0:00:00 1 1363511 138278 0 1169433 1363517 0 0 0 0 9 1 2 1 0 0 0 19995 0 USD 1008 0 0 0 39.99 19995 1 1 2 0 0 0 1900-01-01 0:00:00 1900-01-01 0:00:00 1 2 3 0 0 0 0 0 0 0 0 1 2019-06-12 0:00:00 2019-06-13 0:00:00 2019-06-13 0:00:00 1 0 0 0 2019-06-24 21:00:25 18101

POP10500

PONUMBER POLNENUM POPRCTNM RCPTLNNM QTYSHPPD QTYINVCD QTYREJ QTYMATCH QTYRESERVED QTYINVRESERVE Status UMQTYINB OLDCUCST JOBNUMBR COSTCODE COSTTYPE ORCPTCOST OSTDCOST APPYTYPE POPTYPE VENDORID ITEMNMBR UOFM TRXLOCTN DATERECD RCTSEQNM SPRCTSEQ PCHRPTCT SPRCPTCT OREXTCST RUPPVAMT ACPURIDX INVINDX UPPVIDX NOTEINDX CURNCYID CURRNIDX XCHGRATE RATECALC DENXRATE RATETPID EXGTBLID Capital_Item Product_Indicator Total_Landed_Cost_Amount QTYTYPE Posted_LC_PPV_Amount QTYREPLACED QTYINVADJ DEX_ROW_ID
ORDER11191911 16384 RCT40005806 16384 500 0 0 500 0 0 1 1 39.99 0 39.99 39.99 1 1 TRACF001 GPALA574BGLLR4 Each RSW-CA 2019-06-13 0:00:00 1 0 39.99 0 0 0 323 619 0 0 USD 1008 0 0 0 0 0 0 1 0 0 0 58099

The other two queries did not returned anything.

Thanks in advanced for your urgent help!

*This post is locked for comments

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans