SAP Business One B1 Advance Pro Training Course

Download and install the SAP virtual machine on a standalone laptop or PC, gain offline access for one month, and connect SAP to SQL in the virtual environment.

Explore creating a manufacturing company assignment in SAP Business One, including opening balances and moving from small accounting to ERP with Ragweed Mill, a textile producer.

Create a new company in SAP Business One by specifying the company name and database, choosing the US chart of accounts, configuring 2021 posting periods, and setting a compliant password.

Configure currency in system initialization before starting the company assignment. Set the base currency and system currency (for example us dollars) to enable reports and avoid reinitializing the company.

Explore the level of accounts and how to edit existing ledgers within a chart of accounts, covering the four-level structure for assets, liabilities, equity, revenue, and currency updates.

Create a new ledger by selecting the base ledger, triggering new configuration with ctrl+e, and entering a structured code sequence under McBee Bank with automatic currency detection.

Learn to delete a chart of accounts in SAP Business One by filtering to a ledger in the chart of accounts and deleting it carefully due to linked documents.

Learn to customize the chart of accounts by creating, editing, and renaming ledgers, updating currencies, and aligning assets, liabilities (long term and current), equity, and manufacturing inventory.

Configure GL account determination to set opening balances by linking assets, liabilities, and equity, and use an equity adjustment account to reveal discrepancies and ensure balances reconcile.

Enter opening balances in SAP Business One GL accounts by selecting accounts, entering local currency amounts, and using minus signs for credits, while noting control accounts and currency checks.

Rectify errors in COA opening balances by configuring currencies and correcting entries. Use remaining balances or reverse the full adjustment with negative entries to ensure accurate reconciliations.

Manage business partner master data in SAP Business One by creating customers and suppliers, using find and create modes, entering balances, linking accounts receivable, and safely deleting inactive records.

Import hundreds of customers and vendors into SAP business one using ACP and excel data by preparing, formatting, and mapping fields, then save as text format and run the import.

Learn how to back up a company in SAP by connecting to the database, right-clicking, and selecting backup. Lecture notes discuss backup locations, file naming, and transaction versus complete backups.

Learn how to remove business partners in SAP using the cleanup wizard, selecting customers and vendors, transferring them to removal, executing the cleanup, and confirming no matching records are found.

Learn to re-import business partners in SAP Business One by using the BP custom template, correcting template columns, and verifying imports before proceeding to balances.

Enter opening balances for customers and suppliers in SAP Business One, with equity adjustment preselected and vendor grouping options. Verify totals in accounts receivable and accounts payable, noting inventory remains.

Configure a raw material item by creating a new inventory item, setting type to raw material, selecting the raw material group, and using meter as the unit.

Learn how to reconfigure price lists in SAP Business One, including setting cost price, base price list, and price factors, while managing currency and rounding methods.

Pre-configure the gl system setting to item group from the administration tab, under system initialization and journal settings, general settings, inventory, so item group appears by default and reduces errors.

Duplicate the last inventory record to create new raw material items, update the code, name, and cost base, then set unit of measure and item group, and enter opening balances.

Open the SAP opening balances for raw material inventory items dated January 1, 2021, select all items, set price source to cost base, and assign the equity adjustment account.

Create finished goods in item master data with procurement set to make, planning set to none, and cost left blank because the recipe determines the cost.

Define the bill of materials as the one item recipe for finished goods, detailing steps and materials like cloth, thread, and buttons, and linking finished goods to raw materials.

Execute outgoing payments for non-trading activities in SAP Business One using the banking module to settle accrued expenses, generate journal entries, and distinguish trading from non-trading transactions.

Enter a raw materials purchase order in SAP Business One, configure document numbering, select Sitara textiles, enter 40,000 units at 150 each with tax exempt, noting it doesn't affect accounts.

Convert partial or full purchase orders to invoices in SAP Business One by using the customize option to transfer selected items, adjust quantities, and post the background journal entry.

Change the date format sequence in SAP Business One from month-day-year to day-month-year in the display settings, and optionally switch the separator from slash to dash to avoid date issues.

