The purpose of this page is to help you defend the balance sheet balances that exist for open balance accounts. There are two primary ways to accomplish this task. One shows you a real-time dashboard and supporting details of your balances. The second requires you to reconcile offsetting entries after the fact - say as part of a month close process. Each method has it pluses and minuses.
Installation
Open theERP Academy SCM repository. Note, you will need a username/password if you have not already requested one.
Find the BSD repository
Click on the 'Source' link at the bottom of the page.
Click on the downloads folder
Download all the files in this folder (or even better, simply clone the repository)
Execute the "Create BSD Records" process to populate the temporary tables
Open the BSD windows
Note: running this process changes the BSD values for everyone. Therefore, only one person should be responsible for running the "Create BSD Records" process.
Update 20170511 - Please Read
The BSD has moved to the ERP Academy SCM repository. There are two major changes to the BSD as of this verson:
The window is much much faster because the data is held in pre-calculated temporary tables.
I broke apart the windows into different categories so that you do not see everything in one long list. For example, you can see all your bank accounts in the "BSD Summary -Bank" window.
Update 20160811 - Please Read
You no longer need to update the accounts for a new client. I have updated the views to automatically detect your client's accounting schemas and accounts.
2014-09-09 AM - Balance Sheet Defense Discussion
Introduction
0:00:30 Controller's needs when defending the balance sheet, open balance accounts
0:01:00 black box diagram
0:01:45 define "open balance"
0:03:00 list of balance sheet open balance accounts (NIR, IC, API, APP, ARI, ARR, BIT, and Bank)
0:11:15 Two options for defending balance sheet open balance totals (today: BSD, Thursday: Account Recon)
0:11:45 BSD Summary
Create simple example - Qty: 1
0:12:30 Create PO
0:14:15 Create, Complete and Post MR (NIR) - Review BSD Summary
0:15:30 Explain difference between "Amt GL Schema" and "Trial Balance Schema" columns
0:17:00 Introduce BSD Detail window - show NIR details
0:20:30 Create, Complete and Post Vendor Invoice (IC and API) - Review BSD Summary
0:22:15 View Matched Invoice/Receipt to see how NIR and IC balances were cleared
0:23:30 Explain difference between "Amt Doc Source" and "Amt Doc Schema"
0:24:45 Create, Complete and Post an AP Payment against Invoice - Review BSD Summary
0:26:30 Note that GardenWorld's banks all share the same GL Account (BAD). This is why BIT is now out of balance for both bank accounts.
0:27:45 Allocation cleared the invoice API and the paymetn's APP.
0:29:15 Create, Complete and Post Bank Statement to move cash from BIT to Bank - Review BSD Summary
0:30:30 Clear existing transactions to start from scratch.
0:32:00 Quick discuss "Suspense Balance" and "Currency Balance" accounts in BSD Summary
0:32:30 Repeat the above scenario where you leave MR Qty unmatched - said another way - invoice only some of the MR's Qty.
0:33:45 Create PO and MR
0:34:45 NOTE: there was an issue here!!!
When I used the MR's "Generate Invoice from Receipt" process, it put the wrong Price List at the Vendor Invoice header.
When I changed the Qty of the Vendor Invoice line, it changed the price from $15 to $23 because the header had the wrong Price List.
I have an action to fix the code and submit it to the core iDempiere code base.
0:37:00 Is IPV (Invoice Price Variance) an Open Balance?
0:40:15 BSD Detail for NIR
0:42:00 Repeat the above scenario with a EUR (Euro multi-currency) PO and Vendor Invioce
0:42:00 Create a EUR Price list
0:43:15 Create and Complete a EUR PO
0:44:15 Create, Complete and Post a MR - Review BSD Summary and BSD Detail
0:46:45 Create, Complete and Post the EUR Vendor Invoice - Review BSD Summary
0:48:00 Note that "Amt Doc Source" can be a combination of multiple currencies. This fact makes the total a little erroneous.
0:49:30 Note: do not change a Currency Rate that has already been used. Changes include either (1) changing the existing rate, or (2) creating a new rate that has an effective date in the past.
0:51:30 Quick discussion of Inventory Clearing (IC).
0:54:30 BSD is best used when starting from your first transaction.
0:56:00 Using BSD for EOM - End of Month closing processes
0:57:00 No historical version of the BSD Summary and Detail - coming at some point.
0:01:30 Start from scratch - re-install the database using RUN_ImportIdempiere.sh. This will blow away all changes and bring the DB back to its state the day we installed the server.
0:05:15 Create new Client for our test
0:10:15 Review functions SQL
0:15:00 Download scripts so that we can modify them for our new client
0:17:00 Install the functions sql
0:17:15 Modify the BSD_Views_Detail.sql file to use IDs from our new client - Account IDs
0:23:30 Execute the BSD Audit scripts
0:23:45 Download and install the Pack In
0:30:15 How to create the BSD in ADempiere
0:31:00 OOOOOPS - forgot to update the BSD_Views_Detail.sql to include the updated C_DocType_IDs for the new client
0:37:00 Discuss and create Inventory BSD query
Be aware that this discussion is detailed and long.
Also be aware that you will learn how products relate to costing method relate to Cost element relate to the accounting schema