Initializing Data

This chapter contains the following topics:

Introduction to Initializing Data

System Files

Accounts Payable

Accounts Receivable

Check Reconciliation

General Ledger

Inventory Control

Job Cost

Order Entry

Purchase Order

Payroll

Point of Sale

Sales Analysis

Time and Billing

Customer Orders

Inventory Management

Product Purchasing

Module and Multiple Company Initialization

 

Introduction to Initializing Data

This section enables you to initialize one or more data files and tables for a particular package.

Initialize means to create a new data file. When you initialize a data file that already exists, any information in it is completely erased and the file is recreated.

This function is included in case you need to initialize your data.

If you suspect you have a corrupted data file, do not initialize it or attempt other recovery actions without first checking with your PBS supplier. Also, see the Administrative instructions related to the Data (File) Recovery Utilities chapter. When ever possible, it is often better to restore a backup rather than initializing your data.

* CAUTION *

       Note 

Do not use this function unless you really want to initialize your data.

Initialized data means the information is completely erased.

If you have to initialize your data, you may want to make a backup of the data or even the entire PBS directory and database before doing so.

Certain data sets work together in tandem, such as headers and lines. If you initialize one you may need to initialize the others in the group. You should understand how data is grouped before you start this function. This relationship is not explained in this document.

* CAUTION *

System Files

If you use the multi-company feature, be aware that initialization in the System Manager can do one thing that the other packages cannot; it can initialize data that encompass all companies. Almost all PBS data is specific to a particular company, but there are a few that are exceptions. Initializing one of these affects all companies. You will be warned when you attempt to do this.

You must be an administrative user of Passport Business Solutions in order the run these utilities. Refer to the PBS Users chapter for more information.

To Initialize System data execute this PBS initialization function:

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> SY Initialization

For UNIX/Linux

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level directory.

Then type the following:

syinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter a PBS Administrative User ID.

The following screen displays:

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

#

File name as shown on screen

Internal name (pathfinder)

Description

1.

Company file

COMPFI

Contains the Company information data.

2.

Cost center file

PFCTFI

Contains the list of cost centers or profit centers.

3.

Valid G/L acct file

ACCTFI

Contains the valid General Ledger accounts.

4.

Cash accounts file

CSHACT

Contains the cash accounts.

5.

Batch control file

BTCHFL

Contains a list of the batches currently defined.

6.

Laser print param file

LASPRM

Contains parameters associated with laser printers.

7.

Report number file

REPTNO

This file is a quick index to reports printed to disk. The report number is used as the relative key of the record.

If you select Y to initialize this file, you will be prompted to Enter disk report number. Enter the starting number for reports printed to disk.

8.

Account links file

EGLFIL

Equates your current account structure to any of three other structures. This file is also referred to as the <External Cross-Reference file> and the <External General Ledger file>.

It is not to be confused with the <Cross-reference file>, which is used in reformatting account numbers and does not appear on this screen.

9.

Access file

ACCESS

When using the Menu-bar menu type the Access groups function may be used to move around the system rapidly.

10.

Utility file

UTILFL

Under the Utility menu selection you may enter access to other applications.

11.

Label formats file

LBLFMT

This is the label format file.

12.

Label dictionary file

ICDICT

The label dictionary file.

13.

Label lock file

LBLLCK

This is the label lock file.

14,

Bank file

BNKACT

Bank accounts file.

15.

Reason code file

RSNFIL

Reason codes file.

16.

Payment file

PMTFIL

The payments file contains open payments associated with O/E orders, A/R invoices and cash receipts.

17.

Payment history file

PMTHIS

The payment history file contains posted payments.

18.

Payment codes file

PMTCOD

Payment codes file.

19.

Navigator distribution file

NADIST

This file contains the history of all posted distributions in the system. See note below on restoring the NADIST file.

20.

Multi-company file

MLTCMP

This file spans all companies. Initializing it will affect not just your company but every company in the system.

Contains a list of companies.

21.

Spooled print file

SPOOLF

This file spans all companies. Initializing it will affect not just your company but every company in the system.

There is one record for each spooled file.

22.

Report stack file

STKFIL

This file spans all companies. Initializing this file will affect not just your company, but every company in the system.

23.

Printer codes file

CODFIL

This is the printer codes file. If you initialize it when running multiple companies, it could effect printer settings for all companies.

24.

Email log file

PDFLOG

This is a log of each PDF form when it has been emailed or recreated via a reprint.

25.

PDF master file

PDFMST

This file contains a list of the PDF files that have been generated while printing PDF forms.

26.

Help Graphical PBS

HELPGUI

This file has the links to the help for the graphical screens.

27.

User Help File

USRHLPGUI

This file contains user definable links to help.

Field number to change?

Make any desired changes, then press <Enter> to initialize the files selected. Once processing is complete, the program returns to the operating system.

       Note 

NADIST (Navigator Distribution File) Recovery after File Initialization

When posting and writing to the NADSIST file a backup file is always being written as well. Therefore if the original NADIST file becomes corrupt you may initialize it and use the data recovery utilities to restore the back up file. You will find the back up in the RWxx directory of the company where you want to do a recovery. The name of this file is BKUNADxx.DAT. Copy the file to the top level PBS and change the name to NADISTxx.EXP and use the file recovering utilities to restore it. If you have run some distributions since the file was initialized, then be sure to select "Add records to existing data file".

Other File Initializations

Cross-reference file

The <Cross-reference file> is used in reformatting account numbers and does not appear on the System initialization screen. In order to create new Cross-reference settings you can just re-enter the data. If you prefer, you can delete the Cross-reference file from the top-level PBS directory and PBS will re-create an initialized file when you access Reformat account number from the CTL menu. The file name is XREFFILxx.DAT and XREFILxx.vix with xx representing the company number. You must delete both the ‘.DAT’ and ‘.vix’.

BreakOut Files

BreakOut files are stored in the PSIB00 directory. BreakOut settings are stored per user in a file named BxxxFL.DAT and BxxxFL.vix with the xxx representing the PBS User ID. Unexpected BreakOut settings may occur and it is not always easy to find and fix the setting. If that occurs, you can delete the BreakOut file that contains all the BreakOut settings for the user. The BreakOut file gets automatically re-created when the user accesses the BreakOut utility from a PBS field via the <F12> key or clicking on the BreakOut button on the Tool bar. You must delete both the ‘.DAT’ and ‘.vix’ parts of the file.

Never delete the FUNCFL.DAT file from the PSIB00 directory.

If you prefer not to lose all the user’s BreakOut settings, you may export the BreakOut file, delete unneeded entries in the file and then restore it. To do this use the System Utilities - type SYUTIL from a command prompt.

Accounts Payable

To Initialize Accounts Payable data files, execute the Passport Business Solutions initialization function.

You must be an administrative user of Passport Business Solutions in order the run the data recovery utilities. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> AP Initialization

For UNIX

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level directory.

Then type the following:

apinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen displays.

When this screen is first displayed, all its fields are blank. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including “Field number to change ?”), you may use one of the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked “Yes”, without waiting to reach “Field number to change ?”. You will be asked to confirm that you want to do this.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files/Tables

The following table lists all the entries on the screen and provides a description of each file/table. The internal name of the file is given; this is useful when relating the file name to several features described in the this manual (pathfinder; data recovery utilities).

#

File name as shown on screen

Internal name (pathfinder)

Description

1.

A/P notes file

APNOTF

Notes you have entered in the various A/P selections, such as vendors, which allow notes

2.

A/P accounts file

APACCT

Contains all the G/L accounts which you have designated as A/P accounts

3.

A/P control file

APCTLF

Parameters that define the basic structure of your A/P module

4.

Vendor master file

VENFIL

Contains relevant vender information such as name, address, discount terms and year-to-date statistics.

5.

Change vendor file

CNGVEN

This file is used to log any changes or deletions which are made to the vendor file. It may be selectively purged after the Change Log is printed.

6.

Purchasing address file

PURADR

Contains one record for each ship-to address to which goods are delivered or at which services are performed.

7.

A/P transaction file

APTRXF

This is a transaction file for payables transactions. The file is purged each time payables is posted. If batches are used, then only the payables in the batch are purged.

8.

A/P transaction distribution file

TRXDIS

Used to track the general ledger distributions for unposted payables entries. The file is purged each time payables is posted. If batches are used, then only the payables in the batch are purged.

9.

A/P transaction lock file

APTLCK

Protects the A/P transaction file.

10.

A/P open item file

APOPEN

Contains all of the open items (transactions that are currently outstanding for each vendor).

11.

Open item adjustment transaction file

ADJTRX

Contains adjustment transactions for open items.

12.

A/P open adjustment lock file

ADJLCK

Protects the A/P open item file.

13.

Void check file

VOICCK

Contains all of the void check transactions that are current for each vendor.

14.

A/P check file

APCHKF

Contains check records. The file is purged when the checks are posted.

15.

A/P check lock file

CHKLCK

Protects the A/P check file.

16.

A/P distributions to G/L file

APDIST

Used to generate the A/P Distribution to G/L Report. If the G/L module is used, this file is the input to the G/L get distributions interface program. This file would normally contain all of the detailed G/L distributions for one month or accounting period.

17.

A/P recurring file

APRCUR

Contains one record for each recurring payable by vendor.

18.

Vendor history file

VENHIS

Contains information on all vendor open items, vouchers, payments, paid vouchers and posted memos.

19.

Report parameter file

NSFLCK

Protects the returned checks file.

20.

Vendor contact file

PCOFIL

Additional contacts for vendors.

21

General selection lock file

GENLCK

A general lock file.

22

Check forms file

APFRMF

Contains user defined check and check stub formats.

23

Memo transaction file

TRXMEM

Contains memo transactions

24

Vendor 1099 miscellaneous file

APFAUX

Contains 1099 miscellaneous information used for year-end reporting

25

Vendor 1099 miscellaneous lock file

1099LK

The 1099 miscellaneous lock file.

26.

Pay-to file

PAYTOF

This contains the pay-to addresses.

Field number to change ?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected.

There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel the operation.

Accounts Receivable

To Initialize Accounts Receivable data files, execute the Passport Business Solutions initialization function.

You must be an administrative user of Passport Business Solutions in order the run the data recovery utilities. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions > Init Utilities-> AR Initialization

For UNIX

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level directory.

Then type the following:

arinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

For space reasons, two screens are needed to contain all the files. You can switch between the two screens as needed. No files are initialized until you have approved both screens.

The following screen appears first:

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including “Field number to change ?”), you may use one of the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

PgUp

To return to the first field on the screen, if not there already.

PgDn

(1) To proceed to the last field on the screen, if not there already. (2) If already at the last field or at “Field number to change ?”, to proceed to the second screen, preserving all existing settings on the first screen.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files/Tables

The following table lists all the entries on the screen and provides a description of each file/table. The internal name is useful when relating the data to several features described in the this documentation like pathfinder and data recovery utilities.

#

File name as shown on screen

Internal name

pathfinder

Description

1.

A/R control

ARCTLF

Control information. Parameters that define the basic structure of your A/R module

2.

A/R notes file

ARNOTF

Notes you have entered in the A/R invoice and customer selections which allow notes

3.

A/R accounts file

ARACCT

Contains all the G/L accounts which you have designated as accounts receivable accounts.

4.

A/R codes file

ARCODS

Contains the tax codes, terms codes, and ship-via codes used in the A/R and other modules

5.

Sales rep file

SLMFIL

Lists all active sales representatives. Used in customers, invoices, miscellaneous charges, and commissions due report printing. There should not be any data if you specified (in A/R Control information) that you do not use sales reps.

6.

Ship-to file

SHPFIL

Contains one record for each ship-to address to which goods are delivered or at which services are performed.

7.

Goods
/Services file

GDSSVC

Contains one record for each item or service entered through Goods/Services

8.

Invoice
stations file

IVCSTA

Contains one record for each invoicing station

9.

A/R
Customer file

CUSFIL

Contains relevant customer information such as name, address, credit status, shipping methods, discount terms, tax status, and year-to-date statistics

10.

Change customer file

CNGCUS

This file is used to log any changes or deletions which are made to the customer file. It may be selectively purged after the Change Log is printed.

11.

Customer history file

CUHFIL

Contains information on all fully-paid open items which have been purged from the A/R open item file.

12.

Cash
history file

KSHHST

Contains payment history.

13.

A/R open item file

AROPEN

Contains all of the open items (transactions that are currently outstanding for each customer).

14.

Open item lock file

AROLCK

Protects the A/R open item file.

15.

Cash receipts file

CSHTRX

This is a transaction file for cash receipts. It is purged when cash receipts are posted.

16.

Cash receipts lock file

CSHLCK

Protects the cash receipts file.

17.

Cash application file

CSHAPL

Contains a record for every invoice to which cash is applied during cash receipts processing.

18.

Returned checks file

NSFTRX

Contains information on checks that have been returned.

19.

Returned checks lock file

NSFLCK

Protects the returned checks file.

20.

Returned checks application file

NSFAPL

Contains a record for every invoice to which cash was applied during the original cash receipts processing.

21.

Returned checks charges file

NSFCHG

Contains a record of bank and customer charges charged because of a bad check.

22.

Misc charges trans file

SLSTRX

This is a transaction file for Miscellaneous charges transactions. The file is purged each time miscellaneous charges are posted.

23.

Misc charges lock file

SLSLCK

Protects the miscellaneous charges transaction file.

24.

Misc charges dist file

SLDTRX

Used to track the general ledger distributions for unposted miscellaneous charges entries.

25.

Report parameter file

ARRPTP

When you are entering the parameters to use in printing various reports, you can choose to save them. If you do, they are contained in this file.

26.

Commissions due file

COMFIL

Contains a record for every sale for which a commission exists. Not present if you do not use sales representatives or do not pay them on commission.

27.

A/R distributions to G/L

ARDIST

Used to generate the A/R Distribution to G/L Report. If the G/L module is used, this file is the input to the G/L interface program. This file would normally contain all of the detailed G/L distributions for one month or accounting period.

28.

Finance charges file

FCHTRX

Contains a record of finance charges assessed against a customer in a given period. This file is purged when finance charges are posted.

29.

Finance chrgs lock file

FCHLCK

Protects the finance charges file.

30.

Invoice format file

IVCFMT

Contains the complete descriptions of your invoice formats.

31.

Invoice format lock file

FMTLCK

Protects the invoice format file.

32.

Invoice header file

PIHDRF

Contains one record for each regular invoice.

Field number to change ?

Make any needed changes.

Press <Enter> from a blank “Field number to change” to proceed to the next screen or select <Esc> to cancel.

Continue to answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. The cursor will move through each field in turn, and you will be able to correct any errors from “Field number to change?”. You may also use the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked “Yes”, without waiting to reach “Field number to change ?”. You will be asked to confirm that you want to do this.

PgUp

(1) To return to the first field on the screen, if not there already. (2) If already at the first field or at “Field number to change ?”, to return to the previous screen. This is not the same as <Esc>, since all your settings on the second screen are preserved.

PgDn

To proceed to the last field on the screen, if not there already.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

#

File name as shown on screen

Internal name

PATHFILE

Description

33.

Invoice line item file

PILINF

Contains one record for each line item for each regular invoice.

34.

Invoice auxiliary file

PIAUXF

Contains any overflow data on invoices: multi-line notes, comments, and miscellaneous ship-to addresses.

35.

Invoice lock file

PIILCK

Protects the Invoice file.

36.

Statement format file

PTBFMT

Contains the complete descriptions of your statement formats.

37.

Statement format lock file

SFMLCK

Protects the statement format file.

38.

Recurring bill header file

RHDRFI

Contains one record for the header for each recurring bill.

39.

Recurring bill line item file

RLINFI

Contains one record for each line item on each recurring bill.

40.

Recurring bill aux file

RAUXFI

Contains additional description for recurring bill line items, plus comments and miscellaneous deliver-to addresses for recurring bills.

41.

Invoice hist header file

IHSHDR

Contains one record for the header for each
historical invoice.

42.

Invoice hist line file

IHSLIN

Contains one record for each line item for each historical invoice.

43.

Invoice
history aux file

IHSAUX

Contains additional description for historical invoice line items, plus comments and miscellaneous deliver-to addresses for historical invoices.

44.

Standard bill file

STDBIL

Contains one record for each standard bill line item, plus a single record for each standard bill header.

45.

Standard bill aux file

STDAUX

Contains the additional description for standard bill line items.

46.

Statement printer ctl file

TPRCTL

Contains additional information about each printer for use in printing invoices and statements.

47.

Invoice printer lock file

PRTLCK

Protects the printer printing invoices.

48.

Taxes open item file

TXOPEN

One record per invoice for unreceived or new sales tax reporting.

49.

Invoice hist serial file

IHSSER

Serial numbers for items in invoice history (O/E only).

50.

Customer contact file

CONFIL

Additional contacts for customers.

51.

Recurring sales file

ARRCUR

Contains recurring sales transactions.

52.

Prepaid cash transaction file

PPCTRX

Contains prepaid cash, “N” type records copied from the open item file, that have been applied to O/E orders or A/R invoices.

53.

Customer CC profile file

CUSPRF

Customer credit card profile file.

Field number to change ?

Make any needed changes. Press <Enter> to initialize all files selected (on either screen). There will be a period of processing as files are initialized, then the operating system prompt will reappear.

Unlike most Passport Business Solutions selections, this selection allows you to initiate processing (using <F2>) without waiting to reach Field number to change ?, but you can only do this from the second screen.

Check Reconciliation

To Initialize Check Reconciliation data files, execute the Passport Business Solutions initialization function

You must be an administrative user of Passport Business Solutions in order the run the data recovery utilities. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> CR Initialization

For UNIX

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level
directory.

Then type the following:

crinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The screen displays as follows:

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

The following table lists all the entries on the screen and provides a description of each file/table. The internal name is useful when relating it to several features described in the this documentation like pathfinder and data recovery utilities.

#

File name as shown on screen

Internal name (pathfinder)

Description

1.

C/R account file

CKACCT

This file contains the checking accounts maintained in Check Reconciliation.

2.

C/R notes file

CKNOTF

This file contains the notes you have entered.

3.

C/R control file

CKCTLF

Contained within this file are parameters that define your check reconciliation structure.

4.

Checkbook file

CKBOOK

This file includes all checkbook items, including checks, deposits, adjustments, and balance forward entries.

5.

Checkbook transactions file

CHKTRX

This is a work file for checkbook transactions. The file is purged each time checks are posted.

6.

Checkbook lock file

CRCLCK

This file locks the checkbook file that contains posted transactions during reconciliation.

7.

Checkbook distributions file

CHKDST

This file is used to track the general ledger distributions for unposted C/R entries.

8.

C/R distributions to G/L file

CRDIST

This file contains one record for each G/L distribution generated by the C/R package for posted C/R entries. It is used to generate the C/R to G/L Distributions Report and (if the PBS General Ledger package is used) this file is the input to the G/L interface program. This file would normally contain all of the detailed G/L distributions for one month or accounting period.

Field number to change ?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

General Ledger

To Initialize General Ledger data files, execute the Passport Business Solutions initialization function.

You must be an PBS administrative user in order to use this utility. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> GL Initialization

For UNIX

Type the following:

cd /usr/psi

or replace “/usr/psi” with the name of your PBS top-level directory.

Then type the following:

glinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen will appear:

 

       Note 

Files 32, 33, and 34 can be initialized only if the company you are working with is a consolidation company. Refer to the Company Consolidation chapter in the System User documentation.

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including Field number to change?), you may use one of the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked Yes, without waiting to reach Field number to change ?. You will be asked to confirm that you want to do this.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as Skipped.

1. G/L control file (GLCTLFXX)
(where xx = Company ID)

This file contains a number of parameters that define your general ledger structure. Each parameter defines specific values to be used in other programs.

2. G/l notes file (GLNOTFXX)

This file contains all the notes you have entered in the various G/L selections which allow notes, except for notes entered through Distributions, which are not saved after posting.

3. Accounting period file (PRDFILXX)

The Accounting Period file defines all of the accounting periods in the fiscal year and designates the current and reporting periods.

4. Cost center (or sub account) group file (GRPFILXX)

This file contains one record for each cost center group defined.

5. G/L codes file (GLCODSXX)

This file contains the G/L codes for budget types.

6. Chart of accounts file (CHARTFXX)

The Chart of Accounts file defines all of the accounts to be used by General Ledger, and contains basic data about each account.

7. Chart of accts chg log (CNGCOAXX)

This file records changes to the Chart of Accounts record, and the record after the change was made. This file will be used only if the change log feature is used per Company information.

8. Budget file (BUDGETXX)

This file contains budgets you have entered through the Budgets selection.

9. Budgets chg log file (CNGBDGXX)

This file records changes to the Budget records. This file will be used only if the change log features are used per Company information.

10. Comparatives file (CMPRTVXX)

This file contains comparatives you have entered through the Comparatives selection.

11. Comparatives chg log file (CNGCMRXX)

This file records changes to the comparative records. This file will be used only if the change log feature is used per Company information.

12. Distributions trans file (GNJTRXXX)

This file contains transactions entered using G/L or interfaced from other modules. This file is cleared when distributions (entries) are posted.

13. Distribution notes file (GJNOTFXX)

This file contains the notes you have entered through the
Distributions selection for entries which have not yet been posted. (When distribution entries are posted, the notes are not saved.)

14. Distributions lock file (GNJLCKXX)

This file is used to protect the Distributions file.

15. Recur journal trans file (GLRCURXX)

This file contains recurring transaction information from which distributions entries are created periodically.

16. Std journal trans file (STJTRXXX)

This file contains standard journal transactions (entries).

17. Std journal lock file (STJLCKXX)

This file is used to protect the Standard Journal Transaction file.

18. Gen ledger trans file (TRXFILXX)

This file contains records from General Journal, distributions, and Standard Journal transactions after they are posted. It is the permanent G/L file.

19. Gen ledger lock file (TRXLCKXX)

This file is used to protect the General Ledger Transaction file.

20. Fin stmnt layout file (LAYOUTXX)

The Financial Statement Layout file contains the instructions that determine the appearance of each financial statement.

21. Fin stmnt specs file (FSSPECXX)

The Financial Statement Specification file contains one record for each statement to be printed.

22. Fin stmnt passing file (FSPASSXX)

This file is used to carry control information for statement printing.

23. Fin stmnt text file (TXTFILXX)

The Finish Statement Text file contains text that is to be printed on financial statements.

24. Fin stmnt BSNI file (GLBSNIXX)

The Financial Statement BSNI file contains the calculated balance sheet net income data.

25. Fin stmnt work file (FSWORKXX)

This is a temporary work file used to produce financial statements.

26. Fin data col layout file (LAYCOLXX)

The Financial Data Column Layout file contains the instructions that determine how the transaction file data is extracted.

27. Fin data extract work file

This is a work file used in automatically generating extract financial data.

28. SAF layout file (SAFLOFXX)

This is a work file used in automatically generating standard financial statement layouts for the source and application of funds reports.

29. Proforma account file (PROCOAXX)

The Proforma Account file contains the data records which will allow you to use a standardized balance sheet and operating statement from any chart of accounts.

30. Gen journal header file (MLTRXHXX)

The General Journal header account file contains General Journal header data for each journal entry number.

31. Gen journal trans file (MLTRXDXX)

The General journal trans file contains multi-line transaction records for General Journal.

32. Gen journal lock file (MLTLCKXX)

This file is used to protect the General Journal Transaction file.

33. Company consol mbr file (MEMSPCXX)

This file defines all member companies of consolidations and contains the cost center designation to be used for each member company.

34. Company consol lock file (CCNLCKXX)

This file is used to protect the Company Consolidation selection from other users in a multiple-user system.

35. Consol account link file (ACTLNKXX)

This file defines the links between the chart of accounts in each member company and in the consolidation company. It also contains a description of each account linked.

Field number to change ?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, then the program closes.

Select <Esc> to cancel.

Inventory Control

Initialize Inventory Control data by executing the Passport Business Solutions initialization function.

Only an authorized PBS administrative user can use this utility. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> IC Initialization

For UNIX

Type the following:

cd /usr/psi

or replace “/usr/psi” with the name of your PBS top-level directory.

Then type the following:

icinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The first screen displays as follows:

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

A brief description of each data file/table is listed below:

1.Alternate Items file (ALTITM)

This file contains alternate items you have defined for use with Inventory, Order Entry, or Accounts Receivable.

2.Change Item file (CNGITM)

This is a log of the changes made to the Item file. It is needed only if the Change Log is used.

3.Component file (CMPFIL)

This file contains information for each kit component on a work order.

4.Component Cost file (CMPCST)

This file contains cost information for each kit component on a work order.

5.I/C Codes file (ICCODS)

This file contains the pricing codes, commission codes, and taxable codes.

6.I/C Control file (ICCTLF)

This file contains a number of parameters and default values. It also includes the control information for the saved formats for certain reports and import selections.

7.I/C Dist to G/L file (ICDIST)

This file is used to generate the I/C Distribution to G/L Report and contains the debit and credit distributions that can be interfaced to G/L, if using.

8.Inventory Account file (INVACT)

This file contains all inventory accounts to which I/C activity may be distributed.

9.Inventory Lock file (INVLCK)

This file is used to protect the Inventory Transaction file.

10.Inventory Transaction file (INVTRX)

This file contains the transactions entered using Inventory (or those that came from O/E, or A/R). The transactions remain in this file until removed during posting.

11.Item file (ITMFIL)

Each item of merchandise that is contained in inventory is identified in the Item file.

12.Item Notes file (ICNOTF)

This file contains one record for each item note you have entered.

13.Keyword file (CKEYWF)

This file contains the keywords for each item, as well as all bar code information.

14.Kit file (KITFIL)

This file contains the definitions for each kit.

15.Kit lock file (KITLCK)

This file is used to protect the Kit file.

16.Label file (ILBFMT)

This file contains one record for each item label format that you set up.

17.Label Lock file (ILBLCK)

This file is used to protect the Label file.

18.Layer file (LAYFIL)

This file contains the LIFO/FIFO detail history records (layers).

19.Physical Count Trx file (ICPHXF)

This file contains the physical count transactions created using Physical count, when using the expanded physical count method. The transactions remain in this file until removed during the adjustment creation process.

20.Price file (PRCFIL)

This file contains all warehouse-specific prices, sale prices, and contract prices for items, as well as alternate selling unit information.

21.Serial file (ICTRKF)

Each serial number associated with an inventory item is contained in this file, along with its related information. Lot numbers and historical detail for lot items are also stored in this file.

22.Serial Transaction file (ICTKXF)

This file contains serial transactions produced by entering inventory transactions for serialized items using Inventory (or those that came from O/E). It also contains transactions entered directly through Serial numbers. The serial transactions remain in this file until removed during the posting of the respective functions.

23.Status file (STAFIL)

This file contains the records of quantities, costs, and prior period data for each item for each warehouse.

24.Status Data Load file (LODSTA)

This file contains the load requests entered using Status load file.

25.Warehouse file (WHSFIL)

This file contains the warehouse codes.

26.Work Order file (WKOFIL)

This file contains information on all work orders entered.

27.Work Order Cost file (WKOCST)

This file contains cost information on all work orders entered.

28.Work Order Lock file (WKOLCK)

This file protects the Work Order file.

29.Inventory History file (ITXHIS)

This file contains historical information on past Inventory transaction.

30.Category file (CATEGF)

Item categories are stored in this file.

31.Sub-category file (SUBCAT)

This file contains item sub-category types.

32.Units file (UNITFI)

Item units are stored in this file.

Field number to change ?

Make any changes or use one of the options:

<PgDn>

For the next screen

<F1>

To set all files to Y.

The second screen of the Initialize I/C feature appears after the completion of field #32, or using <PgDn>, and appears as follows:

Continue to answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

33. Work Order history header (WKOHDR)

This file contains information on all work orders header entered.

34. Work Order history line (WKOLIN)

This file contains all Work Order files in use.

35. Serial keyword (SKEYWF)

This file contains information on alphabetical order of terms used in the I/C manuals.

36. Serial History (SERHIS)

The serial units history information are stored in this file.

37. Warranty codes (ICREFM)

This file contains types of warranty codes.

38. Coverage types (COVFIL)

Types of coverage are stored in this file.

39. Item sequence (ITMNUF)

This file contains information on all item sequence.

40. Status code (STAFIl)

Status codes are stored in this file.

41. Quick Work Order (QIKWRK)

This file contains all the quick W/O in use.

42. Temporary item file (TMPITM)

Temporary items are stored in this file.

43. Kit used lock file (KUSLCK)

This file protects a working file.

44. Work order used lock file (WUSLCK)

This file protects a working file.

Field number to change ?

Make any needed changes, or use one of the options:

<PgUp>

For the previous screen

<F1>

To set all files to Y

<F2>

To initialize the files

<Esc>

Cancel and close the program

Job Cost

To Initialize Job Cost data files, execute the Passport Business Solutions initialization function.

To use this utility you must be a PBS administrative user to use this utility. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> JC Initialization

For UNIX or Linux

Type the following:

cd /usr/psi

or replace “/usr/psi” with the name of your PBS top-level
directory.

Then type the following:

jcinit

If you are using multiple companies, enter the 2-character company-id. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen displays:

When this screen is first displayed, all its fields are blank except the first. The cursor moves through each field in sequence until all have been traversed. You can then change any field.

Options 

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including Field number to change ?), you can use one of the options:

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle, alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked Yes, without waiting to reach Field number to change ?. You will be asked to confirm that you want to do this.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as Skipped.

File/Table Descriptions

The following table lists all the entries on the screen and provides a description of each file. Cross-references are given to the Job Cost User documentation chapters where the contents of the data is described. In addition, the internal name of the file is given. This is useful when relating the file name to several features described in this documentation like pathfinder and data recovery utilities.

#

File name shown on screen

Job Cost Manual

Chapter Reference

Internal file name

(pathfinder)

Description/Contents of File

1

Job Cost Control file

Control Information

JCCTLF

Parameters defining your job cost structure

2

Job Master file

Job Descriptions

MSTFIL

Full definition and specification of each job. Contains the identifying description record for each job and one or more cost item records, providing the component parts of each job

3

Job Master Change Log file

Job Descriptions

CNGMST

Used to log changes or deletions made to the Job Master file. Can be selectively purged after the Change Log is printed. If you are not using the change log function (per the Company file), no data is put into this file.

4

Additional Description file

Job Descriptions

DESCFL

Additional description you can enter for the job header records or job cost item records

5

Cost Category file

Cost Categories

CATFIL

Master list of cost categories that are used on all your jobs

6

Job Detail file

Job Descriptions

DTLFIL

Complete record of all cost and billing transactions entered for jobs. These transactions stay in the Job Detail file until you specifically request to save them in another file (the Holding file or Inactive Job Detail file) or purge them.

 

All transactions entered directly in Job Cost and all transactions for jobs that were entered through other Passport Business Solutions modules

7

Cost Transaction file

Costing; Get Costs

CSTTRX

Temporary file for cost entries (transactions). Can be entered directly in the Job Cost module or interfaced into Job Cost from other Passport Business Solutions modules via the Get costs function. When cost transactions are posted, they are deleted from this file at the same time.

8

Cost Transaction Lock file

Costing; Get Costs

CSTLCK

Protects the Cost Entry file during posting of cost transactions

9

Billing and Payment Transaction file

Billing and Payment

BLPTRX

Temporary file for billing and payment entries (transactions) entered directly in Job Cost. File is purged each time such transactions are posted.

10

Billing and Payment Lock file

Billing and Payment

BLPLCK

Protects the Billing Entry file during the posting of billing and payment transactions

11

Activity Transactions file

Completion Estimates

ACVTRX

Temporary work file for activity transactions. Is completely purged each time activity transactions are posted. Activity transactions are another term for completion estimate transactions.

12

Activity Transactions Lock file

Completion Estimates

 

ACVLCK

Protects the Activity Entry file during posting of activity transactions.

13

Job Cost Distribution file

Billing and Payment; Costing‘

JCDIST

Used only if you are not using all three of the PBS A/R, A/P, and PR modules. In this case, it holds all general ledger distributions resulting from cost transactions and billing and payment transactions entered directly in Job Cost. Can be selectively purged at any time.

14

Inactive Job Master file

Utilities

MSTFIX

Saves jobs that have been closed, and that you want to remove from your active files and store for later use or review

15

Inactive Job Detail file

Utilities

DTLFIX

Saves the detailed transactions for the jobs saved in the Inactive Job Master file

16

Inactive Description file

Utilities

DESCFX

Saves the additional description for the jobs saved in the Inactive Job Master file

17

Detail Holding file

Utilities

HLDFIL

Temporarily saves or holds detailed transactions (from the Job Detail file) for jobs that are still active. Allows you to temporarily keep detailed transactions not current in a separate file, so they will not be included with the current detail

Field number to change?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

Order Entry

To Initialize Order Entry data files, execute the Passport Business Solutions initialization function.

You must log in as a PBS administrative user to use this utility. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> OE Initialization

For UNIX

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level directory.

Then type the following:

oeinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen appears:

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

OE Data Descriptions

A brief description of each data file is listed below:

1. O/E control file (OECTLF)

This file contains a number of module parameters and default values for Order Entry.

2. O/E Notes file (OENOTF)

This file contains all the notes you have entered in the various O/E selections that allow notes. Notes associated with either orders, quotations, or recurring orders.

3. O/E Form file (ORFRMF)

This file contains definitions for forms that can be printed from orders. The predefined invoice forms that are supplied with O/E are contained in this file, as well as any new forms that you may define.

4. Order header file (ORDHDR)

This file contains a record for each unbilled order, unposted invoice, credit memo, quote, or RMA. If back order control is used, incomplete orders (those that contain back ordered items) remain in the file until back orders are filled.

5. Order line item file (LINITM)

This file contains a record for each line item associated with a specified order, invoice, credit memo, quote, or RMA. It is used to produce all order reports and is purged when the associated order, invoice, credit memo, quote, or RMA is removed from the Order Header file.

6. Order line serial file (OETKXF)

This file contains a record for each serial number or lot number associated with a specific line item on a particular order, invoice, credit memo, or RMA.

7. Invoice lock file (INVLCK)

This file is used to protect the Order files.

8.Recurring order header file (OERHDR)

These files contain order header and line item detail for recurring orders that may be used repeatedly for creation of regular orders.

9.Recurring order line item file (LINITM)

This file contains order line item detail for recurring orders.

10.Label format file (ELBFMT)

This file contains one record for each COD and shipping label format that you set up.

11. Labels lock file (ELBLCK)

This file protects the Label Format file.

12.Immediate invoice lock file (IMILCK)

This file protects order files.

13. E.D.I. audit file (EDIAUD)

This file protects the E.D.I. audit file.

14. Invoice forms parameter (OEFPAR)

This file saves the parameters for printing forms.

Field number to change?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

Purchase Order

To Initialize Purchase Order data files, execute the Passport Business Solutions initialization function.

You must log in as a administrative user authorized to use PBS software. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> PO Initialization

For UNIX

Type the following:

cd /usr/psi

or replace “/usr/psi” with the name of your PBS top-level directory.

Then type the following:

poinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen displays:

When this screen is first displayed, all its fields are blank. The cursor moves through each field in sequence until all have been traversed. You can then change any field.

Options 

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field you can use one of the options:

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle, alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked Yes, without waiting to reach Field number to change ?. You will be asked to confirm that you want to do this.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as Skipped.

P/O Description Table

The following table lists all the entries on the screen and provides a description of each file/table. Cross-references are given to the chapter(s) where the contents of the file are described. In addition, the internal name of the file is given; this is useful when relating the file name to several features described in this documentation (pathfinder; data recovery utilities).

 

#

Screen

File

Name

Purchase Order

Manual

Chapter Reference

Internal file name

Description

1

P/O control file

Control Information

POCTLF

Contained within this file are a number of parameters that define your purchase order structure. Each parameter determines a specific procedure to be used in other modules.

2

Delivery location file

Deliver-to Locations

WHSFIL

Contains locations and addresses where items are to be stocked and received. It is the same file used in Inventory Control, where it is called the Warehouse File. If you are using Inventory Control, both modules will use the same file.

3

Vendor item file

Vendor Items;
Set Up Vendor Item File

VENITM

Contains the vendors you do business with and the items they provide. Vendor item records contain data about the vendor and the item.

4

P/O master hdr file

Purchase Orders

POHDRF

Contains one header record for each purchase order.

5

P/O master line file

Purchase Orders

POLINF

Contains line items associated with a specific purchase order.

6

P/O master dist file

Purchase Orders

PODIST

Contains distribution records associated with a specific line item.

7

P/O auxiliary file

Purchase Orders

AUXFIL

Contains special messages or manually entered deliver-to addresses associated with purchase order header records, and additional descriptions that have been entered for line item records.

8

Pre-purchase lock file

Pre-purchase Processing

PRELCK

Used to ensure that only one user issues purchase order numbers or prints the purchasing worksheet at a time.

9

P/O trans hdr file

Purchase Orders

HDRTRX

Contains one header record for each purchase order transaction.

10

P/O trans line file

Purchase Orders

LINTRX

Contains line items associated with a specific purchase order transaction.

11

P/O trans dist file

Purchase Orders

DISTRX

Contains distribution records associated with a specific purchase order transaction line item record.

12

P/O trans notes file

Purchase Orders

LNNOTF

Contains the notes associated with P.O. line items.

13

P/O trans lock file

Purchase Orders

PCHLCK

Used to protect the Purchase Order Transaction Files.

14

Chng trans hdr file

Changes to Purchase Orders

CNGHDR

Contains header records of purchase orders that have been changed.

15

Chng trans line file

Changes to Purchase Orders

CNGLIN

Contains line items associated with a specific purchase order that has been changed.

16

Chng trans dist file

Changes to Purchase Orders

CNGDIS

Contains distribution records associated with a specific purchase order line item that has been changed.

17

Chng trans notes file

Changes to Purchase Orders

CNNOTF

Contains the notes associated with change P.O. line items.

18

Chng trans lock file

Changes to Purchase Orders

CNGLCK

Used to protect the Change Transaction Files.

19

Receiving trans file

Receivings

RCVTRX

For receiving transactions. When you receive items, they are entered into this file, and are cleared when posted to the permanent files.

20

Receiving trans lock file

Receivings

RCVLCK

Used to protect the Receiving Transaction File.

21

Receivings history file

Receivings

RCVHIS

Contains the Receivings information after it has been posted. Receivings records remain on file until purged by the user.

22

Price adjustment file

Adjust Receivings

PRCADJ

Contains the adjustments to prices entered for items received. When these adjustments are posted as the new prices, this file is cleared.

23

Price adjust lock file

Adjust Receivings

PRCLCK

Used for multi-user systems, and prevents users from doing incompatible actions while processing price adjustments.

24

Release trans file

Releases

RELTRX

Contains release transactions that have been entered for blanket purchase orders.

25

Release trans lock file

Receivings

RELLCK

Used to protect the Release Transaction File

26

Prepurchase order

Pre-purchase processing

PREFIL

Contains issued purchase order numbers prior to processing.

27

PO Messages

Purchase Order Messages

POMSGS

Contains messages entered for Purchase Orders.

28

Vendor Item Srch

Vendor Items

VENKEY

Holds search receiving transactions.

29

Receiving serial

Receivings

RCSTXF

Holds serial receiving transactions

30

PO Notes

Purchase Orders

PONOTF

Holds notes entered for Purchase Orders

31

PO Form File

Purchase Order Forms

POFRMF

Contains user-defined forms templates.

Field number to change?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

Payroll

To Initialize Payroll data files, execute the Passport Business Solutions initialization function.

You must log in as a administrative user authorized to use PBS software.

Under Windows, Select

Start -> Programs -> Passport Business Solutions -> Init Utilities -> PR Initialization

Under Linux/UNIX

Ensure you are logged in as a user authorized to use PBS software. Refer to the PBS Users chapter for more information.

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level
directory.

Then type the following:

prinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen displays:

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including “Field number to change ?”), you may use one of the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

PgUp

To return to the first field on the screen, if not there already.

PgDn

(1) To proceed to the last field on the screen, if not there already. (2) If already at the last field or at “Field number to change ?”, to proceed to the second screen, preserving all existing settings on the first screen.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Enter the following information:

1.PR control file (PRCTLF)

Contained within this file are a number of parameters that define your payroll structure. Each parameter provides information used by the Payroll system in its normal operation.

2.Deduction code file (DEDCOD)

Each possible earning other than wages and each deduction (other than withholding taxes, garnish amounts, loan repayments and union dues) are entered in this file along with parameters that define the accounting procedures to which each deduction/earning code is subject.

3.Tax code/table file (TAXCOD)

This file contains all of the tax codes and tables.

4.Employee file (EMPFIL)

This file contains all information pertinent to all employees and non-employees who receive compensation through the Payroll module.

5.Employee notes files (PRNOTF)

This file contains all the notes you have entered in the various Payroll selections that allow notes.

6.Change employee file (CNGEMP)

This is a log of changes to the Employee File and who made them.

7.Time trans file (TIMTRX)

This is the main working file of the Payroll system. It is used for entry of time worked by your employees.

8.Time trans dist file (TIMDIS)

This field is used to temporarily store distributions to general ledger for the time worked entered in the previous file.

9.Time trans lock file (TIMLCK)

This file is used to protect the Time Transaction File, so that two users cannot post Time Worked entries at the same time.

10.Check file (CHKFIL)

This file is used to track payroll checks from the moment they are printed until they have been posted.

11.PR dist to G/L file (PRDIST)

This file contains one record for each General Ledger distribution generated by the Payroll module. It is used to generate the Payroll Distribution to G/L report and, if the Passport Business Solutions General Ledger module is used, this file is the input to the General Ledger interface program. This file normally contains all of the detailed G/L distributions for one month or accounting period.

12.PR history file (KHISFIL)

This file contains detail for each check that was paid, one record per transaction. It is used to produce the Payroll History Report, Union Dues Report, and Employee Meals Report, as well as other reports.

13.QTD history file (QTDHIS)

This is a permanent file containing quarter-to-date totals for each employee and is used for tax reporting as well as various employee reports.

14.YTD history file (YTDHIS)

This is a permanent file containing, for each employee, one record for every earning and/or deduction category that the employee is subject to during the year.

15.Manual PR trans file (MANTRX)

This file is used to record manual adjustment payroll transactions.

16.Manual PR dist file (MANDIS)

This file is used to record any General Ledger distributions associated with manual payroll adjustments.

17.Manual trans lock file (MANLCK)

This file is used to protect the Manual PR Transaction File.

18. Void P/R check trans file (VDPCHK)

This file is used to record payroll check information to allow the user to void a check.

19. Void P/R check master file (VDMTRX)

This file is used to store payroll check detail information to be used during the void checks functions.

20. Void P/R check work file (VDMWRK)

This file is used to temporarily store payroll data during the void check processing.

21.Federal auxiliary file (EMPFAU)

This file contains federal information used in printing W-2 forms for each employee.

22.State auxiliary file (EMPSAU)

This file contains state information used in printing W-2 forms for each employee.

23.Auxiliary lock file (AUXLCK)

This file is used to protect the Auxiliary File.

24.Extended field file (EXDATA)

This file contains the user-defined extended field definitions.

25.Employer extended info file (EMPREX)

This file contains the user-defined extended employer information used for magnetic media reporting.

26.Employee extended info file (EMPEXT)

This file contains the user-defined extended employee information used for magnetic media reporting.

27.Magnetic media lock file (MAGLCK)

This file is used to protect the Magnetic Media Format File.

28.Mag general information file (MAGGNA)

This file contains the customized magnetic media General Appearance information.

29.Magnetic media format file (MAGFMT)

This file contains the customized magnetic media report formats.

30.YTD state/city history file (SCDHIS)

This file contains the year to date history for state and city taxes.

31. Payroll report format file (RPTMFT)

This file contains the user defined customized report formats.

32. Payroll report lock file (RPTLCK)

This file is used to protect the Payroll Report file.

Field number to change ?

Make any needed changes.

Press <Enter> from a blank “Field number to change” to proceed to the next screen or select <Esc> to cancel.

Continue to answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. The cursor will move through each field in turn, and you will be able to correct any errors from “Field number to change?”. You may also use the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked “Yes”, without waiting to reach “Field number to change ?”. You will be asked to confirm that you want to do this.

PgUp

(1) To return to the first field on the screen, if not there already. (2) If already at the first field or at “Field number to change ?”, to return to the previous screen. This is not the same as <Esc>, since all your settings on the second screen are preserved.

PgDn

To proceed to the last field on the screen, if not there already.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

33. Multi-city multi-state file (MCSFIL)

This file contains information about those employees who are liable for taxes to more than one state and/or to more than one city.

34. Jurisdictions file (MJRFIL)

This file contains miscellaneous jurisdiction information for federal and state reporting requirements.

35. Employee DDA file (EMPDDA)

This file contains bank account information for each employee.

36. Payroll positive pay format file (PRFRMF)

This file contains positive pay file formats.

37. Employee auxiliary file (EMPAUX)

This file contains employee auxiliary records.

38. Time trans history file (TIMHIS)

This file contains employee auxiliary records.

39. Manual transaction history file (MANHIS)

This file contains employee auxiliary records.

Field number to change ?

Point of Sale

To Initialize Point of Sale data files, execute the Passport Business Solutions initialization function.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> PS Initialization

For UNIX

Ensure you are logged in as a user authorized to use PBS software. Refer to the PBS Users chapter for more information.

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your Passport top-level directory.

Then type the following:

psinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following screen displays.

When this screen is first displayed, all its fields are blank. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

The following table lists all the entries on the screen and provides a description of each file. The internal name of the file is given; this is useful when relating the file name to several features described earlier this manual (pathfinder; data recovery utilities).

#

File name as shown on screen

Internal namepathfinder

Description

1.

P/S control file

PSCTLF

This file contains parameters that define the basic operation of your Point of Sale module

2.

Alias items file

ALIITM

This file contains alias item numbers that refer to I/C items and P/S services.

3.

Credit card file

CCRDFI

Customer credit card information is contained in this file.

4.

Contract pricing file

CNTRPC

This file maintains special pricing for specific customers. Special pricing can be offered for a certain item or service or an entire category of items or services.

5.

Customer restrictions file

CRDHLD

Customer payment restrictions are maintained in this file.

6.

Drawer file

DRWFIL

When drawers are opened, they are added to this file. During posting, closed drawers are removed from this file.

7.

Override file

OVRRID

This file contains all price or credit overrides that are done during transaction processing. This information is moved to history during posting.

8.

Trx/line commnt file

POSCMT

Line item and transaction comments that are entered during transaction processing are stored in this file.

9.

Trx header file

POSHDR

This file contains one record of bill-to/ship-to and related information for each unposted transaction

10.

Trx lock file

POSLCK

This file is used to protect transaction files during processes that require exclusive use of certain Point of Sale files.

11.

Trx line file

POSLIN

This file contains line items information for unposted transactions.

12.

Trx payment file

POSPAY

This file contains unposted payments.

13.

Sales summary file

POSSUM

This file keeps a cumulative history of sales to report by category, by customer, by item, by sales rep and by sales volume.

14.

Services file

POSSVC

This file stores services that your company offers.

15.

Payout file

POTFIL

This file contains a record for each payout that occurs during transaction processing.

16.

Payment codes file

PSCODS

This file contains Point of Sale payment codes for cash, credit cards, checks, etc.

17.

Ship-to addresses file

PSSHIP

This file contains alternate ship-to addresses for customers.

18.

Posted payments file

PSTPAY

This files stores payments that were made during transaction processing and have been posted.

19.

Register file

REGIFI

This file contains information descriptive of registers used during transaction processing.

20.

Comment history file

SHSCMT

This file stores line item and transaction comments that were entered during transaction processing and have been posted.

21.

Header history file

SHSHDR

This file contains one record of historical bill-to/ship-to information for each posted transaction.

22.

Line item history file

SHSLIN

This file contains historical line item information for posted transactions.

23.

Payment history file

SHSPAY

This file contains historical payment information of posted transactions.

24.

Special sale price file

SPCSAL

This file stores special sale prices that apply to specific items or services and for entire categories of items for a specific period of time.

25.

Store file

STORFI

This file contains information specific to the operation of each store.

26.

User file

USERFI

This file contains information specific to users of the Point of Sale module.

27.

Serial transaction file

PSTKFX

This file contains the serial and lot number transaction information.

28.

Serial history file

SHSSER

This file contains the serial and lot number transaction history information.

29.

Layaway comments history file

LWYCMT

This file stores line item and transaction comments for canceled or forfeited layaway transactions.

30.

Layaway header history file

LWYHDR

This file stores header information for canceled or forfeited layaway transactions.

31.

Layaway line history ifle

LWYLIN

This file stores line information for canceled or forfeited layaway transactions.

32.

Layaway payment history file

LWYPAY

This file stores payment information for canceled or forfeited layaway transactions.

33.

Layaway serialization/lot tracking file

LWYTRK

This file stores item serial and lot information for canceled or forfeited layaway transactions.

Field number to change ?

Make any needed changes.

Press <Enter> to initialize all selected files. There will be a period of processing as files are initialized, then the program will close.

Press <ESC> to cancel the operation.

Sales Analysis

To Initialize Sales Analysis data files, execute the Passport Business Solutions initialization function.

You must be logged in as an administrative user authorized to use PBS utilities. Refer to the PBS Users chapter for more information.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> SA Initialization

For UNIX

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your Passport top-level directory.

Then type the following:

sainit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

A screen similar to this appears:

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing the data.

The following table lists all the entries on the screen and provides a description of each file/tables. Cross-references are given to the chapter[s] where the data contents. In addition, the internal name of the file is given; this is useful when relating the file name to several features described in this documentation like pathfinder and data recovery utilities.

#

Screen File Name

Sales Analysis Manual Chapter Reference

Internal File Name

Description

1.

Saved report file

Common Features

SARPTP

Stores saved report selection parameters

2.

Customer comparative file

Customer
Comparatives

CUSCMP

Contains historical information on sales by customer

3.

Cust comparative
control file

Control Information

SACTLR

Contains parameters needed to interface to A/R for obtaining the customer comparative reports.

4.

Item comparative file

Item Comparatives

ITMCMP

Contains historical information on sales by item

5.

Item comparative
control file

Control Information

SACTLC

Contains parameters needed to interface to I/C for obtaining the item comparative reports.

Field number to change?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

Time and Billing

To Initialize Professional Time and Billing data files execute the Passport Business Solutions initialization function.

For Windows

Start -> Programs -> Passport Business Solutions -> Init Utilities -> TB Initialization

For UNIX

Ensure you are logged in as an administrative user to use PBS data recovery utilities. Refer to the PBS Users chapter for more information.

Type the following:

cd /usr/pbs

or replace “/usr/pbs” with the name of your PBS top-level
directory.

Then type the following:

tbinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

For space reasons, two screens are needed to contain all the files. You can switch between the two screens as needed. No files are initialized until you have approved both screens.

Two screens are required for all the files in this module. The following appears first:

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. At any field (including “Field number to change ?”), you may use one of the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

PgUp

To return to the first field on the screen, if not there already.

PgDn

(1) To proceed to the last field on the screen, if not there already. (2) If already at the last field or at “Field number to change ?”, to proceed to the second screen, preserving all existing settings on the first screen.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files

The following table lists all the entries on the screen and provides a description of each file. The internal name of the file is given; this is useful when relating the file name to several features described in the earlier in this manual (pathfinder; data recovery utilities).

#

File name as shown on screen

Internal name pathfinder

Description

1.

Action file

ACNFIL

Contains the action codes and descriptions.

2.

Advance billing file

ADVBFL

Contains one record for each billing on account which has not yet been fully used to “pay” for WIP during billing.

3.

Advance billing account file

ADVACT

Contains the advance billing account numbers, description, statement type and comments. These accounts must also exist in the Valid G/L Accounts File.

4.

Advance billings used file

ADVBHF

This file contains a record for each use of a billing on account to “pay” for a WIP during billing.

5.

Change client file

CHGCLI

Contains one record made for each change made to the client file.

6.

Client file

CLIFIL

Contains relevant client information such as name, address, billing method, discount terms, tax status, and period /year-to-date statistics. (Whenever a new client is entered, a record is created both the Client File in PTB and Customer File in A/R.)

7.

Client notes file

TCNOTF

Contains notes you have entered for clients.

8.

Client rate file

CLRFIL

This file may be used to enter client-specific billing rates for staff.

9.

Cost history file

COSTHF

Contains cost information for non-billable “by the hour” services and non-billable “cost plus” expenses from posted time and expense sheets.

10.

Current matter file

CURMAT

For each client, the matter to which periodic advance billing retainers are to be applied is entered in this file.

11.

Expense file

EXPFIL

This file contains one record for each expense code entered through Expenses.

12.

Fixed fee file

FIXTRX

Contains one record for each fixed fee billing, contingent fee billing, and billing adjustment that has not been invoiced.

13.

Fixed fee history file

FFCHSF

Contains time and expense history for fixed fee matters.

14.

Invoice file

TBINVC

Contains one record for each invoice.

15.

Invoice format file

BLLFMT

This file contains the complete descriptions of the header areas, line items areas, and footer areas of your invoice formats.

16.

Invoice format control file

BILLCK

This file contains the General Appearance information for your invoice formats.

17.

Invoice format lock file

BLFMLK

This file protects the Invoice Format File.

18.

Invoice history file

BLHIST

This file contains the history information for posted invoices.

19.

Invoice history auxiliary file

BLHAUX

This file contains the billing descriptions for posted invoices.

20.

Invoice posting lock file

 

This file protects the billing files during invoice posting.

21.

Matter file

MATFIL

Contains basic information about each matter undertaken for each client.

22.

Matter notes file

TMNOTF

Contains notes you have entered in matters.

23.

PTB control file

TBCTLF

Parameters that define the basic structure of your T/B module

24.

Report parameter file

TBRPTB

When you are entering the parameters to use in printing various reports, you can choose to save them. If you do, they are contained in this file.

25.

Retainer file

RETFIL

The file contains one record for each retainer.

26.

Service file

SVCFIL

Contains the service description, period/year-to-date fields and accounts.

27.

Staff file

STFFIL

Contains information about the staff including rates.

28.

Time & expense header file

TBHDRF

This file contains one record for each time & expense sheet.

29.

Time & expense line file

TBLINF

This file contains one record for each service or expense line entered on a time & expense sheet.

30.

Time & expense auxiliary file

TBAUXF

This file contains billing descriptions entered for billable lines on the time & expense sheets.

31.

Time & expense lock file

TBFLCK

This file is used to protect the time & expense files during posting.

32.

Void invoice file

TBVOID

This file contains one record for each voided invoice.

Field number to change ?

Make any needed changes or select the <Esc> key to cancel.

Press <Enter> from a blank “Field number to change” to proceed to the next screen.

Continue to answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. The cursor will move through each field in turn, and you will be able to correct any errors from “Field number to change?”. You may also use the options:

Options 

<F1>

To set all fields to Y. After the first use of this option, this key functions as a toggle; alternating between setting all fields to Y and to N.

<F2>

To initialize all files marked “Yes”, without waiting to reach “Field number to change ?”. You will be asked to confirm that you want to do this.

PgUp

(1) To return to the first field on the screen, if not there already. (2) If already at the first field or at “Field number to change ?”, to return to the previous screen. This is not the same as <Esc>, since all your settings on the second screen are preserved.

PgDn

To proceed to the last field on the screen, if not there already.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

#

File name as shown on screen

Internal name

pathfinder

Description

33.

WIP file

WIPFIL

This file contains one record for each unbilled service (for matters whose service billing terms are “by the hour”) and for each unbilled expense (for matters whose expense billing terms are “cost plus”).

34.

WIP accounts file

WIPACT

Contains the work-in-process account number, description and comment. These accounts must also exist in the Valid G/L Accounts File.

35.

WIP auxiliary file

WIPAUX

This file contains any additional description entered for work-in-process items, plus any notes.

36.

WIP history file

WIPHIS

Work-in-process history information for posted invoices

37.

WIP history auxiliary file

WIPHAF

Work-in-process billing descriptions from posted invoices.

Field number to change?

Make any needed changes. Press <Enter> to initialize the selected files. Files not selected are not affected. It is not required that any file be selected. There will be a period of processing as the files are processed, and then the program closes.

Select <Esc> to cancel.

Customer Orders

To Initialize Customer Orders data files, execute the Passport Business Solutions initialization function.

For Windows and UNIX

Ensure you are logged in as an administrative user to use PBS data recovery utilities. Refer to the PBS Users chapter for more information.

From the PBS top-level, type the following:

coinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

The following appears:

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files/Tables

The following table lists all the entries on the screen and provides a description of each file. The internal name of the file is given; this is useful when relating the file name to several features described earlier in this documentation like pathfinder and data recovery utilities.

#

File name as shown on screen

Internal name pathfinder

Description

1.

C/O control file

COCTLF

Customer orders control information

2.

Order header file

CSOHDR

