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 Vendor File:

• Vendor Purchase YTD
• Vendor Purchase Last Year
• Vendor Amount Paid YTD
• Vendor Amount Paid Last Year
• Vendor Discounts YTD
• Vendor Discounts Last Year

This utility is designed to help when you miss the year-end closing procedure for Accounts Payable on time.  During the Accounts Payable year-end procedure, you should perform Accounts Payable -> Processing -> Clear Vendor YTD Accumulators.  

This utility will allow users to reset these fields at a later time if the Clear Vendor YTD Accumulators function was not run at the proper time. See sample screen below:

 

Users have the option to choose to recalculate either the Purchase YTD and Last Year, the Amount Paid and Discounts YTD and Last Year, or both.  The options are selected by separate screen field entry. Select Y (yes) to perform the selected recalculations. It is suggested that: 

• If you are using calendar year, then you should answer "Y" to both questions.   
• If you are using fiscal year and you don't need to send out 1099 forms by using Elliott 1099 printing function, then you should answer "Y" to both questions. Make sure the Year Start date matches your fiscal year start date.
• If you are using fiscal year and you do need to send out 1099 forms from Elliott, then you may answer "Y" to one of them, or both with a different year start date. Elliott prints 1099 forms based on vendor amount paid YTD or last year on the calendar basis.  Therefore, the time period basis to recalculate amount paid (calendar year) should be different from the purchase amount (fiscal year). 

The Year Start fields allow the user to specify the starting date of the year. If running on a calendar year, these fields will default to January 1 of the current year. If running on a fiscal year, the Year Start for the Purchase YTD/Last Year will default to the first day of the fiscal year based on Global Setup system period control settings. The Amount Paid/Disc YTD/Last Year will default to January 1 of the current year since amount paid is used for 1099s and is calendar-year based. Both of these fields can be overridden by the user.

Words of Caution

Please be aware that the amount paid and discounts taken will be recalculated based on the check date in the APOPNFIL (A/P Open Item) table.  If your AP check date is different from your print and post AP check date, then the amount paid can be different from your original value in the vendor file.

Also, the A/P Open Item Amount contains the freight and miscellaneous amounts from the voucher that was posted.  These amounts are not updated to the vendor purchase YTD and Last Year during the new AP transaction posting routine.  Since we don't have these two amounts saved separately in the AP open item file, this utility may not recalculate vendor purchase YTD and Last Year correctly.

If you already purged this year's or last year's A/P Open Item to history, then you should not use this utility.

Modified Programs: NSCTLUT5, APRSTVEN, APRSTVEP, NSCTLUT7, NSCTLMNU

DLM, CLS

• Related Articles

• Feature - Customer Highest Balance YTD, Last Year, and Year Before Last Year

  Release Date - 4/26/16 The purpose of this feature is to track the customer highest balance YTD, Last Year and Year Before Last Year. This information can be used when applying for credit insurance. Currently only the customer's highest balance is ...

• I Forgot to Clear the AP Vendor Paid Accumulators at Year End

  Q - We forgot to clear the AP paid accumulators at year-end processing. What would be the best way going forward to get this resolved? We were going to run this now and make note of the current balances, but did not know if we could run this while ...

• 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 ...

• Feature - Last Year Net Income Layout Support

  Release Date - 3/29/19 Version - 8.5 and up For users who perform a temporary year-end close, from the time of the temporary year-end close to the final year-end close, the General Ledger Balance Sheet will be out of balance. This is because the ...

• IM1300 Inventory Management Recalculate Reorder Fields

  Recalculate Reorder Fields Application Overview The Recalculate Reorder Fields application should be run once every forecasting period. Each time it is run it recalculates the average periodic usage for each item. It also recalculates what the ...