Technical

Home < Vision Point < Sales Commissions

Sales Commissions
Description:

If the programs are previously unmodified and the same versions, these new programs may just be copied over. As with all modifications, it is recommended that the ACCPAC versions be checked to assure they are the same. Programs that have been modified are distributed in the same manner as described in the ACCPAC Installation Guide. Programs beginning with "TO", "T0", and "P0" should be treated the same as "SYS" files in ACCPAC, and should be located in the same directory as "SYSDATA.DBF". If there are any databases on the distribution disk that begin with "TO" they should also be located in the system directory. Please refer to the installation instructions. The TOINST program will normally rename and locate programs as required, but some files may need to be moved depending on the individual system configuration.

The enhancement includes programs beginning with "p0" that may be added to SYSMULT if desired, but it is not necessary. You must enter each salesperson into the salesperson file in order to start using them on future sales orders. Old sales (prior to installing the tool) will not show commissions. If updating an existing system, be sure to add any existing sales people to the salesperson file or the system will error when trying to enter an invoice for that salesperson. This program enhancement makes use of the new menu structure for Series 7. The salesperson information is maintained from the selection titled "Custom".
       
Program and Form Changes:

The following programs and forms have either been changed or added:

TYPE FILE NAME DESCRIPTION
PROGRAMS
ARPOSE.PRG Revise Current Invoice/Credit Memo
ARPASS.PRG Add/Change/Delete Password
AROREC.PRG Open Receivable Report
ARMANV.PRG Void Invoice/Credit Memo
ARORCB.PRG Salesperson Receivables Report
SOMENU.PRG Main Menu
TOSLCOM.PRG Pay Sales commission
ARSLCLS.PRG Closing the Salesperson File
MENUS
ARMAIN.MPR AR Main Menu
FORMS
TOSLMRS.*
PROGRAMS
TOSLMR.PRG Salesperson File Report
ARMANT.PRG AR Invoice Maintenance
ARMENU.PRG Main Menu
ARCASP.PRG Cash Receipts
ARPREC.PRG Process Recurring Billing
TOSLHST.PRG Salesperson History
SOPOSD.PRG Enter SO Detail
SYSREPS.PRG Sales People Screen
ARPOSM.PRG Post Manual Invoice
TOCREA.PRG Set Up Files Varibles and Create/Delete/Check Data Files
ARCASQ.PRG Process Cash Receipts
TOFLOC.PRG Locate Directory Placement of Files
TOSLINQ.PRG Salesperson Inquiry
TOINST.PRG Install Dictionary
SOMANE.PRG Edit SO Header
SOSHIP.PRG Enter Shipment
SOSHPE.PRG Enter Shipment Detail
SOMAND.PRG Edit SO Detial Lines
SMDTBL.PRG
SOCREA.PRG Set Up Files Varibles and Create/Delete/Check Data Files
FORMS
TOSLSUM.* Sales Person Summary report
MENUS
SOMAIN.MPR Sales Main Menu
PROGRAMS
SOMANT.PRG Edit SO Detail
ARPCLS.PRG Close Period
TOSLIST.PRG Toolbox File List
TOLIST.PRG List and Select Based on Data Dictionary
FORMS
TOSLMRD.*
PROGRAMS
ARPOST.PRG Create Invoice
SYSCADD.PRG Add a new Customer
SYSCDSP.PRG Display Customer Record
SYSCSRN.PRG Customer Maintenance Screen
ARRECR.PRG Add/Change/Delete Recurring Billings
TOCRE1.PRG Create Databases for a module
SYSIADD.PRG Add Inventory Item
SYSIADJ.PRG Inventory Adjustment
SYSINVT.PRG Maintain Inventory Record
SYSISRN.PRG Inventory Maintenance Screen
SYSREPA.PRG Add new Sales People
SYSREPM.PRG Maintain Sales People
TODBCK.PRG Build/Update Fields for Database Files
ARCREA.PRG Set Up File Variables and Delete/Check Data Files
SOPOSE.PRG Revise Current SO
P0SPLIT.PRG Commission Structure
SOPREC.PRG Generate Recurring SO's
POMENU.PRG Main Menu
ARPOSD.PRG Enter Invoice Detail
SYSCUST.PRG Customer Maintenance
FORMS
TOSLCDU.* Commissions Due Report
PROGRAMS
TOMSELT.PRG Selection Program
TOPSALE.PRG Calculate and post commissions
ARSLREC.PRG Update the Sales Person File
P0COMCHK.PRG Commission Rate Determination
POCREA.PRG Create/Check/Delete Data Files
TOMNBR.PRG Custom Bar Menu
TOMNU9.PRG Extension Menu
TOMNB9.PRG Extension Menu
ARCASR.PRG Cash Receipt Entry
ARMANE.PRG AR Invoice Header Maintenance
SOPASS.PRG Password Maintenance
SCUPDATE.PRG One Time update to add sales people
SOPOST.PRG Create Sales Order
SORECR.PRG Recurring SO Maintenance
SOSHPP.PRG Sales Order Shipping
FORMS
TOSLREP.* Salesperson Report

