Browse By Tags

  • How do I join STOJOU to GACCCODE?

    I am looking to join the two above tables, According to the data models, the join is supposed to happen like this: 1;ACCCOD. How is that supposed to work if STOJOU doesn't have any accounting code? Also what does the 1 mean in the data model? Any and…

  • How do i link a column created in Sage x3 Console Tables to reflect in the sage x3 database

    Good day forum. Am using Sage x3 upfdate 22 Am in the directory. Development>Data and parameters>Tables>Tables. I created a column called "RTN" as seen in line "85" in ask1. Am working with [DEMO].[SINVOICE] I can not see it in the database. Would really…

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

  • 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