/
Miscellaneous Cash Payments Import Error executing getPrimaryDeliveryAddressSequence

Miscellaneous Cash Payments Import Error executing getPrimaryDeliveryAddressSequence



Description of Issue

When importing a Miscellaneous Cash Payments Import file, receiving an error clicking Output-Proc

  • An error has occurred while processing the payment.

  • Additional information concerning a status error of 100.

  • ERROR EXECUTING THE SQL STATEMENT getPrimaryDeliveryAddressSequence.



Context
  • Accounts Receivable

  • Miscellaneous Cash Payments Import



Cause

A specified Customer Number in the file does not exist in Munis.



Resolution

Development is currently researching the issue. 

Workaround:

  • Remove the Customer Number from the Import file. The payment receipt will generate in Enterprise EPR with no Customer Number.

  • Verify that the Customer Number in the file already exists in the Customers program. This will allow the payment receipt to generate in Enterprise ERP for the existing Customer record. 



Additional Information

Contact EERP Revenue Support for further assistance.











Related content

EPL Payments Dropped When Batch Imported Into Munis Due to 0 Deposit Reference
EPL Payments Dropped When Batch Imported Into Munis Due to 0 Deposit Reference
More like this
Miscellaneous Cash Import error - lnvalid column name iTxchgdefMuItiptyByCount
Miscellaneous Cash Import error - lnvalid column name iTxchgdefMuItiptyByCount
More like this
EPL Payments Missing From Munis Imported Batch Due To Payments Missing From EPL XML Export File
EPL Payments Missing From Munis Imported Batch Due To Payments Missing From EPL XML Export File
More like this
Miscellaneous Cash Payment Import program is unable to transfer file to Munis server
Miscellaneous Cash Payment Import program is unable to transfer file to Munis server
More like this
Card number does not exist in MUNIS when importing Purchase Card Statements
Card number does not exist in MUNIS when importing Purchase Card Statements
More like this
EPL refunds fail with the error selectPostZeroJournals
EPL refunds fail with the error selectPostZeroJournals
More like this