Rec'd but not Invoiced Rpt not matching the GL

Yahoo Archive
1
Wee see a similar problem 2 or three times evry January. Somebody with fast fingers enters the correct month and day, but slips up and enters the "old year"

--- In vantage@yahoogroups.com, "Brian Roberts" <broberts@...> wrote:
>
> We had confusing transactions on some receipts after our 6->9 upgrade,
> the root cause was typos in the dates (eg 2021 instead of 2011).
>
> Brian.
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of c.krusen1
> Sent: Friday, August 26, 2011 12:51 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Rec'd but not Invoiced Rpt not matching the GL
>
>
>
>
>
> When we first switched to version 8.03 (from version 4) we had all sorts
> of issues with GL not matching up with the Stock Status Report.
>
> There were two main culprits:
>
> * Accounting was doing unnecessary GL entries (compensating for a lack
> of functions in V4, that V8 was doing).
>
> * Purchasing had some incorrect settings (mainly GL Expense on either
> the Part Class, Vendor, or PO)
>
> Finding the root cause was done by querying the PartTran and GL tables
> (separately). Then trying to reconstruct the "end of day balance for
> each, on a day by day basis. Eventually a transaction (GL or PartTran)
> would look suspicious and be the culprit(or one of them).
>
> Calvin
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Anyone experienced this before?
> >
> >
> >
> > If so did you figure out what caused it? Please share your experience,
> > because I cannot think of anything that would cause this!
> >
> >
> >
> >
> >
> >
> >
> > M. Manasa Reddy
> >
> > Information Technology Manager
> >
> > Welding Company of America
> >
> > manasa@
> >
> > 800.852.2325
> >
> > 630.806.2000 ofc
> >
> > 630.806.2001 fax
> >
> >
> >
> > constant innovation
> >
> > www.weldcoa.com
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
2
Anyone experienced this before?



If so did you figure out what caused it? Please share your experience,
because I cannot think of anything that would cause this!







M. Manasa Reddy

Information Technology Manager

Welding Company of America

manasa@...

800.852.2325

630.806.2000 ofc

630.806.2001 fax



constant innovation

www.weldcoa.com







[Non-text portions of this message have been removed]
3
When we first switched to version 8.03 (from version 4) we had all sorts of issues with GL not matching up with the Stock Status Report.

There were two main culprits:

* Accounting was doing unnecessary GL entries (compensating for a lack of functions in V4, that V8 was doing).

* Purchasing had some incorrect settings (mainly GL Expense on either the Part Class, Vendor, or PO)

Finding the root cause was done by querying the PartTran and GL tables (separately). Then trying to reconstruct the "end of day balance for each, on a day by day basis. Eventually a transaction (GL or PartTran) would look suspicious and be the culprit(or one of them).

Calvin

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Anyone experienced this before?
>
>
>
> If so did you figure out what caused it? Please share your experience,
> because I cannot think of anything that would cause this!
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@...
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
>
>
> constant innovation
>
> www.weldcoa.com
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
4
Hhmmm, interesting approach. Why didn't I think of that?! :)



Sounds like a good plan going forward, thanks for the suggestion!







M. Manasa Reddy

manasa@...

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of c.krusen1
Sent: Friday, August 26, 2011 11:51 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Rec'd but not Invoiced Rpt not matching the GL





When we first switched to version 8.03 (from version 4) we had all sorts
of issues with GL not matching up with the Stock Status Report.

There were two main culprits:

* Accounting was doing unnecessary GL entries (compensating for a lack
of functions in V4, that V8 was doing).

* Purchasing had some incorrect settings (mainly GL Expense on either
the Part Class, Vendor, or PO)

Finding the root cause was done by querying the PartTran and GL tables
(separately). Then trying to reconstruct the "end of day balance for
each, on a day by day basis. Eventually a transaction (GL or PartTran)
would look suspicious and be the culprit(or one of them).

Calvin

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Anyone experienced this before?
>
>
>
> If so did you figure out what caused it? Please share your experience,
> because I cannot think of anything that would cause this!
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@...
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
>
>
> constant innovation
>
> www.weldcoa.com
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
5
We had confusing transactions on some receipts after our 6->9 upgrade,
the root cause was typos in the dates (eg 2021 instead of 2011).

Brian.



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of c.krusen1
Sent: Friday, August 26, 2011 12:51 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Rec'd but not Invoiced Rpt not matching the GL





When we first switched to version 8.03 (from version 4) we had all sorts
of issues with GL not matching up with the Stock Status Report.

There were two main culprits:

* Accounting was doing unnecessary GL entries (compensating for a lack
of functions in V4, that V8 was doing).

* Purchasing had some incorrect settings (mainly GL Expense on either
the Part Class, Vendor, or PO)

Finding the root cause was done by querying the PartTran and GL tables
(separately). Then trying to reconstruct the "end of day balance for
each, on a day by day basis. Eventually a transaction (GL or PartTran)
would look suspicious and be the culprit(or one of them).

Calvin

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Anyone experienced this before?
>
>
>
> If so did you figure out what caused it? Please share your experience,
> because I cannot think of anything that would cause this!
>
>
>
>
>
>
>
> M. Manasa Reddy
>
> Information Technology Manager
>
> Welding Company of America
>
> manasa@...
>
> 800.852.2325
>
> 630.806.2000 ofc
>
> 630.806.2001 fax
>
>
>
> constant innovation
>
> www.weldcoa.com
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]