/
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:

  1. In Tyler Menu, navigate to Munis > Financials > Purchasing > Purchase Order Inquiry and Reports > Purchase Order Inquiry

  2. Search for a PO number and click Notes folder.

  3. 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












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