Exporting stock levels to EXCEL possible?

[NickD]

Hi

I'm looking for a quick and easy way of exporting stock levels to an EXCEL spreadsheet, primarily for accounting/stocktaking purposes. I don't mind if it goes via a CSV file or some other format that EXCEL can import from. I'm using Catalog 6.1.3.0.0.0.0.DHBA. I don't want to get involved in understanding how to use the Access database as I would be a complete Access novice and don't particularly want to have to learn it just for this.

It seems quite possible to print the stock levels but I've not found a way of exporting them. Ho hum.

Any ideas anyone??

Regards

Nick

[Kiran]

Hi Nick,

You can create a csv file that contains all the information you require. From Actinic export a file using File | Export, a wizard opens up that will help you create a .csv file. Save the file on your desktop. When you open the saved file and scroll to the right, under the column "Section Extended Info Width" you should find how much stock you have left.

You can also make changes to the data here, save the file and import it back into Actinic.

Hope this helps

[Jan]

From excel you can use the get external data option to link straight though to the actinic table. This option is on the data menu. Select new database query. Choose the datasource of ActinicCatalog6 The table to select is products and the fields you will need are

Product reference,
Short description
nStockOnHand

You might also want to set criteria for the fields below :

Status <> 'D' ... product is not marked for purge
bStockEnabled = true

to exclude products that are deleted and also products that do not have stock monitoring enabled.

When you have done this, just close the query window and the data will be copied into the spreadsheet. You can then use the refresh data option on the data menu to keep it up to date.

Regards,

[NickD]

Thanks Jan & Kiran

I'll try that & report back.

Regards

Nick