SF.net SVN: ledger-smb:[6657] trunk/sql

[..hidden..]

Revision: 6657
          http://sourceforge.net/p/ledger-smb/code/6657
Author:   einhverfr
Date:     2014-01-27 03:08:08 +0000 (Mon, 27 Jan 2014)
Log Message:
-----------
Adding menu items for overpayment reversal (fixing bug 974)

Modified Paths:
--------------
    trunk/sql/Pg-database.sql
    trunk/sql/modules/Roles.sql
    trunk/sql/modules/menu_rebuild.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2014-01-27 02:37:13 UTC (rev 6656)
+++ trunk/sql/Pg-database.sql	2014-01-27 03:08:08 UTC (rev 6657)
@@ -2815,8 +2815,6 @@
 41	Reports	35	8
 45	Reconciliation	35	7
 132	Year End	73	3
-203	Receipts	200	3
-204	Reverse Receipts	200	4
 111	Trial Balance	109	1
 112	Income Statement	109	2
 60	Combine	50	5
@@ -2839,6 +2837,7 @@
 141	Warehouses	128	8
 222	Sessions	128	5
 225	List Tax Forms	217	2
+203	Receipts	200	4
 226	Reports	217	3
 228	Asset Classes	227	1
 229	Assets	227	2
@@ -2897,6 +2896,9 @@
 85	Reports	77	11
 98	Timecards	0	14
 17	Sequences	128	4
+204	Reverse Receipts	200	5
+18	Reverse Overpay	200	3
+26	Reverse AR Overpay	200	6
 \.
 
 
@@ -3348,7 +3350,7 @@
 184	template_name	receipt	517
 242	template_name	letterhead	649
 188	menu	1	521
-189	module	template.pl	522
+189	module	templates.pl	522
 189	action	display	523
 189	template_name	pos_invoice	524
 189	format	txt	525
@@ -3540,6 +3542,14 @@
 16	action	begin_adjust	179
 17	module	configuration.pl	206
 17	action	sequence_screen	207
+18	batch_type	payment_reversal	208
+18	module	vouchers.pl	209
+18	action	create_batch	210
+18	overpayment	1	211
+26	batch_type	receipt_reversal	212
+26	module	vouchers.pl	213
+26	action	create_batch	214
+26	overpayment	1	215
 \.
 
 

Modified: trunk/sql/modules/Roles.sql
===================================================================
--- trunk/sql/modules/Roles.sql	2014-01-27 02:37:13 UTC (rev 6656)
+++ trunk/sql/modules/Roles.sql	2014-01-27 03:08:08 UTC (rev 6657)
@@ -607,7 +607,7 @@
 SELECT lsmb__grant_role('payment_process', 'ap_transaction_list');
 SELECT lsmb__grant_role('payment_process', 'exchangerate_edit');
 SELECT lsmb__grant_menu('payment_process', node_id, 'allow')
-  FROM unnest(array[38, 43, 201, 202, 223]) node_id;
+  FROM unnest(array[18, 38, 43, 201, 202, 223]) node_id;
 
 SELECT lsmb__grant_perms('payment_process', 'ap', 'UPDATE');
 SELECT lsmb__grant_perms('payment_process', obj, 'ALL')
@@ -622,7 +622,7 @@
 SELECT lsmb__grant_role('receipt_process', 'ap_transaction_list');
 SELECT lsmb__grant_role('receipt_process', 'exchangerate_edit');
 SELECT lsmb__grant_menu('receipt_process', node_id, 'allow')
-  FROM unnest(array[36, 37, 42, 203, 204]) node_id;
+  FROM unnest(array[26, 36, 37, 42, 203, 204]) node_id;
 
 SELECT lsmb__grant_perms('receipt_process', 'ar', 'UPDATE');
 SELECT lsmb__grant_perms('receipt_process', obj, 'ALL')

Modified: trunk/sql/modules/menu_rebuild.sql
===================================================================
--- trunk/sql/modules/menu_rebuild.sql	2014-01-27 02:37:13 UTC (rev 6656)
+++ trunk/sql/modules/menu_rebuild.sql	2014-01-27 03:08:08 UTC (rev 6657)
@@ -799,6 +799,14 @@
 16	action	begin_adjust	179
 17	module	configuration.pl	206
 17	action	sequence_screen	207
+18	batch_type	payment_reversal	208
+18	module	vouchers.pl	209
+18	action	create_batch	210
+18	overpayment	1	211
+26	batch_type	receipt_reversal	212
+26	module	vouchers.pl	213
+26	action	create_batch	214
+26	overpayment	1	215
 \.
 
 
@@ -944,8 +952,6 @@
 41	Reports	35	8
 45	Reconciliation	35	7
 132	Year End	73	3
-203	Receipts	200	3
-204	Reverse Receipts	200	4
 111	Trial Balance	109	1
 112	Income Statement	109	2
 60	Combine	50	5
@@ -968,6 +974,7 @@
 141	Warehouses	128	8
 222	Sessions	128	5
 225	List Tax Forms	217	2
+203	Receipts	200	4
 226	Reports	217	3
 228	Asset Classes	227	1
 229	Assets	227	2
@@ -1026,6 +1033,9 @@
 85	Reports	77	11
 98	Timecards	0	14
 17	Sequences	128	4
+204	Reverse Receipts	200	5
+18	Reverse Overpay	200	3
+26	Reverse AR Overpay	200	6
 \.
 
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.


------------------------------------------------------------------------------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For
Critical Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-commits mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-commits