control reports

What is the main function of the Payment Wizard?

To create outgoing and incoming payments in batches for bank transfers, checks, and bills of exchange[cite: 530].

Which incoming payment type can the Payment Wizard create?

Incoming bank transfer payments[cite: 533].

Which outgoing payment types can the Payment Wizard create?

Checks and bank transfer payments[cite: 534].

What status must A/P or A/R documents have to be included in a Payment Wizard run?

Not fully paid, credited, or reconciled, including unallocated payments on account[cite: 535, 536].

What can the Payment Wizard generate for electronic payments like bank transfers?

Payment files in specific, country-dependent formats[cite: 537].

What is a 'Payment Order Run' in the Payment Wizard?

A run that creates a bank file but does not post JEs or close invoices immediately, awaiting bank confirmation[cite: 538, 539, 540].

What are the main steps when running the Payment Wizard?

1. Start & Load Saved Run, 2. General Parameters, 3. BP Selection, 4. Document Parameters, 5. Payment Method Selection, 6. Recommendations, 7. Save Options, 8. Execution Summary [cite: 555-561].

What is defined in the 'General Parameters' step of the Payment Wizard?

Next run date, payment type (in/out), payment means (check/transfer), minimum amounts, series for payments[cite: 558].

What does the 'Recommendations' step present?

A list of proposed payments based on the criteria, which the user can modify or approve[cite: 562, 563].

What does the 'Non-Included Transactions' button show?

Open items that met initial criteria but were excluded from the final recommendations[cite: 565].

What does 'Save Selection Criteria Only' do?

Saves the wizard setup without reserving the transactions[cite: 590, 591].

What does 'Save Recommendations' do?

Saves the setup and the proposed payments, reserving the involved open transactions for this specific run[cite: 592, 593].

How is a saved Payment Wizard run (with recommendations) cancelled?

Select the run in the first step, right-click, and choose 'Cancel'[cite: 594].

Which execution option allows scheduling the Payment Wizard run for a later time?

Execute Payment Run on Server[cite: 599].

How are multiple invoices for one BP usually handled by the Payment Wizard?

Consolidated into a single payment, unless 'Single Payment' is selected in the BP master data[cite: 614, 615].

What tool is used to define or modify bank file formats?

Electronic File Manager (EFM) add-on[cite: 617, 618].

What must be done after printing checks generated by the Payment Wizard?

Confirm the check numbers using the 'Check Number Confirmation' function[cite: 620, 621].

What setup item primarily controls the Payment Wizard's process and rules?

Payment Methods setup[cite: 663].

What is defined within a 'Payment Method'?

Type (In/Out), Means (Check/Transfer), House Bank, Validations, File Format, Interim Accounts (optional) [cite: 664-670].

How do you assign specific Payment Methods to a Business Partner?

On the 'Payment Run' tab in BP Master Data, check the 'Include' box for desired methods[cite: 719, 720].

Where are vendor bank details entered for use in Payment Wizard bank transfers?

In the BP Master Data, Payment Terms tab, under Bank details[cite: 729, 730].

What is the SAP Business One term for reconciling the company's bank G/L with the bank's statement?

External Reconciliation[cite: 3520].

What is the goal of External Reconciliation?

To match transactions recorded in the SAP B1 house bank G/L account against the external bank statement[cite: 3517].

What status are transactions given after successful External Reconciliation?

Externally reconciled[cite: 3536].

What does Internal Reconciliation achieve within SAP Business One?

Matching and clearing open debits against open credits within the same SAP B1 account (G/L or BP)[cite: 2374].

Is Internal Reconciliation the same as External Reconciliation?

No. Internal matches items within SAP B1; External matches SAP B1 items to an outside statement[cite: 3539].

What are the 3 distinct tools/functions for performing External Reconciliation?

1. Reconciliation function, 2. Manual Reconciliation function, 3. Bank Statement Processing (BSP)[cite: 3571].

Which external reconciliation function involves importing/entering statement lines first, then matching side-by-side with G/L entries?

Reconciliation function[cite: 3589, 3590].

Which external reconciliation function uses the bank statement's ending balance as the target for clearing G/L entries?

Manual Reconciliation function[cite: 3606, 3608].

Which external reconciliation function automates payment creation and reconciliation based on imported bank files?

Bank Statement Processing (BSP)[cite: 3630, 3633].

Which two external reconciliation functions are supported in all localizations?

Reconciliation function and Bank Statement Processing (BSP)[cite: 3588, 3635].

What is the typical 2-step process for Incoming Payments via Cash, Check, or Credit Card?

1. Incoming Payment (posts to Clearing Account). 2. Deposit (moves from Clearing Account to Bank Account)[cite: 3757, 3768].

Which Incoming Payment means typically bypasses the Clearing Account and posts directly to the Bank Account?

