2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
13 $page_security = 'SA_OPEN';
14 include_once($path_to_root . "/includes/session.inc");
16 include_once($path_to_root . "/includes/date_functions.inc");
17 include_once($path_to_root . "/includes/data_checks.inc");
18 include_once($path_to_root . "/includes/ui.inc");
19 include_once($path_to_root . "/reporting/includes/reports_classes.inc");
22 $js .= get_js_date_picker();
23 page(_($help_context = "Reports and Analysis"), false, false, "", $js);
25 $reports = new BoxReports;
27 $dim = get_company_pref('use_dimension');
29 $reports->addReportClass(_('Customer'));
30 $reports->addReport(_('Customer'),101,_('Customer &Balances'),
31 array( _('Start Date') => 'DATEBEGIN',
32 _('End Date') => 'DATEENDM',
33 _('Customer') => 'CUSTOMERS_NO_FILTER',
34 _('Currency Filter') => 'CURRENCY',
35 _('Comments') => 'TEXTBOX',
36 _('Destination') => 'DESTINATION'));
37 $reports->addReport(_('Customer'),102,_('&Aged Customer Analysis'),
38 array( _('End Date') => 'DATE',
39 _('Customer') => 'CUSTOMERS_NO_FILTER',
40 _('Currency Filter') => 'CURRENCY',
41 _('Summary Only') => 'YES_NO',
42 _('Graphics') => 'GRAPHIC',
43 _('Comments') => 'TEXTBOX',
44 _('Destination') => 'DESTINATION'));
45 $reports->addReport(_('Customer'),103,_('Customer &Detail Listing'),
46 array( _('Activity Since') => 'DATEBEGIN',
47 _('Sales Areas') => 'AREAS',
48 _('Sales Folk') => 'SALESMEN',
49 _('Activity Greater Than') => 'TEXT',
50 _('Activity Less Than') => 'TEXT',
51 _('Comments') => 'TEXTBOX',
52 _('Destination') => 'DESTINATION'));
53 $reports->addReport(_('Customer'),104,_('&Price Listing'),
54 array( _('Currency Filter') => 'CURRENCY',
55 _('Inventory Category') => 'CATEGORIES',
56 _('Sales Types') => 'SALESTYPES',
57 _('Show Pictures') => 'YES_NO',
58 _('Show GP %') => 'YES_NO',
59 _('Comments') => 'TEXTBOX',
60 _('Destination') => 'DESTINATION'));
61 $reports->addReport(_('Customer'),105,_('&Order Status Listing'),
62 array( _('Start Date') => 'DATEBEGINM',
63 _('End Date') => 'DATEENDM',
64 _('Inventory Category') => 'CATEGORIES',
65 _('Stock Location') => 'LOCATIONS',
66 _('Back Orders Only') => 'YES_NO',
67 _('Comments') => 'TEXTBOX',
68 _('Destination') => 'DESTINATION'));
69 $reports->addReport(_('Customer'),106,_('&Salesman Listing'),
70 array( _('Start Date') => 'DATEBEGINM',
71 _('End Date') => 'DATEENDM',
72 _('Summary Only') => 'YES_NO',
73 _('Comments') => 'TEXTBOX',
74 _('Destination') => 'DESTINATION'));
75 $reports->addReport(_('Customer'),107,_('Print &Invoices/Credit Notes'),
76 array( _('From') => 'INVOICE',
78 _('Currency Filter') => 'CURRENCY',
79 _('email Customers') => 'YES_NO',
80 _('Payment Link') => 'PAYMENT_LINK',
81 _('Comments') => 'TEXTBOX'));
82 $reports->addReport(_('Customer'),110,_('Print &Deliveries'),
83 array( _('From') => 'DELIVERY',
84 _('To') => 'DELIVERY',
85 _('email Customers') => 'YES_NO',
86 _('Print as Packing Slip') => 'YES_NO',
87 _('Comments') => 'TEXTBOX'));
88 $reports->addReport(_('Customer'),108,_('Print &Statements'),
89 array( _('Customer') => 'CUSTOMERS_NO_FILTER',
90 _('Currency Filter') => 'CURRENCY',
91 _('Email Customers') => 'YES_NO',
92 _('Comments') => 'TEXTBOX'));
93 $reports->addReport(_('Customer'),109,_('&Print Sales Orders'),
94 array( _('From') => 'ORDERS',
96 _('Currency Filter') => 'CURRENCY',
97 _('Email Customers') => 'YES_NO',
98 _('Print as Quote') => 'YES_NO',
99 _('Comments') => 'TEXTBOX'));
100 $reports->addReport(_('Customer'),111,_('&Print Sales Quotations'),
101 array( _('From') => 'QUOTATIONS',
102 _('To') => 'QUOTATIONS',
103 _('Currency Filter') => 'CURRENCY',
104 _('Email Customers') => 'YES_NO',
105 _('Comments') => 'TEXTBOX'));
107 $reports->addReportClass(_('Supplier'));
108 $reports->addReport(_('Supplier'),201,_('Supplier &Balances'),
109 array( _('Start Date') => 'DATEBEGIN',
110 _('End Date') => 'DATEENDM',
111 _('Supplier') => 'SUPPLIERS_NO_FILTER',
112 _('Currency Filter') => 'CURRENCY',
113 _('Comments') => 'TEXTBOX',
114 _('Destination') => 'DESTINATION'));
115 $reports->addReport(_('Supplier'),202,_('&Aged Supplier Analyses'),
116 array( _('End Date') => 'DATE',
117 _('Supplier') => 'SUPPLIERS_NO_FILTER',
118 _('Currency Filter') => 'CURRENCY',
119 _('Summary Only') => 'YES_NO',
120 _('Graphics') => 'GRAPHIC',
121 _('Comments') => 'TEXTBOX',
122 _('Destination') => 'DESTINATION'));
123 $reports->addReport(_('Supplier'),203,_('&Payment Report'),
124 array( _('End Date') => 'DATE',
125 _('Supplier') => 'SUPPLIERS_NO_FILTER',
126 _('Currency Filter') => 'CURRENCY',
127 _('Comments') => 'TEXTBOX',
128 _('Destination') => 'DESTINATION'));
129 $reports->addReport(_('Supplier'),204,_('Outstanding &GRNs Report'),
130 array( _('Supplier') => 'SUPPLIERS_NO_FILTER',
131 _('Comments') => 'TEXTBOX',
132 _('Destination') => 'DESTINATION'));
133 $reports->addReport(_('Supplier'),209,_('Print Purchase &Orders'),
134 array( _('From') => 'PO',
136 _('Currency Filter') => 'CURRENCY',
137 _('Email Customers') => 'YES_NO',
138 _('Comments') => 'TEXTBOX'));
139 $reports->addReport(_('Supplier'),210,_('Print Remittances'),
140 array( _('From') => 'REMITTANCE',
141 _('To') => 'REMITTANCE',
142 _('Currency Filter') => 'CURRENCY',
143 _('Email Customers') => 'YES_NO',
144 _('Comments') => 'TEXTBOX'));
146 $reports->addReportClass(_('Inventory'));
147 $reports->addReport(_('Inventory'),301,_('Inventory &Valuation Report'),
148 array( _('Inventory Category') => 'CATEGORIES',
149 _('Location') => 'LOCATIONS',
150 _('Summary Only') => 'YES_NO',
151 _('Comments') => 'TEXTBOX',
152 _('Destination') => 'DESTINATION'));
153 $reports->addReport(_('Inventory'),302,_('Inventory &Planning Report'),
154 array( _('Inventory Category') => 'CATEGORIES',
155 _('Location') => 'LOCATIONS',
156 _('Comments') => 'TEXTBOX',
157 _('Destination') => 'DESTINATION'));
158 $reports->addReport(_('Inventory'),303,_('Stock &Check Sheets'),
159 array( _('Inventory Category') => 'CATEGORIES',
160 _('Location') => 'LOCATIONS',
161 _('Show Pictures') => 'YES_NO',
162 _('Inventory Column') => 'YES_NO',
163 _('Show Shortage') => 'YES_NO',
164 _('Comments') => 'TEXTBOX',
165 _('Destination') => 'DESTINATION'));
166 $reports->addReport(_('Inventory'),304,_('Inventory &Sales Report'),
167 array( _('Start Date') => 'DATEBEGINM',
168 _('End Date') => 'DATEENDM',
169 _('Inventory Category') => 'CATEGORIES',
170 _('Location') => 'LOCATIONS',
171 _('Customer') => 'CUSTOMERS_NO_FILTER',
172 _('Comments') => 'TEXTBOX',
173 _('Destination') => 'DESTINATION'));
174 $reports->addReport(_('Inventory'),305,_('&GRN Valuation Report'),
175 array( _('Start Date') => 'DATEBEGINM',
176 _('End Date') => 'DATEENDM',
177 _('Comments') => 'TEXTBOX',
178 _('Destination') => 'DESTINATION'));
180 $reports->addReportClass(_('Manufacturing'));
181 $reports->addReport(_('Manufacturing'),401,_('&Bill of Material Listing'),
182 array( _('From product') => 'ITEMS',
183 _('To product') => 'ITEMS',
184 _('Comments') => 'TEXTBOX',
185 _('Destination') => 'DESTINATION'));
186 $reports->addReport(_('Manufacturing'),409,_('Print &Work Orders'),
187 array( _('From') => 'WORKORDER',
188 _('To') => 'WORKORDER',
189 _('Email Locations') => 'YES_NO',
190 _('Comments') => 'TEXTBOX'));
191 $reports->addReportClass(_('Dimensions'));
194 $reports->addReport(_('Dimensions'),501,_('Dimension &Summary'),
195 array( _('From Dimension') => 'DIMENSION',
196 _('To Dimension') => 'DIMENSION',
197 _('Show Balance') => 'YES_NO',
198 _('Comments') => 'TEXTBOX',
199 _('Destination') => 'DESTINATION'));
200 //$reports->addReport(_('Dimensions'),502,_('Dimension Details'),
201 //array( _('Dimension'),'DIMENSIONS'),
202 // _('Comments'),'TEXTBOX')));
204 $reports->addReportClass(_('Banking'));
205 $reports->addReport(_('Banking'),601,_('Bank &Statement'),
206 array( _('Bank Accounts') => 'BANK_ACCOUNTS',
207 _('Start Date') => 'DATEBEGINM',
208 _('End Date') => 'DATEENDM',
209 _('Comments') => 'TEXTBOX',
210 _('Destination') => 'DESTINATION'));
212 $reports->addReportClass(_('General Ledger'));
213 $reports->addReport(_('General Ledger'),701,_('Chart of &Accounts'),
214 array( _('Show Balances') => 'YES_NO',
215 _('Comments') => 'TEXTBOX',
216 _('Destination') => 'DESTINATION'));
217 $reports->addReport(_('General Ledger'),702,_('List of &Journal Entries'),
218 array( _('Start Date') => 'DATEBEGINM',
219 _('End Date') => 'DATEENDM',
220 _('Type') => 'SYS_TYPES',
221 _('Comments') => 'TEXTBOX',
222 _('Destination') => 'DESTINATION'));
223 //$reports->addReport(_('General Ledger'),703,_('GL Account Group Summary'),
224 // array( _('Comments'),'TEXTBOX')));
228 $reports->addReport(_('General Ledger'),704,_('GL Account &Transactions'),
229 array( _('Start Date') => 'DATEBEGINM',
230 _('End Date') => 'DATEENDM',
231 _('From Account') => 'GL_ACCOUNTS',
232 _('To Account') => 'GL_ACCOUNTS',
233 _('Dimension')." 1" => 'DIMENSIONS1',
234 _('Dimension')." 2" => 'DIMENSIONS2',
235 _('Comments') => 'TEXTBOX',
236 _('Destination') => 'DESTINATION'));
237 $reports->addReport(_('General Ledger'),705,_('Annual &Expense Breakdown'),
238 array( _('Year') => 'TRANS_YEARS',
239 _('Dimension')." 1" => 'DIMENSIONS1',
240 _('Dimension')." 2" => 'DIMENSIONS2',
241 _('Comments') => 'TEXTBOX',
242 _('Destination') => 'DESTINATION'));
243 $reports->addReport(_('General Ledger'),706,_('&Balance Sheet'),
244 array( _('Start Date') => 'DATEBEGIN',
245 _('End Date') => 'DATEENDM',
246 _('Dimension')." 1" => 'DIMENSIONS1',
247 _('Dimension')." 2" => 'DIMENSIONS2',
248 _('Graphics') => 'GRAPHIC',
249 _('Comments') => 'TEXTBOX',
250 _('Destination') => 'DESTINATION'));
251 $reports->addReport(_('General Ledger'),707,_('&Profit and Loss Statement'),
252 array( _('Start Date') => 'DATEBEGINM',
253 _('End Date') => 'DATEENDM',
254 _('Compare to') => 'COMPARE',
255 _('Dimension')." 1" => 'DIMENSIONS1',
256 _('Dimension')." 2" => 'DIMENSIONS2',
257 _('Graphics') => 'GRAPHIC',
258 _('Comments') => 'TEXTBOX',
259 _('Destination') => 'DESTINATION'));
260 $reports->addReport(_('General Ledger'),708,_('Trial &Balance'),
261 array( _('Start Date') => 'DATEBEGINM',
262 _('End Date') => 'DATEENDM',
263 _('Zero values') => 'YES_NO',
264 _('Only balances') => 'YES_NO',
265 _('Dimension')." 1" => 'DIMENSIONS1',
266 _('Dimension')." 2" => 'DIMENSIONS2',
267 _('Comments') => 'TEXTBOX',
268 _('Destination') => 'DESTINATION'));
272 $reports->addReport(_('General Ledger'),704,_('GL Account &Transactions'),
273 array( _('Start Date') => 'DATEBEGINM',
274 _('End Date') => 'DATEENDM',
275 _('From Account') => 'GL_ACCOUNTS',
276 _('To Account') => 'GL_ACCOUNTS',
277 _('Dimension') => 'DIMENSIONS1',
278 _('Comments') => 'TEXTBOX',
279 _('Destination') => 'DESTINATION'));
280 $reports->addReport(_('General Ledger'),705,_('Annual &Expense Breakdown'),
281 array( _('Year') => 'TRANS_YEARS',
282 _('Dimension') => 'DIMENSIONS1',
283 _('Comments') => 'TEXTBOX',
284 _('Destination') => 'DESTINATION'));
285 $reports->addReport(_('General Ledger'),706,_('&Balance Sheet'),
286 array( _('Start Date') => 'DATEBEGIN',
287 _('End Date') => 'DATEENDM',
288 _('Dimension') => 'DIMENSIONS1',
289 _('Graphics') => 'GRAPHIC',
290 _('Comments') => 'TEXTBOX',
291 _('Destination') => 'DESTINATION'));
292 $reports->addReport(_('General Ledger'),707,_('&Profit and Loss Statement'),
293 array( _('Start Date') => 'DATEBEGINM',
294 _('End Date') => 'DATEENDM',
295 _('Compare to') => 'COMPARE',
296 _('Dimension') => 'DIMENSIONS1',
297 _('Graphics') => 'GRAPHIC',
298 _('Comments') => 'TEXTBOX',
299 _('Destination') => 'DESTINATION'));
300 $reports->addReport(_('General Ledger'),708,_('Trial &Balance'),
301 array( _('Start Date') => 'DATEBEGINM',
302 _('End Date') => 'DATEENDM',
303 _('Zero values') => 'YES_NO',
304 _('Only balances') => 'YES_NO',
305 _('Dimension') => 'DIMENSIONS1',
306 _('Comments') => 'TEXTBOX',
307 _('Destination') => 'DESTINATION'));
311 $reports->addReport(_('General Ledger'),704,_('GL Account &Transactions'),
312 array( _('Start Date') => 'DATEBEGINM',
313 _('End Date') => 'DATEENDM',
314 _('From Account') => 'GL_ACCOUNTS',
315 _('To Account') => 'GL_ACCOUNTS',
316 _('Comments') => 'TEXTBOX',
317 _('Destination') => 'DESTINATION'));
318 $reports->addReport(_('General Ledger'),705,_('Annual &Expense Breakdown'),
319 array( _('Year') => 'TRANS_YEARS',
320 _('Comments') => 'TEXTBOX',
321 _('Destination') => 'DESTINATION'));
322 $reports->addReport(_('General Ledger'),706,_('&Balance Sheet'),
323 array( _('Start Date') => 'DATEBEGIN',
324 _('End Date') => 'DATEENDM',
325 _('Graphics') => 'GRAPHIC',
326 _('Comments') => 'TEXTBOX',
327 _('Destination') => 'DESTINATION'));
328 $reports->addReport(_('General Ledger'),707,_('&Profit and Loss Statement'),
329 array( _('Start Date') => 'DATEBEGINM',
330 _('End Date') => 'DATEENDM',
331 _('Compare to') => 'COMPARE',
332 _('Graphics') => 'GRAPHIC',
333 _('Comments') => 'TEXTBOX',
334 _('Destination') => 'DESTINATION'));
335 $reports->addReport(_('General Ledger'),708,_('Trial &Balance'),
336 array( _('Start Date') => 'DATEBEGINM',
337 _('End Date') => 'DATEENDM',
338 _('Zero values') => 'YES_NO',
339 _('Only balances') => 'YES_NO',
340 _('Comments') => 'TEXTBOX',
341 _('Destination') => 'DESTINATION'));
343 $reports->addReport(_('General Ledger'),709,_('Ta&x Report'),
344 array( _('Start Date') => 'DATEBEGINTAX',
345 _('End Date') => 'DATEENDTAX',
346 _('Summary Only') => 'YES_NO',
347 _('Comments') => 'TEXTBOX'));
348 $reports->addReport(_('General Ledger'),710,_('Audit Trail'),
349 array( _('Start Date') => 'DATEBEGINM',
350 _('End Date') => 'DATEENDM',
351 _('Type') => 'SYS_TYPES_ALL',
352 _('User') => 'USERS',
353 _('Comments') => 'TEXTBOX',
354 _('Destination') => 'DESTINATION'));
356 add_custom_reports($reports);
358 echo "<script language='javascript'>
359 function onWindowLoad() {
360 showClass(" . $_GET['Class'] . ")
362 Behaviour.addLoadEvent(onWindowLoad);
365 echo $reports->getDisplay();