Miscellaneous Receipt Attachments Missing After Munis Upgrade to 2019

Owned by Knowledge Assistant
Last updated: Apr 28, 2022
1 min read



Description of Issue

We recently upgraded to 2019+ and can no longer find generic miscellaneous receipt attachments in Munis.



Context

  • Munis 2019.1+

  • Generic Attachments

  • Accounts Receivable

  • Miscellaneous Receipts

  • TCM

  • Tyler Content Manager

  • Munis Upgrade



Cause

Munis code was changed between 11.3 and 2019 to populate the bill number field with the receipt number for miscellaneous receipts (ARReceipt document types in TCM) and left the bill number zeroed out in the Munis sppattach table (generic attachments).



Resolution

If OnPremise: Reach out to TSM OnPrem Support for assistance. 


If Hosted (SaaS):   Reach out to TSM Saas Support for assistance



Additional Information

This will rebuild the spattach key on Year, BillNumber, PostRewriteCategory, and ReceiptNumber by joining to Receipts table on Year and ReceiptNumber for all spattach records that have a cat containing 00000000 as the BillNumber and 002 as the Category.