DIAN Sales VAT to Pay Originated by Purchases

When you run the DIAN Sales VAT to Pay Originated by Purchases 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 1005 format.

The DIAN Sales VAT to Pay Originated by Purchases report includes:

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

  • Tax amount.

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 1005 report 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.