Archive

Archive for the ‘Application’ Category

Material Transaction Type

March 4th, 2007 No comments
TRANS TYPE REF TYPE QUANTITY TRAN LOCATION MATL TRAN CODE DESCRIPTION

A

_

=0

_

AC

COST ADJUSTMENT

A

_

<>0

_

A

STOCK ADJUST

B

_

_

_

B

CYCLE COUNT

C

_

<0

<> ” “

CS

JOB SPLIT

C

_

> OR = 0

<> ” “

CM

JOB MERGE

C

K

_

= ” “

CA

JIT WIP CREATE

C

S

_

= ” “

CB

PS WIP CREATE

C

<> K,S

_

= ” “

C

JOB WIP CREATE

D

_

<0

_

DA

PS SCRAP RETURN

D

_

> OR = 0

_

DS

PS SCRAP ISSUE

F

K

_

_

FK

JIT FINISH

F

S

_

_

FS

PS FINISH

F

<> K,S

_

_

F

JOB FINISH

G

_

_

_

G

MISC ISSUE

H

_

_

_

H

MISC RECEIPT

I

K

=0

_

CK

JIT WIP CHANGE

I

K

<>0

_

IK

JIT ISSUE

I

S

0

_

CP

PS WIP CHANGE

I

S

<>0

_

IS

PS ISSUE

I

W

_

_

IW

WC MATL ISSUE

I

<> K,S,W

=0

_

CF

JOB WIP CHANGE

I

<>K,S,W

<>0

_

I

JOB ISSUE

L

_

_

_

L

TRANSFER LOSS

M

_

>0

_

MT

STOCK MOVE TO

M

_

< OR = 0

_

M

STOCK MOVE FROM*

N

K

=0

_

NK

JIT LABOR

N

K

<>0

_

NA

JIT NEXT OPER

N

S

=0

_

NS

PS LABOR

N

S

<>0

_

NB

PS NEXT OPER

N

W

_

_

NW

WC LABOR

N

<>K,S,W

=0

_

NL

JOB LABOR

N

<>K,S,W

<>0

_

N

JOB NEXT OPER

O

W

_

_

OW

WC OTHER COST

O

<>W

_

_

O

JOB OTHER COST

P

_

_

_

P

PHYSICAL INVENT

R

K

_

_

RK

JIT RECEIPT

R

S

_

_

RS

PS RECEIPT

R

<>K,S

<0

_

RA

PO RECEIPT ADJUST

R

<>K,S

> OR = 0

_

R

PO RECEIPT

S

_

>0

_

SA

CO SHIP ADJ

S

O

< OR = 0

_

S

CO SHIP

T

_

>0

_

TT

TRANSFER TO

T

_

< OR = 0

_

T

TRANSFER FROM

W

J

_

_

W

JOB WITHDRAWAL

W

K

_

_

WK

JIT RETURN

W

O

>0

_

WC

CO RETURN

W

O

< OR = 0

_

WA

CO RETURN ADJUST

W

P

<0

_

WR

PO RETURN ADJ

W

P

> OR = 0

_

WP

PO RETURN

W

S

_

_

WS

PS RETURN

W

R

_

_

WM

RMA RETURN

W

W

_

_

WW

WC MATL RETURN
REF TYPE LISTING

I

INVENTORY

J

JOB TRANSACTION

K

JIT PRODUCTION TRANSACTION

O

CUSTOMER ORDER

P

PURCHASE ORDER

R

RETURN MATERIAL AUTHORIZATION (RMA)

S

PRODUCTION SCHEDULE TRANSACTION

T

TRANSFER

W

WORK CENTER TRANSACTION

GENERAL LEDGER ACCOUNTING REFERENCES

March 1st, 2007 No comments

Accounts Payable Distribution Journal

AP Compressed AP Journal Transactions

Occurs at data entry, before posting the AP journal to the GL while stating

Yes to compress journal before posting.

APA # Adjustment Transaction and Voucher Number

Occurs at data entry, before posting an adjustment to a vendor Invoice in

the AP program Enter Vouchers and Adjustments.

APP # Payment Transaction and vendor Number

Occurs at data entry, before posting an AP check that has been printed for Standard

payments or entered for Manual payments in the AP program Payments.

APRV # Recurring Voucher Transaction and Voucher Number

Occurs at data entry, before posting a recurring voucher from the Recurring Voucher

program to the Enter Vouchers and Adjustments program and the posting this file.

APV # Voucher Transaction and Voucher Number

Occurs at data entry, before posting a voucher to a specific vendor in the AP program

