Without going into great detail has anyone come across the need to transfer stock between two separate databases? Basically they want to avoid a whole manual transfer process whereby they receipt in Company A, create another PO in Company A for Company B and then go into Company B and receipt the items etc.

If anyone has come across this situation or similar to it we would like to know more about it or if there is a third party product available for this type of situation as well. We looked at some of the third party products but didn't see anything. Maybe we missed it.

Thank you in advance for any responses.

Hi John,

I don't know what you're doing now, but this might work. It will require setting up an adjustment view in Gridview first. Create an adjustment in one database, post it, and after printing the adjustment but before clearing the audit list, switch to the adjustment view in Gridview and refresh it. This will give you all the adjustments you have just done. Switch back to Inventory, say yes to clearing the audit list, and close this database. Back to Gridview; export the view to excel, reverse the signs, assign proper GL accounts, and then import it into the other database.

John:

Your explanation of the process is not very clear. Is Company A buying all of the inventory for both companies and then transferring (selling I would assume as there has to be an accounting transaction) inventory to Company B? Company A needs to create receivable and Company B needs to create a payable.

Is this process directly linked (every time Company A buys inventory some is transferred to Company B or does the transfers occur randomly?

I have created similar solutions for my clients and may be able to help you out. Feel free to contact me directly if you would like to discuss this further.