Page 1 of 1

Price Lists to Excel

Posted: Fri Feb 17, 2006 6:49 pm
by Bob Graham
Help

To keep our clients happy we need to produce a price list from Capital in an Excel format. When using the conventional reports from within Capital, and you select extended description (which we need) the resulting spreadsheet puts the description over more than one cell (for some parts). Investigating further I think that the description is spread over two databases, namely STOCK and STOCKEX. Is there a way of repeatedly producing an Excel sheet from Capital combining these two description fields into one Excel cell? Reason we produce individual price lists for customers depending on their discount structure, and need the complete parts description.

Can this be done by a custom report. Clearly we are happy to pay for this functionality.

Posted: Fri Feb 17, 2006 6:51 pm
by COBS Tech Support
It's possible that you're getting the description split across two or more cells, depending on the design of the report.

Yes you can do it also using a custom report which would be easy to build using the Form Wizard. Although that is not necessary. CAPITAL 7.4 has a new Catalog Wizard for building price lists and catalogs and it is extremely easy to use. It will create Excel spreadsheets or PDF documents for sending to your customers.