UPDATE _sys_menu
SET urls = '#'
WHERE fldid = 100;

/*
 * CUSTOMER SECTION
 * @author NurSalikeen Saparai <salikeen@salihin.com.my>
 */

## Customer Bad Debt Relief
UPDATE
	_sys_menu
SET
	code = 'CUSRLFTX',
	name = 'CustomerBadDebtRelief',
	urls = 'gstReport/BadDebtRelief/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 357;
UPDATE user_module_access_details SET menuCode = 'CUSRLFTX' WHERE menuCode = 'GSBADRLF';

## Customer Bad Debt Relief Confirm
UPDATE
	_sys_menu
SET
	code = 'CUSRLFCF',
	name = 'CustomerBadDebtReliefConfirm',
	urls = 'gstReport/BadDebtReliefConfirm/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 358;
UPDATE user_module_access_details SET menuCode = 'CUSRLFCO' WHERE menuCode = 'BADBTRLC';

## Customer Bad Debt Relief Report
UPDATE
	_sys_menu
SET
	code = 'CUSRLFRP',
	name = 'CustomerBadDebtReliefReport',
	urls = 'gstReport/BadDebtReliefReport/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 361;
UPDATE user_module_access_details SET menuCode = 'CUSRLFRP' WHERE menuCode = 'BDRETRPT';

## Customer Bad Debt Recover
UPDATE
	_sys_menu
SET
	code = 'CUSCVRTX',
	name = 'CustomerBadDebtRecover',
	urls = 'gstReport/BadDebtRecover/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 359;
UPDATE user_module_access_details SET menuCode = 'CUSCVRTX' WHERE menuCode = 'GSBADBTR';

## Customer Bad Debt Recover Confirm
UPDATE
	_sys_menu
SET
	code = 'CUSCVRCF',
	name = 'CustomerBadDebtRecoverConfirm',
	urls = 'gstReport/BadDebtRecoverConfirm/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 360;
UPDATE user_module_access_details SET menuCode = 'CUSCVRCF' WHERE menuCode = 'BDEBRCCO';

## Customer Bad Debt Recover Report
UPDATE
	_sys_menu
SET
	code = 'CUSCVRRP',
	name = 'CustomerBadDebtRecoverReport',
	urls = 'gstReport/BadDebtRecoverReport/customer',
	seq = 85,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 360;
UPDATE user_module_access_details SET menuCode = 'CUSCVRRP' WHERE menuCode = 'BDRCVRPT';

/*
 * SUPPLIER SECTION
 * @author NurSalikeen Saparai <salikeen@salihin.com.my>
 */

## Supplier Bad Debt Relief Report
UPDATE
	_sys_menu
SET
	code = 'SUPRLFRP',
	name = 'SupplierBadDebtReliefReport',
	urls = 'gstReport/BadDebtReliefReport/supplier',
	seq = 87,
	access = NULL,
	icons = 'icon-active.png'
WHERE
	fldid = 362;

INSERT INTO _sys_menu
(`code`,`name`,`parents`,`module`,`submenu`,`urls`,`access`,`seq`,`display`,`icons`,`language`)
VALUES
('CUSCVRRP', 'CustomerBadDebtRecoverReport', 103, 6, 0, 'gstReport/BadDebtRecoverReport/customer', NULL, 86, 1, 'icon-active.png', 'EN');

INSERT INTO _sys_menu
(`code`,`name`,`parents`,`module`,`submenu`,`urls`,`access`,`seq`,`display`,`icons`,`language`)
VALUES
('SUPCVRRP', 'SupplierBadDebtRecoverReport', 103, 6, 0, 'gstReport/BadDebtRecoverReport/supplier', NULL, 88, 1, 'icon-active.png', 'EN');

INSERT INTO _sys_menu
(`code`,`name`,`parents`,`module`,`submenu`,`urls`,`access`,`seq`,`display`,`icons`,`language`)
VALUES
('DBTMNTR', 'BadDebtMonitoringReport', 103, 6, 0, 'gstReport/BadDebtMonitoringReport', NULL, 89, 1, 'icon-active.png', 'EN');

	
