Filter Programs

You run the filter programs over tables that include information about accounts payable, accounts receivable, or general ledger transactions. The system populates one of four temporary tables with the data for the record types for the reports. The system uses the data in the temporary tables when you generate the output XML files. The system also reads the DIAN MM Minor and Foreign Setup table (F76C0F05) to obtain the fiscal ID and transaction type that is used for reporting when the transactions are for minimal amounts.

This table shows the temporary tables that are populated by filter programs, and actions that you must take before running the filter program:

Filter Programs	Temporary Table Populated	Required Before Running
DIAN Generate concept by Account (R76C9F01)	F76C9F02	Run the Date File Generation (R04901A) to generate as of data in the As-Of Account Payable table (F0411A). For formats 1006 and 1008, run the Data File Generation A/R program (R76C03B11) to generate data in the A/R Customer Ledger As Of table (F76C031A).
DIAN Sales VAT Discountable Origination by Sales (R76C3F50)	F76C4F02	Verify that the appropriate values exist in the 76C/VT UDC table.
DIAN Sales VAT to Pay Originated by Purchases (R76C4F60)	F76C4F02	Verify that the appropriate values exist in the 76C/VT UDC table.
DIAN Accounts Receivable Pending (R76C3F80)	F76C4F01	Run the Data File Generation A/R program (R76C03B11) to populate the F76C031A and F76C034A tables.
DIAN Accounts Payable Pending (R76C4F90)	F76C4F02	Run the Date File Generation program (R04901A) to populate the F0411A table.
DIAN Tributary Information (R76C9F11) DIAN Tributary Information (Certificates, Titles) (R76C9F14) DIAN Consolidate Balance Sheet (R76C9F34)	DIAN Formats File by Account ID (F76C9F11)	Verify that: A system 09 category code UDC table is set up for formats 1011, 1012, and 1034. The system 09 category codes are associated with the appropriate accounts in your chart of accounts.

When you run each filter program, you set a processing option to determine whether the system deletes existing records in the temporary table that is populated by the filter program. Generally, you delete records in a table if the records were generated for a DIAN report other than the report that you are currently running, or if you are regenerating a report.