Skip to main content
Home
Live to Learn!

Main navigation

  • Home
  • Learn
    • FoxPro
    • MS-DOS
    • C PRG
    • Java
    • ASP
    • Ruby on Rails
    • ASP.NET
    • E-Books
    • Exam Preparation
    • Tools
  • Blog
  • Forums
  • Contact
User account menu
  • Log in

Breadcrumb

  1. Home
  2. FoxPro Programming

Simple Journal Entry program

Book navigation

  • FoxPro Commands - Part 1
  • Foxpro commands - Part 2
  • Data Types in FoxPro
  • Numeric Functions in FoxPro
  • Creating a Program
  • Input and Output Statements in Foxpro
  • Control Structures in Foxpro
  • Creating menu in Foxpro for DOS
  • Simple Journal Entry program
  • Simple Ledger creation & Posting Program
  • Trial Balance Program
  • Balance Sheet Program
  • Simple Weekly Calendar Generation
  • How to install FoxPro 2.6 in Windows 10 / Windows 8 / Windows 7?
  • How to install FoxPro 2.6 on Linux OS (Ubuntu 20.04 | 20.10 | 21.04)?
  • How to install FoxPro in Windows 10 64 bit using VDosPlus?
By Karthikeyan , 28 September, 2009

CLEA
clea all
set talk off
use jour1
reply = "y"
GO BOTTOM
	DO WHILE UPPER(REPLY) = "Y"
	STORE 0 TO CRE, DEB
	STORE SPACE(10) TO P1, P2
	STORE SPACE(15) TO NR
	STORE CTOD("  / /  ") TO DATE1
	@4,10 SAY [DATE :] GET DATE1
	@6,10 SAY [PARTICULAR1 :] GET P1
	@6,45 SAY [DEBIT :] GET DEB
	@8,10 SAY [PARTICULAR2 :] GET P2
	@8,45 SAY [CREDIT :] GET CRE
	@12,10 SAY [NARRATION :] GET NR
	READ
	APPEND BLANK
	@18,10 SAY [DO U CONTINUE(Y/N)?] GET REPLY
	READ
	REPL DATE WITH DATE1
	REPL PART1 WITH P1
	REPL PART2 WITH P2
	REPL NAR WITH NR
	REPL DEBIT WITH DEB
	REPL CREDIT WITH CRE
ENDDO
CLEAR
SET DEVI TO SCRE
SET PRINT ON
SET PRIN TO RESUME1.OUT
@2,30 SAY "JOURNAL ENTRIES"
@3,0 SAY REPLICATE ("-",75)
@4,5 SAY "DATE"
@4,18 SAY "PARTICULARS"
@4,48 SAY "DEBIT"
@4,58 SAY "CREDIT"
@5,0 SAY REPLICATE ("-",75)
GO TOP

ROW = 6
DO WHILE .NOT. EOF()
@ROW,6 SAY DATE
@ROW,19 SAY PART1 +[ DR]
@ROW+1,19 SAY [TO ]+PART2
@ROW+2,19 SAY [ (BEING ] +NAR+ [)]
@ROW,45 SAY DEBIT
@ROW+1, 55 SAY CREDIT
IF ROW >18
WAIT ""
@6,0 CLEAR
ROW = 6
ELSE
ROW = ROW + 3
ENDIF
SKIP
ENDDO
SET DEVI TO SCRE
SET PRIN TO
SET PRIN OFF
Screenshots

FoxPro Journal Entry - Database

FoxPro Journal Entry

FoxPro Journal Entry - View

Tags
Foxpro Programs

Comments4

NAVRANG (not verified)

9 years 1 month ago

Can anybody send me VISUAL FOXPRO data entry form/programe. I want to use it in my office. please sent at [email protected]. thanks

ritesh (not verified)

11 years 3 months ago

would u plzz show me output window of this prog

Profile picture for user Karthikeyan

Karthikeyan

11 years 3 months ago

In reply to by prem singh (not verified)

Create jour1.dbf file with necessary fields such as date, particulars, cr, db.

http://livetolearn.in/site/...

prem singh (not verified)

11 years 3 months ago

how to add jour1.dbf file please help

Featured Blog Posts

Convert Currency in Number to Words (Indian Rupees) - MS Excel
Foxpro Tutorial and Programs
Convert Currency in Number to Words in MS Word
Convert Currency in Number to Words (Indian Rupees) - Version 2
Best way to Use Rupee Symbol in Windows – Easy steps
Convert Currency in Number to Words - MS Access
Creating All in One Windows XP DVD with all Important Applications
RSS feed

© 2009-2025 Live to Learn.In

Terms of Use | Privacy Policy