• How do you change the default check stub format in Accounts Payable?

    How do you change the default check stub format in Accounts Payable? I am using BusinessWorks 2018.
  • Calculation Field in Custom Reports

    Businessworks 2017 SP2 I want to calculate job margin on a custom report using JCjobs fields as follows: ((Billings-ActualCost)/Billings)*100 Is a calculation like the above possible in the report? Any help would be greatly appreciated!
  • Sales Analysis Report Includes Incorrect Information?

    When running a sales analysis report by sales rep it is showing the invoice total even when there is a Line Item on the invoice that does not post to sales for the company as a whole. We are a printing company and Postage is a pass through expense so…
  • Inserting a JPEG Company Logo/Address at the top of electronically generated BW Invoices.

    Looking for advice from anyone who has successfully inserted a JPEG "company logo" at the top left of electronically generated PDF BusinessWorks Invoices. I've been living with a Black and White logo of a certain resolution but it looks poor. My attempts…
  • Is there a way to format quantities on invoices to include commas?

    I have been able to edit the BWUser.ini to add commas and dollar signs to all money related numbers on the invoice form but have been unable to find a way to get commas to print in the quantity field. Does anybody know how to do this, if it is even possible…
  • Multiple Sales Rep's and commissions in AR

    FormerMember
    FormerMember
    Does Businessworks have the capability to have more than one sales representative on an invoice and also have more than one commission line (percentage) that will calculate? Can someone advise on this please
  • Canned Reports

    I am really new to the BusinessWorks system and I need to know a few things. There is an aging report under Accounts Payable, I need to know if that can be edited. I have tried to recreate it manually so that I can add information to it, no such luck…
  • Changing number format on the AR Statements

    Is there a way to change the number format on the Accounts Receivable Statements? For instance, the total amount on the statement is 35697.16. How can I change it to have a comma to read as 35,697.16? I don't care if it doesn't have a dollar sign.
  • How do I "open" the PUCHASE ORDER field for use when printing a quote

    Many state and county customers are now requiring our entry of the their "quote order identification" to appear in the purchase order field of quotes we submit to those customers. The PO field is grayed out. How do I activate that field for use when preparing…
  • Voided Payments Report

    I am trying to create a custom AR report with just the voided payments in a given time frame. I don't know how to capture just the voided payments. I tried entering different numbers into the payments status filter field but that didn't get me what I…
  • Custom Exports - Open orders for a specific customer

    I am trying to create a custom export for a specific customer who needs a backorder report sent weekly. All it exports to excel though is a future order (one that we need to ship in about a month). They do have some open orders that were partially filled…
  • DBPipeline Memo fields - Form Design

    What are these fields? I have one on my check form (Check: Remarks (above name) Block) but I cannot figure what purpose it serves.
  • Open Sales Order Reports

    Is there a way to add a comment line to the open sales order report? Perhaps under customized reports.
  • duplicate lines, crystal 10 bw version 2015

    I am trying to link the following tables and I am getting duplicate records so I am thinking that my links are wrong. Can any tell me what field to link to what table and what type of join? the tables are arinvoice, arcustomer, icpart, icpartserialno…
  • Link JCJob database field for selection in Report Builder

    Is it possible to link fields, specifically Job ID (on time card entry) or make available for choosing, from JCJob database when customizing the Check Register Detailed Report in Payroll? A report has already been created and customized under a different…