Dynamics GP: You cannot print unauthorized Purchase Order and the Purchase order is not available in the commitment

Views (0)

Community Member

Like(0)

Report

One of my customers reported an issue with their purchase orders after upgrading to Dynamics GP 2013 R2, below the message they got:

The customer is using PO Commitment to validates budgets and somehow the purchase order was not available in “CPO10110” table, the script below will fix this for you by taking the record information from POP10110:

INSERT INTO [CPO10110]
           ([PONUMBER]
           ,[ORD]
           ,[ACTINDX]
           ,[REQDATE]
           ,[VENDORID]
           ,[APPROVL]
           ,[Committed_Amount]
           ,[POLNESTA]
           ,[QTYCANCE]
           ,[UNITCOST]
           ,[PostedSubtotal])
SELECT [PONUMBER]
           ,[ORD]
           ,[INVINDX]
           ,[REQDATE]
           ,[VENDORID]
           ,1 AS [APPROVL]
           ,0 AS [Committed_Amount]
           ,[POLNESTA]
           ,[QTYCANCE]
           ,[UNITCOST]
           ,[EXTDCOST] AS [PostedSubtotal]
FROM POP10110 WHERE PONUMBER = @PONUMBER