Customer orders header records.

3.

Order comments file

CSOCOM

Order comments.

4.

Order line item file

CSOLIN

Order line items.

5.

Order line comments file

CSOLCM

Order line comments.

6.

Billing lock file

BIMLCK

Billing lock file.

7.

Backlog order sales file

COPBOS

Backlog order sales file

8.

C/O sales trans file

SALTRX

Sales transactions.

9.

C/O sales dist file

SALDST

Sales distributions.

10.

C/O sales history file

SALHIS

Sales history.

11.

Ship-to history file

 

Ship-to history.

12.

Customer type file

CUSTYM

Customer types.

13.

Sales rep commission file

SLSCOM

Sales rep commissions.

14.

Price discount file

PRCDSC

Price discounts.

15.

Std certifications file

CTFFIL

Standard certifications.

16.

Sales accounts file

SLSACM

Sales accounts.

17.

Special prices file

SPCPRC

Special prices.

18.

Customer tracking file

BOSTRK

Customer tracking.

19.

Lot/serial ship detl file

CSOLSN

Lot and serial shipping details.

20.

Packing list select file

PAKSEL

Packing list selected.

21.

Daily sales file

COPORD

Daily sales.

22.

Customer file

SCUSTF

Customers. Normally the customers in A/R are used and there is no data in here.

23.

Sales rep file

SSLMFI

Sales reps. Normally the sales reps in A/R are used and there is no data in here.

24.

Customer codes file

SARCOD

Customer codes.

25.

Commissions due file

SCOMFI

Commissions due.

26.

A/R dist to G/L file

SARDIS

Distributions to G/L

27.

Summary work file

BOSSRT

Summary work.

28.

Bill of lading select file

BOLSEL

Billing of lading selected.

29.

Form design file

COFRMF

Custom invoice design file.

Continue to answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file. The cursor will move through each field in turn, and you will be able to correct any errors from “Field number to change?”. You may also use the options:

Options 

PgUp

(1) To return to the first field on the screen, if not there already. (2) If already at the first field or at “Field number to change ?”, to return to the previous screen. This is not the same as <Esc>, since all your settings on the second screen are preserved.

PgDn

To proceed to the last field on the screen, if not there already.

30.

Customer P.O. header file

CPOHDR

 

31.

Customer P.O. detail file

CPODTL

 

32.

Customer P.O. allowances file

CPOALW

 

33.

Customer P.O. notes file

CPONTE

 

34.

Customer P.O. names file

CPONAM

 

35.

Customer P.O. terms file

CPOTRM

 

36.

EDI item file

EDIITM

 

37.

EDI trading partners file

EDICUS

 

38.

Standard carrier codes file

SCACOD

 

39.

EDI lock files

CPOLCK

 

 

40.

EDI 'C' file

EDIIVC

 

41.

EDI 'D' file

EDIIVD

 

42.

EDI item comment file

EDITCM

 

Inventory Management

To Initialize Inventory Management data files or tables, execute the Passport Business Solutions initialization function.

For Windows and UNIX

Ensure you are logged in as an administrative user to use PBS data recovery utilities. Refer to the PBS Users chapter for more information.

From the PBS top-level, type the following:

iminit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files/Tables

The following table lists all the entries on the screen and provides a description of each file. The internal name of the file is given; this is useful when relating the file name to several features described earlier in this manual (pathfinder; data recovery utilities).

#

File name as shown on screen

Internal name pathfinder

Description

1.

I/M control file

IMCTLF

I/M Control information

2.

Item master file

ITMMST

Item master records

3.

Item comments file

ITMCOM

Item comments

4.

Branch whse item file

BWHITM

Branch warehouse items

5.

Purchase order item file

POLITM

Purchase order items

6.

Shop order file

SOFILE

Shop orders

7.

Shop order comments file

SOCOMT

Shop order comments

8.

Shop order mtl reg file

SOMATL

Shop order material

9.

Physical count file

PHYCNT

Physical count

10.

Inven trans history file

INVHIS

Inventory transaction history

11.

Matl usage variance file

MUVHIS

Material usage variance

12.

G/L dist lock file

GLICTL

Distribution lock data

13.

G/L dist work files

GLDRPT

Distribution work data

14.

Item type code file

ITMTYP

Item types

15.

Warehouse code file

WHSCOD

Warehouse codes

16.

Inv cost category file

ICSCAT

Inventory cost categories

17.

Product category file

PRDCAT

Product categories

18.

Warehouse accounts file

IACWHS

Warehouse accounts

19.

Period qty sold file

PQSHIS

Period quantity sold

20.

Lot/serial # hist file

LSNHIS

Lot and serial number history

21.

On hand detail file

OEIDET

On hand details

22.

Sched exception dates file

SCXDAT

Schedule exception dates

23.

Freeze inventory file

PHYFRZ

Physical count freeze of quantities

24.

Freeze on-hand inven. file

OHIFRZ

On-hand inventory that is frozen

25.

Serial-# notes file

LSNOTF

Serial number notes

Product Purchasing

To Initialize the manufacturing product purchasing data files or tables, execute the Passport Business Solutions initialization function.

For Windows and UNIX

Ensure you are logged in as an administrative user to use PBS data recovery utilities. Refer to the PBS Users chapter for more information.

From the PBS top-level, type the following:

ppinit

If you are using multiple companies, enter the 2-character company-id for the files you wish to initialize. If the company is correct, answer Y. When prompted, enter an administrative User ID.

When this screen is first displayed, all its fields are blank except the first one. The cursor moves through each field in sequence until all have been traversed. You may then change any field.

Answer <Y> for each file you want to initialize, or press <Enter> to default to <N> to skip initializing a file.

Format

One letter at each field, either Y or N. The default is N.

Example

Press <Enter> at each field. This displays as “Skipped”.

Data Files/Tables

The following table lists all the entries on the screen and provides a description of each file. The internal name of the file is given; this is useful when relating the file name to several features described earlier in this manual (pathfinder; data recovery utilities).

#

File name as shown on screen

Internal name pathfinder

Description

1.

P/O control file

PPCTLF

P/P Control information

2.

Purchase order header file

PPHDRF

Purchase order header records

3.

Purchase order item file

POLITM

Purchase order line items

4.

P.O. item comment file

POLCOM

Purchase order item comments

5.

P.O. change log file

POCHGL

Purchase orders changes

6.

Blanket P.O. header file

BPOHDR

Blanket order headers

7.

Blanket P.O. item file

PBOLIN

Blanket P.O. line items

8.

Blanket item comment file

BOLCOM

Blanket P.O. line item comments

9.

Item source file

ITMSRC

Item sources

10.

Non-vendor source file

NONSRC

Non-vendor sources

11.

Vendor shipmts in-transit

VENSIT

Shipment that are in transit

12.

P.O. comments file

POCOMT

Purchase order comments

13.

Reject reason code file

PRRCOD

Item reject reasons

14.

Vendor warehouse file

VENWHS

Warehouses

15.

Planner/buyer code file

PLNBUY

Planner/buyer codes

16.

Purchasing address file

POADDR

Purchasing addresses

17.

Vendor file

SVENFI

Vendors (if not using A/P)

18.

Rejected material file

RJTMTL

Rejected material

19.

Receiving history file

RCMHIS

Receiving history

20.

Vendor performance file

VENPFM

Vendor performance

21.

P.O. invoice dist. file

POIDST

P.O. invoice distributions

22.

P.O. invoice trans. file

POITRX

P.O. invoice transactions

23.

A/P dist to G/L file

SAPDIS

Distributions to G/L

24.

Price var. detail file

PPVDET

Price variance details

25.

Price var. summary file

PPVSUM

Price variance summary

26.

P.O. lick files

 

Purchase order lock files

27.

Uninvoice receipts file

UIRRPT

Purchase orders that have not been invoiced.

Module and Multiple Company Initialization

This utility will initialize data files and SQL tables for an entire module for one or multiple companies. Use this utility with caution as this could remove ALL the data from your entire system.

In order to run this utility, you must be a PBS administrator.

From the top-level PBS folder

Select

INITPB

Enter your user ID and password.

A screen like the following displays:

Enter the company number or select <F5> for all companies

Select the modules that you want to initialize.

Any change?

Select N to continue or Y to re-enter the screen.

When you select N to continue, then the files or SQL tables will be initialized for the companies and modules selected.