Sage 100: Latest in Reports / BI

Votes
1

S/O Open Order Report by Customer and Product Line

We have numerous customers that want monthly backorder reports by product lines. I can't find a default report that allows me to sort by product line.

Comments (0) | by: JOHN W. | 3 months ago | Last activity 3 months ago | Status changed 3 months ago | Reports / BI
Votes
1

Explore reports, allow preview view to be default when opening a ...

Explore reports are very powerful and easy to use, especially compared to Crystal Reports. For our company the PREVIEW VIEW of explore reports that gives line item ...

Comments (0) | by: Justin S. | 5 months ago | Last activity 5 months ago | Status changed 5 months ago | Reports / BI
Votes
1

Export Error

60% of the time I export reports out of Sage 100 (AP, AR, Inventory, GL, etc.) I get an error and everything closes out. This is very frustrating when I am exporting ...

Comments (2) | by: Deanna S. | 10 months ago | Last activity 8 months ago | Status changed 10 months ago | Reports / BI
Votes
5

override price report

need to run a report of just overridden prices, by customer. We recently had a sales price increase on all items. The Retail and Standard price can be changed in IM, ...

Comments (1) | by: curtis j. | about a year ago | Last activity 2 months ago | Status changed about a year ago | Reports / BI
Votes
5

Auto emailing Sage Intelligence Report using athenticated SMTP servers

For Sage Intelliglnce, the SMTP add-in only supports unauthenticated SMTP. So you would need to find a public SMTP server if you wanted to use it. ALL SMTP servers ...

Comments (0) | by: Dana H. | over a year ago | Last activity 9 months ago | Status changed over a year ago | Reports / BI
Votes
2

All all reports to be run by date ... if this can already be done, I ...

Is it just me, or is there no option to run journals and reports by date ... not by transaction number

Comments (0) | by: Sharon S. | over a year ago | Last activity about a year ago | Status changed over a year ago | Reports / BI
Votes
13

Ability to export formatting (i.e. grouping, subtotals, etc.) to excel ...

Currently, if you add grouping or subtotals to a BIE view, they do not export to excel. Once the data is exported to excel you need to re-create the grouping, subtotals, ...

Comments (0) | by: Heidi J. | over a year ago | Last activity 7 months ago | Status changed over a year ago | Reports / BI
Votes
4

Suppress Zero Line Entries in the Receipt History Report

When running the Receipt History Report and sorting by Receipt Date, it would be nice to be able to suppress the lines that were not received on the specific date ...

Comments (0) | by: Gail R. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
2

A/R Sales Analysis by Salesperson should include COGS related to ...

The report is populated from data stored in the AR_CustomerSalespersonHistory.m4t data file. The Job Billing Register does not update this file with COGS data. ...

Comments (0) | by: Karen M. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
19

EXPAND TASK SCHEDULER TO INCLUDE CUSTOM REPORTS

The task scheduler only includes pre-fabricated reports but I cannot schedule my custom reports. I would like to see Task Scheduler include custom reports.

Comments (0) | by: RUTH S. | over a year ago | Last activity 8 months ago | Status changed over a year ago | Reports / BI
Votes
9

Deferred printing to Paperless Office

When posting a journal / register (normally or through Task Scheduler) there is an option to print "Deferred". The problem is that Deferred Printing does not allow later ...

Comments (0) | by: Kevin M. | over a year ago | Last activity 2 months ago | Status changed over a year ago | Reports / BI
Votes
13

Set Task Scheduler to be able to Email Reports, Registers, and ...

Create an option within the Task Scheduler to email generated reports to defined users within the Job.

Comments (0) | by: Machelle A. | over a year ago | Last activity 3 months ago | Status changed over a year ago | Reports / BI
Votes
5

Option to Exclude Credit Items from A/R Aging Report

I would like to have an option to exclude credit items from the A/R aging report. A simple check box to include or exclude credits. This should be a standard report ...

Comments (1) | by: Thom T. | over a year ago | Last activity 4 months ago | Status changed over a year ago | Reports / BI
Votes
2

Warning on Designer button when no existing report is found

When working from a report / form printing dialog, the Designer button automatically creates a company / paper type / form code specific report file when an existing .rpt ...

Comments (0) | by: Kevin M. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
6

Remove 0.00 from reports

Please remove 0.00 Dr/Cr column when there is no value. In the Sage 100 standard 2017 version, there we no 0.00 in the inactive columns for example is General Ledger ...

Comments (1) | by: Christine D. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
3

Allow word wrap for custom fields in the report writer

When creating custom reports and inserting custom fields, word wrap should be an option. Currently the text extends off the page and you cannot get it to wrap to the ...

Comments (0) | by: Season W. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
6

show Tax Exempt number in custom lookups and explore views

Include the Tax Exemption No from the AR_CustomerShipToTaxExemptions table to the customer maintenance lookup or onto the Customer View in Explorer. Or create a canned ...

Comments (0) | by: Christine K. | over a year ago | Last activity about a year ago | Status changed over a year ago | Reports / BI
Votes
12

Report that shows transactions entered by User Login

We would like to be able to pull a report that shows transactions, such as sales orders entered, by User Login. This would help us account for the time a task takes.

Comments (0) | by: Cindy S. | over a year ago | Last activity 4 months ago | Status changed over a year ago | Reports / BI
Votes
10

Add the PO_PurchaseOrderHistoryDetail.LineKey to the ...

Adding this field would make it possible to create a PO Clearing by Date report.

Comments (0) | by: Barbara K. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI
Votes
7

Credit Card Receipts - need a report that will allow us to print ...

We need a report that we can print, by credit card holder, that lists the payee name, amount and date purchased.

Comments (0) | by: Beth B. | over a year ago | Last activity over a year ago | Status changed over a year ago | Reports / BI

2,976	Ideas
3,855	Comments
44,458	Votes

1

1

1

5

5

2

13

4

2

19

9

13

5

2

6

3

6

12

10

7

By Category