Custom Settings

Section Item Value Module and Purpose
AP LiabilityTransfer Yes This setting enables the Liability Transfer Feature. The AP Menu (not the AP Menu Map) will display Liability Transfer, the Invoice Entry screen will have the ‘Transfer Liability From’ field, the Vendor Master File will have four additional fields, and the AP GL Update will include ability to update Liability Transfers.
For more information see AP: Liability Transfer.
AP UseExpandedImport Yes

AP: Invoices (Import)
This setting allows for importing the following additional fields to the Invoice Import: CompanyNumber, MemoLine1, MemoLine2, Notes, ImportUserName, UseTax, UseTaxAmount, PaymentMethodId, CreditCard, DistributionNotes, and WorkTicketNumber. This setting also allows invoices from a prior closed posting period to post within the current month. Also allows qualifiers in the MemoLine1 and MemoLine2 columns. When this custom setting is used, you do not need to specify the Company Number on the AP Invoice screen prior to completing the Import process. If this custom setting is not used, then you must specify a Company Number prior to importing invoices.

Note:  If you want to include inactive jobs in the import, enable the APInvoices | AllowInactiveJob | Yes custom setting.
AP UseExternalPO Yes AP: Invoices
This setting adds a second Purchase Order field to use for External PO's. With this setting in place:
  • the Purchase Order Number field on Invoices will use the PO field for an External Purchase Order Number. Drilling and Lookup functionality is not applicable, therefore not available.
  • The Vendor Activity Report will display the External Purchase Order Number.
  • The Invoice Details screen includes an External PO column.
  • When Import Invoices, if a PO Number is entered in the csv file, then the PO Number will populate the External PO field.
APCheck AccountNumberMICRAdjustment (min) -2.6888
(max) 1.3542		 Moving MICR Horizontally: There are three different custom settings that move the fields (Check Number, Account Number, and Transit Number) in the MICR area horizontally. By having the three fields instead of one, it allows for the most flexibility in the case where a company needs to reposition the check number slightly of the MICR, but not the other two fields.
A negative adjustment moves the field in the MICR area to the left and a positive number moves account number field in the MICR area to the right.
APCheck CheckNumberMICRAdjustment
APCheck TransitNumberMICRAdjustment
APCheck AddBlankLine Yes AP Checks
This setting adds a blank line between Invoices on the stub that are being paid for garnishments.
APCheck ApplyPayeeValidationChanges Yes

These custom settings work together to adjust the layout of the Accounts Payable blank check format.

APCheck | ApplyPayeeValidationChanges | Yes

  • Payee Name is in all capital letters
  • Font is Courier New 12 point
  • Payee field is indented 1/4 inch from Pay to the Order of
  • Pay to the Order of does not overlap into the MICR line

APCheck | LimitAmountAsterisks | Yes

  • Limits the number of asterisks to the left of the amount to no more than 4

Note:  See Printing on Blank Check Stock for samples
APCheck LimitAmountAsterisks Yes
APCheck ConvertLabelstoFrench Yes This setting converts the labels and column headings to French on the AP Checks. This also changes the date format to me MM JJ AAAA. Vendor #: Fournisseur #: Memo: Memo Invoice Date: Date de facture Invoice No.: Numero de facture Amount: Montant Discount: Deductions Net Amt.: Montant Net Check Number: Numero du cheque Check Date: Date du cheque Check Amount: Montant du cheque Date will also print with: MM JJ AAAA instead of MM DD YYYY.
APCheck HorizontalAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the AP check text horizontally. A negative adjustment will move check text to the left and a positive number will move check text to the right.
APCheck HorizontalAmountTextAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the horizontal placement of the check amount text on the check. A negative adjustment moves the amount text to the left and a positive number moves the amount text to the right.
Example: .25 would move the amount a quarter inch to the right, and -.25 would move the amount a quarter inch to the left.
APCheck HorizontalAmountAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the AP amount horizontally. A negative adjustment moves the amount to the left and a positive number moves the amount to the right.
APCheck HorizontalCheckAddressAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the horizontal placement of the check address on the check. A negative adjustment moves the address to the left and a positive number moves the address to the right.
Example: .25 would move the check address a quarter inch to the right, and -.25 would move the check address a quarter inch to the left.
APCheck HorizontalCheckAmountAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the horizontal placement of the check amount on the check. A negative adjustment moves the amount to the left and a positive number moves the amount to the right.
Example: .25 would move the check amount a quarter inch to the right, and -.25 would move the check amount a quarter inch to the left.
APCheck HorizontalCheckEmployeeNameAddressAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the AP employee name and address horizontally. A negative adjustment moves the AP employee name and address to the left and a positive number moves the AP employee name and address to the right.
APCheck HorizontalCheckDateAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the horizontal placement of the check date on the check. A negative adjustment moves the check date to the left and a positive number moves the check date to the right.
Example: .25 would move the check date a quarter inch to the right, and -.25 would move the check date a quarter inch to the left.
APCheck HorizontalCheckNumberAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the placement of the check number on the check. A negative adjustment moves the check number to the left and a positive number moves the check number to the right.
Example: .25 would move the check number a quarter inch to the right, and -.25 would move the check number a quarter inch to the left.
APCheck HorizontalCheckSignatureAdjustment min of -2.6888
max of 1.3542		 This setting adjusts the AP check signature horizontally. A negative adjustment moves the signature to the left and a positive number moves the signature to the right.
Example: .25 would move the check number a quarter inch to the right, and -.25 would move the signature a quarter inch to the left.
APCheck HorizontalLogoAdjustment min of 0.1
max of 1.3542		 This setting adjusts the AP check logo horizontally. It affects both the logo and mail address in the blank format. You must use a positive value between 0.1 and 1.3542. Negative values do not work with this custom setting.
APCheck HorizontalMemoLineAdjustment (distance adjustment) This setting adjusts the placement of the memo line on the check.
Example: .25 would move the memo line a quarter inch to the right, and -.25 would move the memo line a quarter inch to the left.
APCheck MaxNumMemoLines 30 (will print 30 lines on the AP check) AP Checks
This setting controls the number of lines that print on a check stub before breaking to another check form. The normal default is to print 33 lines on the stub. If your company would like to print a different number for some reason, you can use this setting.
APCheck MovePayLabel True Standard Format (formless format) checks. This setting will add 'PAY' in front of 'To the order of' on Standard Format (formless format) checks.
APCHECK PrefixforFederalID "enter the value you want to have as a prefix" AP Report - NACHA Bank Transmission
This setting allows placement of a special value in front of the Federal ID number in the format. Value is the prefix number.
APCheck Preview Yes AP Checks
Allows checks to be previewed prior to printing.
APCheck PrintCompanyAddress Yes This setting will print the Company Name, Address Line 1, City, State, Zip, and Phone Number information on AP Check Stubs. The information is based on the checks' Company Number (for multicompany, the AP Checks' Company Number can be different).
APCheck VerticalAdjustment min of -0.4229
max of 0.6		 Vertical Adjustment setting available for AP Checks. This setting will adjust the text by inches (not pixels). A negative number will cause all fields to move up the page. A positive number will cause all fields to move down the page.
This setting is NOT recommended for Blank Check Stock.
APCheck VerticalCheckEmployeeNameAddressAdjustment min of -0.4229
max of 0.6		 This setting adjusts the AP check employee name and address vertically. A negative number moves the employee name and address up the page. A positive number moves the employee name and address down the page.
APCheck VerticalDateAdjustment min of -0.4229
max of 0.6		 This setting adjusts the date placement on an AP check. A negative number moves the date up the page. A positive number moves the date down the page.
APCheck VerticalAmountAdjustment min of -0.4229
max of 0.6		 This setting adjusts the amount placement on an AP check. A negative number moves the amount up the page. A positive number moves the amount down the page.
APCheck VerticalAmountTextAdjustment min of -0.4229
max of 0.6		 This setting adjusts the amount text placement on an AP check. A negative number moves the amount text up the page. A positive number moves the amount text down the page.
Example: .25 would move the amount a quarter inch down, and -.25 would move the amount a quarter inch up.
APCheck VerticalCheckAddressAdjustment min of -0.4229
max of 0.6		 This setting adjusts the check address placement on an AP check. A negative number moves the address up the page. A positive number moves the address down the page.
Example: .25 would move the check number a quarter inch down, and -.25 would move the check address a quarter inch up.
APCheck VerticalCheckAmountAdjustment min of -0.4229
max of 0.6		 This setting adjusts the check amount placement on an AP check. A negative number moves the amount up the page. A positive number moves the amount down the page. This setting adjusts the placement of the check amount on the check.
Example: .25 would move the check number a quarter inch down, and -.25 would move the check amount a quarter inch up.
APCheck VerticalCheckDateAdjustment min of -0.4229
max of 0.6		 This setting adjusts the vertical placement of the check date on the check. A negative number moves the date up the page. A positive number moves the date down the page.
Example: .25 would move the check date a quarter inch down, and -.25 would move the check date a quarter inch up.
APCheck VerticalCheckNumberAdjustment min of -0.4229
max of 0.6		 This setting adjusts the placement of the check number on the check. This setting adjusts the check number placement on an AP check. A negative number moves the check number up the page. A positive number moves the check number down the page.
Example: .25 would move the check number a quarter inch down, and -.25 would move the check number a quarter inch up.
APCheck VerticalCheckSignatureAdjustment min of -0.4229
max of 0.6		 This setting adjusts the AP check signature vertically. A negative number moves the signature up the page. A positive number moves the signature down the page.
Example: .25 would move the signature a quarter inch down, and -.25 would move the signature a quarter inch up.
APCheck VerticalMemoLineAdjustment min of -0.4229
max of 0.6		 This setting adjusts the AP check memo line vertically. A negative number moves the memo line up the page. A positive number moves the memo line down the page.
Example: .25 would move the check number a quarter inch down, and -.25 would move the memo a quarter inch up.
APCheck VerticalMICRAdjustment min of -0.4229
max of 0.6		 Vertical Adjustment setting available for AP Checks to move only MICR up or down. This setting will adjust the text by inches (not pixels). A negative adjustment moves MICR up the page. A positive number moves MICR down the page.
APCheck SortByMemo Yes This setting will sort AP checks alphabetically by the Memo field.
If you are printing AP checks that contain Union Dues or other Payroll Deductions and want the invoices details on the check to sort alphabetically by the Employee's last name, you can add this Custom Setting. This setting will change the order the memo information is written to be Last Name, First Name, MI, Date, and SSN and then writes that information into the Invoice Memo line. Then on the Print Checks screen, the Sort Memo field alphabetically check box displays and is selected by default. Without this Custom Setting, the checks sort by Invoice Date and Invoice Number.
APChecks BegCheckPasswordProtect Yes This setting adds a feature so that overwriting the Beginning Check # field is password protected. So if someone overrides the check number field, in order for the change to take place, the User will need to enter a password. The password is the same as the Reprint AP Check Password store in AP Defaults.
APInvoices AllowInactiveJob Yes This custom setting allows you to include inactive jobs when importing AP invoices in the expanded format. It is used in conjunction with the existing customer setting APInvoices | UseExpandedImport | Yes which enables the expanded import format.
APInvoices CCAlways Yes AP Invoices
This setting defaults the Payment Method to Credit Card when importing AP Invoices.
APInvoices ImportPermHold No This setting removes the Permanent Hold check box when creating invoices through the Import Invoices feature.
APInvoices ImportPO True This setting writes the Purchase Order number into the Notes field on the AP Invoice whenever using the AP Invoice Import program. For more information see Importing AP Invoices.
APInvoices PRLimitCheck “amount to check” This setting is valid only if the Company Setup State is PR and the Vendor is a ‘Taxable’ Vendor (check box on the payments tab). With this setting in place, the system will displays a message to the User that “This Vendor is subject to 7% Withholding.” as soon as it finds that the vendor has invoices and payments totaling more than the “amount” entered in the value field of the setting. To figure this, the system will look at all AP Invoices for the Calendar Year that the Invoice Date falls under, and it looks at all AP Payments that are marked as “Apply to Expenses” (since these would not be checks paying for invoices and the system has to look at all of these payments as well). If these previous invoices/payments totaled more than the amount in the setting, you will get receive the “This Vendor is subject to 7% Withholding."message.
Note that the system will not start displaying the message until all previous activity for the year (invoices and payments) total more than what is in the custom setting. If that one invoice you are entering is going to throw them over the limit, you will not receive the message on that one. It will be the next invoice (or AP Payment-Applied to Expenses) that is entered.
APInvoices ValidateInvoiceDate Yes This setting forces the invoice date to be within the To and From dates set in System Fiscal Year Setup (Accounts Payable). Without this setting, the invoice date can be before the To date, but it cannot be after the From date.
APNACHA CompanyID <number to transmit> This setting is used in conjunction with the APNACHA Immediate Origin custom setting. It controls the Company Code included in the NACHA Direct Deposit file for Accounts Payable (there are a separate set of custom settings for Payroll).
APNACHA CompanyIDforGLCashAccountXXXX

