Transferring FG inventory from one warehouse to another

SUGGESTED

Hi!

We have recently created a second warehouse in our system and are trying to find the most efficient/effective way to transfer the inventory in the system as well as physically.  I know there is a transfer option in inventory management, but we are looking for a BOL/shipping diagram as well.  Is it easier to set this warehouse up as a customer and create a sales order at $0 to transfer the inventory.  Wondering how others handle this situation.

Thanks! 

Parents
  • 0
    SUGGESTED

    The best way is to do an import into Inventory Transaction Entry set as Transfer Type of transaction.  You will need the FIFO tier, Lot Number and Serial Number in the file.  Don't try to get cute with setting up the warehouse as customer and using a sales order and you are just making it more difficult on yourself.  

  • 0 in reply to BigLouie

    Just thinking out loud.  Always wondered about using a material requisition in PO as a formal way to initiate a "transfer request" and create shipping documentation, close the requisition to ship and remove from the warehouse, then do receipt in inventory transactions in the new warehouse when the product arrives, referencing the requisition #.

  • 0 in reply to ahniergarth

    IM Receipts are posted against the Purchases Clearing account... and you have to process two transactions (plus a potential GL adjustment to correct the Purchases Clearing account).

    I've considered creating an SO Quote (which does not affect "OnSO" quantity), printing shipping documents from there, then have a button script to copy the quote line data into an IM transfer (and deleting the quote)... but setting all that up is more work than just designing a custom report to print from Transfer data.

Reply
  • 0 in reply to ahniergarth

    IM Receipts are posted against the Purchases Clearing account... and you have to process two transactions (plus a potential GL adjustment to correct the Purchases Clearing account).

    I've considered creating an SO Quote (which does not affect "OnSO" quantity), printing shipping documents from there, then have a button script to copy the quote line data into an IM transfer (and deleting the quote)... but setting all that up is more work than just designing a custom report to print from Transfer data.

Children
  • 0 in reply to Kevin M

    the Requisition would post against the clearing account to provide the offset debit entry.  But I could see it getting troublesome with the extra entries in the account when balancing.  Your clearing account would be off by the un-received transfers. But you could post to a UDF to make it easy to track and segregate warehouse transactions hitting that account.  Again thinking out loud.