Enter Vouchers and Adjustments.

APX Multi-Currency Gain/Loss Transaction

Occurs when:

(1) The system has been setup for multi-currency in the system parameters program.

  1. The Generate Currency Gains and Losses program has been performed using

Payables as the Accounts to Process option.

  1. There have been different buying rates used for the specified currencies as found

in the accounting utilities menu.

Accounts Receivable Distribution Journal

AR Compressed AR Journal Transactions

Occurs at data entry, before posting the AR journal to the GL while stating Yes to Compress journal before posting.

ARC # Credit Memo Transaction and Invoice Number

Occurs at data entry, before posting a Credit Memo to a Customer’s Invoice in the AR program Invoices, Debit and Credit Memos.

ARC FIN CHG Credit Memo to Finance Charge Transaction

Occurs at data entry, before posting a Credit Memo to a previously created finance charge in the AR program Invoices, Debit, and Credit Memos.

ARC OPEN Open Credit Memo Transaction

Occurs at data entry, before posting a Credit Memo as open to a Customer in the AR program Invoices, Debit, and Credit Memos.

ARD # Debit Memo Transaction and Invoice Number

Occurs at data entry, before posting a debit memo to a previously created Invoice in the AR program Invoices, Debit, and Credit Memos.

ARD FIN CHG Debit Memo to Finance Charge Transaction

Occurs at data entry, before posting a debit memo and open to a Customer in the AR program Invoices, Debit, and Credit Memos.

ARD OPEN Open Debit Memo Transaction

Occurs at data entry, before posting a debit memo as open to a Customer in the AR program Invoices, Debit, and Credit Memos.

ARI # Invoice Transaction and Invoice Number

Occurs at data entry, before posting an Invoice to a Customer in the AR program Finance Charges.

Occurs when generating, then posting, a finance charge against a past due paying Customer in the AR program Finance Charges.

ARP # Payment Transaction and Check Number

Occurs at data entry, before posting a Customer’s check in the AR program Payments.

ARX Multi-Currency Gain/Loss Transaction

Occurs when:

(1) The system has been setup for multi-currency in the system parameters program.

(2) The Generate Currency Gains and Losses program has been performed using Receivables as the accounts to process option.

(3) There have been different buying rates used for the specified currencies as found in the accounting utilities menu.

Bank Revaluation Distribution Journal

REVALUATION

ADJUSTMENT Multi-Currency Revaluation Transaction

Occurs when the Bank Revaluation Utility is performed and the result is a gain or

loss with a non-domestic customer or vendor.

Fixed Assets Distribution Journal

FA Compressed FA Journal Transaction

Occurs at data entry, before posting the FA journal to the GL while stating Yes to

Compress journal before posting.

FADEP # Depreciation Transaction and Asset Number

Occurs when depreciation of the assets has been generated, then posted, using the

FA program Post Depreciation.

FADSP # Asset Disposal Transaction and Asset Number

Occurs when an asset is disposed and subsequently posted in the FA program Dispose an Asset.

FAT # Asset Transfer Transaction and Asset Number

Occurs when an asset is transferred and subsequently posted in the FA program Transfer an Asset.

General Journal/User Defined Journal

Income

Summary GL Year End Closing Expense/Revenue Transaction

Occurs when the GL year end utility has been performed to net out the previous year’s revenues and expenses with the difference applied to the user defined retained earnings account. Each revenue and expense account will display this transaction type as found in the accounting utility menu as GL Year End Procedure.

Year

Closing GL Year End Closing Income Summary Transaction

Occurs when the GL year end utility has been performed which creates the prior year’s retained earnings as found in the accounting utility menu as GL Year End Procedure.

General Ledger

Date

Summary Compressed GL Transactions by Date

Occurs when the Compress GL Transactions program has been performed to compress GL transactions using the Date option as found in the accounting utilities program.

Period

Summary Compressed GL Transactions by Period

Occurs when the Compress GL Transactions program has been performed to compress GL transactions using the Period option as found in the accounting utilities menu.

Allocation

Summary Occurs when an account is set up as D type (Allocation) in the Chart of Accounts.

Payroll Distribution Journal

PR Compressed PR Journal Transactions

Occurs at data entry, before posting the payroll journal to the GL while stating Yes to Compress Journal Before Posting.

PR # PR Number

Occurs when payroll has been generated, checks printed, and posted as found in the payroll program Payroll Processing using Transaction Print/Post.

PR [DIST DATE]

Payroll Transaction and Date

Occurs when the payroll has been generated, checks printed and posted, as found in the payroll program Payroll Processing using Transaction Print/Post.

