Release Notes for DTE v3.5

General Ledger

Accrual reversal register:  When you enter Yes to Reverse accrual entries as part of the End of Period processing (Miscellaneous menu column), this process now includes a register indicating what transactions are reversing, what date is being written to the file, and to which G/L accounts.

Summarized transactions for the gltran.ism and glyear.ism file:  The Interface from other applications process for any summarized account now creates both a debit and a credit record (if applicable) for each reference (date) being summarized. Previously, a single record with only the net amount was written to the gltran.ism,   and glyear.ism   file.

Expand amount fields:  All period total amount fields, such as carried in the chart of account or budget record, for entry or reporting have been expanded to a decimal 12 field with two places. This accommodates amounts up to 9 billion.

Creating new accounts:  Creating new chart of account codes via the "Create account" selection of the Miscellaneous menu column now defaults to the current processing year. You need only to enter a value if the year your creating for is different than the year displayed.

Copying Chart of accounts:  Added the option to copy the specific division or department account codes to another division or department within the same company. Select "Copy chart of accounts by div/dept" from the Miscellaneous menu column to execute the copy process.

Reporting:  Added report criteria options to print the Chart of Accounts listing by division and/or department.

Accounts Payable

Laser checks: With this release, DTE added the ability to print checks using single sheet laser checks. Select No  (the default) or Yes   in the Laser checks field, within the "Company" selection of the Maintenance Menu column. Nebs 9039 or 9027 are the two standard laser check formats supported. Nebs form number 9039 is an 8.5 x 11 inch check with an additional bottom check stub not used at this time. The form 9027 is 8.5 x 7 inch form with only the top check stub.

Vendor labels:  Added a Reports menu column selection to print vendor labels optionally sorting by zip code and including inactive vendors.

Expand invoice number:  Expanded A/P invoice number field from 8 to 12 characters. All Accounts Payable data entry, inquiry, and reporting field lengths are adjusted accordingly. Note:  Only the first eight characters of the invoice field are carried in the A/P to G/L distribution file or interfaced to General Ledger.

Vendor master:  Added several new fields...

• Added "dba" (doing business as) field. Any value in this field replaces the vendor's name when printing 1099's or checks.
  
• Added a "Remit to" address. If this address has a value, that value prints on the check. If this field is left blank, the vendor address is used.
  
• Added a G/L account (number), Division, and Department fields to be used as the default value displayed in the distribution window of Invoice entry and Recurring Invoice entry.
  
• Added a 1099 code field for default value displayed during Invoice entry.  

Invoice entry: If a vendor master has been designated as a 1099 vendor (entered Yes for the value of the field Print 1099), the 1099 code value (new field in the vendor master) is automatically displayed as the 1099 code field default value for invoice entry.

Also now display the entire invoice amount as the default value in the Distribution window of the Invoice entry.

Invoice proof list/posting register:  Change format of Invoice proof list for readability. Format is similar to the Accounts Receivable Transaction proof listing.

Added the amount of the discount applied to invoices field value that was entered.

Option to print the Invoice proof list and posting register in the order they were entered. To change the format of the Invoice proof list and posting register, enter either Entry or Vendor sequence in the Edit list sequence field in the "Company" selection of the Maintenance menu column.

Laser checks: Added the ability to print checks using single sheet laser checks. Select No  (the default) or Yes  in the Laser checks field, within the "Company" selection of the Maintenance Menu column. Nebs 9039 or 9027 are the two standard laser check formats supported. Nebs form number 9039 is an 8.5 x 11 inch check with an additional bottom check stub not used at this time. The form 9027 is 8.5 x 7 inch form with only the top check stub.

New Pay/deduction history file: Added a separate file, prcodh.ism , to record each employees pay and deduction code information as defined at the time the payroll transaction is posted. Includes a "snapshot" record of the field values defined for each pay/deduction code posted for an employee.

New field in the State tax file: Add gross wages amount to the protax.ism  file, necessary for the California state DE6 reporting.

New fields in the deduction code input window:  New fields were added to the deduction code file to print additional information on the W-2 form. The new fields include:

• W-2 Description to print in either box 11, 13, or 14 on the W-2;
  
• W-2 box number to chose either box 0 (blank), 11, 13, or 14;
  
• Deferred compensation (Deferred comp) field to be marked Yes  to print an "X" for Deferred comp in W-2, Box 15 or No  not to check any item in the W-2, Box 15;
  
• Deduction limit to define a maximum amount to withhold from an employees check for an ascending type deduction code. A declining deduction code type bypasses this field.

Salaried employees calculate hours paid: Creating transactions via "Pay salaried employees" function now calculates the number of hours worked for a salaried employee based on the Pay period field in the Employee master. For example, if the employee is paid weekly, the number of hours is calculated at 40, if defined as semi-monthly, hours is equal to 86.67, and bi-weekly, at 80. This allows salaried employees to base their sick and vacation accrual on the number of hours worked.

Reporting:  Created a new Pay/deduction history report to include data from a new history file (prcodh.ism ). Reporting criteria includes: Starting/ending employee ID, Starting/ending (Check) dates, optionally include Pay, Deduction, or Both codes, and Starting/ending code.

Added a new report to print the federal, state, and city Tax tables defined.

Kit changes:  Kit inquiry window displays all pages of Kit components that apply to the main kit.

Defining Kits via the Maintenance menu column verifies that the Item ID entered for the main Kit ID is defined as a Kit in the Serial/lot field of the Item master. If not defined as a kit, the message "This item is not set up as a kit" displays requiring you to change the Item master Serial/lot field by selecting "Items" from the Maintenance menu column.

Reporting:  Added a format option to the Price list to sort by Item ID.

Changed the format of the Physical count, Long/short report to clarify that the Serial/lot number quantities are for information only, not additional quantities added into the total. The total reflects the total Item ID quantities only.

Unselect shipped quantities:  Added a menu selection, "Unselect shipped quantities" to the transaction menu column. This option zeros out the quantities set as shipped for all unposted orders and marks the record in the oehedr.ism   file as if it had never been selected.

Kit changes:  The main Kit item last and average costs can now be updated via "Recalculate kit costs" from the Miscellaneous menu column. Enter the starting and ending item ID (kit) and location code. The total respective costs of the components are multiplied by the quantities invoiced and updated in the main Kit master record.

Kit components defined with serial/lot numbers now prompt for the component serial/lot number at the time of shipping the kit.

You can choose to print kit components on the invoice (previously printed only on the picking ticket) by entering Yes for the new field, Print kit components within the "Company" selection of the Maintenance menu column.

Negative values are now allowed for Serial/Lot number items when entered via Order Entry. This allows you to substitute a kit component item by entering a negative quantity for the component item being replaced and positive quantity for the new item to include.

Reporting: Added a report to print Recurring Orders, recurring type 1-9 or All.  Negative Kit component quantities are allowed for the Picking ticket.

Unselect set received quantities:  Added a menu selection, "Cancel receivings" to the transaction menu column. This option zeros out the quantities set as received for all unposted purchase orders and marks the record in the pohedr.ism file as if it had never been selected.

Back to top