Browse By Tags

  • Generate a report to get the list of Products without customer through SEI

    Dear All, I am facing some problem to generate a report through sage enterprise intelligence. I want information from the report is 'product without customer' but when i apply criteria/filter to the customer i.e. 'customer code=null', the output…
  • Sage 300 2018 UI Container Error on Print Preview

    Installed sage 2018 Premium with PU2 on a server. migrated a customer from sage accpac v6.0. Data upgraded fine but if i try and print any report to preview the UI container error comes on. Windows Server 2016 with SQL Server 2014.
  • Invoice total and Final balance due on AR invoices don't match

    Hello everyone, I'm hoping someone will be able to help. Our AR invoices have an additional section at the bottom, beneath the Invoice Total, showing payments/credit/discounts applied, with a Final Balance Due. That way, once someone pays the invoice…
  • Silent ODBC on terminal server

    Hi All, I am struggling with this issue. Everything I read says it should work this way but it does not. Client is on Sage 2017 Standard. I created a report that uses a silent connection. It is 64bit and I have set it up as a System DSN. Works fine…
  • Printing attached documents

    So if I was to attach documents to a sales order through Memo's, is there a way to print them when the Bill of Lading is printed?
  • Print Preview not working - Sage 300 2018 PU2

    Upgraded sage accpac 6.0 (200) to sage 300 Advanced 2018. When trying to print preview any default sage reports get error message. Not implemented. Error in File . Operation not yet implemented. Attached image snap . Anyone faced this issue and…
  • Report window exits on clicking Print button

    When clicking the "Print" button on a report options window, the window closes and nothing shows. This is happening with all reports. User is on v2018. This is happening on multiple machines. Appreciate if anyone has seen this before and has a solution…
  • size issue for pre-bill timeslips 2017

    I would like to print individual pages for my timeslips pre-bill. If i choose the "display" option and hit print it uses my video drive settings and doesnt allow me to print "fit to page" or any other change in size. In this option i can pick specific…
  • Print Financial Satements - FrCom Addin

    I have searched the knowledgebase and i have not seen the answer. The Print Financial Statement suddenly stopped working on my workstation. The other workstations are ok. I get this error whenever I click "Print" and when Excel tries to run the report…
  • Scheduled distribution only if it has data

    If I create a scheduled distribution of a worksheet, how can I make it only deliver if it pulls data. So for example I want to use this as essentially a notification for certain invoice types. I have the work sheet built and filtered, and it's scheduled…
  • SEI Budget Analysis reporting

    The budget analysis is only including reporting debit code 1 dimension for actual amounts. How do I include a reporting credit cod 1 dimension into this SEI budget analysis?
  • Crystal Report: Customer Sales History - Multiple Years, Different Periods

    OK, friends! If either of you can solve this for me, you will be my hero for month! Lol I have created a custom report that is sorted by Customer Number. Main tables involved are AR_Customer and AR_CustomerSalesHistory . I need for this ONE report to…
  • Printing lag time

    We updated to BW 2017, SP1 about two weeks ago. Since then, there is a delay from selecting print to spooling the job and then again to printing. Has anyone else had this issue, and/or know of a possible solution? It isn't every time, but quite often…
  • Collate & Duplex Printing

    Hello! When we select "Collate" while printing in any module, the print job is never collated. In addition, when we select "Print on both sides" both "Page 1" are printed on one sheet of paper. Does any one have a solution to this? We're running BW…
  • Old Print Error in 5.6

    Hi ...... when my user tried to print he see's this : KUSHAL ERROR.docx
  • Carré noir dans l'en-tête sur impression de factures

    Bonjour à tous! J'ai un problème avec environ 9/10 de mes impressions de factures: il y a un gros carré noir par dessus l'adresse de mon commerce, en plein centre de l'en-tête de mes factures de vente... (Voir image plus bas) Ce problème ne se produit…
  • Customer statement in sage 300

    When we print a customer statement in the end of every month, those amount on the bottom do not match the total amount, it always missing one day. There is no current amount show. Is there any way we can change "1-30 days" to "0-30 day"? Thanks so much…
  • Custom Crystal Report - Users Logged In

    Is there a specific Sage 100 table to use for a custom Crystal Report, that will show a list of all users currently logged in to the Sage 100 ERP system at any given moment?
  • When printing a posted invoice it's also emailing it to the customer.

    We are just setting up MAS to transmit invoices from the system. However, when I'm trying to print an older posted invoice it prints and it automatically transmits the invoice to the customer contacts. How can I fix it to only transmit when I tell it…
  • Custom Crystal Report is showing multiple transactions for each customer

    Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues... 1. The custom report…
  • Is Sage 300 2016 compatible with Windows 2003 32bit OS at the workstation level?

    I find it cannot print out or preview the built-in standard sage 300 crystal reports with windows 2003 at the c/s workstation level.Everything else is normal. Is it incompatible with windows 2003 and winxp used by sage 300 2016 c/s workstation Level…
  • general ledger error

    I cannot pull up a general ledger report. It gives me an error message saying that an error has occurred. Anybody know how to fix this so I can get that report? Am I going to have to uninstall/ reinstall? Is it in my settings? Please Help!
  • Inserting a running total from a Formula field to OE Invoice report

    To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…
  • Emailing invoices

    Does anyone have step by step instructions on how to set up emailing invoices on version 7.40.20? I was told that I had to use the primary contacts email address. I would prefer to use a secondary email address.
  • Grant Users authority to Report

    Hi, on Sage 5.1 , I created a Crystal Report, and then loaded the report with Report Manager, How do i grant users authority to run this report, probably a very basic question but appreciate any help. right now you can find the report in custom…