Feature - Add New Data Sources for File SY12MONS

Feature - Add New Data Sources for File SY12MONS

Release Date: 4/9/2016

Updated: 8/8/2018

Exanded the amount of data written to the SY12MONS file.

-----------------------

Invoice posting program CP0305 creates updated or new records that correspond to updates of the following files:

ARCUSFIL (SY12MONS-REFERENCE is Customer Number)
  TYPE 01
      AMOUNT 1: Total Sales for the customer by period
      AMOUNT 2: Total Cost for the customer by period
      AMOUNT 3: Number of invoices for the customer by period

ARCUSTYP (SY12MONS-REFERENCE is Customer Type)
  TYPE 01
      AMOUNT 1: Total Sales for the customer type by period
      AMOUNT 2: Total Cost for the customer type by period
      AMOUNT 3: Number of invoices for the customer type by period

ARCDEVIA (SY12MONS-REFERENCE is Ship Via Code)
  TYPE 01
      AMOUNT 1: Order Total Sale Amount for the ship via code by period
      AMOUNT 2: Order Total Weight for the ship via code by period
      AMOUNT 3: Order Total Volume for the ship via code by period
      AMOUNT 4: Number of invoices for the ship via code by period

ARSLMFIL (SY12MONS-REFERENCE is Salesman Number)
  TYPE 01
      AMOUNT 1: Total Sales for the Salesman by period
      AMOUNT 2: Total Cost for the Salesman by period
      AMOUNT 3: Total Commission for the Salesman by period
      AMOUNT 4: Number of invoices for the salesman by period

ARCDETAX (SY12MONS-REFERENCE is Tax Code from the Order Header File)
  TYPE 01
      AMOUNT 1: Sales amount for the Tax Code by period
      AMOUNT 2: Tax amount for the Tax Code by period
      AMOUNT 3: Miscellaneous amount for the Tax Code by period
      AMOUNT 4: Freight amount for the Tax Code by period

ARCDETRM (SY12MONS-REFERENCE is Order Terms Code)
      AMOUNT 1: Total Sales for the Order terms code by period
      AMOUNT 2: Number of invoices for the Order terms code by period

CPSHPFIL (SY12MONS-REFERENCE is Customer Number, Ship-To Number)
  TYPE 01
      AMOUNT 1: Total Sales for the customer by period
      AMOUNT 2: Total Cost for the customer by period
      AMOUNT 3: Number of invoices for the customer/Ship-To by period

IMCATFIL (SY12MONS-REFERENCE is the Product Category)
  TYPE 01
      AMOUNT 1: Line Item Sales amount for the Product Category by period
      AMOUNT 2: Line Item Cost amount for the Product Category by period

IMLOCFIL (SY12MONS-REFERENCE is Order Mfging Location)
  TYPE 01
      AMOUNT 1: Line Item Sales amount for the Location by period
      AMOUNT 2: Line Item Cost amount for the Location by period

-----------------------

AP transaction register program AP02P1 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 1: Vendor purchases for the Vendor by period
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Open Item adjustment program AP06P1 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Check Register program AP08P3 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

AP Void checks program AP08P4 creates updated or new records that correspond to updates of the following files:

APVENFIL (SY12MONS-REFERENCE is the Vendor Number)
  TYPE 01
      AMOUNT 2: Vendor amount paid for the Vendor by period
      AMOUNT 3: Vendor discounts for the Vendor by period

-----------------------

PR Post Checks program PRPSTCHK creates updated or new records that correspond to updates of the following files:

EMPFILE (SY12MONS-REFERENCE is the Employee Number)
  TYPE 01
      AMOUNT 1: Gross Pay for the employee by period
      AMOUNT 2: Taxable Gross for the employee by period
      AMOUNT 3: FICA Tax for the employee by period
      AMOUNT 4: Federal Withholding Tax for the employee by period

  TYPE 02
      AMOUNT 1: Earned Income Credit for the employee by period
      AMOUNT 2: State Withholding Tax for the employee by period
      AMOUNT 3: Other State Tax for the employee by period
      AMOUNT 4: City Withholding Tax for the employee by period

  TYPE 03
      AMOUNT 1: Tips Reported for the employee by period
      AMOUNT 2: Employee Meals for the employee by period
      AMOUNT 3: Total Deductions for the employee by period
      AMOUNT 4: Tip Credit for the employee by period

  TYPE 04
      AMOUNT 1: Total Allowances for the employee by period
      AMOUNT 2: Net Pay for the employee by period
      AMOUNT 3: Union Deduction for the employee by period
      AMOUNT 4: Regular Hours for the employee by period

  TYPE 05
      AMOUNT 1: Special hous for the employee by period
      AMOUNT 2: Overtime Hours for the employee by period
      AMOUNT 3: Medicare Tax for the employee by period 

Modified Programs: CP0305, AP02P1, AP06P1, AP08P3, AP08P4, PRPSTCHK

DLM




    • Related Articles

    • Feature - Add Update to Item Audit File When Running Future Price Posting

      Release date: 4/18/2020 Version 8.5 & Up In Item File Maintenance, when you "Add" a new item, the system will write a record to the Item Audit file with ITEM-AUDIT-ACTION = "A" (Add). If an item master record is changed, then it writes two records ...

    • Feature - Prevent Duplicate Invoice Numbers with Invoice Cross Reference File

      Release Date - 3/25/19 Version: 8.5 and Up This feature uses a new table, the Invoice Cross Reference table, to determine if an invoice has already been used by another unposted or posted order. The Invoice Cross Reference is updated at the time of ...

    • Feature - Add Events for Addition of PO Header and Line

      Release date: 3/28/18 New events have been added that can be set up to trigger when adding new Purchase Orders. Purchase orders can be added through: PO -> Processing -> 1) Purchase order processing - Add 2) Purchase order processing - Change, F3 = ...

    • ARSRCMNT Accounts Receivable Payment Source File

      Payment Source File Application Overview This feature allows you to assign G/L accounts for various payment codes used in Elliott and the Elliott Shopping Cart. Additionally, you can set up and post to accounts for credit card surcharges and ...

    • APINVIMS Accounts Payable Invoice Import Utility

      A/P Invoice Import Utility Introduction This utility is similar to the COP Sales Order Import Utility. It will allow vendor invoices created through an external source to be imported and become New A/P Transactions in Elliott. Traditionally, if a ...