• 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…
  • 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
  • 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.
  • 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!
  • Balances due under vendor maintenance, but in the check printing invoice payment selection, the invoices have $0 balances

    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…
  • receiving a rent from a location that I also rent.

    I do rent a warehouse for my business, about 45 thousand square feet; my rent is about $45,000.00. but from this space I do rent to somebody else and receive $3,000.00. The question is, how can I book the $3,000.00, should I credit rent expense or another…
  • A GL Account for a GPS traker

    I may not in the right place to post ask these questions. But I need some help. I purchase a GPS tracker for my trucks what GL should I use for this expense. Thank you for your help.
  • AP Vendor Remittance Advice Number is not incrementing

    Within the AP Options - Entry- we have checked the box for Increment Next Check No. When Changed During Printing under the Manual Check Quick Print header. Our AP analyst has to manually advance this field when performing ACH payments. Does anyone know…
  • How to deal with a Prepaid credit card purchase order and have the payment reflecting that payment.

    We have a vendor that is prepay via credit card (not attached to sage). They have already been paid and entered into Purchase Order receipt of goods, the Purchase Order Receipt of invoice entry. This vender and invoice are showing on my aged invoice report…
  • BOI Create Completion Transaction for Work Ticket

    I'm trying to use Business Objects to create a completion transaction for a Work Ticket in Sage 100 2022. I can't seem to figure out how to add the work ticket to the actual transaction. Below is a slimmed down version at its simplest form of what I'm…
  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
  • Invoice total displaying as zero

    The total is displaying as zero in Invoice Data entry I've written the script for the extension amount as follows. Can you pls clarify which column should be used to store the total?
  • Invoices not showing in customer maintenance

    Hi Team, Can someone kindly help me with displaying the invoices in the customer maintenance section? It appears in the data entry for invoices but not in the section for customer maintenance.
  • WIP was turned off and it affected our GL postings. Is there a way to fix these without looking at each S/O Journal?

    Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…
  • Positive Pay Export for Union Bank

    Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…
  • Shipping data entry sending items in multiple packages with packing list for each package

    We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list. Does anyone have a similar issue?
  • serialized items are showing as available but they have been invoiced

    We are showing a serialized item on hand and available, but it was sold in November 2021. History shows the item was received and sold, with no further movement on this serial number It's still showing on the Inventory Valuation Report - item in…
  • Move AR Cash Receipts Entry to a different batch possible?

    On occasion we need to move one or more cash receipts entries out of the existing batch, into its own batch. Currently the only way I know to do this is to view the existing entry, open a new batch and manually recreate the entry in the new batch, before…
  • Reverse Auto Check Reconciliation

    Hello, We began using the Auto Check Reconciliation utility in Sage 100. We imported a list of cleared checks from our bank, with the account number, cleared date, and amount. We proceeded with the auto reconciliation, and now we need to completely…
  • Paid invoice not showing in transactions or history

    I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…
  • Cannot prevent posting to prior period in Subsidiary Modules if General Ledger is open for that period

    I have several clients that have this issue and found an updated KB article on Sage's website. The article was originally created in 2015, but it was updated in 2020. Is Sage still working on the issue? When will it be resolved? Cannot prevent posting…
  • RECIEPT OF GOODS INVOICE - SAGE 100

    For some reason quite often when i do a receipt of goods invoice a few days later the invoice shows for $0 with lines "0" invoiced. I do multiple invoices in batches and i always make sure that the quantity being invoiced matches what we received and…
  • Reverse a Prepayment

    A prepayment was incorrectly made, and due to some confusion was also entered in negatively so it shows up as a positive number in the aged invoice report. Is there a way to delete a PP or reverse it? This is on the A/R side. Thank you.