Note:  The XXXX portion of this item represents your General Ledger account number



 <ACH ID> This setting controls the Company Code included in the NACHA Direct Deposit file for Accounts Payable (there are a separate set of custom settings for Payroll).
APNACHA CPR TRUE This setting is used when the ARP option on the form is selected. If this setting is in place then a CPR (Controlled Payment Reconciliation) format is used for the creation of the ARP (Acct Recon Program) file. The file contains checks that will be clearing the bank for this cash acct. This does override the custom setting for any ARP format (APNACHA,NACHAReportName). In other words, the CPR format "wins".
APNACHA CreditAlways TRUE AP Report: NACHA Bank Transmission
This setting excludes the credit entry in the NACHA file which creates what the bank calls an "unbalanced file". It suppresses the creation of Number 6 record that would have been an off-setting debit total entry.
APNACHA IdentificationNumber <unique number assigned by the bank> This setting replaces the Federal Tax ID that is included in the header record in the NACHA file with the number set in the value of this parameter. This is done for security reasons.
APNACHA ImmediateDestination <routing number> This setting uses the number set in the value of this custom setting as the routing number in the header of the NACHA file instead of the number stored in each detail record.
APNACHA ImmediateDestinationforGLCashAccountXXXX

Note:  The XXXX portion of this item represents your General Ledger account number

 <routing number> This setting allows you to designate different routing numbers for different GL accounts. When creating files, the system uses the routing number that matches the GL account being processed.

