Understanding How to Update Tables with Information from the Golden Tax System

After you use the Golden Tax system to generate and print the pre-formatted, pre-numbered VAT invoice, you must update the F75C001 table with the information from the Golden Tax system. You use the Text File Processor program to upload the interface file from the Golden Tax system into the text file processor tables, and then use the Download Jinshui Return File into JDE program (R75C7101) to upload the invoice information into the F75C001 table.

When you run the Download Jinshui Return File into JDE program, the system:

• Updates the GUI field with the GUI number.

• Updates the status field to P (printed).

• Updates the category code provided in the Golden Tax interface file.

• Compares the invoice total and line item amounts as calculated by the Golden Tax system to the amounts in the F75C001 table.

  If the amounts do not match, the system prints an error message in the report and does not process the invoice.

The Download Jinshui Return File into JDE program also validates this information and generates an error message when:

• The invoice status in the F75C001 table is C (canceled).

  A status of C means that the invoice has been processed as a cancellation. The system updates the GUI number in the F75C001 table, but leaves the status as C.

• The invoice is not found in the F75C001 table.

• The invoice in the F75C001 table already has a GUI number.

  The new GUI number is not written to the F75C001 table.

See also:

• "Working with the Text File Processor" in the JD Edwards EnterpriseOne Applications Financial Management Fundamentals Implementation Guide.