DIAN Consolidate Balance Sheet (R76C9F34)

When you run the DIAN Consolidate Balance Sheet program, the system reads data in the Account Master (F0901), Account Balances (F0902), and Company Additional Information (F7400010) tables and generates the DIAN Formats File by Account ID (F76C9F11) temporary table for the 1034 format.

The DIAN Consolidate Balance Sheet report includes:

• Tax concept

• Amount reported

When you run the DIAN Consolidate Balance Sheet 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 1034 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 1000 and each account has 500 as the amount, the system shows 5 in the F76C9F11 table and 2500 for concept 1000 in the XML file.