warren 4/1/2021 1:13:20 PM

Manually trigger a purchase order status change to release

I have created a custom SSRS purchase order report for GP users to print. When using this report, POs are not being "released" as they natively do when you print a standard GP report.

Is there a way to programmatically change the status of a PO?

I think there are two options:

1. econnect node: tapohdr, tapoline

2. SQL script to update POP10100, POP10110, PM00201, IV00101, IV00102, IV00103

Any help appreciated.

Version: All
Section: Dynamics GP, eConnect, SQL Scripts, SSRS


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3