I am copying RMS database values to other database.... While copying i have an issuse in purchase order table......
how to differentiate the cancelled and closed purchase order from purchase order table
*This post is locked for comments
I am copying RMS database values to other database.... While copying i have an issuse in purchase order table......
how to differentiate the cancelled and closed purchase order from purchase order table
*This post is locked for comments
How do you handle cancelled purchase orders in the first place?
You can differentiate the open, partial and committed POs with these values:
if postatus = 0, PO is open
1 = Partial, means updated with entries but not yet committed
2 - committed
André Arnaud de Cal...
294,467
Super User 2025 Season 1
Martin Dráb
233,066
Most Valuable Professional
nmaenpaa
101,158
Moderator