Custom Report and Label Making

15.4.1 Overview

The configuration menu in pc/MRP for Windows version 6.49AH and higher contains a custom Visual FoxPro report writer that allows users to modify pc/MRP reports. The table below contains the name of pc/MRP's standard and custom reports and the dbf file used with each report. Prior to modifying or creating a report or label, back up the original standard .frx and .frt report files or the standard .lbx and lbt label files to floppy disk for safe keeping. These back up files will come in handy if you make a mistake and need to restore the original files.

It is best to open a standard report, rename it to the correct custom name, and then modify the new report as standard reports are overwritten and custom reports are not overwritten when pc/MRP is updated to a newer version.

For more detailed information on the use of the VFP report writer, please see the Microsoft Visual FoxPro site links:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/vfp7startpage.asp

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/lngoverview_of_the_language.asp

A good place to start is our web site that describes report modifications:

http://www.pcmrp.com/mrp101/customtableofcontents.htm

To create a custom report you would, from within pc/MRP:

1. Select Configuration, Settings and Utilities.

2. Enter your configuration code number.

3. Select Option 24.

4. Select Form or Label.

5. Select the correct file you wish to modify or use as a basis for custom report or label

6. Click on Open

7. Select File, Save as, enter the file as a custom .frx report (see sections starting at 15.4.2.1 for correct custom file names to use for your custom reports, forms, or labels), then press Save.

8. Make your modifications

9. Select File, Close, Save Changes

10. Return to pc/MRP's Main Menu

11. Print out the new report selecting Custom instead of Standard for reports.

pc/MRP's Custom Report Writer is shown above with the following icons in the upper left hand corner text A, field ab|, line, sq box , rounded box, and picture (bit map). Clicking on an icon will allow you to add an object. Double clicking on any object allows you to edit and or move it.

Double clicking a field object or clicking on the word object brings up the Report Expression dialog box (shown below) which allows you to edit the object.

The first box contains the expression (field, memory variable, or text) you would like to print out in that area of the report. In the example above the partnumber would print out in the area you are editing. The format field and button will allow you to format the data (!!!! = upper case, 999.999.99 = numeric only with 2 decimal places, etc.). The Print When Box will allow you to specify conditions that must be true for this item to print out. For example entering len(alltrim(partno)) > 0 would print out the part number only if it the length of the trimmed part number were greater than zero. Clicking on the Expression Button will allow you to select the memory or field variable from a list rather than typing in the variable expression by hand as shown below:

In the above example the partno field was selected by double clicking on the partno field in the fields list. If we wanted to print out the first 4 characters of the part number, you could type in left(partno,4) into the expression box or click on the string function list and select the function left(). The String list contains all FoxPro string functions (substr(), alltrim(), etc.). The Logical list contains all FoxPro logic functions (and, or, etc.). The Math list contains all FoxPro math functions (+, -, /, *, etc.). The Date list contains all FoxPro date functions (ctod(), dtoc(), month(), etc.). The Verify button will automatically verify that the expression you have built in the expression box is valid.

15.4.1.1 Example of Modifying a Report

Suppose that you wish to make some changes to an inventory report.

1. Go to the Main Menu

2. Click on the Configuration option

3. Click on Settings and Utilities

4. Click on the Next button

5. Place your cursor over the spinner button

6. Click the "up" arrow until you get "24"

7. Click OK

8. Enter your code number and click OK

9. Click on the Form button

10. Select the parts$.frx file by double clicking or click OPEN

Your screen should look like this:

The first thing you want to do is to save the file.

You want to save using the custom form name so as not to overwrite the original file.

1. Click on File

2. Click on Save As

3. The ‘Save Report As’ box should read: cuspar*.frx (* means any characters you want. Keep the report names relatively short. Some reports will only have a ? or ??. This means your report name can end in any single character or double character you want.)

4. Click the Save button

5. Place your cursor over the title "Partmaster Report"

6. Hit the "delete" button on your keyboard

7. Click on the text box (A) over on the left hand side of the screen

8. Place the cursor over where "Partmaster Report" use to be and click

9. Type in "Partmaster Inquiry" and click somewhere on the screen

10. Click back onto your new text to highlight it with the little square boxes

11. Now go to the menu bar and click on Object

12. Click on Font; this should bring you to a font dialog box

13. The font should be Courier New, font style is Bold and size is 16; click OK

14. Click on Object again

15. Click Pen Color

16. Chose the color red

Your screen should look similar to this:

· Delete the text "DESCRIPTION" in the Page Header field

· Delete the field "DESCRIPTION" in the Detail field

· Click on the Text (A) icon

· Place the cursor where DESCRIPTION used to be in the Page Header field and click

· Type in "CLASSIFICATION" (make sure you type in capital letters)

· The font should be Courier New, bold, size 8

· Highlight CLASSIFICATION and check the font information to make sure

· Click on the Field (ab|) icon

· Place the cursor where DESCRIPT used to be the Detail field and click

· The Report Expression dialog box should pop up

· In the Expression Box type in "CLASS"

· Check the middle radio button: Top--Field Can Stretch

· Click OK

