The EPL refunds are failing due to an error
Error Message: Error executing the SQL statement selectPostZeroJournals
External batch XXXXXXX contains data validation errors and cannot be posted
Data validation errors occurred while processing external item REC-XXXXXX-XXXX
Refund element is missing Vendor Address 1
Refund element is missing Vendor City
Refund element is missing Vendor State
Refund element is missing Vendor Zip Code
- Enterprise Permit & Licensing (EPL)
- Refunds
- Enterprise ERP
- System Log
Munis cannot validate the refund record import as required data is missing from the CreateARRefunds XML file
Verify the One time vendor code in Munis:
- Navigate to: EERP>General Revenues>Accounts Receivable>Setup>Accounts Receivable Settings
- Click the Refunds tab
- Note One time vendor code
Verify that the One time vendor code was entered correctly in EPL:
- In EPL, navigate to System Settings > Integration Settings > Tyler Financial > Default Tyler Financial Integration
- Click Batch Manager
- Enter the batch number in the Batch Number field
- Click Search
- Enter the Batch Number or Batch Id (it may be necessary to search under Failed and Successful batches)
- Click the Batch Preview pop-out icon
- the batch XML will be viewable in new window
- Note the value in the <OneTimeVendorNumber></OneTimeVendorNumber> field to see if it matches the value in Munis
Contact Enterprise Permitting & Licensing Support to review refund processing steps, specifically what setting or user input determines the vendor number used in the export
Contact Enterprise ERP General Billing & Misc Cash Support to test manually importing an updated XML file
Add Comment