SytelineMaster

It is very often that you need to get current date/time in your development.

T-SQL

To get today date without time as string variable use following script:

Select CONVERT( CHAR(8), GetDate(), 112)

To get datetime variable of today date without time use following script:

Select CAST( CONVERT( CHAR(8), GetDate(), 112) AS DATETIME)

VB

System.DateTime.Now.ToString(“yyyyMMddhhmmss”)

Now()

To initiate a date field as today’s date in Syteline form, need to use CURDATE().

Problem:

Many business would not allow product shipped to a “PO Box” address.  So would like to block any “PO Box” address being entered into any ship to address.

Solution:

1)      Enter design mode of “Customer Ship Tos” Form.

2)      We are going to first create a script.  Go to “Menu -> Edit -> Script”, a Script window should open.  Click “New”, enter Script Name called “NoPOBox”, then click OK.

Put in the following script:

Option Explicit On

Option Strict On

Imports System

Imports Microsoft.VisualBasic

Imports Mongoose.IDO.Protocol

Imports Mongoose.Scripting

Namespace SyteLine.GlobalScripts

Public class NoPOBox

Inherits GlobalScript

Sub Main()

Dim strValue As String

Dim logicYN as boolean

Dim logicYN1 as boolean

Dim logicYN2 as boolean

Dim logicYN3 as boolean

Dim logicYN4 as boolean

strValue = GetParameter(0).ToUpper()

logicYN = strValue like “*PO BOX*”

logicYN1 = strValue like “*P.O BOX*”

logicYN2 = strValue like “*P.O.BOX*”

logicYN3 = strValue like “*PO. BOX*”

logicYN4 = strValue like “*P.O. BOX*”

If logicYN or logicYN1 or logicYN2 or logicYN3 or logicYN4

ReturnValue = “1”

else

ReturnValue = “0”

end if

End Sub

End Class

End Namespace

Then “OK” to save the Script, and “Done” to close the Script window.

3)      Create a Validator.

While we are still in the design mode of “Ship Tos” Form, from menu, go to “Edit -> Validator”.  A “Validator” window open, click “New”.  In the “Validator Properties” window, enter “NoPOBox” as name, “Run Script” as type.  Select “NoPOBox” as script name from the pull-down list, that is the script we just created in step 2).

Then, create Error Message: “PO Box Is Not Valid Address”.

Click OK all the way back, we now have created a validator called “NoPOBox”, and we can apply it to the fields that we want to validate.

4)      Apply validator

Click to enter PV(Addr_1), that means property value of Addr_1, as parameters.

5) Now save the change and exit out of design mode, we should be able to see the validation is working:

Syteline system cut over will be the biggest milestone of your implementation project.  Careful planning would be essential to your project success.

Section A – Initial Setup

Section B – General Ledger Setup

Section C – General Financial Setup

Section D – Accounts Payable Setup

Section E – Accounts Receivable Setup

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Backup Database before entering Section F (note Parameter forms can be entered, no master data just static data)

Section F – Inventory Setup

Section G – Purchasing Setup

Section H – Sales/Order Entry Setup

Section I – Manufacturing Setup

Section J – Human Resources / Payroll Setup

K – Beginning Balances

L –Action Items

The “Query” function in Syteline allows you to use multiple selection criteria to query transaction.  The example below show you how to query manual transactions for inventory account in a given date range.

Open the “GL posted transaction query” form.

Click “Additional Criteria” tab.

In the first pull down list, select “Account”.  In second pull down list, select “=”.  Put in an account#, or select from pull down list in the last field, then click the “Add” button.

Select “Posted from”, let it “=” to General.  That means we will only select transactions that is posted from “General Journal”, instead of normal inventory transactions that are posted from “IC Journal”.  Then click the “Add” button.

Repeat the similar process for “Transaction date”, to give a date range.  Once finished entering all the criteria, click the “Refesh” button.  Transaction data should shows up.

Right click on left-upper corner of the grid, from the menu, select “To Excel”, you will then be able to export the data to Excel.

The similar query process will work on all the “Query” form.

The Definition of Procedures

Procedures represent the documentation of business process.  Their purpose is to document all business processes, strategies, and principles and their related information.  In terms of ISO 9000, procedures represent the Level B/Tier 2 of the Quality System.  Procedures should be written in a detailed manner.  They should cover the ‘5 – Ws’, what, where, when, why, and who.  A common rule of content to adopt is 90% specific and 10% general.

