/
Database view and column containing purchase order notes
Database view and column containing purchase order notes
Description of Issue
User needs TRS view and column for purchase order notes to build a custom report
Context
Munis all versions
SSRS reports
Crystal reports
SaaS, Tyler-hosted clients
OnPrem, Self-hosted clients
Purchase order inquiry
Cause
The View Database Columns overlay option does not exist to view table and column name
Resolution
To view notes field in Munis, follow the steps below:
In Tyler Menu, navigate to Munis > Financials > Purchasing > Purchase Order Inquiry and Reports > Purchase Order Inquiry
Search for a PO number and click Notes folder.
Select a line and click Accept in the top menu ribbon.
This text is available under column nd_note_text in TRS view ap_po_notes.
Additional Information
, multiple selections available,
Related content
Database view containing comments for a work order
Database view containing comments for a work order
More like this
Database view containing inventory item description
Database view containing inventory item description
More like this
Database view containing P-Card Invoice vendor name
Database view containing P-Card Invoice vendor name
More like this
Database view containing case notes from Case Management program
Database view containing case notes from Case Management program
More like this
How to see purchase orders in the Purchase Order Receiving program in Munis
How to see purchase orders in the Purchase Order Receiving program in Munis
More like this
Database view containing addition description of a work order
Database view containing addition description of a work order
More like this