Bank Transfer[cite: 3781, 3782].

What document is used to transfer funds from 'Cash on Hand' or 'Checks Received' to the Bank Account G/L?

Deposit document[cite: 4050, 4082].

What does an asterisk (*) indicate next to an invoice in the Payment document?

The invoice is due or overdue based on the payment's posting date[cite: 3906, 3907].

What is 'Payment on Account' used for?

Recording a payment amount that isn't applied to any specific open invoice or transaction listed[cite: 4010, 4011].

Can a single payment be made using multiple methods (e.g., part cash, part check)?

Yes, via the Payment Means window accessible from the payment document[cite: 4029, 4030].

How does the default posting for Outgoing Payments (Check/Transfer) usually differ from Incoming Payments (Check/Cash)?

Outgoing Payments often credit the Bank Account G/L directly, whereas Incoming often use a Clearing Account first[cite: 4119, 4120].

What is the standard JE for an Outgoing Payment paying an A/P Invoice?

Debit Vendor account, Credit Bank account[cite: 4117, 4118].

How can you manually make an Outgoing Payment post to a clearing account?

Enter the clearing G/L account code in the 'G/L Account' field within the Payment Means window[cite: 4121, 4122].

What is the primary function of the Cash Flow report?

It's a forecast report showing expected incoming and outgoing cash transactions to assess liquidity[cite: 786, 788].

What does the 'Security Level' in the Cash Flow report indicate?

The probability or certainty that a forecasted transaction will result in actual cash movement[cite: 805, 806].

Which component has the highest security level in the Cash Flow report?

Cash (actual balances in bank and cash G/L accounts)[cite: 809].

Which components generally have the lowest security level in the Cash Flow report?

Customer Forecast and Vendor Forecast (based on open orders, drafts, etc.)[cite: 810, 811].

How does the Cash Flow report typically organize its data?

By Security Level within defined Time Intervals (days, weeks, months)[cite: 847, 848].

What are 'Projected Postings' in the Cash Flow report criteria?

Manually entered future transactions (not yet in SAP B1) to include in the forecast[cite: 912, 913].

How does the Cash Flow Forecast report differ visually from the standard Cash Flow report?

The Forecast report is graphical (bar and line charts) and instantly updates with criteria changes [cite: 968-972].

What is the Statement of Cash Flow?

A formal, often legally required, financial report categorizing cash movements (operating, investing, financing)[cite: 987].

What is the main purpose of the Dunning Wizard?

To create and send reminder letters to customers with overdue invoices[cite: 3193, 3194, 3195].

Besides letters, what can the Dunning Wizard automatically generate and post?

Service Invoices for interest and/or dunning fees[cite: 3198, 3199].

Where are Dunning Terms (levels, intervals, fees, interest) defined?

Administration -> Setup -> Business Partners -> Dunning Terms[cite: 3248, 3249].

How does the system determine which dunning level applies to an overdue invoice?

Based on the 'Effective After (Days)' setting for each level, relative to the due date or previous dunning date[cite: 3255, 3256, 3257].

Where is a specific Dunning Term assigned to a customer?

In the Business Partner Master Data, on the Payment Terms tab[cite: 3403, 3404].

Can the Dunning Wizard show open A/P items for a vendor connected to the customer being dunned?

Yes, if the 'Consider Connected Vendors' option is selected[cite: 3440, 3443].

What does the Customer Receivables Aging report show?

Open (unreconciled) customer transactions, typically A/R invoices, categorized by how long they are overdue[cite: 2939].

What is the 'Aging Date' used for in the Aging reports?

It's the reference date for calculating how many days/months/periods transactions are overdue[cite: 3004].

What does the 'Future Remit' column display in the Aging reports?

The balance of open transactions whose due date is after the specified Aging Date[cite: 3010].

Can the Customer Receivables Aging report include open balances for a vendor connected to that customer?

Yes, by selecting the 'Consider Connected Vendors' checkbox in the report criteria[cite: 3053, 3054].

Which standard financial report shows a company's Assets, Liabilities, and Equity at a specific point in time?

Balance Sheet[cite: 169].

Which standard financial report lists the debit, credit, and ending balance for G/L accounts (and optionally BPs) over a selected period?

Trial Balance[cite: 271].

Which standard financial report shows Revenues minus Expenses to calculate Profit or Loss for a selected period?

Profit and Loss Statement[cite: 365].

What is the fundamental equation represented by the Balance Sheet?

Total Assets = Total Liabilities + Equity[cite: 228, 229].

Which Chart of Accounts drawers are included in the Balance Sheet?

Assets, Liabilities, Equity (Capital + Reserves)[cite: 107, 178].

Which Chart of Accounts drawers are primarily included in the Profit and Loss Statement?

Revenues (Turnover), Cost of Sales, Expenses (Operating Costs), Financing (Non-Operating), Other Revenues/Expenses (Tax + Extr.)[cite: 107].

Which types of accounts are included in the Trial Balance?

All account types (Balance Sheet and Profit and Loss)[cite: 281].

For a complete period, what should the total balance (Debits - Credits) of a Trial Balance including all accounts be?

Zero[cite: 329, 330].

How is the current period's profit/loss incorporated into the Balance Sheet report before year-end closing?

It's calculated dynamically ('profit period') and included within the Equity section[cite: 231].

Can you drill down from financial reports to see underlying G/L account details or BP master data?

Yes, using the golden link arrows[cite: 403, 404].

What are the two ways journal entries can be created in SAP B1?

Automatically via documents (e.g., invoices, payments) or manually entered by a user[cite: 1067, 1081].

Where are all posted journal entries stored?

In the Journal Entries file[cite: 1099].

What shortcut displays the G/L account list in a JE line?

Tab key[cite: 1187].

What shortcut displays the Business Partner list in a JE line?

CTRL + Tab[cite: 1187].

What are the two methods for reversing a journal entry?

Standard Reverse Transaction (swaps Dr/Cr) or Reverse Transaction with Negative Amounts [cite: 1213-1215].

Which reversal method avoids inflating account turnover totals?

Reverse Transaction with Negative Amounts[cite: 1265].

Where is the option to 'Allow Negative Amounts for Reversal Transaction Posting' set?

Company Details -> Basic Initialization tab[cite: 1289, 1290].

How can you schedule a JE to be automatically reversed on a future date?

Check the 'Reverse' box in the JE header and enter the desired reversal date[cite: 1344, 1345].

What tool is used for JE templates where amounts are calculated based on percentages?

Posting Templates[cite: 1541].

What tool is used for JE templates with fixed amounts posted on a regular schedule?

Recurring Postings[cite: 1466].

How often can Recurring Postings be scheduled?

Daily, Weekly, Monthly, Quarterly, Semi-annually, Annually, or One Time[cite: 1499].

What is the main purpose of a Journal Voucher?

To save manual journal entries as drafts for later review, correction, or posting[cite: 1625, 1633].

Can an unbalanced JE be saved in a Journal Voucher?

Yes[cite: 1633].

How are the entries in a Journal Voucher made permanent?

By selecting the voucher and choosing 'Post Voucher'[cite: 1706].

What report allows viewing and posting Journal Vouchers or individual entries within them?

Journal Voucher Report[cite: 1747, 1748].

What is the primary posting period defined for a company?

The Fiscal Year[cite: 1794, 1804].

What are the standard options for Sub-Periods within a Fiscal Year?

Year, Quarters, Months, Days[cite: 1857].

What determines the Posting Period / Sub-Period for a transaction?

The transaction's Posting Date[cite: 1810, 1830].

What is a key restriction when defining the start date of a fiscal year?

Must be the first day of a month[cite: 1875, 1876].

What are the four statuses available for a Posting Period?

Unlocked, Unlocked Except Sales, Closing Period, Locked [cite: 2184-2196].

Which Posting Period status allows posting only by specifically authorized users?

Closing Period[cite: 2193, 2194].

What is the main objective of the Period-End Closing utility?

To zero out P&L account balances and transfer the net result to Retained Earnings[cite: 1994, 2002, 2097].

How many JEs are created per P&L account by the Period-End Closing utility?

Two[cite: 2130].

What is the 'Origin' code for JEs created by Period-End Closing?

BC (Balance Carried Forward)[cite: 2161].

What action should be taken regarding Posting Period status after year-end closing is complete?

Change the status of the closed periods to 'Locked'[cite: 2003, 2102].

What does 'Internal Reconciliation' match?

Open debits and credits within the same SAP B1 account (G/L or BP)[cite: 2374].

Paying an invoice with a payment document is an example of what kind of reconciliation?

Automatic System Internal Reconciliation[cite: 2383, 2384].

What is 'Partial Reconciliation'?

When reconciled debit/credit amounts are unequal, leaving a remaining balance due[cite: 2444, 2446].

Which interim accounts are often automatically system-reconciled?

Allocation Account, Expense Clearing Account, Stock in Transit, WIP Inventory Account[cite: 2455, 2456].

When is Manual User Reconciliation typically necessary?

When payments are made 'On Account' or don't automatically match specific documents[cite: 2515, 2518].

What are the 3 types of User Reconciliation?

Manual, Automatic, Semi-automatic[cite: 2543].

What does the 'Multiple BPs' option in Manual Reconciliation allow?

Reconciling transactions between different BP codes (e.g., connected customer/vendor)[cite: 2547, 2548].