Customer Order Distribution Journal

CO Compressed CO Journal Transactions

Occurs at data entry, before posting the Order Entry journal to the GL while stating Yes to Compress Journal Before Posting.

INV CRT # Customer Order Return and Order/Line Number

Occurs when there has been a return against a previously shipped Customer Order in the Order Entry program Ship Transaction using the Manual Ship/Return option

INV CSH # Customer Order Shipment and Order/Line Number

Occurs when there has been a shipment against a Customer order in the order entry program Ship Transaction.

Inventory Control Distribution Journal

IC Compressed IC Journal Transactions

Occurs at data entry, before posting the INV journal to the GL while stating Yes to Compress journal before posting.

INV ACTC Inventory Update

Occurs when there has been an update or change to the inventory account used previously

to track the costs of the quantity on-hand to the GL. The change occurs in the inventory

program Stock Loc.

INV ADJ Inventory Adjustment

Occurs when there has been an adjustment to the quantity on-hand in the inventory program Adjust found in the Qty commands for Item stockroom locations.

INV CC-A Cycle Count Adjustment

Occurs when there is a different quantity entered in the Enter Cycle Count Qty versus the

cut-off quantity and then posted in the inventory cycle counting program Post Qty.

INV CHGM Change Item Cost Method

Occurs when the cost method in Item Maintenance has been changed which would revalue the inventory currently on-hand (i.e. from Specific to Average as found in Item Maintenance).

INV MISU Inventory Miscellaneous Issue

Occurs when there has been a miscellaneous issue from Inventory on-hand as found in the Inventory program Stock Loc using the Qty Commands for 1 Misc. Issue.

INV MOVE Inventory Move

Occurs when an Inventory quantity is moved from one location to another where the new location has a higher specific cost or has a different GL inventory account than the prior location as found in the Inventory program Stock Loc using the Qty Commands for Move.

INV MRCP Inventory Miscellaneous Receipt

Occurs when an inventory quantity is moved from one location to another where the new location has a higher specific cost or has a different GL inventory account than the prior location as found in the inventory program Stock Loc using the Qty Commands for Move.

INV PI-A Physical Inventory Adjustment

Occurs when the quantity posted in the physical inventory program is different from the quantity that was originally generated as found in the inventory utilities program Physical Inventory using the Financial/Inventory Posting.

INV SADJ Stack Adjustment

Occurs when the Manual LIFO/FIFO Adjustment utility has been run and has created a transaction to offset an incorrect entry of an issue or receipt.

INV STDC Inventory Roll Current to Standard Cost

Occurs when:

(1) The system has been set for standard costing in the system parameters.

(2) The inventory utility Roll Current cost to Standard Cost has been used to change the standard unit cost in Item Maintenance.

INV TADJ Multi-Warehouse Transfer Loss

Occurs when the inventory warehouse program Transfer Loss has been performed to enter a list or partially lost transfer order. Basically (qty shipped > qty received) as found in the inventory program Stock Loc using Transfers for Transfer Loss.

INV TMOV Multi-Warehouse Transfer between Warehouses

Occurs when performing a warehouse transfer of material where the GL account number of the new stocking location differs from the old stocking location as found in the inventory program Stock Loc using Transfers.

INV SMOV Multi-Site Transfer Order

Occurs when when your Site parameter “Posting Method” is set to “Intra-Entity”

INV DMOV Multi-Site Transfer Order

Here’s what I’ve figure out by looking at the code (I couldn’t find anything in the design document).

For either one of these references, you must be performing a Multi-Site Transfer Order (From Site not equal to To Site).

The journal transaction will appear in the To Site’s database.

The journal transaction is created at Receiving time when FOB Site = To Site.

The journal transaction is created at Shipping time when FOB Site = From Site.

The journal transaction will contain “INV SMOV”.

If it is set to “Inter-Entity”, then the reference will be “INV DMOV”.

Shop Floor Distribution Journal

SF Compressed SF Journal Transactions

Occurs at data entry, before posting the Shop Floor journal to the GL while stating Yes to Compress Journal Before Posting.

INV JADJ # Job BOM Cost Roll Up and Job Order Number

Occurs when an Item using specific cost method:

(1) has been Xref from a PO to a Job.

(2) has been received/issued to the Job.

(3) has the PO vouchered at a different cost than it was received.

(4) performs the Job Definition utility ‘Job BOM Cost Roll Up’ while changing the flag labeled ‘Update ‘P’ Ref Matl Actual Cost’ to ‘Yes’.

