I am designing the app which required the Chart of Accounts (finance cost centre). I want to basically to have a flexibility for any business models.
So far I found that any business models (industry) can have:
1. Manufacturing Services:
XX - XXX - XXX - XXX - XXX - XXX - XXX
Company - Cost Centre - Account - Product - Product Line - Sub Account
2. Distribution (News)
XX - XXX - XX - XX - XXX
Division - Account - Region - Story - Distribution
XXX - XXXX - XX - XXXX - XX
Company - Accounts - Department - Projects - Project Type
My understanding that each XX can be considered as SEGMENTS.
1. I can have tables which containing 15 SEGEMENTS .... the assumption I won't the company has more than 15 SEGMENTS.
2. Or make it dynamically which is having ParentID/ID relationshi into a single SEGMENT table.
Some consideration ... in the transaction table I will record the full code of segment for instance AAA-123-XXX-123-70303. Also, considering for reporting, do the roll up report for instance for company/division/business units.
This is not accounting software though ... it's just a billing but require chart of account.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …