Skip to main content
Question

Historical Inventory Valuation shows zero quantity items with a cost


Hello,

Long story short, I have certain items that have zero quantity, but are still showing a cost both on our inventory reports, and the GL.  This is from the Historical Inventory Valuation report - in aggregate, it balances to the GL.  There aren’t any other issues with Warehouse/Branch/etc - it all relates to the costs not clearing properly.

Here we can see where it starts.  We receive 7 of this particular item for $85.11, but when it’s sold, it’s relieved from inventory for $81.81, leaving the $3.30 with 0 qty.

The next month we can see that $3.30 carries through.

 

Looking at the Inventory Transaction Details, the purchase in August matches the Inventory report, but it shows an ending unit cost of $8.31, vs the $8.86 (53.16/6) unit cost on the report



This is just a single example that’s easy to see on an item that goes to 0 and up again, but it’s pervasive across our inventory IDs.

Certainly not impressed that our inventory reports aren’t reliable and the system is messing around with our cost of sales values.

I ran the ‘Recalculate Inventory’ process, but that doesn’t do anything here.

I’d definitely appreciate any insight about what might be happening here, as I have no idea what’s causing it, or how to fix the issues that are there because of it.

5 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • August 16, 2024

Hello, 

Is the Inventory Valuation report customized? Users in the Report Designer role can see the Report Versions tab where custom reports, if any, can be identified and de-activated, to rule out customizations as the cause of your issue. 

Does the site have any published customization projects? If yes, does the inventory valuation look incorrect if you temporarily un-publish all customizations and running Recalculate inventory?

Once customizations of all types are ruled out, it may be helpful for us to know your version.

Laura


  • Author
  • Freshman I
  • 7 replies
  • August 19, 2024

Hi @Laura02 ,

The report itself isn’t customized.  Realistically, it isn’t an issue with the report itself - the report is reading exactly what the GL is, so we can determine that what is displayed on the report is accurate. This is where the problem lies - the report is ‘accurate’ and agrees to the GL, but is still showing 0 qty items with values.  Extrapolate this for every item that has an average cost, but is not actually being valued at average cost because the cost total does not equal the qty x average cost (in any case where the qty is nil, the total cost must always be equal to $nil).

Our site does have customizations, but none that I would expect should touch inventory valuation (although this is certainly possible).  I’ll have to talk with our Implementation/Service Partner about activating/deactivating customizations.  They are in a constant state of befuddlement and unhelpfulness about everything, including this, which is why I’m taking to the forums to try and get help.

This is the version we are on:
Acumatica 2022 R2
Build 22.210.0020

Any other info you need, I’m happy to provide and I appreciate your response!


@kevinstudent , were you able to figure that out? If still not please create Acumatica Support ticket and we will assist you.


  • Author
  • Freshman I
  • 7 replies
  • September 20, 2024
yanagrigorieva75 wrote:

@kevinstudent , were you able to figure that out? If still not please create Acumatica Support ticket and we will assist you.

@yanagrigorieva75 Unfortunately it has not been resolved yet.  Pardon my naivety, but could you link me to the spot where I submit support tickets?

 

Thank you!


Forum|alt.badge.img+8
  • Semi-Pro I
  • 714 replies
  • September 21, 2024

@kevinstudent The partner should be able to assist create Support tickets 


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