CSV Import of Unapplied Customer Payment
Published on
November 30, 2023 at 3:56:48 PM PST November 30, 2023 at 3:56:48 PM PSTth, November 30, 2023 at 3:56:48 PM PST
Scenario
CSV Import of Unapplied Customer Payment.
Solution
- Create a CSV Import file with the following headers:
- External ID (Any alphabet, numeric, or alphanumeric which is unique per customer payment record)
- Customer
- Date
- Posting Period
- Payment Amount
- Payment Method
- Check #
- Navigate toSetup>Import/Export>ImportCSVRecords
- Import Type = Transactions
- Record Type = Customer Payment
- Click Next
- Data Handling = Add
- Click Next
- Map the following fields:
- External ID <> ExternalId
- Customer <> Customer (Req)
- Date <> Date (Req)
- Posting Period <> Posting Period
- Payment Amount <> Payment Amount
- Payment Method <> Payment Method
- Check # <> Check #
- Click Next
- Click Save & Run
This is just a sample CSV Import file. Others which could be found on theMainFieldsuch asMemo,Department,Location,Class, etc. can also be specified should users wish to populate values for these fields.