Price Lists to Excel
  • Bob Graham
    Price Lists to Excel

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

    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.
  • COBS Tech Support
    Posts:683
    Joined:Fri Sep 09, 2005 8:23 am

    by COBS Tech Support » Fri Feb 17, 2006 6:51 pm

    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.

Who is online

Users browsing this forum: No registered users and 4 guests