GL Expense Distribution

Yahoo Archive
1
How about a Crystal Report using subreports.

Shirley Graver
Systems Administrator
Rubber Associates Inc.
Cleveland/Akron, OH

-----Original Message-----
From: Joanne Yargeau [mailto:jyargeau@...]
Sent: Thursday, May 16, 2002 12:09 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] GL Expense Distribution


Why not design dept expense reports in the gl Financial report writer
showing month and year to date amounts by account and dept. We have
monthly
department expense reports and any questions with a particular account we
can then run a gl detail for that account under gl reports.

-----Original Message-----
From: John Hannaford [mailto:johnh@...]
Sent: Thursday, May 16, 2002 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GL Expense Distribution


That does seem a little involved. But if you want to show them what they
spent, why not do just that. The POs and invoices certainly have enough
detail to slice them up any way you want. Our accounting folk often work
too
hard on their super detailed GL to get information that can easily be
obtained from the entries that cause the GL transactions in the first
place.

John

-----Original Message-----
From: Chris Hansen [mailto:chansen@...]
Sent: Monday, April 22, 2002 1:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] GL Expense Distribution


Ryan,
You've hit on the one item that drives me crazy with the GL reports.
We've written many reports under report builder, but you still end up
using
two reports to find out what was posted from the periodic posting process.

It's also hard when you would like to show someone how much they spent in
a
certain area. I was showing someone just last week what was spent on
tooling, and had to use the two reports, and he thought that was so
ridiculous.

Chris Hansen
Controller
Herker Industries, Inc.


