Sage 100

Looking for recommendations on how to handle a AR repetitive invoice that is billed annually for example but it's not based off the calendar year. It's based on when the customer signed up. For example, signed up 4/1/2022 so entered a repetitive invoice…

we frequently need to make wire payments in advance of receiving an invoice, non-inventory items. We record the wire as a manual check. We have had duplicate payments to vendors as we've lost invoice # being the control. When I view the vendor inquiry…

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…

We have the LM-Role Maintenance - Module Option - AR - uncheck the Allow Credit Limit Override so that the users cannot override a credit hold. This has also effected our RMA users. When they try to process an RMA for a customer that is on Credit…

I have a client that bills once per month. I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 300+ customers need to be autopay a few days after the invoices…

Hello, We noticed that two vendors have a posted check with the same check number, different amounts, and different check dates. Check 4340 for 2,313.03 shows under Vendor A with a Check Date of 06/23/2022 Check 4340 for 2,120.14 shows under Vendor…

Hi! So my co-worker tried to add a new credit card to a customer account, and received this message "Already used this customerID". As a test, we added the card to a different customer, and had no problem. I reached out to the credit card processor…

I need to clear multiple AR Invoices for loans. Payments against loan balances years ago changed to be offset by a GL account as loan software was utilized to track loan balances. At this point the loans are paid off and the invoices are sitting in the…

We have a long time customer who has been using Paya for years, and now (due to an ownership change) they are moving from Chase to Moneris, so we've set up a new Payment Type with the new Merchant Account details. When we process a payment in the new…

Using Sage 100, I entered an invoice as July 6, 2022, but it should have been June 22, 2022, using Invoice Data Entry, and then I applied the case using Cash Receipt Entry. I entered the cash received on the correct date of June 22, 2022, so now my June…

Need to undo the Cash Receipts entry, but the Cash Receipts journal was posted. The Daily Transaction Register was not posted yet. Should we just finish the DTR and do a Reverse Cash Receipts entry or is there another way before the DTR is run?

I am running Sage 2021 and have managed to get two people into the same batch for doing Credit Card transactions with Paya. Any attempt to add a third person will not work. What is the preferred method for allowing users to run a stored card for a client…

how to make a bank transfer journal entry from one bank to another bank in sage 100 (2017)? I tried to make an entry thru GL transaction JE, but I did not see source journal TR or BT for transfer.

Hi Could anyone suggest why sales invoices list are not showing in cash receipt invoice list? using sage100 v2021 Here are my invoices

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…

Hello, Two questions.. First how do I disable/remove a Sale TAX Schedule that is no longer needed. If it can be removed how will that affect history?? Next... I have a customer with a tax schedule of WA2717 in its customer record but when I create…

I am looking at a company that has provided me with a bank reconciliation that worked (0.00 out of balance) when prepared in early Feb-22 (for year-end) 12/31/21 - however, when I review the bank reconciliation today (late Mar-22) and compare it to the…

We are trying to close out the batch in the Daily Sales Reports/Updates and we receive this error box. When you go to the SO and check which user has the SO open it is the user who is trying to update the batch. The SO is getting invoiced partial…

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…

Does Sage 100 create balanced or unbalanced direct deposit files?

We have several non-financial accounts, and we use Sage 100 Premium. Our auditor was looking at our NF account (apparently for his own enjoyment) and questioned how our non-financial accounts can be off balance, but our trial balance is still in balance…

When we attempt to attach a PO or PDF to a Sales Order it disappears, I have to continuously try to attach until if finally sticks.. could take two tries or 5 .. Any ideas

We paid an invoice three months ago by paper check for say, $100. The check didn't arrive to the vendor, and so we then paid the invoice by ACH for $100. The ACH cleared, and then they also received and cashed the check. When the vendor realized they…

Our PO was cut with 1 line item at a 1 price of $1000 and received in as quantity 1. The vendor is billing us in pieces like $500, $200, $200, $100 with different invoice #'s for each amount. What is the best way to enter these invoices against the PO…

I have a client that gets the message 'A file is in use by another task. Update will continue to retry until record "" is available' when trying to print the Invoice Register in AP. There is no one else in AP. If you shut down and go back in you get the…