Well our AR clearing has been fine for a long time.. maybe pennies off from time to time.. but not often. AP is usually fine too... probably three times since 2001 has that been off.. When I run capture you can see the stuff that is outside of the date range and I take care of those before I post capture. I WIP/INV reconciliation on past periods just to make sure something doesn't mysteriously pop up. We are off between all inventory accounts about 1 to 2 thousand dollars a month... not much but enough to make you wonder why.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of bakerprovan
Sent: Friday, April 29, 2005 1:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Variances between Detail sub ledger reports and
what posts in GL
The main point of my response is that a dead simple fix resolved our
problem - re-open all the closed periods and rerun capture. Might
be worth a try.
It is now going on 2 months since I went through this and it got
fiendishly complex. I don't trust myself to retell the story
accurately. In broad terms we had dollars getting hung up in WIP,
AP & AR clearing. The amounts in the balance sheet didn't match the
reports. For example, the amount in AR clearing did not match the
goods shipped, not invoiced report. The problem was caused by
transaction dates referencing closed periods and capture being
unable to complete the transactions (and not giving any warning).
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@k...>
wrote:
blind.. I have done that and not found anything.
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of bakerprovan
Sent: Friday, April 29, 2005 1:47 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Variances between Detail sub ledger reports and
what posts in GL
The main point of my response is that a dead simple fix resolved our
problem - re-open all the closed periods and rerun capture. Might
be worth a try.
It is now going on 2 months since I went through this and it got
fiendishly complex. I don't trust myself to retell the story
accurately. In broad terms we had dollars getting hung up in WIP,
AP & AR clearing. The amounts in the balance sheet didn't match the
reports. For example, the amount in AR clearing did not match the
goods shipped, not invoiced report. The problem was caused by
transaction dates referencing closed periods and capture being
unable to complete the transactions (and not giving any warning).
--- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@k...>
wrote:
> What were some of the issues that specifically happened for youthat caused the variances? After you went through the days of going
blind.. I have done that and not found anything.
>Behalf
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
> Of bakerprovanand
> Sent: Thursday, April 28, 2005 8:05 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Variances between Detail sub ledger reports
> what posts in GLmainly
>
>
> In our case we had "timing issues" with backdated transactions,
> shipping & receiving. Reopening all closed periods and re-runninginvoiced,
> capture corrected most of these problems.
>
> We have also had problems not properly closing out AP goods
> not received. A fairly basic problem but still not easy to detectin a
> mountain of transactions.and
>
> As far as tracking the problems down this was my procedure:
> . Copy the data to a test database,
> . Simplify the picture by posting all the shipments and receipts
> generally closing out unfinished processesthe
> . Run capture then use the Inventory/WIP reconciliation report for
> suspect account and manually match the debits and creditsjob.
> . Track down everything else that doesn't match.
>
> There went several days that could have been spent doing my real
>the
> I'd be pleased to hear about a better method.
>
> If I had understood the database better I possibly could have got
> data into Excel to speed up the matching process.wrote:
>
> Good Luck
>
> --- In vantage@yahoogroups.com, "Geary, Stephanie" <sgeary@k...>
> >have
> >
> > I have asked this before but does any one have issues with the
> variances in the gl postings and the amounts in the detail??? We
> a few thousand at month end and we really need a way to track downUseful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
> where/why these are occurring.
> > I would appreciate any ideas anyone uses in tracking down
> differences!
> > Thanks
> > Stephanie Geary
>
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links