Getting Started

Getting organized to begin the process of procedure writing requires several administration steps.  The first step is to determine what kind of procedure system do you require.  This can be determined by reviewing your current procedure situation.

• Do procedures exist?
• Are these procedures current?
• Is there a common procedure?
• Are or will the current procedures required for a regulatory certification?
• Review current situation
• Determine required control
• Pick a procedure format
• Start a procedure log
• Educate procedure writers

Getting Started

The answers to these questions will assist in determining the level of control required manage your procedures.

The next steps are to select the proper procedure format for your system and develop a procedure log to establish procedure requirements. There is no one standard procedure format.  Selecting a procedure format is a matter of reviewing possible styles and selecting the one suited best to meet your requirements.  If a certification, like ISO 9000, is factor a specific procedure format or content may be required.  . Check with you registrar for recommendations.  Establishing a procedure log through the course of the implementation will allow written procedures to be documented and tracked.  Establishing this log prior to the business pilot will allow you to determine the scope of procedure writing required for your implementation.  Some of the most common elements of a procedure log are procedure numbers, titles, revision level, functional area, person responsible, approval responsibilities, and related dates.

Once the procedure system and format have been established, the next step is to select and educate procedure writers.  Often the best people to write the procedures are the ones responsible for the tasks.  The selected procedure writers should be given proper education on what is expected and to review the selected procedure format and content.  Practicing flowcharting business processes is an excellent way to begin the process and to develop proper technique.  Flowcharting helps to understand the level required and where additional or smaller procedures are needed.  After completing the flowchart, the procedures can then be easily written in the specified format or in a draft fashion for a clerical person to input for review.  The final step is to review, approve, and distribute the finished procedures.

Procedure for writing a procedure

1.0 Purpose

1.01     The purpose of this procedure is to detail the requirements necessary                  in documenting a procedure

2.0 Scope

2.01     All procedures must be prepared on standard format paper.

2.02     All procedures must have as a minimum the following:

• title
• procedure number
• issue number
• date
• page number
• purpose
• scope
• responsibility
• definition
• procedure itself
• references

2.03     The decision, as to whether or not a written procedure is necessary,                          should be taken on the basis that if the absence of such a procedure                                could adversely affect the quality of work being performed, then a                          procedure is necessary.

2.04     The language used in a procedure should be specific enough to avoid                 ambiguity and general enough to ensure it is practical.

2.05     Documentation Control controls the issue of the procedure numbers                               and the procedure log.

3.0 Responsibility

3.01     Primary responsibility for the adherence to the requirements of this                           procedure shall rest with the originator, with contributing                                          responsibility from the appropriate Function Head.

4.0 Definitions

4.01     Function Head.

The Function Head is defined as the manager for the area in which                                the procedure will be performed.

4.02     Originator.

The preparation and writing of a procedure shall be undertaken by                          personnel familiar with the function to be controlled.  The person(s)                                so defined shall be the originator of the procedure.

4.03     Controlled Document.

Authorized copies of procedures, which are produced on the colored                 pro-forma paper, shall be classified as controlled documents.

Authorized copies of procedures, which are not on colored pre-                          printed paper, shall be classified as uncontrolled documents, i.e.                                 photocopies.

5.0 Procedure

5.01     The Originator will prepare a draft procedure.

5.02     The Originator will then forward the draft procedure to all                                        departments affected by the procedure for their comments.

5.03     Departments are normally given two weeks to respond with their                             comments.  (Originators should specify in a covering memo, the                          deadline for comments and circulation list.)

5.04     Comments are taken into account and the procedure modified if                               necessary.  The Project Leader will arbitrate on any disagreements.

5.05     The Originator signs and dates the document under the Approval                            Section.

5.06     Document Control issues official copies of the procedure.

6.0 Reference Documents

6.01     The references shall identify all procedures, operating instruction,                                   and documents referred to within the procedure, which are not part                                of the procedure itself.

Sample Procedure Format

1.0 Purpose

Objective of the procedure.

2.0 Scope

To what activities the procedure applies.

3.0 Responsibility

Who is responsible for implementation?

4.0 Definitions

Terms or words not readily understood.

5.0 Procedure

Step by step instructions of each activity stating:

• What is done?
• By whom?
• When, where, and possibly why?

6.0 Reference Documents

Any other documents or referred to activities.

CRP – INVENTORY CONTROL

