• Where is Credit card information stored in Sage 100

    Can anyone please help me with the business object for Credit card information and the tables in which it is stored.

  • stapling forms

    Hi All,   I have a client that wants to print Work Order Travelers and have the printer staple each traveler together.   I know that "normal" printing will not do this and work require that each one be printed as a separate job.   But I am wondering…

  • TrueType fonts for use in Paperless office

    Best way to download TrueType fonts for use in Paperless office

  • Read line items for a specific Invoice order without using a loop for every order.

     using (DispatchObject soObject = new DispatchObject(pvx.InvokeMethod("NewObject", "SO_Invoice_bus", oSS.GetObject())))              	 {
                        soObject.InvokeMethod("nSetKeyValue", new object[] { "InvoiceNo$", strRefNumber });

  • Adding Weights of a Repeat Item

    Hey All,

    I am customizing our Bill of Lading (Picking Ticket) so that it will calculate and print the Net and Gross weight of each item on the ticket. I have just about everything worked out. Where I'm stuck is when there is an item that is repeated on…

  • customizing the invoices tab in customer maintenance

    Is it possible to change the order of the columns or delete a column not used in customer maintenance under the invoice tab

    We never use the Disc Date or the Discount amount is it possible to move them to the last columns or remove them from the vie…

  • Sage 2022 Theme Misaligned

    Has anyone else noticed the themes in Sage 100 2022 Premium are misaligned?  We use different frame colors by company.  The cutouts for the minimize, maximize, and exit buttons on the top right of every screen are misaligned.

  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR?  In AP there is the selection drop down for Wire Transfer, but not in AR.  I read if we use ACH/Credit Card, it doesn't post to BR.  So do we use Cash and if so, how/where do we enter the long…

  • Invoice total displaying as zero

    The total is displaying as zero in Invoice Data entry

    I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?

  • Invoices not showing in customer maintenance

    Hi Team, 

    Can someone kindly help me with displaying the invoices in the customer maintenance section? 

    It appears in the data entry for invoices but not in the section for customer maintenance.

  • SMTP Configuration Question

    We are using Sage 100.  We have some users that use the workstation app on their local machines and we have some users that connect to a Terminal Services box to run the workstation app.  I recently configured SMTP on the Sage server.  We require firewall…

  • Is there a report that distinguishes between credit card customers and Net 30 customers who pay by credit card?

    Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice.  I doubt it's possible, but is there some sort of report, or series of reports, I could run…

  • OAuth Login Screen, Office 365

    Hello all,

    I constantly get a popup to log into my account with microsoft every time I try to test the Oauth email settings. When I do actually try to log in, the page fails as seen in below screenshot. Everything is filled in on the company maintenance…

  • Sales order UOM is different than SO Invoice UOM

    Customer orders in cases but need to invoice in pounds.  Cases may or may not be exact weight, each case may have a different weight.  Similarly, order from Vendors is in cases but are invoiced by the vendor in pounds.  Again, case may or may not be exact…

  • Inventory Label printer

    Any suggestions on a label printer for inventory receipt of goods?  I'd like the label to be about 2 x 3 - most printers are either 1 x 2 1/8 or 4 x 6 - to small or too large.  I need a printer and of course the labels, compatible with Sage 100.  Thanks…

  • An Error has Occurred. While running Sage. not a Sage Error

     Has anyone seen this kind of error?

    Any suggestion for a solution?

  • Sage Intelligence Excel Protected mode

    In upgrading office from 2010 to Office 365 reports generated in Sage Intelligence I can only see the data when the document is opened in protected mode. If the document is opened not in protected mode I get a NAME reference error on all the formulas…

  • display separate quantities for each warehouse in item look up

    Hi there!

    I'm a fairly new Sage 100 user and work in a call center that handles sales for multiple warehouses. 

    I get a lot of questions about the availability of products and in different sizes (which we use different item codes for).  I would like…

  • Object Reference for Sales Order Line Items

    Hi All, 

    I was searching for the object reference for Sales Order Line Items. Can anyone please guide me on this.

  • Script to find the Contact Code from the Confirm To in Sales Order

    Hi, I'm trying to write a script to find the Contact Code using the Confirm To in the Sales Order header so that I can populate some user defined fields in the contact code maintenance into the sales order header. I have this so far, but it's not finding…

  • SO Invoice Data Entry: Button Script to get Invoice No from an SO No

    I have added a button script to the SO Invoice Data Entry MAIN panel and was wanting to make looking up an invoice that has already been batched a little quicker.

    Essentially, instead of the user typing the invoice # they would type the sales order #…

  • Does SAGE 100 offer paperless for SO Picking sheets

    In the SO module we currently use paperless Output Office for printing SO's and SO invoices. 

    Is there a way to use paperless for printing the picking sheet "Pick Sheet"?


  • Sage100.ObjectManagement Interfaces .net Error when creating line entry

               var sessionLogon = new SessionLogon
                    CompanyCode = companyCode,
                    UserLogon = new NetworkCredential { UserName = userName, Password = password },
                    ModuleCode = ModuleNames.AccountsReceivable…

  • Sage 100 Customizer DMAIN and DMAINW

    When I use Sage 100 Customizer to add customized panel, I noticed each panel has a W version, eg, In the task of Sales Order Entry,  there's a DMAIN and a DMIANW. What's the difference between the two? Can I set the default display to be DMAIN instead…

  • Script to Synchronize Customer Billing Address in Sales Order Data Entry

    I was attempting to create a VB Script (to be executed via an External Link button) that would update the billing address within a sales order from the customer's AR address. Currently our admins do not have the ability to manually change a customer's…