• Sage 50 US. Search for inventory items using "description" keywords, inside the sales order.

    Can anyone please help find out ALL the ways possible to search for inventory items using "description" keywords, inside the sales order. Say, there are hundreds or thousands of ID's, there is no way to know or remember them. But the users know the…
  • 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…
  • Relation between sales order and purchase order.

    In sage 50, which field in jrnlHDR table tell us for relation between Sales order & purchase order ?
  • 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…
  • Field Population - Sales Rep

    I am having a hard time trying to get the Sales Rep field to populate on my Sales Orders and Invoicing. I have even tried customizing the field. Does anyone has any suggestions.