import sql-ledger 2.4.4SQL_LEDGER

1 files changed, 524 insertions, 18 deletions

diff --git a/sql-ledger/menu.ini b/sql-ledger/menu.ini
index 87207982e..637bf9857 100644
--- a/sql-ledger/menu.ini
+++ b/sql-ledger/menu.ini
@@ -1,3 +1,5 @@
+[ ]
+
 [AR]
 
 [AR--Add Transaction]
@@ -20,6 +22,12 @@ module=ar.pl
 action=search
 nextsub=ar_transactions
 
+[AR--Reports--Outstanding]
+module=ar.pl
+action=search
+outstanding=1
+nextsub=ar_transactions
+
 [AR--Reports--AR Aging]
 module=rp.pl
 action=report
@@ -30,6 +38,11 @@ module=rp.pl
 action=report
 report=tax_collected
 
+[AR--Reports--Non-taxable]
+module=rp.pl
+action=report
+report=nontaxable_sales
+
 [AR--Customers]
 module=menu.pl
 action=acc_menu
@@ -42,10 +55,36 @@ action=add
 db=customer
 
 [AR--Customers--Reports]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[AR--Customers--Reports--Search]
 module=ct.pl
 action=search
 db=customer
 
+[AR--Customers--Reports--History]
+module=ct.pl
+action=history
+db=customer
+
+[POS]
+
+[POS--Sale]
+module=ps.pl 
+action=add
+nextsub=openinvoices
+
+[POS--Open]
+module=ps.pl   
+action=openinvoices
+
+[POS--Receipts]
+module=ps.pl
+action=receipts
+
 [AP]
 
 [AP--Add Transaction]
@@ -68,6 +107,12 @@ module=ap.pl
 action=search
 nextsub=ap_transactions
 
+[AP--Reports--Outstanding]
+module=ap.pl
+action=search
+outstanding=1
+nextsub=ap_transactions
+
 [AP--Reports--AP Aging]
 module=rp.pl
 action=report
@@ -78,6 +123,11 @@ module=rp.pl
 action=report
 report=tax_paid
 
+[AP--Reports--Non-taxable]
+module=rp.pl
+action=report
+report=nontaxable_purchases
+
 [AP--Vendors]
 module=menu.pl
 action=acc_menu
@@ -90,22 +140,44 @@ action=add
 db=vendor
 
 [AP--Vendors--Reports]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[AP--Vendors--Reports--Search]
 module=ct.pl
 action=search
 db=vendor
 
+[AP--Vendors--Reports--History]
+module=ct.pl
+action=history
+db=vendor
+
 [Cash]
 
 [Cash--Receipt]
 module=cp.pl
 action=payment
+type=receipt
 vc=customer
 
 [Cash--Payment]
 module=cp.pl
 action=payment
+type=check
 vc=vendor
 
+[Cash--Transfer]
+module=gl.pl
+action=add
+transfer=1
+
+[Cash--Reconciliation]
+module=rc.pl
+action=reconciliation
+
 [Cash--Reports]
 module=menu.pl
 action=acc_menu
@@ -122,9 +194,28 @@ module=rp.pl
 action=report
 report=payments
 
-[Cash--Reconciliation]
+[Cash--Reports--Reconciliation]
 module=rc.pl
 action=reconciliation
+report=1
+
+[HR]
+
+[HR--Employees]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[HR--Employees--Add Employee]
+module=hr.pl
+action=add
+db=employee
+
+[HR--Employees--Reports]
+module=hr.pl
+action=search
+db=employee
 
 [Order Entry]
 
@@ -154,6 +245,50 @@ module=oe.pl
 action=search
 type=purchase_order
 
