Browse By Tags

  • Print report from C# program error Unknown error 0x80040200

    Hi All, I have an error when trying to print custom report from my C# program. System.Runtime.InteropServices.COMException (0x80004005): Unknown error 0x80040200 at AccpacCOMSVR.AccpacSvrReportClass.PrintReport(Boolean& pWebReportGenerated, String&…
  • Anyone know how to Insert AR Invoice C# ACCPAC.Advantage

    I can insert a customer, i can insert a Vendor, but when i try to insert an invoice into AR, i get object set to null errors lol no matter what i do. I've been doing permutations of the code in hopes of finding WHY the error happens, i tried their RVSpy…
  • Using Crystal Reports to customize Ardinvo, how do I add database tables and fields from those tables?

    I'm customizing the Ardinvo report in crystal reports. I took a copy of the report, saved it as a different file name. Now I want to add some fields to it that are not in the set of data tables already in the report. In the "Field Explorer" I right…
  • CS0120 data to accpac finder in COM API

    Is that possible to add CS0120 data to accpac finder in COM API, after browse the sql statement. mDBLinkCmpRW.OpenView("CS0120", out csQry); sSQL = "Select Name, Description from MYDB.dbo.Table"; csQry.RecordClear(); csQry.Browse(sSQL, true); …
  • User Defined Fields Data

    We use UDFs on our Invoices to populate fields with both product codes and lot numbers. If those items are already part of the products invoiced, all is good. If we have to manually enter product codes or lot numbers, we have a weird issue. I'll try to…
  • Generate PDF from UDF and create save/email functions from Sales Order/Invoice Data Entry custom tab

    Hello everyone, I created an extra tab in Sales Order/Invoice Data Entry and I have a few questions: Most importantly, how can I use the data that's selected and inputted here to generate a PDF or other type of document? Each of these fields is built…
  • Exceptions with Empty Messages

    Note the is a .NET application written in C#. I have an application that imports orders, purchase orders and inventory items into Sage. The customer supplies a file that contains all of the purchase orders w/items. The file is parsed into purchase orders…
  • How can I develop an add-on for sage 50?

    Hi Expert, Currently, I need to customize my sage 50 software, something like add user defined field to sales order and sales invoice, create a customize form that I can define this page display and fields and logic. Could anyone show me some lights…
  • Consolidated Bills with ALL invoice numbers appearing on bills??

    I am working with TS 2016. I have a two-part question. 1) When I do a master/sub-client consolidated bill, the sub-client invoice number prints, and reprints, as the master client's invoice number, even though it shows it's own invoice number. For example…
  • Consolidated Bills

    On the invoice view once consolidated to be on one invoice, the project names aren't showing up on the actual invoices when I consolidate them. I only see the master client on every page and there isn't a way to differentiate the different clients/projects…
  • Validation rule on a custom field

    Hi all, I would like to know what is the best way (step by step) to create a rules/automation on a custom field. I have a field on SIH0 screen, It is a type A field: 1 - When creating the register, the system populates the field with a sequential…
  • Two different tabs using the table screen type.

    Good day everyone, I am going to be grateful if I get a reply to one of my challenges. I am trying to create two tabs with the table screen type. I am successfully making on the tab save data to the database but the other tab cant save data into the database…
  • Make A New Field

    How can I make a new field on the invoice? When an invoice is created I want to use this new field with drop down options that the team can use to tag invoices. So when reporting is done they can filter for a specific report.
  • SDK Getting Started

    I am a senior developer who is VERY new to Sage. I haven't ever used it or even seen it. A client wants me to use the SDK to get some very basic invoice and payment information out of Sage 50, but even the "Getting Started" info around here seems a little…