x Want to participate? Join the group to interact

  • Creating AR Aging in Sage Intelligence Sage 100 Advanced

    We need a multi company Aging Report and want to create it in Sage Intelligence reporting. I am assuming I cannot use the A/R Aging work file as it only works when run in Providex. Right? I did try that file in SI and came up with no data. I am not surprised…

  • Build Custom Explore Views?

    Is there a way to build custom explore views. For example, If I go into Business Insights > Explorer am I able to create one of those views from scratch?

  • UDT in AP Invoice detail

    I've created a UDT in AP. Populated the data and then created a UDF in AP Invoice Detail. The Code field appears from the table but i cannot select it. what needs to be changed? UDT AP Invoice Detail UDF in AP Thanks for your assistance…

  • Button Script to Add Comment Line to GD_Lines Table in SO Invoice Data Entry

    From the Payment tab in SO Invoice Data Entry I have added a button with the caption "CC Receipt". Upon a user clicking this button I would like a comment (Item code /C) added to the next line number with details from the credit card. First I actually…

  • Script message won't display

    Can't determine what the problem is for the script message not displaying in SO Entry. Here is my script. Client is Premium version 2021 ' -------------------------SCRIPT START ------------------------------------ If oSession.CompanyCode <> "ZZZ" and…

  • Can't figure out Event hook

    I have a script for Item Maintenance that is connecting to Item Warehouse, summing up QtyOnHand and then writing it to a UDF on the Main Panel. The script works when I can get it to run, but I am having trouble figuring out which Event I can associate…

  • Customizing SO Invoice Data Entry - New Tab - Adding Fields/UDF with Drop-Down Menus etc

    Hi everyone, I'm using Sage 2013 I've added a new tab to the Sales Order module in Main > Invoice Data Entry I've added fields/UDFs (some are already ones that existed), but I'm unable to add to anything in this tab or figure out how to get some of…

  • Possible to add additional 'Order Status' type?

    Hello, We are wanting to further specify Quote orders as 'New', 'Converted', or 'Expired'. Is it possible to add an entry to the 'Order Status' drop down in sales order entry? I'm assuming I will need to do some script/UI customizations to complete…

  • How to get Child or sub file (table) level data from Sage VB Script

    Hi All, I need to display a message box on Shipping Data Entry interface. I can get data from "SO Sales Order Header" and "SO Shipping Data Entry" and "Customer....". On Custom Office using trigger of " "SO Shipping Data Entry" " and Pre-Write. …

  • How do you manager your Sales Orders when you have a remote admin team?

    We just hired a remote team member to process orders that drop ship either entirely or partially or are fulfilled electronically. Our current work flow revolves around paper and that doesn't work any more. Have you built or found an Order Manager…

  • Specialize job cost invoice with vendor name listed next to items on invocie

    Updated from Sage 100 Standard to Sage 100 Premium. Need to supply vendor name on job cost invoice. for customer. JC_InvoivoWrk only supplies Vendor id and Division id. How best to link JC_InvoiceWrk to Vendor File to get Vendor name in database

  • List Box Sort

    Is there a way to select the field and sort direction (ascending/descending) for a list box such as Invoice History or Item Transactions? If a script is needed, what method/property should be used? How does Sage determine the default field and sort…

  • How to Differentiate Between Inquiry and Maintenance Panel in Script

    I'm writing a script to expose or hide selected controls based on user. I would like the script to be operational ONLY in Maintenance mode, not Inquiry. In the script, how do I identify whether the panel is in Maintenance or Inquiry mode?

  • Scripting Dilemma (Pre vs Post Table write)

    Hello, I am working on a scripting solution that sets a hard cap on the number of free sample items a salesperson can receive. I currently have a UDT set up that tracks how many of each product line a sales person has, and am able to write to that table…

  • Add a column in BIE? Help, I am not that smart!

    I am trying to make a custom report in Business Insights Explorer that shows: Item Code Item Description Product Line Quantity on Sales Order Total Quantity on Hand But I cannot link a "Qty. on Sales Order" column to the rest of the report…

  • Script to transfer data to secondary company

    Is it possible to write data into different company within some Sage 100 company. For Example add a button on Sales Order Entry to copy order to secondary company. I know how to do it outside of Sage with a script but not sure if session to different…

  • How to Create a Windows batch file to run "Other Sage 100 ERP Task Outside the Program"

    KB article 19387 "How to create a short-cut or Windows batch file to run Visual Integrator import job, export job, or other Sage 100 ERP task outside the program," implies this can be done but the examples given are for VI jobs only, where the "APP Name…

  • Paperless Office Input options - Possible to Scan or Attach a PDF to existing Customer Maintenance account?

    The question is: can Paperless Office receive scanned in documents and attach them to / associate them with a Customer Maintenance record? ..Or any other way to associate files with a Sage Customer account? Thanks very much!!!

*Community Hub is the new name for Sage City