• 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…
  • Conditional field suppression in Crystal Reports

    MN has enacted Safe and Sick pay that must show on an employees paystub. I have added this field and label to the DD stub but do not want it to print for employees that are not in MN. The hours are helfd in time off 2. How can I suppress this field from…
  • Product Line in Open Sales Order Report

    As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…
  • T&M Invoicing

    How do I add a "Description of work" to a T&M invoice?
  • 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…
  • 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…
  • How can I add 'applies to invoice #' in Crystal Reports for customer credits?

    We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…
  • Looking to Customize Customer Statements Sage 100 2019

    I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…
  • How to obtain Quantity of Items Sold and Issued with Custom Date Range

    I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…
  • 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…
  • Need help with Taxable vs Nontaxable discounts on invoices.

    Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…
  • 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…
  • Sales KIT not invoicing due to KIT not shipped

    Hello, We are having an issue with our invoices not closing out because the actual kit is marked as 'backordered' as opposed to 'shipped'. However, all components of the kit have shipped. For example, the KIT named ABC-KIT has 3 components: ABC…
  • 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…
  • What is the best way to tie together cash flow needs and projections into a working document that can be easily tweaked by GL account?

    FormerMember
    FormerMember
    I am wanting to build a cash flow report that can also serve as a place to tweak projections. The current Sage 100 - Bank Rec- Estimated Cash flow report doesn't drill down enough, detail GL accts, and allow enough flexibility?
  • 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
  • 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…
  • Auto-emailing past due invoices

    Is it possible to automatically email our customers when their invoices become past-due? We are trying reign in our A/R and at 45 days after the invoice is issued, it would be awesome to have our system auto-send a notification/reminder to the debtor…
  • 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…
  • Automate Statement Printing?

    Hello, We are looking to automate statement printing for our customers. I looked through the "Task Scheduler" provided by MAS and noticed that this was not an option. I have no experience with this sort of thing, but it seems that this should be possible…
  • Is there a way to produce a remittance advice using AP manual check and payment?

    Is there a way to produce a remittance advice when making payments using AP manual check and payment? We are not set up yet to pay ACH's through Sage check printing and electronic payments, so we are entering ACH payments through manual check and…
  • Miscellaneous Items in Designer

    Hello, I am trying to make a custom quote form for the Sales Order module. In particular, I have created three miscellaneous comment codes that I would like to use in the form to act as a type of specialized input for our business' needs. However, when…
  • 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…