Browse By Tags

  • 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…

  • Unable to access other modules whilst in new bank feeds 29.2

    Users who do online sales and do not create customer record for every single sale rely on sales orders to help identify transactions that need to be processed into sage. The payment tab in SO is used to process those payments. Now the bank feeds has its…

  • Convert an order into a sales order, delivery note or invoice.

    Very often I place a complete purchase order which is for a specific customer and I then have to invoice the complete order when it has arrived. It can be very tiresome duplicating this into an invoice especially with multiple stock codes and then adding…

  • Why and how to avoid: Orders input by other users not showing immediately.

    Problem We have several users who look after sales and purchasing who are in different offices. Often, one user will input e.g. a sale; however, other users cannot see this sale immediately which can result in the sale being input again by another user…

  • 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.

*Community Hub is the new name for Sage City