Browse By Tags

  • Vendor Reporting YTD LY Results

    How can we do a report to show how much money we spend with each vendor for last year?
  • Table Mapping

    What is the link between the OESalesOrder table and OELineItem. I'm pulling the data via ODBC and trying to identify the key between the two tables. Any insight or documentation you can direct me towards would be greatly appreciated! (BW 2019)
  • 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…
  • Negative quantities posting to I/C

    We are currently building a pump, the way we process the job is to charge everything and then at the end we post a negative quantity of the completed pump to balance the numbers. Unfortunately, now that I need to close jobs for the end of January next…
  • Part issues report by custom date

    FormerMember
    FormerMember
    Hi, Can anyone help and tell me if there is a report that will tell me how many issues I have for a particular part over a specific time range? Not MTD or YTD and not a dollar total. I need to know how many peices I sold. Thanks
  • Employee List Reports

    I am customizing the Employee 401K List Report (it has been renamed but no fields have been deleted, just made invisible) and I am having trouble with adding a database field for selection. I get the message "The SQL statement that you have provided is…
  • Employee Hours List Report

    I am having problems printing a good copy of the Employee Hours List Report in BW2013. I am up-to-date with service pack 8 installed. No other printing issues, just this report. It will print after a lengthy amount of time but, it cuts off several columns…
  • Issued AR Invoices Emailed or Printed and mailed?

    Is there a report that will show if an AR invoice was emailed and to what email address? Thanks
  • G/L Flash Report not showing cash balance from new cash account

    We recently changed banks and so we reset the defaults to the new account which now appears as account #1 in CM/Maintain cash accounts. The problem is that the G/L Flash report is still showing the $0.00 balance apparently from the account we no longer…