· Now you must stretch out the Field (ab|) cursor using the arrow cursor

You will know when you can stretch out the field when you get a cursor with arrows pointing out from the middle

Your screen should look similar to this:

When you close the parts$.frx screen, you do not need to save any of the changes. This exercise is designed to get you familiar with modifying any report you want.

15.4.2 List of Reports

pc/MRP for Windows includes the report, forms, and labels listed below. If the last character in the report name is "w" it is the wide carriage report. For example the UNCSIN report is the report used for 8.5" x 11" print outs and the UNCSINW report is the report form use for 14" x 11" printouts.

When viewing any report you can view the open tables by pressing CTRL-F10 (CTRL-F12 in 8.10 and above). This will open a TXT file with all of the open tables in the "select area" statement.

By example:

"Select area: 1, Table in Use:

C:\MY DOCUMENTS\PCMRPTEST\PCMRPW750\PARTMAST.DBF Alias: PARTMAST"

This means the partmast.dbf is open when running this report.

REPORT LISTINGS HAVE THE FOLLOWING FORMAT:

REPORT(.FRX)  REPORT DESCRIPTION                                                     DBF FILE USED

15.4.2.1 BOM Module

Standard BOM Reports
ALLBOM	standard all BOMs	bomtemp.dbf
AVABOM	standard parts availability report	bomtemp.dbf
CNVBOM	standard convert parts to assy report	bomtemp.dbf
EXPBOM	standard costed exploded BOM (incls comments)	bomtemp.dbf
PICBOM	standard pick list exploded and single level	bomtemp.dbf
PICBSN	standard pick list with available serial#'s	bomtemp.dbf
SINBOM	standard costed single level BOM	bomtemp.dbf
UNCEXP	standard uncosted exploded BOM (incls comments)	bomtemp.dbf
UNCSIN	standard uncosted single level BOM	bomtemp.dbf
UNCSRF	standard uncosted single level BOM w ref des	bomtemp.dbf
WHEBOM	standard where used	bomtemp.dbf
WHEBOMML	multi-level where used	wheretree(tmp)
Custom BOM Reports
CALLBOM	custom all BOMs	bomtemp.dbf
CAVABOM	custom parts availability report	bomtemp.dbf
CCNVBOM	custom convert parts to assy report(8.00 & below)	bomtemp.dbf
CEXPBOM	custom costed exploded BOM	bomtemp.dbf
CPICBOM	custom pick list exploded and single level	bomtemp.dbf
CSINBOM	custom costed single level BOM	bomtemp.dbf
CUNCEXP	custom uncosted exploded BOM	bomtemp.dbf
CUNCSIN	custom uncosted single level BOM	bomtemp.dbf
CUNCSRF	custom uncosted single level BOM w ref des	bomtemp.dbf
CUSBOM*	custom BOM & Convert Parts to Assembly reports	bomtemp.dbf

Note: tmpb+[the first four characters of the users name].dbf instead of bomtemp.dbf for BOM reports.

15.4.2.2 Accounting Module

Standard Accounting Reports
ACCPAY	accts payable report	receive.dbf
ACCPAYW	accts payable wide carriage report	receive.dbf
ACCREC	accts receivable report	invoice.dbf
ACCRECW	accts receivable wide carriage report	invoice.dbf
BILL	billing statement form	billtmp.dbf
CASHOUT	standard cash out report	purchase.dbf
CHART	standard, narrow, wide carriage chart of acct	chartacc.dbf
CHKREC	check reconciliation report	prgltmp.dbf
COMMISS	commission report based on payment	transact.dbf
COMMISSI	commission report based on invoices issued	invoice.dbf
COSTSALD	cost of sale from stockroom+Employee Module	stocktra.dbf
COSTSALE	cost of sales report based on invoices	invoice.dbf
CURBAL	Std Balance for a date/time period based on the Chart of Accounts	prgltmp.dbf, acctcursor
FIFO	FIFO report	fifotmp.dbf
FORM 1096	1096 Form
FORM 1099	1099 Misc. Form	Form1099.dbf
GLINCOME	standard gl income statement	chartacc.dbf
GLTRIAL	standard trial balance report	chartacc.dbf
HREC	accts receivable payment history report	billtmp.dbf
PPV	purchase price variation report	ppvtmp.dbf
PRCHECKS	single laser check form	mchktmp.dbf
PRCREBIT	standard liability + equity side of bal sheet	chartacc.dbf
PRDCHK	single dot matrix check form	mchktmp.dbf
PRDEBIT	standard asset side of balance sheet	chartacc.dbf
PRGL	t-acct,4th close Mon,curr bal,accting reports	prgltmp.dbf
PRGL2	Std balance for a month, date, or all transactions	prgltmp.dbf, acctcursor
PRGLALL	standard balance for a time period	prgltmp.dbf, acctcursor
PROFITANDLOSS	YTD profit & Loss,Div/Dept YTD Exp & Revenue	Profitandloss.dbf, Chartacc.dbf
PRTRAN	general ledger and 5th close month gl reports	prtrntmp.dbf
PRYTD	year to date expense and revenue report	chartacc.dbf
RECLOG	standard debit memo report	receive.dbf
RELCOSTSO	Cost of salebased upon related doc number	relcostso
REMIT	single check remittance report	transact.dbf
REMITALL	standard remittance report	transact.dbf
ROYALTY	standard royalty report	invoice.dbf
SOMANUFACTURECOST	Sales/Work Order manufacturing cost report	salescursor
SPAY2	summary accts payable report	acpaytmp.dbf
SREC	summary accts receivable report	billtmp.dbf
TAXLOG	in state sales tax report	invoice.dbf
TAXLOGO	out of state sales tax report	invoice.dbf

Custom Accounting Reports and Checks
CACCPAY	custom accts payable report	receive.dbf
CACCPAYW	custom accts payable wide carriage report	receive.dbf
CACCREC	custom accts receivable report	invoice.dbf
CACCRECW	custom accts receivable wide carriage report	invoice.dbf
CBILL	custom billing statement form	billtmp.dbf
CCASHOUT	custom cash out report	purchase.dbf
CCOMMISS	custom commission report based on payment	transact.dbf
CCOMMISS	custom commission report based on invoice	invoice.dbf
CCOMMISS	custom commission on payment/invoice	transact.dbf invoice.dbf
CCOSTSAL	custom cost of sales(invoices),Manufact Variance	invoice.dbf
CFIFO	custom FIFO report	fifotmp.dbf
CHKREC	custom check reconciliation report	prgltmp.dbf
CHREC	custom accts receivable payment history rpt	billtmp.dbf
CPCREBIT	custom Trial Balance credit report	chartacc.dbf
CPPV	custom purchase price variation report	ppvtmp.dbf
CPRDEBIT	custom Trial Balance debit report	chartacc.dbf
CPRGL	custom t-acct,4th close mon, cur bal acct reports	prgltmp.dbf
CPRTRAN	custom general ledger, 5th close month gl reports	prtrntmp.dbf
CPRYTD	Custom year to date expense and revenue report	chartacc.dbf
CRECLOG	custom debit memo report	receive.dbf
CRELCOSTSO	Custom cost of sale based upon Related doc nbr	relcostso
CROYALTY	custom standard royalty report	invoice.dbf
CSOMANUFACTURECOST	Custom SO/WO manufacturing cost report	salescursor
CSPAY2	custom summary accts payable report	acpaytmp.dbf
CSREC	custom summary accts receivable report	billtmp.dbf
CTAXLOG	custom in state sales tax report	invoice.dbf
CTAXLOGO	custom out of state sales tax report	invoice.dbf
CUSCHECK	custom check (6.73 and Higher)	mchktmp.dbf (tmp)
CUSIRS*	custom 1099, 1096 forms

15.4.2.3 Partmaster Module

Standard Partmaster Reports
AVL	Assigned vendor list	Partmast.dbf
BLNKINV	standard disp and pr physical/inventory form	partmast.dbf
BLNKINVW	standard wide carriage physical/inventory frt	partmast.dbf
COSTINV	physical inventory variance report	partmast.dbf
CYCLECNT	cycle count standard form	cyctmp.dbf
DISPPART	inventory/partmaster find part report	partmast.dbf
PARMOV	partmaster inventory movement report	movement.dbf
PARMOVP	physical inventory, inventory movement report	movement.dbf
PART	standard uncosted disp and pr inventory rpt	partmast.dbf
PART$	standard costed pr and wide inventory report	partmast.dbf
PARTS$	standard costed disp inventory report	partmast.dbf
PARTW	standard uncosted wide inventory report	partmast.dbf
PIH	physical inventory history report	pih.dbf
PRICELIS	standard price list report	partmast.dbf
Custom Partmaster Reports
CUSPAR*	custom inventory report	partmast.dbf
Custom Partmaster Reports
CBLNKINV	custom physical inventory count form	partmast.dbf
CUSPIH*	custom physical inv history report	pih.dbf
CUSTCYC	custom cycle count form	Cyctmp.dbf
CUSTPHY	custom physical inventory variance report	Partmast.dbf

15.4.2.4 Invoice Module

Standard Invoice Reports
INVLOG	narrow carriage invoice report	invoice.dbf
INVLOGW	wide carriage invoice report	invoice.dbf
Standard Invoice/Shipper Form
INVOICE	shaded invoice form	invoice.dbf
INVOICEB	boxed invoice form	invoice.dbf
SHIPPER	shaded shipper form	invoice.dbf
SHIPPERB	shaded boxed shipper form	invoice.dbf
Custom Invoice Reports
CUSINV*	custom invoice report	invoice.dbf
Custom Invoice/Shipper Form (Version 7.72 & Lower)
CINVOICE	custom invoice form	invoice.dbf
CSHIPPER	custom shipper form	invoice.dbf
Custom Invoice/Shipper Form (Version 7.73 & Higher)
CINV*	custom invoice form	invoice.dbf
CSHIP*	custom shipper form	invoice.dbf

Note: Invoice reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf in pc/MRP.

15.4.2.5 Sales Order/ Work Order Module

Standard Sales Report
SALELOG	narrow carriage and displayed sales report	sales.dbf
SALELOGW	wide carriage sales report	sales.dbf
SOPER	ISO 9000 Customer on time delivery report	sales.dbf
Standard Sales/Shipper Form
SALE	shaded sales order form	sales.dbf
SALEB	boxed sales order form	sales.dbf
SHIPPER	shaded shipper form	sales.dbf
SHIPPERB	shaded boxes shipper form	sales.dbf
Custom Work Order/Sales/Shipper Form (Version 7.72 & Lower)
CSO	custom work order and sales order form	sales.dbf
CSHIPPER	custom shipper form	sales.dbf
Custom Work Order/Sales/Shipper Form (Version 7.73 & Higher)
CSO*	custom work order and sales order form	sales.dbf
CSHIPPER*	custom shipper form	sales.dbf
Custom Sales Order Reports
CUSSO*	Custom Sales Reports	sales.dbf
CUSTSO*	Custom Sales Reports	sales.dbf
Custom Work Order Reports
CUSWO*	custom work order reports	sales.dbf
CUSTWO*	custom work order reports	sales.dbf

Note: Sales Order reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf.

15.4.2.6 Receive Module

Standard Receive Report
RECLOG	narrow carriage receiver report	receive.dbf
RECLOGW	wide carriage receiver report	receive.dbf
Standard Receive Form
REC	shaded receiver form	receive.dbf
RECB	boxed receiver form	receive.dbf
Custom Receive Report
CUSTREC*	custom receiver report	receive.dbf
Custom Receive Form (Version 7.72 & Lower)
CREC	custom receiver form	receive.dbf
Custom Receive Form (Version 7.73 & Higher)
CREC*	custom receiver forms	receive.dbf

Note: Receiver reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf.

15.4.2.7 Purchase Module (& Min/Max)

Standard Purchase Report
LGMINREQ	standard min max report	partmast.dbf
LGPARREQ	standard display/print MRP report (Single Bucket)	partmast.dbf
PURLOG	narrow carriage purchase report	purchase.dbf
PURLOGW	wide carriage purchase report	purchase.dbf
VENPER	ISO 9000 vendor performance report	purchase.dbf
Standard Purchase Form
PO	shaded PO form	purchase.dbf
POB	boxed PO form	purchase.dbf
PO_SHIP	shaded PO form with shipping address	purchase.dbf
POB_SHIP	boxed PO form with shipping address	purchase.dbf
Custom Purchase Report
CUSTPO*	custom purchase order report	purchase.dbf
CUSTMRP	custom min max report	partmast.dbf
Custom Purchase Form (Version 7.72 & Lower)
CPO	custom PO forms	purchase.dbf
Custom Purchase Form (Version 7.73 & Higher)
CPO*	custom PO forms	purchase.dbf

Note: Purchase Order reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf.

15.4.2.8 Sales Quote Module

Standard Sales Quote Report
QUOLOG	standard quote report	quote.dbf
Custom Quote Report
CUSTQUO*	custom quote report	quote.dbf
Standard Sale Quote Form
QUOTE	standard shaded sales quote form	quote.dbf
QUOTEB	standard boxed sales quote form	quote.dbf
Custom Quote Form
CQUO*	custom sales quote form	quote.dbf

Note: Sales Quote reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf.

15.4.2.9 MRP, Infinite Bucket Reports

Standard MRP, Min Max, Infinite Bucket Reports
MRP2	standard non-consolidated inf bucket MRP report	action.dbf, mrppart, mrpso
MRP2BUY	standard infinite bucket buy report	Action.dbf partmast.dbf
MRP2CBPP	standard infinite bucket pre-shortage report	action.dbf, mrppart, purchase
MRP2CONS	standard consolidated inf bucket MRP report	mrp2cons.dbf
MRP2EXCS	standard infinite bucket excess inventory rpt	exectmp.dbf (tmp)
MRPSHRT2	standard infinite bucket issued shortage rpt	action.dbf, mrppart, mrpso, routing, mrpstock,
PUSHPULL	standard infinite bucket push pull report	avail.dbf, mrppart, mrpso
WPARREQ	standard wide carriage MRP report	partmast.dbf
Custom MRP Report
CMRP	custom MRP report (version 7.71 and lower) infinite bucket	action.dbf
CUSMRP*	custom MRP report found in infinite bucket	action.dbf
CUSTCMRP	custom MRP report found in purchasing module	partmast.dbf
CUSTMRP*	custom MRP report found in infinite bucket	action.dbf

Note: Most Infinite Bucket MRP “All” reports use the action.dbf, mrppart.dbf, and mrpso.dbf.

15.4.2.10 Sales Analysis Module

Standard Sales Analysis Report
MAKECONM	standard consolidated multiple BOM report	makecons.dbf
MAKECONS	standard consolidated single BOM report	makecons.dbf
SANAL	std sales analysis report	sanal.dbf
SANAL2	std sales analysis report sorted by division	sanal.dbf
SANALCS	std cost of sales report	costsale.dbf
Custom Sales Analysis Report
CUSSANA	custom sales analysis report	sanal.dbf

