Sage 100

Looking to print invoice detail lines on check stub however I have not been able to determine which column in the AP_CheckStubWrk table contains the information that I am looking for. I have attempted to link the work table to the AP_InvoiceHistoryDetail…

I used be able to go into Data File & Display and change the description on a customer P.O. in Mas90 - I can not figure how do do this in Sage 100 - Anyone know how? FYI; I use certain codes to pull up data for a seminar dates in Crystal Reports

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…

Is there’s a way to classify vendors so they can be sorted/filtered? We have this for customers. It would be nice to have something similar for vendors, since we have to show vendor listings to regulatory auditors. The only way to print a list of vendors…

I see where Sage will give a profit % by line in the sales order module, but is there a way to get the total profit percentage for the entire quote displayed on the totals tab?

Hello, very new to Sage. I would like to edit my financial reports such as the BS, Cash Flow, etc. I want to be able to add/remove accounts or drill down to see what accounts are in the reports. I want to be able to add columns, and change the look of…

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…

Is it possible to add a logo on Income Statement from Financial Reports? I could do that in Trend report, Balance report and Cash Flow report. Cannot fine which report format to use in Crystal. Appreciate any help. [:P]

When pulling the information in Accounts Receivable - Invoice Data Entry, I'm able to put in the terms under 'Terms Code' and it automatically generates a due date in the box above it. But when invoices are printed, the due date is nowhere to be found…

In testing finance charges, I noticed the statement lists them as "finance charge" on the line items. It is not legal for non-banking institutions to use "finance charge" terminology in some states. Therefore, we want to know if we can change that to…

Hi all. We have Sage 100 (v. 2014) and I created a custom report that prints out some G/L account information but I want to print out the current Sage login of the person printing the report. I've tried doing the FORMULA = "" for PrintedByUser etc.…

Trying to modify crystal GL Detail report to create a custom report for specific GL accounts. I keep getting ERROR MESSAGE - Invalid Index. {Exception from HRESULT: 0x8002000B(DISP_E_BADINDEX)) Can you please tell me what is wrong? Thanks.

Hi all. I'm creating a VI export job in Sage 2014 and can't seem to concatenate 2 (ARDivisionNo and CustomerNo) fields but unfortunately it's not doing so. I created a temp field that is calculated below is the calcuation, when the file is exported…

We recently tried out the trial of Bartender and are very impressed with it. I was able to accomplish what I needed to do using the Professional edition but I know the Automation Edition and Enterprise Automation Edition offer more automation capabilities…

Posted this tip years ago in the forums but I can't find it any more, so I thought a repost might be good for those who have not seen it before. I also posted it in response to a different thread but thought this might make it easier for people to find…

The company that I work for just started using Batch Processing for the Accounts Payable and Accounts Receivable. I was wondering if there was a way to modify the various Registers and Daily Transaction Reports so that they put different batches on different…

Hi Everyone, My trial balance report at year end shows this: 3200 RETAINED EARNINGS $0.00 3201 RETAINED EARNINGS BEGIN $670,000.00 3203 PRIOR YEAR ADJUSTMENT $0.00 My balance sheet shows this: 3201 Retained Earnings - Current Year…

We need to update the 1099 history with a Wire transfer that did not go through the AP System in February 2015. If I manually update the amount for 2015, will it continue to add the subsequent payments we make to the same vendor in the total for 2015…

Looking for some guidance on this one...we have a custom report in Crystal that we use as a bill of lading. I would like to transfer this report into SAGE 100 into the Sales Order Module -Shipping - Packing List Printing - as one of the options under…