• AP invoice and the AP Trial Balance Report compared to the GL

    Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…
  • Purchase History Explore / Report question

    I have a question regarding how to look at bits of data from a certain vendor. Using the explorer views we are trying to figure out how to find a certain item from a certain vendor and how much we paid for the individual item for the past 5 years.
  • Are First and Last Names needed for printing or eFiling 1099s?

    I thought I read a post about this, but now I cannot locate one. When we have Vendors with SSNs, like in this ABC Vendor below, we expect the First Name and Last Name fields to be filled out, but they are not: Of course we get this message, which…
  • Scheduling IRP's to run in the evening

    We have to schedule 4 different IRP types to run in the evening. Can this be done under Library Master > Task Scheduler? And how can we schedule them?
  • Full Inventory Inventory List w/filters

    Hello fellow Sagers! Happy Holiday's or Merry Christmas! I need a report that shows all inventory items WITH "Inventory Cycle" and "Active/Inactive" status displayed. I have years of incorrect inventory items/status modifications that were entered and…
  • Sage 100 2023 & StarShip v24

    Hello everyone, My company has been having an issue with a Sage 100 & StarShip interaction. Basically, when shipping items, the associated Sage documents are not printing. I've doubled checked multiple times to ensure the Form Code is correct and no…
  • Budget

    I tried to copy last year's budget to the next year. But I keep getting No Budgets Selected. Is there a trick to this?
  • Set Up 1099 Boxes Based On an Existing Year

    I know the below are instrcutions to create 1099 boxes based on an existing year. However, I accidentally clicked "No" in step 4 when I tried to setup Year 2022 and 2023. And I'm not getting the prompts again. How do I setup 1099 boxes now? Is there…
  • batch report creation

    Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\
  • Daily Sales Report

    I am trying to update my day but every time I click on the daily sales report in SO, it will not launch and crashes pvxwin32. The links file has been renamed to break our 3rd party connections with zero impact on the launch. Everything else in Sage run…
  • Print cash receipts

    My company recently bought another company who has sage 100 for their accounting software. Before we close out their books we need to enter a few AR cash receipts. I have a basic knowledge of Sage 100 but am not proficient. I have entered the payments…
  • 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 if turning…
  • 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 that…
  • 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…
  • 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…
  • 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"? Thanks
  • Crystal Reports: Adding a UDF for each Item Number on a Picking Ticket.

    OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing . I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…
  • Upgraded to Sage 100 2021 No Paperless Button in Customer Maintenance screen

    Upgraded to Sage 100 2021, I am not seeing paperless options in my Customer Maintenance screen, is there a new right I need to activate to get that back??
  • Crystal Reports QuantityDecimal formula for 2 decimal places

    What formula would be used in QuantityDecimal to set the number of decimals to 2? We need 4 decimals for qty for BOMS only, so would like all forms to only display 2 decimals. Thanks.
  • Pick Sheets - Only Print Items that are Shipping

    Hopefully there is a way to do this. We are currently in a major backorder situation due to material shortages and have many orders that are partially shipping. For example, We enter an order containing pages of items (100-300 parts) We are able…
  • Cannot open attachments in memo fields

    Currently unable to open attachments. When I try nothing happens. This is happening for file types. File path look to be correct. I have uninstalled and reinstalled Sage. This is happening on Sage 100 2019 premium.
  • SalesOrder Picking Sheet Denied Access

    Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…
  • AR Deposit Transaction Report

    Hi. How do I generate a report that will show me how a cash receipt was applied? I need to know what invoices were paid by each individual cash receipt in the year 2020 and early 2021. During the early days of COVID ach payments were sent in randomn…
  • Source Data for Customer Sales History by Period Report

    The Customer Sales History by Period >> Dollar Sold does not match our income statement revenue. I tried reverse-engineering the data and it appears that any values that touch the customer A/R account are included in Dollars Sold, regardless of which…
  • How to find the cause of variance between invoice total and the number on income statement ?

    Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…