Customers and Manufacturing Subcontractors

We have a similar situation with our real clients, who are retailers. When one of them builds a new store, they may let out the store fixturing (our products) with all the other construction requirements to perhaps 5 different general contractors. We take the orders from the GC's. To consolidate the data, we set up a Project for the store, and list all the orders and jobs from all the GC's in the one project.

Hope this helps



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

I was wondering if and how anyone else is dealing with the below scenario. We
currently have a solution but wondered if anyone else had addressed this
differently.

We are looking to track Sales by customers who use manufacturing subcontractors.
For example, we have a very large Customer ABC who actually outsources most of
their manufacturing to company XYZ and company 123 (we are finding this to be
increasingly common). There may be some sales/invoicing activity to ABC in the
prototyping stages but after this stage XYZ and 123 take over full production.
We enter sales orders, ship to and invoice XYZ and 123. If you look at the
standard Vantage Sales reports which look at invoicing activity ABC looks like a
bit player. However, ABC is the driver for all production. All manufacturing
decisions come from ABC. So, even though we have invoiced the subcontractors,
we attribute all this business to ABC and want this to be reflected on Sales
reports.

We also can not say that all XYZ and 123 sales should be attributed to ABC since
XYZ and 123 (who happen to be major, global manufacturing subcontractors) also
act as manufacturing subcontractors for DEF, GHI and JKL, etc.

I look forward to seeing how Vantage users have addressed this issue.

Mike Lowe
Corporate I.S. Manager
Connor Manufacturing Services
(909) 273-1282
MLowe@...
Would using the Parent Company field in the customer file fix this for you.
ABC being the parent of ZYX and 123. Your a sales reports in report builder
could show subtotals for the parents and Childs.

Patrick J. Winter
Information Services Manager
sSc Specialty Screw Corporation
Vantage 3.00.614, Progress 8.3A

-----Original Message-----
From: MLowe@... [mailto:MLowe@...]
Sent: Friday, October 06, 2000 12:25 PM
To: vantage@egroups.com
Subject: [Vantage] Customers and Manufacturing Subcontractors


Good Morning!

I was wondering if and how anyone else is dealing with the below scenario.
We
currently have a solution but wondered if anyone else had addressed this
differently.

We are looking to track Sales by customers who use manufacturing
subcontractors.
For example, we have a very large Customer ABC who actually outsources most
of
their manufacturing to company XYZ and company 123 (we are finding this to
be
increasingly common). There may be some sales/invoicing activity to ABC in
the
prototyping stages but after this stage XYZ and 123 take over full
production.
We enter sales orders, ship to and invoice XYZ and 123. If you look at the
standard Vantage Sales reports which look at invoicing activity ABC looks
like a
bit player. However, ABC is the driver for all production. All
manufacturing
decisions come from ABC. So, even though we have invoiced the
subcontractors,
we attribute all this business to ABC and want this to be reflected on Sales
reports.

We also can not say that all XYZ and 123 sales should be attributed to ABC
since
XYZ and 123 (who happen to be major, global manufacturing subcontractors)
also
act as manufacturing subcontractors for DEF, GHI and JKL, etc.

I look forward to seeing how Vantage users have addressed this issue.

Mike Lowe
Corporate I.S. Manager
Connor Manufacturing Services
(909) 273-1282
MLowe@...



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
Mike,

We have a Very similar situation here. Our solution may not be the best,
but we have sort of side-stepped standard Vantage in a way. What we do is
use a user-field on the Sales Order to specify who the 'Final' customer is.
Then, we have reports that run sales, etc., sorting by this field.

Sarah