Browse By Tags

  • Import Unit Cost for Inventory Adjustments with the COM API

    I'm trying to import the Unit Cost field among others for Inventory adjustments via the COM Interface. For some reason this one field likes to remain at 0.00 even when making a positive adjustment with a value greater than 0.00. Here is an example of…
  • Address Validation with Avalara

    Hello, We have encountered an issue when validating addresses where the FOB and ship method are automatically changed after validation is complete. Is there a way to prevent the FOB & Ship Method from being restored to default? Thank you for your…
  • UK VAT reporting for Europe

    Client in Canada has an entity that resides in the UK. They received a letter saying that they are 'required' to use MTD (Making Tax Digital) software to file their VAT returns. It seems that Sage 300 Cloud is not on their supported software list. Has…
  • 'Non-zero amount must be rounded to whole currency' Sage 50 SDK

    When trying to save a sales order using the Sage 50 SDK, I get the error: ``` 'Non-zero amount must be rounded to whole currency'...``` I've been able to save them using something like `_.Amount = _.CalculateAmount(_.Quantity, _.UnitPrice);` which…
  • Does Windows Service Connecting to Sage 50 US Via SDK Count As A User

    Our client has a five user license installation. We noticed that our windows service shows up as a user in login manager. Does this mean that a we need a new license for the windows service connecting to Sage 50 via the SDK?
  • Could not load file or assembly Sage.Peachtree.Domain

    Hi I have written a windows service that speaks to Sage 50. It runs on three computers. On only one computer, I see this in the logs: 2020-07-09 11:01:27.277 -04:00 [DBG] Could not load file or assembly 'Sage.Peachtree.Domain, Version=2020.2.0.219…
  • SDK 2020.1 not working after Sage 50 2020.2 update

    Hi, Our job control system exports invoices to Sage 50 (Canadian Edition) using the latest version of the SDK 2020.1. We had to update Sage 50 to version 2020.2. which includes the up-to-date tax tables. According to Sage Support, there won't be an…
  • Hubspot

    Is anyone out there utilizing HubSpot? And if so, are you transferring data both to and from Sage 100? Or just transferring data from HubSpot to Sage? Any problems with the integration?
  • Do I Need A New Application ID For Each Installation?

    We have a developer license and application ID which we have used to create a connector that pulls data from an ERP into Sage 50. It runs as a windows service. It has worked well on all our development boxes. Yesterday, we tried to install the windows…
  • Payables Workflow with PJC Retainage Integration

    Does anyone knows of a web-based Payables Workflow that is able to process and approve job-related PJC invoices with retainage? Both Pacific Technologies and Norming's solutions do not handle PJC retainage. Thanks.
  • Sage 300 + CDATA JDBC Driver for sage 300 + Talend Data integration

    Hello , I'm new with sage 300 and i need to connect my Talend data integration with sage to extract data. To this i installed sage 300 on my machine i created a simple company to do the test , then installed CData JDBS Driver for sage 300 ... …
  • Querying and Creating New GRNs

    I'm working on an application that takes in a structured .csv file and can't find any information on how to query and create new Goods Received Notes. I know that parts of them are stored in the titrec and tjourent tables, but adding to them manually…
  • Accounting Period

    I've found how to get a list of the Accounting Periods through the SDK (Using .net API). Is there a place to find the current period so I'm not entering or updating records from an accounting period?
  • Event Viewer Exception from Accpac internal dlls

    I am using the Accpac.Advantage dlls to communicate from a third party .net app into Sage 300. The processes we are doing are simply to open a connection and then return various pieces of information from view calls (I use the CS query view through an…
  • Integration with Rails app 2019

    Hello and good day to all. I'm looking for a way to access SAGE 50 endpoints for purchase orders, invoice. inventory etc through our front-end system built in Rails. The ideal solution would be through an API which I couldn't find any suitable yet.…
  • Vendor Names Changed On Save Without Any Reason

    This issue may or not be related to the Vendor.IsModified always being true ( https://www.sagecity.com/support_communities/sage50_accounting_us/f/sage-50-u-s-software-development-kit-sdk/132513/vendor-ismodified-is-always-true ). I'm posting it separately…
  • Integrate Sage 300 (non-cloud) with a PHP website

    Hello, We have a Sage 300 On Premise (non-cloud) version. We are looking to integrate it with our e-commerce website (PHP). We want to do two-way integration. 1) : From Sage 300 to website Customer invoice, order history, tracking information from…
  • Vendor.IsModified is Always True?

    I'm trying to troubleshoot some problems I'm having, so I wrote a very simple .NET Framework v4.7.2 C# console application to narrow down where the problem is. One issue I've found is immediately after loading any Vendor record, IsModified is always true…
  • Woocommerce and SAGE 50 Canadian version 2019.3 integration

    Hello Guys, Anybody know here how to integrate SAGE 50 with WooCommerce Wordpress plugin? Is there any good solution available in the market? We are using SAGE 50 Canadian version 2019.3 Thank you. Rahul
  • Sage Add-On - Subscription Based Service Plan Tracking

    Looking for a Sage 50 Add-On. My company uses Sage 50 and we offer a subscription based maintenance planfor customers, and having a way to keep track of which customers are signed up, what equipment they have, scheduled visits, billing, would be incredibly…
  • Customer.Contacts and Vendor.Contacts in the UI

    Hi. I have a simple question that seems like it should be obvious but is actually baffling. In the .NET API, you can access the "Contacts" property on both the Customer object and the Vendor object. There are contacts like BillToContact and PaymentsContact…
  • Anybody else having issues with JobOps/Scanco integrating with other ISV's?

    We have been using Sage 100 along with the Scanco and JobOps modules for quite some time. We recently purchased a module from another ISV which requires some integration work to be completed to ensure they operate together without conflicts. We’ve tried…
  • .NET Core Compatibility with Sage 50 US SDK/API

    Hi. Is the Sage 50 US .NET SDK/API compatible with .NET Core 2.2? If not, what's the ETA now that Microsoft has announced that .NET Core will replace .NET Framework? If yes, it is compatible, then I'm having a problem I really need some help with, please…
  • Ar Cash Receipts using BOI

    Hi community! I need some help. I have an almost perfect code here in C# posting a payment in cash receipts. The only problem is that the batch amount is duplicated. The batch total is $520.00 instead of $260.00. What am I doing wrong? Here…
  • Can Sage 50 CA 2019 work with SAP Crystal Reports?

    Hi, I know that the Sage 50 US edition 2019 works currently with SAP Crystal reports, but I just want to confirm if SAP Crystal Reports can also work with Sage 50 CA 2019? I saw in SAP Crystal reports knowledgebase that they can work with data source…