+[Shipping]
+
+[Shipping--Ship]
+module=oe.pl
+action=search
+type=ship_order
+
+[Shipping--Receive]
+module=oe.pl
+action=search
+type=receive_order
+
+[Shipping--Transfer]
+module=oe.pl
+action=search_transfer
+
+[Quotations]
+
+[Quotations--Quotation]
+module=oe.pl 
+action=add 
+type=sales_quotation
+
+[Quotations--RFQ]
+module=oe.pl 
+action=add 
+type=request_quotation
+
+[Quotations--Reports]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[Quotations--Reports--Quotations]
+module=oe.pl
+action=search
+type=sales_quotation
+
+[Quotations--Reports--RFQs]
+module=oe.pl
+action=search
+type=request_quotation
+
 [General Ledger]
 
 [General Ledger--Add Transaction]
@@ -181,11 +316,21 @@ module=ic.pl
 action=add
 item=assembly
 
+[Goods & Services--Add Labor/Overhead]
+module=ic.pl
+action=add
+item=labor
+
 [Goods & Services--Add Group]
 module=pe.pl
 action=add
 type=partsgroup
 
+[Goods & Services--Add Pricegroup]
+module=pe.pl
+action=add
+type=pricegroup
+
 [Goods & Services--Stock Assembly]
 module=ic.pl
 action=stock_assembly
@@ -196,6 +341,11 @@ action=acc_menu
 target=acc_menu
 submenu=1
 
+[Goods & Services--Reports--All Items]
+module=ic.pl
+action=search
+searchitems=all
+
 [Goods & Services--Reports--Parts]
 module=ic.pl
 action=search
@@ -206,16 +356,47 @@ module=ic.pl
 action=search
 searchitems=service
 
-[Goods & Services--Reports--Assemblies]
+[Goods & Services--Reports--Labor/Overhead]
 module=ic.pl
 action=search
-searchitems=assembly
+searchitems=labor
 
 [Goods & Services--Reports--Groups]
 module=pe.pl
 action=search
 type=partsgroup
 
+[Goods & Services--Reports--Pricegroups]
+module=pe.pl
+action=search
+type=pricegroup
+
+[Goods & Services--Reports--Assemblies]
+module=ic.pl
+action=search
+searchitems=assembly
+
+[Goods & Services--Reports--Components]
+module=ic.pl
+action=search
+searchitems=component
+
+[Goods & Services--Translations]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[Goods & Services--Translations--Description]
+module=pe.pl
+action=translation
+translation=description
+
+[Goods & Services--Translations--Groups]
+module=pe.pl
+action=translation
+translation=partsgroup
+
 [Projects]
 
 [Projects--Add Project]
@@ -224,10 +405,32 @@ action=add
 type=project
 
 [Projects--Reports]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[Projects--Reports--List Projects]
 module=pe.pl
 action=search
 type=project
 
+[Projects--Reports--Transactions]
+module=rp.pl
+action=report
+report=projects
+
+[Projects--Translations]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[Projects--Translations--Description]
+module=pe.pl
+action=translation
+translation=project
+
 [Reports]
 
 [Reports--Chart of Accounts]
@@ -249,8 +452,110 @@ module=rp.pl
 action=report
 report=balance_sheet
 
+[Batch Printing]
+
+[Batch Printing--Print]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[Batch Printing--Print--Sales Invoices]
+module=bp.pl
+action=search
+vc=customer
+type=invoice
+
+[Batch Printing--Print--Sales Orders]
+module=bp.pl
+action=search
+vc=customer
+type=sales_order
+
+[Batch Printing--Print--Work Orders]
+module=bp.pl
+action=search
+vc=customer
+type=work_order
+
+[Batch Printing--Print--Quotations]
+module=bp.pl
+action=search
+vc=customer
+type=sales_quotation
+
+[Batch Printing--Print--Packing Lists]
+module=bp.pl
+action=search
+vc=customer
+type=packing_list
+
+[Batch Printing--Print--Pick Lists]
+module=bp.pl
+action=search
+vc=customer
+type=pick_list
+
+[Batch Printing--Print--Purchase Orders]
+module=bp.pl
+action=search
+vc=vendor
+type=purchase_order
+
+[Batch Printing--Print--Bin Lists]
+module=bp.pl
+action=search
+vc=vendor
+type=bin_list
+
+[Batch Printing--Print--RFQs]
+module=bp.pl
+action=search
+vc=vendor
+type=request_quotation
+
+[Batch Printing--Print--Checks]
+module=bp.pl
+action=search
+vc=vendor
+type=check
+
+[Batch Printing--Print--Receipts]
+module=bp.pl
+action=search
+vc=customer
+type=receipt
+
 [System]
 
