home *** CD-ROM | disk | FTP | other *** search
/ Frostbyte's 1980s DOS Shareware Collection / floppyshareware.zip / floppyshareware / DOOG / QATEMPLA.ZIP / INVOICE.DTF (.txt) < prev    next >
Symantec Q&A Database File  |  1990-03-13  |  55KB  |  337 lines
  1. SYMANTEC TOUCHBASE DATABASE
  2. Pat V. ext. 2732
  3. *b230W
  4. *b230W
  5. *b230W
  6. *b230W
  7. *b230W
  8. *b230W
  9. *b230W
  10. *b230W
  11. *b230W
  12. *b230W
  13. rrison x8980
  14. nvoice #:
  15. Percent!of!Total Sales
  16. @left(@round(#3/@total(#3)*100,2),5) + " %"
  17. 10,F(JR)
  18. Salesman!Total
  19. @total(#10,#1)
  20. Salesman!Total
  21. @left(@str(#15)+" %",(#50<>#1)*100)
  22. 20,F(JR)
  23. mino Real1/23/90Campb
  24. !Percent of Sales by Salesman
  25. !@date(11)
  26. !- # -
  27. 08) 111-2322Thank you for your patrona
  28.                                                                               
  29.                                                                               
  30.                              
  31. "                                  
  32.                  
  33.                                                                               
  34.                                                                               
  35. Possible Lookup choices
  36. U: UPS Ground
  37. B: UPS Blue
  38. R: UPS Red
  39. F: Federal Express
  40. W: Best Way
  41. M: US Mail
  42. 2%, Net 10
  43. Net 30
  44. Check
  45. Credit Card
  46. UPS Ground
  47. UPS Blue
  48. UPS Red
  49. Federal Express
  50. Best Way
  51. US Mail
  52. Sam S.
  53. Paul V.
  54. Jeff G.
  55. Laura G.
  56. Kari J.
  57. 93021
  58. *b230W
  59. Brian's Sport Shop(408) 555 - 13547822 West El Camino RealCampbell, CA 91134@dateCashThank you for your patronage!Please call us with any questions(408) 555 - 1354
  60. 21,AS3,ST,T
  61. 2,AS,CS1,AS3,ST,T
  62. ..UPS..;..Fed..hop(408) 555 - 13540000937822 West El Camino Real1/23/90Campb/
  63. ee4342.001368.0
  64. !Address Log!Page #
  65. !@date(11)
  66. 8) 555 - 1354
  67. Sales by Salesman
  68. Sales by Day
  69. Payment Method
  70. Address List
  71. Shipping Log
  72. *b230
  73. Brian's Sport Shop(408) 555 - 13540001017822 West El Camino Real2/1/90Campbell, CA 911341/20/90PAUL V.David FeldkampDavid FeldkampSymantecSymantec43234 Elm St.43234 Elm St.San JoseCA94323San JoseCA94323(408) 111-2322(408) 111-2322Best WayNET 302322-42223-3212B4323332-44343Hamburger Meat434.00136.00644Buns254.22108.4422.3017.11283.85Thank you for your patronage!Please call us with any questions(408) 555 - 13544
  74.                 
  75. Invoice #:
  76.            
  77.          $
  78. Q&A Invoive Manager            (Press any key to exit help)
  79.                               
  80. This is a pre-defined Sales Invoice.  You can customize it to your business by setting the Initial Values in the Customize menu to your own information.  The Sold to and Ship to sections will look into previous invoices to fill in the customer information.  If you leave the Attn: field   blank in "Ship to", the "Sold to" name will be copied over.
  81. Look up? (Y/N)
  82. ! is not in&
  83. Possible Lookup Choices
  84. 2 : 2%, Net 10
  85. 3 : Net 30
  86. D : COD
  87. K : Check
  88. CC: Credit Card
  89. C : Cash
  90. Jan 20, 1990
  91. 3:37 pm
  92.           Q&A WRITE -- B. Emerald                                                                                                                                                                                                                            
  93.                                                        
  94.  INVOICE 
  95.  <AA                           > <AB                 > 
  96.  Invoice #:AC          
  97.  <AD                           >                       
  98.  Order Date:AE         
  99.  <AF                           >                       
  100.  Inv. Date:AG          
  101.                                                        
  102.  Salesman:AH           
  103.  Sold to 
  104.  Ship to 
  105.          <AI            ><a><AJ><AK>  
  106.           <AL            ><b><AM><AN>  
  107.  Attn:AO                              
  108.  Attn:AP                               
  109.  Co:AQ                                
  110.  Co:AR                                 
  111.  Addr:AS                              
  112.  Addr:AT                               
  113.  Cty:AU               St:AV  Z:AW     
  114.  Cty:AX               St:AY   Z:AZ     
  115.                                       
  116.                                        
  117.  Phone:Aa                             
  118.  Phone:Ab                              
  119.    Ship Via   
  120.      Terms     
  121.    Card Number   
  122.   Auth Card  
  123.    PO Number   
  124. <Ac          >
  125. <Ad           >
  126. <Ae             >
  127. <Af         >
  128. <Ag           >
  129. Instructions<Ah
  130.                                                                                >
  131.  Part 
  132.  Description 
  133.  Qty 
  134.  Price 
  135.  Extended 
  136. <Ai       >
  137. <Aj                             >
  138. <Ak  >
  139. <Al      >
  140. <Am          >
  141. <An       >
  142. <Ao                             >
  143. <Ap  >
  144. <Aq      >
  145. <Ar          >
  146. <As       >
  147. <At                             >
  148. <Au  >
  149. <Av      >
  150. <Aw          >
  151. <Ax       >
  152. <Ay                             >
  153. <Az  >
  154. <BA      >
  155. <BB          >
  156. <BC       >
  157. <BD                             >
  158. <BE  >
  159. <BF      >
  160. <BG          >
  161. <BH       >
  162. <BI                             >
  163. <BJ  >
  164. <BK      >
  165. <BL          >
  166. <BM       >
  167. <BN                             >
  168. <BO  >
  169. <BP      >
  170. <BQ          >
  171. <BR       >
  172. <BS                             >
  173. <BT  >
  174. <BU      >
  175. <BV          >
  176.                                                      
  177.  Shipping   <BW         >
  178.  <BX>                                                
  179.    Tax 7%   <BY         >
  180.                                                      
  181.     Total   <BZ         >
  182.                                                      
  183.                                                                               
  184.                                                                               
  185.                        <Ba                           >                        
  186.                      <Bb                                >                     
  187.                              <Bc               >                              
  188.                                                                               
  189.                                                                               
  190. *b230W
  191. 5x1x10x15+20+25x30x,28) 555 - 13540001037822 West El Camino Real1/23/90Campb.
  192. 5x10x15x20+25+30x40x1x,2e!Please call us with any questions(408) 555 - 1354A
  193. !Sales by Day
  194. !Printed @date(11)
  195. - # -
  196. y questions(408) 555 - 1354     
  197. !X#30
  198. !X#30
  199. !Look Up? (Y/N)
  200. !X#30
  201. !X#40
  202. !X#30
  203. !X#50
  204. !X#30
  205. !X#60
  206. !X#30
  207. !X#70
  208. !X#30
  209. !X#77
  210. !X#30
  211. !X#80
  212. !X#35
  213. !X#35
  214. !Look up? (Y/N)
  215. !X#35
  216. !X#45
  217. !X#35
  218. !X#55
  219. !X#35
  220. !X#65
  221. !X#35
  222. !X#75
  223. !X#35
  224. !X#78
  225. !X#35
  226. !X#85
  227. !Enter the Zipcode
  228. !Enter the Zipcode
  229. !Press [F1] for choices.
  230. !Press [F1] for choices.
  231. !Hit [F2] to Print, [Shift][F10] to save and exit.
  232. 03: goto #104<#104:if #103>(
  233.  INVOICE 
  234.                              
  235.                    
  236. Invoice #:
  237.            
  238.                              
  239. Order Date:
  240.           
  241.                              
  242. Inv. Date:
  243.            
  244.     Salesman:
  245.             
  246.  Sold to 
  247.  Ship to 
  248.               
  249.               
  250. Attn:
  251.                                
  252. Attn:
  253.                                  
  254. !                                 
  255. "                                  
  256. Addr:
  257.                                
  258. Addr:
  259.                                  
  260.                 
  261.       
  262.                 
  263.       
  264.                                       
  265.                                        
  266. Phone:
  267.                               
  268. Phone:
  269.                                
  270.    Ship Via   
  271.      Terms     
  272.    Card Number   
  273.   Auth Card  
  274.    PO Number   
  275.             
  276.              
  277.                
  278.            
  279.              
  280. InstructionsA
  281. ;#65=#60;#75=#70;#78=#77;#85=#)
  282.  Part 
  283.  Description 
  284.  Qty 
  285.  Price 
  286.  Extended 
  287.              
  288.                                
  289.         
  290.             
  291.              
  292.                                
  293.         
  294.             
  295.              
  296.                                
  297.         
  298.             
  299.              
  300.                                
  301.         
  302.             
  303.              
  304.                                
  305.         
  306.             
  307.              
  308.                                
  309.         
  310.             
  311.              
  312.                                
  313.         
  314.             
  315.              
  316.                                
  317.         
  318.             
  319. Shipping
  320.            
  321. Tax 7%
  322.            
  323. Total
  324.            
  325. "" then if #192 <> "" then goto #150 e
  326.     ]    ]    `    n    
  327. <#1000:goto #10<#10:if #10="" then {#10=@number;#10=@text(6-@len(#10),"0") + @str(#10)};#15=@DATE;goto #15>#15:goto #21<#21:goto #22>#22: lookup(#22,3,#22);goto #30<#26:if @xlookup(@filename,#30,"X#30","X#30")<>"" then {#26="Look Up? (Y/N)"; #27=@mid("NY",(#50="")+1,1); goto #27} else if #30 <>"" then {@msg("");goto #40} else goto #40>#27: if #27="N" then {#26="";#27=""; goto #40} else {#26="";#27="";goto #28}<#28:xlookup(@filename,#30,"X#30","X#40",#40);xlookup(@filename,#30,"X#30","X#50",#50);xlookup(@filename,#30,"X#30","X#60",#60);goto#29<#29:xlookup(@filename,#30,"X#30","X#70",#70);xlookup(@filename,#30,"X#30","X#77",#77);xlookup(@filename,#30,"X#30","X#80",#80);#26="";#27="";goto #40<#36:if@xlookup(@filename,#35,"X#35","X#35")<>""and#35<>""then{#36="Look up? (Y/N)";#37=@mid("NY",(#55="")+1,1);goto#37}else if#35<>""then{@msg("");goto #45}else{#35=#30;#45=#40;#55=#50;#65=#60;#75=#70;#78=#77;#85=#80;goto #45}>#37: if #37="N" then {#36="";#37="";goto#45} else {#36="";#37="";goto #38}<#38:xlookup(@filename,#35,"X#35","X#45",#45);xlookup(@filename,#35,"X#35","X#55",#55);xlookup(@filename,#35,"X#35","X#65",#65);goto#39<#39:xlookup(@filename,#35,"X#35","X#75",#75);xlookup(@filename,#35,"X#35","X#78",#78);xlookup(@filename,#35,"X#35","X#85",#85);#36="";#37="";goto #45>#30: goto #26>#35:goto #36>#40: goto #50>#45: goto #55>#50: goto #60>#55:goto #65>#60: goto #70>#70:@msg("Enter the Zipcode"); goto #77>#77: goto #80>#65: goto #75>#75: @msg("Enter the Zipcode");goto #78>#78: goto #85>#80:IF @LEN(@NUM(#80))=7 THEN #80=@LEFT(@NUM(#80),3)+"-"+@RIGHT(@NUM(#80),4);IF @LEN(@NUM(#80))=10 THEN #80="("+@LEFT(@NUM(#80),3)+") "+@MID(@NUM(#80),4,3)+"-"+@MID(@NUM(#80),7,4); #26="";#27="";goto #35>#85:IF @LEN(@NUM(#85))=7 THEN #85=@LEFT(@NUM(#85),3)+"-"+@RIGHT(@NUM(#85),4);IF @LEN(@NUM(#85))=10 THEN #85="("+@LEFT(@NUM(#85),3)+") "+@MID(@NUM(#85),4,3)+"-"+@MID(@NUM(#85),7,4);#36="";#37="";@msg("Press [F1] for choices.");goto#192>#192:lookup(#192,2,#192); @msg("Press [F1] for choices.")>#193:lookup(#193,1,#193)>#90:if #90="" then if #192 <> "" then goto #199 else goto #150#92>#93: goto #94<#94:if #93 > 0 then #94 = #92 * #93 else #94 = ""; goto #95>#95:if #95="" then if #192 <> "" then goto #199 else goto #150#97>#98: goto #99<#99:if #98 > 0 then #99 = #97 * #98 else #99 = ""; goto #100>#100:if #100="" then if #192 <> "" then goto #199 else goto #150#102>#103: goto #104<#104:if #103> 0 then #104= #102* #103else #104= ""; goto #105>#105:if #105="" then if #192 <> "" then goto #199 else goto #150#107>#108:goto #109<#109:if #108> 0 then #109= #107* #108else #109= ""; goto #120>#120:if #120="" then if #192 <> "" then goto #199 else goto #150#122>#123:goto #124<#124:if #123> 0 then #124= #122* #123else #124= ""; goto #125>#125:if #125="" then if #192 <> "" then goto #199 else goto #150#127>#128:goto #129<#129:if #128> 0 then #129= #127* #128else #129= ""; goto #130>#130:if #130="" then if #192 <> "" then goto #199 else goto #150#132>#133:goto #134<#134:if #133> 0 then #134= #132* #133else #134= ""; goto #135>#135:if #135="" then if #192 <> "" then goto #199 else goto #150#137>#138:goto #139<#139:if #138> 0 then #139= #137* #138else #139= ""; goto #199>#199:goto #150<#198:@msg("Hit [F2] to Print, [Shift][F10] to save and exit.")<#111:goto #150<#150 :if #94 > 0 then {#111 = .07 * @sum(#94,#99,#104,#109,#124,#129,#134,#139); #150 = @sum(#199,#94,#99,#104,#109,#111,#124,#129,#134,#139)} else {#150 = "";#111 = ""}; goto #198#900:#26="";#27="";#36="";#37=""";#27="";#36="";#37=""""";#37=""
  328. 2,AS,CS,SC,C1,AS1040,ST,T
  329.            
  330.     Salesman:
  331. 12,AS,CS,SC,C2,AS6,AS,H(Method!of!Payment)30,ST,T
  332. Brian's Sport Shop(408) 555 - 13540001037822 West El Camino Real1/23/90Campbell, CA 911341/23/90KARI J.John DoeJohn DoeIBMIBM4102 1st Street4102 1st StreetSan JoseCA93023San JoseCA93023(333) 414-5334(333) 414-5334CASHAB342Apple Pie6231.441388.6497.201485.84Thank you for your patronage!Please call us with any questions(408) 555 - 1354
  333. Brian's Sport Shop(408) 555 - 13540000937822 West El Camino Real1/31/90Campbell, CA 911341/20/90KARI J.John JonesJohn JonesApplied ComputerApplied Computer1402 Marilee Ave.1402 Marilee Ave.Santa CruzCA91123Santa CruzCA91123(408) 923-0001(408) 923-0001CASH1234Coffee4342.001368.001245Apples1004.50450.00127.261945.26Thank you for your patronage!Please call us with any questions(408) 555 - 13545=#+
  334. Brian's Sport Shop(408) 555 - 13540001027822 West El Camino Real1/23/90Campbell, CA 911341/21/90PAUL V.David FeldkampSam FrancesIBMIBM43234 Elm St.43311 Elm St.San JoseCA94323San JoseCA94323(408) 111-2322Federal ExprCASH2323Car Parts3745.002235.00150.00156.452541.45Thank you for your patronage!Please call us with any questions(408) 555 - 1354
  335. Brian's Spor23Sa
  336. zCA91123(408) 923-0001(408) 923-0001CASH1234Coffee4342.001368.001245Apples1004.50450.00127.261945.26Thank you for you
  337.