Custom Report and Label Making

You are looking at an old Manual of pc/MRP,
the Complete MRP Inventory/Accounting Package.

Please click below for
the latest pc/MRP Manual

Please click below to
reach the pc/MRP Main Page

Manual Logo

Main Page Logo

 

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.

 

NOTE: 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/customsettingsandutilities.htm


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

Configuration, Settings and Utilities.
Enter your configuration code number.
Select option 24.
Select Form or Label.
Select the correct file you wish to modify or use as a basis for custom report or label
Click on Open
Select file, save the file as a custom .frx report (see list below for correct file names)
Make your modifications
Select file, close, save changes
Return to pc/MRP's Main Menu
Print out the new report selecting custom instead of standard

CUSTOM REPORT


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.

CUSTOM REPORT


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:

CUSTOM REPORT


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.

o        Go to the Main Menu

o        Click on the Configuration option

o        Click on Settings and Utilities

o        Click on the Next button

o        Place your cursor over the spinner button

o        Click the "up" arrow until you get "24"

o        Click OK

o        Enter your code number and click OK

o        Click on the Form button

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

Your screen should look like this:

Customizing Reports

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.

o        Click on File

o        Click on Save As

o        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.)

o        Click the Save button

o        Place your cursor over the title "Partmaster Report"

o        Hit the "delete" button on your keyboard

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

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

o        Type in "Partmaster Inquiry" and click somewhere on the screen

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

o        Now go to the menu bar and click on Object

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

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

o        Click on Object again

o        Click Pen Color

o        Chose the color red

Your screen should look similar to this:

Changed Report

 

 

Your screen should look similar to this:

 

2nd Changed Report


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. 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
    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    
    DISSPART
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 
    CMRP2
custom MRP found in infinite bucket prior to version 7.72
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 all parts
Partmast.dbf
    PARLABEL 
standard parts labels for all parts dot matrix
partmast.dbf
    PARLAB2X 
standard parts labels for all parts 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
 
  BOM 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 
standard parts label for a receiver
receive.dbf
   RECLABBOX
Std parts label for a receiver showing boxes
workfile
   RECLABQTY
Std parts label for a receiver showing qty
workfile
   RECLAB2X
standard parts labels for a receiver
receive.dbf
 
  Custom Receiver Labels
    CRECLAB  
custom parts labels for an assembly
receive.dbf
    CUSREC*  
custom parts labels for an assembly
receive.dbf          
    CUSTREC*
custom parts labels for an assembly
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,

The above example is for the variable PARTNO.

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

Go to the configuration menu, select next window, select report writer
Select Label
Select PARLABTMP.DBF as your dbf file, click on Use
Select PARLABEL.LBX as your label, click on open
Save the PARLABEL.LBX as CPARLAB.LBX
Click on the part number object,
from the menu select Format, Font, select BC 39 3/1 HD medium, regular, 26 points
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:

Click on report
Click on page layout
Click on data environment
Click on clear
Click on ok
Click on file
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 pcMRP 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 below 7.00C

·         Versions below 7.00C require a file named apndfil.fxp be downloaded from Software Arts and placed in pc/MRP's directory, pcmrpw.

·         Use Window's Notepad program to create an ASCII text file named "RPTREL.EF" for a report or "FRMREL.EF" for a form. 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 "RPTREL.EF" with Window's Notepad program.

·         Enter the following dbase/FoxPro commands into the "RPTREL.EF" file.

·         The first line [CUSBOMVE.FRX], tells pc/MRP what report this set of commands are for.

·         The next line, ~IN~, tells pc/MRP to follow this set of commands before starting to print the report. The second command, 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". The field name, such as PARTNO should be upper case and surrounded with quotation marks.

·         Please note that, REPREL.EF may contain sections of similar code for other custom reports.

[CUSBOMVE.FRX]
~IN~
DO APNDFIL WITH "PARTNO", "Enter part of the part number"

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

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”.