Browse By Tags

I have a customer that has over 1,000 customer credit cards stored with Sage Payment Solutions (now PAYA). They are planning on changing banks and through Sage 300 if you attempt to change the processing code with a credit card it will delete all the…

Hi We are looking into switching banks from Wells Fargo to a smaller institution that is aligned with our values. The bank we are looking at does not provide custom designed files for use with Sage 100's Auto Check Reconciliation. Can someone tell…

Hi, I have just linked our Stripe account with our Sage software. Before I begin using this feature I would like to make sure I have it set up correctly and that I know what the flow of Journal entries will be. When I create an invoice through the…

Hi, When receiving prepayments from customer in AR (against an Order), the VAT amount of the prepayment has to be reported. How can I record it so it appears in Tax Tracking Reports? Appreciate your input. Thanks & Regards, Ubaidullah Nubar.

Hi, I use Sage 50, When I received a deposit from a customer, and we have not done up an invoice for them yet. I will enter the amount in the receipt module under the Deposit amount. Now it sits as a credit to that customer. Now the boss will give me…

When trying our first bank rec after upgrading we discovered that as part of the recent conversion our deposit tables were cleared. It is an easy fix to complete the bank rec, but the issue is that now all the associated payments are showing up in AR…

Hi What are the steps to post a sales order through to AR? How is the AR pdf log created?

I have a customer who used to be set up as a different name. On the old name, there are outstanding invoices. On the new name, those exact same invoices are marked as a prepaid. How can I clean this up and get all invoices under both names to a zero balance…

I am going through the Perdisco assignment for my accounting 4 class. When I got to the first trial balance part of the practice set, my general ledger trial balance was way off. My numbers are correct when I did it by pencil, but they are different than…

Hello I have a novice question.... but it is really holding up my production. When I issue an invoice in "Revenues" and then a "Receipt" when payment is made, is that payment automatically linked to the1200 A/R Control Account in the COA? I am carrying…

David Beard and Jeff Richards will be available online to help customers & our reseller partners with technical questions, perhaps brainstorm ideas for deployment, seek advice on marketing & sales + almost anything else SageCRM Drop in via Skype or dial…

I have read all of the questions on here about the reconciliation of the A/R Trial balance to the GL Trial balance. I have run countless reports, and excel files trying to find the differences. Things I know: There are zero postings to the A/R GL…

We have an invoice that was created for a customer with sales tax included. However, the customer is tax exempt and I'd like to know what the easiest way would be to fix this? Would it be to create a credit memo and then create a new invoice?

I am trying to reconcile the A/R aging to my G/L and I can't get it to match, no matter what report I run. It matched in November, so it has to be something that happened in December. I have checked the G/L accounts and all of the transactions were generated…

I am trying to process year end in AR. I have ran/printed all customer statements, interest, printed all posting journals and reports needed. Every batch is posted to the GL and backed up. Every time I click "Process" in Year end I keep getting the error…

The 1st January 2018 Sage 50 US Payroll Solutions Update was released today, December 19th 2017 This update contains Federal and State tax formula calculations for the 2018 calendar year reported through December 13th, 2017 . To receive this update…

Good morning! I work at an equipment rental company with seven locations (two more being added within the next few months). The company uses Point of Rental software for the daily business, and each day I download the previous day's journal entries into…

Hi, Is there any way to contra transactions and show a net balance if a vendor is also a customer? Priti

Hello, I am new to Sage and have found that you can not do a JE to reduce an A/R invoice attached to a job. My client received payment for a particular invoice long ago yet it still shows in A/R so how would I remove that invoice without voiding it…

I am trying to combine tow A/R into one. here is the scenario: A/R account has an account left over from last year. So when I tried to add to it it didn't allow me, the account didn't show up as it is a control account. Than I changed it to A/R general…

Hi, Monthly I have a task to import data (all Credit memos, Debit memos & Invoices) into our Sage 100 & post them. Usually while proceed my batch in Sales Journal module, Sage 100 let me Print (or Preview) two reports: one summary & one for details…

Hi all. Something weird happened to two of my A/R batches this morning. Two separate batches combined into one deposit number. Has anyone ever had this happen before? I am wondering if somewhere in Sage there is a way to combine separate batches into…

I have a client that has processed a credit card payment that was supposed to partially pay an invoice. They over applied the payment so the invoice now shows up as paid, but they credit card payment show up in the Aged Receivables because it was over…

I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!

I am new to Sage. I am reviewing books for a client and find that none of their sub ledgers (A/R, A/P or Inventory) match the financial statements. In QuickBooks I know how to trouble shoot these; but not so in Sage. Can someone point out the common mistakes…