Invoice Manager

Field

Description

Ranges

Batch No - From

You may search for batches by typing a range of batch numbers. Type the beginning batch number of the range.

Batch No - To
(No label)

You may search for batches by typing a range of batch numbers. Type the ending batch number of the range.

External Batch - From

You may enter a range of external batches to limit the display to batches within that range. Type the beginning external batch number of the range.

External Batch - To
(No label)

You may enter a range of external batches to limit the display to batches within that range. Type the ending external batch number of the range.

Date - From

You may search for batches by selecting a range of invoice dates. Select the beginning date of the range.

Date - To (No label)

You may search for batches by selecting a range of invoice dates. Select the ending date of the range.

Exclude

You may exclude a pay means from the selected batch by typing the payment mask and then entering a check mark in this box.

Account

Enter a check mark in this box to limit the batch to invoices with this pay means mask at the account level.

GL Type

GL Type

General ledger subscriber type for this batch. (This menu originates from program #1578.)

• This information is generally used to redirect revenue.

Exclude

You may exclude a GL type from the selected batch by selecting the GL type and then entering a check mark in this box.

Work Order Number Range

Number — From
(No label)

You may include a range of work order numbers in the selected batch. Type the beginning number of the range.

Number — To
(No label)

You may include a range of work order numbers in the selected batch. Type the ending number of the range;

Account Number Range

Account — From (No label)

You may type a range of account numbers to limit the batch to invoices with an account number within the range. Type the beginning account number of the range.

Account — To
(No label)

You may type a range of account numbers to limit the batch to invoices with an account number within that range. Type the ending account number of the range.

Exclude

You may exclude a range of account numbers from the batch by typing the range and then entering a check mark in this box.

Delay Job Until

Delay — Date

You may select a future date and time to run the invoice batch.

• Use UNIX jobs start_invoice_scheduler and stop_invoice_scheduler to have SBN automatically launch the batch when that date and time arrives. For more information on UNIX jobs, see Unix Start/Stop Maintenance.

Delay —Time

You may select a future date and time to run the invoice batch.

• Use UNIX jobs start_invoice_scheduler and stop_invoice_scheduler to have SBN automatically launch the batch when that date and time arrives. For more information on UNIX jobs, see Unix Start/Stop Maintenance.

Column

Description

Batch Number

SBN-generated number assigned to each batch.

• If this column displays xxxxxx, the batch is a delayed batch.

System Date

Date the batch execution or invoice calculation occurred.

Tran Date

Date printed on the invoice.

Invoice Amount

Total amount for the selected invoice(s).

No Invoice

Number of invoices in this batch.

Min Inv

Starting invoice number for this batch.

Max Inv

Ending invoice number for this batch.

User

ID of the user that ran the invoice calculation process.

Description

Text description of the batch. Updated Export 128 so that item description on the invoice changed to item translation based on the user's language setting.

Date

If the batch is scheduled to run on a later date, this column displays the scheduled date.

Time

If the batch is scheduled to run at a later time, this column displays the scheduled time.

Export Scheduled

If this column displays an X, this batch is scheduled to export at a later date and time.

• This column functions only for custom exports 80, 81, 88, 99, 101.

External Batch Number

External batch number for the selected invoice batch.

Hold Flag

If this column displays an X, SBN placed this batch on Hold.

Note: If a batch fails in calculation, SBN places all batches for that dealer on Hold and submits the next batch that is not on Hold for calculation.

Error

Column with populate with an X if an error occurred.

Batch Previously Exported

Column with populate with an X if the batch was previously exported.

Note: When option bl232 is on, if the batch has been previously exported, users will see the line turn to the color selected in this option.

Field

Description

Batch No

Batch number for the selected invoice batch.

Inv Dt

Invoice date for the selected batch.

• If option bl104 is on, you cannot create an invoice batch with an invoice date earlier than the current fiscal period.

Due Date

Due date for the selected invoice batch; only used for contracts that do not contain specific payment terms.

Cycle Date

Control date for selecting cycle fees for this batch. This batch includes only cycle fees that have been invoiced through a date before the current date.

• SBN displays a warning when you select a date in the future.

Arrears Cycle Date

Control date for selecting arrears cycle fees for this batch. This batch includes only arrears cycle fees that have been invoiced through a date before the current date.

System Date

Date this batch was created.

Fiscal Date

Fiscal period in effect when this batch was created.

Description

Text description of the selected batch.

Batch Total

Total amount of the selected batch.

Batch Count

Total number of invoices included in the selected batch.

Minimum Invoice

Beginning invoice number included in this batch.

Maximum Invoice

Ending invoice number included in this batch.

Type

You may type a type code to limit this batch to work orders with this type.

User

You may type a user ID to limit batch to work orders created by this user.

Fin Sep

This field is active when option ba278 is on.

Financial Separation; use with Securitas Partner Invoicing.

You may enter a flag in this field to limit reminders based on the Fin Sep flag in Branch Profiles (program #1530) for the associated branch:

• • X —— use only accounts associated with branches flagged to use Financial Separation.

  • blank —— use only account not associated with branches flagged to use Financial Separation

  • % —— Use all accounts regardless of the Financial Separation flag for their associated branches.

• Action 1557/17 controls a user’s ability to enter % in this field. When a user’s profile does not include this action:

That user cannot enter % in this field

If the user tries to enter %, SBN displays an error message

Currency

Currency type of the selected batch. SBN supports multiple currencies.

Calculate Work Order Invoices

One Time

If this field displays a check mark, this batch includes invoices for work orders containing one-time fees.

Credits

If this field displays a check mark, this batch includes invoices for work orders containing negative amounts.

Calculate Installment Invoices

If this field displays a check mark, this batch includes invoices for work orders containing financing.

Calculate Cycle Invoices

If this field displays a check mark, this batch includes invoices for recurring charges.

Contract Selection Parameters

Ctr No Range

Contract Number 1 — From
(No label)

You may type a range of contract numbers to include in the selected batch. Type the beginning contract number of the range.

Contract Number 1 — To
(No label)

You may type a range of contract numbers to include in the selected batch. Type the ending contract number of the range.

Exclude

You may exclude a range of contract numbers from the selected batch by typing the range and then entering a check mark in this box.

Ctr No Range

Contract Number 2 — From
(No label)

You may type an additional range of contract numbers to include in the selected batch. Type the beginning contract number of the range.

• The first field of this range of contracts works as a mask when the second field of this range is empty.

Contract Number 2 —— To
(No label)

You may type an additional range of contract numbers to include in the selected batch. Type the ending contract number of the range.

• The first field of this range of contracts works as a mask when the second field of this range is empty.

Exclude

You may exclude a range of contract numbers from the selected batch by typing the range and then entering a check mark in this box.

Dealer Range

Dealer ID —— From
(No label)

You may limit the batch to those invoices that contain a dealer ID at the contract level within a range of dealer IDs. Type the beginning dealer ID of the range.

• If option ba325 is on, this field is required and displays only those dealer IDs in the user’s profile.

Dealer ID —— To
(No label)

You may limit the batch to those invoices that contain a dealer ID at the contract level within a range of dealer IDs. Type the ending dealer ID of the range.

• If option ba325 is on, this field is required and displays only those dealer IDs in the user’s profile.

Exclude

You may exclude a range of dealer IDs from the batch by typing the range and then entering a check mark in this box.

• If option ba325 is on, you may not exclude a range of dealer IDs.

Account

Enter a check mark in this box to limit the batch to invoices that contain a dealer ID —— at the account level —— within the range.

Sub Type Range

Subscriber Type --From (No label)

You may limit the batch to invoices of particular subscriber types within a range of sub types. Select the beginning subscriber type of the range.

Subscriber Type -- To (No label)

You may limit the batch to invoices of particular subscriber types within a range of sub types. Select the ending subscriber type of the range.

Exclude

You may exclude a range of subscriber types from the batch by selecting the range and then entering a check mark in this box.

Account

Enter a check mark in this box to limit the batch to invoices that contain a subscriber type —— at the account level —— within the range.

Normal

Select this check box to limit the batch to invoices for only Normal type cycle fees.

Note: You must select the Calculate Cycle Invoices check box to invoice cycle fees.

Group 1 Mask

Group 1 Mask

You may select a Group 1 mask to limit the batch to invoices that with this Group 1 mask at the contract level.

Exclude

You may exclude a Group 1 mask from the batch by typing the Group 1 mask and then entering a check mark in this box.

Account

Enter a check mark in this box to limit the selected batch to invoices with this Group 1 mask at the account level.

Rental

Select this check box to limit the batch to invoices for only Rental type cycle fees.

Note: You must select the Calculate Cycle Invoices check box to invoice cycle fees.

Group 2 Mask

Group 2 Mask

You may select a Group 2 mask to limit the batch to invoices that have this Group 2 mask at the contract level.

Exclude

You may exclude a Group 2 mask from the batch by typing the Group 2 mask and then entering a check mark in this box.

Account

Enter a check mark in this box to limit the batch to invoices with this Group 2 mask at the account level.

Permit

Select this check box to limit the batch to invoices for only Permit type cycle fees.

Note: You must select the Calculate Cycle Invoices check box to invoice cycle fees.

Variable

Select this check box to limit the batch to invoices for only Arrears type cycle fees.

Note: You must select the Calculate Cycle Invoices check box to invoice cycle fees, and you must enter an Arrears Cycle Date to invoice Arrears cycle fees.

Payment Mask

Payment Mask

You may enter a payment mask to limit the selected batch to invoices at the contract level that contain this pay means.

Note: When you calculate work order invoices, SBN creates invoices for work orders with the selected pay means (Pay Code). SBN only invoices work orders with a blank Pay Code if the contract (or account when the Account check box is selected) associated with a work order contains the selected pay means.

Exclude

You may exclude a pay means from the selected batch by typing the payment mask and then entering a check mark in this box.

Account

Enter a check mark in this box to limit the batch to invoices with this pay means at the billing account level.

GL Type

GL Type

General ledger subscriber type for this batch. (This menu originates from program #1578.)

• This information is generally used to redirect revenue.

Exclude

You may exclude a GL type from the selected batch by selecting the GL type and then entering a check mark in this box.

Work Order Number Range

Number — From
(No label)

You may include a range of work order numbers in the selected batch. Type the beginning number of the range.

Note: You must enter a range of contract numbers along with a work order range to calculate work order invoices.

Number — To
(No label)

You may include a range of work order numbers in the selected batch. Type the ending number of the range.

Note: You must enter a range of contract numbers along with a work order range to calculate work order invoices.

Account No Range

Account — From
(No label)

You may type a range of account numbers to limit the batch to invoices with an account number within the range. Type the beginning account number of the range.

Account — To
(No label)

You may type a range of account numbers to limit the batch to invoices with an account number within that range. Type the ending account number of the range.

Exclude

You may exclude a range of account numbers from the batch by typing the range and then entering a check mark in this box.

Branch Ranges

Branch Range - From (1)

You may select branch ranges to include in the selected batch. Select the beginning branch of the first range. (This menu originates from program #1530.)

Branch - To (1)
   (No label)

You may select branch ranges to include in the selected batch. Select the ending branch of the first range. (This menu originates from program #1530.)

Exclude (Branch Range 1)

You may exclude the first range of branches from the batch by selecting the range and then entering a check mark in this field.

Account

Enter a check mark in this field to limit the batch to accounts within the range of branches.

Branch - From (2)
   (No label)

You may select branch ranges to include in the selected batch. Select the beginning branch of the second range. (This menu originates from program #1530.)

Branch - To (2)
   (No label)

You may select branch ranges to include in the selected batch. Select the ending branch of the second range. (This menu originates from program #1530.)

Exclude
(Branch Range 2)

You may exclude the second range of branches from the batch by selecting the range and then entering a check mark in this field.

Branch - From (3)
   (No label)

You may select branch ranges to include in the selected batch. Select the beginning branch of the third range. (This menu originates from program #1530.)

Branch - To (3)
   (No label)

You may select branch ranges to include in the selected batch. Select the ending branch of the third range. (This menu originates from program #1530.)

Exclude
(Branch Range 3)

You may exclude the third range of branches from the batch by selecting the range and then entering a check mark in this field.

Delay Job Until

Delay — Date

You may select a future date and time to run the invoice batch.

Delay — Time

You may select a future date and time to run the invoice batch.

Email

You may type an email address to which SBN sends a notice when the batch runs. The email includes

• Total amount of the batch

• Count of invoices included in the batch

• Smallest invoice number included in the batch

• Largest invoice number included in the batch

• ID of the user who created the batch

Column

Description

Contract #

Contract number associated with the selected invoice in the batch.

Invoice #

Invoice number in the batch.

Amount

Amount due for the selected invoice.

Paid Amount

Amount of credit invoice or pre-bill invoice applied to the selected contract.

Tax

Tax on invoice total, if applicable.

Cycle Fee

If this column displays an X, the selected invoice includes cycle fees.

One-Time Fee

If this column displays an X, the selected invoice includes one-time fees.

Proration

Amount of an initial cycle-fee that SBN prorated as a one-time fee.

External Invoice Number

Customer-defined external invoice number. (The range of external invoice numbers originates from program #1620.)

Account Number

Displays the account number to which the selected contract is attached.

Field

Description

Template

Template to use for the export. (This menu originates from program #1591. Templates defined for the selected export type appear in the menu.)

Comment

Comment about the selected export template.

Batch Number (1)

You must select at least one batch number to include in the export.

External Batch # (1)

You may select an external batch number to include in the export.

Note: External Batch Number field (EBchNo) within Batch No dropdown of Export screen.

Batch Number (2)

Select a second batch number to include invoices within the range of the first and second batch. If you enter the same batch number in both Batch Number fields, the export contains only that batch.

Note: SBN automatically populates this field with the same batch number entered in the first Batch Number field, but you may change it before running the export to include a range of batches.

External Batch # (2)

You may select a second external batch number to include invoices within the range of the first and second external batch.

Output File

You must type a name for the Output File that SBN creates when you run this program.

Pay Code

You may select a Payment Method Code to limit the export to invoices from the selected batch for accounts/contracts that use that code. (This menu originates from program #1528.)

O    If you leave this field blank:

l    SBN exports the invoices of accounts/contracts in the batch with no defined pay code

l    SBN exports the invoices of accounts/contracts in the batch with a pay code that does not require validation

O    If you type % in this field, SBN exports all invoices in the batch regardless of pay code.

Dealer Range

Dealer ID — From

You may select a range of dealer IDs to limit the export to invoices from the selected batch that are associated with a dealer within the range. Select the beginning ID of the range.

Dealer ID — To
(No label)

You may select a range of dealer IDs to limit the report to invoices from the selected batch that are associated with a dealer within the range. Select the ending ID of the range.

Reexport Invoices

Enter an X in this field to re-export invoices.

Column names include

Enter a check mark in this field to include column headers on the exported invoices.

Include scheduled payments

Enter a check mark in this field to include scheduled payments on the invoices from the selected batch.

O    This field no longer defaults to a check mark between exports.

Language

Select a language to export in. (Language originates from program #548).

Subscriber Type

Subscriber Type originates from program #559.

Due Date Range

Due Date — From

You may select range of due dates to limit the report to invoices from the selected batch with a due date that occurs during the range. Select the beginning due date of the range.

Due Date — To
(No label)

You may select a range of due dates to limit the report to invoices from the selected batch with a due date that occurs during the range. Select the ending due date of the range.

Bank Account Number

Enter the Bank Account number for the export.

Bank Code

Enter the Bank Code number for the export.

My Invoices Only

Select this check box to include only those invoices that you flagged to be printed in the Invoice Status tab of Contract Master (program #548) in the export, and exclude invoices flagged to be printed by other users.

When this check box is blank, the export includes invoices flagged to be printed by all users.

Field

Field Length

Description

headline

varchar (40)

Customer-defined headline.

invo_no

varchar (10)

Invoice number.

pg

varchar (5)

Page number.

mpg

varchar (5)

Maximum page number.

ctr_no

varchar (20)

Contract number ’-’ dealer ID.

acc_no

varchar (20)

Account number.

branch

varchar (6)

Branch ID.

c_name

varchar (40)

Contact name.

inv_date

varchar (9)

Date invoice was created.

due_date

varchar (9)

Date payment is due on invoice.

name

varchar (40)

Account name.

name2

varchar (40)

Account name 2.

street1

varchar (40)

Street address for account.

street2

varchar (40)

Additional street address for account.

zip

varchar (10)

Zip code for account.

city

varchar (30)

City for account.

state

varchar (40)

State for account.

Detail Lines

Up to 40 detail lines per page. The actual maximum number of detail lines per page depends on the format of the invoice. You may configure the number of detail lines.

ln1_desc - ln40_desc

varchar (60)

Description of chargeable element. (This data originates from the Description field of the item in program #1535.)

Note: The ln3_desc column displays the installation country after the street and city for installations with the Print Details flag checked and code 2 or 3 in the Print Details #2 field of program #548.

ln1_desc2 - ln40_desc2

varchar (60)

Description 2 of chargeable element. (This data originates from the Description 2 field of the item in program #1535.)

ln1_amount -ln40_amount

varchar (13)

Amount charged for element.

tot_desc

varchar (64)

Description of the total amount of the invoice.

tot_amount

varchar (13)

Total amount of the invoice.

ocr_acc

varchar (12)

OCR customer reference.

amo_part1

varchar (10)

OCR dollars (leading zeroes).

amo_part2

varchar (2)

OCR cents.

amo_chk

varchar (1)

Check digit for dollars + cents.

payto_acc

varchar (20)

Bank/post account to receive payment.

ip_ix

varchar (5)

Internal pay mean code.

pay_mean_cd

varchar (12)

Pay mean code.

pay_mean_no

varchar (30)

Pay means number.

pay_mean_txt

Pay mean text.

tax_no

varchar (35)

Tax number.

tax_loc

varchar (12)

Tax location.

tax_desc

varchar (60)

Description of tax amount.

tax_amount

varchar (13)

Tax amount.

text

varchar (70)

Report messages text.

euro_novat_amt

varchar (15)

Portion of invoice total for which VAT does not apply.

euro_vat_amt

varchar (15)

Portion of invoice total for which VAT applies.

euro-tot_amt

varchar (15)

Total of non-VAT and VAT portions of invoice.

grp1

varchar (8)

Revenue group 1 from the billing account associated with the invoice.

grp2

varchar (8)

Revenue group 2 from the billing account associated with the invoice.

cname

varchar (40)

Contact name from the contract associated with the invoice.

O    The export includes this contact only when the contact exclude flag in the contract is blank.

wo_msgid

varchar (10)

ID of work order message.

pay_term_cd

char (4)

Pay term code.

county

varchar (30)

County for the account.

inv_ix

char (4)

Index number of scheduled payment.

wo_tran_date

char (8)

Transaction date of the work order.

tot_cyc

varchar (10)

Total of cycle fees.

extinv

varchar (20)

External invoice number.

br_desc

varchar (60)

Description of contract branch.

br_name

varchar (60)

Name of contract branch.

br_street1

varchar (40)

Street address of contract branch.

br_street2

varchar (40)

Additional street address of contract branch.

br_zip

varchar (10)

Zip code of contract branch.

br_city

varchar (30)

City of contract branch.

br_state

varchar (4)

State of contract branch.

br_phone

varchar (15)

Phone number of contract branch.

br_fax

varchar (15)

Fax number of contract branch.

br_email1

varchar (255)

Text of email1.

br_email2

varchar (255)

Text of email2.

br_pay_mean_cd

varchar (2)

Primary billing pay means of the contract branch; defined in program #1530.

br_pay_mean_no

varchar (30)

Primary pay means number of the contract branch.

br_pay_mean_cd2

varchar (2)

Secondary billing pay means of the contract branch; defined in program #1530.

br_pay_mean_no2

varchar (30)

Secondary pay means number of the contract branch

br_tax_no

varchar (50)

Tax ID of the contract branch; defined in program #1530.

inv_tix

char (8)

Payment index.

wo_type

char (8)

Work order type.

pay_mean_no2

varchar (30)

Secondary pay means number.

bal_amount

varchar (13)

Amount of balance for the account.

Item Lines

Up to 40 item codes to include on the invoice.

ln1_ic - ln40_ic

varchar (12)

Item codes 1 - 40.

ins_date

varchar (8)

Installation date.

sv_out_date

varchar (8)

Service request out date.

ba_email1

varchar (255)

Primary email address of the billing account.

ba_email2

varchar (255)

Secondary email address of the billing account.

tot_taxable

varchar (13)

Amount of invoice to which tax applies.

tot_ntaxable

varchar (13)

Amount of invoice to which tax does not apply.

pay_mean_code2

varchar (2)

Export code defined for the pay mean.

pay_term_code2

varchar (4)

Export code defined for the pay term.

account_balan

varchar (13)

Total invoice balance for the account.

ponum

varchar (60)

Purchase order number from the Work Order or Cycle Fee.

inv_cred

varchar (60)

External invoice number of the credited invoice, if defined. If there is no external invoice number, this column displays the credited invoice number.

crd_date

varchar (8)

Invoice date of the credited invoice.

ctry

varchar (2)

Country of the billing account address.

currency

varchar (4)

Invoice currency type.

igrpkey

varchar (12)

Information group of the billing account.

bill_paymean_cd

varchar (2)

Pay code of the billing account.

ba_tax_no

varchar (50)

Tax ID of the billing account.

bill_phone1

varchar (15)

Phone number 1 of the billing account.

bill_phone2

varchar (15)

Phone number 2 of the billing account.

prt_user

varchar (15)

Name of the individual printing the invoice.

chg_flg

char (1)

Change Flag.

UMR

varchar (35)

Current Unique Mandate Reference number; defined in SEPA tab of program #548.

UMR_original

varchar (35)

Original Unique Mandate Reference number; defined in SEPA tab of program #548.

Type

varchar (5)

Type of UMR (Core or B2B); defined in SEPA tab of program #548.

FIRST

varchar (1)

When this check box is selected, it indicates that the selected UMR is new; defined in SEPA tab of program #548.

signed_date

varchar (10)

Date on which the UMR was signed; defined in SEPA tab of program #548.

deb_name

varchar (75)

The debtor's full name; defined in SEPA tab of program #548.

deb_IBAN

varchar (30)

Debtor's current International Bank Account Number (IBAN); defined in SEPA tab of program #548.

Deb_BIC

varchar (25)

Debtor's Bank Identifier Code (BIC); defined in SEPA tab of program #548.

Deb_IBAN_org

varchar (75)

Debtor's original International Bank Account Number (IBAN); defined in SEPA tab of program #548.

crd_ident

varchar (35)

Creditor identifier for the UMR; defined in SEPA tab of program #548.

Crd_Name

varchar (75)

Creditor name for the UMR; defined in SEPA tab of program #548.

crd_ident_org

varchar (35)

Original creditor identifier for the UMR; defined in SEPA tab of program #548.

crd_name_org

varchar (75)

Original creditor name for the UMR; defined in SEPA tab of program #548.

frq

integer

How often, in months, the selected UMR is used to make payments; defined in Frequency field of SEPA tab in program #548.

MaxAmo

integer

The maximum amount that can be used on this SEPA UMR; defined in SEPA tab of program #548.

chg_fields

varchar (255)

List of fields that have been changed in the SEPA tab of program #548. When no fields have been changed, this column displays NEW.

sub_deal

varchar (12)

Sub-dealer (Found in Data Entry Master and Basics (#559)).

invform

varchar (4)

Invoice Form (Found in Contract Master (#548)).

Button

Name

Shortcut Key

Action

Description

Search

f9

1557/ 3

Search for invoice batch or range of batches.

Get Record

alt+f1

1557/ 1

View details of selected batch.

Previous Record

f4

Go to previous record.

Next Record

f5

Go to next record.

Print selected records

ctrl+f8

1557/ 4

Print selected records.

Calculate Invoices

f3

1557/ 2

Calculate invoices.

Reprint Report Locally

shift+f6

1557/ 6

Reprint report locally.

Export

shift+f8

1557/ 5

Export invoice batch.

Change Record

f2

Change selected batch.

Delete Record

shift+f10

1557/ 7

Delete selected batch.

Batch Report

shift+f9

1557/ 9

Generate Invoice Export Report (report #2134) for the selected invoice batch.