INV JBF # Job Order Back Flush and Job Order Number

Occurs when an Item has been flagged as Backflush Item: Yes on screen two, then entered as a Job BOM. The Material is automatically issued based on the quantity completed when the Operation or Job is shown as complete.

INV JCLS # Job Order Other WIP Variance and Job Order Number

Occurs when:

(1) The system has been set for standard costing in the system parameters.

(2) The Job in question has been completed.

(3) There has been variance between the standard cost and the actual cost found in the Job Definition program.

INV JFIN Job Order Finish and Job Order Number

Occurs when an Item has been partially completed on a Job and has been moved to Inventory without completing the Job found in the Job Definition program Job Transaction.

INV JFMO Order Fixed Material Overhead and Job Order Number

INV JMOV # Job Order Overhead Variance and Job Order Number

Occurs when:

(1) The system has been set for standard costing in the system parameters.

(2) The Item found in the Job BOM in which material overhead is being applied has had an update to the standard unit cost after the Job was created.

(3) The material is issued using the new standard cost found in the Job Definition program Material Transaction.

INV JMUV # Job Order Material Usage Variance and Job Order Number

Occurs when:

(1) The system has been set for standard costing in the system parameters.

(2) The material actually issued to the Job is greater or less than the standard quantity required.

(3) The Job in question has been completed as found in the Job Definition program.

INV JOB # Job Order Other Issue and Job Order Number

Occurs when an Item is issued to a Job that has a material type of Other as found in the Job Definition program Matl Transaction.

INV JOI# Job Order Material, Tool, Fixture, Issue, and Job Order Number

Occurs when an Item is issued to a Job that has a material type of Material, Fixture, Tool as found in the Job definition program, Material Transaction.

INV JOL # Job Order Labor and Job Order Number

Occurs when a Job labor transaction has been posted to a Job as found in the Job Definition program Job Transaction.

INV JRWK # Job Order Return for Rework and Job Order Number

Occurs when:

(1) The system has been set for actual costing in the system parameters.

(2) An Item that was previously produced and moved to Inventory is returned back to the originating Job through the Job Definition program Job Transaction.

INV JVMO # Job Order Variable Material Overhead and Job Order Number

Occurs when:

  1. The shop floor control parameter labeled Ovhd Basis has been either set to M (material).

(2) The Variable Material Ovhd Rate in the product code file has been set to a value > 0 for those Items found on a Job BOM.

(3) The BOM Items have been issued to the Job found in the Job Definition program Material Transaction.

INV JWIP # Job Order WIP Account Change and Job Order Number

Occurs when a Job order’s WIP account has been changed after costs have been posted to the Job found in the Job Definition program.

Project Control Distribution Journal

PRJ MTL Project Resource Transaction

Occurs when a Project Resource transaction is performed.

PRJ ADJ Project Adjustment Transaction

Occurs when an Adjustment transaction is performed.

PRJ LBR Project Labor Transaction

Occurs when a Project Labor transaction is performed.

JCLS PRJ Project’s Job Order Other WIP Variances

Occurs when a job is cross referenced to a project and is closed with WIP variances.

JFIN PRJ Project’s Job Order Finish

Occurs when a job is cross referenced to a project and an item has been partially completed on a job and has been moved to Inventory without completing the job found in the Job Definition program Job Transaction.

JOL PRJ Project’s Job Order Labor

Occurs when a job is cross referenced to a project and a job labor transaction has been posted to a job as found in the Job Definition program Job Transaction.

JOM PRJ Project’s Job Order Material

Occurs when a job is cross referenced to a project and a job material transaction has been posted to a job as found in the Job Definition program Job Transaction.

JMUV PRJ Project’s Job Order Material Usage Variances

Occurs when a job is cross referenced to a project; the system has been set for standard costing in the system parameters; the material actually issued to the job is greater than or less than the standard quantity required; and the job in question has been completed as found in the Job Definition program.

JFMO PRJ Project’s Job Order Fixed Material Overhead Variances

JVMO PRJ Project’s Job Order Variable Material Overhead Variances

Occurs when a job is cross referenced to a project; the shop floor control parameter labeled Ovhd Basis contains at least M (material); the Variable Matl Ovhd Rate in the product code file has been set to a value greater than zero for those items found on a Job BOM; and the BOM items have been issued to the job found in the Job Definition Program Matl Transaction.

Purchase Order Distribution Journal

PO Compressed PO Journal Transactions

Occurs at data entry, before posting the Purchasing journal to the GL while stating Yes to Compress Journal Before Posting.

INV P-CL # PO Status Change and PO/Line Number

