We have actually accomplished this in the past, if you know your allocation
of revenue up front. The process is as follows:
1) Create a sales order line for each of the departmental breakouts (i.e.
each departments revenue) with a product group for the applicable
department. Make sure you use the same part number for each line and the
qty ordered should be the % of the total.
2) If you link a job to the order, link all lines. If the amounts required
were entered correctly in step 1, the total for the job should match the
quantity ordered.
3) Modify the Crystal forms to group using the part number. This will
ensure that only one line for the total sales amount will appear for each
part number on the order acknowledgements, packing slips, invoices, etc.
Not perfect, but it has worked.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Jim Smith [mailto:jsmith@...]
Sent: Monday, March 11, 2002 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] G/L Accounting for sales revenues across departments
We normally sell parts that will migrate through multiple departments. When
a sale occurs the sales revenue is credited to the department that is
referenced in the part's master file even though it may account for only a
fraction of the time / expense incurred. We are trying to measure the
profitability of the departments within our company instead of just the
company as a whole. The expense side is easy to allocate to the individual
departments. Is there a way to have the revenue split between the various
departments involved at the time of invoicing?
Thanks in advance,
James Smith
Financial Coordinator
Lovejoy Chaplet Corporation
(518) 686-5232
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/
of revenue up front. The process is as follows:
1) Create a sales order line for each of the departmental breakouts (i.e.
each departments revenue) with a product group for the applicable
department. Make sure you use the same part number for each line and the
qty ordered should be the % of the total.
2) If you link a job to the order, link all lines. If the amounts required
were entered correctly in step 1, the total for the job should match the
quantity ordered.
3) Modify the Crystal forms to group using the part number. This will
ensure that only one line for the total sales amount will appear for each
part number on the order acknowledgements, packing slips, invoices, etc.
Not perfect, but it has worked.
Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
"Helping Business Make Intelligent Use of Technology"
-----Original Message-----
From: Jim Smith [mailto:jsmith@...]
Sent: Monday, March 11, 2002 4:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] G/L Accounting for sales revenues across departments
We normally sell parts that will migrate through multiple departments. When
a sale occurs the sales revenue is credited to the department that is
referenced in the part's master file even though it may account for only a
fraction of the time / expense incurred. We are trying to measure the
profitability of the departments within our company instead of just the
company as a whole. The expense side is easy to allocate to the individual
departments. Is there a way to have the revenue split between the various
departments involved at the time of invoicing?
Thanks in advance,
James Smith
Financial Coordinator
Lovejoy Chaplet Corporation
(518) 686-5232
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/