Field Definitions: AP Transaction Entry Form

The following is a list of field descriptions for the AP Transaction Entry form.Many of the descriptions include links to other topics that provide additional information about or related to the topic.

Seq#

Enter the existing sequence to work on, or enter 'N', 'New' or '+' to add a new sequence. The system assigns the next available sequence number. Use F4 to look up existing transactions for the month.

Action

When entering new records, this field defaults to A (Add) and cannot be accessed.

If this is an existing record, specify the action for this entry.

  • C-Change - Use this action to make changes to records that have already been processed.

  • D-Delete - Use this action to delete this record from all related module files. (The delete functions in the toolbar and Records menu only delete the entry from the batch.)

AP Trans

Display only, the transaction number assigned to each transaction once posted in AP Batch Process.

Vendor

Enter the vendor that applies to this transaction. If you do not know the vendor number, you can enter alpha characters, which will be matched to the vendor sort name for the first closest match. Alternately, use F4 to view all available vendors.

Note:

If you are tracking vendor compliance for non-PO/SL invoices (flag in AP Company Parameters) and this vendor is out of compliance, an ***Out of Compliance*** warning displays in red above the header; however, entry is allowed.

Description

Enter a description of this transaction, up to 30 characters. This description prints on the check stub, as well as on certain reports.

Invoice Date

Required field.

Enter the invoice date. Once you enter the date, the system automatically defaults the date in the Due Date field.

Disc Date

Initially defaults a discount date based on the payment terms assigned to the specified vendor in AP Vendors; may be overridden.

Note:

When entering a discount amount for this transaction, you must enter a date in this field. If a discount date is not entered, an error displays when you validate the batch (AP Batch Process). Also, if you enter and save PO or SL lines, and the payment terms for the PO or SL do not match those in the transaction header, a message displays providing you the option to update the header with the PO or SL payment terms. Select Yes to change this date to reflect the updated payment terms.

Due Date

Initially defaults a due date based on the payment terms assigned to the specified vendor in AP Vendors. If you have not specified payment terms for the vendor, the field defaults to the invoice date.

Note:

If you enter and save PO or SL lines, and the payment terms for the PO or SL do not match those in the transaction header, a message displays providing you the option to update the header with the PO or SL payment terms. Select Yes to change this date to reflect the updated payment terms.

Invoice Total

Enter the total amount of this invoice. If the Require Invoice Total to Equal Sum of all Lines option in AP Company Parameters is checked, this amount is compared to the total of all invoice lines, and if amounts do not match, a warning is displayed. Amounts must match before you can add or edit another transaction.

Hold Code

The Hold Code field in the AP Transaction Entry form, Payment/1099 InfoPayment Overrides tab

Entry in this field is not required. However, if entry is made, must be valid.

Specify the hold code (from HQ Hold Codes) for this transaction, if applicable. Hold codes prevent the invoice from being paid until the hold code is released. The hold code entered here is in addition to any hold code automatically placed on the transaction (or any portion of the transaction) because of retainage or a vendor hold.

Pay Control

Defaults from the pay control code from the Pay Control field on AP Vendors.

Enter the pay control code for this transaction.

The pay control code is used to group invoices together for payment. For example, you could code all loan payments with the same control code. Then, when initializing the payment batch, you can select all invoices with that pay control code. For subcontract invoices, you might use the owner’s application number to facilitate the “pay when paid” process (the SL Worksheet updates this field for that purpose).

Pay Method

Specify the payment method for this invoice. Payment methods include:

  • N-Viewpoint ePayments

  • C–Check

  • E–EFT

  • S-Credit Service

This field's default value comes from the Pay Method field in the AP Vendors form (Payment Method tab) for the selected vendor.

Tip: If this is a prepaid transaction,you must select C-Check.

N-Viewpoint ePayments

If you select the N-Viewpoint ePayments pay method, you must meet the setup requirements before you can generate and upload an ePayments file. For more information, see AP Viewpoint ePayments Download.

E-EFT

If you select the E-EFT pay method, and you have not set up bank routing information for the specified vendor in AP Vendors (Payment Method tab), the system displays a warning, but allows you to save the entry.

Additionally, the system enables the Addenda drop-down on the Addenda Info tab, allowing you to include tax payments, child support, or invoice detail with your payments. For details, see Addenda.

S-Credit Service

You should only select the S-Credit Service pay method if you have set up the appropriate information in AP Company Parameters (Payment Services tab) and AP Vendors (Payment Method tab). For more information, see Set up Credit Card Payments.

CM Acct

Enter the CM Account for paying this transaction. The entry must be a valid account set up in CM Accounts.

Note:

If you have specified a credit service CM account in the AP Company Parameters form, and you are paying this vendor with a different method (either check or EFT), the system will display a warning if you enter the credit service CM account. You will be allowed to save the record, however.

This field defaults depending on where you generate the transaction from:

  • If you are entering the transaction directly into AP Transaction Entry, this field initially defaults from the CM Account field in the AP Vendors form (Info tab). If the CM Account field in the AP Vendors form is blank, the system uses the number from the CM Account # field in the AP Company Parameters (Subledgers tab).

  • If you are creating transactions from PR (that is, using the PR AP Update form), and you enter an account number in the CM Account Override field, this field defaults that account number. If you leave the CM Account Override field blank, the system defaults the number from the CM Account field in the AP Vendors form. If that field is blank, the system uses the number from the CM Account # field in the AP Company Parameters form.

  • If you are updating AP from SL (that is, using the SL Update to AP form, accessed from SL Worksheet), this field defaults the account number from the CM Account field in SL Worksheet. If that field is blank, the system defaults the number from the CM Account field in the AP Vendors form. If that field is blank, the system uses the number from the CM Account# field in the AP Company Parameters form.

  • If you are paying this vendor by credit card, this field will default from the CM Acct field in the AP Company Parameters form (Payment Services tab).

Separate Payment

Check this box if this transaction is to be paid separately. When payments are initialized (in AP Payment Posting), a separate payment generates for this transaction.

Note:

If you are generating separate payments per job or subcontract, and this option is checked, this transaction will be paid separately from all other transactions for a subcontract or job.

Do not check this box if this transaction is not to be paid separately. When payments are initialized, this transaction will be grouped together with other transactions having the same vendor on a single invoice.

Prepaid Transaction

Check this box if this transaction has already been paid.

Do not check this box if payment has not been made on this transaction.

Note:

If you void a prepaid check after it has been posted, the prepaid information is removed from the invoice header. If you need to make corrections to the invoice and reprocess the prepaid, recheck this box and re-enter the prepaid check information in order to process the prepaid once the corrected invoice is posted.

Check #

If this transaction has already been paid, enter the check number on which it was paid. The number must be a whole number; up to 10 digits (may include leading zeros).

Note:

If paying multiple pre-paid transactions with a single check, a warning displays once the check number has been entered. However, the entry is allowed.

Paid Date

If prepaid, enter the payment date for this transaction. This date must match the payment batch month for processing prepaid transactions (AP Prepaid Process).

Paid Mth

This field automatically defaults to the month indicated by the Paid Date (previous field). Accept the default, or enter the month in which this transaction was paid. If you override the default, the system displays a warning, although you will be allowed to continue. The month indicated here is the month in which the payment will be posted. In other words, this month must match the month in which the prepaid is processed in AP Prepaid Process.

Include in 1099 Totals

This field initially defaults based on the vendor’s setup (AP Vendors).

Check this box if this invoice’s amounts are to be included in the specified vendor’s 1099 totals.

Do not check this box if this invoice’s amounts are not to be included in the specified vendor’s 1099 totals.

Click for the Australian field definition: Include in Payments Reporting.

Click here for the Canadian field definition: Include in T5018 Totals.

Include in Payments Reporting

Check this box if this invoice's vendor/subcontractor is subject to Taxable Payments reporting.

Note:

