Added 'Item Like' parameter to Stock Sheet Report allowing SQL LIKE or regexp filteri...
[fa-stable.git] / reporting / reports_main.php
1 <?php
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 ***********************************************************************/
12 $path_to_root="..";
13 $page_security = 'SA_OPEN';
14 include_once($path_to_root . "/includes/session.inc");
15
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");
20 $js = "";
21 if ($use_date_picker)
22         $js .= get_js_date_picker();
23
24 add_js_file('reports.js');
25
26 page(_($help_context = "Reports and Analysis"), false, false, "", $js);
27
28 $reports = new BoxReports;
29
30 $dim = get_company_pref('use_dimension');
31
32 $reports->addReportClass(_('Customer'), RC_CUSTOMER);
33 $reports->addReport(RC_CUSTOMER, 101, _('Customer &Balances'),
34         array(  _('Start Date') => 'DATEBEGIN',
35                         _('End Date') => 'DATEENDM',
36                         _('Customer') => 'CUSTOMERS_NO_FILTER',
37                         _('Show Balance') => 'YES_NO',
38                         _('Currency Filter') => 'CURRENCY',
39                         _('Suppress Zeros') => 'YES_NO',
40                         _('Comments') => 'TEXTBOX',
41                         _('Orientation') => 'ORIENTATION',
42                         _('Destination') => 'DESTINATION'));
43 $reports->addReport(RC_CUSTOMER, 102, _('&Aged Customer Analysis'),
44         array(  _('End Date') => 'DATE',
45                         _('Customer') => 'CUSTOMERS_NO_FILTER',
46                         _('Currency Filter') => 'CURRENCY',
47                         _('Show Also Allocated') => 'YES_NO',
48                         _('Summary Only') => 'YES_NO',
49                         _('Suppress Zeros') => 'YES_NO',
50                         _('Graphics') => 'GRAPHIC',
51                         _('Comments') => 'TEXTBOX',
52                         _('Orientation') => 'ORIENTATION',
53                         _('Destination') => 'DESTINATION'));
54 $reports->addReport(RC_CUSTOMER, 103, _('Customer &Detail Listing'),
55         array(  _('Activity Since') => 'DATEBEGIN',
56                         _('Sales Areas') => 'AREAS',
57                         _('Sales Folk') => 'SALESMEN',
58                         _('Activity Greater Than') => 'TEXT',
59                         _('Activity Less Than') => 'TEXT',
60                         _('Comments') => 'TEXTBOX',
61                         _('Orientation') => 'ORIENTATION',
62                         _('Destination') => 'DESTINATION'));
63 $reports->addReport(RC_CUSTOMER, 114, _('Sales &Summary Report'),
64         array(  _('Start Date') => 'DATEBEGINTAX',
65                         _('End Date') => 'DATEENDTAX',
66                         _('Tax Id Only') => 'YES_NO',
67                         _('Comments') => 'TEXTBOX',
68                         _('Orientation') => 'ORIENTATION',
69                         _('Destination') => 'DESTINATION'));
70 $reports->addReport(RC_CUSTOMER, 104, _('&Price Listing'),
71         array(  _('Currency Filter') => 'CURRENCY',
72                         _('Inventory Category') => 'CATEGORIES',
73                         _('Sales Types') => 'SALESTYPES',
74                         _('Show Pictures') => 'YES_NO',
75                         _('Show GP %') => 'YES_NO',
76                         _('Comments') => 'TEXTBOX',
77                         _('Orientation') => 'ORIENTATION',
78                         _('Destination') => 'DESTINATION'));
79 $reports->addReport(RC_CUSTOMER, 105, _('&Order Status Listing'),
80         array(  _('Start Date') => 'DATEBEGINM',
81                         _('End Date') => 'DATEENDM',
82                         _('Inventory Category') => 'CATEGORIES',
83                         _('Stock Location') => 'LOCATIONS',
84                         _('Back Orders Only') => 'YES_NO',
85                         _('Comments') => 'TEXTBOX',
86                         _('Orientation') => 'ORIENTATION',
87                         _('Destination') => 'DESTINATION'));
88 $reports->addReport(RC_CUSTOMER, 106, _('&Salesman Listing'),
89         array(  _('Start Date') => 'DATEBEGINM',
90                         _('End Date') => 'DATEENDM',
91                         _('Summary Only') => 'YES_NO',
92                         _('Comments') => 'TEXTBOX',
93                         _('Orientation') => 'ORIENTATION',
94                         _('Destination') => 'DESTINATION'));
95 $reports->addReport(RC_CUSTOMER, 107, _('Print &Invoices'),
96         array(  _('From') => 'INVOICE',
97                         _('To') => 'INVOICE',
98                         _('Currency Filter') => 'CURRENCY',
99                         _('email Customers') => 'YES_NO',
100                         _('Payment Link') => 'PAYMENT_LINK',
101                         _('Comments') => 'TEXTBOX',
102                         _('Customer') => 'CUSTOMERS_NO_FILTER',
103                         _('Orientation') => 'ORIENTATION'
104 ));
105 $reports->addReport(RC_CUSTOMER, 113, _('Print &Credit Notes'),
106         array(  _('From') => 'CREDIT',
107                         _('To') => 'CREDIT',
108                         _('Currency Filter') => 'CURRENCY',
109                         _('email Customers') => 'YES_NO',
110                         _('Payment Link') => 'PAYMENT_LINK',
111                         _('Comments') => 'TEXTBOX',
112                         _('Orientation') => 'ORIENTATION'));
113 $reports->addReport(RC_CUSTOMER, 110, _('Print &Deliveries'),
114         array(  _('From') => 'DELIVERY',
115                         _('To') => 'DELIVERY',
116                         _('email Customers') => 'YES_NO',
117                         _('Print as Packing Slip') => 'YES_NO',
118                         _('Comments') => 'TEXTBOX',
119                         _('Orientation') => 'ORIENTATION'));
120 $reports->addReport(RC_CUSTOMER, 108, _('Print &Statements'),
121         array(  _('Customer') => 'CUSTOMERS_NO_FILTER',
122                         _('Currency Filter') => 'CURRENCY',
123                         _('Show Also Allocated') => 'YES_NO',
124                         _('Email Customers') => 'YES_NO',
125                         _('Comments') => 'TEXTBOX',
126                         _('Orientation') => 'ORIENTATION'));
127 $reports->addReport(RC_CUSTOMER, 109, _('&Print Sales Orders'),
128         array(  _('From') => 'ORDERS',
129                         _('To') => 'ORDERS',
130                         _('Currency Filter') => 'CURRENCY',
131                         _('Email Customers') => 'YES_NO',
132                         _('Print as Quote') => 'YES_NO',
133                         _('Comments') => 'TEXTBOX',
134                         _('Orientation') => 'ORIENTATION'));
135 $reports->addReport(RC_CUSTOMER, 111, _('&Print Sales Quotations'),
136         array(  _('From') => 'QUOTATIONS',
137                         _('To') => 'QUOTATIONS',
138                         _('Currency Filter') => 'CURRENCY',
139                         _('Email Customers') => 'YES_NO',
140                         _('Comments') => 'TEXTBOX',
141                         _('Orientation') => 'ORIENTATION'));
142 $reports->addReport(RC_CUSTOMER, 112, _('Print Receipts'),
143         array(  _('From') => 'RECEIPT',
144                         _('To') => 'RECEIPT',
145                         _('Currency Filter') => 'CURRENCY',
146                         _('Comments') => 'TEXTBOX',
147                         _('Orientation') => 'ORIENTATION'));
148
149 $reports->addReportClass(_('Supplier'), RC_SUPPLIER);
150 $reports->addReport(RC_SUPPLIER, 201, _('Supplier &Balances'),
151         array(  _('Start Date') => 'DATEBEGIN',
152                         _('End Date') => 'DATEENDM',
153                         _('Supplier') => 'SUPPLIERS_NO_FILTER',
154                         _('Show Balance') => 'YES_NO',
155                         _('Currency Filter') => 'CURRENCY',
156                         _('Suppress Zeros') => 'YES_NO',
157                         _('Comments') => 'TEXTBOX',
158                         _('Orientation') => 'ORIENTATION',
159                         _('Destination') => 'DESTINATION'));
160 $reports->addReport(RC_SUPPLIER, 202, _('&Aged Supplier Analyses'),
161         array(  _('End Date') => 'DATE',
162                         _('Supplier') => 'SUPPLIERS_NO_FILTER',
163                         _('Currency Filter') => 'CURRENCY',
164                         _('Show Also Allocated') => 'YES_NO',
165                         _('Summary Only') => 'YES_NO',
166                         _('Suppress Zeros') => 'YES_NO',
167                         _('Graphics') => 'GRAPHIC',
168                         _('Comments') => 'TEXTBOX',
169                         _('Orientation') => 'ORIENTATION',
170                         _('Destination') => 'DESTINATION'));
171 $reports->addReport(RC_SUPPLIER, 203, _('&Payment Report'),
172         array(  _('End Date') => 'DATE',
173                         _('Supplier') => 'SUPPLIERS_NO_FILTER',
174                         _('Currency Filter') => 'CURRENCY',
175                         _('Suppress Zeros') => 'YES_NO',
176                         _('Comments') => 'TEXTBOX',
177                         _('Orientation') => 'ORIENTATION',
178                         _('Destination') => 'DESTINATION'));
179 $reports->addReport(RC_SUPPLIER, 204, _('Outstanding &GRNs Report'),
180         array(  _('Supplier') => 'SUPPLIERS_NO_FILTER',
181                         _('Comments') => 'TEXTBOX',
182                         _('Orientation') => 'ORIENTATION',
183                         _('Destination') => 'DESTINATION'));
184 $reports->addReport(RC_SUPPLIER, 205, _('Supplier &Detail Listing'),
185         array(  _('Activity Since') => 'DATEBEGIN',
186                         _('Activity Greater Than') => 'TEXT',
187                         _('Activity Less Than') => 'TEXT',
188                         _('Comments') => 'TEXTBOX',
189                         _('Orientation') => 'ORIENTATION',
190                         _('Destination') => 'DESTINATION'));
191 $reports->addReport(RC_SUPPLIER, 209, _('Print Purchase &Orders'),
192         array(  _('From') => 'PO',
193                         _('To') => 'PO',
194                         _('Currency Filter') => 'CURRENCY',
195                         _('Email Customers') => 'YES_NO',
196                         _('Comments') => 'TEXTBOX',
197                         _('Orientation') => 'ORIENTATION'));
198 $reports->addReport(RC_SUPPLIER, 210, _('Print Remittances'),
199         array(  _('From') => 'REMITTANCE',
200                         _('To') => 'REMITTANCE',
201                         _('Currency Filter') => 'CURRENCY',
202                         _('Email Customers') => 'YES_NO',
203                         _('Comments') => 'TEXTBOX',
204                         _('Orientation') => 'ORIENTATION'));
205
206 $reports->addReportClass(_('Inventory'), RC_INVENTORY);
207 $reports->addReport(RC_INVENTORY,  301, _('Inventory &Valuation Report'),
208         array(  _('End Date') => 'DATE',        
209                         _('Inventory Category') => 'CATEGORIES',
210                         _('Location') => 'LOCATIONS',
211                         _('Summary Only') => 'YES_NO',
212                         _('Comments') => 'TEXTBOX',
213                         _('Orientation') => 'ORIENTATION',
214                         _('Destination') => 'DESTINATION'));
215 $reports->addReport(RC_INVENTORY,  302, _('Inventory &Planning Report'),
216         array(  _('Inventory Category') => 'CATEGORIES',
217                         _('Location') => 'LOCATIONS',
218                         _('Comments') => 'TEXTBOX',
219                         _('Orientation') => 'ORIENTATION',
220                         _('Destination') => 'DESTINATION'));
221 $reports->addReport(RC_INVENTORY, 303, _('Stock &Check Sheets'),
222         array(  _('Inventory Category') => 'CATEGORIES',
223                         _('Location') => 'LOCATIONS',
224                         _('Show Pictures') => 'YES_NO',
225                         _('Inventory Column') => 'YES_NO',
226                         _('Show Shortage') => 'YES_NO',
227                         _('Suppress Zeros') => 'YES_NO',
228                         _('Item Like') => 'TEXT',
229                         _('Comments') => 'TEXTBOX',
230                         _('Orientation') => 'ORIENTATION',
231                         _('Destination') => 'DESTINATION'));
232 $reports->addReport(RC_INVENTORY, 304, _('Inventory &Sales Report'),
233         array(  _('Start Date') => 'DATEBEGINM',
234                         _('End Date') => 'DATEENDM',
235                         _('Inventory Category') => 'CATEGORIES',
236                         _('Location') => 'LOCATIONS',
237                         _('Customer') => 'CUSTOMERS_NO_FILTER',
238                         _('Comments') => 'TEXTBOX',
239                         _('Orientation') => 'ORIENTATION',
240                         _('Destination') => 'DESTINATION'));
241 $reports->addReport(RC_INVENTORY, 305, _('&GRN Valuation Report'),
242         array(  _('Start Date') => 'DATEBEGINM',
243                         _('End Date') => 'DATEENDM',
244                         _('Comments') => 'TEXTBOX',
245                         _('Orientation') => 'ORIENTATION',
246                         _('Destination') => 'DESTINATION'));
247 $reports->addReport(RC_INVENTORY, 306, _('Inventory P&urchasing Report'),
248         array(  _('Start Date') => 'DATEBEGINM',
249                         _('End Date') => 'DATEENDM',
250                         _('Inventory Category') => 'CATEGORIES',
251                         _('Location') => 'LOCATIONS',
252                         _('Supplier') => 'SUPPLIERS_NO_FILTER',
253                         _('Items') => 'ITEMS_P',
254                         _('Comments') => 'TEXTBOX',
255                         _('Orientation') => 'ORIENTATION',
256                         _('Destination') => 'DESTINATION'));
257 $reports->addReport(RC_INVENTORY, 307, _('Inventory &Movement Report'),
258         array(  _('Start Date') => 'DATEBEGINM',
259                         _('End Date') => 'DATEENDM',
260                         _('Inventory Category') => 'CATEGORIES',
261                         _('Location') => 'LOCATIONS',
262                         _('Comments') => 'TEXTBOX',
263                         _('Orientation') => 'ORIENTATION',
264                         _('Destination') => 'DESTINATION'));                            
265 $reports->addReport(RC_INVENTORY, 308, _('C&osted Inventory Movement Report'),
266         array(  _('Start Date') => 'DATEBEGINM',
267                         _('End Date') => 'DATEENDM',
268                         _('Inventory Category') => 'CATEGORIES',
269                         _('Location') => 'LOCATIONS',
270                         _('Comments') => 'TEXTBOX',
271                         _('Orientation') => 'ORIENTATION',
272                         _('Destination') => 'DESTINATION'));                            
273 $reports->addReport(RC_INVENTORY, 309,_('Item &Sales Summary Report'),
274         array(  _('Start Date') => 'DATEBEGINM',
275                         _('End Date') => 'DATEENDM',
276                         _('Inventory Category') => 'CATEGORIES',
277                         _('Comments') => 'TEXTBOX',
278                         _('Orientation') => 'ORIENTATION',
279                         _('Destination') => 'DESTINATION'));                            
280
281 $reports->addReportClass(_('Manufacturing'), RC_MANUFACTURE);
282 $reports->addReport(RC_MANUFACTURE, 401, _('&Bill of Material Listing'),
283         array(  _('From product') => 'ITEMS',
284                         _('To product') => 'ITEMS',
285                         _('Comments') => 'TEXTBOX',
286                         _('Orientation') => 'ORIENTATION',
287                         _('Destination') => 'DESTINATION'));
288 $reports->addReport(RC_MANUFACTURE, 409, _('Print &Work Orders'),
289         array(  _('From') => 'WORKORDER',
290                         _('To') => 'WORKORDER',
291                         _('Email Locations') => 'YES_NO',
292                         _('Comments') => 'TEXTBOX',
293                         _('Orientation') => 'ORIENTATION'));
294 $reports->addReportClass(_('Dimensions'), RC_DIMENSIONS);
295 if ($dim > 0)
296 {
297         $reports->addReport(RC_DIMENSIONS, 501, _('Dimension &Summary'),
298         array(  _('From Dimension') => 'DIMENSION',
299                         _('To Dimension') => 'DIMENSION',
300                         _('Show Balance') => 'YES_NO',
301                         _('Comments') => 'TEXTBOX',
302                         _('Orientation') => 'ORIENTATION',
303                         _('Destination') => 'DESTINATION'));
304         //$reports->addReport(_('Dimensions'),502, _('Dimension Details'),
305         //array(        _('Dimension'),'DIMENSIONS'),
306         //              _('Comments'),'TEXTBOX')));
307 }
308 $reports->addReportClass(_('Banking'), RC_BANKING);
309         $reports->addReport(RC_BANKING,  601, _('Bank &Statement'),
310         array(  _('Bank Accounts') => 'BANK_ACCOUNTS',
311                         _('Start Date') => 'DATEBEGINM',
312                         _('End Date') => 'DATEENDM',
313                         _('Zero values') => 'YES_NO',
314                         _('Comments') => 'TEXTBOX',
315                         _('Orientation') => 'ORIENTATION',
316                         _('Destination') => 'DESTINATION'));
317
318 $reports->addReportClass(_('General Ledger'), RC_GL);
319 $reports->addReport(RC_GL, 701, _('Chart of &Accounts'),
320         array(  _('Show Balances') => 'YES_NO',
321                         _('Comments') => 'TEXTBOX',
322                         _('Orientation') => 'ORIENTATION',
323                         _('Destination') => 'DESTINATION'));
324 $reports->addReport(RC_GL, 702, _('List of &Journal Entries'),
325         array(  _('Start Date') => 'DATEBEGINM',
326                         _('End Date') => 'DATEENDM',
327                         _('Type') => 'SYS_TYPES',
328                         _('Comments') => 'TEXTBOX',
329                         _('Orientation') => 'ORIENTATION',
330                         _('Destination') => 'DESTINATION'));
331 //$reports->addReport(RC_GL, 703, _('GL Account Group Summary'),
332 //      array(  _('Comments'),'TEXTBOX')));
333
334 if ($dim == 2)
335 {
336         $reports->addReport(RC_GL, 704, _('GL Account &Transactions'),
337         array(  _('Start Date') => 'DATEBEGINM',
338                         _('End Date') => 'DATEENDM',
339                         _('From Account') => 'GL_ACCOUNTS',
340                         _('To Account') => 'GL_ACCOUNTS',
341                         _('Dimension')." 1" =>  'DIMENSIONS1',
342                         _('Dimension')." 2" =>  'DIMENSIONS2',
343                         _('Comments') => 'TEXTBOX',
344                         _('Orientation') => 'ORIENTATION',
345                         _('Destination') => 'DESTINATION'));
346         $reports->addReport(RC_GL, 705, _('Annual &Expense Breakdown'),
347         array(  _('Year') => 'TRANS_YEARS',
348                         _('Dimension')." 1" =>  'DIMENSIONS1',
349                         _('Dimension')." 2" =>  'DIMENSIONS2',
350                         _('Account Tags') =>  'ACCOUNTTAGS',
351                         _('Comments') => 'TEXTBOX',
352                         _('Orientation') => 'ORIENTATION',
353                         _('Destination') => 'DESTINATION'));
354         $reports->addReport(RC_GL, 706, _('&Balance Sheet'),
355         array(  _('Start Date') => 'DATEBEGIN',
356                         _('End Date') => 'DATEENDM',
357                         _('Dimension')." 1" => 'DIMENSIONS1',
358                         _('Dimension')." 2" => 'DIMENSIONS2',
359                         _('Account Tags') =>  'ACCOUNTTAGS',
360                         _('Decimal values') => 'YES_NO',
361                         _('Graphics') => 'GRAPHIC',
362                         _('Comments') => 'TEXTBOX',
363                         _('Orientation') => 'ORIENTATION',
364                         _('Destination') => 'DESTINATION'));
365         $reports->addReport(RC_GL, 707, _('&Profit and Loss Statement'),
366         array(  _('Start Date') => 'DATEBEGINM',
367                         _('End Date') => 'DATEENDM',
368                         _('Compare to') => 'COMPARE',
369                         _('Dimension')." 1" =>  'DIMENSIONS1',
370                         _('Dimension')." 2" =>  'DIMENSIONS2',
371                         _('Account Tags') =>  'ACCOUNTTAGS',
372                         _('Decimal values') => 'YES_NO',
373                         _('Graphics') => 'GRAPHIC',
374                         _('Comments') => 'TEXTBOX',
375                         _('Orientation') => 'ORIENTATION',
376                         _('Destination') => 'DESTINATION'));
377         $reports->addReport(RC_GL, 708, _('Trial &Balance'),
378         array(  _('Start Date') => 'DATEBEGINM',
379                         _('End Date') => 'DATEENDM',
380                         _('Zero values') => 'YES_NO',
381                         _('Only balances') => 'YES_NO',
382                         _('Dimension')." 1" =>  'DIMENSIONS1',
383                         _('Dimension')." 2" =>  'DIMENSIONS2',
384                         _('Comments') => 'TEXTBOX',
385                         _('Orientation') => 'ORIENTATION',
386                         _('Destination') => 'DESTINATION'));
387 }
388 else if ($dim == 1)
389 {
390         $reports->addReport(RC_GL, 704, _('GL Account &Transactions'),
391         array(  _('Start Date') => 'DATEBEGINM',
392                         _('End Date') => 'DATEENDM',
393                         _('From Account') => 'GL_ACCOUNTS',
394                         _('To Account') => 'GL_ACCOUNTS',
395                         _('Dimension') =>  'DIMENSIONS1',
396                         _('Comments') => 'TEXTBOX',
397                         _('Orientation') => 'ORIENTATION',
398                         _('Destination') => 'DESTINATION'));
399         $reports->addReport(RC_GL, 705, _('Annual &Expense Breakdown'),
400         array(  _('Year') => 'TRANS_YEARS',
401                         _('Dimension') =>  'DIMENSIONS1',
402                         _('Account Tags') =>  'ACCOUNTTAGS',
403                         _('Comments') => 'TEXTBOX',
404                         _('Orientation') => 'ORIENTATION',
405                         _('Destination') => 'DESTINATION'));
406         $reports->addReport(RC_GL, 706, _('&Balance Sheet'),
407         array(  _('Start Date') => 'DATEBEGIN',
408                         _('End Date') => 'DATEENDM',
409                         _('Dimension') => 'DIMENSIONS1',
410                         _('Account Tags') =>  'ACCOUNTTAGS',
411                         _('Decimal values') => 'YES_NO',
412                         _('Graphics') => 'GRAPHIC',
413                         _('Comments') => 'TEXTBOX',
414                         _('Orientation') => 'ORIENTATION',
415                         _('Destination') => 'DESTINATION'));
416         $reports->addReport(RC_GL, 707, _('&Profit and Loss Statement'),
417         array(  _('Start Date') => 'DATEBEGINM',
418                         _('End Date') => 'DATEENDM',
419                         _('Compare to') => 'COMPARE',
420                         _('Dimension') => 'DIMENSIONS1',
421                         _('Account Tags') =>  'ACCOUNTTAGS',
422                         _('Decimal values') => 'YES_NO',
423                         _('Graphics') => 'GRAPHIC',
424                         _('Comments') => 'TEXTBOX',
425                         _('Orientation') => 'ORIENTATION',
426                         _('Destination') => 'DESTINATION'));
427         $reports->addReport(RC_GL, 708, _('Trial &Balance'),
428         array(  _('Start Date') => 'DATEBEGINM',
429                         _('End Date') => 'DATEENDM',
430                         _('Zero values') => 'YES_NO',
431                         _('Only balances') => 'YES_NO',
432                         _('Dimension') => 'DIMENSIONS1',
433                         _('Comments') => 'TEXTBOX',
434                         _('Orientation') => 'ORIENTATION',
435                         _('Destination') => 'DESTINATION'));
436 }
437 else
438 {
439         $reports->addReport(RC_GL, 704, _('GL Account &Transactions'),
440         array(  _('Start Date') => 'DATEBEGINM',
441                         _('End Date') => 'DATEENDM',
442                         _('From Account') => 'GL_ACCOUNTS',
443                         _('To Account') => 'GL_ACCOUNTS',
444                         _('Comments') => 'TEXTBOX',
445                         _('Orientation') => 'ORIENTATION',
446                         _('Destination') => 'DESTINATION'));
447         $reports->addReport(RC_GL, 705, _('Annual &Expense Breakdown'),
448         array(  _('Year') => 'TRANS_YEARS',
449                         _('Account Tags') =>  'ACCOUNTTAGS',
450                         _('Comments') => 'TEXTBOX',
451                         _('Orientation') => 'ORIENTATION',
452                         _('Destination') => 'DESTINATION'));
453         $reports->addReport(RC_GL, 706, _('&Balance Sheet'),
454         array(  _('Start Date') => 'DATEBEGIN',
455                         _('End Date') => 'DATEENDM',
456                         _('Account Tags') =>  'ACCOUNTTAGS',
457                         _('Decimal values') => 'YES_NO',
458                         _('Graphics') => 'GRAPHIC',
459                         _('Comments') => 'TEXTBOX',
460                         _('Orientation') => 'ORIENTATION',
461                         _('Destination') => 'DESTINATION'));
462         $reports->addReport(RC_GL, 707, _('&Profit and Loss Statement'),
463         array(  _('Start Date') => 'DATEBEGINM',
464                         _('End Date') => 'DATEENDM',
465                         _('Compare to') => 'COMPARE',
466                         _('Account Tags') =>  'ACCOUNTTAGS',
467                         _('Decimal values') => 'YES_NO',
468                         _('Graphics') => 'GRAPHIC',
469                         _('Comments') => 'TEXTBOX',
470                         _('Orientation') => 'ORIENTATION',
471                         _('Destination') => 'DESTINATION'));
472         $reports->addReport(RC_GL, 708, _('Trial &Balance'),
473         array(  _('Start Date') => 'DATEBEGINM',
474                         _('End Date') => 'DATEENDM',
475                         _('Zero values') => 'YES_NO',
476                         _('Only balances') => 'YES_NO',
477                         _('Comments') => 'TEXTBOX',
478                         _('Orientation') => 'ORIENTATION',
479                         _('Destination') => 'DESTINATION'));
480 }
481 $reports->addReport(RC_GL, 709, _('Ta&x Report'),
482         array(  _('Start Date') => 'DATEBEGINTAX',
483                         _('End Date') => 'DATEENDTAX',
484                         _('Summary Only') => 'YES_NO',
485                         _('Comments') => 'TEXTBOX',
486                         _('Orientation') => 'ORIENTATION',
487                         _('Destination') => 'DESTINATION'));
488 $reports->addReport(RC_GL, 710, _('Audit Trail'),
489         array(  _('Start Date') => 'DATEBEGINM',
490                         _('End Date') => 'DATEENDM',
491                         _('Type') => 'SYS_TYPES_ALL',
492                         _('User') => 'USERS',
493                         _('Comments') => 'TEXTBOX',
494                         _('Orientation') => 'ORIENTATION',
495                         _('Destination') => 'DESTINATION'));
496
497 add_custom_reports($reports);
498
499 echo $reports->getDisplay();
500
501 end_page();
502 ?>