Saturday, June 11, 2016

Configuration of Tally Part-D

Configuration of Tally


Part-D
As stated in my previous article, I am presenting here my fourth and last installment on Configuration of Tally.

You may access Part A, B, and C by clicking links given below.




In this post I am presenting Banking Configuration.

Banking Configuration

This allows you to configure the BRS Report and alter the Reconciled Vouchers.
Go to Gateway of Tally > F12: Configuration Menu > Banking Configuration


Show all Unreconciled Transactions Till Date:


If this option is set to Yes, Tally.ERP 9 will display all the Unreconciled Transactions till the given date, irrespective of the From date set in the Bank Reconciliation Statement.
Note: This option is also available in the Configuration of Bank Reconciliation Statement.
Remove Bank Date on Altering Reconciled Vouchers:
By default, this option will be set to No. Set this option to Yes to remove the Bank Date (Reconciled Date) of a reconciled voucher on changing the Bank Ledger/Amount or Bank Transaction Amount.  Following message will be displayed before removing the Bank Date:
The default locations of New Bank Statement Files, Imported Bank Statement Files, Payment Instructions, New Intermediate Files and Imported Intermediate Files are displayed in the respective fields. The paths can be changed, as required by the user.

Show Details Before Export: Details of transactions for which the Payment Instruction is being exported will be displayed.


Download the whole article in pdf file by clicking HERE.


Configuration of Tally Part-C

Configuration of Tally


Part-C
As stated in my previous article, I am presenting here my third installment on Configuration of Tally.

You may access Part A, B, and D by clicking links given below.




In this post I am presenting Voucher Entry and Invoice / Orders Entry.


Voucher Entry

This option allows you to configure the vouchers entries in Tally.ERP 9, both the Accountingand Inventory Vouchers can be configured from this menu for additional information.
Go to Gateway of Tally > F12: Configure > Voucher Entry

By default, the above configuration options are displayed in the Voucher Entry Configuration screen, which can be changed as per requirements.
Note: Depending upon the Company Features, options get added in Voucher Entry configuration. For instance, if you enable Allow Multi Currency option in F11: Accounting Features, Show Forex Gain/Loss as on Voucher Date option gets added in voucher entry configuration.

Accounting Vouchers

Skip Date field in Creation Mode (faster entry!)

By default, the Cursor skips the Date field during Voucher creation. If you do not want to skip the date field then set this option to No

Use Single Entry Mode for Pymt/Rcpt/Contra

By default, Tally.ERP 9 displays single entry mode for payment/receipt/contra entry. If you want to display it in double entry mode, then set this option to No

Use Payment / Receipt as contra

By enabling this option, you can enter contra in payment as well as receipt voucher

Use Cr/Dr instead of To/By during Entry

By enabling this option, you can change To/By to Cr/Dr in the Voucher Entry screen

Use Cheque Printing for Contra

By enabling this option, you can print the Cheques from Contra Voucher itself while making the inter bank transfers and Cash withdrawals. The Cheque printing option will appear the for the Bank which is Credited

Warn on Negative Cash Balance

By Default, Tally.ERP 9 displays a Negative Cash balance warning Message. If you set it to No, this error message will not be displayed

Pre-Allocate Bills for Payment/Receipt

By enabling this option, you can pre-allocate the bills before specifying the Ledger amount

Allow Cash Accounts in Journal

By enabling this option, you can select cash and also bank account in Journal

Allow Expenses / Fixed Assets in Purchase Voucher

By enabling this option, you can select the expenses and also Fixed Asset ledger in Purchase Voucher Entry

Allow income accounts in Sales Voucher

By enabling this option, you can select the income ledger in sales voucher entry

Show inventory Details

By default, Tally.ERP 9 displays inventory details in the voucher entry screen. If you set it to No, the inventory details will not be displayed

Show Table of Bill details for selection

By default, Tally.ERP 9 displays Pending Bills list of a ledger account in the voucher entry screen. If you set it to No, the pending bills list will not be displayed

Show Bill-wise Details

By default, Bill-wise details of a ledger account are displayed in the Voucher entry screen. If you set it to No, Bill wise details will not be displayed

Expand into Multiple Lines

This is a sub-option of the Show bill-wise Details option. When you enter credit days in the Bill-wise Details screen, Tally.ERP 9 displays the due date below the credit days. By default, it displays both credit days and Due date in the voucher entry screen. If you set it to No, it will display only credit days

Show ledger current balance

By default, Tally.ERP 9 displays the ledger current balance up to last voucher entry date. If you set it to No, the ledger current balance will not be displayed

Show balance as on voucher date

By default, Tally.ERP 9 displays the ledger current balance up to Last voucher entry date. If you set it to Yes, it will display the ledger balance up to current voucher entry date
Show Forex Gain/Loss as on voucher Date
By default, Tally.ERP 9 displays the Forex Gain/Loss balance up to the Last voucher entry date. If you set it to Yes, it will display the Forex Gain/Loss balance up to current voucher entry date.

Inventory Vouchers

Use Reference number in Stock Journal

By enabling this option, you can add the voucher reference field in Stock Journal also

Show Compound Unit of Item based on Rate

By enabling this option, you will be allowed to show the compound unit of item based on the unit provided in the Rate Per column.
Example: Compound Unit created as Kgs of 1000 grms. When the Quantity is typed as 12-250, the Quantity will be displayed as 12-250 kgs and unit in Rate per as Kgs. Enable the option Show Compound Unit of Item based on Rate, and type the required Unit in Rate Per column to change the compound unit of the Item, i.e., if grms is typed in Rate Per column, the Quantity will automatically change to 12,250 grms.

Show Full Details of Compound Unit

Enabling this option will display full details of compound unit in the Quantity field. If Kgs is typed in Rate per field, the Quantity field will display as 12 Kgs.250 grms.

Warn on Negative stock balance

By default, Tally.ERP 9 displays a warning message for negative stock balance. If you set it to No, the error message will not be displayed.

Honor Expiry Dates usage for Batches

By default, Tally.ERP 9 displays expiry batches in the List of Active batches during Voucher Entry. If you set it to No, expiry batches will not be displayed in the List of Active batches.

Show Balances as on Voucher Date

By default, Tally.ERP 9 displays the Stock Item balance up to the Last voucher entry date. If you set it to Yes, it will display the Stock Item balance up to current voucher entry date.

Show Godown-wise Details

This option is used only in the case of Rejection in and Rejection out vouchers. By default, Tally.ERP 9 displays the Godown details in Rejection in/out vouchers. If you set it to No, the godown details will not be displayed in Rejection in/out vouchers.

Show Batch-Wise Details

This option is used to display batch information pertaining to Stock Items during Voucher Entry. If you set it to No, the Batch-Wise details will not be displayed.


Invoice / Orders Entry

This allows you to configure invoice, delivery notes and sales & purchase orders. The Invoice entry and Order entry screens can be configured for additional information such as export details, shipping details, etc.
Go to Gateway of Tally > F12: Configure > Invoice/Orders Entry
Note: Depending upon the Company Features, options get added in Invoice/order Entry configuration. For instance, if you enable VAT option in F11 Statutory Features, Allow selection of VAT/TAX Class during entry, Warn on Mismatch in VAT Rates and Activate E1 or E2 Transaction option gets added in Invoice/Order entry configuration.

General Options

Accept Supplementary Details

By default, this option is set to YES.
Tally.ERP 9 displays an additional screen to feed in the delivery note details, order details, Terms of payment, party address details, etc., after selecting the required Party ledger account.

Print Default Name & Address of Party

By default, Print Default Name & Address of Party is not visible in the Invoice Entry configuration Screen. This option is available only if Accept Supplementary Details in F12 Configure is set to No.
On setting this option to Yes, Tally.ERP 9 Prints the Party Ledger’s Mailing Name and address details given in the Ledger master – in the Invoice. On setting this option to No – the invoice printout will display only the Party Ledger’s Name without address details.

Allow separate Buyer and Consignee Names

By default, this option is set to No.
If set to Yes – Tally.ERP 9 provides an option to enter consignee Name and address in the Supplementary details screen.

Allow modification of ALL fields during entry

Default order/delivery note entries appearing in the invoice can be changed during invoice entry. Set this to Yes to permit modification of all fields.

Use Common Ledger A/c for Item Allocation

By default, this option is set to Yes.
This automates the updation process of the Sales and Purchase accounts for all the items selected in the invoice. In case this option is Set to No – Tally.ERP 9 prompts for sales or purchase accounting allocations after every item.

Use Defaults for Bill Allocations

By default, this option is set to Yes. In this case, Tally.ERP 9 automatically takes the invoice number as the bill reference name and the credit period given in the Party ledger master as the credit period – both as part of the bill-wise details. This enables faster data entry.
Note: In a purchase invoice, Tally.ERP 9 automatically takes the invoice reference number as Bill reference. If invoice reference number is empty then it will take invoice number as Bill reference.
However, if this option is set to No – Tally.ERP 9 prompts the user for bill-wise details at the end of the entry.

Use Additional Description(s) for Item name

By default, this option is set to No.
If it is set to Yes – Tally.ERP 9 automatically allows you to specify description for each item selected in the invoice.

Use Additional Descriptions(s) for Ledger name

By default, this option is set to No.
If it is set to Yes – Tally.ERP 9 automatically allows you to specify the description for each Ledger selected in the Accounting invoice entries.
Note: This options are provided to specify any additional description for sales ledger selected in the Accounting Invoice mode not in the Item invoice mode.

Consolidate Stock Items with same rates

By default, this option is set to No.
If you want to consolidate the stock items having same rates in Invoice/Challans, set this option to Yes.

Show Compound Unit of Item based on Rate


Show Full Details of Compound Unit


Show turnover achieved with Customer

By default, this option is set to No.
If you want to view the turnover achieved till date with a particular customer, set this option to Yes.

Exporter’s Options

Specify Export Shipping Details

By default, this option is set to No.
If set to Yes, Tally.ERP 9 provides an option to enter export details for the invoice in the Supplementary details screen.
You can enter the following details:
·         Place of Receipt
·         Vessel / Flight No. (the transport used to send the goods)
·         Port of Loading (from where the goods are despatched)
·         Port of Discharge (where the goods will be finally offloaded)
·         Country To (to which country the goods are being sent)

Specify Marks & Nos. / Container No.

By default, this option is set to No.
If set to Yes – Tally.ERP 9 allows you to specify Marks details for every item selected in the invoice.

Specify No. and Kind of packages

By default, this option is set to No.
If set to Yes – Tally.ERP 9 allows to you to specify Num. Packages for every item selected in the invoice.

Inventory

Show Compound Unit of Item based on Rate


Show Full Details of Compound Unit


Warn on Negative Stock Balance

By default, this option is set to Yes.
This is similar to the option available in the Voucher Entry Configuration screen. You can configure Tally.ERP 9 to warn in case the item selected reaches a negative balance.

Honor Expiry Dates usage for Batches

By default, this option is set to YES.
This is similar to the option available in the Voucher Entry Configuration Screen. You can configure Tally.ERP 9 NOT to include expired batches in the list of batches displayed at the time of entry.

Complete Accounting Allocations in Order / Delivery Note

By default, this option is set to Yes.
This means that in the Sales / Purchase Order and Delivery / Receipt Note entries, you can allocate a sales / Purchase ledger. This enables faster data entry at the time of entering sales / purchase invoices against the Delivery / Receipt notes.

Statutory

Calculate Tax on Current Sub-Total

By default, this option is set to No.
For example:
Name
Qty
Rate
Amount
Item A
10 No.
100 / No.
1000
Item B
10 No.
200 / No.
2000