• Set up parameter files
• Determine item structure for Item Master.  Determine what will be inventory items and non-inventory items.
• Determine structure for Product Codes/Distribution Accounts.
• Set up master files
  • Item Master
    • Purchasing information
    • Manufacturing information
    • Costing information
    • Engineering information
    • Sales information
  • Product Codes/Distribution Accounts
  • Warehouse Master
  • Stock Locations
    • Nettable/non-nettable
    • Temporary/permanent
  • Reason Codes for miscellaneous inventory transactions
  • Set up Customer/Item and Vendor/Item Cross References
  • Determine valid item/stockroom locations for each inventory item & ranking
  • Determine use of lot tracking and/or serial tracking
  • Determine use of item reservations
    • Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements:
      • Item maintenance, including BOMs
      • Product Code/Distribution Accounts maintenance
      • Warehouse orders and transfers
      • Use of miscellaneous inventory transactions
      • Cycle count
      • Physical inventory
      • Periodic procedures and utilities
        • Rebalance utilities
        • Cost roll-ups
        • Roll current unit cost to standard unit cost
        • Delete transactions/locations/lots/serial numbers
        • Set item PTD and YTD totals to zero
• Determine reports and/or documentation to be used for all procedures – SyteLine and internal
• Establish guidelines for retention of documents and reports – printing hard copies or printing to the terminal

CRP – BOM

• Set up master files
  • Work Centers – scheduling & costing information
  • Machine Master
  • Maintenance schedules
  • Cells
  • Create current routings and bills of material for manufactured items
  • Perform BOM utilities to create standard routing/BOM
    • Low Level Processor
    • BOM Cost Roll-up
    • Roll Current Unit Cost to Standard Unit Cost
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements:
  • BOM maintenance
  • Periodic procedures and utilities
    • Cost roll-ups
    • Roll current unit cost to standard unit cost
    • Delete utilities
    • Substitutions
• Determine reports and/or documentation to be used for all procedures – SyteLine and internal
• Establish guidelines for retention of documents and reports – printing hard copies or printing to the terminal

CRP – ENGINEERING CHANGE NOTICES

• Set up codes
  • Priority Codes
  • Reason Codes
  • Distribution Codes
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements:
  • Use of Engineering Change Notices for items, estimates, and/or jobs
    • Guidelines for use
    • Requests
    • Flow of documentation through system
    • Changes to
    • Revision tracking
    • Approval
• Determine reports and/or documentation to be used for all procedures – SyteLine and internal
• Establish guidelines for retention of documents and reports – printing hard copies or printing to the terminal

CRP – ORDER ENTRY

• Set up parameter files
• Set up master files, creating examples of each possible type of record or situation that may occur
  • Customer Master
  • Ship-To Addresses
  • Salesperson Master
  • Billing Terms
  • Ship Via Codes
  • Shipping Return Reason Codes
  • Customer Hold Reason Codes
  • Set up Customer/Item cross-references
  • Determine use of Drop Ship To’s
  • Tax codes
    • Determine requirements for reporting on sales tax collected
    • Establish required tax codes
    • Establish procedures for assessing sales tax on orders
    • Pricing
      • Review requirements
      • Establish pricing by some combination of available methods
      • Determine procedures for price changes
      • Determine procedures for exceptions to existing pricing
      • Determine procedures for new item pricing and/or modifications to items
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
  • Customer Order Entry – steps
    • Create order
    • Print Order Verification
    • Verify on-hand, available to ship
    • Print Order Pick List
    • Ship items
    • Print Packing Slip
    • Print Bill of Lading
    • Invoice order
    • Close order after invoicing
  • Customer Order Entry – types of orders to consider
    • Regular/blanket in stock
    • Regular/blanket manufacture to order
    • Regular/blanket conversions
    • Regular/blanket spare parts
    • Regular/blanket services
    • Other

CRP – ORDER ENTRY (contd.)

• Changes to existing orders
• Managing back orders – completing/not completing
• Expediting orders
• Progressive billing – use and management
• Stopping/re-releasing orders
• Order cancellations
• Shipping return procedures
  • Use of RMAs to manage
  • Flow of documentation through the system
  • Notification to shipping department and customer service/accounting          for credit to customer
  • Perform shipping return
  • Inspection of returned goods and return/not return to inventory
  • Generation and control of credit memos
  • Un-ship (prior to invoicing)
  • Use of credit holds and credit limits
    • Compliance and exceptions
    • Changes to credit limit
  • Order Inquiry handling by customer service
  • Reserving inventory for orders
  • Adjustments to price after invoicing
  • Commissions
    • Use of SyteLine commission structure or external
    • Management of calculation
    • Adjustments to
    • Payment through AP or Payroll
  • Routine utilities and procedures
    • Closing orders
    • Purge Customer Order Audit Trail
    • Rebalance Customer Order/Posted Balance
    • Balance History
    • Period/Year end Procedures
    • Delete and purge transactions
• Determine reports and/or documentation to be used at each step – SyteLine and internal
• Establish guidelines for retention of documents and reports – printing hard copies or printing to the terminal

CRP – PURCHASING

• Set up parameter files
• Set up master files, creating examples of each possible type of record or situation that may occur
  • Vendor Master and remit to vendors
  • Billing Terms
  • Ship Via Codes
  • Drop Ship To’s
  • Receiving Return Reason Codes
  • Set up Vendor/Item cross-references
  • Determine use of Drop Ship To’s
    • Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
      • Purchase Requisitions – if and for what items
      • Purchase Order Entry – steps
        • Create purchase order
        • Verify cost
        • Print Purchase Order
        • Print purchasing Receiving List
        • Receive items
        • Close order after vouchering (AP)
  • Purchase Order Entry – types to consider
    • Regular/blanket for inventory stock items
    • Regular/blanket for non-inventory items
    • Regular/blanket Customer Orders – cross-reference or not
    • Regular for Job Orders – cross-reference or not
    • Regular for inter-company purchases
  • Lot/serial controls on purchases
  • Expediting Purchase Orders
  • Canceling Purchase Orders
  • Managing back orders – completing/not completing
  • Receiving returns
    • Use of RMAs to manage
    • Flow of documentation through the system
      • Notification to receiving department and accounting for credit from vendor
    • Perform receiving return
  • Un-receive (prior to vouchering)
  • Use of PO Change Orders
    • Determine use of Vendor Communications Log

CRP – PURCHASING (contd.)

• Routine utilities and procedures
  • Closing Purchase Orders
  • Closing Change Orders
    • Review and update Purchased Current Unit Cost if vouchered cost does not equal received cost
    • Purge Purchase Order Audit Trail
    • Rebalance items
    • Delete utilities
    • Determine reports and documentation to be used – SyteLine and internal
      • Determine how purchasing requirements will be determined – Purchase Requirements Report or MRP
      • Determine if tax codes are to be used for purchasing
        • Establish tax codes as required
        • Establish procedures for assessing use tax
        • Determine reporting requirements for use tax on purchases

CRP – ACCOUNTS PAYABLE

• Set up parameter files
• Set up master files, creating examples of each possible type of record or situation that may occur
  • Vendor Master and remit to vendors
  • Salesperson Master
  • Billing Terms
  • Ship Via Codes
  • State Master
  • Vendor Payment Hold Reason Codes
  • Bank Codes
  • Set up Vendor/Item Cross-references
  • Establish tax codes as required
    • Establish procedures for assessing use tax
    • Determine reporting requirements for use tax on purchases
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
  • Vouchering
    • From purchasing
    • Manually through Vouchers & Adjustments
    • Generating recurring vouchers
    • Distributing manual and recurring vouchers
  • Voucher Adjustments
    • From purchasing returns
    • Manually through Vouchers & Adjustments
    • Distributing voucher adjustments
  • Payment processing
    • Manual check posting
    • Generation of standard checks
    • Manual addition of standard checks
    • Selection of check distributions
    • Check printing and posting
  • Void checks prior to posting and after posting
  • Putting vendors and/or vouchers on hold
  • Use of Vendor Communications Log
  • Routine utilities and procedures
    • Year end procedure
    • Delete transactions
    • Deactivate posted transactions
    • Generate currency gains/losses
    • Purge Vendor Master Audit Trail

CRP – ACCOUNTS PAYABLE (contd.)

• Determine reports and documentation to be used – SyteLine and internal
  • Establish procedures for retention of documents and reports – printing hard copies or printing to the terminal

Accounts Payable Cut-Over Procedures:

• Order checks
• Set up recurring vouchers
• Enter all AP open vouchers at cut-over date into Vouchers & Adjustments (this includes those items vouchered in the existing system – i.e. already recorded in general ledger on the existing system)
• Enter all AP open payments, if any, such as an un-applied deposit on a vendor’s account at cut-over date into Payments
• Post Vouchers & Adjustments and Payments files to AP Distribution Journal
• Purge AP Dist. of all transactions
• Print AP Aging.  Verify vendor balances to AP Aging on existing system.
• Enter outstanding checks into Bank Reconciliation file

