Question

Cost in Stock Item and Kit Specifications Rarely Matches

  • 21 August 2023
  • 8 replies
  • 70 views
C
Rank
Userlevel 1

We do a lot of production, utilizing Acumaticas Kit Specifications/Kit Assembly. However, the cost on the Stock Item and Kit Specification rarely matches. Any reason why these 2 don’t match, when they should? Thanks!

8 replies

Laura02
Rank
Badge +18

Hello @CodyK ,

What is the valuation method on the Component item?  What is the valuation method on the Kit item?

Can you post screenshots of a the In Balance or IN Valuation report to show us the cost of a component item prior to kit assembly, and show us the resulting cost of the same item when added to the kit?

Thank you.

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
davidnavasardyan09
Rank
Userlevel 5
Badge +1

Hi @CodyK  The cost of a Stock Item is updated based on the costing method selected (such as FIFO, Average, etc.) and inventory transactions. If there have been recent transactions affecting the cost of the stock item, but the cost on the Kit Specification has not been updated yet, the costs may differ. Additionally, review the costing method, valuation method, and any manual overrides in the Kit Specification to ensure consistency with the Stock Items.

C
Rank
Userlevel 1

Hi @CodyK  The cost of a Stock Item is updated based on the costing method selected (such as FIFO, Average, etc.) and inventory transactions. If there have been recent transactions affecting the cost of the stock item, but the cost on the Kit Specification has not been updated yet, the costs may differ. Additionally, review the costing method, valuation method, and any manual overrides in the Kit Specification to ensure consistency with the Stock Items.

Thank you. Does the cost of the Kit Spec update when a Kit is assembled or when/how?

Laura02
Rank
Badge +18

Depending on the Valuation Method, the cost of the item may always be the same (standard cost), may be assigned when received, may be assigned when used from inventory, etc.

This is why we ask for your Valuation Method.

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
C
Rank
Userlevel 1

Hello @CodyK ,

What is the valuation method on the Component item?  What is the valuation method on the Kit item?

Can you post screenshots of a the In Balance or IN Valuation report to show us the cost of a component item prior to kit assembly, and show us the resulting cost of the same item when added to the kit?

Thank you.

Laura

The items in question are the same item. Example: PART XYZ is $244.8133 in Inventory Valuation. $177.633 in Kit Specifications and $177.69 on Last Cost on Stock Items. Currently the Valuation Method is AVERAGE

C
Rank
Userlevel 1

Depending on the Valuation Method, the cost of the item may always be the same (standard cost), may be assigned when received, may be assigned when used from inventory, etc.

This is why we ask for your Valuation Method.

Laura

Average is the Valuation Method

Chris Hackett
Rank
Userlevel 7
Badge

Hi @CodyK were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
C
Rank
Userlevel 1

Hi @CodyK were you able to find a solution? Thank you!

We did not

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved