Browse By Tags

  • report error "invalid object name mscfld

    I am running a report and get report error "invalid object name mscfld. I have changed the report form to the system report, no change, and searched the code for the word invalid, none was there.
  • How do I enter the client's retainer and then generate an invoice/bill that shows the work that was done and how much of the client's retainer is remaining?

    So my attorney charges her clients a retainer fee based on the type of case she is handling (so each client can have a completely difference retainer amount), and on top of that, she is billing AGAINST the retainer. We were generating bills in Word format…
  • Open Items Report for BP

    Hi, I want to run a report for a specific BP/Customer and I would like this report to show a complete list of all transactions for the customers - open and closed, invoices, CMs, DMs. I want to see 2 columns, one showing original amount and one column…
  • Blended Billing-Flat Rate Task & Hourly Billing Task

    FormerMember
    FormerMember
    Trying to figure out how to invoice clients who have flat rate task and hourly task on one bill Example file application- flat $1400 report application as filed $18/ hrly can I invoice a flat rate task and an hourly task? Can I invoice a flat rate…
  • Pulling payments for specific time period for specific invoices/clients.

    FormerMember
    FormerMember
    Hello! Thank you in advance! I am attempting to pull payments received from 01/01/19 - 08/31/19 only for invoices dated 01/01/19 - 08/31/19. Any report I try to create ends up pulling in payments that I've recorded during that time frame, regardless…
  • I need a report to show me any AR that was billed but not paid

    I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium …
  • Sales Reports

    Hi, I'm using Sage 50. Could anyone help me on how to run a sales report which can show Item Description from the invoice? Thanks
  • AP Historical Aging

    Does anyone have an AP historical aging report they would be willing to share? Either in report designer or office connector. Thanks in advance, Amanda
  • Item Sales Report Sorting

    I need to find a way to generate a report that shows how many times an inventory item was invoiced over a given period of time, and I need to sort it by the Sales Rep on the WO/Invoice. I am working to make sure stock items shipped to one of our locations…
  • SQL REPORT IN X3

    I am trying to run the following query but its giving me an error. Any suggestion on how it can be fixed.
  • Crystal Report Invoice Report field with No data

    I did the following to the YSBONFAC Report. When I print the report, the report does not break. But it does not out put the lot number either. Any recommendation. The lot number is on the delivery.
  • Free Professional Invoices For Sage X3

    Tired of your current boring Invoice templates and wish you could spruce them up a little bit? Well, now you can. Download these crystal reports and make sure the last impression you leave is a lasting one. Download Now These set of templates have…
  • 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. …
  • Business Insights Reporter Wizard Payroll Hang

    I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…
  • Reports

    Good morning. I have two visas set up in my accounting and made some simple errors that i then fixed (ex: using wrong card for transaction). that has been fixed. But now when i print out my transactions by account report for each card... the wrong vendor…