• Vendor Customer Purchase Report

    Morning, We have Sage 100ERP, I am looking to see if there is a way to create a report by period that shows how much in sales per vendor. So we are a distribution company and we purchase products from several vendors, and then sell those products to…
  • Crystal Report Feeding DM2 Returning Blank

    Hello, I am trying to write a crystal report formula that does the following: If an amended PO number exists in the UDF_AMENDED_PO field, then return UDF_AMENDED_PO, if not, return CustomerPONo When I test this, when UDF_PO_NO is NULL, it returns…
  • Is the a way to summarize the invoice totals to a customer or suppress the detail from the view?

    I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job. Our business is in manufacturing, and…
  • SAGE Formula

    I have a formula in my SO picking sheet it puts different words on the header depending on the number of days between the order date and the ship expire date. I want to edit this formula that the < 4 is actually 0 to 3 Business days. before the wording…
  • Sage BOI Printing

    Hello Community! I have this code below which works great. I have 2 questions: 1. I cannot change the form code to anything else but STANDARD. Seems it fails to find unprinted pickings. 2. How can I code it so multiple copies are printed and / or…
  • Select BOM Revision on PO Line

    I would like to select the BOM revision when entering a PO Line for an Item which has multiple BOM revisions. Adding a UDF to PO Line doesn't have a business object link to BOM. Any ideas on how I can expose the BOM Revision field on a PO Line?
  • Invoice Form with Payment Applied, Balance Due

    Hello, I would like to make an invoice for that shows payment applied (in AR) and balance due. What field do I use on the Crystal Form for the Less Payment Amount?
  • Creating Crystal Reports Interactive Dashboards for Sage 100

    I have several reports in Crystal 2016. Has anyone created interactive dashboards using crystal reports? The Business Insight Dashboard is canned and not really customizable. Sage Intelligence isn't all that friendly. Your still trapped in a little box…
  • oSession.UserName object required

    Hello, We have a customer using our button for a form in Sage 100. We are on 2020 advanced, with script for button to execute on the server. The username: oSession.UserName worked but now it is throwing an error, nothing seems to have changed…
  • Does Sage 100 2020 have the ability to drill down into detail behind a GL account?

    I can pull a report of the GL detail but this does not allow me to click back through to a record that affected the GL. We have been using this system for 2 months and I am trying to figure out if this is an option of the system or just something that…
  • JobOps WT Template Modification Through BOI

    Hey everyone! I'm attempting to modify and create/remove work ticket templates via BOI (through C# and Entity Framework) and I'm not having much luck. I'm not sure what object the template table is a part of and I haven't been able to find anything…
  • User defined script in AP invoice Data Entry is not working returning the Job Cost variables...

    I am trying to warn the user with a message when entering an A/P invoice and selecting a Job that is no longer active. Since there is no Active/Inactive jobs in J/C ,module, the customer is using the Sort field for this purpose. For jobs that are active…
  • Open PO Report

    Is there a way to get an Open PO Report as of a certain date? Meaning, if I want to see what was Open as of Jan 1, 2020. Thanks in advance
  • Overriding tax to AR Invoice object

    I'm trying to override the tax on the AR Invoice object, and while I'm successful at changing the amount on the AR Invoice Header, I'm having trouble changing the amount on the AR Invoice Tax Summary. Here's my code which fires on Post-Write of AR Invoice…
  • Debugging Custom Report in Sage

    Is there any way to run the report from WITHIN Crystal? The only way I have found is to jump back and forth between Sage 100 and Crystal, to view results, every time I make a change.
  • Updating SalesOrder Tax Records

    Hello - I'm trying to override the tax amount on a Sales Order and I'm getting the following error (Record in use by another task): Interestingly enough, the tax amount still seems to save. Any ideas what I'm missing? Here's my code (on table SO_SalesOrderHeader…
  • nProcessReport and copies

    Hello! I have learned to use the nProcessReport in vb.net but i cannot find how to control the number of copies. Does anyone have a sample code to share?
  • Scripting (maybe) / Paperless

    Is it possible to have a batch print job, say Sales Order Printing, set to electronic delivery and then have it NOT deliver the document based on X Criteria? IE, if the only item on the SO is an item that the customer doesn't need to see, how can I do…
  • Error Attempting to Open Crystal Reports via Script.

    Hello, I'm working on a project where I need to pass a parameter to and open a custom crystal report. I have done a lot of searching, and understand that it is possible, but I can't even open crystal let alone pass parameters. I keep receiving the…
  • VB/.Net (BOI syntax) to VBScript (UDS) syntax for calling Custom Report

    Hi everyone, I see many examples of processing a report in BOI, like this one . But all of them are VB/.NET or C#. Could someone please help me translate the syntax to UDS work with Events like Column_PostValidate? Below is Bret's example of Previewing…
  • Trying to Schedule VBScript that prints Sales Orders

    We are on Sage 100 Advanced v2017 and I have a VBScript that prints Sales Orders using the SO_SalesOrderPrinting_UI object. Does anyone know if this object requires an active Windows session in order to run? The script runs perfectly when I run it…
  • How do I run a script after a sales order is really saved?

    I need to run a script after a sales order is saved. The Post-Write doesn't work, because the data is not yet in the tables when the Post-Write script runs. My script prints a specific sales order form for the order being saved, but on new orders, since…
  • Existing UDF

    Hello, I'm looking some existing reports in SAGE 100 and some has User Define Function (UDF) so how do I look at the detail definition of those UDF? Thank you.
  • Script to Export SO

    I'm working on a button script ("Execute on Server" selected, MAS 200) that will export a PDF of a Sales Order to a specific location without prompting the user. I'm running into some strange issues and was hoping someone has seen some of these things…
  • Passing a parameter to Crystal Reports using a button script

    Hi All, I have created a new report that is launched from a button script. I have one thing left to accomplish & the syntax is killing me. Several things to get "out of the way", this is being done is Sage 2015 Premium. What we have wound up doing is…