another blog

Icon

About Microsoft Dynamics GP :-)

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’*/

http://www.facebook.com/notes/almas-mahfooz/posted-receipts-not-showing-on-enter-match-invoice-window/405639859506815

Advertisements

Filed under: Data Issue of Dynamics GP, , , ,

2 Responses

  1. Crystal Roach says:

    Thank you – Your information was very helpful.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: