Account Inquiry: Difference between revisions

Latest revision as of 06:29, 5 February 2016

Menu: Inquiry | Account Inquiry...

Introduction

Quick inquiry the ledger transactions for General Ledger, Sales Ledger (Customer) and Purchase Ledger (Supplier).

Account Inquiry

General Ledger

1. Select the date ranged.

2. Select a GL account code.

3. Click on Apply.

Sales Ledger (Customer)

1. Select the date ranged.

2. Select a Customer account code.

3. Click on Apply.

Purchase Ledger (Supplier)

1. Select the date ranged.

2. Select a Supplier account code.

3. Click on Apply.

Access Control in Account Inquiry

Tools | Maintain User...

1. You can set the access control to the access to General, Sales and Purchase Ledger.

2. Tick or untick Execute to:

No	Access Control	Explanation
01	Account Inquiry - Inquire G/L Account	Allow to inquire GL Account.
02	Account Inquiry - Inquire Customer Account	Allow to inquire Customer Account (Sales Ledger).
03	Account Inquiry - Inquire Supplier Account	Allow to inquire Supplierr Account (Purchase Ledger).
04	Account Inquiry	Allow to use Account Inquiry.

@@ Line 2: / Line 2: @@
 ==Introduction==
-:1. It helps to filter the data based on the conditions defined.
+:Quick inquiry the ledger transactions for General Ledger, Sales Ledger (Customer) and Purchase Ledger (Supplier).
-:2. It is very useful for those who '''DO NOT ALLOW''' certain users to access the documents.
+::[[File:Inquiry-Account Inquiry-01.jpg |700px]]
-:3. For example, agent  '''Lip Fong''' can view and access the sales invoices belong to his agent code '''LF'' ONLY.
+<br />
+==Account Inquiry==
+===General Ledger===
+:1. Select the date ranged.
+:2. Select a GL account code.
+:3. Click on '''Apply'''.
+::[[File:Inquiry-Account Inquiry-02.jpg |700px]]
+<br />
-==Maintain Form Mode (eg. Filtered by Agent)==
+===Sales Ledger (Customer)===
-:1. Click on '''New'''.
+:1. Select the date ranged.
-::[[File:Tools-Maintain Form Mode-01.jpg |600px]]
+:2. Select a Customer account code.
+:3. Click on '''Apply'''.
+::[[File:Inquiry-Account Inquiry-03.jpg |700px]]
 <br />
-:2. Enter a '''Code''', eg. IV-LF, IV-SF...
+===Purchase Ledger (Supplier)===
-::[[File:Tools-Maintain Form Mode-02.jpg |600px]]
+:1. Select the date ranged.
+:2. Select a Supplier account code.
+:3. Click on '''Apply'''.
+::[[File:Inquiry-Account Inquiry-04.jpg |700px]]
 <br />
-:3. Select the '''Form''' to filter, eg. Invoice.
-::[[File:Tools-Maintain Form Mode-03.jpg |600px]]
+==Access Control in Account Inquiry==
-<br />
+''Tools | Maintain User...''
-:4. Click on '''Customize Filter'''. Click on '''press the button to add a new condition'''.
+:1. You can set the access control to the access to '''General''', '''Sales''' and '''Purchase Ledger'''.
-::[[File:Tools-Maintain Form Mode-04.jpg |600px]]
+:2. Tick or untick '''Execute''' to:
-<br />
-:5. Choose a field to filter, eg. Agent '''(SL_IV.AGENT)'''.
-::[[File:Tools-Maintain Form Mode-05.jpg |600px]]
-<br />
-:6. Change the filter operators, eg. equals.
-::[[File:Tools-Maintain Form Mode-06.jpg |600px]]
-<br />
-:7. Enter the '''agent code'''.
-::[[File:Tools-Maintain Form Mode-07.jpg |600px]]
-<br />
-:8. Filter Text will be display as: '''(SL_IV.AGENT = 'LF')'''.
-::[[File:Tools-Maintain Form Mode-08.jpg |600px]]
-<br />
-:9. Other '''optional''' setting.
-::[[File:Tools-Maintain Form Mode-09.jpg |600px]]
 ::{| class="wikitable"
 |-
-! Options !! Explanation
+! No !! Access Control !! Explanation
 |-
-| Allow Multiple Windows || To allow duplicate Windows screen by click from the menu list.
+| 01 || Account Inquiry - Inquire G/L Account || Allow to inquire '''GL Account'''.
 |-
-| Force Filter || Force filter.
+| 02 || Account Inquiry - Inquire Customer Account || Allow to inquire '''Customer Account (Sales Ledger)'''.
 |-
-| Split Browse & Detail Windows || Enable to split the Windows when click on Browse and Detail button.
+| 03 || Account Inquiry - Inquire Supplier Account || Allow to inquire '''Supplierr Account (Purchase Ledger)'''.
 |-
-| Default Windows <br /> * Browse<br />* Detail<br /> || style="vertical-align: top;" | To set the default mode.
+| 04 || Account Inquiry || Allow to use Account Inquiry.
 |}
-<br />
+::[[File:Inquiry-Account Inquiry-05.jpg |700px]]
-:10. Lets said you have created more than 1 form mode for same form (eg.'''invoice'''). Go to Sales | Invoice, you will get prompt the '''select browse mode''' to choose. See the screenshot below.
-::[[File:Tools-Maintain Form Mode-10.jpg |250px]]
-<br />
-==How to lock the form mode by Agent==
-:1. Go to '''Tools | User Access Right Assignment...'''
-:2. Under the '''list of security''', click on '''form mode'''.
-:3. Select the user, eg. '''user code: LF''' (Lip Fong).
-:4. Tick to allow execute the '''form mode''', eg. tick on '''form mode: IV-LF'''.
-:5. Click '''Save'''. See the screenshot below.
-::[[File:Tools-Maintain Form Mode-11.jpg |600px]]
-<br />
-:6. Login the user as '''LF'''.
-:7. Go to Sales | Invoice...
-:8. User LF can see the invoices belong to his '''agent code: LF'''.
-::[[File:Tools-Maintain Form Mode-12.jpg |700px]]
 <br />
 ==See also==