Excel Reporting to data criteria & increase maximum rows limit
Excel reporting has the potential to be very useful, there are 2 limitations that make is not so useful. 1. There is an upper limit of 1 million rows, whilst this may appear to be a high number it is nowhere as high as can be seen in some SQL tabl...
Assign payments and receipts to suppliers/customers
When entering a payment or receipt directly from the bank account page, it would be useful to be able to assign that payment/ receipt to a supplier or customer.
Guest
over 4 years ago
in Payment/Receipt
2
Further Information Required
Nominal Payments and Receipts - do not allow postings to Control A/Cs specified in Nominal Default Accounts
Users are able to post Nominal Payments and Receipts(Taxableand Non Taxable) to Control A/Cs- this can ends up making Control A/Cs go out of balance eg Debtors Control - the system should not allow these postings. The Debtors and Creditors Reconci...
Saeed Malik
over 10 years ago
in Payment/Receipt
0
Idea Accepted - Gauging Support
Allow multiple Excel reports to be updateable/ viewable
Within Excel reports there is a check box column down the left side allowing selection of multiple reports. Current functionality greys out the Update and View buttons when more than one report is selected. Could the check boxes be removed to less...
Guest
about 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
Provide a list of all unallocated cash/cheques transactions
We enter debit/credit card transactions on a daily basis. We allocate the amount against the residents account .Difficulty we have is we're unable to run a list of all unallocated cash transactions. At month end we're unable to allocate cash for 1...
When creating the Balance Sheet in the excel reporting area, all PL AND Balance Sheet reporting categories are shown, it would be much more efficient if the B/Sheet behaved like the old style financial statement layouts and could have the system g...
Guest
over 7 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
Ability to enter bank charges on non-currency receipts and payments
My client has requested the ability to enter bank charges on receipts and payments on both home currency and foreign currency transactions. Currently this is only available on currency transactions.
Michelle White
almost 10 years ago
in Payment/Receipt
0
Will not implement
Batch deposits to individual invoices rather than customers
It would be really useful to do a batch deposits by selecting individual invoices rather than customers. For example, where we have a group of customers that all pay via one payment and send a remittance that lists the individual invoice numbers t...
Guest
about 4 years ago
in Payment/Receipt
0
Idea Accepted - Gauging Support
Ability to create an Excel Workbook based on any area within Sage 200
I frequently have to create SQL Views via an ODBC link in Excel to get additional Excel based reports. Please provide a method to create our own reports and allow these to be linked to most if not all areas within Sage 200 including Project Accoun...
Guest
over 8 years ago
in Excel Reporting
0
Idea Accepted - Gauging Support
