MIP fund accounting uses a definition file to perform the import of AR entries from GovCollect.  The file below is a JV journal voucher file.  That means when imported into MIP, the user will find it in theirjournal voucher section to view and post.


CHANGE FOR EACH CUSTOMER

The only thing that has to be changed for each customer is the GL Account segment portion of the definition file.  It is in red below. The segments are in MIP admin chart of accounts setup.  The name and segment positions must match for the import to locate the correct GL Account.


Below is the standard def file contents.  Review it.  You will see positions 1, thru 10 defined in the CSV file we export from GovCollect.  Position 10 is the document number used for grouping. 


NOTE - PAMENT entries use a different file layout and are imported as a Cash Receipt into MIP.



FILE,SESSION,C:\MIP Share\Import\Master Def files\nameit.csv

CONTEXTIDPOSITION,1

TRANSACTION_READ,3

CLEANLINE_READ,1

SUPPRESSWARNINGS

FILETYPE,CSV

CONTEXT,SESSION,HEADER,HSESSN

SESSION_SESSIONNUMID,,AUTONUM

SESSION_STATUS,,BP

SESSION_CURRENCY_TYPE,,USD

SESSION_DESCRIPTION,,Imported GovCollect AR

SESSION_SESSIONDATE,7,,MM/DD/YYYY

SESSION_TRANSSOURCEID,,JV

ENDCONTEXT

REM,----------------------------------------------------------------------------

REM, Document Header Information

REM,----------------------------------------------------------------------------

CONTEXT,TRANSENTRY,HEADER,HDOC

TEDOC_SESSION

TEDOC_TRANSOURCE,,JV

TEDOC_DOCNUM,10

TEDOC_DESCRIPTION,2

TEDOC_DOCDATE,7,,MM/DD/YYYY

TEDOC_DUEDATE,7,,MM/DD/YYYY

ENDCONTEXT

REM,----------------------------------------------------------------------------

REM, Document Transaction Lines Information

REM,----------------------------------------------------------------------------

CONTEXT,TRANSENTRY,DETAIL,DDOC

TETRANS_SESSIONNUMID

TETRANS_DOCNUM,10

TETRANS_DESCRIPTION,5

TETRANS_ENTRY_TYPE,,N

TETRANS_EFFECTIVEDATE,7,,MM/DD/YYYY

TETRANS_SEGMENT_Fund,1,,,1,3

TETRANS_SEGMENT_Account,1,,,5,6

TETRANS_DEBIT,8,0,,,,0 

TETRANS_CREDIT,9,0,,,,0

ENDCONTEXT