Total Item value
3000
Discount

-10%
-300
If you add another line, Tax 1%, it will calculate 1% on 3000 (on Total Item value) giving 30 as Tax value. However, if you opt for calculating on the current sub-total, Tax value will be calculated on 2700 [3000-300] giving 27 as Tax value.


Download the whole post in pdf file by clicking HERE.




Configuration of Tally Part-B

Configuration of Tally


Part-B
As stated in my previous article, I am presenting here my second installment on Configuration of Tally.

You may access Part A, C, and D by clicking links given below.




In this Part-B, I am presenting Numeric Symbols andAccts / Inventory Info.


Numeric Symbols

·         This enables you to set the number styles. The default styles and symbols are specified. However, you have the option of changing them in the respective fields according to your preference.
·         For example, change negative sign from (-) to (+).
·         Go to Gateway of Tally > F12: Configure > Numeric Symbols.


Accts / Inventory Info.
Here you can configure the details you want in the masters over and above those provided by fault. You can access the F12: Configure screen from Accounts Masters and Inventory Masters when required. The fields pertaining to both Accounting and Inventory Info. can be configured here.
Go to Gateway of Tally > F12: Configure > Accts/Inventory Info.


Note: Depending upon the Company Features, option gets added in the Master configuration. For instance, if you enable VAT in F11 Statutory Feature, then the option Calculate VAT on MRP/Marginal gets added.

Master Configuration

Allow Aliases along with Names

Set this option to Yes to enter the Alias names in the Master.

Allow Language Aliases along with Names

Set this option to Yes to enter the Alias names in any of the Indic Languages in the Master.

Accounts Masters

Allow Advanced Entries in Masters

Set this option to Yes, to enter some of the advanced information in the Ledger and Group Master. This information will be reflected in the reports.

Use Addresses for Ledger Accounts

Set this option to Yes to enter the Mailing Details in the ledger master. It is useful for a Customer ledger, a Party ledgers or Bank Accounts. Mailing Details like Name, Address, State, PIN Code and PAN / IT No. is entered in this section.
These details will appear in the printed reports.

Use Contact Details for Ledger Accounts

Set this option to Yes to specify the details of Contact person (if any) in the ledger creation screen.
You can specify the details like the Name of the Contact Person, Telephone Number, Fax Number and the E-Mail Id.

Add Notes to Ledger Accounts

Set this option to Yes and a new field to enter Notes appears in the Ledger master. This field allows you to enter any additional information about the ledger.
Note: The Contact Details for the ledgers appear only if Use Addresses for Ledger Accounts is set to Yes.

Inventory Masters

Allow Advanced entries in Masters

Set this option to Yes to specify the behavior of the Stock Item, in the Stock Item Master. For further details, please refer the section Stock Items.

Use Part Numbers for Stock Items

Set this option to Yes, to enter the Part Numbers of the Stock Item.

Use Description for Stock Items

Set this option to Yes to enter any Description of the Stock Item in the Stock Item Master.

Use Remarks for Stock Items

Set this option to Yes to enter your remarks or comments about the stock Item.

Use Alternate Units for Stock Items

Set this option to Yes to define an Alternate Unit for the Stock Item.

Allow Std. Rates for Stock Items

Set this option to Yes, to specify the Standard Purchase Cost and Standard Sales Price of the Stock Item.

Specify Default Ledger Allocation for Invoicing

Set this option to Yes, to Set or Modify Default Ledgers for Invoicing for the Stock Item.
This allows you to allocate default Sales/Purchase Ledgers which will be credited when a Stock Item is invoiced.

Allow Component list details (Bill of Materials)

Set this option to Yes, to define the Components (BOM) for the Stock Item. For further details, refer to the section Bill of Material.

Use Addresses for Godowns


Set this option to Yes, to enter the Godown address in the Godown Master.


Download the whole post in pdf format by clicking HERE.