Note: Print Checks still uses the Transit Routing Number listed on the Cash Accounts Set Up screen.
APNACHA ImmediateOrigin <number to transmit> This setting works in conjunction with the APNACHA Company ID setting. It controls the Immediate Origin code included in the NACHA Direct Deposit file for Accounts Payable (there are a separate set of custom settings for Payroll). The value you enter should be the entire number you want to transmit (this includes your Fed ID Number).

Example:  If you need to show a '2' in front of your Federal ID number, you would enter a value of 2456123456.
APNACHA NACHAReportName <ARP identifier> AP Report: NACHA Bank Transmission
There are several NACHA formats than can be used. For a complete list of values that may be used, see NACHA Bank Transmission Report for a list of ARP identifiers.
APNACHA NACHAReportName BOAFixed Creates NACHA Bank Transmission Report in the Fixed Length format required by Bank of America.
APNACHA NACHAReportName RegionsCSV Creates NACHA Bank Transmission Report in the .CSV format required by Regions Bank.
APNACHA PrefixforFederalID <0-9 or a space> This setting allows a number (the value of this custom setting) to display in front of the Federal ID number when using the Use Federal ID in Header option.
APNACHA DiscretionaryAccount #### This custom setting is for any client using the JPM Chase Bank web platform.
It allows the client to add a discretionary bank account number (up to 20 digits) to the NACHA file. It must be right justified and 0 filled.
APNACHA DiscretionaryAccountForGLCashAccountXXXX Account Number This custom setting allows you to create NACHA reports for multiple accounts without changing the value of the discretionary account custom setting (APNACHA | DiscretionaryAccount | Account Number.) This allows you to create multiple custom settings and enter a different account number for each general ledger number. When this setting is enabled, the NACHA file overrides the discretionary account with the discretionary account for the general ledger number used to create the file.
APNACHA SuppressCompanyName Yes This custom setting is for any client using the JPM Chase Bank web platform.
It suppresses the company name from the NACHA file on records 1 and 5. The company name displays as spaces.
APNACHA Suppress0DollarChecks True This setting suppresses 0 dollar amount checks from the electronic file and report.
APNACHA TraceNumber XXXXXXXXXX This setting allows the bank (BOA) to enter a trace number.
APNACHA UseDiffCompany <CO Number> This setting forces the system to use the federal tax ID and company name and number for the value entered in the custom setting to override what it would normally choose for these fields.
APUpdateRecurring UseFullSSN Yes For those AP invoices created through the Update to Invoice Entry program using Type: Payroll Other Deductions, we mask the social security number for Memo Line 1, leaving only the last 4 digits visible in the Invoice and therefore on the AP Check. If this setting is in place, the system will show the full social security number in Memo Line 1.
LaserAP1099 PrintInstructionsSeperately

Important:  You must include the spelling error in the item of this custom setting for it to work correctly.

 True This setting forces the instructions to print on a separate page when the 1099 Vendor Report is printed.
LaserAPCheck APCheckLimitAmount <dollar amount limit> This setting allows you to exclude checks from the batch print/reprint process when the checks are equal to or over the dollar amount limit set in the value. The over limit checks also do not include a signature.

This custom setting makes the Exclude Signature Limit Checks check box visible on the AP: Print Checks screen. This check box is selected by default, which excludes any check with an amount greater than or equal to the limit from the batch process. If you clear the check box, the over limit checks print first (without a signature), followed by the rest of the checks (with a signature). If you want to include a signature on all checks (even over the limit checks), use the LaserAPCheck | IncludeSignatureOverLimit | Yes custom setting.
LaserAPCheck IncludeSignatureOverLimit Yes When this custom setting is used signatures print on all checks, even checks over the limit set in the LaserAPCheck | APCheckLimitAmount | Yes custom setting.

When printing and reprinting checks, the checks are grouped into batches with over limit checks first and then all other checks. Within the batches, the checks are in alphabetical order by Vendor Name.
LaserAPCheck PrintVendorNameFirst Yes This setting puts the vendor’s name before the word Attention on the check.
LaserAPCheck SuppressCheckNumber Yes AP: Print Checks
This setting applies to the Standard-2 Part Stub check layout using MICR (where you print the check numbers).
This setting is used to suppress the check number from printing in the top right-hand corner of each of the 2 check stubs.