Posted receipts not showing on Enter Match Invoice window

Issue: Posted receipts not showing on Enter Match Invoice window, even record exist can be verify at backend.

Cause:  Posting interrupted or everything is possible in the world of dynamics GP.

Fix: Update two fields in two different PO tables.

1. POP_POLine

Display Name        Purchase Order Line

O/S Name               POP10110

Update PO Line status field. For posted lines it should be set as 4. Use as many ”wheres” as you can so update the right record.

4 = POP_POLINESTATUS_RECEIVED

/*update POP10110 set POLNESTA=4

Where  PONUMBER='POXXXXXXXX' and ITEMNMBR='XXXXXXXXXX’

and ORD='XXXXXXX' and VENDORID='XXXXXX'*/

1. POP_PORcptApply

Display Name        Purchasing Receipt Line Quantities

O/S Name               POP10500

The POP_PORcptApply table contains the information necessary to apply a POP_ReceiptLine to its POP_POLine.

Update Status field. It should be 1.

1= Posted

/*update POP10500 set Status=1 where PONUMBER='POXXXXXXXXXX’

And  POPRCTNM='RCTXXXXX’ and POLNENUM='XXXXXX'

and  ITEMNMBR='XXXXXXXX’*/