Browse By Tags

  • Custom Invoice templates

    FormerMember
    FormerMember
    Hi, Is it possible to upload custom made templates? Thanks
  • How to change layout description

    I have created a new invoice layout in Sage 50 based on a previous layout then saved with a new file name, but I can't find how to change the file description - is there a way of doing this?
  • Invoices

    FormerMember
    FormerMember
    I have just moved from Sage Instant Accounts to Sage cloud Accounting. The invoice templates hardly seem to be customisable at all now and also I am having problems with the company logo - whatever I try I cannot get this to appear sharply. For this latter…
  • Inserting data tokens into email templates

    FormerMember
    FormerMember
    I want clients to see this in the email they receive when sent an invoice: Past Due Balance: Total Balance Due: (which includes past due and New charges) Client Funds Balance: (retainer) I am accomplishing this by inserting data tokens into…
  • TableExceptionC in Slip Templates and SQL error code = -303

    Seem to get his error a lot when working within Slip Templates, trying to delete them etc. When we try to convert the database with these slip templates: Converting Slip Template table Slip Template Records 3..4271 ---------------------------…
  • Multiple invoice templates like Xero?

    Hi, I have a Sage 50 customer who we're looking to moving over to Sage Business Cloud Accounting. They invoice in multi-currencies which isn't a problem as SBC Accounting can handle this out of the box. The issue is that they have a different invoice…
  • Importing customer / loan returns template

    Hi, I have a need to import customer returns into X3 ( both normal and loan returns). How is this done as the template I built only imports the header record and not the edtail record, despite detail records info being specified during the import (…
  • Sage100 - Copy Custom AP Check Form to all company codes.

    I was trying to use Report Manager to copy the form from the company code that I created it in to all companies. It shows in the Report Manager and after I create the form code in the other company it is using the standard form. I have 250 companies that…
  • URL link for tracking a package

    I'm trying to set my scripts to be able to search the tracking number when they click the hyperlink, but for some reason I don't get the value I get the name of the UDF, but not what I put in there. Anyone has idea how to do it? please help ' Create…
  • Cannot change script language from VBScript to JScript

    I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…
  • 8. Training

    See an overview of the Sage 50c and Microsoft 365 integration: Sage 50c and Microsoft 365 integration Need more training on Sage 50c and the Microsoft 365 features? Attend the following training: 50CA - Sage 50—Canadian Edition - Sage 50 to…
  • How do I generate a report that shows Attorney, Amounts Billed for a certain period and Invoice Status amount at the same time?

    Does anyone know how to generate a report that shows Attorney, Amounts Billed for a certain period (A/R Transaction Date), and Invoice Status (Paid/Partially Paid) amount at the same time? I cannot find/create a report with these three items. Please advise…
  • Workstation "locked" while SI reports run

    A client has 84 companies in their Sage 100 Standard system, which was recently upgraded from v4.50 to v2016. The upgrade was installed on a new Server 2012 and workstations are new Windows 10 units, all exceeding current SPM specs. In Sage Intelligence…
  • Report/Log for Fiscal Calendar maintenance

    Is there a report or log that shows Fiscal Calendar changes? We are in period 10 of 12 for 2016, and somehow period 8 START date was inadvertently changed from 01/06/216 to 06/01/2016. The start date is not even an editable field. No other dates were…
  • Reading the XML file using RDSEQ

    Hi there, I am reading the XML file by using RDSEQ, but the problem here is its not reading line by line, instead its reading no. line at time. Please advise !
  • Cost of Goods Report

    I am running a COGS report for the week ending 4/15/16; however, not all of my invoices are coming up. I verified that one particular invoice in question was correctly posted in that time period, and the items are allocated to the correct GL accounts…
  • po receipt of goods paging

    Is there a way to create a page break in the po receipt of goods journal when it prints- after receiving against purchase orders (Receipt of Goods Entry). We need for the journal to print only one purchase order to print per page. I am NOT speaking of…
  • Wildcard in the first section of GL code

    Dear Friend, My company are using a several-section numbering for GL code and i would like to know how to wildcard the first part of GL code? For example, GL code, 100-02-03,101-02-04,102-02-05, 102-03-01 etc. if i like to use wildcard in the first…
  • Re: Remove 0 in the report

    Hello All, My Financial Report that exported from system by using template include a lot of 0, the cells without any number. The template is wrote by myself. I was wondering if somebody can advise how to remove 0 and just show clean cell? I mean how…
  • in $000

    Hello Guys, i am designing a highlight report and need to use (in $000), anybody know how to create it ? Thanks in Advance, Frank
  • unable to export to excel

    Hi, I have ERP 2012 SP and I cannot export to Excel.When I do so I have this error message" Method not found: CrystalDecision.ReportAppServer.DataDefModel.Propertyflag..." Repaired Sage, Renamed BusinessObject folder and SAp folder and it was not…
  • Crystal - template expert

    Template expert is grayed out. How can it be accessed to apply/change a template?
  • 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…
  • Sage 300 2014 Intelligence Report getting an sa login failure

    Sage 300 2014 Intelligence Report getting an sa login failure when attempting to run a report with terminal server. Any ideas? Everything else appears to be working.
  • Not a valid Crystal Report

    After upgrading to Version 14.1, some of our systems will not print Crystal Reports. When attempting to print we get the following error message. We have attempted to perform the suggested Resolution on KB 55371 with no results. Anyone have any ideas…