Browse By Tags

  • Macro to print/save Open G/L batches at month end

    I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…
  • Difference between the Finance and UDM in SEI?

    I would like to know the difference between UDM and normal Finance process,dashboard and reports?
  • 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 …
  • Formulas to pull out First name & Middle Initial separately

    I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…
  • 'All Journal Entries' report won't load all of a sudden. How to get it to load again?

    My 'All Journal Entries' report won't load all of a sudden. It previously was working perfectly, but now it won't load. I click to have it come up, but all I see when I hover over the Sage icon on the toolbar is the main Sage window and another window…
  • 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…
  • Can the SEI weblinks be opened without a user signing in?

    Can the SEI weblinks be opened without a user signing in? I want to deploy ongoing report through the browser that will automatically tab over to display different reports. The issues is, we have to sign into it every time it reboots.
  • 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…
  • 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…
  • 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.
  • How to remap fields in SEI processes after db field name changes?

    Some fields in our X3 db were renamed. SEI process currently refers to old field names. Is it possible to remap field references in process? I was hoping to be able to update references in the relevant process files in CentralPoint. But this hasn…
  • 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…
  • SEI Sending Two Email To Each Users

    When we are sending out emails to the users via Scheduler. It is sending two email each time to the user. How can we stop it from doing that?
  • SEI v8.0.1.29 - Reports currency symbol formatting

    I am testing the Reports in SEI v8.0.1.29 and formatted a calculation column on a new with the £ currency symbol. The formatting preview shows the symbol in front of the number as £1,234.56 but the report shows the currency sysbol after the number 1…
  • 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…
  • 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?
  • 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…
  • 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…