Growing PO Accrual variance

We recently upgraded from Visual 7.0 to 9.0.8 SP5. Everything looked good. However, our accountant noticed that there was a variance between the PO Accrual report and the PO Accrual entry in the G/L of over $60K for March. Normally, there might be a variance of a few hundred dollars.

It seems that the variance grows throughout the month as postings are done. Infor advised us on using costing tools to identify errors in the purchase receipts but it doesn't account for the variance. They also replied with a procedure to check for bad batches and errors in the PO accrual, but it didn't uncover anything significant enough.

Has anyone experienced this issue? Any advice would be appreciated.

Mike Lavarnway

Trayer Products, Inc.

Find more posts tagged with

VISUAL - Enterprise General Discussions

Accepted answers

All comments

unknown

I have not had a problem with purchase accruals, however I'm having very similar problems with work in progress and stock values. There are huge discrepancies between the reports and the G/L. Infor have offered us no explanation as to why this is happening, only lengthy processes for checking it every month and recosting processes which take a weekend to run. We are using version 9.0.8 service pack 4. This is not new though, we have been having severe problems with this since 2006 (version 6) and our accountants are not best pleased.

Elaine Slater

Hydraulic Projects Ltd, UK

unknown

I concur that when we upgraded from Visual 7.1.1 to 9.0.8 SP4 in November 2020 that we also did not observe any abnormal financial account balances or activity.

unknown

I was lucky enough to be mentored by a Consultant with the initials LS. I don't know if name dropping is frowned upon here but he is retired. He gave me an extremely valuable set of queries for PO accruals. I wouldn't feel comfortable giving away his toolkit but I wouldn't have a problem with detailing what his queries looks for, if someone needs any help.

unknown

Hi Mike

I have now also started having problems with PO Accruals since upgrading to verstion 9.0.8 sp4- the difference is now huge. I have always had problems with stock values not matching the nominal accounts (see my message 2 years ago). I too have received no satisfactory explanations from Infor why this happens. If the person with the initials LS can offer any help or explantions of how to avoid these mismatches, I would be very grateful. My accountant is less than impressed with Visual.

Thanks

Elaine Slater

unknown

I just joined this group yesterday. LOL. Did not expect to have a "customer" so early. OK. His first query was to look for unposted API & PUR. When your AP peoples need to void a voucher, I don't think Visual allows you to pick a posting date. I think it defaults to the posting date of the original voucher. So I would search for status of "U" for Unposted in the dbo_PAYABLE_DIST table.

I bring this up because it was a recent problem for us. A different report brought up the other problem we had. A future dated receiver on a Voucher posted in the previous month. Honestly, there's like 20 different checks so let's get you past these first two because they are what we have currently experienced pain from. I probably need to dig in and understand the other queries but I won't give up on you!

unknown

I have checked for status 'U' in the payable_dist table. The only items there were new transactions in June 2023 which have not yet been posted.

Copyright © 2025 Infor. All rights reserved.