.Payment Imports v2018.1

Capability

This Import allows the User to INSERT new records into the Payment grid. There is no way to determine if a payment is unique and the identification of duplicate payments is not possible.  For more information on Payments, see the AR Payment Wiki page.

It is not possible for PCR-360 employees to fix multiple accidental uploaded records.

Fields

Account Number (GLA)

Required

Datatype is Hierarchical String

Method of Payment

Required

Datatype is String

This must match a value within the PAYMENT_METHOD List (not case sensitive). See the List Values wiki page for more information.

Description

Datatype is String

Payment Date

Required

Datatype is String

Amount

Required

Datatype is String

This should be a positive, non-zero value

Batch Number (Payment Batch)

Datatype is String

If used, it must match an preexisting pending Batch Number.

Batch Number must be in Pending Status

Remarks

Datatype is String

UDF Associations

User Defined Fields on any given Import are all handled the same way with Conditional Logic. For more information about adding a UDF to the Import see the section of the Imports main page.

Errors

The following errors occur if the Payment Import INSERT fails:

• Error : Account Number was not found
• Error : Account Number was not Accounts Receivable
• Error : Batch Number <Batch Number> must be numeric
• Error : Batch Number <Batch Number> not found
• Error : Batch Number <Batch Number> must have Pending Status