15.4.2.11 Address Book Module

Standard Address Book Report
ADDRESS	standard address book report	addrbook.dbf
ADDRESSW	standard wide carriage address book report	addrbook.dbf
Custom Address Book Report
CUSADR*	custom address book report	addrbook.dbf

15.4.2.12 Stockroom Module

Standard Stockroom Reports
AVABOM	standard parts available report	bomtemp.dbf
AVABUY	standard buy report	bomtemp.dbf
BOMBUILD	standard max no of BOMs that can be built	bomlist-cursor
CNVSBOM	standard stockroom I transaction report	stocktra.dbf
ISUSHORT	standard stockroom P and shippable report	stocktra.dbf
MAKEUPWO	standard stockroom P transaction by W/O	stocktra.dbf
SKTRCMFG	standard receive from manufacturing report	stockrtra.dbf
STKISSSHRT_PO	Standard stock issued report with POs	Stockrtra.dbf, purchcursor
STOCKLOG	standard stock room transaction report	stocktra.dbf
SWOLOG	std stock room report subtotaled by sales/work#	stocktra.dbf
UNISSUE	standard stock room U transaction report	stocktra.dbf
Custom Stockroom Reports
CUSBMB	custom max no of BOMs that can be built	bomlist-cursor
CUSBOM*	custom parts available report	bomtemp.dbf
CUSMUS*	custom stockroom P transaction report	stocktra.dbf
CUSSTK*	custom stock room report	stocktra.dbf
CUSTSTK*	custom stock room report	stocktra.dbf
Use CUSBOM*	custom stockroom I transaction report	stocktra.dbf

15.4.2.13 Purchase Request/Quote Module

Standard Purchase Request Forms
REQUESTB	standard boxed PO request form	request.dbf
REQUEST	standard shaded PO request form	request.dbf
Custom Purchase Request Form
CREQ*	custom PO request form	request.dbf
Standard Purchase Quote Forms
POQUOB	standard boxed quote form	request.dbf
POQUO	standard shaded PO quote form	request.dbf
Custom Purchase Quote Form
CPOQUO*	custom PO quote form	request.dbf

Note: Purchase Request/Quote reports automatically have a set relation into the Partmast.dbf and Addrbook.dbf.

15.4.2.14 Serial/Lot Number Module

Standard Serial/Lot Number Form
AUDITSN	standard Serial/Lot Audit report form	auditsn.dbf
SNLOG	standard master serial/lot number report	snlot.dbf
SNDLOG	standard master serial/lot number report	snlotdet.dbf
Custom Serial/Lot Number Form
CAUDITSN	custom Serial/Lot Audit report form	auditsn.dbf
CUSTSN	standard master serial/lot number report	snlot.dbf
CUSTSN	standard master serial/lot number report	snlotdet.dbf

15.4.2.15 Routing Module

Standard Routing Form
ROUTE	standard Routing Module report	routing.dbf
ROUTEW	wide carriage Routing Module report	routing.dbf
Custom Routing Forms
CUSTRTR*	custom Routing Module report form	routing.dbf
CUSRTR*	custom Routing Module report form	routing.dbf

15.4.2.16 Employee Time Tracking Module

Standard Employee Tracking Forms
EMPFRM	employee profile form	employee.dbf
EMPLOG	all employee form	employee.dbf
EMPTIMECOST	all Labor cost forms	emptimesh.dbf
EMPTIMESH	all time sheets forms	emptimesh.dbf
Custom Employee Time Tracking Forms
CUSEMP*	custom employee report form	employee.dbf
CUSTIM*	custom time sheet form	emptimesh.dbf

15.4.2.17 Inspection Module

Standard Inspection Forms
INSPIL	standard inspection list report	inspect.dbf
INSPALL	standard all inspection report	inspect.dbf
INSPECT	Standard inspection form	inspect.dbf
Custom Inspection Forms
CUSINS*	custom inspection report	inspect.dbf
CINSPECT*	Custom inspection form	inspect.dbf

15.4.2.18 ECN Module

Standard ECN Form
ECN	standard inspection list form	ecn.dbf
Custom ECN Form
CECN	custom inspection form	ecn.dbf

15.4.2.19 QuickBooks Module

Standard QuickBooks Export Form
QBEXPORT	standard Invoice/Receiving Export report form
Custom QuickBooks Export Form
CUSQBEX	custom Invoice/Receiving Export report form

15.4.2.20 Labels

LABEL(.LBX)    LABEL DESCRIPTION                                                              DBF FILE USED

