Distribution, Manufacturing, and Internet Modules

[Kerry]

We are in the process of rearranging our inventory in the different warehouses and need to change the warehouse on the existing Sales Order Line Detail to match the Item Master's default warehouse.  I created a Visual Integrator job that will export the Sales Order #, Item #, and the Sales Order History Detail line number (I couldn't find Order Line Number in the Sales Order Detail fields of Visual Integrator).  I then created an Import job in Visual Integrator to use this file to import into Sales Order Line Detail.  My thoughts were that it would find exisiting records of Sales Order #, Item Number, and Sales Order History Detail line number and update them.  What it did instead was add more line detail records with the new warehouse.

Any suggestions on what I did wrong or how I can update the warehouse in the existing Sales Order Line detail record?

Thanks,
kerry

[connex]

That is the way that V/I works for SO detail.  Perhaps you could re-import them with a mofified sales order number that is a derivative of the original then delete the original.

[csaintaz · Accepted solution]

Kerry,

Version 4.4 is supposed to allow update of existing line records in SO Entry.  I wouldn't use the SO History Files to get your key fields.  They involve links to AR History and do not necessarily match up as you might expect with the Key in SO Entry Detail. 

If you are not 4.4, the other response to your post applies to all prior versions. 

In 4.4, you should be able to read the Line Key from an SO detail, along with the SO Number.  The line key is a 6 character, zero filled (from left), numeric field.  Those two fields make up the Primary Key of the detail file, and would be the minimum you would need. 

You can export the SO, Line Key, Warehouse code etc. using VI.  We typically link to the tables from Access using a linked table or a pass -through query to see what the records look like in MAS.

You should be importing to the SO_SalesOrderHeader.  The "SalesOrderNo" and "LineKey" fields are both available in the Data tab of the import Job Maintenance. 

Hope this helps

[BigLouie]

You did not do anything wrong. VI is working as designed. Since day 1 VI has not been able to address existing lines in data entry files, only add now ones. With VN and the BOI you can address exisitng lines if you know the key.

[Kerry]

Thanks all for your help.  This is the first time I tried to change anything in a Data Entry file since 3.71 .Prior to version 4, I would just write a providex program to do it.  Since we do not plan to upgrade from our current version (4.3)  until the release of 4.5 for various reasons, it looks like we'll just have to suffer with the limitation until all the current open orders are shipped which is several months.