Database Changes

ARSLINnn.DBF

Salesperson Invoices

Tags:

INVNO Key: invno + salesmn

SALESMN Key: salesmn + invno

Name TYPE WID DEC DESCRIPTION

ARSLMNnn.DBF

Salesperson Master File

Tags:

SALESMN Key: salesmn

Name TYPE WID DEC DESCRIPTION

ARSLRTnn.DBF

Salesperson Class Rate File

Tags:

Name TYPE WID DEC DESCRIPTION

ARYTRNnn.DBF

Year-To-Date Invoice Transaction File

Tags:

Name TYPE WID DEC DESCRIPTION

ARMASTnn.DBF

Current Invetory Master File

Tags:

Name TYPE WID DEC DESCRIPTION

ARINVTnn.DBF

Inventory Master File

Tags:

Name TYPE WID DEC DESCRIPTION

ARRECRnn.DBF

Recurring Billing Master File

Tags:

Name TYPE WID DEC DESCRIPTION

ARCUSTnn.DBF

Customer Master File

Tags:

Name TYPE WID DEC DESCRIPTION

ARSLHCnn.DBF

Salesperson Commission History File

Tags:

SALESMN Key: salesmn

Name TYPE WID DEC DESCRIPTION

ARSLHSnn.DBF

Salesperson Sales History File

Tags:

SALESMN Key: salesmn

Name TYPE WID DEC DESCRIPTION
SLS16 N 9 0 Sales for 16 period prior

ARTRANnn.DBF

Invoice Transaction File

Tags:

Name TYPE WID DEC DESCRIPTION

ARSNOTnn.DBF

Salesman Note File

Tags:

Name TYPE WID DEC DESCRIPTION

ARYMSTnn.DBF

Year-To-Date Invoice Master File

Tags:

Name TYPE WID DEC DESCRIPTION

SOTRANnn.DBF

Sales Order Transaction File

Tags:

Name TYPE WID DEC DESCRIPTION

SOYTRNnn.DBF

Year-to-Date Transaction File

Tags:

Name TYPE WID DEC DESCRIPTION

SOMASTnn.DBF

Sales Order Master File

Tags:

Name TYPE WID DEC DESCRIPTION

SOYMSTnn.DBF

Year-to-Date Master File

Tags:

Name TYPE WID DEC DESCRIPTION

SORECRnn.DBF

Recurring Sales Order File

Tags:

Name TYPE WID DEC DESCRIPTION

SYSPIKnn.DBF

Browse Assistance Database

Tags:

Name TYPE WID DEC DESCRIPTION

 



Integrated Business Solutions
P:619-462-7797
F:619-462-7698
4177 Yale Avenue - La Mesa, CA 91941-7717
www.ibsweb.com