Here you can search through the pages of this Namespace, their attachments and the files uploaded to the system.
Note: the results will only display the items you have permissions to read.
General Information
Default Menu Location : Maintain >> Accounts Payable >> Bank Reconciliation Screen Name : BANKREC Function : The Bank Reconciliation screen provides an interface to reconcile Adjutant AP and AR transactions to your bank's current balance.
The Bank Rec screen may also be used to enter Manual Cash Adjustments.
Filters
The Filter tab of the Bank Rec screen controls [...]
[...] Backup files when screen is loaded,don't backup after each reload. BANKRECBANKASOF - Prevents the bank balance from changing for transactions cleared in dates beyond the As Of date when running Bank Reconciliation in As Of mode. BANKRECBPURGE - Adds a button that will allow the user to purge selected (cleared) items in bank reconciliation. The new button allows records to be purged at user convenience, rather than at the same time of clearing. This new Turning on this option will hide the "Purge Cleared" checkbox [...]
[...]
General Information Default Menu Location Maintain >> System >> Rule Maintenance
Function The Bank Reconciliation Import Format holds the valid Bank Rec Import format codes used in the 'Bank Integration' tab. Each Bank Integration format must be custom developed [...]
[...] are defined once in the Checking Accounts screen. Other information entered on this screen such as Bank Name, Address, Routing Number, and Account Number may be printed on the check. The next check number that Adjutant will use is also defined on the System Cash/Checking Accounts screen.
Please note that the Next Check Number number may be changed at any time!!! You can change it while printing checks, or you can change the counter on the Checking Accounts screen.
It is THE USER'S RESPONSIBILITY to make sure the next check number matches up with the first check [...]
[...] blank and the deposit flag is blank, the record will be imported as an open credit. f11 - BankDepNum - Bank deposit number. This is used to group and sort Cash Receipts reporting, as well as Bank Reconciliation. f12 - ClearDate - Bank Reconciliation cleared date. If a date is filled in, the record will be marked as cleared in Bank Reconciliation. f13 - SNote - Cash Receipt note f14 - CRTtype - Cash Receipt Type. Valid Cash Receipt type names from the CASHRECTYPE rule should be used. [...]
[...] current/liquid accounts first to the least current/liquid accounts. Current assets generally include cash, bank accounts, accounts receivables, inventory, supplies, and prepaid expenses. These accounts have normal debit balances. The second range of account numbers will generally be the property, plant, and equipment. These accounts include land, buildings, equipment, vehicles, and accumulated depreciation for those assets. These accounts have normal debit balances. The third range of account numbers are current liabilities accounts. These accounts include accounts payable, [...]
[...] Locks/disables the GL Acct field when a stock item is entered onto a PO. POLOCKWHSE - Locks/disables the Rec Whse field on Purchase Order line items. All lines will be received into the warehouse listed on the PO Header. POLOTPROJPHASE - If option is enabled, and item has PONOISLOTNO attribute, use PO-PROJ#-PHASE as lotnumber. PONOISLOTNO - Automatically assigns the PO# as the Lot # when receiving lot controlled items. PONOTEMPLATE - If set, the template box is disabled. POPRINTALLOC - Report option to PO receipt screen. New PORECALLOC report only shows linked SO lines [...]
[...] will specify the name of the file that is generated. Format - This is currently built to handle Amegy Bank's format. Contact your consultant to discuss what is needed to generate a format for your specific bank. Default Email - Here you can specify a default email for the file to be sent to; the process will only send to this email address if there is no AP contact associated to the Company receiving the check payment. Checking Accounts: Next, navigate to the Checking Accounts screen, and add the ACH information to the GL Account you [...]
[...] generate a Positive Pay .csv file based on check payments made in the system that can be sent to a bank.
Once generated, the Positive Pay csv file will be saved in the AP_PP_Exports folder contained in the Adjutant Folder. Format There are three formats used: OLDPP - The traditional positive pay format containing transaction type, routing number, check date, number, amount and vendor. NEWPP - The new format containing the account number, routing info, check number, date, amount, a check code (320 for active check, 370 for voided), and the vendor. ATPP - [...]
[...] once a day when bankrec is loaded. This data can be used to find the source of the floating book and bank balance issues. BANKRECNEWBOOK - Option to switch between old and new book and bank logic (BANKRECNEWBOOK), default is old logic. BANKRECPURGEC - BANKRECPURGEC CHANGEDISCACCT - Enables pop-up window on AP Invoice and Cash Receipt screen to allow user to change default discount given/taken GL account. DOCLINK - Documents in document vault are stored as links (paths on workstation or network) instead of embedded into SQL database. [...]
[...] will override the previous two defaults. Adj Acct: If making an adjustment to an invoice (bad debt, bank fees, write-off, etc), enter the offsetting account to use for the adjustment. ID: Select the customer making payment from the drop down box. (Typing the first letter will filter the list) Ref #: Enter a reference number for the cash receipt; this may be the check number. Amount: Enter the amount of the payment. Bank [...]
[...] orders. This screen is also frequently accessed from the Purchase Orders screen by clicking the PO Rec button. PO Receipt Screen
How To Receive
Enter the purchase order number in the PO Number field. Enter a Packing List number in the PL # field. Enter the quantities received for each line item and any required serial/lot numbers. For lines that require several serial/lot numbers, the import function can be used. Enter the warehouse receiving the items in the Whse field. Do not save the PO Receipt until you have entered the quantity received for each line [...]
[...] Open: The quantity that hasn't been received. Automatically populated as the items are received. Qty Rec: The quantity that has been received. Automatically populated as the items are received. Required Date: The date the items are required for receipt. Disc %: The percentage the items will be discounted, if any. Unit: The unit of measure for the quantity ordered. Unit Cost: The price of one unit of the item. This will default to the last cost received per the vendor. Recv Date: The date the items were received. Est Date: The estimated date of receipt. [...]
[...] Locks/disable the GL Acct field when a stock item is entered onto a PO. POLOCKWHSE - Locks/disable the Rec Whse field on Purchase Order line items. All lines will be received into the warehouse listed on the PO header. PONOTEMPLATE - If set, the template box is disabled. POQUALVEND - POQUALVEND POQUOTECOST - Uses Quoted Cost, instead of Last Cost, from vendor on all PO's. PORECFAST - Opens the quick PO receipt screen when clicking the PO Receipt icon on the PO screen. PORECUPSOCOST - Automatically updates the Sales Order line item cost for SO line items that are linked [...]
[...] For/Whse Qty Allocated: Quantity allocated (open sales orders) based on Owner/Held For/Whse Last Rec: Date of the last PO receipt for the items based on for Owner/Held For/Whse Usage: Average usage of the items (per week) based on Owner/Held For/Whse ProBin: Bin number in which the items to be stocked based on Owner/Held For/Whse. Items produced on Build For Stock work orders will go into this bin by default. PWOBin: Bin number in which the items to be stocked based on Owner/Held For/Whse. Stocked items produced on regular work orders (ones linked to a sales [...]
[...] factor. f13 - QtyRec - Quantity previously received for the associated line item. The Line Items screen Rec Amt value will show the calculated received amount based on the total of received items at the purchase cost, UNTIL the line item screen is edited. After editing, the Rec [...]
[...] orders. This screen is also frequently accessed from the Purchase Orders screen by clicking the PO Rec button. How To Receive
Enter the purchase order number in the PO Number field. Select a line and enter the qty received in the Qty - field Do not save the PO Receipt until you have entered the quantity received for each line item. PO Receipts will update the average cost of stock items based on the cost and quantity of the item received.
Data Fields & Buttons
Item Search - Allows searching of items on specified PO for easy locating and receiving. Once [...]
[...] checking/cash account when Approving AP Invoices and Printing AP Checks. Also the default account in the Bank Rec. [...]
[...] checking/cash account when Approving AP Invoices and Printing AP Checks. Also the default account in the Bank Rec. [...]
[...] POCOILLOTCHKWHSE - Option to prevent duplicate lot numbers (any item, any whse). POLOCKWHSE - Locks/disables the Rec Whse field on Purchase Order line items. All lines will be received into the warehouse listed on the PO Header. PORECCHGWHSE - Allows you to change the receiving warehouse during a PO Receipt. POSPLITTAX - Split tax out on itemact record if POSPLITTAX is enabled. POSWITCHWHSE - Automatically updates all PO line items with new Receiving Warehouse when it is changed on the PO Header. POTEMPWHSE - Add new temp whse field to POREC screen. If filled in, items are received [...]
[...] Auto Apply Cash Receipts screen allows the user to upload Lockbox or ACH/Wire 820 files from their bank and match them up to invoices received to automatically apply the cash to invoices. Currently integration has been done with 5/3 bank. [...]
[...] Open: The quantity that hasn't been received. Automatically populated as the items are received. Qty Rec: The quantity that has been received. Automatically populated as the items are received. Required Date: The date the items are required for receipt. Disc %: The percentage the items will be discounted, if any. Unit: The unit of measure for the quantity ordered. Unit Cost: The price of one unit of the item. Recv Date: The date the items were received. Est Date: The estimated date of receipt. Rec [...]
[...] Items)
Purchase Order pomo Vend # custno Vendor Name company Ord Value qtyord * cost Rec Value qtyrec * cost Open Balance (qtyord [...]
[...] Carton 71 reprintC0 PrntCLbl Reprint Carton Label 72 itemswap SwapItem Item Swap 73 recmaster PO Rec PO Receipt 74 soload0 SO Load SO Loading [...]
[...] Cash Receipts: AR Cash Receipts and Applied Credits from the organization. Search by Invoice number, Bank Deposit number, and Cash Receipt Notes. [...]
[...] Maintenance Function The AP ACH Data rule controls the ACH format details and the link to the AP Bank G/L Account. This rule also holds the base [...]
[...] Payable Account Pay Invoice:
Debit to the Accounts Payable Account
Credit to the Cash in Bank Account
When a stock item is received, the [...]
[...] f14 - CkType - Check type. Common entry is C for check, or M for manual f15 - ClearDate - Sets the Bank Reconciliation clear date, and marks the check [...]
[...] Group' dropdown, select the Process Group of securities you wish to update (Address Book, Accounts Rec, Accounts Pay, etc). STEP 3: Select [...]
[...] serialized or lot controlled item in Adjutant.
Process
1. On the Purchase Order screen, click the PO Rec button.
2. Select a the line that you [...]
