Scenario
User creates Assembly Build records for their items. When the work is done and shipped, the cost of all labor, hardware and shipping is not stated anywhere on the record. User needs to easily see the breakdown of labor and shipping costs and also the total cost for everything the build.
Solution
When creating Assembly Builds, only the components of the Assembly are added to the sublist. There are no standard fields wherein users can enter the labor costs or shipping costs associated with the Assembly Build.
There are 2 possible options how the requirement can be met:
- Add Other Charge (For Purchase) Items to the Assembly's components
- Create custom fields to enter the Labor and Shipping Costs, and another to compute the Total Cost
Option 1: Add Other Charge (For Purchase) Items to the Assembly's components
You can add Other Charge (For Purchase) Items for Labor and Shipping Costs to the Assembly's components, so it will also appear in the Assembly Build component sublist. The user can then set the quantity/value of the labor/shipping costs. However, in doing so, these costs will be added to the total cost of the Assembly Item and will affect the item's value and average cost.
Here is an example:
- Other Charge Item (with Purchase Price = $1)
Note: I have set the Purchase Price to $1 so that the quantity input in the Assembly Build will be multiplied by 1.
**Create another one for Shipping Cost
- Added as a component of the Assembly Item
- Assembly Build for the Item. (Users can edit the quantity for the Labor and Shipping Costs in the Components)
Here is the GL Impact:
And here is the Assembly Item record showing the cost of the item:
Option 2: Create custom fields to enter the Labor and Shipping Costs, and another to compute the Total Cost
Create custom transaction body fields to add to the Assembly Build record. The user can enter the Labor and Shipping costs in these fields. You can setup another custom field to compute for the total cost of the transaction. With this, the users will be able to easily see the total cost of the transaction, and this will not affect the cost of the Assembly item.
Here is an example:
- Custom Transaction Body Field: (one for Labor Costs and another for Shipping Costs)
- Custom Transaction Body Field for Total Costs:
The Store Value field is not checked for the Total Costs. This is because there is a formula in the Validation & Defaulting tab:
For this formula, it is computing the total cost of the components plus the values entered in the custom body fields for Labor and Shipping.
Assembly Build for the Item:
GL Impact:
And here is the Assembly Item record showing the cost of the item:
Note: These options may or may not work for your specific requirement. Consult with your inhouse developers or reach out to your Account Manager to engage with our Professional Services team for further customizations.
-----
If you find this information useful, let us know by reacting or commenting on this post!