Inventory Labels  (also see section 5.8.1)
PARLABBAR	Standard parts labels w/barcode for one part	TmpTable.dbf
PARLABEL	std parts labels for all,prod,div,pn dot matrix pr	partmast.dbf
PARLAB2X	std parts labels for all,prod,div,pn laser pr	partmast.dbf
SHIPPER	standard shipper label, see 10.9.1
Custom Inventory Labels
CPARLAB	custom parts labels for all parts, prod,pn	partmast.dbf
CUSPAR*	custom parts labels for all parts, prod, pn	partmast.dbf
CUSTPAR*	custom parts labels for all parts, prod, pn	partmast.dbf
Assembly Labels
BOMLB	standard parts labels for an assy dot matrix	bomtemp.dbf
BOMLB2X	standard parts labels for an assy laser pr	bomtemp.dbf
Custom BOM Labels
CUSBOMLB	custom parts labels for an assy	bomtemp.dbf
CUSBOM*	custom parts labels for an assy	bomtemp.dbf
CUSTBOM*	custom parts labels for an assy	bomtemp.dbf
Receiver Labels
RECLABEL	Inventory parts labels for a receiver (dot matrix)	receive.dbf
RECLAB2X	Inventory parts labels for a receiver (laser)	receive.dbf
RECLABBOX	Receiver parts labels for a receiver RoHs Checkbox	Labprnt.dbf
RECLABQTY	Receiver parts labels for a receiver showing qty	Labprnt.dbf
RECLAB2X	Receiver parts labels	Labprnt.dbf
Custom Receiver Labels
CRECLAB	custom label for inventory and receiver module	receive.dbf
CUSREC*	custom label for inventory and receiver module	receive.dbf
CUSTREC*	custom label for inventory and receiver module	receive.dbf
Address Book Labels
ADDRLBS	pin fed standard address label 15/16x3-1/2	addrbook.dbf
ADDRLBM	laser standard address label 4"x2-7/8"	addrbook.dbf
DDRLBMS2	pin fed standard address label 4"x2-7/8"	addrbook.dbf
Custom Address Book Labels
CUSADRXX	custom address labels (version 6.80 and higher)	addrbook.dbf
CUSTADRX	custom address labels (version 6.80 and higher)	addrbook.dbf
Sales/Work Order Serial Number Labels
LBLWO-SN	Tmptable=copy of partmast w/ModelNo=Serial#) and:	sales.dbf partmast.dbf
Custom Sales/Work Order Serial Number Labels
CUSSNL*	See above for files.
CUSTSNL*	See above for files.
Stock Issue Labels
STKLAB	custom stockroom labels	stocktra.dbf
Custom Stock Issue Labels
CSTKLAB	custom stockroom labels	stocktra.dbf
CUSSTK*	custom stockroom labels	stocktra.dbf
CUSTSTK*	custom stockroom labels	stocktra.dbf

NOTE: Shipper labels and custom shipper labels are described in section 10.9.1

15.4.3 Adding Bar Code Fonts to Custom Labels, Forms, and Reports

Barcodes can be added to pc/MRP labels, forms, and reports by installing pc/MRP's  optional True Type bar code font into Windows Font file (Select Main, Control Panel, Fonts, Add, and enter the location of the barcode font A: for example). To modify a report or label use pc/MRP's report generator, select the related data base file, select the report, select the variable, select object such as part number, from the menu select Format, Font, and select the bar code font. The bar code font should be 26 points or higher and should not be printed out in bold. The 3 of 9 font requires that the variable be entered as:
"*" + UPPER(ALLTRIM(PARTNO)) + "*"

or

BAR39STR(PARTNO)

The above example is for the variable PARTNO.

Note: Acceptable alpha-numbers values for the Bar Code reader are:

ABCDEFGHIJKLMNOPQRSTUVWXYZ.1234567890$%-+ and ‘space’

Note: Bar code fonts may be listed as:

BC C39 3/1 HD Medium,

BC C39 3/1 HD Narrow,

BC C39 3/1 HD Wide,

BC C39 3/1 Medium,

BC C39 3/1 Narrow,

BC C39 3/1 Wide,

BC UPC HD Wide,

To create a custom part label with a bar coded part number you would.

1. Go to the configuration menu, select next window, select report writer

2. Select Label

3. Select PARLABTMP.DBF as your dbf file, click on Use

4. Select PARLABEL.LBX as your label, click on open

5. Save the PARLABEL.LBX as CPARLAB.LBX

6. Click on the part number object, from the menu select Format, Font, select BC 39 3/1 HD medium, regular, 26 points

7. Click on the part number object and change it from partno to read
"*" + UPPER(ALLTRIM(PARTNO)) + "*"

or

BAR39STR(PARTNO)

To print your custom part number labels

Go to the Inventory Module, select labels, select all part numbers, select custom

15.4.4 Clearing the save environment feature on FoxPro for Windows reports

FoxPro for Windows reports save the name of the dbf files that were open when the report was created or last run. This feature can inhibit customizing the report if several dbf files were open when the report was last run or created. If several data base files were open at the time, the report may pick the wrong dbf file to open when you try to view your modifications. To turn off the "save environment" feature, open up the report using the modify report command in FoxPro’s command window and follow the steps listed below:

1. Click on report

2. Click on page layout

3. Click on data environment

4. Click on clear

5. Click on ok

6. Click on file

7. Click on save

Reopen the report and repeat the above process, if you were successful you will see the environments clear and restore buttons are now disabled. Go ahead and click on cancel. Now you will have to enter the related dbf file manually prior to modifying the report, however it will be the correct dbf file.

15.4.5 Opening an additional related database file when printing/displaying a report

The following modifications should only be made by a person who is familiar with dbase and FoxPro commands.

This section explains how to open up another related database file when running a report for the purpose of printing out data from the original database file and the related database file. For example, a user may wish to have a custom sales order report print/display the drawing number for each sales order listed in the report. The drawing number is not in the sales.dbf, so the user must modify pc/MRP such that the partmast.dbf file is open and related to the sales.dbf file whenever that report is run. To make the modifications follow the steps listed below:

With pc/MRP versions 7.50A and higher, Sales Orders, Sales Quotes, Invoice, Purchase, Purchase Quote, and Receiver reports, pc/MRP automatically sets a relation to the PARTMAST and ADDRBOOK database files. As such, you would simply add a field to the custom report with the name of the table (database file) as a prefix e.g. ‘partmast.drawingno’ or ‘addrbook.resale’.

With pc/MRP version 8.13D and higher, Sales Orders, Sales Quotes, Invoice, Purchase, Purchase Quote, and Receiver forms, pc/MRP automatically sets a relation into the PARTMAST and ADDRBOOK database files.

For all other reports or DBF files, you must use Window's Notepad program to create an ASCII text file with the same name as the report you plan on running with the extension of ".ef". For example if you had a custom sales report named "CUSTSO1.FRX" and wanted to include data from another data base besides sales.dbf you would use Notepad to create a new file in the pcmrpw directory named "CUSTSO1.EF"

Enter the following dbase/FoxPro commands into the "CUSTSO1.EF" file. The first command, ~IN~, tells pc/MRP to follow this set of commands before starting to print the report. The second command, THISAREA=SELECT(), stores the name of the first database file in a memory variable named THISAREA. The third through fifth command then set relation between the two files. The last command, GO TOP, makes sure the original dbf file (in this case, sales.dbf) is initialized and ready to begin printing. The seventh command, ~OUT~, begins the instruction set pc/MRP will follow after it has finished printing the report. The remaining commands after the ~OUT~ command, simply close the related dbf file and select the original dbf file as the primary dbf file.

~IN~

THISAREA=SELECT()

SELECT 0

USE PARTMAST INDEX BYPARTNO (for Version 8.00 and later, change the word INDEX to ORDER)

SELECT (THISAREA)

SET RELATION TO LEFT(PARTNO,MPNSIZE) INTO PARTMAST

GO TOP

~OUT~

THISAREA=SELECT()

SELECT PARTMAST

USE

SELECT (THISAREA)

The above commands work for any DBF file ( not just the partmast).

 If you need to set a relation to the address book (“addrbook”) or partmaster file (“partmast”), or (“both”), the following example code will work as well:

~IN~

RELATE("partmast")

~OUT~

USE IN SELECT("partmast")

Save the file as the report/form/label name appended with a “.ef” (no quotes), e.g. “CUSTSO1.EF”, in the pcmrpw directory.

Finally, one would modify the custom report (in this case, CUSTSO1.FRX), adding the fields from the related dbf file to the report (in this case, PARTMAST.DRAWINGNO). Please note, that you must preface the fields from the related dbf file with the name of the related dbf file followed by a period and the name of the field.

When viewing any report you can view the open tables by pressing CTRL-F10. This will open a TXT file with all of the open tables in the "select area" statement. By example: "Select area: 1, Table in Use: C:\MY DOCUMENTS\PCMRPTEST\PCMRPW750\PARTMAST.DBF Alias: PARTMAST" This means the Partmast.dbf is open when running this report.

15.4.6 Setting an additional filter when printing/displaying a report

The following modifications should only be made by a person who is familiar with dbase and FoxPro commands.

This section explains how to get a custom report to prompt for an additional filter condition. For example, a user may wish to have a custom bill of materials report that lists only part numbers that start with the prefix "33-". To make the modifications follow the steps listed below:

pc/MRP versions 7.00C and higher

· Versions 7.00C and higher ship with a file named apndfil.fxp compiled into pcmrpw.exe and do not require it to be downloaded from Software Arts.

Use Window's Notepad program to create an ASCII text file with the same name as the report you plan on running with the extension of ".ef". For example if you had a custom BOM report named "CUSBOMVE.FRX" and wanted to include only part numbers that started with "33-", you would either open or create a file in the pcmrpw directory named "CUSBOMVE.EF" with Window's Notepad program and include the following lines:

 ~IN~

DO APNDFIL WITH "PARTNO", "Enter part of the part number"

· The first line, ~IN~, tells pc/MRP to follow this set of commands before starting to print the report.

· The second line, DO APNDFIL WITH "PARTNO", "Enter part of the part number", tells pc/MRP to set up a filter on the field PARTNO and ask the user to "Enter part of the part number". Please note that the field name, such as PARTNO should be upper case and surrounded with quotation marks.

With pc/MRP versions 7.54D and higher, users can use numeric and or logical fields not just text fields.  When users run the report, users will be prompted for the default value (1) and the operator (>).

If the filter is a text field:

1. contains

2. does not contain

3. start with

4. is equal to

5. is not equal to

If the filter is a numeric or date field:

1. not equal to

2. less than

3. less than or equal to

