• Payroll transaction file

    Does anyone know you to reset the batch number in the direct deposit transaction file? After I did my year-end, it reset the batch number back to 000001 and now it is saying the batch number already exists.
  • AR invoice

    An A/R Invoice was created by copying a previous invoice. Only problem it was save with status as Paid. Any fixes?
  • Inventory - brought items in - now need to "ADD" to them (ie paint them) - what's the best process

    We brought in some shelving - they are in inventory at a cost of $5. Now we have to send some of these out to get painted - the painting is going to cost $2/shelf. What is the best practice to bring these items back in at $7/shelf - but pay the painter…
  • Shipping Data Entry: Scanned Orders Disappeared

    In the middle of a batch that my shipping manager was scanning out the company had lost power. An hour later, when the power came back on he went to continue to scan out the order that was in this batch but SAGE 100 would not allow him as it's saying…
  • Source Journal Missing from GL

    We are on MAS 200 v4.50.50, with the original payroll module (I know...we're working with our reseller on an upgrade plan). Our installation has been stable, and in the 10+ years we've been on this version, I've never seen anything like this so I believe…
  • 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.
  • Is there a way to process a credit card as an immediate Sale in Sales Order Entry and not just a pre-authorization using Paya in Sage 100?

    Any time we enter an order in Sales Order Entry that is being prepaid with a credit card, we use the "Payment" Transaction Type which pre-authorizes the funds for the order. It is not until the order ships and the invoices are posted that the credit card…
  • AP from AR Clearing Affects Commission Report

    I realized that processing an AP from AR Clearing transaction will overwrite the original customer invoice payment date with the clearing date. This has led to duplicate commission payments when the customer invoice payment date and clearing date are…
  • how can I automatically add a credit card processing charge to a SO or invoice

    Many businesses are adding a Credit Card Processing charge (1 to3 %) to transactions paid by credit card. This is justified by the need to cover the credit card processing fees, which have become significant. Can I automate that addition to the transaction…
  • Freight included on first invoice posting from AR Sales Journal if freight account = sales account

    Was able to recreate this in 2023.1. If you have your Freight account in Division Maintenance setup as a Sales Account and then post a batch of invoices which also use this sales account on line items, the first line item in the first invoice will add…
  • Importing CB batch to change bank code error

    We have a lot of CB batches posted with the wrong bank code. Instead of reversing the entries and doing new batches with the correct codes, we are trying to export the posted batches, amend the bank code and import the batches again. However, cannot do…
  • lines in a sales order invoice doubling

    I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…
  • Cash receipts entry to AR leger not matching

    Every once in a while i will try to enter a payment through the path Accounts Receivable, cash receipts entry and the invoice I want to pay will show a zero balance. If i simultaneously pull the invoice up using the path Accounts Receivable, customer…
  • Accounts Payable Credit Card Transfer Question

    When transferring an open vendor payable to a credit card vendor, the invoice for the original vendor shows as paid via a particular bank code. Does anyone know what dictates the bank code used for the credit card 'payment'? Also, since a bank code will…
  • How to apply a vendor Check from a CM for inventory returned?

    How do i apply a check from a vendor who paid me for inventory items returned back to him? CM has been processed via Return of goods entry. Many thanks
  • 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…
  • Post Dating Accounts Payable Check to a future date

    We would like to print checks on the 30th but have them posted to the 1st of the next month, can we do this and have it posted in the next month as well? If we can, how would we do this? We want to do this because the rent invoices are for July but…
  • Duplicate imported payments

    We imported manual check entry payments via the Visual Integrator module. Accidentally uploaded twice, and now have duplicate payments posted. They're exactly the same, down to the same check number. Can I delete the duplicate? Or will I have to void…
  • When drilling down on an "MC" source journal, it brings up Payment History Inquiry instead of AP Invoice History?

    Hello all, I am looking in Account Inquiry at AP and MC source journal entries. Drilling down on AP entries brings up AP Invoice History information. However, drilling down on an MC entry brings up only Payment History Inquiry. Does anyone know why…
  • Opening Balances in GL

    I for the life of me can not figure our this whole clearing account and corresponding account in the journal entry to in put opening balances. I an starting fresh and want to input previous amounts from my Quickbooks in my GL so I can start using Sage…
  • How to get to the end of a line in the comment field in grid entry?

    I'm entering journal entries and in the grid, there's a comment text field. On different lines I want to append things to what I've entered in the header comment. Example: Header comment = Apr 2023 Line comment 1 = Apr 2023 - meals Line comment…
  • S/O Credit Hold

    Hello, with 2019 version when we created a new S/O quote if customer was on Credit Hold it would prompt us now with 2022 it does not. . However if we start with an order not quote then we get prompted. Has this function been removed for quoting..…
  • Repetitive Invoicing

    We would like to allow some customers to pay their invoice on a 6-month payment schedule. I see that we can use repetitive invoicing and set up up for a 6-month period but we want to take the sale upfront. Does the repetitive invoicing replace the traditional…
  • AP ACH File Special Characters

    We are processing ACH files out of AP, and while it has worked fine, we recently came across an issue where some of the payment lines were rejected because the vendor numbers (which are included in the ACH file by default) contain special characters …
  • AR Repetitive Invoice Cycle and unique billing dates

    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…