|
Inventory adjustments |
Post Reply 
|
| Author |
 Share Topic Printable Version Google Delicious Digg StumbleUpon Windows Live Yahoo Bookmarks reddit Facebook MySpace Newsvine Furl Topic Search  Topic Options
|
administrator 
Admin Group 
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
 Post Options
 Quote Reply
 Topic: Inventory adjustmentsPosted: 30 July 2010 at 7:31am |
|
The exporter is $125 and you can request a demo from this link: http://baystateconsulting.com/products/01TxnExportDemo.asp#demo
|
|
 |
|
|
JerryG
Newbie 
Joined: 29 July 2010 Online Status: Offline Posts: 5 |
Post Options
Quote Reply
Posted: 29 July 2010 at 5:11pm |
|
I used the Utilities/Export function from QB.
How much is your exporter?
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 29 July 2010 at 4:56pm |
|
An easier way to do this is to use our exporter product to pull the item list. Unlike the QB report we pull the full item name with subitems. That way it's properly formatted for use with TPI. Another advantage is you don't need to remove pages headers/footers and other invalid file data. If you don't want to have to purchase the exporter then you need to look over the file you sent and see if any of those items are sub items. If they are it's going to be very hard for you to correct your file. Just how did you produce your export file? Which report did you run? We can see if it is including the parent or just the sub items. |
|
|
|
|
JerryG
Newbie
Joined: 29 July 2010 Online Status: Offline Posts: 5 |
Post Options
Quote Reply
Posted: 29 July 2010 at 4:25pm |
|
It's possible. Short of going thru all the items I don't know how to determine that. Is there any way to identify the records that are rejected?
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 29 July 2010 at 4:05pm |
|
Is it possible these are subitems and QB isn't showing the parent child relationship with the colon separator?
|
|
|
|
|
JerryG
Newbie
Joined: 29 July 2010 Online Status: Offline Posts: 5 |
Post Options
Quote Reply
Posted: 29 July 2010 at 3:16pm |
|
uploads/1594/ZeroQuantUploadTrblShoot.zip
Sorry- took me a while to download zip prog...
|
|
|
|
|
administrator
Admin Group
Joined: 01 October 2003 Online Status: Offline Posts: 1882 |
Post Options
Quote Reply
Posted: 29 July 2010 at 2:17pm |
|
Can you post a small sample of your import file? Click Post reply and then upload it as a zip file. Is it possible these are subitems and QB isn't showing the parent child relationship with the colon separator?
|
|
|
|
|
JerryG
Newbie
Joined: 29 July 2010 Online Status: Offline Posts: 5 |
Post Options
Quote Reply
Posted: 29 July 2010 at 1:50pm |
|
I'm trying to zero out the counts on about 13K inventory items. I exported the item list to Excel, eliminated unnecessary columns, and used the TPI sample inventory adjustment file as a template. When TPI tries to import, it says that some item names don't match QB (remember, they were exported from QB). In addition, I can't match the item names on the TPI error list with the item names in my Excel import file. So I can't get rid of the invalid names, and can't import the file. Any ideas? Also, is there any way to use TPI to inactivate inventory items?
Thanks.
|
|
|
|
|
Post Reply
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
