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) 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:
|
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
APCheck | LimitAmountAsterisks | Yes
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. |