DIAN Tributary Information (Certificates, Titles) (R76C9F14)

When you run the DIAN Tributary Information program, the system reads data in the Account Master (F0901), Account Balances (F0902), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables and generates the DIAN Formats File by Account ID temporary table for the 1012 format.

The DIAN Tributary Information report includes:

• Tax concept

• Amount reported

• Name and surname

• Fiscal ID

• Country code.

  The system uses the value in the F0116.ALCTR field to obtain the country code from the DIAN Country Code (76C/CC) UDC table.

  It the F0116.ALCTR field is blank, the system obtains the country code from the address number of the company. If no value exists for the country code in the address book records, the system prints an error message on the PDF report and does not write data for the record to the output tables.

When you run the DIAN Tributary Information (Certificates, Titles) program, the system writes the number of accounts for each concept to the F76C9F11 table. When you run the DIAN Output XML Generation program for the 1012 format, the system sums the amounts in the accounts.

For example, if five accounts in the account master are assigned the general ledger category code for concept 1100 and each account has 1000 as the amount, the system shows 5 in the F76C9F11 table and 5000 for concept 1100 in the XML file.