Need new lineitem file

[SBTBILL]

I need to recreate the line item file after a conversion from Clasic.

What I'd like to do is either delete all the inventory items or better yet just replace the file and do an import from data that I've set up. Have seen some posts about this and think I've even done it before but can not get it to work. Always get a file is read only message when I drag and drop a new lineitem file in from a dummy company that I set up to have a blank inventory.

Any suggestions?

Bill Couture

[dringstrom]

If you're converting from Peachtree for DOS, one way around this is to edit the import files created by the conversion utility. Starting with version 8.02 and later, you can now longer swap data files around between companies. If you're using an earlier version, you can get away with making behind the scenes changes.

In any case, just clear out the section of the import files from the conversion utility that deal with inventory, then you should end up where you'd like to be.

[SBTBILL]

Sounds like Peachtree has made things worse.

Bill Couture

[dringstrom]

I agree...unfortunately keeping some folks from shooting themselves in the foot also eliminates opportunities for those that know how to handle the weaponry.

[TheWolf]

Depends on what you mean by worse. If you mean that you can no longer copy dat files from one company to another then I consider that an improvement. Too many of my clients felt they could replace just a specific file and go on from there, when in fact they would cause themselves even more problems.

[SBTBILL]

No mater what the package is an end user shouldn't be working in the backdoor in most cases. However, it certainly, a limitation that the files aren't editable. In this case the underlying issue is that Clasic handled assemblies with more then 100 items. Complete only handles 100 items. So I needed to export the inventory and create sub-assembly items which I can then place in the inventories. Then I replaced the orginal assemblies with the new information.

I think I have a work around that will let me do it. I am changing the ID on the orginal assemblies in hopes I will be able to import the new inventory items. Since all the goes into the subitems is the item number and quantity that is relatively easy to do with a DO WHILE loop in Visual FoxPro. Biggest problem is that Peachtree sends the CSV file in a way that is comma sensative. Hard to believe but even their documentation admits it.

Now if the import works then I can move forward and get the data in as well as writing a report.

Bill Couture