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…
I need a report to show me any AR that was billed prior to 7-1-2017, but NOT paid as of 12/31/2018. Is there a report in TS that will give me this info? Or a combo of a couple reports that I can then put the info together in Excel? I use TS Premium
…
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…
I want to Download in Excel (from Sage 100) an Accounts Receivable Open Invoice Report. The problem is that the reports that I found in the AR module shares excel columns, for example, the AR aging will share the customer name with the invoice number…
Is there a way to keep track of materials used and labour for a project on excel and export it into sage as a sales invoice? I have been weeks trying to figure out the easiest way to keep track. I could use time slips to keep track of labour but it doesn…
Anyone know what the program is to run the AR Aging process? I know it can be done by running an aging, and by rebuilding sort files. But I need to schedule this to be done daily. And the Task Scheduler is not working for this client. Support has not…
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…
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…
We have numerous $0 invoices in each customer AR account for items like samples, literature, etc. This is our way of tracking these materials. Recently, we began using bolt on programs for alerts and reporting. One report will send an alert for each customer…
We have a customer with a lot of entities and locations with the same bill to. Within these locations, there are many contacts. So we have customers calling, stating they are with XYZ and we don't know which ship to location is related to which bill to…
How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.
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!
Hey there,
When setting up from our last accounting software we had two accounts receivable, one in cad $ and one in us $, as well as three accounts payable, the extra being for GBP. When linking my accounts receivable to my customers for the linked…
Hi,
We have an AR receipt Entry batch with 2 entries my first entry is ok but I want to undo the 2nd entry in order to put back the document number in the first entry.
Hi there,
Is there a document for Sage 300 2016 to direct the user as to which tables should be edited in order to change an invoice number in the AR module.
thanks
Hello,
Instead of making a purchase voucher, I made a general journal entry and cleared the accounts payable account via cash. However, instead of this amount linking to the accounts receivable, I know have amounts in both A/P and A/R. How can I transfer…
Hi there,
In accounts receivable invoice was entered for customer “ABC” in the amount of $50,000 another Invoice was entered for customer “XXX” in the amount of $500. That was all ok the problem happened when the receipt entry was made.
There was…
I have 3 issues; not sure if they're related. It is a foreign currency set-up, and I'm aware of the Knowledgebase article saying that one should call Sage support for database repair -- but I'm not sure I'm at that point -- would prefer to explore ideas…
I am seeking suggestions & guidance on dealing with &/or finding the root of our A/R being out of balance. Here's what I've done/fixed so far:
I started filling in for a bookkeeper a couple months ago while she was off work a few weeks (due to a stroke…
Question, I need to run a report showing what I billed our customers for the month of December 2016. But I need to choose customers who only purchased certain products. Which report do I need to run? I'm starting to confuse myself. Help!! Thanks.
Hi All
How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016).
something that looks like: Thanks!
Vendor A $50,000
Vendor B $100,000 …
Our company is CDN but also does business in the US. So, we have set up a US bank account. We invoice our US customers in US funds and they pay accordingly. We also purchase US products (COGS, etc.) and pay for these using our US account.
My problem…
Hello,
I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…
SAGE Advanced 2016 (Version 5.30.1.0)
We recently upgraded from 2014 to 2016 and have noticed a problem with some of the data entry panels. The fonts are extra large and bold on some and normal on others.
I have managed to fix most of them simply…