06/21/1999 Upgrade! of the MOST4IRS spreadsheet has a new look for compatibility with your MOST database forms and an added spreadsheet for calculating the Time factor. You can download the sheet for Excel 5 at * MOST4IRS

04/10/1999 UpGrade! for StrongWare for Microsoft Access 7 and Corel Paradox 7.

Several upgrades are available to provide for enhanced commercial use:

    1. The PersDat database is created as a separate table, query, form, and reports; and
    2. The WrkPln42 is enhanced with fields for commercial work.

You can augment your PrsNote database with your separate PersDat database, which is the same as the PrsNote. The PersDat queries, forms and reports are based on the new PersDat database and QpersDat query. You can load the SWAc7x.exe and expand it, then add the table and query into your SWAc7.mdb.

The simplest way to do this is to open the SWAc7x.mdb and copy the PersDat table to the clipboard, then open your SWAc7, select Table, New, and past in the PersDat fields, then save it as PersDat. Next, go to Query, New, and select PersDat and create the new query. You can then do the same with your PersDat for and your PersDat reports, copying from your new SWAc7x files into your old Swac7 form and report files. You can aalos, as an alternative, simply open your forms and reports in the Design mode and change the data menu to show that they are based upon the new table and query.

You can repeat the procedure for the new WrkPln42. The new table has added fields for:

[Profit] or [Commision]: For Office Use Only

GandA:=> 20.00 Cost+: 45.40 BusTax@50%: 22.70 Gross: 295.10

Profit%:=> 0.200 Profit:=> 45.40 BusTax:=> 22.70 Billing:=> 295.10

Salespers: Worker:

Contact: CreditCard

Orgadres: CCNbr:

City: CCExp:

State: Telefone:

ZIP: FAX:

Email:

Account Type- Account Receivable = A ; Paid = P ; Returned = R ; Personal Use: A

 

You can also do a report for an Invoice:

Please remit payment for the following work

WorkPlan: Description of Work: Date: SubTotal:

HE000001 House Electrical 3/27/99 295.10

 

You can also report as a columnar log:

 

Rec.Id: Line Item: Budget Item: CostTotal GandA BusTax: Profit: Billing: ACCTYPE: DATE:

RECNO: About:

HE000001 House Improvements Electrical 207.00 20.00 22.70 45.40 295.10 A 3/27/99

1 Replace electrical outlets with GFCIs

Total Labor and Cost: 207.00 20.00 22.70 45.40 295.10

 

 

 

If you would like to enter your WorkPlan data into your Organizational Budget spreadsheet, "OrgBud", then you can use your Wrk4OB report. The best way to do this is to print to Word, then copy and paste the report footer data into your OrgBud. You can do this on a monthly basis for a particular product market. You can paste: the CMSUM as your CoGS 'purchases'; the Labor as 'labor'; and the travel, meals and other into their respective expense cells. 

	WorkPlan for Small Business Budget, SBB, 
	Labor:	CMSUM:	CESUM:	Travel:	Meals:	Lodging:  Phonexp:  OtherCost	Billing: WRKRECNBR
	100.00	120.00	1.00	55.00	66.00	77.00	     22.00	 7.00	  535.10 HE000001
	 20.00	  4.00	0.00	 0.00	 0.00	 0.00	                                 J1

	Labor:	CMSUM:	CESUM:	Travel:	Meals:	Lodging:  Phonexp:  OtherCost   Billing:
	120.00	124.00	1.00	55.00	66.00	77.00	     22.00	 7.00     535.10

Back to -> *Home