Skip to main content
Question

Appears to be a bug in Inventory Adjustments with Project-specific inventory

  • September 16, 2022
  • 6 replies
  • 291 views

Forum|alt.badge.img

A positive inventory adjustment made directly to a project/task hits the project ledger as a negative qty/cost on the project ledger….  everything else in the GL and IN modules appears correct, but the project ledger is wrong.

 

the workaround it to do the adjustment to project X (this avoiding the incorrect project transaction) and doing a transfer into the project… but in current release of Acumatica (22R1 and prior) this doesn’t completely solve the issue from a reporting standpoint, since transfers still don’t hit the project ledger at all….  would be nice to have that fixed btw…

 

I have a business event setup to properly create a project transaction after the transfer.

But this seems to be a legit a bug unless I’m missing something obvious…

 

-Matt

 

6 replies

Heidi Dempsey
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • 271 replies
  • September 16, 2022

@matthewbeebe  What is the purpose of the Inventory Adjustment?  An Adjustment always debits inventory and then you designate the credit account with the reason code you choose.  Are you wanting to issue from inventory to the project?  Happy to schedule a meeting with you to discuss workflow.

-Heidi    heidi.dempsey@acumatica.com


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 40 replies
  • September 16, 2022

thanks for the quick response @Heidi Dempsey 

 

Establishing an initial cost/quantity in this case… the GL side:

 

NOTE: I’m not sure why Project X appears here in the journal transaction (I’ve always assumed it’s because of the way projects came later) and a need for it to balance against something…

 

this DOES result in correct project stock cost/qty:

 

 

But the project ledger is wrong:

 

Project transaction: 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2781 replies
  • November 2, 2022

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


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 40 replies
  • November 3, 2022

No.  It’s a bug and an incomplete/missing feature.

You can bring it into Project X, then do a subsequent transfer into your project as a workaround to get one half of it done, but then you need to create the project transactions (which can easily be done via business event)

 

-Matt

 

 


Heidi Dempsey
Community Manager
Forum|alt.badge.img+2
  • Community Manager
  • 271 replies
  • November 3, 2022

@matthewbeebe The journal entry you showed, credited the project inventory so the project ledger is correct.  The reason code is what determines the credit side of the entry.  What are you trying to accomplish with the adjustment?  Are you wanting to issue this inventory to a project?


  • Jr Varsity I
  • 11 replies
  • March 11, 2025

Has this issue been resolved, please?
 


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