home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Shareware Overload
/
ShartewareOverload.cdr
/
database
/
disk_20.zip
/
NUDBMSX.ZIP
/
BILLING.PRG
< prev
next >
Wrap
Text File
|
1987-01-28
|
2KB
|
90 lines
***** Program: BILLING.PRG *****
* A Billing Program
SET TALK OFF
SET ECHO OFF
PUBLIC INVNO,INVDATE,ACCTNO,ACCTNAME,MADDRESS,CITYSTZIP
CLEAR
DO WHILE .T.
USE INVOICE
DELE ALL
PACK
APPE BLAN
REPL INV_DATE WITH DATE()
@ 3,1 say " Invoice Number : " get inv_no
@ 4,1 say " Invoice Date : " get inv_date
@ 5,1 say " Account Number : " get acct_no
READ
INVNO = INV_NO
INVDATE = INV_DATE
ACCTNO = ACCT_NO
USE ACCOUNTS
LOCA FOR ACCT_NO=ACCTNO
IF EOF()
CLEAR
? " Invalid account number, Reenter !"
LOOP
ELSE
@ 1,1 SAY SPACE(30)
EXIT
ENDIF
ENDDO
@ 3,35 say " Account Name : " + acct_name
@ 4,35 say " Address : " + address
@ 5,51 say trim(city)+" "+state+' '+zip
ACCTNAME = ACCT_NAME
MADDRESS = ADDRESS
CITYSTZIP = trim(city)+', '+state+' '+zip
@7,5 say " Quantity Quantity Quantity"
@8,5 say "Stock No. Model No. Ordered Shipped Back Ordered Unit Price"
SELE 1
USE SALE
SELE 2
USE COSTS
SELE 1
DELETE ALL
PACK
ITEMNO = 1
APPE BLAN
DO WHILE .T.
@ 9+itemno,1 say " " get stock_no
READ
IF stock_no = ' '
EXIT
ENDIF
STOCKNO = STOCK_NO
@ 9+itemNO,28 say ' ' get qty_orderd
@ 9+itemNo,38 say ' ' get qty_shiped
READ
REPL QTY_BO WITH QTY_ORDERD - QTY_SHIPED
@ 9+itemNo,50 say ' ' get qty_bo
READ
@ 21,1 say ' '
WAIT ' Are these quantities correct (Y/N) ? ' to answer
IF upper(answer) = "Y"
@ 22,0 CLEAR
SELE 2
LOCATE FOR STOCK_NO = STOCKNO
IF EOF()
SELE 1
LOOP
ENDIF
@9+ITEMNO,07 say ' ' get model_no
@9+ITEMNO,61 say ' ' get dlR_cost
CLEA GET
MODELNO = MODEL_NO
UNITPRICE = DLR_COST
SELE 1
REPL INV_NO WITH INVNO
REPL MODEL_NO WITH MODELNO
REPL UNIT_PRICE WITH UNITPRICE
ITEMNO = ITEMNO + 1
APPE BLAN
LOOP
ELSE
LOOP
ENDIF
ENDDO
CLOS DATABASES
DO PRINTINV
RETURN