i would like to create a UBAQ which i will be filtering on a dashboard, all i need this to do is select a new warehouse and bin location and update the database where the material is held.
i thought this would be a simple task (for some it may be) as adding the partbin table, making the warehouse and bin fields updateable and away you go.
can anyone point me in the direction i should be going with this?
I did this not to long ago, and its actually pretty easy.
Do you need to move Parts that are Wip products or only products on the part master record? Needing both complicates it more, but if you just want to move around Parts on the Master record then its not too bad.
For just the Inventory Transfer you need to make a BAQ and grab the Values required to populate the InvTranTrans Table like so.
Var TransRefrence is just a string that you want the Transaction reference to say, this is optional iirc.
Then feed that into a BO Method Erp.InvTransfer.CommitTransfer
If you need help with the Moving WIP products as well its a little more involved, but i can help.