-----Original Message-----
From: rmrindler [SMTP:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution

I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

ADVERTISEMENT


<http://rd.yahoo.com/M=226020.2031982.3521154.1971030/D=egroupweb/S=17050071

83:HM/A=1073422/R=0/*http://www.qksrv.net/click-1084497-610300?url=http://ww
w.tv/en/landing.shtml&HHcode=yhc3my2>


<http://us.adserver.yahoo.com/l?M=226020.2031982.3521154.1971030/D=egroupmai
l/S=1705007183:HM/A=1073422/rand=247339845>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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


Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company
3
I feel your pain. Reconciliation of accounts is NOT easy with Vantage. I
run two reports, the WIP/Reconciliation and the general ledger for each such
account that I'm reconciling. What info I don't get from one, I get from
the other.

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: rmrindler [mailto:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution


I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler


[Non-text portions of this message have been removed]
4
Ryan,
You've hit on the one item that drives me crazy with the GL reports.
We've written many reports under report builder, but you still end up using
two reports to find out what was posted from the periodic posting process.

It's also hard when you would like to show someone how much they spent in a
certain area. I was showing someone just last week what was spent on
tooling, and had to use the two reports, and he thought that was so
ridiculous.

Chris Hansen
Controller
Herker Industries, Inc.


-----Original Message-----
From: rmrindler [SMTP:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution

I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
That does seem a little involved. But if you want to show them what they
spent, why not do just that. The POs and invoices certainly have enough
detail to slice them up any way you want. Our accounting folk often work too
hard on their super detailed GL to get information that can easily be
obtained from the entries that cause the GL transactions in the first place.

John

-----Original Message-----
From: Chris Hansen [mailto:chansen@...]
Sent: Monday, April 22, 2002 1:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] GL Expense Distribution


Ryan,
You've hit on the one item that drives me crazy with the GL reports.
We've written many reports under report builder, but you still end up using
two reports to find out what was posted from the periodic posting process.

It's also hard when you would like to show someone how much they spent in a
certain area. I was showing someone just last week what was spent on
tooling, and had to use the two reports, and he thought that was so
ridiculous.

Chris Hansen
Controller
Herker Industries, Inc.


-----Original Message-----
From: rmrindler [SMTP:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution

I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
Why not design dept expense reports in the gl Financial report writer
showing month and year to date amounts by account and dept. We have monthly
department expense reports and any questions with a particular account we
can then run a gl detail for that account under gl reports.

-----Original Message-----
From: John Hannaford [mailto:johnh@...]
Sent: Thursday, May 16, 2002 11:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GL Expense Distribution


That does seem a little involved. But if you want to show them what they
spent, why not do just that. The POs and invoices certainly have enough
detail to slice them up any way you want. Our accounting folk often work too
hard on their super detailed GL to get information that can easily be
obtained from the entries that cause the GL transactions in the first place.

John

-----Original Message-----
From: Chris Hansen [mailto:chansen@...]
Sent: Monday, April 22, 2002 1:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] GL Expense Distribution


Ryan,
You've hit on the one item that drives me crazy with the GL reports.
We've written many reports under report builder, but you still end up using
two reports to find out what was posted from the periodic posting process.

It's also hard when you would like to show someone how much they spent in a
certain area. I was showing someone just last week what was spent on
tooling, and had to use the two reports, and he thought that was so
ridiculous.

Chris Hansen
Controller
Herker Industries, Inc.


-----Original Message-----
From: rmrindler [SMTP:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution

I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=226020.2031982.3521154.1971030/D=egroupweb/S=17050071
83:HM/A=1073422/R=0/*http://www.qksrv.net/click-1084497-610300?url=http://ww
w.tv/en/landing.shtml&HHcode=yhc3my2>

<http://us.adserver.yahoo.com/l?M=226020.2031982.3521154.1971030/D=egroupmai
l/S=1705007183:HM/A=1073422/rand=247339845>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
7
Hmmm......Depends John.....how many places do you want to go to dig up all
the info needed? What kind of reports have you or they written to refer to
ease of finding info they need?

Unless you've modified your PO's, they don't have the G/L number on
them......then you have to dig through trackers......
Reconciling stuff in Vantage is NO SMALL TASK......Help your accounting
dept. for a month end and walk a mile in their shoes to understand what they
are trying to achieve. A/P edit lists do not have the correct G/L numbers
either....just that blasted A/P Clearing account.

You hit a raw nerve here, I'm afraid. Our Purchasing Manager runs for cover
every time I mention A/P Clearing Account.. She
has heard about it WAY TOO often.

Deb Wilmoth
Controller
Reeder & Kline Machine Company, Inc.
Vantage 5.0


-----Original Message-----
From: John Hannaford [mailto:johnh@...]
Sent: Thursday, May 16, 2002 10:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] GL Expense Distribution


That does seem a little involved. But if you want to show them what they
spent, why not do just that. The POs and invoices certainly have enough
detail to slice them up any way you want. Our accounting folk often work too
hard on their super detailed GL to get information that can easily be
obtained from the entries that cause the GL transactions in the first place.

John

-----Original Message-----
From: Chris Hansen [mailto:chansen@...]
Sent: Monday, April 22, 2002 1:15 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] GL Expense Distribution


Ryan,
You've hit on the one item that drives me crazy with the GL reports.
We've written many reports under report builder, but you still end up using
two reports to find out what was posted from the periodic posting process.

It's also hard when you would like to show someone how much they spent in a
certain area. I was showing someone just last week what was spent on
tooling, and had to use the two reports, and he thought that was so
ridiculous.

Chris Hansen
Controller
Herker Industries, Inc.


-----Original Message-----
From: rmrindler [SMTP:rrindler@...]
Sent: Monday, April 22, 2002 12:19 PM
To: vantage@yahoogroups.com
Subject: [Vantage] GL Expense Distribution

I have a problem with the GL Expense Distribution Report, and I am
wondering if anybody else is having the same problem. This report
only shows transactions that directly hit our GL Expense accounts
through the invoicing process. Anything that goes through the
Inv./WIP Capture and post process does not show up on this report.
The problem is, all of our POs & Receipts go through that process, so
anything that hits the GL through that process just shows up as a
cumulative, "Periodic Posting Process" transaction in the GL Account
Detail.

Our controller would really like to see all of the detail in one
report, not two. I called Vantage Tech Support, and they said this
is not possible. Has anybody else had that experience? It doesn't
make much sense to me why it would be programmed this way, but I have
been unable to build a report that can pull the appropriate data.

Thank you.

Ryan Rindler
Network Administrator
Norwood Tool Company



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



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