This box is checked by default if the vendor/subcontractor is set as subject to Taxable Payments in AP Vendors (you checked the Subject to taxable payments reporting box, Add'l Info tab).

For more information see Generating Taxable Payments Annual Reports.

Type

This field defaults to the 1099 type specified for this vendor (in AP Vendors); may be overridden.

If 1099 amounts are to be included when printing 1099s or creating 1099 electronic files (AP 1099 Processing), you must specify a 1099 type of “MISC” (Miscellaneous Income), “INT” (Interest Income), or “DIV” (Dividends/Distributions).

Note:

If you are using 1099 types only for informational or reporting purposes, any type is acceptable.

Canadian users

See Type for the Canadian field definition.

Type

This field defaults the type set up in AP Vendors (T5 Type field, Add'l Info tab). Enter the appropriate T5 type, if necessary.

Box#

Defaults initially based on the vendor’s setup (AP Vendors).

Press F4 to select from a list of valid boxes on the 1099 form that will be used to accumulate and print 1099 amounts.

Address Seq

Specify the payment address sequence to use for this transaction. Must be a valid address sequence defined for the vendor in AP Additional Addresses, and must be an address sequence flagged as 'Payment' or 'Both'.

Note:

If you previously entered an override address (to the left), entering an address sequence in this field will cause the 'Override Payment Address' checkbox to be cleared, and the override address to be replaced with the address defined for this address sequence.

Override Payment Address

Check this box if you want to override the name and/or address specified for this vendor in the AP Vendors. Use of this option will allow for a single vendor number to be used for all one-time purchases from various vendors. The override name and address will be used on all checks, and will be stored with the transaction for check history. When invoices are pulled for payment, separate sequences–and therefore separate checks–are printed for each transaction in the batch where the override box has been checked.

Do not check this box if you do not want to override the payment address for this vendor.

Note:

This checkbox is only for use when entering an override payment address (to the left). If you check this box, then enter an Address Seq (below), this box automatically clears.

Payment Address

If you check the Override Payment Address box, the system enables the following fields and you may enter an override address.

  • Name - Enter an override name here, up to 60 characters. Overriding the name will allow the system to use a single vendor for one-time purchases from various vendors. If you do not enter anything here, the name defaults from AP Vendors ( Name field, Payment Address section) when you save the record.

  • Add'l Info - Enter override information, up to 60 characters. Information that you enter here is included when printing checks for this vendor (e.g., Attention line, Garnishment Case #, etc.). If you do not enter anything here, the name defaults from AP Vendors ( Add'l Info field, Payment Address section) when you save the record.

  • Address - Enter an override address here, up to 60 characters. If you do not enter anything here, the name defaults from AP Vendors ( Address field, Payment Address section) when you save the record.

  • City - Enter an override city here up to 30 characters. If you do not enter anything here, the name defaults from AP Vendors ( City field, Payment Address section) when you save the record.

  • State - Enter an override state. The state must be valid as defined in HQ States. The system validates the state based on the Default Country field in HQ Company Setup for the active company. If it is not valid, an error will display but the system will allow entry. At that point, you must enter a valid country for this state in the Country field.

If you do not enter anything here, the name defaults from AP Vendors ( State field, Payment Address section) when you save the record.

  • Zip Code - ( Postal Code ) Enter an override zip code, up to 12 characters. If you do not enter anything here, the zip code defaults from AP Vendors ( Zip Code field, Payment Address section) when you save the record.

  • Country - Enter an override country, up to 2 characters. You must enter a country in this field when the address exists outside the Default Country specified in HQ Company Parameters for the active company. The country must be valid for the specified state (e.g., state, province, territory) as defined in HQ States.

Note:

If you enter any overrides in the above fields, a separate check will print for each transaction for the same vendor in the payment batch.

Note:

If you entered a value in the Address Seq # field, the system disables these fields and it automatically defaults the information from the Payment Address section in AP Vendors.

Note:

If you have Internet access, you can click the Map button for direct access to the default map site for your login (as defined in User Options, Main Menu). The map will default the approximate location of the specified country and address. If a country is not specified, attempts to locate the country is based on the Default Country field in HQ Company Setup.

Addenda

Addenda field in the AP Transaction Entry form, Addenda Info tab

If EFT is the pay method on the Payment Overrides tab, you can include tax payments, child support, and invoice detail with the payment of this invoice. Based on the addenda type you select from this field, additional fields display to enter related information. This field initially defaults from the Addenda Type field in AP Vendors, if one is indicated for the vendor.

  • 1-Tax Payment - Select this option if you want to include Federal tax payments with your EFT payments. When you select this option, the following fields display on the form: Form Code, Pd End Date, Amt Type, Amount, Amt Type 2, Amount 2, Amt Type 3, and Amount 3. The Amt Type fields identify the type of tax and you will enter the tax amount for that type in the Amount fields. The information in these fields depends on the form code and whether the fields represent subcategories defined for that form. For example, if you are using the Employer’s Quarterly Tax Return (Form Code 94105), the Amount Type and Amount fields are used to indicate the Social Security, Medicare, and Federal withholding amounts. Refer to your “EFTPS Payment Instruction Booklet” for more detailed information about individual field requirements. Information entered here is included when creating Federal tax invoices in PR AP Update.

Note:

The types of federal tax payments that can be entered here are limited to those outlined in "EFTPS Payment Instruction Booklet."

  • 2-Child Support — Select this option for EFT-paid child support payments. When you select this option, the following fields display on the form: PRCo#, Employee, and DL Code. You can manually generate a payment to the child support agency by entering the information directly in AP Transaction Entry. Typically, however, a payroll deduction is set up for the child support payment and the deduction is added to the employee's deductions (PR Employee Deductions/Liabilities). When payroll is run, the child support payment is deducted from the employee’s pay check. When PR AP Update is run, an invoice is generated for the state agency specified as vendor. When the invoice is accessed in AP Transaction Entry, the employee and deduction/liability code automatically default into these fields (if the deduction code is flagged to automatically update AP).

  • 3-Stub Detail – Select this option if you want to include invoice detail with this vendor’s EFT payment. This option can be used for any vendor (except for those requiring Tax or Child Support addenda). When the EFT Download is run, all EFT-paid vendor invoices in the batch with this addenda type automatically have CTX format addenda text records created in the download. One addenda for each line of detail will include the AP reference number, Invoice date, description, gross amount and net amount [gross - (retainage + discount)].

Note:

Viewpoint does not currently support state EFT tax payments.

AP Vendors

PR AP Update

PR Employee Dedns/Liabs

EFT Federal Tax Payment Info: Form Code

Used only if Addenda Type is “Tax Payment”.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Specify the ACH Credit Tax Form Code Number (from the EFTPS Payment Instruction Booklet) for this transaction. Up to 10 characters allowed. If you are using the “Automatic Update to Accounts Payable” option for the deduction/liability code (in PR Deductions/Liabilities), the form code automatically defaults based on the option selected in the Federal Type drop-down for the deduction/liability code as follows:

  • If set to 1–Withholding , defaults form code 94105

  • If set to 2–FUTA, defaults form code 941052

  • If set to 3–Soc Sec, defaults form code 941053

  • If set to 4–Medicare, defaults form code 941054

  • If set to null (blank), assumes 1–Withholding and defaults form code 94105

EFT Federal Tax Payment Info: Period End Date

Used only if Addenda Type is “Tax Payment”.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Enter the tax period ending date in MMDDYY format. This will be the tax period ending date for the IRS Return for which the liability is being paid, not the payment date.

Note:

The date is converted to YYMMDD format in the text file, with the day set to '01'. For example, if you enter 121508 as the tax period ending date, it will be formatted as 081201 in the text file.

If you are using the “Automatic Update to Accounts Payable” option for the withholding deduction/liability code (PR Deductions/Liabilities), the period end date automatically defaults from Payroll.

EFT Federal Tax Payment Info: Amount Type

Used only if Addenda Type is “Tax Payment”.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Specify the Amount Type (Tax Information ID Number). This will be the Subcategory or IRS Number from the EFTPS Payment Instruction Booklet. If none, enter the Form Code specified above.

For example, if you are using Form Code "94105” (Employer’s Quarterly Tax Return – Forms 941), there are three Subcategories: Social Security=1, Medicare=2, and Withheld=3. Social Security would be the first subcategory, therefore, you would enter “1” in this field.

EFT Federal Tax Payment Info: Amount

Used only if Addenda Type is “Tax Payment”.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Enter the tax amount. If a Subcategory/IRS number was entered in the previous field, this amount will be the tax amount for the subcategory (Amount Type) specified above. For example, if using Form Code “94105”, where Amount Type is “1” (Social Security), this will be the Social Security tax amount.

Note:

If subcategories exist, the total amount of all subcategories must equal the total tax amount (i.e. invoice amount). Otherwise, this amount will be the total tax amount.

EFT Federal Tax Payment Info: Amount Type 2

Used only if Addenda Type is “Tax Payment” and Subcategories are being used.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Specify the Amount Type (Tax Information ID Number). This will be the Subcategory or IRS Number from the EFTPS Payment Instruction Booklet. Using the previous example, where the Form Code is “94105” and the subcategories are Social Security=1, Medicare=2, and Withheld=3, you would enter “2” here.

EFT Federal Tax Payment Info: Amount 2

Used only if Addenda Type is “Tax Payment” and Subcategories are being used.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Enter the tax amount. If a Subcategory/IRS number was entered in the previous field, this amount will be the tax amount for the subcategory (Amount Type 2) specified above. For example, if using Form Code “94105”, where Amount Type is “2” (Medicare), this will be the Medicare tax amount.

EFT Federal Tax Payment Info: Amount Type 3

Used only if Addenda Type is “Tax Payment”, and Subcategories are being used.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Specify the Amount Type (Tax Information ID Number). This will be the Subcategory or IRS Number from the EFTPS Payment Instruction Booklet. Using the previous examples, where the Form Code is “94105” and the subcategories are Social Security=1, Medicare=2, and Withheld=3, you would enter “3” here.

EFT Federal Tax Payment Info: Amount 3

Used only if Addenda Type is “Tax Payment”.

Note:

It is suggested that you refer to your “EFTPS Payment Instruction Booklet” for more detailed information about entry requirements for this field.

Enter the tax amount. If a Subcategory/IRS number was entered in the previous field, this amount will be the tax amount for the subcategory (Amount Type 3) specified above. For example, if using Form Code “94105”, where Amount Type is “3” (Withheld), this will be the Federal Withholding tax amount.

EFT Child Support Payment Info: PR Co#

Used only if Addenda Type is “Child Support”.

Enter the PR company of the employee paying the child support. If the deduction code for this transaction has been flagged to auto update AP (i.e. the “Automatic Update to Accounts Payable” option in PR Deductions/Liabilities), this field will default from Payroll.

EFT Child Support Payment Info: Employee

Used only if Addenda Type is “Child Support”.

Specify the employee paying the child support. If the deduction code for this transaction has been flagged to auto update AP (i.e. the “Automatic Update to Accounts Payable” option in PR Deductions/Liabilities), this field will default from Payroll.

EFT Child Support Payment Info: DL Code

Used only if Addenda Type is “Child Support”.

Enter the deduction code for child support. If the deduction code for this transaction has been flagged to auto update AP (i.e. the “Automatic Update to Accounts Payable” option in PR Deductions/Liabilities), this field will default from Payroll.

Line #

Enter a number (0-32,767) for this invoice line, or ‘N’, ‘New’, or '+' for the next available number.

Action

When entering new records, this field defaults to A (Add) and cannot be accessed.

If this is an existing record, specify the action for this entry.

  • C-Change - Use this action to make changes to records that have already been processed.

  • D-Delete - Use this action to delete this record from all related module files. (The delete functions in the toolbar and Records menu only delete the entry from the batch.)

Type

Select the line type. The screen will display additional fields related to the line type.

  • 1-Job- Use for expenses related to a JC job.

  • 2-Inv- Use for expenses related to an Inventory location.

  • 3-Exp- Use for miscellaneous expenses.

  • 4-Equip- Use for expenses related to equipment usage.

  • 5-EM Work Order- Use for expenses related to an EM work order.

  • 6-PO- Use for expenses related to a purchase order.

  • 7-SL- Use for expenses related to a subcontract.

  • 8-SM Work Order- Use for miscellaneous expenses related to an SM work order.

    Note:

    Entries of this type will generate a work completed miscellaneous line in the Work Completed grid of SM vWork Orders.

    Note:

    For Australian and Canadian companies, if you specify a non-job SM work order, the system will automatically set the Tax Type to 3-VAT for the work completed miscellaneous line in SM Work Orders. The tax code for the work completed line will default from the Service Center or Service Site (depending on the Tax Source specified for the work order) and must be a VAT-type code. However, to ensure proper implementation of this functionality, the SM company's AR company (defined in SM Company Parameters) must be set up with a Default Country of AU or CA in HQ Company Setup.

  • For 4-Equip and 5-EM Work Order lines, if you checked the Display last used date for parts in AP/PO/EM box in EM Company Parameters, the Last Used Date of Part field displays in the header area of this form.

  • For 6-PO and 7-SL lines, additional display fields appear on the Other Info tab.

JC Co#

Specify the Job Cost company in which job/phase/cost type information for this invoice item will be validated, and to which the job expense will be posted.

Job

Specify the job to be charged for this invoice item.

  • If you enter a soft- or hard-closed job, the status displays in red to the right of the Line field. The system will only save the record if you allow posting to soft or hard-closed jobs (flags in JC Company Parameters).

  • The update to AP from SL Worksheet creates invoice items for subcontracts posted to soft- or hard-closed jobs, regardless of whether you allow posting to closed jobs. However, if you do not allow posting to closed jobs, you will be unable to post the batch.

Phase

Specify the phase to which this invoice item applies.

Note:

If the specified job’s Lock Phases option is checked (JC Jobs), must be a valid job phase (as set up in JC Job Phases).

CT

Specify the Job Cost cost type for this invoice item.

Ticket

The Ticket field on the AP Transaction Entry form, Lines section, Info tab.

This field only displays for 1-Job lines and job-related 6-PO lines that reference a field ticket.

For Job lines: Enter the field ticket number for this invoice line or press F4 to select from a list of valid open field tickets for the specified job/contract.

For job-related PO lines: This field defaults the field ticket specified for the purchase order item and is disabled.
Note: Costs associated with approved field tickets only impact T&M billings; therefore, assigning field tickets to job lines is only useful if the job's contract/contract item has a bill type of T&M or Both.

Once you post the invoice, the system updates the Cost Detail tab in JC Field Ticket with this line's transaction information, showing a Source of AP Entry.

For more information about field tickets, see JC Field Ticket Form.

Material

This field is optional, unless posting an Inventory type transaction. Not applicable to SL type transactions.

Enter the material to which this invoice item applies.

If this is a Job, Expense, Equipment, or Work Order item, you can enter any material, valid or non-valid. If the material is a valid HQ material, the description, unit of measure, and unit cost will default from HQ Materials. If a non-valid material, description defaults as 'Not in Material File', and UM defaults as LS. Unit cost defaults as 0.00 and is disabled.

If this is an Inventory item, you must enter a valid stocked material (as defined in HQ Materials), and the material must be set up for the specified location in IN Materials. The unit cost will default from IN Location Materials.

If a PO item, material defaults from PO and field is disabled. Material description, UM, and unit cost default from PO item.

Note:

If the material is set up for the vendor in PO Vendor Materials, the unit cost will default based on the vendor's setup, regardless of the line type.

IN Co#

Entry in this field is not required. However, if entry is made, it must be valid.

Specify the Inventory company in which material/location information for this invoice item will be validated, and to which inventory item will be posted.

Loc

Specify the Inventory location for which this material was purchased. Location must be set up in IN Location Setup, and material must be assigned to this location in IN Materials.

EM Co#

Specify the EM company in which equipment information for this invoice item will be validated, and to which the equipment expense will be posted.

Equipment

Specify the equipment (from EM Equipment Master) to which this invoice item applies.

If this is a Work Order line, this field is display only, and will default the equipment assigned to this work order.

Comp Type

Specify the component type (from EM Component Types) for the equipment, if applicable.

If this is a Work Order line, this field is display only, and will default the component type assigned to this work order, if applicable.

Component

If you entered a component type in the previous field, this field will default the first component of this type for the indicated equipment (as defined in EM Equipment). May be overridden, but must be a valid component for this equipment.

If this is a Work Order line, this field is display only, and will default the component assigned to this work order, if applicable.

Cost Code

Specify the cost code (as defined in EM Cost Codes) to which this invoice item applies.

If this is an Equipment line, and you entered a component for this equipment (previous field), this field defaults the cost code assigned to the component’s type in EM Component Types. May be overridden.

If this is a Work Order line, this field will default the cost code assigned to the specified work order item (in EM Work Order Edit). Cost code may only be changed if the Allow Cost Code Changes option (for Work Orders) in EM Company Parameters is checked. Otherwise, this field is display only.

Cost Type

Specify the equipment cost type (as defined in EM Cost Types) to which this invoice item applies.

Work Order

Enter the work order (as set up in EM Work Orders) to which this invoice item applies.

Item#

Indicate the work order item to which this invoice item applies. Once you have entered the item number, the Equipment, Component Type and Component (if applicable), and Cost Code assigned to this work order item are displayed to the right of this field. The Equipment, Component Type, and Component cannot be changed.

PO

Enter the purchase order that this invoice item applies to or press F4 to select it from a list.

  • The vendor assigned to the specified purchase order must be the same as the vendor specified in the transaction header.
  • If the Check Compliance On Transaction Entry, Warning Only box is checked for Purchase Orders in AP Company Parameters and the purchase order is out of compliance, you will receive a warning at this point stating that the “Purchase order is not in compliance”.
  • If the purchase order is related to an SM work order, the associated SM Co, SM Work Order, and Scope display below the PO Item# and PO Item Line fields. If the PO is for a job-related SM work order, the system will also display the JC phase and cost type assigned to the PO item.

If you initialized the purchase order via the AP Purchase Order Initialize form (accessed by selecting File > Initialize from PO from the Line # field), the system automatically populates the PO, PO Item, and PO Item Line fields with the appropriate values. If you initialized by Receiver #, the system also populates the Rec # field with the specified receiver number. The Rec # field is display only and therefore, cannot be edited.

Note: If the job associated with the work order has been soft or hard-closed, the system will only allow the entry if you allow posting to closed jobs (i.e. the Allow Posting to Hard-Closed Jobs and/or Allow Posting to Soft-Closed Jobs boxes are checked in JC Company Parameters).

If you do not allow posting to closed jobs, you will receive a message indicating the job is closed and you will be unable to save the record.

PO Item

Enter the purchase order number for this invoice item. Additional fields will display based on the type of purchase order item (e.g. if a job line, screen will display the JC Co, Job, Phase, and CT). Some fields may be grayed out; these cannot be changed.

If you initialized the purchase order via the AP Purchase Order Initialize form (accessed by selecting File > Initialize from PO from the Line # field), the system automatically populates the PO, PO Item, and PO Item Line fields with the appropriate values. If you initialized by Receiver #, the system also populates the Rec # field with the specified receiver number (which is assigned to the PO when you receive it in PO Receipts Entry). The Rec # field is display only and therefore, cannot be edited.

Note: Once you enter the item number, you can view additional information about the purchase order item by selecting the Other Info tab. This tab displays current totals for the PO item, such as the Current Units, Unit Cost, and Total Cost, and Received, Backordered, Invoiced, and Remaining amount.

PO Item Line

If you distributed the PO item to multiple lines, enter the applicable line number. Press F4 to see a list of valid line numbers. If you have not distributed the PO item to multiple lines, this field will default automatically to 1 and the system will not allow you to change the number.

Note: If you are adding a transaction back to a batch and a PO line item has been paid, the system will disable this field.

If you have not already distributed the PO item to multiple lines, and want to, press F5 from this field to access the PO Item Distribution form. Use that form to distribute the item among multiple lines. You can also select Open PO Item Distribution from the Tasks drop-down on the toolbar. When you save your changes, and exit the PO Item Distribution form, the PO line on this form refreshes to display the updated data. For more information, see PO Item Distribution.

If you initialized the purchase order via the AP Purchase Order Initialize form (accessed by selecting File > Initialize from PO from the Line # field), the system automatically populates the PO, PO Item, and PO Item Line fields with the appropriate values. If you initialized by Receiver #, the system also populates the Rec # field with the specified receiver number. The Rec # field is display only and therefore, cannot be edited.

SL

Enter the subcontract (as set up in SL Entry) to which this invoice item applies.

Note:

The vendor assigned to the specified subcontract must be the same as the vendor specified in the transaction header.

Also, if the “Check Compliance On Transaction Entry, Warning Only” option for Subcontracts in AP Company Parameters is checked, and the subcontract is out of compliance, you will receive a warning at this point stating that the “Subcontract is not in compliance”.

SL Item#

Enter the subcontract item to which this invoice item applies. The item’s assigned job, phase, and cost type (as set up in SL) and the job/phase/cost type’s U/M (as set up in JC) are displayed. These fields cannot be changed.

SMCo

This field is disabled for PO lines associated with an SM work order.

Required.

Enter the SM company to which this invoice line applies. This will be the SM company in which the SM work order was set up. Press F4 for a list of valid SM companies.

SM Work Order

This field is disabled for PO lines associated with an SM work order.

Required.

Enter the SM work order to which this invoice line applies. Press F4 for a list of valid work orders for the specified SM company.

Note: If you specify a job-related work order and the job associated with the work order has been soft or hard-closed, you can save the record if you allow posting to closed jobs (i.e. the Allow Posting to Hard-Closed Jobs and/or Allow Posting to Soft-Closed Jobs boxes are checked in JC Company Parameters). If you do not allow posting to soft or hard-closed jobs, a message displays indicating the job is closed and you will be unable to save the record.

Scope Seq

This field is disabled for PO lines associated with an SM work order.

Required.

Enter the work order scope to which this invoice line applies. Press F4 for a list of valid scopes for the specified work order.

  • If you enter a scope that is closed, a warning displays and you will be unable to save the record. You must either reopen the scope in SM Work Orders or select an open scope.

  • If the transaction line is in an open batch and the scope is closed prior to processing the batch, you will be unable to post the batch until you either reopen the scope or change to an open scope.

For job-related work orders:

  • If the job associated with the work order has been soft or hard-closed, you can save the record if you allow posting to closed jobs (i.e. the Allow Posting to Hard-Closed Jobs and/or Allow Posting to Soft-Closed Jobs boxes are checked in JC Company Parameters). If you do not allow posting to soft or hard-closed jobs, a message displays indicating the job is closed and you will be unable to save the record.

  • If the work order has a Cost Method of Markup and you specify a scope that does not a rate template assigned, you will be able to save the line; however, you will unable to post the batch until you assign a rate template to the scope.

  • If the work order scope is not assigned a phase, a message displays indicating a phase is needed, but the system will allow you to save the record. However, you will be required to assign a phase to the work order scope before posting the invoice in AP Unapproved Invoice Posting.

Tip:

You can press F5 from the Work Order or Scope fields to access SM Work Orders and assign a phase to the scope.

SM Cost Type

This field only displays when the line Type is 8-SM Work Order.

Enter the SM cost type that applies to this invoice line. Press F4 for a list of valid SM cost types.

JC Cost Type

This field is only displayed and enabled if the line Type is 8-SM Work Order and the SM work order is for a job.

Enter the JC cost type (from JC Cost Types) for this invoice line. Initially defaults as follows:

  • If you entered an SM cost type for the line, defaults the JC cost type assigned to the SM cost type (in SM Cost Types). Default may be overridden.

  • If you did not enter an SM cost type or if you entered an SM cost type, but no JC cost type is assigned to the SM cost type, defaults as blank and must be entered manually.

The system will use this cost type, in conjunction with the phase specified for the work order sequence, to post the costs to Job Cost (via the JC Cost Detail table).

Note:

If the work order scope specified for this invoice line has not been assigned a phase, you will receive a message indicating the phase is missing; you will be unable to save the record until you assign a phase to the work order scope in SM Work Orders.

Note:

If no phase override exists in JC Departments (Phase Overrides tab) for the phase specified on the work order scope, the cost type entered here must be set up with the appropriate GL accounts in JC Departments (Cost Types tab) based on the following:

  • If the phase exists on the job (locked and non-locked jobs), the cost type must be set up for the department assigned to the phase's contract item.

  • If the phase does not exist for the job (non-locked jobs only), the cost type must be set up for the department assigned to the first contract item associated with the job.

  • If the phase does not exist for the job (non-locked jobs only), but the phase matches the "number of valid characters" of a phase that does exist on the job, the cost type must exist for the contract item assigned to the valid job phase.

Note:

If the cost type is not found in JC Departments, you will be unable to post the batch. This applies regardless of how you set the JC interface checkbox in SM Company Parameters.

Locked Phases vs. Non-Locked Phases

If the Phases on this job are locked box is checked for the job in JC Jobs, the cost type specified here must be set up for the job/phase in JC Job Phases. If it is not, you will receive a warning and be unable to save the line until you specify a valid job/phase cost type.

Tip:

You can add the cost type to the job phase by pressing F5 from this field to access JC Job Phases. Once you set up the cost type and exit JC Job Phases, you can enter the cost type here.

If the Phases on this job are locked box is not checked in JC Jobs, you can use any cost type defined for the phase in JC Job Phases or JC Phases. If the cost type is not set up for the phase, you will receive a warning and be unable to save the line until you specify a valid phase cost type.

Description

Enter the description of this invoice item, up to 30 characters. Initially defaults the header description, but may change depending on the line type entered.

  • Job – If you checked the Default Header Description to Lines on Job Type box in AP Company Parameters, the header description will be used as the line description. If you did not check this option, the phase description will default as the line description.

  • Inventory – Defaults the material description.

  • Expense – Defaults the header description.

  • Equipment, EM Work Order – If you checked the Default header description to lines on equipment typebox in AP Company Parameters, this field defaults the header description. If you did not check this option, this field defaults the cost code description.

  • PO & SL – Defaults the PO item description or SL item description, respectively.

  • SM Work Order - Defaults the header description.

If you specify a material for the line, the description defaults as follows:

  • Job, Inventory, Expense, or SM Work Order – Defaults the material description from HQMT (HQ Materials). If an non-valid material is entered (does not apply to Inventory lines), the description will default as 'Not in material file'.

  • Equipment or Work Order – Defaults the material description from EMEP (Equipment Parts), HQMT (HQ Materials), or POVM (PO Vendor Materials). If a work order may also default from EMWP (Work Order Parts). If the material exists in more than one table, it will use the description from the first table in which the material is located. For example, if the material exists in both Equipment Parts and Vendor Parts, but you select the material from Vendor Parts in the F4 lookup, it will return the description from Equipment Parts because EMEP is checked before POVM.

GL Co#

This field is enabled for 3-Expense lines only.

Specify the GL company for this invoice item. Initially defaults the GL company specified in AP Company Parameters.

For all other line types, this field defaults the GL company specified for the line type company (e.g. if a Job line, defaults the GL Co defined for the JC company).

GL Acct

This field initially defaults a GL account based on the transaction line type:

  • 1-Job - Defaults from the JC Departments form. If you did not select the Allow GL Account override when posting cost check box in the JC Company Parameters form (GL Cost tab), the system will disable this field. If the default is blank, the system will allow entry in this field; however, once the line is saved, the system disables the field. If you selected the Allow GL Account override when posting cost check box, the system enables this field and you can override the value.
  • Defaults from IN Locations. If you did not select the Allow GL Account overrides check box in IN Company Parameters, the system will disable this field. If the default is blank, the system will allow entry in this field; however, once the line is saved, the system disables the field. If you selected the Allow GL Account overrides check box, the system enables this field and you can override the value.
  • 3-Expense - Defaults from AP Vendors, unless a non-stocked material is specified, in which case, this field defaults from the Non-Stocked GL Account field in HQ Material Categories.
  • 4-Equipment - Defaults from the EM Departments form. If you did not select the Allow GL Account Override check box in the EM Company Parameters form, the system will disable this field. If the default is blank, the system will allow entry in this field; however, once the line is saved, the system disables the field. If you selected the Allow GL Account Override check box, the system enables this field and you can override the value.
  • 5-EM Work Order - Defaults from the EM Departments form. If you did not check the Allow GL Account Override check box in the EM Company Parameters form, the system will disable this field. If the default is blank, the system will allow entry in this field; however, once the line is saved, the system disables the field. If you checked the Allow GL Account Override check box, the system enables this field and you can override the value.
  • 6-Purchase Order - Defaults from the purchase order. If a job PO item, defaults as follows:
    • If the job is open and the JC Dept GL account is blank, this field defaults the GL account from the PO item.
    • If the job is open and the JC Dept GL account is not blank, but you have checked the Allow GL Account override when posting revenue box in JC Company Parameters, this field defaults the GL account for the PO item. If you did not check the box, this field defaults the GL account from the JC department. The system will display a message warning that the defaulted GL account does not match the PO item's GL account.
    • If the job is closed (final) and the JC Dept closed GL account is blank, the GL account defaults as blank. The system will display a message warning that the defaulted GL account does not match the PO item's GL account. If you did not check the Allow GL Account override when posting revenue box (JC Company Parameters), manual entry is required, as initialization cannot occur.
    • If the job is closed and the JC Dept closed GL account is not blank, this field defaults the closed GL account from JC Departments. The system will display a message warning that the defaulted GL account does not match the PO item's GL account.
Note: For PO items referencing an SM work order, this field is disabled.
  • 7-Subcontract - Defaults from the subcontract as follows:
    • If the job is open and the JC Dept GL account is blank, this field defaults the GL account from the subcontract item.
    • If the job is open and the JC Dept GL account is not blank, but you have checked the Allow GL Account override when posting revenue box in JC Company Parameters, this field defaults the GL account for the subcontract item. If you did not check the box, this field defaults the GL account from the JC department. The system will display a message warning that the defaulted GL account does not match the subcontract item's GL account.
    • If the job is closed (final) and the JC Dept closed GL account is blank, the GL account defaults as blank. The system will display a message warning that the defaulted GL account does not match the subcontract item's GL account. If you did not check the Allow GL Account override when posting revenue box (JC Company Parameters), manual entry is required, as initialization cannot occur.
    • If the job closed and the JC Dept closed GL account is not blank, this field defaults the closed GL account from JC Departments. The system will display a message warning that the defaulted GL account does not match the subcontract item's GL account.
  • 8-SM Work Order - The GL Acct field is always disabled for this line type and will derive the Misc Cost account from the SM department as follows:
    • If you specified a division on the work order scope and an alternate department is assigned to the division, the system uses the following hierarchy to determine the correct account to use:
      1. The system looks for a cost type category/call type/cost type override (in SM Departments, Overrides tab) based on the SM cost type entered for the invoice line, the cost type category assigned to the SM cost type, and the call type specified for the work order scope. If one exists, it will use that account.
      2. If no cost type category/call type/cost type override is defined, the system will then look for an override cost type category/call type or cost type category/cost type, and if found, use it.
      3. If no override accounts are defined by cost type category/call type or cost type category/cost type, the system will use the standard account defined for the cost type category at the department level (SM Departments, Info tab).
      4. If no SM cost type is specified for the invoice line, the system will use the standard Other account defined in SM Departments (if no material is entered) or the Material account defined in SM Departments.
    • If no alternate department is assigned to the division or no division is assigned to the work order scope, the system will use the department assigned to the service center to determine the default account using the same process defined above.

UM

Enter a valid unit of measure for this invoice item. Initially defaults as follows.

If a material is entered:

  • Job, Inventory, Expense, and SM Work Order Lines - If you entered a valid HQ material, the field defaults the purchase unit of measure. You can override this default, but it must be a valid unit of measure for that material.

    If overrides exist for the specified material/vendor in PO Vendor Materials (POVM), defaults the vendor material UM matching the Purchase UM in HQ Material; if no match is found, it will default the lowest UM for the vendor/material group/material.

  • Equipment Lines - If the selected material exists in EMEP (Equipment Parts) for the equipment, UM will default from EMEP if it matches the HQMT Purchase UM; otherwise, default will be the HQMT Purchase UM.

    If you selected a vendor material that does not also exist in EMEP, defaults the vendor material UM if it matches the HQMT Purchase UM; otherwise, defaults the lowest UM (in POVM) for the vendor/material group/material.

    If material does not exist in EMEP or POVM, defaults the HQMT Purchase UM.

  • EM Work Order Lines - If the selected material exists in EMWP (Work Order Parts) for the work order, UM will default from EMWP, regardless of whether it matches the HQMT Purchase UM.

    If you select a material from EMEP (Equipment Parts) that does not also exist in EMWP for the work order, UM will default from EMEP if matches the HQMT Purchase UM; otherwise, default will be the HQMT Purchase UM.

    If you select a vendor material that does not also exist in EMWP and/or EMEP for the work order, defaults the vendor material UM if it matches the HQMT Purchase UM; otherwise, defaults the lowest UM (in POVM) for the vendor/material group/material.

    If material does not exist in EMWP, EMEP, or POVM, defaults the HQMT Purchase UM.

  • PO and SL Lines - Defaults the unit of measure specified for the PO or SL item. This default cannot be overridden.

Note:

If you entered a non-valid material (Job, Exp, Equip, EM Work Order, and SM Work Order lines only), the UM will defaults as LS. You can override this default with any valid unit of measure.

If no material is entered:

  • Job - If the Default JC Job Phase UM on job lines box is checked in AP Company Parameters, this field will default the UM from the CT specified for invoice line (as defined in JC Job Phases). If the Default JC Job Phase UM on job lines box is not checked, this field defaults LS as the unit of measure.

  • Expense, Equip, EM Work Order, and SM Work Order - Defaults as LS.

Note:

For Inventory lines, a material must always be entered. For PO lines and SL lines, this field will always default from the PO or SL and cannot be overridden.

Units

Indicate the number of units for this invoice item.

If this is a purchase order line, the invoiced units will be checked to see if they exceed the PO's received units. If they do, a warning displays. If the Allow Invoice to Exceed Received box is checked (in AP Company Parameters), the entry will be allowed and the batch can be posted. However, if the option is unchecked, you will be unable to save the line until the invoiced units are corrected.

Note:

Units posted to job lines will only be updated to JCCD (JC Cost Detail) if you have checked the Update Actual Units From AP option for the specified job in JC Jobs. If option is unchecked, units will be set to 0.00 in JCCD.

Unit Cost

Indicate the cost per unit for this invoice item. If you skip this field and enter the Gross amount, the unit cost will be calculated for you. This field initially defaults as follows:

  • For Job, Exp, Equip, EM Work Order, and SM Work Order lines, this field defaults as 0.00 unless a material is specified. In which case, the unit cost defaults from HQ Materials.

Note:

The unit cost posted for job lines will only be updated to JCCD (JC Cost Detail) if you have checked the Update Actual Units From AP option for the job in JC Jobs. If option is unchecked, unit cost will be set to 0.00 in JCCD.

  • For Inv lines, this field will defaults the Last Unit Cost defined in IN Location Materials.

  • For PO and SL items, this field defaults the unit cost defined on the purchase order or subcontract.

Note:

If you change the unit cost for a PO or SL item, you will receive a warning indicating that the unit cost is different than the PO or SL unit cost, and that committed costs will be reduced by units at the PO or SL unit cost. Changes made will not be updated to related PO/SL files.

Note:

If you specified a material for this invoice item and the material is set up for the vendor (in PO Vendor Materials), the unit cost default will be based on vendor's setup, regardless of line type.

ECM

Specify which quantity the unit cost represents:

E - Cost is per each unit.

C - Cost is per 100 units.

M - Cost is per 1000 units.

Gross

(Click here for the field definition for Australian or Canadian users.)

Specify the total amount for this invoice item, or accept the default. If unit of measure is other than LS (lump sum), changes to the Gross amount will cause the unit cost to be recalculated.

Purchase Order Lines

If you enter a Gross amount and the item's units are 0.00 and the UM is not LS, you will receive a warning that 'entering gross amount without units could cause problems, and that for Job Type items, it will cause committed costs to be improperly updated'. However, entry is allowed.

In addition, the invoiced amount for each item is checked to see if it exceeds the current total cost of the PO item and/or PO. If it does, a warning is displayed, but the entry is accepted. However, if the Allow Transactions to Exceed Item's Current Total Cost and/or Allow Transactions to Exceed PO's Current Total Cost boxes are unchecked in AP Company Parameters, you will be unable to post the batch until the invoiced amounts are corrected.

The invoiced amount will also be checked to see if it exceeds the PO's received amount. If it does, a warning is displayed. If the Allow Invoiced to Exceed Received box is checked in AP Company Parameters, the entry will be allowed. However, if unchecked, you will be unable to save the line until the invoiced amount is corrected.

Subcontract Lines

The invoiced amount for each item will be checked to see if it exceeds the current total cost of the subcontract item or subcontract. If it does, a warning is displayed. If the Allow Transactions to Exceed Current Total Cost box is checked in AP Company Parameters, the amount will be allowed. Another check will be done at the header level once all items have been entered and accepted. If the total of all items exceeds the total remaining amount available on the subcontract, another warning is displayed. Total amount will be allowed if the “Allow transactions…” flag is checked. This verification allows for the condition of a deduct item (subcontracts) not invoiced, which could then result in an overpayment.

SM Work Order Lines

This amount will be sent to the specified SM work order as "actual cost". If you also entered taxes and a miscellaneous amount (with Included box checked) for the line, those amounts will be included in the actual cost sent to SM.

Note: If the SM work order is job-related, the resulting actual cost will be updated to Job Cost using the phase and JC cost type associated with this line.

Amt

Specify the payable amount for this invoice item, or accept the default. If unit of measure is other than LS (lump sum), changes to this amount will cause the unit cost to be recalculated.

Purchase Order Lines

If you enter an amount and the item's units are 0.00 and the UM is not LS, the system provides a warning, but entry is allowed.

The invoiced amount for each item is checked to see if it exceeds the current total cost of the PO item and/or PO. If it does, a warning is displayed, but the entry is accepted. However, if the Allow Transactions to Exceed Item's Current Total Cost and/or Allow Transactions to Exceed PO's Current Total Cost check boxes are selected in the AP Company Parameters form, you will be unable to post the batch until the invoiced amounts are corrected.

The invoiced amount will also be checked to see if it exceeds the PO's received amount. If it does, a warning is displayed.

If the Allow Invoiced to Exceed Received check box is selected in the AP Company Parameters form, the entry will be allowed. However, if not selected, you will be unable to save the line until the invoiced amount is corrected.

Subcontract Lines

The invoiced amount for each item will be checked to see if it exceeds the current total cost of the subcontract item or subcontract. If it does, a warning is displayed. If the Allow Transactions to Exceed Current Total Cost check box is selected in the AP Company Parameters form, the amount will be allowed. Another check will be done at the header level once all items have been entered and accepted. If the total of all items exceeds the total remaining amount available on the subcontract, another warning is displayed. Total amount will be allowed if the “Allow transactions…” check box is selected. This verification allows for the condition of a deduct item (subcontracts) not invoiced, which could then result in an overpayment.

Misc Amt

Use this field to enter freight or other miscellaneous charges. If you check the Included box (to the right of this field), the amount entered here will be included in this line’s total. However, this amount is not included when taxes, discounts, or retainage are calculated for this line. This amount will also be excluded:

  • when checking the item's invoiced amount against the current total cost of the PO/PO Item or SL/SL Item.

  • from the total committed cost in APJC (AP JC Distributions) for standing PO's where the unit of measure is LS and the PO is not flagged for receiving.

  • when updating the Received Cost and Invoiced Cost amounts in POIT (PO Items).

  • when updating the Invoiced Cost amount in SLIT (SL Items).

For SM Work Orders, if this is a PO line (type 6-PO) and the specified PO is associated with an SM Work Order, this amount will be included in the actual cost updated to the work completed purchase line (in SM Work Orders, Work Completed tab).

Note:

If multiple work completed purchase lines exist that reference the same PO item, the actual cost will be allocated proportionately across the work completed lines.

If this is an SM Work Order line (type 8-SM Work Order), this amount will be included in the actual cost updated to the work completed miscellaneous line.

Note:

For lines with a UM other than LS, this will cause a discrepancy between the cost total for the work completed line and the quantity/rate values (because the quantity x rate will not match the cost total).

Included

Check this box to include the Misc Amt (left) in this line's total amount. The Misc Amt is not included when calculating tax, discount, or retainage amounts for this line.

Leave this box unchecked to exclude the Misc Amt from this line's total amount. For all lines except for Inventory, the miscellaneous amount will also not be charged to Job Cost, Equipment, General Ledger, or SM work orders. It will be a memo entry only, and will only be useful if writing reports to pull this miscellaneous amount.

Inventory Lines

Although any line type may include or exclude a Misc Amt, its primary purpose is for inventory purchase lines. If using the option for burdened unit cost (flag in IN Company Parameters), the Misc amount will be handled as follows:

  • If this box is checked, the Misc Amt is included in the invoice total, the Inventory and AP accounts are debited/credited with the total amount, and the total (including the Misc Amt) will be included in the unit cost for the Inventory location.

  • If this box is not checked, the Misc Amt is excluded from the invoice total, but is included in the unit cost for the IN location. The Inventory account is debited with the total amount (including the Misc Amt), the AP account is credited with the gross amount (total less the Misc Amt), and the Misc Amt is credited to the location's Miscellaneous Expense account. When posting the freight vendor's invoice for the Misc Amt, the entry should be posted to offset the Miscellaneous Expense amount.

Subject to On-Cost

This box defaults from the Subject to On-Cost box in AP Vendors.

If you specified a cost type in AP Vendors for generating on-cost invoices (JC Cost Type field), you must enter that cost type in the CT field for this invoice line, or the system will uncheck this box; however you may re-check this box, if necessary.

Check this box if the invoice for this vendor is subject to on-cost.

Note:

If you check this box and the vendor is not set as subject to on-cost (Subject to On-Cost box in AP Vendors is not checked) or does not have associated on-cost types (On-Cost tab, AP Vendors), the system will display a warning but will allow you to save the record.

If you add the original invoice back into a batch and uncheck this box after posting the associated on-cost invoice, the system will not delete the on-cost invoice. So, if you uncheck this box and reprocess the original invoice, the system will generate duplicate on-cost invoices.

Ret%

Specify the percentage at which retainage is calculated for this item, or accept the default.

Note:

Retainage can be entered with any line, but is typically only used with job-related transactions.

Ret Amt

If a Ret% was entered, this field defaults an amount based on the percentage specified and the invoice line’s gross amount. Accept the default, or enter the retainage amount. If you change the default amount, the retainage percentage is recalculated.

  • A line’s retainage amount cannot exceed the line’s gross amount. If this occurs, a warning displays, and the amount must be corrected before the line can be saved).

  • Retainage is not calculated on Tax or Misc amounts. Additionally, the retainage portion of the invoice line is automatically placed on hold using the Retainage hold code specified in AP Company Parameters.

Disc%

Specify the percentage at which discounts for this invoice item will be calculated, or accept the default. Discount rate initially defaults from the Vendor’s payment terms (specified in invoice header). If the line’s type is PO or SL, the discount rate defaults from the payment terms specified for the purchase order or subcontract.

Disc Amt

If a Disc % was entered, this field defaults an amount based on the percentage specified and the invoice line’s gross amount (less retainage, if any). Accept the default, or enter the discount amount. If you change the default amount, the discount percentage is recalculated.

Note:

Discounts are not calculated on Misc amounts. Also, if you enter a discount amount here, a discount date must be entered in the header. If a discount date is not entered, a warning displays when you validate the batch (AP Batch Process).

If using tax discounts (flag in AP Company Parameters), the discount will be taken by subtracting this amount from the invoice's gross amount to get the tax basis.

Tax Type

Specify the tax type for this item.

  • 1-Sales – Tax amounts are payable to the vendor and are added to the invoice total. This tax amount is directly charged to Job Cost, Equipment, and GL.

  • 2-Use - Tax amounts are accrued, and will be paid at a later date to the appropriate State or Local taxing authority. Calculated tax amounts do not affect the gross or net balance due to the vendor. Instead, the transaction’s gross amount and tax amount is charged to Job Cost, Equipment, and GL account with an offsetting liability account as defined in HQ Tax Codes. Use the AP Tax Report to obtain an itemization of use tax amounts.

  • 3-VAT (Value Added Tax) - This tax is paid on goods and services at each stage of production or distribution, and is based on the value added at each stage. This tax is not directly expensed; it is tracked in the GL and reduces the payment to a taxing authority through an Input Tax Credit (ITC). Use the AP Value Added Tax Report to obtain an itemization of VAT amounts. This is the default tax type for Australian and Canadian companies (where Default Country in HQ Company Setup is AU or CA).

Note:

When generating work completed miscellaneous lines from AP Transaction Entry, the system posts the tax information to the work completed line based on the work order type, the billable status, and whether the invoice line is material related or non-material. For detailed information, see About Tax Calculations for Work Completed.

Intercompany Transactions

The tax type you select determines which company is responsible for paying tax, either the selling company or the purchasing company. The system determines the appropriate tax rate and tax code based on the responsible company’s associated tax group (HQ Tax Codes and Rates field, HQ Company Setup, Add’l Info tab).

For sales and value added tax, the system validates/defaults the tax code (in the Code field) based on the selling company’s tax group. For use tax, the system validates/defaults the tax code based on the purchasing company’s tax group.

Tax Code

If posting taxes to this item, specify a valid tax code (HQ Tax Codes), or accept the default. Default is based on the following:

  • Job Lines — The tax code default is determined by the Base Tax On field in JC Jobs. If set to J-Job, the tax code defaults from JC Jobs. If set to V-Vendor, the tax code defaults from AP Vendors. If set to O-Vendor Override, the tax code defaults from AP Vendors. If a tax code is not specified for the vendor, the tax code will default from JC Jobs. You can override the default as necessary.

  • Inventory Lines — Defaults the tax code from IN Locations, unless material is not taxable, in which case, defaults as null.

  • Exp, Equip, and EM Work Order Lines – Defaults tax code from AP Vendors.

  • SM Work Order Lines – Defaults tax code from one of the following (may override as necessary):

    • Sales tax – from AP Vendors

    • Job work order and use tax – from JC Jobs

    • Customer work order and use tax – from Work Order Site or Center

Note:

When generating work completed miscellaneous lines from AP Transaction Entry, the system posts the tax information to the work completed line based on the work order type, the billable status, and whether the invoice line is material related or non-material. For detailed information, see About Tax Calculations for Work Completed.

  • SM Work Order Lines – Defaults tax code from one of the following (may override as necessary):

    • Sales tax – from AP Vendors

    • Job work order and use tax – from JC Jobs

    • Customer work order and use tax – from Work Order Site or Center

Note:

When generating work completed lines from AP Transaction Entry, the system defaults the tax code as follows:

Note:
  • For billable work order lines created in AP with sales tax, the Tax Type in SM Work Completed is set to Sales, and the Tax Code will default to what was specified in the Service Site or Service Center

  • For non-billable work order lines created in AP with use tax, the Tax Type in SM Work Completed is set to Use, and the tax code will be copied over from AP

Note:

For instances where a non-billable work order line with sales tax is paid to a vendor in AP and has an additional use tax obligation in the service department, the miscellaneous work completed line item will display the use tax where the rate is the remaining difference between sales tax paid in AP, and the use tax to be paid on the work order. (For example, if an item from AP is $100.00 and has a sales tax of 5%, the sales tax is $5.00 in AP. If the use tax on the work order is 15%, the remaining use tax obligation is 10%, and Use tax amount is $10.00 in the Tax Amount field.)

Note:

In an instance where sales tax in AP is greater than or equal to the use tax on the work order (for example, 10% Sales tax and 5% Use tax, the use tax will not display in the Tax Amount field).

Note:

If the work order is job related, no tax code will be assigned to the generated work completed miscellaneous line unless use tax has been assigned.

  • PO & SL Lines – Defaults tax code as defined on the purchase order or subcontract (respectively).

Note:

If you entered a valid, non-taxable material for the line, the tax code will default as null. If you entered a non-valid material, the tax code will default based on the line type.

Note:

If the PO is associated with a job-related SM work order and the tax code specified here is assigned a redirect phase and/or cost type, the appropriate GL accounts must be set up in JC Departments for the phase (Phase Overrides tab) or cost type (Cost Types tab); otherwise, you will be unable to post the batch.

Note:

This applies regardless of how you set the JC interface checkbox in SM Company Parameters.

Committed Costs

If you specified a job (JC, PO, or SL line types) for this line and you post taxes to the line, the system relieves committed costs from the phase/cost type in JC Cost Detail table for the tax amount as follows:

  • if phase and cost type overrides exist for the tax code, the system uses the tax code phase and cost type.

  • if a phase override exists for the tax code, but a cost type override does not exist, the system uses the tax code phase and the cost type from the PO line.

  • if a cost type override exists for the tax code, but a phase override does not exist, the system uses the phase from the PO line and the tax code cost type.

  • if phase or cost type overrides do not exist for the tax code, the system uses the phase and cost type specified for the PO item.

Intercompany Transactions

If the tax type is 1-Sales or 3-VAT (Value Added Tax), the tax code defaults based on the Tax Group assigned to the AP Company.

If the tax type is 2-Use, the tax code defaults based on the Tax Group assigned to the 'posted to' company.

Redirect Phase/Cost Type

If this invoice item is for a 1-Job line, a 6-PO line (that is associated with a job or SM job work order), or an 8-SM Work Order line (job-related work order only), and the tax code entered here is assigned a redirect phase and/or cost type (i.e., JC Tax Phase and/or JC Cost Type in HQ Tax Codes), the system will validate the phase and/or cost type based on the Phases on this job are locked checkbox in JC Jobs. Validation will be as follows:

  • Phases Locked - If the Phases on this job are locked box is checked and the tax code specifies a redirect phase only, the phase must exist in JC Job Phases for the line's job. If the tax code specifies both a redirect phase and cost type, the phase/cost type combination must exist for the line's job in JC Job Phases. If the tax code specifies a redirect cost type only, the cost type must exist in JC Job Phases for the invoice line's phase (for PO and SM lines associated with a job work order, this will be the scope phase).

  • Phases Not Locked - If the Phases on this job are locked box is not checked and the tax code specifies a redirect phase only, the phase must exist in JC Job Phases (for the line's job) or in JC Phases. If the tax code specifies both a redirect phase and cost type, the phase/cost type combination must exist in JC Job Phases or JC Phases. If the tax code specifies a redirect cost type only, the cost type must exist in JC Job Phases or JC Phases for the invoice line's phase (for PO and SM lines associated with a job work order, this will be the scope phase).

If validation determines that the conditions indicated above do not exist, you will need to either use a different tax code or add the phase and/or cost type combination to JC Job Phases or JC Phases (depending on the "locked phases" flag) before you can post the batch.

Tax Basis

This field indicates the portion of the gross amount that is taxable. If using tax discounts (flag in AP Company Parameters), the field default is the 'gross amount less discount amount' (if applicable). Otherwise, the default is the invoice's gross amount; may be overridden.

Note:

Tax amounts posted to subcontract lines are not included in the invoiced amount updated to SLIT (SL Items). Therefore, if you have set up a subcontract to include sales tax, it is suggested that you post invoices with the tax amount included as part of the gross amount and set this field to 0.00. If the subcontract is set up without tax and sales tax applies, then gross and sales tax amounts should be entered separately on the invoice line.

  • Tax amounts posted to subcontract lines are not included in the invoiced amount updated to SLIT (SL Items). Therefore, if you have set up a subcontract to include sales tax, it is suggested that you post invoices with the tax amount included as part of the gross amount and set this field to 0.00. If the subcontract is set up without tax and sales tax applies, then gross and sales tax amounts should be entered separately on the invoice line.

  • When generating work completed miscellaneous lines from AP Transaction Entry, the system posts the tax information to the work completed line based on the work order type, the billable status, and whether the invoice line is material related or non-material. For detailed information, see About Tax Calculations for Work Completed.

Tax Amt

Defaults an amount based on the Tax Rate (defined for tax code in HQ Tax Codes) and the Tax Basis; may be overridden.

  • Tax amounts posted to subcontract lines are not included in the invoiced amount updated to SLIT (SL Items). Therefore, if you have set up a subcontract to include sales tax, it is suggested that you post invoices with the tax amount included as part of the gross amount (i.e. not posted separately here). If the subcontract is set up without tax, and sales tax applies, the gross and sales tax amounts should be entered separately on the invoice line.

  • When generating work completed miscellaneous lines from AP Transaction Entry, the system posts the tax information to the work completed line based on the work order type, the billable status, and whether the invoice line is material related or non-material. For detailed information, see About Tax Calculations for Work Completed

  • Tax amounts posted to a job-related SM Work Order line are included in the total billable amount for the work completed miscellaneous line generated during batch processing (even though the tax code is set to blank for the work completed line); this ensures that the total amount paid to the vendor is charged to the job.

Pay Category

This field displays only if you selected the Using Payable Category check box in AP Company Parameters.

Specify a valid pay category for this line. The pay category specified here, along with the line type (Type field), will determine the default pay type (next input).

Initially defaults a pay category as follows:

  • If you have set up a standard or user pay category override in F3 Properties (not recommended), defaults the F3 pay category.

  • If no F3 override exists, defaults the pay category specified for the current user in VA User Profile.

  • If no override pay category is specified for the user, defaults the pay category defined in AP Company Parameters.

  • If no default pay category is defined for the company, default will be null. (In this case, the pay type will default from AP Company Parameters based on the line's type.)

The default may be overridden if you allow overrides to pay type (you selected the Allow Payable Type Override checkbox in AP Company Parameters); otherwise, input is disabled.

Note:

If you bring a posted transaction back into a batch and change the pay category for a line with retainage, the system debits the GL account associated with the pay type for the original pay category (Payable Type Retainage field in AP Pay Category).

Additionally, if the pay category has a discount GL specified (Discount Taken GL Acct field in AP Pay Category), and you have checked the Post Discounts Offered to GL and net amount to subledgers box in the AP Company Parameters form, the system debits the discount to the GL account specified for the original pay category.

For Purchase Order lines, the pay category and pay type always default from the PO item, regardless of whether overrides exist in F3, VA User Profile, or AP Company Parameters. This is true even if you deselect the Using Payable Category checkbox in AP Company Parameters after you have already implemented its use. Although the pay category is not visible, its assignment will remain in effect.

If a pay category and pay type were not specified for the PO item, the pay category and pay type default based on the standard hierarchy (F3, VA User Profile, AP Company Parameters) and the PO item's line type. However, you will be allowed to continue. The month indicated here is the month in which the payment will be posted.

Pay Type

The Pay Type field in AP Transaction Entry, Lines section, Info tab.

Required.

Specify the pay type for this item. If you are using pay categories (flag in AP Company Parameters), defaults the pay from this line's pay category based on the line type. The pay type used for each line type is as follows:

  • Job lines - Use the Job pay type

  • Inv, Exp, Equip, and EM Work Order lines - Use the Expense pay type

  • PO lines - Use the pay type assigned to the PO item.

  • SL lines - Use the Subcontract pay type

  • SM Work Order lines - Use the SM Work Order pay type

If you allow pay type overrides (flag in AP Company Parameters), you may override the default.

If you are using pay categories, the pay type must be either assigned to the specified pay category (in AP Pay Category) or an 'unassigned' pay type (a pay type that has not been restricted to a pay category in AP Payable Types). If you are not using pay categories, you can specify any pay type, regardless of whether the pay type is restricted to a pay category.
Note: You can only enter a pay type that is not designated for retainage in AP Company Parameters or for a pay category in AP Pay Category.

Supplier

Indicate the supplier (from AP Vendors) for this item, if applicable. Note that if a supplier is entered here, payment will be made with a 2-party check.