+[System--Audit Control]
+module=am.pl
+action=audit_control
+
+[System--Defaults]
+module=am.pl
+action=defaults
+
+[System--Yearend]
+module=am.pl
+action=yearend
+
+[System--Backup]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--Backup--Send by E-Mail]
+module=am.pl
+action=backup
+media=email
+
+[System--Backup--Save to File]
+module=am.pl
+action=backup
+media=file
+
 [System--Chart of Accounts]
 module=menu.pl
 action=acc_menu
@@ -259,11 +564,11 @@ submenu=1
 
 [System--Chart of Accounts--Add Account]
 module=am.pl
-action=add
+action=add_account
 
 [System--Chart of Accounts--List Accounts]
 module=am.pl
-action=list
+action=list_account
 
 [System--Chart of Accounts--Add GIFI]
 module=am.pl
@@ -273,6 +578,76 @@ action=add_gifi
 module=am.pl
 action=list_gifi
 
+[System--Warehouses]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--Warehouses--Add Warehouse]
+module=am.pl
+action=add_warehouse
+
+[System--Warehouses--List Warehouses]
+module=am.pl
+action=list_warehouse
+
+[System--Departments]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--Departments--Add Department]
+module=am.pl
+action=add_department
+
+[System--Departments--List Departments]
+module=am.pl
+action=list_department
+
+[System--Type of Business]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--Type of Business--Add Business]
+module=am.pl
+action=add_business
+
+[System--Type of Business--List Businesses]
+module=am.pl
+action=list_business
+
+[System--Language]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--Language--Add Language]
+module=am.pl
+action=add_language
+
+[System--Language--List Languages]
+module=am.pl
+action=list_language
+
+[System--SIC]
+module=menu.pl
+action=acc_menu
+target=acc_menu
+submenu=1
+
+[System--SIC--Add SIC]
+module=am.pl
+action=add_sic
+
+[System--SIC--List SIC]
+module=am.pl
+action=list_sic
+
 [System--HTML Templates]
 module=menu.pl
 action=acc_menu
@@ -294,26 +669,61 @@ module=am.pl
 action=display_form
 file=templates=invoice.html
 
+[System--HTML Templates--AR Transaction]
+module=am.pl
+action=display_form
+file=templates=ar_transaction.html
+
+[System--HTML Templates--AP Transaction]
+module=am.pl
+action=display_form
+file=templates=ap_transaction.html
+
 [System--HTML Templates--Packing List]
 module=am.pl
 action=display_form
 file=templates=packing_list.html
 
+[System--HTML Templates--Pick List]
+module=am.pl
+action=display_form
+file=templates=pick_list.html
+
 [System--HTML Templates--Sales Order]
 module=am.pl
 action=display_form
 file=templates=sales_order.html
 
+[System--HTML Templates--Work Order]
+module=am.pl
+action=display_form
+file=templates=work_order.html
+
 [System--HTML Templates--Purchase Order]
 module=am.pl
 action=display_form
 file=templates=purchase_order.html
 
+[System--HTML Templates--Bin List]
+module=am.pl
+action=display_form
+file=templates=bin_list.html
+
 [System--HTML Templates--Statement]
 module=am.pl
 action=display_form
 file=templates=statement.html
 
+[System--HTML Templates--Quotation]
+module=am.pl
+action=display_form
+file=templates=sales_quotation.html
+
+[System--HTML Templates--RFQ]
+module=am.pl
+action=display_form
+file=templates=request_quotation.html
+
 [System--LaTeX Templates]
 module=menu.pl
 action=acc_menu
