I have a question.

I am inserting some items into tiitm001 through SQL developer. The itm001 data has been modified at the SQL level to set my new warehouse values, suppliers and zero out any inventory counts in tiitm001.

It appears through testing of a manual entry that when I write one record from scratch, an entry is made in tdinv001..

Regarding tdinv001, is this needed ? Can the values for this table be written with an inventory adjustment or something as needed ?

I am just concerned if I need to populate inv001 or can that be done later on ? Copying inv001 table values from the source comapny gets a little messy because some items are duplicates and would be a pain to try and sort them all out :) ..

Are you inserting into or modifying existing items in the itm001 table? The tdinv001 table holds warehouse wise details of an item. While inserting new items into itm001 table, i dont think you need to populate the tdinv001 table, from what i know and done...

sk

Thanks for the reply. I am inserting new items from an existing company to a new company that has just started selling this product. I don't like using the exchange scheme much so I have created a number of queries to change and import ti itm001 as needed as opposed to exchange schemes ....

Thanks for the info on the inventory table ...

Hi,
You mentioned that you were inserting items from an existing company to the current company in question. Does this mean that the item you are inserting has a history? Does it have on hand, on order and so on order related data? If it does, then you surely have to insert the same into the tdinv001 table, i.e if you want to use the same data in the current company..

It would be helpful if you tell us what is the goal of doing all this? Are you trying to create another company with the base data of your old company..

sk

I don't think tdinv001 needs to be filled. It will fill itself upon the first (planned) transaction.

However you need to fill tiitm100 for each record that you insert in tiitm001!!

If one is transferring the item codes with the stock then you would have to fill inv001 along with the itm001, itm004(if multi units for this item exist) and itm100. If on the other hand, just the item codes are being copied to the other company, then itm001, itm004(above condition) and itm100 are the only tables that needs to be filled.

sk