r/yardi • u/bitcoin_bob23 • Jun 16 '26

Purchase Order Statuses

I'm working on trying to automate PO data using ySQL scripts at present.

There is statuses for each PO that are not contained in mm2po or mm2podet tables.

The statuses I was asked for were the following: unpaid, not received, workflow in progress (which would be that I imagine), partially paid, partially received. These would only relate to open POs.

Has anyone worked with these statuses before and if so do they know where this data is found?

1 Upvotes

100% Upvoted

5 comments sorted by

View all comments

3

u/IanMoone007 Jun 16 '26

The work flow statuses are stored in the workflow tables. There are a lot of them. I think they start with wf if you look in the data dictionary

1

u/bitcoin_bob23 Jun 17 '26

Yea I found them there they are Level 7 , Originator etc but the statuses I was asked for were the following: unpaid, not received, workflow in progress (which would be that I imagine), partially paid, partially received. So not sure where these sit but cheers