FACS Statement

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 VDM has the ability to read, process and treat FACS Statement text files as a database file.  The feature enables you to leverage the data within the FACS Statement for Finished Reports and Visualize.  We provide a VDM View with a Finished Report at the bottom of this article.

 

FACS Prerequisites

Before you get started, there are some settings within FACS that need to be configured before you produce your FACS Statement.  These configurations are required as VDM is reading and parsing the FACS Statement text file line by line.  Any deviation from the requirements may result in an incomplete or inaccurate result.

The following settings are required for Letter Code 960:

FORM LENGTH: 17
TOP BLANK LINES: 0
LEFT MARGIN: 0

Letter #9601.png

The following lines must be included and set to the columns defined below.

LINE 1 COLUMN 1: <<82@NOTE1>>
LINE 3 COLUMN 1: <<82@NOTE2>>
LINE 4 COLUMN 1: <<82@NOTE3>>
LINE 6 COLUMN 1: <<82@CLACCT>>
LINE 10 COLUMN 10: <<CLIENT ADDRESS>>

2.png

 

Statement Detail Letters:
If you utilize Statement Detail Letters each line must be indented for VDM to properly process the data.  Recommended <<@8>> or <<@10>>

mceclip1.png

The test parser requires two lines per consumer entry.  You can use a detail letter or Sort Code 2 or 3 to meet this requirement:

mceclip0.png

Statement System Option for decimal:
Verify the decimal point option is set to Yes.4.png

 

Approved Client Masters Statement Settings:
We've tested VDM using the following two configurations.

Configuration 1:
mceclip1.png

Print DP Reference: N
Print Balance: Y
Print Settlement: Y
Combine Corr. Clients: N
Summary Statement: Y
Dbl Space Payments: N

Configuration 2:
mceclip0.png
Print DP Reference: N
Print Balance: Y
Print Settlement: Y
Combine Corr. Clients: N
Summary Statement: N
Dbl Space Payments: N

 

Generate FACS Statement

With the prerequisites completed, you can now create your FACS Statement using the 

  1. Go to menu 3,9,1
  2. Select Document Number
  3. Verify the data
  4. Create Text File
  5. Run the text file through VDM (Steps Below)

 

VDM Prerequisites

Before we process our first FACS Statement we need to setup the FACS Client Statement template in VDM.

1. Right click on Database Files in the Tables/Fields section and select Add From Text File > Templates > FACS

mceclip0.png

 

 

2. Select the FACS_ClientStatement Template 

mceclip4.png

 

 

3. Set the File Options File location to the FACS Statement text file you created earlier.  Click Test Import to verify setup.

mceclip3.png

 

 

4. Click Finish after the Import Successful message is displayed.

mceclip5.png

 

 

5. The FACS_ClientStatement template should now be available under Database Files in Tables/Fields.

mceclip9.png

 

 

6. Click on Database Files to establish a connection.

Note: Valid connection to database files can be seen in the bottom left of VDM's main screen.

mceclip6.png

 

 

OPTIONAL: Drag the newly created template into the Report Fields area of VDM and click run to test that results are obtained.

mceclip11.png

 

 

7. Download and Open this FACSStatement.vdm View (last updated 10/22/2020).  Click Run View and you will be prompted to select the FACS Statement Report File*.

*The FACSStatement.vdm View has a parameter that will allow you to define the location of your FACS Statement text file at run time.  We've provided a samples FACS Statement text output here for testing purposes FACS Statement Example.txt

mceclip0.png

 

 

8. Click Finish to process the FACS Statement into VDM. Once the View has executed and completed, click on Finished Reports to view the report.

mceclip7.png

 

 

Finished Report Preview

mceclip3.png

 

 

Have more questions? Submit a request

Comments