Purchase Order to Transfer Inventroy Out Order

Posted by Cribstoteens on June 1, 2009, 10:47 am

Please log in for more thread options

Is there a way to get all the items from a PO and make a Transfer Inventory
Out Order with those same items? If not, how would I go about creating my own
customization to do this? I know how to query tables and such in SO
Administrator, but I don't know how to make that into software to copy the
information from the PO to a new TO. And would it be safe to modify the
database in this way, creating a new TO with items? I would obviously create
a test environment for this. I know that from a PO# I can query the
PurchaseOrder table to get the ID. I would then query the PurchaseOrderEntry
table, filtering out all data without that ID, and use that data to create a
new TO with that data. Would this work?

Posted by Cribstoteens on June 1, 2009, 1:39 pm

Please log in for more thread options

I couldn't seem to find out any way to integrate these queries into RMS
itself, so I'm just going to write software in C# that accesses the database
and creates the new TO. I still would like to know if this is safe to do with
standalone software. Thanks.

"Cribstoteens" wrote:

> Is there a way to get all the items from a PO and make a Transfer Inventory

> Out Order with those same items? If not, how would I go about creating my own

> customization to do this? I know how to query tables and such in SO

> Administrator, but I don't know how to make that into software to copy the

> information from the PO to a new TO. And would it be safe to modify the

> database in this way, creating a new TO with items? I would obviously create

> a test environment for this. I know that from a PO# I can query the

> PurchaseOrder table to get the ID. I would then query the PurchaseOrderEntry

> table, filtering out all data without that ID, and use that data to create a

> new TO with that data. Would this work?

Posted by Cribstoteens on June 8, 2009, 11:56 am

Please log in for more thread options

I've managed to finish this software, and it works quite well. It has the
ability to copy purchase orders and change the copied purchase order into a
transfer out order. This worked for the business I work at because all the
items are shipped to one location before they are shipped to the others. If
anyone is interested a copy of this software, feel free to email me at
c.lukasoft@gmail.com

"Cribstoteens" wrote:

> I couldn't seem to find out any way to integrate these queries into RMS

> itself, so I'm just going to write software in C# that accesses the database

> and creates the new TO. I still would like to know if this is safe to do with

> standalone software. Thanks.

> "Cribstoteens" wrote:

> > Is there a way to get all the items from a PO and make a Transfer Inventory

> > Out Order with those same items? If not, how would I go about creating my

own

> > customization to do this? I know how to query tables and such in SO

> > Administrator, but I don't know how to make that into software to copy the

> > information from the PO to a new TO. And would it be safe to modify the

> > database in this way, creating a new TO with items? I would obviously create

> > a test environment for this. I know that from a PO# I can query the

> > PurchaseOrder table to get the ID. I would then query the PurchaseOrderEntry

> > table, filtering out all data without that ID, and use that data to create a

> > new TO with that data. Would this work?

Posted by Lance on June 8, 2009, 2:23 pm

Please log in for more thread options

To do that I use PowerOps from Digital Retail Solutions. Then I alter
the POType field in the database table PurchaseOrder from 0 to 3.
That's all it takes to convert a PO to a transfer out.

On Jun 1, 7:47=A0am, Cribstoteens

> Is there a way to get all the items from a PO and make a Transfer Invento=

> Out Order with those same items? If not, how would I go about creating my=

own

> customization to do this? I know how to query tables and such in SO

> Administrator, but I don't know how to make that into software to copy th=

> information from the PO to a new TO. And would it be safe to modify the

> database in this way, creating a new TO with items? I would obviously cre=

ate

> a test environment for this. I know that from a PO# I can query the

> PurchaseOrder table to get the ID. I would then query the PurchaseOrderEn=

try

> table, filtering out all data without that ID, and use that data to creat=

e a

> new TO with that data. Would this work?