Monday, March 25, 2019

CSV Import of Unapplied Customer Payment

1. 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 #

 

Note: This is just a sample CSV Import file. Others which could be found on the Main Field such as Memo, Department, Location, Class, etc. can also be specified should users wish to populate values for these fields.

2. Navigate to Setup > Import/Export > Import CSV Records.
-Import Type = Transactions
-Record Type = Customer Payment
-Next
-Data Handling = Add
-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

No comments:

Post a Comment