Occurs when a Purchase Order Line Item or the entire Purchase Order is closed where there is a cost difference between what the received Line Item cost versus what it was originally billed within the vouchering process, as found in the Purchase Order programs Items.

INV PIV # PO Status Change and PO/Line Number

Occurs when a Purchase Order Line Item or the entire Purchase Order is closed where there is a cost difference between the received Line Item cost versus what it was originally billed within the vouchering process, as found in the Purchase Order program Items. Any previously existing journal references may display the reference INVP-CL#. All new transactions will use INV-PIV.

INV PNI # PO for Non-Inventory Item and PO/Line Number

Occurs when a non-inventory Item is received against a Purchase Order Line Item, as found in the Purchasing program Enter Receiving Transaction.

INV PRCV # PO Receipt and PO/Line Number

Occurs when an Inventory Item is received against a Purchase Order Line Item as found in the Purchasing program Enter Receiving.

INVPRTN # PO Return and PO/Line Number

Occurs when a previously received Inventory Item on a Purchase Order Line Item is returned, as found in the Purchasing program Enter Receiving Transaction.

Work Center Distribution Journal

WCM # Work Center Material

Occurs when Actual Materials are posted either when there is a manual issue via the Work Center Materials Transaction screen or when Backflushing occurs for a Production Schedule or JIT Production as a result of posting transactions the Production Schedule Quantity Transaction screen or JIT Transaction screen and this represents the component costs of material from Split WIP.

WCL # Work Center Labor

Occurs when Actual Materials Labor hours are posted either when here is a manual issue via the Work Center Labor Transaction screen or when Backflushing occurs for a Production Schedule or JIT Production as a result of posting transactions the Production Schedule Quantity Transaction screen or JIT Transaction screen or component costs of material from Split WIP.

WCFO # Work Center Fixed Overhead

Occurs when Material, Labor or Machine Fixed Overhead costs are posted either when here is a manual issue via the Work Center Labor Transaction screen or when Backflushing occurs for a Production Schedule or JIT Production as a result of posting transactions the Production Schedule Quantity Transaction screen or JIT Transaction screen or component costs of material from Split WIP.

WCVO # Work Center Variable Overhead

Occurs when Material, Labor or Machine Variable Overhead costs are posted either when here is a manual issue via the Work Center Labor Transaction screen or when Backflushing occurs for a Production Schedule or JIT Production as a result of posting transactions the Production Schedule Quantity Transaction screen or JIT Transaction screen or component costs of material from Split WIP.

WCO # Work Center Outside Labor

Occurs when Actual Materials Labor hours are posted either when here is a manual issue via the Work Center Labor Transaction screen or when Backflushing occurs for a Production Schedule or JIT Production as a result of posting transactions the Production Schedule Quantity Transaction screen or JIT Transaction screen. These transactions are for Outside Work Centers or component costs of material from Split WIP.

WCI # Work Center Inventory

Occurs when issuing materials from inventory for Production Schedule Complete transactions or JIT Production.

WFIN # Work Center Finished Goods

Occurs when Finished Goods are received into inventory from a Work Center.

Categories: Application Tags: , ,

End User Type

February 24th, 2007 No comments

The End User Type allows you to assign G/L Accounts, specific to a type of customer and provide an additional reporting functionality.  You have the ability to use Unit Codes 3 and or 4 to identify different categories.  For example, Unit Code 3 can be used to break out Sales separately, 1000 could represent Domestic, and 2000 could represent International.

The use of End User Types will provide additional sales information to the ledger.  You will be able to see not just sales of a product type but sales of a product type to a customer type.

This screen will add End User Type and define what account numbers are to be used for reporting purposes.

To Define End User Type:

ScreenShot002

End User Type: Create a code to represent this end user –  6 alpha/numeric positions. (i.e.Intl)

Description:  Full definition of end user type – 15 alpha/numeric positions.

Enter the G/L Account numbers that applies for each category.  Typical implementations will use the default accounts for Accounts Receivable, Sales, and COGS.

Enter the appropriate Unit Code in unit code 3 or 4

Note:   Unit Code 2 is to remain blank on this screen.   Leaving UC2 blank will  allow SyteLine to use the default Unit Code 2 extension as defined in Distribution Accounts for the product being sold.

To Update Customer Master File with End User Type:

ScreenShot003

Distribution Accounts

Sales of a product in the FG-100 product code to a customer in the DSTRB end user type category would result in GL trx that looked like this:

Acct                       UC2       UC3

11000                                    1000                                       $100

40000                    0001       1000                                                       $100