For some time now I've wanted to come up with a way for non-IT users to be able to easily and quickly develop G/L Reports. With that goal in mind I've been working on a workbook that (to begin with) pulls all the G/L Master records for the current month which will be "pulled" into the report by entering a range of valid G/L Accounts. One of my Customers was kind enough to assist me with this but thought I would use the Blog to see if anyone else is interested in this project and if so would be willing to provide input. Below is a prototype of the workbook. For simplification in this workbook I'm only using Main Account Number (GLNO03) and the Branch Number (GLNO06) to pull the Current Month Net Change Amount (GLAM01). The From and Too Main Accounts and Branch Number are entered in Columns B thru E. Columns F and G contain formulas to convert the Main Account and Branch into a Code that is used in the formulas that return the Amount in Column O. Columns J and K contain formulas that display an error message if the Codes in Columns F and G are invalid. User enters Headings, Sub-Headings, Descriptions and sub-totals in columns L, M, N and P respectively.
Well, that's what I've got so far. I would really appreciate any input that you would be willing to share. Leave a comment or email me regarding any suggestions or if you would like to have a copy of the workbook.
Columns B thru K should be hidden with the report is complete.
No comments:
Post a Comment