View source | View content page | Page history | Printable version   

Projects:OpenBalances/Technical Documentation

Contents

Technical Documentation

Functional Description

When browsing an open balance (for example for receivables account) in the ledger, we can see all entries related to that account and time range.

Having tons of entries some times makes it really difficult to understand where the outstanding amount (open balance) comes from.

Having an option to hide those entries which have already been debited and credited (are no longer open items) can really help to understand where an open balance comes from. User would like to map the open balance for receivables with the outstanding invoices that have not yet been paid.


Scope

This project revisits financial flow to link accounting entries one to another. Holding that info is required to exclude not open balances in the ledger.

This projects puts in place an infrastructure to be able to manage open balances per account, so that any other account can use it in future implementations.

Configuration

There is no particular configuration required to use this piece of functionality.

There is a new process which can be scheduled called:

Record_ID2 Filling

This process revisits accounting entries trying to populate required info. It sets both link and balancing date for historical records.

Implementation

There are two new fields in Fact_Acct table:

Accounting processes needs to be revisited for:

when booking against invoice:

when booking against invoice:

when booking against payment:

when booking against transaction:

when booking against invoice:

when booking against payment:

when booking against transaction:

Table Structure

Fact_Acct table

Fact_Acct
Column Name Type Length Comments
RECORD_ID2 VARCHAR 32 The ID WHICH LINKS ONE ENTRY TO ANOTHER.
DATEBALANCED DATE HOLDS THE DATE ON WHICH THE BALANCE WAS OFFSET

Retrieved from "http://wiki.openbravo.com/wiki/Projects:OpenBalances/Technical_Documentation"

This page has been accessed 747 times. This page was last modified on 28 April 2014, at 11:18. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.