@@ -325,21 +735,46 @@ module=am.pl
 action=display_form
 file=templates=invoice.tex
 
+[System--LaTeX Templates--AR Transaction]
+module=am.pl
+action=display_form
+file=templates=ar_transaction.tex
+
+[System--LaTeX Templates--AP Transaction]
+module=am.pl
+action=display_form
+file=templates=ap_transaction.tex
+
 [System--LaTeX Templates--Packing List]
 module=am.pl
 action=display_form
 file=templates=packing_list.tex
 
+[System--LaTeX Templates--Pick List]
+module=am.pl
+action=display_form
+file=templates=pick_list.tex
+
 [System--LaTeX Templates--Sales Order]
 module=am.pl
 action=display_form
 file=templates=sales_order.tex
 
+[System--LaTeX Templates--Work Order]
+module=am.pl
+action=display_form
+file=templates=work_order.tex
+
 [System--LaTeX Templates--Purchase Order]
 module=am.pl
 action=display_form
 file=templates=purchase_order.tex
 
+[System--LaTeX Templates--Bin List]
+module=am.pl
+action=display_form
+file=templates=bin_list.tex
+
 [System--LaTeX Templates--Statement]
 module=am.pl
 action=display_form
@@ -355,36 +790,107 @@ module=am.pl
 action=display_form
 file=templates=receipt.tex
 
-[System--Stylesheet]
+[System--LaTeX Templates--Quotation]
 module=am.pl
-action=display_stylesheet
+action=display_form
+file=templates=sales_quotation.tex
 
-[System--Backup]
+[System--LaTeX Templates--RFQ]
+module=am.pl
+action=display_form
+file=templates=request_quotation.tex
+
+[System--Text Templates]
 module=menu.pl
 action=acc_menu
 target=acc_menu
 submenu=1
 
-[System--Backup--Send by E-Mail]
+[System--Text Templates--POS Invoice]
 module=am.pl
-action=backup
-media=email
+action=display_form
+file=templates=pos_invoice.txt
 
-[System--Backup--Save to File]
+[System--Text Templates--Invoice]
 module=am.pl
-action=backup
-media=file
+action=display_form
+file=templates=invoice.txt
 
-[System--Audit Control]
+[System--Text Templates--AR Transaction]
 module=am.pl
-action=audit_control
+action=display_form
+file=templates=ar_transaction.txt
 
-[System--Preferences]
+[System--Text Templates--AP Transaction]
+module=am.pl
+action=display_form
+file=templates=ap_transaction.txt
+
+[System--Text Templates--Packing List]
+module=am.pl
+action=display_form
+file=templates=packing_list.txt
+
+[System--Text Templates--Pick List]
+module=am.pl
+action=display_form
+file=templates=pick_list.txt
+
+[System--Text Templates--Sales Order]
+module=am.pl
+action=display_form
+file=templates=sales_order.txt
+
+[System--Text Templates--Work Order]
+module=am.pl
+action=display_form
+file=templates=work_order.txt
+
+[System--Text Templates--Purchase Order]
+module=am.pl
+action=display_form
+file=templates=purchase_order.txt
+
+[System--Text Templates--Bin List]
+module=am.pl
+action=display_form
+file=templates=bin_list.txt
+
+[System--Text Templates--Statement]
+module=am.pl
+action=display_form
+file=templates=statement.txt
+
+[System--Text Templates--Check]
+module=am.pl
+action=display_form
+file=templates=check.txt
+
+[System--Text Templates--Receipt]
+module=am.pl
+action=display_form
+file=templates=receipt.txt
+
+[System--Text Templates--Quotation]
+module=am.pl
+action=display_form
+file=templates=sales_quotation.txt
+
+[System--Text Templates--RFQ]
+module=am.pl
+action=display_form
+file=templates=request_quotation.txt
+
+[Stylesheet]
+module=am.pl
+action=display_stylesheet
+
+[Preferences]
 module=am.pl
 action=config
 
 [Version]
-module=login.pl
+module=am.pl
 action=company_logo
 
 [Logout]