Skip to main content
Question

Issue with cost/unit while Manual Receiving Additional Stock

  • December 24, 2024
  • 6 replies
  • 78 views

Forum|alt.badge.img+9
  • Sidekick (Partner)
  • 137 replies

Hi Team,

 

During stock counting, we found that for a part there is an additional quantity that is not included in any PO’s. As a result it is not received into inventory during goods receipt and not reflecting on Inventory Parts In Stock window.

For manually receiving the particular stock into inventory, we are using “Receive Inventory Parts” window, where we are specifying the Quantity Received = 1 & required warehouse location. As there is no traceability for the part quantity, in Define Cost Structure window, we are deleting existing Cost Bucket associated with the part and adding a new Cost Bucket having Cost/Unit as 0.01. 

However, when I am going to Inventory Parts In Stock window, it is not showing the correct Total Inventory value & Unit Cost (both values getting changed but incorrect values) although the quantity has been updated.

Note: Inventory Valuation Method for particular part is : Weighted Average

Humbly request you to please help me on this.

Best Regards,

Rakesh

6 replies

Abdul
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 194 replies
  • December 25, 2024

Hi Rakesh,

I have some queries to understand reported issue.

  1. Whether Part is Lot/Batch or Serial controlled?
  2. What is Inventory Part Cost Level?
  3. What is Inventory Part Weighted Average After and Before receiving the part

 

Regards

Abdul Rehman


Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 137 replies
  • December 30, 2024

Hi ​@Abdul 

 

Please find below required information:

  1. Whether Part is Lot/Batch or Serial controlled? - Part is Lot/Batch
  2. What is Inventory Part Cost Level?- Cost per part
  3. What is Inventory Part Weighted Average After and Before receiving the part?- Before receiving the part, Unit cost was 362.64 & After receiving the part, Unit Cost is 357.31. While receiving the part what I did was, made the Cost/Unit for the existing Cost Bucket ID’s as 0.00 and added a new Cost Bucket with Cost/Unit as 0.01.

Please find below the attached screenshot.

 

Humbly request you to please help me on the same.

Best Regards,

Rakesh


Abdul
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 194 replies
  • December 30, 2024

Hi ​@Rakesh,

Can you please check Inventory Transaction History whether any Inventory Re-valuation was performed on this part as well.

I don’t see any other reason here except Weighted Average recalculation with NREC transaction.

Can you please confirm your On-Hand stock before receiving 1 additional pcs through NREC at 0.01 value.

 

Regards

Abdul Rehman


Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 137 replies
  • December 31, 2024

Hi ​@Abdul ,

 

Please find below the screenshot of  Inventory Transaction History for particular part:

 

I assume no Inventory Re-valuation is performed. 

On-Hand stock before receiving 1 additional pcs was 10 for the particular location.

 

Best Regards,

Rakesh


Abdul
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • 194 replies
  • December 31, 2024

Hi ​@Rakesh,

As you have confirmed that Inventory Part Cost Level is Cost per part, the system would consider Inventory Stock available across all locations. I would suggest you please calculate new weighted average by all complete on hand stock and then check.

 

Regards

Abdul Rehman 


Forum|alt.badge.img+9
  • Author
  • Sidekick (Partner)
  • 137 replies
  • January 13, 2025

Hi ​@Abdul 

 

Thank you so much 😊


Reply


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