Normally at our year end, I would run some functions in AR that would do a variety of tasks, including setting customers YTD to zero. Our year end was August 31 and I neglected to complete this function (Year End Maintenance).

Can I go into the system AS OF Aug 31 and do so now, or will it clear all the September transactions as well?

Thank you for any help you may be able to provide.

Barb

Hi Barb,

It will clear the September transactions from the accumulators as well. You'd need to use GridView to calculate the correct figures and import them.

Darn, was hoping it would be much easier than that. Thanks Andrew.

Barb

Hi Barb,

Just to let you know that a new Toolkit for Adagio will be released at the end of this month. There are 6 new functions, including a 'Re-calculate Customer Statistics'. You set the date ranges and it calculates the new statistics, based upon your current/historical transactions. Likewise, for Vendors.

Information about the current release can be found on our website. http://www.dakotasoftware.com/toolkit.html

Bob

Hmm. Would this work the same way as the year end function for AR? Right now we have all of what should have been LY sales accumulating with Sept sales (should have been set at zero for Sept 1). Would this new function in Toolkit (which we do have as part of our package) be able to separate out sales from Sept 1/08-Aug 31/09 as our LY sales, and the amount from Sept 1/09 - Current as YTD? Or have I read this response incorrectly. If Toolkit will do the same thing as the AR Year End function, it seems wise to wait, as the Toolkit function sounds much easier.

Thank you for any insight you are able to provide.

Barb

Hi Barb,

Running the year end function in Receivables just moves the current figures to the LY buckets and zeros out the current year figures on the day that it is run. The toolkit will recalculate both figures at any time based on the transactions that it finds in the transaction file (which assumes you have not purged history for a year or so).

Sorry, just a bit overwhelmed today...so the Toolkit will do what I need it to do, or not?

Hi Barb,

I believe that Toolkit will work for you with this upcoming new feature as long as you have not purged your history in the last year and the transactions are fully intact for the previous and current years.

Note that this Toolkit feature is not a replacement for Year End in Receivables as other processing occurs during Year End.

Thanks very much.

Barb

Hi Barb,

I believe the earlier responses were correct. Provided you still have transactions on file, the customer's statistics can be recalculated. If you've purged history, there might not be this year's or last year's transactions. There are date ranges for the period start/end, current year start/end and prior year start/end. You can play with those date ranges and run the function repeatedly. For example, you could set your period range to be September, 2009. You can selectively recalculate a particular set of statistics. A screenshot would be easier.

The short answer is that it should work for you.

Thanks,
Bob.