CRP – ACCOUNTS RECEIVABLE

• Set up parameter files
• Set up master files, creating examples of each possible type of record or situation that may occur
  • Customer Master
  • Ship-To Addresses
  • Salesperson Master
  • Billing Terms
  • Ship Via Codes
  • Bank Codes
  • Establish tax codes as required
    • Determine requirements for reporting on sales tax collected
    • Establish procedures for assessing sales tax on orders
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
  • Invoices, debit memos, and credit memos
    • Generate from Order Entry
    • Price Adjustments generated in Order Entry
    • Create and print from Accounts Receivable
      • Uses for AR invoices, debits, and credits
      • Distributing AR invoices, debits, and credits
    • Invoice posting
    • Transactions review
  • Payments
    • Distributions to invoices
    • Prepayments tied to Customer Orders
    • Open payments
    • Non-AR payments
    • Payment posting
    • Re-application of open payments
    • Re-application of open credits and debits
  • Add bank deposits to Bank Reconciliation file
  • Process finance charges
  • Review posted transactions for open transactions
  • Collections, statements, dunning letters
  • Use of Customer Communications Log

CRP – ACCOUNTS RECEIVABLE (contd.)

• Routine utilities and procedures
  • Rebalance Customer Order/Posted Balance
  • Balance History
  • Period/Year end Procedures
  • Delete and purge transactions
  • Deactivate Posted Transactions
  • Purge Customer Audit Trail
  • Generate Currency Gains/Losses
  • Determine reports and/or documentation to be used – SyteLine and internal
    • Establish procedures for retention of documents and reports – printing hard copies or printing to the terminal

Accounts Receivable Cut-Over Procedures:

• Order invoices and statements
• Enter all AR open invoices at cut-over date into Invoices, Debits, & Credits screen (this includes those items invoiced in the existing system – i.e. already recorded in general ledger on the existing system)
• Enter all AR open payments, if any, such as an un-applied deposit on a customer’s account at cut-over date into Payments
• Post Invoices, Debits & Credits and Payments files to AR Distribution Journal
• Purge AR Dist. of all transactions
• Print AR Aging.  Verify customer balances to AR Aging on existing system.
• Enter deposits in transit into Bank Reconciliation file

CRP – GENERAL LEDGER

• Establish Chart of Accounts
• Set up parameter files
• Determine financial reporting requirements
• Determine use of Budgets and Plans
• Set up accounting periods
  • Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
    • Posting journals
    • Standard entries and recurring journals for those entries
    • Correcting journal entries
    • Creation and generation of financial statements
    • Using Bank Reconciliation
    • Periodic procedures and utilities
      • Updating accounting period
      • Maintaining budgets and plans
      • Maintaining chart of accounts
      • Year-end closing
  • Account analysis
  • Determine reports and/or documentation to be used – SyteLine and internal
    • Establish procedures for retention of documents and reports – printing hard copies or printing to the terminal

General Ledger Cut-Over Procedures:

• Enter accounting periods for current year and other years, as applicable
• Enter net monthly GL account balances into a Balances journal for the current YTD and prior year, if applicable (this includes those items posted in the existing system – i.e. already recorded in general ledger on the existing system)
• Load budgets and plans
• Post Balances journal
• Reconcile posted GL balances to current system

CRP – PRODUCTION PLANNING/CONTROL

• Set up parameter files
• Set up master files
  • Shop Calendars
  • Holidays
  • Employees
• Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
  • Determine how manufacturing requirements will be determined – Purchase Requirements Report or MRP
  • Job cycle – steps
    • Create job and copy item routing/BOM
    • Modify job routing/BOM
    • Release job
    • Job paperwork and dispatch list
    • Post transactions through backflushing or transaction entry
    • Lot controlled items on jobs
    • Job analysis
    • Close job
    • Lot/serial tracking finished goods
  • Job cycle – types
    • Manufacture to stock
    • Manufacture cross-referenced to Customer Order
  • Production schedule cycle – steps
    • Create production schedule and copy item routing/BOM
    • Modify PS routing/BOM
    • Set up PS releases
    • Paperwork and dispatch
    • Issue material to floorstock locations as appropriate
    • Report production to work centers
    • Report complete production
    • Run end of period costing procedure
    • Review variances
  • Modifying job/production schedule routing/BOM
  • Determine use of backflushing and/or manual reporting
  • Cross-referencing Purchase Orders
  • Job splitting
  • Job merging
  • Stopping  jobs/production schedules
  • Canceling jobs/production schedules

CRP – SCHEDULING/CAPACITY PLANNING

• Set up parameter files
• Set up master files
  • Departments
  • Shop Calendars
  • Holidays
  • Work Centers – Scheduling & Costing
  • Cells
  • Machine
  • Machine Maintenance
  • Determine scheduling methods – finite/infinite, backward/forward, move, queue
  • Determine scheduling method for each Work Center
  • Determine how to use scheduling priorities
    • Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
      • Use outputs to review Work Center capacity
        • Analyze job schedules and production schedules in terms of load on Work Center capacity
  • Use global priority setting and scheduling methods
  • Use individual priority setting and scheduling methods

CRP – COSTING

• Determine costing method(s) to be used
• Set up parameter files
  • Procedures to be considered and tested, including how-to, responsibility, frequency, reporting requirements
    • Determine cost type & method by item
    • Overhead rates
      • Basis – material, labor, machine
      • Valuation
      • Changes
      • Routine evaluation
  • Work Center costing
    • Labor and machine rates
    • Efficiency
    • Crew size
    • Period based accounts setup
    • Changes at Work Center
    • Changes to Job/Production Schedule routing
    • Routine evaluation
  • Employee Labor Rates
    • Valuation determination
    • Changes
    • Routine evaluation
  • Determine Current Unit Cost for purchased and manufactured items
  • Roll Current Unit Cost to Standard Unit Cost for standard cost items
  • Costing method changes to existing items, new items
  • Item cost reviews (cost comparison)
  • Product Code account determinations
  • Maintenance of BOM costs
    • Review of and utilities to update
    • Scrap factor determination
  • Purchase costing review
    • Differences in Purchase Order Plan Cost and Item Cost
    • Update of Purchased Current Unit Cost for vouchered cost
    • Freight cost analysis
  • Capitalization of landed costs
  • Job cost analysis
  • Period based costing analysis
  • Review of material transactions

CRP – COSTING (contd.)

• Review of journal entries
  • Purchasing variances
  • Non-inventory item costs
  • Job costing variances
  • Period based costing variances
  • Sales and cost of sales
  • General Ledger analysis
    • Budget vs. Actual
    • Current vs. Prior Year
    • Departments

CRP – MRP

• MRP Logic – methodology
• Forecasting – data requirements
• MPS – schedule, controls
• Rough Cut Capacity Planning – capabilities, process
• MRP Detail Information – ownership
• MRP “Firm” Planned Orders – process, paperwork
• Exception Messages – priority, control, paperwork
• Regeneration vs. Net Change – when, how, who

Payroll Generation: pr/pr-trxg.p, main logic in pr/pr-trxg1.p

Payroll record prlog can be generated from 4 differ sources:

1. Manufacturing transaction jobtran.  The Generate Payroll From field on the Employee Master must also be set to M. The summarized transactions include: WC Labor, WC Machine Time and Job Labor.  prlog.posted-from = “M”.
2. Manufacturing Project transaction projtran.  The Generate Payroll From field on the Employee Master must also be set to M.  prlog.posted-from = “M”.
3. Time and Attendance record timeatt.  The PR From field must also be set to T. Total Hours are calculated on the time between clock-in and clock-out with all break times subtracted out. After each time & attendance transaction is summed to the Payroll Transaction record, the time & attendance transaction status is changed from Unposted to Posted.  prlog.posted-from = “T”.
4. Attendance transaction prhrs.  When the reason code is set to Vacation, Holiday, or Sick, the record is treated as if it were the Vacation, Holiday, or Sick record entered into the Payroll Hours file.  prlog.posted-from = “P”.  Noted that prhrs record got deleted after the process (prlog created.)
5. empabsence.  prlog.posted-from = “X”. 
   

Pay Rate calculation.   pr/calcrate.p

Example:        run pr/calcrate.p (recid(employee), prlog.hr-type, true,
prlog.shift, prlog.work-date, FALSE, OUTPUT prlog.pay-rate).

The table contains MPS is rcpts with the ref-type = “M”.  rcpts also contain other records that generated by MRP.  To remove any MPS demand, remove rcpts records with ref-type = “M”.