Vendor Maintenance Screen??

[toomes1]

I am having a problem getting the correct numbers to show up in "Amount Paid" YTD in the vendor maintenance screen. The amnt showing is the amnt for the entire time we have had macola which is since 2002.

 

[dgillz]

This is because no one ever cleared accumulators. To get these to work properly you should clear accumulators at month-end and year-end. This is under AP, Processes, Clear Accumulators. There are similar processes in other modules as well.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[toomes1]

Is there any way to get the correct number to show up there, or if I cleared the accumulators today would that number would return to zero. I know we cleared the accumulators at year end
ing 6/31/05,,,we might have forgotten to do AP is there anyway to resolve the problem.

 

[dgillz]

You could write a sql script to go through the APOPNHST_SQL and total up purchases and amounts paid YTD (provided it has not been purged), and then have the sql script update the APVENFIL_SQL table.

Thats not for the faint of heart though.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[toomes1]

What if I just ran a crystal report to get those numbers and manually updated the APVENFIL_SQL

 

[toomes1]

ohhh,,,there would be a lot to update manually

 

[dgillz]

You can do that then manually key it is, but you would have to stop all Macola AP and PO processing for this to be corrrect. Also, you will have to turn off 'lock protected fields' in AP setup.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kscheeler]

You could just wait until the end of the year and clear the accumulators and start off 2006 correctly.

Kevin Scheeler