4. equal to

5. greater than or equal to

6. greater than

To set the defaults with version 7.54 users can add a default value and operator.  For example, in the above example, users could enter

      DO APNDFIL WITH “DESCRIPT”, “Enter a Description”, “BEARING”, 1

When the report is printed pc/MRP will pop up a window asking the user to enter a description with a default entered of BEARING.

15.4.7 Email and HTML Files

Email and HTML forms can only be modified by personnel at Software Arts. Software Arts can send you a custom fxp file containing your modifications .

Modules Std Fxp File Custom fxp

Sales/Sales Quote/Work Order       EMSO.FXP                              CEMSO.FXP

Purchases                                       EMPO.FXP                              CEMPO.FXP

Receivers                                       EMREC.FXP                            CEMREC.FXP

Purchase request                            EMREQ.FXP                           CEMREQ.FXP

Invoices                                         EMINV.FXP                            CEMINV.FXP

The custom fxp files would be copied into the main pcmrpw directory.

15.4.8 Converting custom 16-bit report forms to 32-bit report forms

Installing an update to a 32-bit version of pc/MRP will copy in all new 32-bit standard report forms. Starting pc/MRP for the first time after installing the update will convert all non 32-bit reports, Custom and Standard, to 32-bit.

To individually convert a 16-bit report to 32-bit, open the command line and enter:

CONVERTFORM("filename.frx")

If you use just enter:

CONVERTFORM()

it will allow you to scroll and select the report to be repaired.

15.4.9     Adding a picture or logo to a report, form, or label for each Partnumber on a report.

1. Select Configuration/Settings & Utilities

2. Enter your Configuration Code Number.

3. Run Utility 24.

4. Choose either Form if you are adding a picture or logo to a form or report or choose Label if you are adding it to a label.

5. Select the '.frx' or '.lbx' file to modify. In this case, parlab2x.lbx.

6. Check the pc/MRP manual, section 15.4.2 for the proper prefix of a custom report. In this case, ‘cusparlab2x’ for example.

7. Choose ‘File/Save As’ and enter and save your new custom report name.

8. Click on the OLE(Picture/ActiveX Bound Control). Move your cursor to the position you wish to add the picture and draw a box that will contain your picture. A window for Report Picture appears.

9. If you are adding a logo or picture that appears in the page header portion of the report or form, select File and click the ellipse button to locate the logo or picture BMP, JPG, or GIF file (skip to #13). If you are adding pictures to the detail line where you might want a different picture for each part, select File and type in the words ‘partmast.Image_File’. This is the field name for the location of the image file for the part in the Part Master database.

10. In the section “If picture and frame are different sizes”, choose Scale “Picture, Retain Shape.”

11. Press the Print When Button; a ‘Print When’ form appears.

12. In the Print only when expression is true box, Enter “Not Empty(FileChk(alltrim(Partmast.Image_File)))” (without quote marks)

13. Press ‘OK’ twice

14. Choose File/Close to exit the Designer.

The new report/form/label is available in the drop-down area when you choose “Custom” for the report/form/label you are running.

15.4.10.1 Address information layout used for forms (pc/MRP version 8.03 and below).

Addresses in the Purchase, Receive, Sales, and Invoice forms (not reports) are stored in a long single memory variable. For example, “MVENDOR1” in the PO form has the following layout:

SUBSTR(MVENDOR1,1,30) = VENDOR NAME

SUBSTR(MVENDOR1,31,30) = CONTACT NAME

SUBSTR(MVENDOR1,61,30) = VENDOR ADDRESS

SUBSTR(MVENDOR1,91,15) = VENDOR CITY

SUBSTR(MVENDOR1,106,2) = STATE

SUBSTR(MVENDOR1,108,10) = ZIP

SUBSTR(MVENDOR1,118,30) = COUNTRY

Therefore, the ZIP code is located 108 characters into the variable for a length of 10.

15.4.10.2 Address information layout used for forms (pc/MRP version 8.04 and higher).

Addresses in the Purchase, Receive, Sales, and Invoice forms (not reports) are stored in a long single memory variable. For example, “MVENDOR1” in the PO form has the following layout:

SUBSTR(MVENDOR1,1,41) = VENDOR NAME

SUBSTR(MVENDOR1,42,41) = CONTACT NAME

SUBSTR(MVENDOR1,83,41) = STREET ADDRESS 1

SUBSTR(MVENDOR1,124,41) = STREET ADDRESS 2

SUBSTR(MVENDOR1,165,30) = VENDOR CITY

SUBSTR(MVENDOR1,195,20) = VENDOR STATE

SUBSTR(MVENDOR1,215,10) = ZIP

SUBSTR(MVENDOR1,225,30) = COUNTRY

Therefore, the ZIP code is located 215 characters into the variable for a length of 10.

15.4.11 Adding the RoHS information to a report, form, or label.

The RoHS field is a logical field in the inventory database on the Misc. tab. To use in a report, form, or label, the field must be added to the report detail band and the header description band. The detail band field is defined as follows:

IIF (ROHS, “YES”, “NO”)

Or for a one character field, use “Y”,”N”.