Browse By Tags

  • How to enter Purchase order and create Sales Order using API

    My team has been using desktop Sage 100 (2021) to enter purchase orders to generate sales orders, but we would like to do this via API. https://help-sage100.na.sage.com/2021/FLOR/index.htm#Program_Listings/Program_Listings_Overview.htm?TocPath=Program…
  • Error on API Sales order submission

    I get this message on submission of so far only two orders out of hundreds "The selected item is inactive and cannot be used for this process" I've checked the products are active and the account isn't on hold Supposedly a user was able to submit…
  • Request: Support for setting Unit of Measurement (UOM) in Sales Order creation via API

    Currently, when creating a Sales Order, the API allows the upload of items but does not allow the setting of the Unit of Measurement for each item. Sage 50 uses the item default set in the account instead. Unfortunately, this limitation means that someone…
  • Split a Sales order into in stock and out of stock items.

    FormerMember
    FormerMember
    When a Sales Order is added be able to split the order into two one with any items in stock and one with out of stock items. THis would then match with the websites and other third party apps I have come across so far.
  • How to overwrite the sales tax using sdk

    We want to be able to write the Sales tax of a document back to sage using a third party application. From the .net dll, we have understood that the sales tax can only be calculated but not written to. But we want to know if there is any way we can edit…
  • Sample ODBC/SQL queries for getting Sales Order information, Customer Information, and inventory information?

    Can anyone offer any sample SQL scripts for getting information, such as Customer Information (given a customer ID), sales order information (given a sales order number or customer ID), and/or inventory information (given an Item ID) out of the database…