Browse By Tags

  • MRP Generation runs forever, no error messages

    I am trying to run an MRP generation to generate a report. I am doing so in the legacy MRP for Sage 100 ERP version 2018. This will be the first time that the generation would be run for this particular company. The files for this company are not gigantic…
  • Accounts Payable Check Printing

    We had 2 checks stick together during check printing. I did not notice we were off by a check number until I had printed and posted the batch. about 40 of our 78 checks printed are off by 1 number. How do I fix this? Do I have to void them all and reprint…
  • Rework - Labeled Product

    Need to reprocess labeled product into a new FG item. How can this be completed? Currently we take bright product and turn it into FG labeled product. Pallet tags with quantities and lot codes are generated. We are taking two FG labeled product and…
  • Changing Effective dates when running a Job.

    When we run a job nightly for IRP do we need to change the effective and cutoff dates every day or does it change automatically somehow?
  • How to remove invoice items for deleted batch

    Dear concern, I am using sage erp 100. I accidentally deleted batch . Now can not post invoices. But these invoices hold items which are not available for sale. I want to cancel or delete these invoices. Please help me to solve this problem
  • Component Exception Manager, Order To Stock, Not By W/T

    Hi - I am trying to use CEM to make stock orders based on my CEM report data. CEM shows me the demand but when I cut the PO it still links all the w/t's. This is causing issues between order and use quantities and generally a mess. Instead, I want CEM…
  • Adjusting Journal Entries

    I created a job invoice last year, but the total amount invoiced is less than the actual cost. Unfortunately, since the year 2023 has already ended and the financial statements are being finalized, I cannot make any changes to that year. The CPA suggested…
  • Bringing in a large value item, but want it to equal Zero

    We have an item we need to bring in that is a large value item. The problem with this is that we are bringing it in through RMA. We need it in the system but cant have this value show in our books. Is there any way to have its value show Zero in our books…
  • Transfer history in a GL Code to a new GL.

    In the General Ledger, I would like to transfer history in a GL Code to a new GL. The new account will not have been used before, just trying to clean up the books. Is there a way to do this?I have looked at Utilities/Change accounts, but am not sure…
  • purge cleared items - bank reconciliation

    How can I be sure that I purged cleared items on my bank reconciliation? I do not recall the system asking this question, but I may have been on auto-pilot and answered it without realizing.
  • GENERAL LEDGER

    MESSAGE RECEIVED JE DATA ENTRY FILES ARE IN USE, UNABLE TO UPDATE HOW CAN I CORRECT
  • Negative quantities for Sale Order.

    We have 2 items in our inventory, that show an SO for a negative amount. I cannot find an orders that have negative amounts and no orders that match the quantities. For example, we on hand 110 units of product A with SO of -15 and an available inventory…
  • VI Job for Inventory Adjustments

    Hi there, I hope you can help me. I created a job to import data for a positive inventory adjustment, and I need to specify the unit cost. We are using Scanforce multi-bin software, so we also need to specify the bin and lot. The issue is that the job…
  • Purge records in pl_journalPDFlog

    Good morning. Does anyone know of utilities to purge records from the pl_journalPDFlog or to rebuild these files? Over time this file gets fairly large. Can the log be purged without deleting the PDF files? Thanks so much.
  • What is the best way to intercompany an AP credit from one company to another company?

    We have multiple companies that ultimately rolls into one set of financials. Company A accidentally paid invoice #1 for $100.00 when invoice #1 actually belonged to Company B. Company B also received and paid for invoice #1 already. Company B wants to…
  • returned item shows as received on PO

    I have a PO with returned item still showing as received. 15 ordered, 20 originally received, 5 returned, 15 invoiced The PO shows the goods receipts for the 20 and (5), GLs are debited and credited as expected and inventory is correct. However, the…
  • Edit PO Quantity Ordered Without Reversing Receipt of Invoice

    Hello everyone, I was wondering if it is possible to edit a PO quantity ordered in the lines tab without having to reverse the receipt of invoice. From everything I learned, I always thought we had to create a reverse receipt of invoice first, then…
  • Voiding a Posted RMA?

    Is there any way to void an RMA after it has already been fully posted (RMA entry and Receipts entry completed, picking sheet generated, invoice generated, Daily Transaction Register run). I am still learning the RMA system and have made a few mistakes…
  • How to Input a Grant?

    I need help! Our small business received a digital grant of $2500 which was deposited in December 2022. We did not make any purchases from this grant until January 2023. My questions:: How do I input this grant into Sage? I know that I have to put…
  • Inventory Adjustments - Profit Margins

    Hi Everyone A purchase order was received in with a higher unit costs than it was supposed to be Sales orders were processed and updated Found mistake did a return of good and re-received at the correct unit costs How do I now fix the profit margins…
  • AR module disappeared

    Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…
  • Bank Reconciliation - Beginning Balance Changed from Ending Balance of Previous Month

    Hello everyone, I am trying to reconcile one of our accounts in Sage 100 and when I am in the Reconcile Bank feature, it shows that there is zero difference, but when I printed the report it said that I was off. I have identified that it was the beginning…
  • 11-2 Work Orders Posting - automatic change to today for invoice date posting - wrong period

    I'm trying to close out last month's work orders. We close and post in the period per the last day of labor. ie: In work orders (11-2) I change the invoice date on the billing tab to the LDOL (ex. 06/12/23) -->> I then change the posting period to 6…
  • RMA Does Not Have Sales Order Attached To It

    Hello, I am using Sage 100. I received an RMA about month ago and the Sales Order I thought was attached to it was either deleted or used by someone else. I wrote the SO # that was created in the "Generate Transactions" screen when initially receiving…
  • Editing Received RMAs

    Hi Everyone! I forgot to zero out unit price for a received RMA that already has a created batch in the invoice data entry (already posted the RMA Receipts Entry). Is there a way to edit or correct? I would greatly appreciate any help!