/
Database view containing miscellaneous description in Receipt Inquiry

Database view containing miscellaneous description in Receipt Inquiry

Description of Issue

User need to retrieve miscellaneous description in Receipt Inquiry from database for building a custom report

Context
  • Enterprise ERP Version 2019.1 and above

  • SSRS Reports

  • SaaS clients

  • OnPrem clients

  • Miscellaneous description

  • Receipt Inquiry

Cause

View database column option show field as derived

Resolution

To view this field in Enterprise ERP, follow the steps below:

  1. Navigate to EERP Menu > Financials > Cash Management > Cash Receipts and Daily Processing > Receipt Inquiry

  2. Miscellaneous description is located under Journal Information section

This field is available through table AccountsReceivable.ReceiptLineJournalAccountOverrides under the column Comment.

Additional Information

Note that this field is not available through a TRS view, so any user who will need to run a report utilizing this table will need to have db_datareader permission in the database.

Please reach out to EERP Reporting Services Support team, as this permission need to be granted on the database server.

 

Related content

Receipt Inquiry browse missing columns for department and the fiscal year period journal fields
Receipt Inquiry browse missing columns for department and the fiscal year period journal fields
More like this
Detail option not linking back to Receipt Inquiry from Account Inquiry for CRP journals after upgrade from 11.3 or below to 2017.1 or above
Detail option not linking back to Receipt Inquiry from Account Inquiry for CRP journals after upgrade from 11.3 or below to 2017.1 or above
More like this
SQL ar_receipt_all view returning all activity except for Miscellaneous Receipts
SQL ar_receipt_all view returning all activity except for Miscellaneous Receipts
More like this
Database view and column containing purchase order notes
Database view and column containing purchase order notes
More like this
Database view for batch number in Receipts
Database view for batch number in Receipts
More like this
Additional Description is not printing on the General Journal Entry Proof report
Additional Description is not printing on the General Journal Entry Proof report
More like this