Enter and process purchase invoices for raw materials in sap, including vendor setup, manual document numbering, posting date versus document date, and recording debits to raw materials with related liabilities.

Configure default tax code determination to automatically apply exempt codes based on item or service, item group, and business area using export determination rules.

Transfer funds between accounts using the banking model with outgoing payments and cash on hand, then preview journal entries and save drafts to support the audit trail.

Process partial incoming payments from customers in SAP Business One. Learn to apply partial balances and post the cash on hand against receivables, with correct journal entries.

Learn how to record purchase of services on credit in SAP Business One, including service invoices, cost of goods sold for services, currency and tax handling, and journal entry preview.

Learn to record cash payments for services from a vendor in SAP Business One, using an outgoing payment from banking and posting to cost of goods sold for services.

Record a sales order against customer advances by recognizing advances as a liability, linking the customer advances account, and using the relationship map to connect the order, invoice, and payment.

Configure the MCP bank in SAP Business One by creating the bank in settings, linking it to the ledger and a branch, and setting up the dual account.

Configure bank and record two cheque payments: travel expenses and office building maintenance, with separate entries due to different dates and cheque numbers; review outgoing payments and journal entry previews.

record a Suzuki pickup purchase through the bank using outgoing payments, assign to the motor vehicles cost account, and process a 50,000 check payment via MCP Bank.

Track the end-to-end creation of finished goods from raw materials by planning and releasing production orders, calculating material needs from the recipe, and applying backflush accounting.

Learn how to handle bad debts in SAP by reconciling customer balances, settling invoices against write-offs, and using manual reconciliation to create journal entries that reduce receivables.

Convert a sales order to a sales invoice in SAP Business One, applying prior advances and invoicing only the remaining balance while updating dates and revenue accounts.

Record a direct sale in SAP by adding an invoice for shirts, adjusting exempt cost, and posting journal with debit to cost of goods sold and credit to finished goods.

Convert a sealed order to a sealed invoice in SAP by retrieving the order and copying it to an invoice, then review the journal entry and relationship map.

Record a partial cash receipt in SAP Business One using the add in sequence feature to allocate incoming payments across open invoices and generate the journal entry.

Learn to process partial payments by cheque to vendors in SAP Business One, configuring the bank (UBL) and recording cheque-based outgoing payments to vendors like Eden Sons.

Record a cash purchase of office equipment under the office equipment ledger, debit office equipment and credit cash on hand, using the banking area’s outgoing payments in SAP Business One.

This lecture demonstrates recording a partial cash repayment of a bank loan in SAP Business One using outgoing payments and cash on hand, with a journal entry preview before saving.

Process raw material purchase returns in SAP Business One using copy from credit memo to select a single item, review the journal entry, and check the relationship map.

Enter a sales return of finished goods in SAP Business One B1 Advance Pro training course, processing 200 of 500 units, and posting inventory and cost of goods sold entries.

Process a director's cash withdrawal for personal use in SAP Business One by recording an outgoing payment from banking, selecting a drawing and related equity accounts.

Learn to record raw material losses in SAP Business One using inventory counting, post the variance to cost of sales, and verify the journal entry for inventory gains or losses.

Record January expenses as accrued expenses in SAP Business One using journal entries to reflect utilities, rent, and salaries in the correct month and P&L.

explains blanket agreements in sap business one b1, defining vendor-specific, time-bound pricing with quantity and discount terms, and demonstrates setup, posting periods, and applying prices to items such as motherboard.

Raise a purchase quotation from a purchase request by selecting a new or existing vendor, forwarding for prices, and entering quantities and prices upon reply, updating status.

Convert a partial purchase quotation to a purchase order by transferring conditions to selected items, including multiple vendors, while examining the relationship map of linked orders.

Learn how to convert multiple purchase orders into a single good receipt bill in SAP Business One, selecting orders and handling inventory and temporary liability.

Learn how to process a goods return in the SAP purchase module: identify faulty items, initiate returns from a good receipt, and reverse liabilities while clearing inventory.

Celebrate finishing the SAP Business One B1 Advance Pro Training Course by applying the learned tools in your professional and personal life, and leave a review to help others.