Related Topics

Comp Tax Exception Report

Contents

1 Overview

2 Exception Report

3 Selection Criteria

4 Tables Diagram

 

3 Selection Criteria

This Exception Report receives a list of AP Invoice Master (FFAPIM-INVOICE-MST) table records listed by Invoice ID Number (FFAPIM-ACCT-MST.FFAPIM-ID) to report as comp tax exceptions. This report must be used by another program, including the Comp Tax Generated Invoice Report, Comp Tax Status Report, or Comp Tax Reporting Totals. When printed, the Exception Report is simply appended to the end of the original report, with information pertaining to the original report. (This includes a continuation of the report's page numbers, identical filename, time, and date). Records are displayed in the order in which they are selected for inclusion in the report.  

 

  1. Calculate Invoice Taxable Amount: Search the AP Invoice Master (FFAPIM-INVOICE-MST) table to determine how to calculate the amount.

    1. If the following is true, the taxable amount is Invoice Subtotal (FFAPIM-INVOICE-MST.WA-FFAPIM-SUBTOTAL):  

      1. Table: AP Invoice Master (FFAPIM-INVOICE-MST)

      2. Invoice Account Breakdown (FFAPIM-ACCT-BRK) = "M" for "Master"

  3. If the above criteria is false, then the taxable amount is found by adding the Invoice Detail Subtotal (FFAPID-INVOICE-DTL.WA-FFAPID-SUBTOTAL) fields for each detail record under the following criteria:

      1. Table: Invoice Detail (FFAPID-INVOICE-DTL)

      2. Invoice Detail ID = Vendor Invoice’s Invoice Master ID (IDFFAPIM-INVOICE-MST.FFAPIM-ID)

      3. Invoice Detail Taxable? (FFAPID-INVOICE-DTL.WA-FFAPID-TAXABLE) = "TRUE"

  1. Calculate the Invoice Comp Tax Amount: Add the comp tax account distribution AP Invoice Accounts (FFAPIA-INVOICE-ACCTS) records’ Washington Sales Tax (WA-FFAPIA-SALES-TAX) fields, then multiply that sum by –1. Use the following fields to get each distribution record:

    1. Invoice Accounts ID (FFAPIA-INVOICE-ACCTS.FFAPIM-ID) = Invoice Master Account ID (FFAPIM-INVOICE-MST.FFAPIM-ID)

    2. Accounting Record Generated by Comp Tax Calculations? (FFAPIA-INVOICE-ACCTS.WA-FFAPIA-CTX) = "TRUE"

  3. Calculate Comp Tax Amount: The exception process calculates the comp tax for an invoice and creates a comp tax invoice record for the current date. The process reads the newly-created comp tax invoice record's values, then backs out the Comp Tax Invoice record creation. It uses the read values as the currently-calculated comp tax. Values that differ from those in the comp tax records appear in the Exception Report.

  4. Invoices Paid Before Conversion: A footnote is added if an invoice was paid before conversion. This is determined from the following logic:

    1. The Invoice Master Check Record ID Number (FFAPIM-INVOICE-MST.FFAPCK-ID) is examined. A non-zero value indicates that a payment has been made and posted for the invoice. If the FFAPCK-ID is zero, the item will not be footnoted.

    2. If the Check Record ID Number is non-zero, the Check Record (FFAPCK-CHECK-REC) carrying that FFAPCK-ID is retrieved and the Updated Date (FFAPCK-UPD-DATE) examined.  If the Updated Date is less than or equal to the Control File Installation Date (FFAACT-CONTROL-FILE.FFAACT-INSTALL-DATE) then the item will be footnoted.

Page Updated 11/04

Top