Issue :
When i am trying to integrate Receiving Transaction Entry through econnect I got the below issue.
"There is an active
Purchase Order Approval workflow"
This is dynamics GP 2015 econnect procedure issue.I have decrypt the taPopRcptlineInsert procedure.This procedure checks work flow status as 9.But Purchase Order completed Status is 6 not 9.
Solution 1:
decrypt the taPopRcptlineInsert procedure and modify.
Solution 2:
Step 1 : Update the Workflow status as 9
UPDATE POP10100 SET Workflow_Status = 9 WHERE PONUMBER = @PONUMBER
Step 2 : Execute the econnect method for integrating purchase receipt
Step 3 : After integrating again update the status as 6
UPDATE POP10100 SET Workflow_Status = 6 WHERE PONUMBER = @PONUMBER
When i am trying to integrate Receiving Transaction Entry through econnect I got the below issue.
"There is an active
Purchase Order Approval workflow"This is dynamics GP 2015 econnect procedure issue.I have decrypt the taPopRcptlineInsert procedure.This procedure checks work flow status as 9.But Purchase Order completed Status is 6 not 9.
Solution 1:
decrypt the taPopRcptlineInsert procedure and modify.
Solution 2:
Step 1 : Update the Workflow status as 9
UPDATE POP10100 SET
Workflow_Status = 9 WHERE PONUMBER = @PONUMBERStep 2 : Execute the econnect method for integrating purchase receipt
Step 3 : After integrating again update the status as 6
UPDATE POP10100 SET Workflow_Status = 6 WHERE PONUMBER = @PONUMBER
I used the taPopRcptLineInsertPre SP to save the workflow status, then set it to 9. I then used the taPopRcptLineInsertPost SP to set it back to the previous state.
ReplyDelete