Sage 100

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…

We are running Sage 100C, 2016 Premium. We have just noticed that customers are disappearing from Sage 100. Their customer numbers are gone in Sage 100, but we can still see the customer number in Sage CRM. We aren't sure exactly when this started to…

Hello, I decided to try using a Business Insights dashboard for looking at the A/R. When I view the A/R Analysis report, the first Aging Period is correct for today. But the ones displayed below are the last months of our 2014 Fiscal Year, and not the…

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…

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?

Hello, We're recently encountered a problem with posting AR Cash Receipts. This has occurred over the last 5 months and we haven't found a solution. A Cash Receipt is properly posted and clears the AR invoice. If you view AR Inquiry, the invoices…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

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, 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…

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…

Looking to show Quantity Ordered, Quantity Shipped, and Quantity Backordered in Invoice History Inquiry for SO invoices. Currently it just shows "Quantity" which is the quantity shipped. I opened the panel for SO Lines in Custom Office, and it's just…

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…

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…

This is a Crystal Reports question. I am trying to add to AR Aged invoice report Average Days to pay from AR Customer Listing With Balance. I have gone into Crystal Report added to Database Expert AR_CustomerListingBalWrk and linked with AR_AgedInvoiceReportWrk…

AR - created a CM and dated it one date (1/18/17) and posted in to another GL period (2/8/17) thus throwing my recon for January off. I know it clears out in February but would like to correct in January. Can someone please help me? Thanks

A customer overpaid and then next month ran a schedule for same amount. Need to take the overpayment from first invoice and pay off second invoice

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.

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…

Currently I can only see a few months worth of customer sales history. I need to see more than this. How can I go in and adjust the settings to allow me to see more than just the last few months? I need to at least see all of 2016 and right now I can…

Hello I have some issue in the account receivable. In my Aged report it shows open and when I try to apply the PP-PP using cash receipts it shows no balance. the dates are fine nothing posted like for next month or year. (I did create a credit memo…

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…

CR error - posted a deposit and it did not update correctly. Shows posted in CR but not in AR. Its like the deposit is hung out there. How to fix? I can't delete the deposit because it is gone. I did update and its just caught up! I need to rebuild or…

We have customers who require us to send them a monthly statement of invoice's during that month. We do not want a cumulative Aging statement. Is this something I have to create using a custom solution or does MAS200 5.1.5 2014 have a canned report…

All the amounts were correct and when I printed and updated the commission register I saw 1 salesperson whose vendor link was not updated. Will is transfer to AP ? How can I correct this? I manually updated his link in salesperson maintenance, but how…