Tuesday, July 27, 2021

Symbol for comment in statement in Foxpro

Comment in foxpro is * or Note if user don't want to interpret the statement than either this two symbol is used.

यदि हमें अपने फॉक्सप्रो प्रोग्राम मे कोई कमेंट देना हो तो उसके लिये * या Note लिखते है जैसे 

*Write a program for Leap Year

Note Write a Program for Leap Year 

इस तरह से लाइन इन्टरप्रेट नहीं करता है। .. और प्रोग्राम में कोई एरर नहीं दिखाता है  

Monday, July 26, 2021

Create a report file in Foxpro

 

fjiksZV

MsVk dks fyLV dekaM dh enn ls fLdzu ij iznf’kZr fd;k tk ldrk gSA fyLV ds }kjk vkmViqV dk izLrqrhdj.k gksrk gS ij u rks blesa dgha ;g fy[kk x;k gS fd vkmViqV fdl dke ds fy;s gS u gh blesa fofHkUu vkafdd izfdz;k;sa djus dh lqfo/kk miyC/k gSA ;fn QkbZy dks fdlh dze esa O;ofLFkr :Ik ls fizaV djkuk pkgrs gSa rks ;g Hkh blesa laHko ugha gSA bl vlqfo/kk ls cpus ds fy, rFkk vkmViqV dks vf/kd iBuh; rFkk vkd”kZd cukus ds fy, QkDlizks esa ,d vR;ar izHkko’kkyh fjiksZV izLrqrhdj.k lqfo/kk iznku dh xbZ gS ftlds tfj;s MsVk QkbZy dks ,d lqfo/kk iznku ds lkFk ,d fu/kkZfjr QkesZV ds :Ik esa izLrqr fd;k tk ldrk gSA bl QkesZV esa tgka MsVk QkbZy dk vf/kd iBuh; :Ik esa izLrqr fd;k tkrk gS ogka vf/kdkf/kd lwpukvksa dk ,d lkFk izLrqr fd;k tk ldrk gSA

fjiksZV dh fuEufyf[kr fo’ks”krk,a %&

1 fdlh fu/kkZfjr ‘kh”kZd dks fjiksVZ ds izR;sd ist ij fizaV fd;k tk ldrk gSA

2 fQYM ;k fjdkMZ dks vko’;drkuqlkj eupkgs dze esa O;ofLFkr fd;k tk ldrk gSA

3 QhYM ds lkFk&lkFk mi;ksxh VsDLV dks Hkh fy[kk tk ldrk gSA

4 QhYM dh pkSMkbZ dks fjiksZV ds nkSjku gh de ;k T;knk izLrqr fd;k tk ldrk gSA

5 izR;sd ist ij ‘kh”kZd ds lkFk&lkFk QqVj Hkh fizaV fd;k tk ldrk gSA

6 i`”B ds vkdkj] ekftZu dks fu;af=r fd;k tk ldrk gSA

7 fjiksZV ds fofHkUu Hkkxksa dks vyx&vyx LVkbZy esa tSls& Bold, Italic, Bold Italic rFkk Underline izdkj ls fizaV fd;k tk ldrk gSA

8 fjiksZV ds fdlh Hkh Hkkx dks ckDl ds vanj gh izLrqr fd;k tk ldrk gS] tSls& tksM] ?kVkuk] vkSlr vkfn dh x.kuk dh tk ldrh gSA

9 vkafdd MkVk ds vk/kkj ij dbZ vad xf.krh; izfdz;k,a dh tk ldrh gSaA MkVk dh fofHkUu xzqi esa  oxhZd`r dj fizaV fd;k tk ldrk gS rFkk fofHkUu xzqi ds Hkkxksa dks vyx&vyx tksMk tk ldrk gSA fjiksZV izLrqrhdj.k ds fy;s ,d ls vf/kd MkVk QkbZy dk iz;ksx fd;k tk ldrk gSA Creat Report dekaM }kjk cuk;k tkrk gSA ftldk ,DlVsa’ku - .FRX gksrk gSA

10 fjiksZV iwjs MkVk QkbZy ds lkFk iz;ksx djus ds LFkku ij dqN p;fur fjdkMZ dk Hkh iz;ksx djus ds fy;s Hkh fu;af=r fd;k tk ldrk gSA

ge ,d MsVkcsl cukrs gSA

Create Sales

mlesa

cust_name       C      20

quantity           N      3

pro_name        C      20

price                N       6

total                 N      9

ysaxsA tSls dh mij MsVkcsl cuk gSA bls ctrl+w ls lso dj ysA vc blesa fjdkMZ tksM ns flQZ total esa dksbZ ,aVjh u djsaA

vc dekaM foaMks ij fy[ks

Replace all total with price*quantity <enter>

Index on pro_name tag p <enter>

Create report sales <enter>

,d fLdzu vk;sxk ftlesa rhu cSaM feysxk page header, detail, page footer. blesa nks cSaM vkSj tksMsaxs

Report menu esa data grouping esa fDyd djsaxsA

QkDlizks ds vkmViqV vf/kd iBuh; rFkk vkd”kZd cukus ds fy;s QkDlizks esa vR;ar izHkko’kkyh fjiksZV  izLrqrhdj.k lqfo/kk iznku dh xbZ gS ftlds tfj;s MsVk QkbZy dks ,d fu/kkZfjr izk:Ik ds  :i esa izLrqr fd;k tk ldrk gSA bl izk:Ik esa tgka MsVk QkbZy dks vf/kd iBuh; :Ik esa izLrqr fd;k tkrk gSA ogha vf/kdkf/kd lwpukvksa dks izLrqr fd;k tk ldrk gSA fjiksZV fuekZ.k djus ds fy;s dekaM foMksa ij fuEu nhft,&

Use Sales

Syntax:-Create Report file name <press enter>

Ex:-       Create Report Product <press enter>


Report dks Screen ij ns[kus ds fy;s fuEu Command dk iz;ksx fd;k tkrk gSA

Syntax:- Report Form File name <press enter>

Ex:-         Report Form Product <press enter>

               Modi Report Product <press enter>

Report Screen rhu Hkkxksa esa ckaVk tk ldrk gS%&

Page Header

Detail

Page Footer

Page header- bl Hkkx dk iz;ksx Report ‘kh”kZd fy[kus ds fy;s fd;k tkrk gS] ;g ‘kh”kZd Report ds izR;sd Page ij Print gksrk gSA

Detail- bldk iz;ksx Report ds okLrfod fgLls rS;kj djus ds fy;s fd;k tkrk gSA Report ds fy, vko’;d lHkh Field ;k muds vk/kkj ij x.kuk,a blh fgLls esa fu/kkZfjr dh tkrh gSA

Page footer- izR;sd Page ds var esa Footer iznf’kZr djuss ds fy, bldk iz;ksx fd;k tkrk gSA Report dk Preview fn[kkus ds fy;s File Menu ds Preview Option dk iz;ksx fd;k tkrk gSA Report dks Run djkus ds fy;s Report Form File Name Command dk iz;ksx fd;k tkrk gSA

Report esa Page Header, Page Footer, Detail ds vykok nks vkSj Band dks Mkyk tk ldrk gSA

Title Band-  bl Band esa fy[kh x;h Text Report ds igys Page ij Print gksrk gSA

Summary Band-  bl Band esa Mkyk x;k VsdLV vk[kfj fjdkMZ ds rqjar ckn fizaV gksrk gSA

Step:- Report Menu- Title/Summary Band.

DATA GROUPING

     tc [kqyh gqbZ MsVkcsl QkbZy ds fjdkMZ dks xqzi esa ckaVuk gks rks Data Grouping djus dh vko’;drk gksrh gS] Data Grouping djus ds fy, ml fQYM dk baMsDlhx djuk vko’;d gksrk gSA ftUkls xzqihax cukuk pkgrs gSaA tc xzqihax djrs gSa rks Report Designer Window esa nks vkSj Band fn[kkbZ nsrs gSa ;s gS%& 1] Group Header 2] Group Footer. Group dh Heading dks nsus ds fy, Group Header dk iz;ksx djrs gSa rFkk Group ds Footer esa tc Group ls lacaf/kr x.kuk,a dh tkrh gS Data Grouping ds fuEu Step gS%&

Report- Data Grouping- ml QhYM dk uke nhft, ftldk xzi cukuk pkgrs gSaA

In Dell Laptop user ask for how to use function keys.

 In Dell Laptop user ask for how to use function keys.

There is a Fn key next to ctrl key . So press Fn Key with function key .... like we want to use Function key F1 then press Fn+F1 

Voucher Color in Tally

The back color of Payment voucher in Tally is Light Pink .

The back color of Receipt voucher in Tally is Light Violet.

The back color of Contra voucher in Tally is White.

The back color of Sales voucher in Tally is Light Violet.

The back color of Purchase voucher in Tally is Light Pink.

The back color of Journal voucher in Tally is Pink.

Sunday, April 4, 2021

Tally GST with Example


GST के लिये ERP 9 Tally में करे 

और साथ ही release 6 या 6 से उपर का होना जरुरी है 

जो आपको Gate way of Tally में नीचे की ओर दिखेगा !!

Question

A article is marked at Rs 15000.

A dealer sells it to a consumer at 10% profit. 

If the rate of GST is 12% find:

(i) the selling price (Excluding tax) of the article.

(ii) the amount of tax (under GST) paid by the consumer.

(iii) the total amount paid by the consumer.

Solution:

(i) marked price of the article =15000 Rs.

when sold at 10% profit

profit=15000*(10/100)=1500 Rs

Thus the selling price (excluding tax)=15000+1500

=16500 Rs.

(ii) The rate of GST is 12%

Thus the amount of tax (GST) paid by the consumer would be 

=16500*(12/100)

=1980 Rs

(iii) Therefore, the total amount paid by consumer= Selling price + GST

=  16500 Rs + 1980 Rs

= 18480 Rs

Tally Solution 

GST

Create a Company

Gateway of Tally> Create Company

Name > ABC & Co.

Country> India 

State > Chhattisgarh 

Gateway of Tally> press F11>F3

Enable GST Goods and services Tax> yes

Set/alter GST Details >yes

GSTIN/UIN  22AAAAA1234A1Z5 (for CG )

Press Ctrl+A

Press Ctrl+A

Create a Item for Computer

Gateway of Tally > Inventory Info > Stock Items> Create> Computer

Under > Primary

Category > Not Applicable

Units> ctrl + c 

Name Pcs

Under Primary

Ctrl + A

Ctrl+ A

Create a Ledger for Buyer Mohan

Gateway of Tally> Accounts Info> Ledgers> Create > Buyer Mohan

Under> Sundry Debtors 

Maintain bill by bill >yes

Country >India

State >Chhattisgarh 

Registration Type>Regular

GSTIN/UIN > 22AAAAA1234A1Z5

Set/Alter GST details ? yes

Yes करने पर एक screen आयेगा अगर नही आया तब F12 press करना फिर

Provides aliases along with name? Yes

Provide advanced information in master? Yes

Provide address for ledger accounts? Yes

Registration type Regular 

Access of other Territory? No

Is e-commerce operator ? No

Consider party as deemed export for purchase ? No

Party type Not Applicable

GSTIN/UIN 22AAAAA1234A1Z5

Is a transporter ? No

Ctrl+A

Ctrl + A

Create a Ledger for Consumer Sohan

Gateway of Tally> Accounts Info> Ledgers> Create > Consumer Sohan

Under> Sundry Creditors 

Maintain bill by bill >yes

Country >India

State >Chhattisgarh 

Registration Type>Regular

GSTIN/UIN > 22AAAAA1234A1Z5

Set/Alter GST details ? yes

Yes करने पर एक screen आयेगा अगर नही आया तब F12 press करना फिर

Provides aliases along with name? Yes

Provide advanced information in master? Yes

Provide address for ledger accounts? Yes

Registration type Regular 

Access of other Territory? No

Is e-commerce operator ? No

Consider party as deemed export for purchase ? No

Party type Not Applicable

GSTIN/UIN 22AAAAA123451Z5

Is a transporter ? No

Ctrl + A

Ctrl + A

Create a Ledger for CGST

Gateway of Tally > Accounting Info > Create > CGST 

Under> Duties & Taxes

Type of duty’s/Tax > GST

Tax type > Central Tax

Ctrl+A

Create a Ledger for SGST

Gateway of Tally > Accounting Info > Create > SGST 

Under> Duties & Taxes

Type of duty’s/Tax > GST

Tax type > State Tax

Ctrl + A

Create a Ledger for Profit

Gateway of Tally > Accounting Info > Create > Profit

Under> Indirect Income

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description computer Profit 

Nature of Transaction Sales Taxable 

Tax Type

Integrated Tax 12%

Central Tax 6%

State Tax  6%

Ctrl + A

Type of supply Goods

Ctrl +A

Create a Ledger Purchase Nil

Gateway of Tally > Accounting Info > Create > Purchase nil

Under> Purchase Account

Inventory Values are affected? Yes

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description Purchase Nil

Nature of Transaction Purchase Nil Rated

Tax Type

Integrated Tax 0%

Central Tax 0%

State Tax  0%

Ctrl + A

Type of supply Goods

Ctrl + A

Create a Ledger Sales

Gateway of Tally > Accounting Info > Create > Sales

Under> Account

Inventory Values are affected? Yes

Is GST Applicable? Applicable 

Set/ alter GST details? Yes

कभी कभी screen में HSN/SAC details नही मिलता तब F12 press करना

Allow HSN/SAC details? Yes

और 

Show all GST tax types? Yes 

करना

Description Sales 12%

Nature of Transaction Sales Taxable 

Tax Type

Integrated Tax 12%

Central Tax 6%

State Tax  6%

Ctrl + A

Type of supply Goods

Ctrl + A

Voucher Entry 

Gateway of Tally > Accounting Voucher > F9 Purchase ctrl + V 

हमेशा entry 1 July के बाद का date दे क्योंकि GST July से लागू हुआ है

Party name Consumer Sohan

Name of item 

Computer  1 pcs 15000

Profit 10%.            1500

Total                   16500 (automatic)

हमेशा entry 1 July के बाद का date दे क्योंकि GST July से लागू हुआ है

Gateway of Tally > Accounting Voucher > F8 Sales ctrl + V 

Party name Buyer Mohan 

Name of item 

Computer  1 pcs 16500

Enter

CGST                          990 (automatic)

SGST                          990 (automatic)

Total                         18480 (automatic)

अगर इसका print लेना है तब

Alt + p फिर mouse से right side menu में Alt + I को click करना तब preview दिखायेगा 

Details देखने के लिये 

Date को जरुर set कर ले Alt + F2

Gate way of Tally > Display > Day Book > Alt + F1 

Saturday, April 3, 2021

Creating Database file List Browse.....


 

Display, Locate ect Commands of Foxpro


 

Important Commands of Foxpro


 

Sort & Index Commands in Foxpro


 

Hyperlink Cross Reference and BookMark


 

Tricks & Tips for MS-Word


 

Goggle Form Questionnaire


 

Basic Commands of DOS Operating System


 

Fundamentals of Computer


 

Shortcut Keys for Power Point


 

Shortcut Keys For MS-Excel


 

Shortcut Keys for MS-Word


 

Types of Internet Services


 

Internet Connectivity


 

TCP/IP and OSI Model


 

Internet Terminology


 

Introduction of Internet


 

Computer Virus


 

Drop Down List in Excel


 

Payroll System in Tally


 

Memorandum Voucher in Tally


 

Scenario Management in Tally


 

Interest Calculation in Tally


 

Bank Reconciliation


 

Accounts and Inventory in Tally


 

Stock Entry in Tally


 

Company Creation with Voucher Entry


 

How to Create Ledger and Group


 

Tally Terminology


 

Budget in Tally


 

Export Import in Tally


 

Insert Check Marks in Excel




 

Number System


 

How to Create Macros in MS-Word


 

Logic Gates Part I


 

Logic Gate Part II


 

How to Create a Company


 

Create Form Through Developer


 

Birbal Ki Immandari


 

Theen Prashne


 

Patilae Ki Mrituu






 

Badshah Ka Adesh


 

Khush Kabari




 

Joru Ka Gulam


 

Akbar Ka Tota


 

Dudha Bhai


 

Mulla Do Payaja


 

Badshah Ka Sawal


 

Sabse Teja Chal

 


Chor ki Dadi Mai Tinka


 

Badshah Ka Adesh


 

Huzur ka Sevak


 

Char Bewakufa


 

Amir Garib


 

Kavi Ka Innam


 

Bansa Ka Tukada


 

Birbal Ka Guru


 

Theen Kahaniya


 

Badashah Ka Sapna


 

Malikana Hqua


 

Jaise Ko Taisa


 

Badashah ka Sala


 

Chamatkari Pade


 

Badshah ka Hukum


 

#Akbar #Birbal #Ki #Mulakat


 

#Pade #ki #Gawahi


 

Visual Basic .Net Programming

 Program 1 Sum of Two Numbers Form Design for Sum of Two Numbers Coding for OK Button Dim a, b, c as integer a=textbox1.text b=textbox2.text...