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…
  • Creating a Time UDF with Default Value

    Sage has built-in support for storing dates in a UDF by simply changing the "Data Type" to "Date". Then under default value, "<SystemDate>" to allow the date to be immediately filled upon new record creation. Did they forget that dates are usually paired…
  • DFDM Modifications to Allow UDT Field Lookups

    When viewing a multi-line field within DFDM I noticed that one of the UDF fields within the current table (AR_Customer) had a Nomads Tag that suggested I may be able to possibly manipulate a different multiline field to perform a lookup within a UDT.…
  • 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); …
  • 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…
  • UDT not showing in user-defined field and table maintenance

    I've got a UDT that isn't displaying in the list under user-defined field and table maintenance. It used to display but has since disappeared. I wonder if anyone knows some tricks to refresh the menu system? The table I'm looking for is called SY So…
  • Filter the look of UDT

    Hello all, I have a button script on repetitive invoice header which will pulls out a UDT. But what I want to do is not just pulls out the UDT, (cause it will show all the datas) but also filter the UDT values that shows only for this particular customer…