hello,
it is possible to enter 150-200 different item #’s into an excel spreadsheet and then import that to ACCPAC? instead of creating an item one by one in the inventory item?
thanks
eb
Yes. Do an export, there's your template.
question.
1. when you'll create the items on excell. do you need to make them like this 0000-00000000-00-00 meaning, with the format from accpac.
2. when you'll export, what do you choose from excel as an export?
thanks
1. No
2. Doesn't matter unless you have more than 65,556 items, then xlsx.
Ok but the part that i don't understand is how by exporting in excel, you'll bring the information to accpacc
You edit the spreadsheet, then import.
I hope this helps, The detail steps are:
1. In Sage 300 desktop,open Iventroy control, Items ui and try to enter a item number so you can save it correctly.
2. In the same Items ui, you can click on File, export to export to Excel 2007 and give it a file name.
3. Modify the excel file, you only need to concentriate on the item that you just saved in step 1, create the new items in each workbook in the Excel file similar to the first item you created.
4. Now back to items ui, select File, import with your updated Excel file and follow the process.
5. If you use Web screen, then the Export/import function is in Options icon in the top right corner of IC items screen.
Good morning,
I tried the steps which seem to work good. however, when i create a dummy item number on inventory control and export just like you told me, it is exporting ALL my items that i currently have on inventory control.
i thought it was only going to be the one that i just created.
Also, i think i didn't explain myself to clearly in the beginning.
We have about 200 new items that we need to enter on AccPacc and we want to put them on a spreadsheet first and then export them to the inventory control.
please help. thanks
eblim
Set a Filter before you press export.
thanks.
but the question still remain unaswared.
if i have items that i have not entered on accpacc but i want them to be in there. why am i doing this first. perhaps to have the format in excell in that way i can just enter the new items and then export them on accpac?
Yes, now you have a template. Add your items to that sheet, then import.
thank you. let me try.
let you know how it went.
thanks
eblim
Did the whole thing in excel. i went back to inventory and import and got an error saying
"TYPE MISMATCH PURCHTAXCL file should be an integer"
what am i doing wrong?
thanks
Delete the PURCHTAXCL column, or put integers in it.
sorry to bother you but now i get the following:
swset should be an integer. this is what i have on the excel tax tab
ITEMNO | AUTHORITY | SALESTAXCL | PURCHDESC | PURCHASETAXCL | SALESDESC | TXAUTHDESC |
2610057520BOSCH | STATE | 1 | Non-Taxable | 1 | Non-Taxable | State Sales Tax |
That's on the Item_Optional_Fields tab. Delete all rows on that tab except the 1st one.
i did and this is what i got. i don't know if you can see it but it says
"Type mismatch SWSET field should be integer. what am i doing wrong?
thanks
I'm sorry, I can't help you any more, I have work to do.
thanks
That field is an integer, default is 1, not 1.00 so you will need to modify your Excel file. Like I have suggested, create one item and export, that one item will be your default template so you can enter the same in every sheet of Excel file.
i already fixed the issue. but thanks for your e-mail and for all your help before.
regards,
*Community Hub is the new name for Sage City