Format 1007

You use format 1007 to report on income received. The records for this format use a specific fiscal ID and the DIAN document type that you set up in the DIAN General Setup program for transactions with foreign suppliers or minimal amounts. When you run the DIAN Generate concept by Account ID program for format 1007, the system reads data in the F0911, F76C9F01, 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 to Account ID (F76C9F02) temporary table.

The records for format 1007 include:

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

• Income concept.

• Country code of customer.

  The system uses the value in the F0116.ALCTR field to obtain the reporting code that is associated with 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 book record 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.

• Amount received.

• Discount amount.