Import customer payments (DIEF)

1. Open the required template: GroupsCustomerPaymentJournal.csv
2. Edit the spreadsheet as follows:

   Header	Description
   JournalName	Customer payment journal set up in Fred NXT Head Office. For example, 01Cust
   Voucher	Mandatory Use ## or any fill-in value
   TransDate	Date on the Payment file received from the bank.
   AccountType	Customer
   LedgerDimension	If LedgerDimension is not provided, CRN is used instead.
   Txt	Optional Enter any additional description for the payment.
   CurrencyCode	AUD Mandatory
   AmountCurCredit	Amount paid by customer.
   AmountCurDebit
   PaymReference	Customer Reference Number (CRN)
   DocumentNum	Optional
   DocumentDate	Optional
   PaymMode	Any valid method of payment: BPAY, Card, cash, Cheque

3. Click File > Save as and save as .csv file in an easy to find location.

   

4. Click File > Exit to close your file.
5. Navigate to the file, then right-click the file and choose to Open with Notepad.

   Remove any blank lines at the end or spaced commas at the end of the file.

6. Click File > Save.

   The file is now ready for importing into Fred NXT Head Office with DIEF.

Ensure the file is closed and in .csv format before importing.

1. From the Dashboard, navigate to Data synchronisation > Store Integration > Data import Export Framework > Processing Groups.

   

2. Select GroupsProducts (or the relevant Group name) then click Get staging Data.

   

3. Enter a Description then click OK.
4. Click the File Path field to display
5. Click and browse to the import file.
6. Select Execute Target step.

   This is the faster import method as it transfers the import file directly from Staging to Target.

7. Click OK to start the import process.

1. From FredNXT Head Office, navigate to Customers and click Receipt journal.

   

2. In the Receipt journal grid, locate the newly imported Customer Payment journal, and click Post.