DIAN Accounts Receivable Pending (R76C3F80)

When you run this program, the system reads data in the A/R Customer ledger As Of (F76C031A), A/R Check Detail file As Of (F76C034A), Company Additional Information (F7400010). and DIAN MM Minor and Foreign Setup F76C0F05) tables and populates the DIAN Formats File by Invoices (F76C4F02) temporary table.

The DIAN Incomes Received report includes:

  • Customer name.

    The system uses the alpha name or mailing name from the address book record for a customer who is a legal entity and the values for name and surname that you set up in the 01/W0 UDC table for customers who are natural persons, depending on the values in the DIAN General Setup program (P76C0F00).

  • Fiscal ID of the customer.

  • Debt concept.

  • Amount pending.

  • Department code.

    The system extracts this data for Colombian customers only. If the data does not exist in the source table, the system prints an error message on the PDF report.

  • Municipal code.

    The system extracts this data for Colombian customers only. If the data does not exist in the source table, the system prints an error message on the PDF report.

  • Customer country

    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 customer. 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.

You use processing options to specify the versions of the DIAN Configurable Setup Concepts for Format 1008 program that you set up for data selection.