Skip to main content
Question

Cost in Stock Item and Kit Specifications Rarely Matches


Forum|alt.badge.img
  • Freshman II
  • 11 replies

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
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • August 21, 2023

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


davidnavasardyan
Jr Varsity I
Forum|alt.badge.img+2

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.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 11 replies
  • August 22, 2023
davidnavasardyan09 wrote:

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
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • August 22, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 11 replies
  • August 22, 2023
Laura02 wrote:

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 11 replies
  • August 22, 2023
Laura02 wrote:

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
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2757 replies
  • September 18, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman II
  • 11 replies
  • September 19, 2023
Chris Hackett wrote:

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

We did not


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings