Page 10125 "Posted Bank Rec. Worksheet" (US)

US country layer · Microsoft.Bank.Reconciliation · BC29-30 · source at ea08af5e · facts from BC29

An object of the US localization, not part of W1.

Properties

Property	Value
Caption	Posted Bank Rec. Worksheet
SourceTable	Posted Bank Rec. Header
PageType	Document

Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control’s own, else the bound field’s (marked).

Group	Control	Shows	ToolTip
General	Bank Account No.	`Rec."Bank Account No."`	Specifies the code for the bank account the reconciliation applies to.
	Statement No.	`Rec."Statement No."`	Specifies the statement number to be reconciled.
	Statement Date	`Rec."Statement Date"`	Specifies the as-of date of the statement. All G/L balances will be calculated based upon this date.
	G/L Balance (LCY)	`Rec."G/L Balance (LCY)"`	Specifies the G/L balance for the assigned account number, based on the G/L Bank Account No. field.
	G/L Balance	`Rec."G/L Balance"`	Specifies the general ledger balance for the assigned account number.
	+ Positive Adjustments	`Rec."Positive Adjustments" - Rec."Negative Bal. Adjustments"`	Specifies the total amount of positive adjustments for the bank statement.
	Subtotal	`Rec."G/L Balance" + (Rec."Positive Adjustments" - Rec."Negative Bal. Adjustments")`	Specifies a subtotal amount for the posted worksheet. The subtotal is calculated by using the general ledger balance and any positive or negative adjustments.
	- Negative Adjustments	`Rec."Negative Adjustments" - Rec."Positive Bal. Adjustments"`	Specifies the total of the negative adjustment lines for the bank statement.
	Ending G/L Balance	`Rec."G/L Balance" + (Rec."Positive Adjustments" - Rec."Negative Bal. Adjustments") + (Rec."Negative Adjustments" - Rec."Positive Bal. Adjustments")`	Specifies the sum of values in the G/L Balance field, plus the Positive Adjustments field, minus the Negative Adjustments field. This is what the G/L balance will be after the bank reconciliation worksheet is posted and the adjustments are posted to the general ledger.
	Difference	`(Rec."G/L Balance" + (Rec."Positive Adjustments" - Rec."Negative Bal. Adjustments") + (Rec."Negative Adjustments" - Rec."Positive Bal. Adjustments")) - ((Rec."Statement Balance" + Rec."Outstanding Deposits") - Rec."Outstanding Checks")`	Specifies the difference between the Amount field and the Cleared Amount field.
	Cleared With./Chks. Per Stmnt.	`Rec."Cleared With./Chks. Per Stmnt."`	Specifies the total of the cleared withdrawals/checks for the statement being reconciled.
	Cleared Inc./Dpsts. Per Stmnt.	`Rec."Cleared Inc./Dpsts. Per Stmnt."`	Specifies the total of the cleared increases/deposits for the statement being reconciled.
	Balance on Statement	`Rec."Statement Balance"`	Specifies the amount entered by the operator from the balance found on the bank statement.
	+ Outstanding Deposits	`Rec."Outstanding Deposits"`	Specifies the total of outstanding deposits of type Increase for the bank statement.
	Subtotal	`Rec."Statement Balance" + Rec."Outstanding Deposits"`	Specifies a subtotal amount for the posted worksheet. The subtotal is calculated by using the general ledger balance and any positive or negative adjustments.
	- Outstanding Checks	`Rec."Outstanding Checks"`	Specifies the total of outstanding check withdrawals for the bank statement.
	Ending Balance	`(Rec."Statement Balance" + Rec."Outstanding Deposits") - Rec."Outstanding Checks"`	Specifies the sum of values in the Balance on Statement field, plus the Outstanding Deposits field, minus the Outstanding Checks field.
Checks	ChecksSubForm	part Posted Bank Rec. Chk Lines Sub	—
Deposits/Transfers	DepositsSubForm	part Posted Bank Rec. Dep Lines Sub	—
Adjustments	AdjustmentsSubForm	part Posted Bank Rec. Adj Lines Sub	—
Control Info	Bank Account No.2	`Rec."Bank Account No."`	Specifies the code for the bank account the reconciliation applies to.
	Statement No.2	`Rec."Statement No."`	Specifies the statement number to be reconciled.
	Currency Code	`Rec."Currency Code"`	Specifies the currency code assigned to the bank account.
	Currency Factor	`Rec."Currency Factor"`	Specifies currency conversions when posting adjustments for bank accounts with a foreign currency code assigned.
	Statement Date2	`Rec."Statement Date"`	Specifies the as-of date of the statement. All G/L balances will be calculated based upon this date.
	No. Printed	`Rec."No. Printed"`	Specifies the number of times the statement has been printed.
	Date Created	`Rec."Date Created"`	Specifies a date automatically populated when the record is created.
	Time Created	`Rec."Time Created"`	Specifies the time created, which is automatically populated when the record is created.
	Created By	`Rec."Created By"`	Specifies the User ID of the person who created the record.

Actions

Group	Action	ToolTip	Runs
Bank Rec.	Comments	View comments that apply.	Page “Bank Comment Sheet”
	Card	Open the card for the bank account that is being reconciled.	Page 370 “Bank Account Card”
Processing	Print	Prepare to print the document. A report request window for the document opens where you can specify what to include on the print-out.
	Find entries…	Find all entries and documents that exist for the document number and posting date on the selected entry or document.

Procedures

SetupRecord()

Plus 1 local procedures.

Triggers

OnAfterGetRecord, OnNewRecord

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "page", object_name: "Posted Bank Rec. Worksheet"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A US country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.