Import/Finance - Revision history

Dcowan: Redirected page to Data Import/Payments

2016-09-28T05:03:08Z

Redirected page to Data Import/Payments

Scarpenter: Replaced content with "= Page no longer valid = Please go to this page for importing payments in Emersion"

2015-12-01T05:18:52Z

Replaced content with "= Page no longer valid = Please go to this page for importing payments in Emersion"

Pdundas: /* Emersion Bulk Format */

2015-10-12T23:03:28Z

‎Emersion Bulk Format

Pdundas: /* Emersion Bulk Format */

2015-10-12T23:02:54Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T03:09:41Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T03:09:21Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T03:08:08Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T03:07:42Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T01:58:56Z

‎Emersion Bulk Format

Kcruz: /* Emersion Bulk Format */

2013-12-20T01:58:31Z

‎Emersion Bulk Format

← Older revision		Revision as of 05:03, 28 September 2016
Line 1:		Line 1:
−	~~= Page no longer valid =~~	+	#REDIRECT [[Data_Import/Payments]]
−
−	~~Please go to~~ [[Data_Import/Payments ~~\| this page~~]] ~~for importing payments in Emersion~~

← Older revision		Revision as of 05:18, 1 December 2015
Line 1:		Line 1:
		+	= Page no longer valid =

−	~~==Emersion Bulk Format==~~	+	Please go to [[Data_Import/Payments \| this page]] for importing payments in Emersion
−	*ACCOUNT_ID (Emersion Account ID e.g 123456)
−	*PAYMENT_DATE (YYYY-MM-DD)
−	*PAYMENT_TIME (HH:MM:SS)
−	*BPAY_BILLER_CODE
−	*BPAY_REFERENCE
−	*CUST_REFERENCE
−	*AMOUNT (INC TAX)
−	*SURCHARGE_AMOUNT (EX TAX)
−	*SURCHARGE_PERCENT (As a whole Number e.g 3% = '3')
−	*PAYMENT_METHOD (See Below Ref Table)
−	*PAYMENT_NOTE
−	*INVOICE_LIST (Pipe Delimited list e.g 123456 \| 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to ~~be allocated.)~~
−	*INVOICE_ALLOCATION_LIST (Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List e.g 120 \| 230)
−	*SURCHARGE_IN_AMOUNT (true - when the surcharge is contained in the amount)
−	*SURCHARGE_AMOUNT_INC_TAX (true - when the surcharge (amount) already includes tax)
−
−
−	~~'''Sample record:'''~~
−	ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX
−	~~5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true~~
−
−	~~5999998,2013-12-01,,,,123456,50.00,,,VISA_MC,IVR,123456\|123457,20\|30,true,true~~
−
−	~~'''Sample file:'''~~
−	[[~~Media:Payment bulk import sample file.csv~~]]
−
−
−	~~===PAYMENT_METHOD===~~
−	*PAYMENT_METHOD \|\|Description
−	*DIRECTDEBIT \|\|Direct Debit
−	*EFT\|\| EFT or Direct Deposit
−	*EFTPOS\|\| EFTPOS
−	*CASH\|\| Cash
−	*CHEQUE\|\| Cheque
−	*MORDER\|\| Money Order
−	*BPAY\|\| BPay
−	*PAYBYPHONE\|\| Pay By Phone
−	*POSTBILLPAY\|\| Australia Post Bill Pay
−	*AGENT\|\| Agent Collected
−	*INTERNAL\|\| Internal Charge
−	*VISA_MC\|\| Credit Card - VISA/MASTERCARD
−	*AMEX\|\| Credit Card - AMEX
−	*DINERS\|\| Credit Card - DINERS
−	*CONTRA\|\| Contra

@@ Line 21: / Line 21: @@
 ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX
 5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true
 5999998,2013-12-01,,,,123456,50.00,,,VISA_MC,IVR,123456|123457,20|30,true,true

@@ Line 13: / Line 13: @@
 *PAYMENT_NOTE
 *INVOICE_LIST	 (Pipe Delimited list e.g 123456 | 1234466)(If blank will be Unallocated Payment. Where INVOICE_LIST and INVOICE_ALLOCATION_LIST are pipe delimited fields including which invoices are to be paid, and how much is meant to be allocated.)
-*INVOICE_ALLOCATION_LIST (Pipe Delimited list e.g 120 | 230)
+*INVOICE_ALLOCATION_LIST (Pipe Delimited list if $ amounts in the same order as the Invoices in the Invoice List e.g 120 | 230)
 *SURCHARGE_IN_AMOUNT (true - when the surcharge is contained in the amount)
 *SURCHARGE_AMOUNT_INC_TAX (true - when the surcharge (amount) already includes tax)
@@ Line 21: / Line 21: @@
 ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX
 5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true
 '''Sample file:'''

← Older revision		Revision as of 03:09, 20 December 2013
Line 22:		Line 22:
	5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true		5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true

		+	'''Sample file:'''
	[[Media:Payment bulk import sample file.csv]]		[[Media:Payment bulk import sample file.csv]]

← Older revision		Revision as of 03:08, 20 December 2013
Line 22:		Line 22:
	5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true		5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true

−	[[~~Media~~:Payment bulk import sample file.csv]]	+	[[Sample File:Payment bulk import sample file.csv]]

← Older revision		Revision as of 03:07, 20 December 2013
Line 21:		Line 21:
	ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX		ACCOUNT_ID,PAYMENT_DATE,PAYMENT_TIME,BPAY_BILLER_CODE,BPAY_REFERENCE,CUST_REFERENCE,AMOUNT,SURCHARGE_AMOUNT,SURCHARGE_PERCENT,PAYMENT_METHOD,PAYMENT_NOTE,INVOICE_LIST,INVOICE_ALLOCATION_LIST,SURCHARGE_IN_AMOUNT,SURCHARGE_AMOUNT_INC_TAX
	5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true		5999999,2013-12-01,,,,516361...954,65.58,0.94,,VISA_MC,IVR,,,true,true
		+
		+	[[Media:Payment bulk import sample file.csv]]