• How can I export a report as a live Excel file or .csv?

    I want to take different reports and export them as live updating .csv file or other Excel compatible format. For example, there is a report at IC > Reports > On Hand Detail Report. I would like to be able to save a copy of the file locally to open with…
  • No currency format in Maintain O/E forms

    Under the Order Entry Module I was redesigning a sales order to use for a commercial invoice. After creating a db calculation it would only display the number with no decimal places unless there happened to be cents in the calculated answer. I wanted…
  • Ar Statements - display of items

    AR Statements - Forms modification question. Is there a way to only show AMOUNT DUE items (invoices, credits,deposits with an amount due) on a statement? The current form includes invoices already paid and a separate line for payments to the account …
  • Need Report/Export for Open AP Invoices by Account

    The AP Open Invoice report does not provide GL detail. The AP Invoice G/L Distribution Report does not given an option to run for only Open invoices. I have played around with Exports in both AP and GL but don't see where I can get this data. …
  • Do custom worksheets export to a Excel 2010/2013 worksheet? I cannot get it to work.

    I have Order Entry custom worksheets. Stand alone, I am unable to set them up to port the data to an XLSM (Excel 2010) workbook and sheet. In fact, the top of the BW Edit template workbook browse says *.XLS . So, I just want to confirm you cannot use…