Browse By Tags

  • Importing Sales Orders - Unit Price and Amount are coming in as negative values rather than positive values, and what is the Number of Distributions value used for on a Sales Order?

    I am new to Sage 50 and trying to help this small business to import sales order information. I started by identifying the fields that I thought we needed and then I exported that so that I had everything in the right sequence. I don't see a place when…

  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…

  • Export sales order out of sage 50 US Edition?

    How do i export sales /purchase order out of sage 50 US edition? I have done this with sage 100 using visual integrator and i am in need to do that with sage 50.

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

  • EFT 2015 versus SAGE 50 2015.3

    Est-ce qu'il est possible d'exporter les informations de l'onglet Débit pré-autorisé de SAGE 50 vers EFT 2015? La connexion avec la compagnie se fait correctement pour les clients; fournisseurs et employés. SAUF que l'information du compte bancaire…

  • Vendor Price Lists

    Hello, Is there a way to import Vendor Price lists from excel so that the prices are updated for existing products and so that new products are added into inventory? Thanks, Dave

*Community Hub is the new name for Sage City