x Want to participate? Join the group to interact

  • Using a Sage UDT (Sage Premium SQL table) as a source for a VI job?

    How can I use a Sage UDT SQL table as a source for a VI job?

  • Sage100 Advanced to Sage100 Premium Migration

    Hi, I need to upgrade Sage100 desktop application from Sage100 Advanced to Sage100 Premium. Question 1 - What are the perquisites for upgrading/migrating? Question 2 - What will happen to my data if I switched from Sage100 Advanced to Sage100 Premium…

  • Consolidated billing query with AR_InvoiceHistoryDetail

    We are trying to write a query or stored procedure to identify the cash receipts for each of our franchises (warehouses) but ran into some trouble with consolidated billing. Since payments aren't applied to the line items we need to create a lookup table…

  • New GL Accounts for 200 Companies

    For FFCRA, we need to add the same 4 new GL Accounts to over 200 different companies. Does anyone have a suggestion on how to "automate" this process? We are using Sage 100 on SQL Server. My background is in MS SQL Server database management and development…

*Community Hub is the new name for Sage City