Related Topics

Comp Tax Generated Invoice Report

Contents

1 Overview

2 Sample Report

3 How-to

4 Fields

5 Selection Criteria

6 Tables Diagram

 

5 Selection Criteria

Records are selected for inclusion in this report in a two-phase process:

 

  1. Identify the generated comp tax invoices to be included:

    1. Vendor Invoice Master (FFAPIM-INVOICE-MST) records available for consideration are those where Invoice with Comp Tax? (FFAPIM-INVOICE-MST.WA-FFAPIM-GEN-CTX-INV) = "Yes".  

    2. Each Comp Tax invoice is read to see whether all of the Low and High ranges on the screen are met, as follows:

  1. Cash Account: Low must be less than or equal to Cash Account (FFAPIM- INVOICE-MST.FFAMBT-CODE), which must be less than or equal to Cash Account: High.

  1. Batch Number: Low must be less than or equal to Batch Code (FFAPIM-INVOICE-MST.FFAMSB-BATCH), which must be less than or equal to Batch Number: High.

  2. Invoice Date: Low must be less than or equal to Invoice Date (FFAPIM-INVOICE-MST.FFAPIM-INV-DATE), which must be less than or equal to Invoice Date: High.

    1. Records must contain the desired invoice type(s) as defined in the Invoice Status (ffapim-status) field. Values will be "B", "O", or "H", which represent "Batch", "Open", and "History".

    2. Comp tax invoice records which meet all conditions will be included in the report.

  1. For each comp tax generated invoice selected, all associated vendor invoices are listed beneath it. Associated vendor invoices are those where Invoice with Comp Tax? field (FFAPIM-INVOICE-MST.WA-FFAPIM-GEN-CTX-INV-ID) = Invoice ID (FFAPIM-INVOICE-MST.FFAPIM-ID) of the Comp Tax generated invoice record. These fields reflect the join relationship between the comp tax invoice record and its associated vendor invoice records. It is usual for a one to many relationship to exist.

Page Updated 2/04

Top