Browse By Tags

  • Payroll Entry Unbalanced

    We posted a payroll entry that wasn't balanced. From looking at it, it appears that we used an earnings code that wasn't liked to a GL account and now the trial balance is unbalanced. I wanted to see if anyone else has experienced this and see how they…
  • 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…
  • Electronic Payment paid twice as much as invoice

    We have a vendor that we entered in our AP data entry. The amount entered into the data entry batch matches that amount of the auto draft from our bank account. When we go into Invoice Payment Selection, the amount is correct and matches back to the AP…
  • Vendor Terms Set Not Updating in PO Module

    Hello everyone, I had updated a vendor's terms in Vendor Maintenance. Since updating I have received a handful of invoices in the PO module and it still keeps having it as due upon receipt instead of populating the terms I set it to in the vendor card…
  • Transfer Paid Invoices to Another Vendor

    We have two vendor cards that are for the same vendor, but used for different accounts. When reviewing, we found that some posted transactions had been put under the wrong vendor number. Is there any way to just transfer the invoice (even though it has…
  • How can I apply Credit Card purchases to jobs?

    I have tried to add in through AP. However, when I go to Job Cost, the receipts are not showing. I also tried to add in under 4-7-3 and still not coming up under job cost. We need to be able to see total job cost for the specific job and gross profit…
  • 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…
  • Automatic Sales Order Entry

    What are the best options for getting automatic entries for new Sales Orders? Looking to integrate orders placed through online sales and have them directly entered into Sage. Currently on 2020, but looking to update.
  • 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…
  • 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…
  • Job Cost Retention Invoicing while using BT/ST

    We would like to use Job Cost Retention in Sage 100 Premium 2021, but currently Sage does not support the Bill-To/Sold-To (BT/ST) feature within Job Cost (which we need because all our jobs requiring Retention bill to a GC or third party). Adding Job…
  • AR Pre-payment

    Hi. Okay..... A prepayment was applied to the wromg customer in Sage and has been reconciled since December 2021. I was told to issue a debit memo for the amount that was misapplied. My big question is.... is it possible to apply prepayments to…
  • "This option cannot be changed while A/R Invoice Entry is in process"

    I received this error in Accounts Receivable module and I cannot seem to find any knowledgebase article that directs me on how to remedy this. Anyone else had this issue? In this instance, all batches are closed and none are outstanding in the Invoice…
  • Sage 2020 Negative Issue of Materials

    Hi, In Sage 2018 and WOScan we could negative issue an item and create a new unique Lot or Serial Number on the fly. In Sage 2020 and MFG100, MFG100 will accept the scan, but Sage rejects the import because the number Lot/SN doesn't already exist…
  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…
  • /MISC "A General Ledger account is missing for an item code"

    Hello, We added few line items in Sales order under /MISC and created its invoice along with other normal line items but we are trying to post the sales batch we get an error " A General Ledger account is missing for an item code" Does anyone…
  • ERROR " This batch will be retained because deleted entries exist" in General Ledger

    Hello, I tried to delete a batch in General Ledger, but I received this error "This batch will be retained because deleted entries exist". Has anyone had this error before? How to fix it. Thanks a lot! Jun
  • Journal entry uploads

    Hi, My company is currently importing journal entries to the General Journal Entry module by uploading a csv file through the General Ledger Exchange. I was wondering if there's a way to customize the settings so that Sage is the one assigning the journal…
  • Intracompany transactions

    Hello, I am very familiar on how to post intercompany transactions but not with intracompany. I am hoping someone can assist me. My business for privacy is called ABC. ABC has 3 locations, WV, KY, TN. We utilize the WO module to purchasing, including…
  • How to purge Time track transactions that have not been transferred to payroll?

    Currently I am moving my client to Sage 100 2019 Payroll 2.21 and will be integrating their payroll with another software through time track. I am currently using a test company for all of this. I need to clear all transactions in Time track. Some date…
  • setting up general ledger accounts

    Hello I am sorry if I am in the wrong section but, I am trying to set up a company and I chose contractor for the chart of accounts, but when I go to the maintenance account only I can only see the retained earnings account. how can I make the accounts…
  • Burden Posting

    Hello all: I Have a client who is on Sage 100 2014. They are using Job Cost and Payroll. They want payroll entries to post burden by cost code. The labor is posting correctly but for some odd reason the burden is posting to one cost code. I have reviewed…
  • Pay AP Invoices with Bank Purchase Card through an upload to the bank

    have a client that wants to do the following... "Process AP invoices just like we currently do, but the vendor set-up will reflect it being a credit card payment (i.e. rather than live check or ACH). When we process the weekly AP batches, we will…
  • What research tools can I use to balance Bank Rec?

    I'm doing a manual bank rec (not using Sage bank rec, but doing it on my own using bank statements plus everything I've entered into Sage.) It's not balancing. I have used the General Ledger Detail report to verify each item entered and everything matches…