Sage 100

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…

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…

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…

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?

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

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…

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…

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…

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.

MESSAGE RECEIVED JE DATA ENTRY FILES ARE IN USE, UNABLE TO UPDATE HOW CAN I CORRECT

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…

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…

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.

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…

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…

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…

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…

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…

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…

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…

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!

Hi. I came in this morning to close out the month of June. My module date was set for 7/3, i forgot to change the date back to June. Does anyone know how to reverse the back rec? Can I just go back in and redo for June? Any help on where to move from…

In Vendor Maintenance we see a vendor with 2 balances due. But in the check printing invoice payment section the invoices have $0 balances. We need to pay these bills, but are unable to. The payTodayFlags are set to no, because the payments got backed…

My company is operating on Sage 100 v. 5.00.4 and appears to have not closed periods in any modules for several years (both via word of mouth and staff members’ inadvertent postings to prior periods). Although I was able to find some resources in Help…

There is a PO in my system where everything is completed, but it shows as a backorder and says ***over invoiced*** on the open po report. Any ideas on how to get this to a completed status? Thanks, Dan