Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PO Receivings in WORK and HISTORY

Status
Not open for further replies.
RobertC22

RobertC22

MIS
Jun 14, 2006
89
AU
Does anyone have a sql script to remove PO receivings records for the POP10300 and POP10310 for an incomplete posting?

The records have been created in the POP30300 and POP30310 tables and the Payable Invoices created, but copy of record remains in the POP10300/POP10310.

When the user attempts to do a Purchase order Inquiry by Receipt Number with Assigned PO marked, they get a primary key violation.

Thanks in advance
Robert
 
Status
Not open for further replies.

Similar threads

appelq
  • Locked
  • Question
Cash Batch and Bank Fees in Dynamics GP
Replies
0
Views
817
appelq
appelq
kgeorge71
  • Locked
  • Question
Bank Recs not tying to GL in Dynamics Great Plains
Replies
0
Views
954
kgeorge71
kgeorge71
appelq
  • Locked
  • Question
Receivables Batch Print the edit list is not working for an imported Cash receipts batch
Replies
0
Views
678
appelq
appelq
Nisly
  • Locked
  • Question
Deleting purchases from Fixed Assets Purchases in Great Plains
Replies
0
Views
695
Nisly
Nisly
Devanand0311
  • Locked
  • Question
Syntax error in date in query expression 'UCase
Replies
0
Views
639
Devanand0311
Devanand0311

Part and Inventory Search

Sponsor

Back
Top