Feature - Utility to Reset Item PTD/YTD Fields from Location History

Feature - Utility to Reset Item PTD/YTD Fields from Location History

Release Date - 5/26/16

The Rest Item PTD from Location History now has the option to also reset the Year-To-Date and Last Year accumulators in addition to the Period-To-Date accumulators. These fields are also reset from the I/M Location History file (IMLOCHST).  IMLOCHST is a better database to keep track of item history, however some users are used to looking at the Item Master PTD/YTD fields.  If you miss the proper timing to reset the Item PTD/YTD fields, you can now use this utility to reset the Item PTD/YTD fields for any reason.

You can perform this reset by going to Global Setup, Utilities, Generate Statistic Info, Generate, and Reset Item PTD from Location History.  The following screen will appear:  


Reset Item PTD? - Answer Y or N.  The field defaults to N.  Answer Y to reset the period to date usage, quantity sold, sales, and cost.
Reset Item YTD/Last Year?  Answer Y or N.  The field defaults to N.  Answer Y to reset the year to date usage, quantity sold, sales, and cost.  It will also reset the last year usage and sales.

The reset of the Year To Date and Last Year fields will take into consideration the Use Calendar Year Or Fiscal Year field found in System Utilities, Global Setup, System, and System Period Control.


Be aware that running this utility does not update the Item History File nor does it advance the Current Period in IM Setup.

Program Modified: IMRSTPTD, IMRSTPTP
CLS






    • Related Articles

    • Feature - Utility to Reset Item PTD Fields from Location History

      Release Date: 02/04/2016 A new utility has been developed to reset item PTD fields from I/M Location History (IMLOCHST). IMLOCHST is a better database to keep track of item history, however some users are used to looking at the data in the Item ...

    • Feature - Exclude Debit Memos from Updating Customer Sales Ptd/Ytd

      Release Date - 11/21/17 This feature allows the user to control whether the customer sales period-to-date and year-to-date are updated when a debit memo is posted from Sales & Cr/Dr Memo processing. This feature is enabled through a new A/R Global ...

    • AP2300 Accounts Payable Clear Vendor YTD Accumulators

      Clear Vendor YTD Accumulators Application Overview The Vendor File contains fields that show you the total year‑to‑date purchases, amount paid, and discounts taken. If the Purchase Order and Receiving package is in use, there are also fields showing ...

    • AP11S1 Accounts Payable Check History Report

      Check History Report Application Overview The Check History Report accesses the A/P Open Item File for check information. The A/P Open Item File contains information since the last purge date (date for which the Purge A/P Open Item File was last ...

    • Feature - Recalculate AP Vendor YTD and Last Year Amount

      Release Date: 7/6/2016 A new menu item has been added to Util-Setup -> Global Setup -> Utilities -> A/P Utilities -> Utilities -> Reset A/P YTD and Last Year This function will recalculate/reset the Year to Date (YTD) and Last Year amount in A/P ...