Skip to main content
Question

material stuck in-transit

  • May 25, 2023
  • 8 replies
  • 280 views

Forum|alt.badge.img

We found an item that has a phantom quantity stuck in-transit. - Not sure how this has not been caught prior, but this is a very slow mover item.  I have a 2 step transfer that was done from 1 inventory to another.  full quantity was received, but a balance still shows on the inventory allocation as an incoming amount still to receive.  Not sure how to clear this.  This one item has 2 transactions 59190 and 59972 that are stuck like this,  No adjustments have been done on this item.  Lot # matches everywhere also.  you can see on the transfer, it shows zero in-transit qty available.

 

8 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • May 25, 2023

Hello,

I think you are saying Step 2 of the 2-step transfer, the Receipt, is released? Please confirm or show the receipt batch status.

Have you tried the Recalculate Inventory process ? 

Thank you.

Laura


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 25, 2023

material has been recalculated, done daily.  this is the print screen I showed above, you can see that the received qty matches the quantity, but on this one, its leaving a balance of 600.

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • May 25, 2023

This is the only thing that I can find different is the Lot# has a lower H. 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • June 21, 2023

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


Forum|alt.badge.img
  • Author
  • Freshman I
  • August 14, 2023

no we have not yet.  we have tried doing adjustments with the lower case Lot #’s but that is not helping either.  these are stuck in transfer status.


  • Freshman I
  • September 14, 2023

Same problem here with no solution.

Items have been 2-step receipted into bin warehouse/location with a lowercase batch, while the outwards (1st step) was upper case.

The inventory lands into the warehouse/location, but never decrements from in-transit.

 

Reading around it seems there is no way to adjust in-transit inventory.

Tried receipting 2nd step again, but its closed, with no way of re-opening or correcting it.

 

2-step transfer process seems to be a bit lacking / needing development.


Laura03
Captain II
Forum|alt.badge.img+19
  • Captain II
  • September 14, 2023

It sounds like the next step might be a Support Ticket with Acumatica.

If your partner has a SQL developer, they may be able to try updating the lowercase letters on the PO Receipt lines, then running Inventory Recalculation again, in a test copy of your tenant before repeating in Live.

Laura


Forum|alt.badge.img

Same problem