Integration Manager - Inventory transaction integration quantities

[number1rookie]

I guess I have two questions.

The first is:

I have successfully integrated all of my inventory items into GP, but all the quantities are 0. Is there a way to bring in these items with their quantites established?

The second is:

Since I havent found out how to do the above mentioned. I made a seperate integration that does an inventory tranaction, and once posted, it adds the quantites to my inventory. My only problem is that when I view an item from the Item Master List, the quantites do not show up. They still say 0. However, when I double click any item to view its detail, the Quantity On Hand and Quantity Available are correct. Can someone please help me with these issues? Many Thanks ahead of time.

 

[btamulis]

I would recommend running Great Plains Inventory Reconcile.
Tools >> Utilities >> Reconcile

Run it for the complete range of items.

Did you import inventory transaction into a batch and then post the batch - I think that's the recommended process according to MBS.

Good Luck

 

[number1rookie]

Thank you very much for the reply.

I ran the Reconcile to no avail. To answer your question, yes, I did import the inventory transaction into a batch and then post the batch.

Theres two things I forgot to mention.

When I add a new item manually, I do not have this problem. If I do a quantity adjustment the change shows up in both the Item Master List and Item Detail Screen. I'm only having this problem with the items added via Integration Manager.

I'm on GP 8.0. Thank you again.

 

[number1rookie]

Does anyone else have any possible solutions? Any help is much appreciated.

 

[jazgeek]

question: how did you integrate this inventory transaction? Did you do it via integration manager or did you do it through a table import?


-----------
and they wonder why they call it Great Pains!

jaz

 

[number1rookie]

I did it via Integration Manager.

 

[jazgeek]

please be more specific where you are seeing the 0 quantity and details as well.

when you did a inventory reconcile, did you check box the transaction history button as well?

-----------
and they wonder why they call it Great Pains!

jaz

 

[btamulis]

number1rookie -
The IV00102 table stores on hand quantities. The on hand value seen on the item maintenance screen reads from the IV00102 table. If what you say is true - your IV00102 table is out of whack.
The IV00102 table has one record for each site the item is assigned to and one record for the the 'sum' of the sites. Here's an example -
Item Number 100XLG is assigned to two sites - Warehouse (10 on hand) and North (56 on hand). There will be 3 records in the IV00102 table:

100XLG (no location code) 66 on hand
100XLG (NORTH) 56 on hand
100XLG (WAREHOUSE) 10 on hand

In your case the '(no location code) record is blank - leading us to believe you did a direct table import and not a batch integration. Also - the Inventory Reconcile procedure is designed to correct data base inconsistencies as stated above - so I'm surprised problem persists.

You could try - Checklinks - this is a more comprehensive database maintenance routine - it should be done with no other users in system.

File >> Maintenance >> Checklinks >> Inventory Series >> select all files

Good Luck,

BT

 

[number1rookie]

Thank you so much for all of your help. It turned out to be a Site thing. On the Integration that was made it required a Default Site, and it was using source DefaultSite. I changed that to Use Input and used the name of the one site that I have set up (we only have one site), and then changed all the items to ran a query to change all the itmes to Discontinued, ran a year-end and checked the remove discontinued items box. Then I re-integrated the items with the slight change in the integration, and then ran the Item transaction integration batch, posted it, and it all worked out.

Thanks to everyone who helped. You guys are great.