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
The OneTimeVendorNumber in the export file does not match the One time vendor code in Enterprise ERP
Verify the One time vendor code in Enterprise ERP:
- 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 Enterprise Permitting & Licensing:
- 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 Enterprise ERP
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