One thing to help find the variances is to set up a report builder report to
look at transactions that the system date is greater than or equal to your
start of the next period(2/1/04) but the transaction date is less than or
equal to your month end date(1/31/04). You can set this up as a filter on
the report to look at transactions that are "back dated" or entered after
month end but before posting. Use the part tran as your master table. This
will pull up the transactions that are going through the wip report but on
not on your Inventory wip reconciliation when run at month end. Hope this
helps. Whenever a variance comes up when trying to reconcile this is the
first place I look.
Jim
look at transactions that the system date is greater than or equal to your
start of the next period(2/1/04) but the transaction date is less than or
equal to your month end date(1/31/04). You can set this up as a filter on
the report to look at transactions that are "back dated" or entered after
month end but before posting. Use the part tran as your master table. This
will pull up the transactions that are going through the wip report but on
not on your Inventory wip reconciliation when run at month end. Hope this
helps. Whenever a variance comes up when trying to reconcile this is the
first place I look.
Jim
> -----Original Message-----
> From: Ludwig, Rick [mailto:RickL@...]
> Sent: Thursday, February 05, 2004 11:04 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Accrued Accounts Payable
>
>
> Stephanie-
>
> How your son is doing better. When I first read your e-mail, I thought
> that was a line you gave to vendors calling for payment because you had
> delayed their payment via your change in the invoice date!
>
> While on the subject of Accrued A/P, I too, can't recall the last time I
> got the reports to balance. Usually its off by a couple thousand of
> dollars that I charge to Material Variance as I don't know where it
> belongs; however, this month, I am trying to resolve a $48k difference!!
> I HOPE its related to material being received in the wrong period as we
> have a new receiver on the dock that was NOT trained on how to PROPERLY
> use Vantage!
>
> I feel a lot better in that I'm not the ONLY one having this problems
> tying out this account at month-end! I agree with Deb, Epicor needs to
> revisit this issue and make Vantage more "accountant-friendly".
>
>
> Thanks!
>
>
>
> Rick Ludwig