DIAN Sales VAT Discountable Origination by Sales

When you run the DIAN Sales VAT Discountable Origination by Sales program, the system reads data in the A/R Customer ledger As Of (F76C031A), 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 1006 format.

The DIAN Sales VAT Discountable report includes:

• Customer's 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).

• Customer's fiscal ID.

• Tax amount.

• Minimal amounts.

  The system generates one summary record per customer when the income on which the tax amount is based is less than the amount specified in the DIAN General Setup program (P76C0F00).

You use data selection to set up this program to select records for credit notes. The program determines which tax amounts to include in the report for the 1006 format by retrieving the G/L offset account from the F76CUI02 table and comparing it to the two-character code in the 76C/VT UDC table. If the characters match, the system includes the tax amount in the report.