Hi,
In the course of doing business, we purchase component parts (for example rims and tyres etc) which are prepared as sub-assemblies (eg wheels, nut and bolt sets etc). These sub-assemblies are then used in various assemblies (eg axles, drive trains etc). The assemblies are then fitted into finished product (eg cars, trucks, trailers etc). The assemblies and sub-assemblies are also sold separately as items.
We purchase these component parts from various suppliers globally and in different currencies. We then sell them globally in various currencies and at varying discount rates per customer or customer type.
We have considered creating assemblies or item groups in order to manage the various items and assemblies, paricularly for estimating. However:
Assemblies will not allow for dependency on price, and so will not automatically calculate prices. It appears that every cost change, whether supplier cost, exchange rate or other variance needs to be manually updated.
An assembly added to an item group will not display any pricing information unless it has already been manually configured.
An existing item group cannot be added as a member to new item groups. While pricing is automatic, without being able to add an exiting item group to a new one, we lose the flexibility of being able to create sub-assemblies and assemblies in the system. In addition, item groups do not seem to natively appear in item lists when creating estimates.
Is there a work around that will allow us to achieve our aims:
* Create assemblies-in-assemblies (or groups-in-groups) and
* Have pricing update automatically and
* Have the assemblies appear in items lists in estimates and
* Be able to create sales orders and impact inventory on sale and
* Include all types of saleable items including inventory, services and charges etc. in the group or assembly and
* Have activity impact COGS, income and asset accounts correctly
Any ideas much appreciated.