Import C/M Transactions - Revision history

Chanson: /* Sample File */

2021-04-15T14:00:24Z

Sample File

Chanson: /* Import File */

2021-04-15T13:58:38Z

Import File

Chanson: Chanson moved page CMPRIMP to Import C/M Transactions

2021-04-15T13:40:15Z

Chanson moved page CMPRIMP to Import C/M Transactions

Chanson at 13:39, 15 April 2021

2021-04-15T13:39:10Z

Chanson: Created page with "Cash Management Import Transactions is used to import cash activity into a special batch file without creating related g/l. Typically a separate g/l batch is imported which c..."

2021-04-15T13:33:06Z

Created page with "Cash Management Import Transactions is used to import cash activity into a special batch file without creating related g/l. Typically a separate g/l batch is imported which c..."

New page

Cash Management Import Transactions is used to import cash activity into a special batch file without creating related g/l. Typically a separate g/l batch is imported which covers all related g/l transactions. This program works hand in hand with Post Imported Transactions.

==Import Settings==

*'''Import File:''' Select the file (typically a .csv file). After import this file will be renamed with a .bk1 extension.
*'''G/L Account:''' The cash g/l account being imported. This must match the account in the transaction records in the input file.
*'''Batch ID:''' This is auto-created as '''IMP-{session_no}''' reflecting the current session number of this import program.
*'''Batch Date:''' This is the date of the batch. The actual dates in the import file are assigned to the individual transactions.
*'''File Contains Header:''' Check this if the first line of the file is a header record.
*'''Transaction Amount Handling:'''
**'''Trx Type:''' Use this when all amounts in the input file are stored (normally) positive and the transaction type indicates credit or debit handling. In this case checks and deposits are '''+''' in the input file.
**'''Trx Amount:''' Use this when the amount in the input file are set as positive for debit and negative for credit. In this case checks are '''-''' and deposits are '''+''' in the input file.

@@ Line 36: / Line 36: @@
 ===Sample File===
 <pre>
 GLAccount,TrxDate,TrxAmount,CheckNo,EntityId,Description,CheckMemo,VoidInd,DirDepFlag,TransactionType,Name,Address1,Address2,City,State,Zip

@@ Line 26: / Line 26: @@
 *VoidInd (optional)
 *DirDepositFlag (optional)
-*TrxType (optional)
+*TrxType (optional)  2=Check (Default)
 *Name (optional)
 *Address1 (optional)
@@ Line 33: / Line 33: @@
 *State (optional)
 *Zip (optional)

← Older revision		Revision as of 13:39, 15 April 2021
Line 11:		Line 11:
	**'''Trx Type:''' Use this when all amounts in the input file are stored (normally) positive and the transaction type indicates credit or debit handling. In this case checks and deposits are '''+''' in the input file.		**'''Trx Type:''' Use this when all amounts in the input file are stored (normally) positive and the transaction type indicates credit or debit handling. In this case checks and deposits are '''+''' in the input file.
	**'''Trx Amount:''' Use this when the amount in the input file are set as positive for debit and negative for credit. In this case checks are '''-''' and deposits are '''+''' in the input file.		**'''Trx Amount:''' Use this when the amount in the input file are set as positive for debit and negative for credit. In this case checks are '''-''' and deposits are '''+''' in the input file.
		+
		+	==Import File==
		+
		+	The expected file should be a comma delimited text file (.csv)
		+
		+	===Fields===
		+	*GLAccount
		+	*TrxDate
		+	*TrxAmount
		+	*CheckNo
		+	*EntityId (optional)
		+	*Description (optional)
		+	*CheckMemo (optional)
		+	*VoidInd (optional)
		+	*DirDepositFlag (optional)
		+	*TrxType (optional)
		+	*Name (optional)
		+	*Address1 (optional)
		+	*Address2 (optional)
		+	*City (optional)
		+	*State (optional)
		+	*Zip (optional)

← Older revision	Revision as of 13:40, 15 April 2021
(No difference)