Browse By Tags

  • User unable to promote company to Sage 300 Customer/Vendor

    Hi all, I am able to promote company as admin. However, my user unable to promote company to Sage 300 Customer/Vendor, stating that the Customer code already exists in Sage 300 Company, but the customer code does not exist yet. My user setting: …
  • Error while installing Workstation Setup

    Hi all, My customer is having error while installing the Workstation setup on Sage 300. Checking the log file, a lot of things cannot be found. how do I fix this? The following properties have been set: Property: [AdminUser] = true {boolean…
  • Non-existent items

    We're currently using the Sage100 C# NuGet package noted below. We've run into a situation whereby a miscellaneous item (CI_Item) is visible in the UI and via OBDC connection however, we're unable to find the item using the MASRecordset utilities…
  • SAGE 300 PROJECTS AND JOB COSTING INTERGRATION WITH MICROSOFT PROJECTS

    Where can I find a document or a user guide on how to integrate Sage 300 2020 PJC and Microsoft Projects 2016. Please advice
  • Documented needed to help create new modules

    My apologies if I'm not in the correct forum for this. (It seemed to match the best from the list I was presented with.) I'm looking for documentation on building modules to run from the Sage 100 desktop. I've taken a number of the courses (including…
  • 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…
  • Invalid or missing posting date encountered on Bill of Materials transaction update

    Hi, I've been working on automatic registration of transactions for Bill of materials. but I've been encoutering this issue for a couple of days now. its been throwing me an error that says "Invalid or missing posting date encountered" I opted…
  • BM Production register Error "The register must be printed prior to posting"

    Hi, I've been wondering if someone else encountered or might have a solution for this. Im getting the error "The register must be printed prior to posting" oSS2.nSetProgram(oSS2.nLookupTask("BM_ProductionRegister_UI")) objTransactionRegister…
  • Is it possible to Restrict certain Customers created within Sage 300 with specific group code from getting inserted or synced to CRM?

    Hello, Is there any method/setting, that can ‘Restrict’ certain Customers (with specific Group code) that are created within Sage 300 from getting into CRM as company record? I know that if we tick the suspend A/R integration to CRM checkbox from…
  • 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?
  • 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…
  • Sage300 Integration with C#. Error Occurred While Opening ODBC Connection on Sage 300 Application using C#.

    ERROR [08001] [Simba][SimbaEngine ODBC Driver][DRM File Library]Invalid account name.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failedERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version…
  • SalesJournal SetShipDate The field you are trying to change or function you are calling is not accessible under current circumstance.

    Hello Friends, I am using SAGE 2019.1 SDK for importing invoice in my application. I am getting error at the time of SetShip date "The field you are trying to change or function you are calling is not accessible under current circumstance.". I am getting…
  • Unable to do multi select in all list box after installing sage 300 2019 CRM Integration Setup

    Dear All, I am unable to do multi select option in all the list box fields in sage crm, this is happened only after installting the sage 300 2019 integration setup. Sage CRM ver 2018 R3. Please refer to the bleow url which is from sage CRM Community…
  • Issue sending AP/AR Adjustments using SAGE300WebAPI calls ARReceiptAndAdjustmentBatches/APPaymentAndAdjustmentBatches

    I'm sending adjustments to Sage 300 ERP Server for 'posted' invoices and I know that the transaction are successful because the webapi call returns a reponse code is 201 and the response message contains the information I sent but when I open the adjustment…
  • There was a problem opening company.: (inner exception: FileNotFound)

    var companyId = GetCompany(); try { // Request authorization from Sage 50 for our third-party application. AuthorizationResult authorizationResult = Session.RequestAccess(companyId); This line Session.RequestAccess throws a PeachtreeException: FileNotFound…
  • #C and SDK issues

    FormerMember
    FormerMember
    Hi, A little background... We were asked by a client to create a.Net application to do a few things. The more effort we put in the less success we seem to be having. We are trying to create POs, Time records, and add Cost Codes to the DB. Reading…
  • update onhand on MasterStockItem

    Hi, Is there any way to update the onhand qyt in a MasterStockItem from the SDK?
  • SDK Performance is tooooo slow

    Hi, I have sage 50 accounting, the data are on a local server (within same network). We have no issue with the performance when using Sage 50 but when using the SDK it's really [:@]tooooooooooooo[:@] slow Listing companies takes 45 seconds! Finding…
  • Where payment terms are stored for the customer in Sage 50 CA Edition?

    I'm working on extracting data from the database sage 50 CA, but in the documentation containing the data definition , I have not found the relationship of the payment terms with customers, or where it is stored ( table). Here is the information that…
  • Exist the price levels in Sage 50 CA?

    I'm working on the integration of Sage 50 CA with a third party application with .NET. And price levels are within the required information extracted from the database Sage 50 CA, but so far I have not found any information to verify the existence of…
  • Receiving a Payment via SDK

    Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?
  • Custom button is missing once the CRM Integration with Sage 300 ERP 2014 is installed on CRM server

    I created a new button through Administration > Advanced Customization > Button Group for Company Summary screen with the System Act of "newemail". It was working until I installed the Sage CRM Integration for Sage 300 ERP 2014. Once it was installed…
  • Update Inventory Worksheet via SDK

    Hi Guys, I am having an issue while updating Inventory Counts in SAGE300. I have created the Macro but it actually does not update the Quantity Counted in I/C Physical Inventory Quantities. Has someone successfully updated /C Physical Inventory…
  • Cannot send journal to Sage 50 US via SDK importer

    I am trying to use the SDK (COM) to transfer a journal entry to Sage 50 (Peactree) but cannot make it work. I can see the import status screen flash out and there is no error occurs during the import; but nothing appears in the sage 50 journal entry report…