DIAN Accounts Payable Pending (R76C4F90)

When you run the DIAN Accounts Payable Pending program, the system reads data in the As-Of Account Payable (F0411A), Tax Detail - Work File (F76CUI02), Company Additional Information (F7400010), and DIAN MM Minor and Foreign Setup (F76C0F05) tables and generates the DIAN Formats File by Invoice (F76C4F02) temporary table for the 1009 format.

The DIAN Accounts Payable Pending report includes:

• Supplier name.

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

• Supplier's fiscal ID.

  If the supplier is a foreign supplier, the system uses the fiscal ID that you set up in the DIAN General Setup program.

• Debt concept.

• Amount pending.

• Department code.

  The system extracts this data for Colombian suppliers 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 suppliers only. If the data does not exist in the source table, the system prints an error message on the PDF report.

• Supplier 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. If the F0116.ALCTR field is blank, the system obtains the country code from the address number of the supplier. 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.

This report retrieves the value in the Open Amount field in the F0411A table to calculate the accounts payables pending by supplier.