fix(webapp): use the server formatted value

Bumps [axios](https://github.com/axios/axios) from 0.20.0 to 1.6.0.
- [Release notes](https://github.com/axios/axios/releases)
- [Changelog](https://github.com/axios/axios/blob/v1.x/CHANGELOG.md)
- [Commits](https://github.com/axios/axios/compare/v0.20.0...v1.6.0)

---
updated-dependencies:
- dependency-name: axios
  dependency-type: direct:production
...

Signed-off-by: dependabot[bot] <support@github.com>
Co-authored-by: dependabot[bot] <49699333+dependabot[bot]@users.noreply.github.com>

.all-contributorsrc

@@ -60,6 +60,15 @@
       "contributions": [
         "bug"
       ]
+    },
+    {
+      "login": "kochie",
+      "name": "Robert Koch",
+      "avatar_url": "https://avatars.githubusercontent.com/u/10809884?v=4",
+      "profile": "https://me.kochie.io",
+      "contributions": [
+        "code"
+      ]
     }
   ],
   "contributorsPerLine": 7,

.env.example

@@ -8,7 +8,7 @@ MAIL_FROM_NAME=
 MAIL_FROM_ADDRESS=
 
 # Database
-DB_HOST=mysql
+DB_HOST=localhost
 DB_USER=bigcapital
 DB_PASSWORD=bigcapital
 DB_ROOT_PASSWORD=root

.gitpod.yml

@@ -0,0 +1,22 @@
+tasks:
+  - name: Init
+    init: |
+      pnpm install &&
+      cp .env.example .env &&
+      docker-compose up -d &&
+      pnpm run build:server &&
+      node packages/server/build/commands.js system:migrate:latest
+    command: | 
+      docker-compose up -d &&
+      pnpm run dev
+
+ports:
+  - port: 4000
+    visibility: public
+    onOpen: open-preview
+  - port: 3000
+    visibility: public
+    onOpen: ignore
+  - port: 3306
+    visibility: public
+    onOpen: ignore

CONTRIBUTING.md

@@ -33,7 +33,8 @@ Contributions via pull requests are much appreciated. Once the approach is agree
 ---
 
 ## Local Setup Prerequisites
- - The application currently supports **Node.js v14.x**. Please ensure that you are using this version of Node.js when developing. (use [nvm](https://github.com/nvm-sh/nvm#installing-and-updating) to switch between node versions)
+  - The application currently supports **Node.js v18.x**.
+  - `pnpm` packages manager, (from pnpm [guide](https://pnpm.io/installation) pick any installation method).
 
 ## Contribute to Backend
 
@@ -44,11 +45,10 @@ Contributions via pull requests are much appreciated. Once the approach is agree
 cp .env.example .env
 ```
 
-- Install all npm dependencies of the monorepo, you don't have to change directory to the `backend` package. just hit these command on root directory and it will install dependencies of all packages.
+- Install all npm dependencies of the monorepo, you don't have to change directory to the `backend` package. just hit the command on root directory and it will install dependencies of all packages.
 
 ```
-npm install
+pnpm install
-npm run bootstrap
 ```
 
 - Run all required docker containers in the development, we already configured all containers under `docker-compose.yml`.
@@ -69,7 +69,7 @@ cefa73fe2881   bigcapital-redis   "docker-entrypoint.s…"   7 seconds ago   Up
 - There're some CLI commands we should run before running the server like databaase migration, so we need to build the `server` app first.
 
 ```
-npm run build:server
+pnpm run build:server
 ```
 
 - Run the database migration for system database.
@@ -87,7 +87,7 @@ Batch 1 run: 6 migrations
 - Next, start the webapp application.
 
 ```
-npm run dev:server
+pnpm run dev:server
 ```
 
 **[`^top^`](#)**
@@ -105,14 +105,13 @@ git clone https://github.com/bigcapital/bigcapital.git && cd bigcaptial
 - Install all npm dependencies of the monorepo, you don't have to change directory to the `frontend` package. just hit that command and will install all packages across all application.
 
 ```
-npm install
+pnpm install
-npm run bootstrap
 ```
 
 - Next, start the webapp application.
 
 ```
-npm run dev:webapp
+pnpm run dev:webapp
 ```
 
 **[`^top^`](#)**

README.md

@@ -37,6 +37,31 @@ Bigcapital is a smart and open-source accounting and inventory software, Bigcapi
   <img src="https://raw.githubusercontent.com/abouolia/blog/main/public/screenshot-3.png" width="270">
 </p>
 
+# Getting Started
+
+We've got serveral options on dev and prod depending on your need to get started quickly with Bigcapital.
+
+## Self-hosted 
+
+Bigcapital is available open-source under AGPL license. You can host it on your own servers using Docker.
+
+### Docker
+
+To get started with self-hosted with Docker and Docker Compose, take a look at the [Docker guide](https://docs.bigcapital.ly/deployment/docker).
+
+## Development
+
+### Local Setup
+
+To get started locally, we have a [guide to help you](https://github.com/bigcapitalhq/bigcapital/blob/develop/CONTRIBUTING.md).
+
+### Gitpod
+
+- Click the Gitpod button below to open this project in development mode.
+- This will open and configure the workspace in your browser with all the necessary dependencies.
+
+[![Open in Gitpod](https://gitpod.io/button/open-in-gitpod.svg)](https://gitpod.io/new/#https://github.com/bigcapitalhq/bigcapital)
+
 # Resources
 
 - [Documentation](https://docs.bigcapital.ly/) - Learn how to use.
@@ -80,6 +105,7 @@ Thanks goes to these wonderful people ([emoji key](https://allcontributors.org/d
       <td align="center" valign="top" width="14.28%"><a href="https://scheibling.se"><img src="https://avatars.githubusercontent.com/u/24367830?v=4?s=100" width="100px;" alt="Lars Scheibling"/><br /><sub><b>Lars Scheibling</b></sub></a><br /><a href="https://github.com/bigcapitalhq/bigcapital/issues?q=author%3Ascheibling" title="Bug reports">🐛</a></td>
       <td align="center" valign="top" width="14.28%"><a href="https://github.com/suhaibaffan"><img src="https://avatars.githubusercontent.com/u/18115937?v=4?s=100" width="100px;" alt="Suhaib Affan"/><br /><sub><b>Suhaib Affan</b></sub></a><br /><a href="https://github.com/bigcapitalhq/bigcapital/commits?author=suhaibaffan" title="Code">💻</a></td>
       <td align="center" valign="top" width="14.28%"><a href="https://github.com/KalliopiPliogka"><img src="https://avatars.githubusercontent.com/u/81677549?v=4?s=100" width="100px;" alt="Kalliopi Pliogka"/><br /><sub><b>Kalliopi Pliogka</b></sub></a><br /><a href="https://github.com/bigcapitalhq/bigcapital/issues?q=author%3AKalliopiPliogka" title="Bug reports">🐛</a></td>
+      <td align="center" valign="top" width="14.28%"><a href="https://me.kochie.io"><img src="https://avatars.githubusercontent.com/u/10809884?v=4?s=100" width="100px;" alt="Robert Koch"/><br /><sub><b>Robert Koch</b></sub></a><br /><a href="https://github.com/bigcapitalhq/bigcapital/commits?author=kochie" title="Code">💻</a></td>
     </tr>
   </tbody>
 </table>

lerna.json

@@ -1,6 +1,7 @@
 {
   "$schema": "node_modules/lerna/schemas/lerna-schema.json",
+  "version": "independent",
+  "npmClient": "pnpm",
   "useWorkspaces": true,
-  "version": "0.9.6",
+  "packages": ["packages/*"]
-  "npmClient": "npm"
 }

package.json

@@ -2,7 +2,6 @@
   "name": "bigcapital-monorepo",
   "private": true,
   "scripts": {
-    "bootstrap": "lerna exec npm install",
     "dev": "lerna run dev",
     "build": "lerna run build",
     "dev:webapp": "lerna run dev --scope \"@bigcapital/webapp\"",
@@ -13,10 +12,6 @@
     "test:e2e": "playwright test",
     "prepare": "husky install"
   },
-  "workspaces": [
-    "packages/*",
-    "shared/*"
-  ],
   "devDependencies": {
     "@commitlint/cli": "^17.4.2",
     "@commitlint/config-conventional": "^17.4.2",
@@ -27,7 +22,7 @@
     "lerna": "^6.4.1"
   },
   "engines": {
-    "node": "14.x"
+    "node": "16.x || 17.x || 18.x"
   },
   "husky": {
     "hooks": {

packages/server/.gitignore

@@ -1,7 +1,6 @@
 /node_modules/
 /.env
 /storage
-package-lock.json
 stdout.log
 /dist
 /build

packages/server/Dockerfile

@@ -1,4 +1,4 @@
-FROM node:14.20-alpine as build
+FROM node:18.16.0-alpine as build
 
 USER root
 
@@ -83,15 +83,25 @@ WORKDIR /app
 
 RUN chown node:node /
 
+# Install pnpm 
+RUN npm install -g pnpm
+
 # Copy application dependency manifests to the container image.
 COPY ./package*.json ./
+COPY ./pnpm-lock.yaml ./pnpm-lock.yaml
+COPY ./pnpm-workspace.yaml ./pnpm-workspace.yaml
+COPY ./lerna.json ./lerna.json
 COPY ./packages/server/package*.json ./packages/server/
 
-COPY ./lerna.json ./lerna.json
+# Install application dependencies
+RUN apk update
+RUN apk add python3 build-base chromium
 
-# Install app dependencies for production.
+# Set PYHTON env
-RUN npm install
+ENV PYTHON=/usr/bin/python3
-RUN npm run bootstrap
+
+# Install packages dependencies for production.
+RUN pnpm install
 
 COPY --chown=node:node ./packages/server ./packages/server
 

packages/server/package.json

@@ -1,6 +1,6 @@
 {
   "name": "@bigcapital/server",
-  "version": "0.10.0",
+  "version": "0.10.2",
   "description": "",
   "main": "src/server.ts",
   "scripts": {
@@ -31,10 +31,11 @@
     "agendash": "^3.1.0",
     "app-root-path": "^3.0.0",
     "async": "^3.2.0",
-    "axios": "^0.20.0",
+    "axios": "^1.6.0",
     "babel-loader": "^9.1.2",
     "bcryptjs": "^2.4.3",
     "bluebird": "^3.7.2",
+    "body-parser": "^1.20.2",
     "compression": "^1.7.4",
     "country-codes-list": "^1.6.8",
     "cpy": "^8.1.2",
@@ -42,7 +43,7 @@
     "crypto-random-string": "^3.2.0",
     "csurf": "^1.10.0",
     "deep-map": "^2.0.0",
-    "deepdash": "^5.3.7",
+    "deepdash": "^5.3.9",
     "dotenv": "^8.1.0",
     "errorhandler": "^1.5.1",
     "es6-weak-map": "^2.0.3",
@@ -72,6 +73,8 @@
     "memory-cache": "^0.2.0",
     "moment": "^2.24.0",
     "moment-range": "^4.0.2",
+    "moment-timezone": "^0.5.43",
+    "mongodb": "^6.1.0",
     "mongoose": "^5.10.0",
     "mustache": "^3.0.3",
     "mysql": "^2.17.1",
@@ -92,11 +95,13 @@
     "rate-limiter-flexible": "^2.1.14",
     "reflect-metadata": "^0.1.13",
     "rtl-detect": "^1.0.4",
+    "source-map-loader": "^4.0.1",
     "ts-transformer-keys": "^0.4.2",
     "tsyringe": "^4.3.0",
     "typedi": "^0.8.0",
     "uniqid": "^5.2.0",
-    "winston": "^3.2.1"
+    "winston": "^3.2.1",
+    "xlsx": "^0.18.5"
   },
   "devDependencies": {
     "@types/lodash": "^4.14.158",
@@ -131,7 +136,7 @@
     "rimraf": "^3.0.2",
     "rtlcss": "^3.3.0",
     "run-script-webpack-plugin": "^0.1.1",
-    "sass": "^1.37.5",
+    "sass": "^1.58.0",
     "sinon": "^7.4.2",
     "start-server-webpack-plugin": "^2.2.5",
     "ts-loader": "^9.4.2",

packages/server/resources/locales/en.json

@@ -587,6 +587,7 @@
   "balance_sheet.long_term_liabilities": "Long-Term Liabilities",
   "balance_sheet.non_current_liabilities": "Non-Current Liabilities",
   "balance_sheet.equity": "Equity",
+  "balance_sheet.net_income": "Net Income",
 
   "balance_sheet.account_name": "Account name",
   "balance_sheet.total": "Total",

packages/server/src/api/controllers/FinancialStatements/APAgingSummary.ts

@@ -2,19 +2,20 @@ import { Router, Request, Response, NextFunction } from 'express';
 import { query } from 'express-validator';
 import { Inject } from 'typedi';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
-import APAgingSummaryReportService from '@/services/FinancialStatements/AgingSummary/APAgingSummaryService';
 import BaseFinancialReportController from './BaseFinancialReportController';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
+import { APAgingSummaryApplication } from '@/services/FinancialStatements/AgingSummary/APAgingSummaryApplication';
 
 export default class APAgingSummaryReportController extends BaseFinancialReportController {
   @Inject()
-  APAgingSummaryService: APAgingSummaryReportService;
+  private APAgingSummaryApp: APAgingSummaryApplication;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -28,8 +29,9 @@ export default class APAgingSummaryReportController extends BaseFinancialReportC
 
   /**
    * Validation schema.
+   * @returns {ValidationChain[]}
    */
-  get validationSchema() {
+  private get validationSchema() {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('as_date').optional().isISO8601(),
@@ -49,42 +51,58 @@ export default class APAgingSummaryReportController extends BaseFinancialReportC
   }
 
   /**
-   * Retrieve payable aging summary report.
+   * Retrieves payable aging summary report.
+   * @param {Request} req -
+   * @param {Response} res -
+   * @param {NextFunction} next -
    */
-  async payableAgingSummary(req: Request, res: Response, next: NextFunction) {
+  private async payableAgingSummary(
-    const { tenantId, settings } = req;
+    req: Request,
+    res: Response,
+    next: NextFunction
+  ) {
+    const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
     try {
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+      // Retrieves the json table format.
+      if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
+        const table = await this.APAgingSummaryApp.table(tenantId, filter);
 
-      switch (acceptType) {
+        return res.status(200).send(table);
-        case 'application/json+table':
+        // Retrieves the csv format.
-          const table = await this.APAgingSummaryService.APAgingSummaryTable(
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
-            tenantId,
+        const csv = await this.APAgingSummaryApp.csv(tenantId, filter);
-            filter
+
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.send(csv);
+        // Retrieves the xlsx format.
+      } else if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
+        const buffer = await this.APAgingSummaryApp.xlsx(tenantId, filter);
+
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
         );
-          return res.status(200).send({
+        res.setHeader(
-            table: {
+          'Content-Type',
-              rows: table.rows,
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
-              columns: table.columns,
+        );
-            },
+        return res.send(buffer);
-            meta: table.meta,
+        // Retrieves the json format.
-            query: table.query,
+      } else {
-          });
+        const sheet = await this.APAgingSummaryApp.sheet(tenantId, filter);
-          break;
-        default:
-          const { data, columns, query, meta } =
-            await this.APAgingSummaryService.APAgingSummary(tenantId, filter);
 
-          return res.status(200).send({
+        return res.status(200).send(sheet);
-            data: this.transfromToResponse(data),
-            columns: this.transfromToResponse(columns),
-            query: this.transfromToResponse(query),
-            meta: this.transfromToResponse(meta),
-          });
-          break;
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/ARAgingSummary.ts

@@ -5,16 +5,18 @@ import ARAgingSummaryService from '@/services/FinancialStatements/AgingSummary/A
 import BaseFinancialReportController from './BaseFinancialReportController';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { ARAgingSummaryApplication } from '@/services/FinancialStatements/AgingSummary/ARAgingSummaryApplication';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 @Service()
 export default class ARAgingSummaryReportController extends BaseFinancialReportController {
   @Inject()
-  ARAgingSummaryService: ARAgingSummaryService;
+  ARAgingSummaryApp: ARAgingSummaryApplication;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -30,7 +32,7 @@ export default class ARAgingSummaryReportController extends BaseFinancialReportC
   /**
    * AR aging summary validation roles.
    */
-  get validationSchema() {
+  private get validationSchema() {
     return [
       ...this.sheetNumberFormatValidationSchema,
 
@@ -52,41 +54,53 @@ export default class ARAgingSummaryReportController extends BaseFinancialReportC
 
   /**
    * Retrieve AR aging summary report.
+   * @param {Request} req
+   * @param {Response} res
    */
-  async receivableAgingSummary(req: Request, res: Response) {
+  private async receivableAgingSummary(req: Request, res: Response) {
-    const { tenantId, settings } = req;
+    const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
     try {
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
 
-      switch (acceptType) {
+      const acceptType = accept.types([
-        case 'application/json+table':
+        ACCEPT_TYPE.APPLICATION_JSON,
-          const table = await this.ARAgingSummaryService.ARAgingSummaryTable(
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
-            tenantId,
+        ACCEPT_TYPE.APPLICATION_CSV,
-            filter
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+      // Retrieves the xlsx format.
+      if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
+        const buffer = await this.ARAgingSummaryApp.xlsx(tenantId, filter);
+
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
         );
-          return res.status(200).send({
+        res.setHeader(
-            table: {
+          'Content-Type',
-              rows: table.rows,
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
-              columns: table.columns,
+        );
-            },
+        return res.send(buffer);
-            meta: table.meta,
+        // Retrieves the table format.
-            query: table.query,
+      } else if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
-          });
+        const table = await this.ARAgingSummaryApp.table(tenantId, filter);
-          break;
-        default:
-          const { data, columns, query, meta } =
-            await this.ARAgingSummaryService.ARAgingSummary(tenantId, filter);
 
-          return res.status(200).send({
+        return res.status(200).send(table);
-            data: this.transfromToResponse(data),
+        // Retrieves the csv format.
-            columns: this.transfromToResponse(columns),
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
-            query: this.transfromToResponse(query),
+        const buffer = await this.ARAgingSummaryApp.csv(tenantId, filter);
-            meta: this.transfromToResponse(meta),
+
-          });
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
-          break;
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.send(buffer);
+        // Retrieves the json format.
+      } else {
+        const sheet = await this.ARAgingSummaryApp.sheet(tenantId, filter);
+
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       console.log(error);

packages/server/src/api/controllers/FinancialStatements/BalanceSheet.ts

@@ -3,25 +3,21 @@ import { Router, Request, Response, NextFunction } from 'express';
 import { query, ValidationChain } from 'express-validator';
 import { castArray } from 'lodash';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
-import BalanceSheetStatementService from '@/services/FinancialStatements/BalanceSheet/BalanceSheetService';
 import BaseFinancialReportController from './BaseFinancialReportController';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
-import BalanceSheetTable from '@/services/FinancialStatements/BalanceSheet/BalanceSheetTable';
+import { BalanceSheetApplication } from '@/services/FinancialStatements/BalanceSheet/BalanceSheetApplication';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 @Service()
 export default class BalanceSheetStatementController extends BaseFinancialReportController {
   @Inject()
-  balanceSheetService: BalanceSheetStatementService;
+  private balanceSheetApp: BalanceSheetApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -38,7 +34,7 @@ export default class BalanceSheetStatementController extends BaseFinancialReport
    * Balance sheet validation schecma.
    * @returns {ValidationChain[]}
    */
-  get balanceSheetValidationSchema(): ValidationChain[] {
+  private get balanceSheetValidationSchema(): ValidationChain[] {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('accounting_method').optional().isIn(['cash', 'accrual']),
@@ -84,10 +80,12 @@ export default class BalanceSheetStatementController extends BaseFinancialReport
 
   /**
    * Retrieve the balance sheet.
+   * @param {Request} req
+   * @param {Response} res
+   * @param {NextFunction} next
    */
-  async balanceSheet(req: Request, res: Response, next: NextFunction) {
+  private async balanceSheet(req: Request, res: Response, next: NextFunction) {
-    const { tenantId, settings } = req;
+    const { tenantId } = req;
-    const i18n = this.tenancy.i18n(tenantId);
 
     let filter = this.matchedQueryData(req);
 
@@ -95,29 +93,45 @@ export default class BalanceSheetStatementController extends BaseFinancialReport
       ...filter,
       accountsIds: castArray(filter.accountsIds),
     };
-
     try {
-      const { data, columns, query, meta } =
-        await this.balanceSheetService.balanceSheet(tenantId, filter);
-
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
 
-      const table = new BalanceSheetTable(data, query, i18n);
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+        ACCEPT_TYPE.APPLICATION_CSV,
+      ]);
+      // Retrieves the json table format.
+      if (ACCEPT_TYPE.APPLICATION_JSON_TABLE == acceptType) {
+        const table = await this.balanceSheetApp.table(tenantId, filter);
 
-      switch (acceptType) {
+        return res.status(200).send(table);
-        case 'application/json+table':
+        // Retrieves the csv format.
-          return res.status(200).send({
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
-            table: {
+        const buffer = await this.balanceSheetApp.csv(tenantId, filter);
-              rows: table.tableRows(),
+
-              columns: table.tableColumns(),
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
-            },
+        res.setHeader('Content-Type', 'text/csv');
-            query,
+
-            meta,
+        return res.send(buffer);
-          });
+        // Retrieves the xlsx format.
-        case 'json':
+      } else if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
-        default:
+        const buffer = await this.balanceSheetApp.xlsx(tenantId, filter);
-          return res.status(200).send({ data, columns, query, meta });
+
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+      } else {
+        const sheet = await this.balanceSheetApp.sheet(tenantId, filter);
+
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/CashFlow/CashFlow.ts

@@ -8,29 +8,20 @@ import {
   ValidationChain,
 } from 'express';
 import BaseFinancialReportController from '../BaseFinancialReportController';
-import CashFlowStatementService from '@/services/FinancialStatements/CashFlow/CashFlowService';
+import { AbilitySubject, ReportsAction } from '@/interfaces';
-import {
-  ICashFlowStatementDOO,
-  ICashFlowStatement,
-  AbilitySubject,
-  ReportsAction,
-} from '@/interfaces';
-import CashFlowTable from '@/services/FinancialStatements/CashFlow/CashFlowTable';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
+import { CashflowSheetApplication } from '@/services/FinancialStatements/CashFlow/CashflowSheetApplication';
 
 @Service()
 export default class CashFlowController extends BaseFinancialReportController {
   @Inject()
-  cashFlowService: CashFlowStatementService;
+  private cashflowSheetApp: CashflowSheetApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -47,7 +38,7 @@ export default class CashFlowController extends BaseFinancialReportController {
    * Balance sheet validation schecma.
    * @returns {ValidationChain[]}
    */
-  get cashflowValidationSchema(): ValidationChain[] {
+  private get cashflowValidationSchema(): ValidationChain[] {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('from_date').optional(),
@@ -67,41 +58,6 @@ export default class CashFlowController extends BaseFinancialReportController {
     ];
   }
 
-  /**
-   * Retrieve the cashflow statment to json response.
-   * @param {ICashFlowStatement} cashFlow -
-   */
-  private transformJsonResponse(cashFlowDOO: ICashFlowStatementDOO) {
-    const { data, query, meta } = cashFlowDOO;
-
-    return {
-      data: this.transfromToResponse(data),
-      query: this.transfromToResponse(query),
-      meta: this.transfromToResponse(meta),
-    };
-  }
-
-  /**
-   * Transformes the report statement to table rows.
-   * @param {ITransactionsByVendorsStatement} statement -
-   */
-  private transformToTableRows(
-    cashFlowDOO: ICashFlowStatementDOO,
-    tenantId: number
-  ) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const cashFlowTable = new CashFlowTable(cashFlowDOO, i18n);
-
-    return {
-      table: {
-        data: cashFlowTable.tableRows(),
-        columns: cashFlowTable.tableColumns(),
-      },
-      query: this.transfromToResponse(cashFlowDOO.query),
-      meta: this.transfromToResponse(cashFlowDOO.meta),
-    };
-  }
-
   /**
    * Retrieve the cash flow statment.
    * @param {Request} req
@@ -109,26 +65,52 @@ export default class CashFlowController extends BaseFinancialReportController {
    * @param {NextFunction} next
    * @returns {Response}
    */
-  async cashFlow(req: Request, res: Response, next: NextFunction) {
+  public async cashFlow(req: Request, res: Response, next: NextFunction) {
-    const { tenantId, settings } = req;
+    const { tenantId } = req;
     const filter = {
       ...this.matchedQueryData(req),
     };
 
     try {
-      const cashFlow = await this.cashFlowService.cashFlow(tenantId, filter);
-
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
 
-      switch (acceptType) {
+      const acceptType = accept.types([
-        case 'application/json+table':
+        ACCEPT_TYPE.APPLICATION_JSON,
-          return res
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
-            .status(200)
+        ACCEPT_TYPE.APPLICATION_CSV,
-            .send(this.transformToTableRows(cashFlow, tenantId));
+        ACCEPT_TYPE.APPLICATION_XLSX,
-        case 'json':
+      ]);
-        default:
+      // Retrieves the json table format.
-          return res.status(200).send(this.transformJsonResponse(cashFlow));
+      if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
+        const table = await this.cashflowSheetApp.table(tenantId, filter);
+
+        return res.status(200).send(table);
+        // Retrieves the csv format.
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
+        const buffer = await this.cashflowSheetApp.csv(tenantId, filter);
+
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.status(200).send(buffer);
+        // Retrieves the pdf format.
+      } else if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
+        const buffer = await this.cashflowSheetApp.xlsx(tenantId, filter);
+
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieves the json format.
+      } else {
+        const cashflow = await this.cashflowSheetApp.sheet(tenantId, filter);
+
+        return res.status(200).send(cashflow);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/CustomerBalanceSummary/index.ts

@@ -1,29 +1,21 @@
 import { Router, Request, Response, NextFunction } from 'express';
 import { query } from 'express-validator';
 import { Inject } from 'typedi';
-import {
+import { AbilitySubject, ReportsAction } from '@/interfaces';
-  AbilitySubject,
-  ICustomerBalanceSummaryStatement,
-  ReportsAction,
-} from '@/interfaces';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
-import CustomerBalanceSummary from '@/services/FinancialStatements/CustomerBalanceSummary/CustomerBalanceSummaryService';
 import BaseFinancialReportController from '../BaseFinancialReportController';
-import CustomerBalanceSummaryTableRows from '@/services/FinancialStatements/CustomerBalanceSummary/CustomerBalanceSummaryTableRows';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
+import { CustomerBalanceSummaryApplication } from '@/services/FinancialStatements/CustomerBalanceSummary/CustomerBalanceSummaryApplication';
 
 export default class CustomerBalanceSummaryReportController extends BaseFinancialReportController {
   @Inject()
-  customerBalanceSummaryService: CustomerBalanceSummary;
+  private customerBalanceSummaryApp: CustomerBalanceSummaryApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -42,7 +34,7 @@ export default class CustomerBalanceSummaryReportController extends BaseFinancia
   /**
    * Validation schema.
    */
-  get validationSchema() {
+  private get validationSchema() {
     return [
       ...this.sheetNumberFormatValidationSchema,
 
@@ -62,75 +54,67 @@ export default class CustomerBalanceSummaryReportController extends BaseFinancia
     ];
   }
 
-  /**
-   * Transformes the balance summary statement to table rows.
-   * @param {ICustomerBalanceSummaryStatement} statement -
-   */
-  private transformToTableRows(
-    tenantId,
-    { data, query }: ICustomerBalanceSummaryStatement
-  ) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const tableRows = new CustomerBalanceSummaryTableRows(data, query, i18n);
-
-    return {
-      table: {
-        columns: tableRows.tableColumns(),
-        data: tableRows.tableRows(),
-      },
-      query: this.transfromToResponse(query),
-    };
-  }
-
-  /**
-   * Transformes the balance summary statement to raw json.
-   * @param {ICustomerBalanceSummaryStatement} customerBalance -
-   */
-  private transformToJsonResponse({
-    data,
-    columns,
-    query,
-  }: ICustomerBalanceSummaryStatement) {
-    return {
-      data: this.transfromToResponse(data),
-      columns: this.transfromToResponse(columns),
-      query: this.transfromToResponse(query),
-    };
-  }
-
   /**
    * Retrieve payable aging summary report.
    * @param {Request} req -
    * @param {Response} res -
    * @param {NextFunction} next -
    */
-  async customerBalanceSummary(
+  private async customerBalanceSummary(
     req: Request,
     res: Response,
     next: NextFunction
   ) {
-    const { tenantId, settings } = req;
+    const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
     try {
-      const customerBalanceSummary =
+      const accept = this.accepts(req);
-        await this.customerBalanceSummaryService.customerBalanceSummary(
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+
+      // Retrieves the xlsx format.
+      if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
+        const buffer = await this.customerBalanceSummaryApp.xlsx(
           tenantId,
           filter
         );
-      const accept = this.accepts(req);
+        res.setHeader(
-      const acceptType = accept.types(['json', 'application/json+table']);
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieves the csv format.
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
+        const buffer = await this.customerBalanceSummaryApp.csv(
+          tenantId,
+          filter
+        );
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
 
-      switch (acceptType) {
+        return res.send(buffer);
-        case 'application/json+table':
+        // Retrieves the json table format.
-          return res
+      } else if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
-            .status(200)
+        const table = await this.customerBalanceSummaryApp.table(
-            .send(this.transformToTableRows(tenantId, customerBalanceSummary));
+          tenantId,
-        case 'application/json':
+          filter
-        default:
+        );
-          return res
+        return res.status(200).send(table);
-            .status(200)
+      } else {
-            .send(this.transformToJsonResponse(customerBalanceSummary));
+        const sheet = await this.customerBalanceSummaryApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/InventoryDetails/index.ts

@@ -8,24 +8,20 @@ import {
   ValidationChain,
 } from 'express';
 import BaseController from '@/api/controllers/BaseController';
-import InventoryDetailsService from '@/services/FinancialStatements/InventoryDetails/InventoryDetailsService';
-import InventoryDetailsTable from '@/services/FinancialStatements/InventoryDetails/InventoryDetailsTable';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
+import { InventortyDetailsApplication } from '@/services/FinancialStatements/InventoryDetails/InventoryDetailsApplication';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 @Service()
 export default class InventoryDetailsController extends BaseController {
   @Inject()
-  inventoryDetailsService: InventoryDetailsService;
+  private inventoryItemDetailsApp: InventortyDetailsApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -45,7 +41,7 @@ export default class InventoryDetailsController extends BaseController {
    * Balance sheet validation schecma.
    * @returns {ValidationChain[]}
    */
-  get validationSchema(): ValidationChain[] {
+  private get validationSchema(): ValidationChain[] {
     return [
       query('number_format.precision')
         .optional()
@@ -77,69 +73,66 @@ export default class InventoryDetailsController extends BaseController {
   }
 
   /**
-   * Retrieve the cashflow statment to json response.
+   * Retrieve the inventory item details sheet.
-   * @param {ICashFlowStatement} cashFlow -
-   */
-  private transformJsonResponse(inventoryDetails) {
-    const { data, query, meta } = inventoryDetails;
-
-    return {
-      data: this.transfromToResponse(data),
-      query: this.transfromToResponse(query),
-      meta: this.transfromToResponse(meta),
-    };
-  }
-
-  /**
-   * Transformes the report statement to table rows.
-   */
-  private transformToTableRows(inventoryDetails, tenantId: number) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const inventoryDetailsTable = new InventoryDetailsTable(
-      inventoryDetails,
-      i18n
-    );
-
-    return {
-      table: {
-        data: inventoryDetailsTable.tableData(),
-        columns: inventoryDetailsTable.tableColumns(),
-      },
-      query: this.transfromToResponse(inventoryDetails.query),
-      meta: this.transfromToResponse(inventoryDetails.meta),
-    };
-  }
-
-  /**
-   * Retrieve the cash flow statment.
    * @param {Request} req
    * @param {Response} res
    * @param {NextFunction} next
    * @returns {Response}
    */
-  async inventoryDetails(req: Request, res: Response, next: NextFunction) {
+  private async inventoryDetails(
-    const { tenantId, settings } = req;
+    req: Request,
+    res: Response,
+    next: NextFunction
+  ) {
+    const { tenantId } = req;
     const filter = {
       ...this.matchedQueryData(req),
     };
 
     try {
-      const inventoryDetails =
-        await this.inventoryDetailsService.inventoryDetails(tenantId, filter);
-
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+      // Retrieves the csv format.
+      if (acceptType === ACCEPT_TYPE.APPLICATION_CSV) {
+        const buffer = await this.inventoryItemDetailsApp.csv(tenantId, filter);
 
-      switch (acceptType) {
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
-        case 'application/json+table':
+        res.setHeader('Content-Type', 'text/csv');
-          return res
+
-            .status(200)
+        return res.send(buffer);
-            .send(this.transformToTableRows(inventoryDetails, tenantId));
+        // Retrieves the xlsx format.
-        case 'json':
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_XLSX) {
-        default:
+        const buffer = await this.inventoryItemDetailsApp.xlsx(
-          return res
+          tenantId,
-            .status(200)
+          filter
-            .send(this.transformJsonResponse(inventoryDetails));
+        );
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieves the json table format.
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_JSON_TABLE) {
+        const table = await this.inventoryItemDetailsApp.table(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(table);
+      } else {
+        const sheet = await this.inventoryItemDetailsApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/ProfitLossSheet.ts

@@ -1,24 +1,20 @@
 import { Service, Inject } from 'typedi';
 import { Router, Request, Response, NextFunction } from 'express';
 import { query, ValidationChain } from 'express-validator';
-import ProfitLossSheetService from '@/services/FinancialStatements/ProfitLossSheet/ProfitLossSheetService';
 import BaseFinancialReportController from './BaseFinancialReportController';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
-import { ProfitLossSheetTable } from '@/services/FinancialStatements/ProfitLossSheet/ProfitLossSheetTable';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
+import { ProfitLossSheetApplication } from '@/services/FinancialStatements/ProfitLossSheet/ProfitLossSheetApplication';
 @Service()
 export default class ProfitLossSheetController extends BaseFinancialReportController {
   @Inject()
-  profitLossSheetService: ProfitLossSheetService;
+  private profitLossSheetApp: ProfitLossSheetApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -34,7 +30,7 @@ export default class ProfitLossSheetController extends BaseFinancialReportContro
   /**
    * Validation schema.
    */
-  get validationSchema(): ValidationChain[] {
+  private get validationSchema(): ValidationChain[] {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('basis').optional(),
@@ -85,37 +81,54 @@ export default class ProfitLossSheetController extends BaseFinancialReportContro
    * @param {Request} req -
    * @param {Response} res -
    */
-  async profitLossSheet(req: Request, res: Response, next: NextFunction) {
+  private async profitLossSheet(
-    const { tenantId, settings } = req;
+    req: Request,
-    const i18n = this.tenancy.i18n(tenantId);
+    res: Response,
+    next: NextFunction
+  ) {
+    const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
-    try {
-      const { data, query, meta } =
-        await this.profitLossSheetService.profitLossSheet(tenantId, filter);
-
     const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
 
-      switch (acceptType) {
+    const acceptType = accept.types([
-        case 'application/json+table':
+      ACCEPT_TYPE.APPLICATION_JSON,
-          const table = new ProfitLossSheetTable(data, query, i18n);
+      ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+      ACCEPT_TYPE.APPLICATION_CSV,
+      ACCEPT_TYPE.APPLICATION_XLSX,
+    ]);
+    try {
+      // Retrieves the csv format.
+      if (acceptType === ACCEPT_TYPE.APPLICATION_CSV) {
+        const sheet = await this.profitLossSheetApp.csv(tenantId, filter);
 
-          return res.status(200).send({
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
-            table: {
+        res.setHeader('Content-Type', 'text/csv');
-              rows: table.tableRows(),
+
-              columns: table.tableColumns(),
+        return res.send(sheet);
-            },
+        // Retrieves the json table format.
-            query,
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_JSON_TABLE) {
-            meta,
+        const table = await this.profitLossSheetApp.table(tenantId, filter);
-          });
+
-        case 'json':
+        return res.status(200).send(table);
-        default:
+        // Retrieves the xlsx format.
-          return res.status(200).send({
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_XLSX) {
-            data,
+        const sheet = await this.profitLossSheetApp.xlsx(tenantId, filter);
-            query,
+
-            meta,
+        res.setHeader(
-          });
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(sheet);
+        // Retrieves the json format.
+      } else {
+        const sheet = await this.profitLossSheetApp.sheet(tenantId, filter);
+
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/SalesByItems.ts

@@ -16,15 +16,12 @@ export default class SalesByItemsReportController extends BaseFinancialReportCon
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
       '/',
-      CheckPolicies(
+      CheckPolicies(ReportsAction.READ_SALES_BY_ITEMS, AbilitySubject.Report),
-        ReportsAction.READ_SALES_BY_ITEMS,
-        AbilitySubject.Report
-      ),
       this.validationSchema,
       this.validationResult,
       asyncMiddleware(this.purchasesByItems.bind(this))
@@ -35,7 +32,7 @@ export default class SalesByItemsReportController extends BaseFinancialReportCon
   /**
    * Validation schema.
    */
-  get validationSchema(): ValidationChain[] {
+  private get validationSchema(): ValidationChain[] {
     return [
       query('from_date').optional().isISO8601(),
       query('to_date').optional().isISO8601(),
@@ -63,7 +60,11 @@ export default class SalesByItemsReportController extends BaseFinancialReportCon
    * @param {Request} req -
    * @param {Response} res -
    */
-  async purchasesByItems(req: Request, res: Response, next: NextFunction) {
+  private async purchasesByItems(
+    req: Request,
+    res: Response,
+    next: NextFunction
+  ) {
     const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 

packages/server/src/api/controllers/FinancialStatements/SalesTaxLiabilitySummary/index.ts

@@ -1,20 +1,21 @@
+import { Inject } from 'typedi';
 import { Router, Request, Response, NextFunction } from 'express';
 import { query } from 'express-validator';
-import { Inject } from 'typedi';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
 import BaseFinancialReportController from '../BaseFinancialReportController';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
-import { SalesTaxLiabilitySummaryService } from '@/services/FinancialStatements/SalesTaxLiabilitySummary/SalesTaxLiabilitySummaryService';
+import { SalesTaxLiabilitySummaryApplication } from '@/services/FinancialStatements/SalesTaxLiabilitySummary/SalesTaxLiabilitySummaryApplication';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 export default class SalesTaxLiabilitySummary extends BaseFinancialReportController {
   @Inject()
-  private salesTaxLiabilitySummaryService: SalesTaxLiabilitySummaryService;
+  private salesTaxLiabilitySummaryApp: SalesTaxLiabilitySummaryApplication;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -31,8 +32,9 @@ export default class SalesTaxLiabilitySummary extends BaseFinancialReportControl
 
   /**
    * Validation schema.
+   * @returns {ValidationChain[]}
    */
-  get validationSchema() {
+  private get validationSchema() {
     return [
       query('from_date').optional().isISO8601(),
       query('to_date').optional().isISO8601(),
@@ -45,7 +47,7 @@ export default class SalesTaxLiabilitySummary extends BaseFinancialReportControl
    * @param {Response} res -
    * @param {NextFunction} next -
    */
-  async salesTaxLiabilitySummary(
+  private async salesTaxLiabilitySummary(
     req: Request,
     res: Response,
     next: NextFunction
@@ -55,33 +57,52 @@ export default class SalesTaxLiabilitySummary extends BaseFinancialReportControl
 
     try {
       const accept = this.accepts(req);
-      const acceptType = accept.types(['json', 'application/json+table']);
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
 
-      switch (acceptType) {
+      // Retrieves the json table format.
-        case 'application/json+table':
+      if (acceptType === ACCEPT_TYPE.APPLICATION_JSON_TABLE) {
-          const salesTaxLiabilityTable =
+        const table = await this.salesTaxLiabilitySummaryApp.table(
-            await this.salesTaxLiabilitySummaryService.salesTaxLiabilitySummaryTable(
           tenantId,
           filter
         );
-
+        return res.status(200).send(table);
-          return res.status(200).send({
+        // Retrieves the xlsx format.
-            table: salesTaxLiabilityTable.table,
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_XLSX) {
-            query: salesTaxLiabilityTable.query,
+        const buffer = await this.salesTaxLiabilitySummaryApp.xlsx(
-            meta: salesTaxLiabilityTable.meta,
-          });
-        case 'json':
-        default:
-          const salesTaxLiability =
-            await this.salesTaxLiabilitySummaryService.salesTaxLiability(
           tenantId,
           filter
         );
-          return res.status(200).send({
+        res.setHeader(
-            data: salesTaxLiability.data,
+          'Content-Disposition',
-            query: salesTaxLiability.query,
+          'attachment; filename=output.xlsx'
-            meta: salesTaxLiability.meta,
+        );
-          });
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieves the csv format.
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_CSV) {
+        const buffer = await this.salesTaxLiabilitySummaryApp.csv(
+          tenantId,
+          filter
+        );
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.send(buffer);
+        // Retrieves the json format.
+      } else {
+        const sheet = await this.salesTaxLiabilitySummaryApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/TransactionsByCustomers/index.ts

@@ -1,30 +1,22 @@
 import { Router, Request, Response, NextFunction } from 'express';
 import { query } from 'express-validator';
 import { Inject, Service } from 'typedi';
-import {
+import { AbilitySubject, ReportsAction } from '@/interfaces';
-  AbilitySubject,
-  ITransactionsByCustomersStatement,
-  ReportsAction,
-} from '@/interfaces';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
 import BaseFinancialReportController from '../BaseFinancialReportController';
-import TransactionsByCustomersService from '@/services/FinancialStatements/TransactionsByCustomer/TransactionsByCustomersService';
-import TransactionsByCustomersTableRows from '@/services/FinancialStatements/TransactionsByCustomer/TransactionsByCustomersTableRows';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { TransactionsByCustomerApplication } from '@/services/FinancialStatements/TransactionsByCustomer/TransactionsByCustomersApplication';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 @Service()
 export default class TransactionsByCustomersReportController extends BaseFinancialReportController {
   @Inject()
-  transactionsByCustomersService: TransactionsByCustomersService;
+  private transactionsByCustomersApp: TransactionsByCustomerApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -58,45 +50,13 @@ export default class TransactionsByCustomersReportController extends BaseFinanci
     ];
   }
 
-  /**
-   * Transformes the statement to table rows response.
-   * @param {ITransactionsByCustomersStatement} statement -
-   */
-  private transformToTableResponse(customersTransactions, tenantId) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const table = new TransactionsByCustomersTableRows(
-      customersTransactions,
-      i18n
-    );
-    return {
-      table: {
-        rows: table.tableRows(),
-      },
-    };
-  }
-
-  /**
-   * Transformes the statement to json response.
-   * @param {ITransactionsByCustomersStatement} statement -
-   */
-  private transfromToJsonResponse(
-    data,
-    columns
-  ): ITransactionsByCustomersStatement {
-    return {
-      data: this.transfromToResponse(data),
-      columns: this.transfromToResponse(columns),
-      query: this.transfromToResponse(query),
-    };
-  }
-
   /**
    * Retrieve payable aging summary report.
    * @param {Request} req -
    * @param {Response} res -
    * @param {NextFunction} next -
    */
-  async transactionsByCustomers(
+  private async transactionsByCustomers(
     req: Request,
     res: Response,
     next: NextFunction
@@ -104,25 +64,51 @@ export default class TransactionsByCustomersReportController extends BaseFinanci
     const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
+    const accept = this.accepts(req);
+    const acceptType = accept.types([
+      ACCEPT_TYPE.APPLICATION_JSON,
+      ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+      ACCEPT_TYPE.APPLICATION_CSV,
+      ACCEPT_TYPE.APPLICATION_XLSX,
+    ]);
     try {
-      const report =
+      // Retrieves the json table format.
-        await this.transactionsByCustomersService.transactionsByCustomers(
+      if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
+        const table = await this.transactionsByCustomersApp.table(
           tenantId,
           filter
         );
-      const accept = this.accepts(req);
+        return res.status(200).send(table);
-      const acceptType = accept.types(['json', 'application/json+table']);
+        // Retrieve the csv format.
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
+        const csv = await this.transactionsByCustomersApp.csv(tenantId, filter);
 
-      switch (acceptType) {
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
-        case 'json':
+        res.setHeader('Content-Type', 'text/csv');
-          return res
+
-            .status(200)
+        return res.send(csv);
-            .send(this.transfromToJsonResponse(report.data, report.columns));
+        // Retrieve the xlsx format.
-        case 'application/json+table':
+      } else if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
-        default:
+        const buffer = await this.transactionsByCustomersApp.xlsx(
-          return res
+          tenantId,
-            .status(200)
+          filter
-            .send(this.transformToTableResponse(report.data, tenantId));
+        );
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieve the json format.
+      } else {
+        const sheet = await this.transactionsByCustomersApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/TransactionsByVendors/index.ts

@@ -3,27 +3,19 @@ import { query, ValidationChain } from 'express-validator';
 import { Inject } from 'typedi';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
 import BaseFinancialReportController from '../BaseFinancialReportController';
-import TransactionsByVendorsTableRows from '@/services/FinancialStatements/TransactionsByVendor/TransactionsByVendorTableRows';
+import { AbilitySubject, ReportsAction } from '@/interfaces';
-import TransactionsByVendorsService from '@/services/FinancialStatements/TransactionsByVendor/TransactionsByVendorService';
-import {
-  AbilitySubject,
-  ITransactionsByVendorsStatement,
-  ReportsAction,
-} from '@/interfaces';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
+import { TransactionsByVendorApplication } from '@/services/FinancialStatements/TransactionsByVendor/TransactionsByVendorApplication';
 
 export default class TransactionsByVendorsReportController extends BaseFinancialReportController {
   @Inject()
-  transactionsByVendorsService: TransactionsByVendorsService;
+  private transactionsByVendorsApp: TransactionsByVendorApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -42,7 +34,7 @@ export default class TransactionsByVendorsReportController extends BaseFinancial
   /**
    * Validation schema.
    */
-  get validationSchema(): ValidationChain[] {
+  private get validationSchema(): ValidationChain[] {
     return [
       ...this.sheetNumberFormatValidationSchema,
 
@@ -58,64 +50,64 @@ export default class TransactionsByVendorsReportController extends BaseFinancial
     ];
   }
 
-  /**
-   * Transformes the report statement to table rows.
-   * @param {ITransactionsByVendorsStatement} statement -
-   */
-  private transformToTableRows(tenantId: number, transactions: any[]) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const table = new TransactionsByVendorsTableRows(transactions, i18n);
-
-    return {
-      table: {
-        data: table.tableRows(),
-      },
-    };
-  }
-
-  /**
-   * Transformes the report statement to json response.
-   * @param {ITransactionsByVendorsStatement} statement -
-   */
-  private transformToJsonResponse({
-    data,
-    columns,
-    query,
-  }: ITransactionsByVendorsStatement) {
-    return {
-      data: this.transfromToResponse(data),
-      columns: this.transfromToResponse(columns),
-      query: this.transfromToResponse(query),
-    };
-  }
-
   /**
    * Retrieve payable aging summary report.
    * @param {Request} req -
    * @param {Response} res -
    * @param {NextFunction} next -
    */
-  async transactionsByVendors(req: Request, res: Response, next: NextFunction) {
+  private async transactionsByVendors(
+    req: Request,
+    res: Response,
+    next: NextFunction
+  ) {
     const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
     try {
-      const report =
+      const accept = this.accepts(req);
-        await this.transactionsByVendorsService.transactionsByVendors(
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+
+      // Retrieves the xlsx format.
+      if (ACCEPT_TYPE.APPLICATION_XLSX === acceptType) {
+        const buffer = await this.transactionsByVendorsApp.xlsx(
           tenantId,
           filter
         );
-      const accept = this.accepts(req);
+        res.setHeader('Content-Type', 'application/vnd.openxmlformats');
-      const acceptType = accept.types(['json', 'application/json+table']);
+        res.setHeader(
-
+          'Content-Disposition',
-      switch (acceptType) {
+          'attachment; filename=report.xlsx'
-        case 'application/json+table':
+        );
-          return res
+        return res.send(buffer);
-            .status(200)
+        // Retrieves the csv format.
-            .send(this.transformToTableRows(tenantId, report.data));
+      } else if (ACCEPT_TYPE.APPLICATION_CSV === acceptType) {
-        case 'json':
+        const buffer = await this.transactionsByVendorsApp.csv(
-        default:
+          tenantId,
-          return res.status(200).send(this.transformToJsonResponse(report));
+          filter
+        );
+        res.setHeader('Content-Type', 'text/csv');
+        res.setHeader('Content-Disposition', 'attachment; filename=report.csv');
+        return res.send(buffer);
+        // Retrieves the json table format.
+      } else if (ACCEPT_TYPE.APPLICATION_JSON_TABLE === acceptType) {
+        const table = await this.transactionsByVendorsApp.table(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(table);
+        // Retrieves the json format.
+      } else {
+        const sheet = await this.transactionsByVendorsApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/FinancialStatements/TrialBalanceSheet.ts

@@ -3,20 +3,22 @@ import { Request, Response, Router, NextFunction } from 'express';
 import { query, ValidationChain } from 'express-validator';
 import { castArray } from 'lodash';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
-import TrialBalanceSheetService from '@/services/FinancialStatements/TrialBalanceSheet/TrialBalanceSheetService';
+import TrialBalanceSheetService from '@/services/FinancialStatements/TrialBalanceSheet/TrialBalanceSheetInjectable';
 import BaseFinancialReportController from './BaseFinancialReportController';
 import { AbilitySubject, ReportsAction } from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
+import { TrialBalanceSheetApplication } from '@/services/FinancialStatements/TrialBalanceSheet/TrialBalanceSheetApplication';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
 
 @Service()
 export default class TrialBalanceSheetController extends BaseFinancialReportController {
   @Inject()
-  trialBalanceSheetService: TrialBalanceSheetService;
+  private trialBalanceSheetApp: TrialBalanceSheetApplication;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -36,7 +38,7 @@ export default class TrialBalanceSheetController extends BaseFinancialReportCont
    * Validation schema.
    * @return {ValidationChain[]}
    */
-  get trialBalanceSheetValidationSchema(): ValidationChain[] {
+  private get trialBalanceSheetValidationSchema(): ValidationChain[] {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('basis').optional(),
@@ -59,28 +61,62 @@ export default class TrialBalanceSheetController extends BaseFinancialReportCont
   /**
    * Retrieve the trial balance sheet.
    */
-  public async trialBalanceSheet(
+  private async trialBalanceSheet(
     req: Request,
     res: Response,
     next: NextFunction
   ) {
-    const { tenantId, settings } = req;
+    const { tenantId } = req;
     let filter = this.matchedQueryData(req);
 
     filter = {
       ...filter,
       accountsIds: castArray(filter.accountsIds),
     };
-
     try {
-      const { data, query, meta } =
+      const accept = this.accepts(req);
-        await this.trialBalanceSheetService.trialBalanceSheet(tenantId, filter);
 
-      return res.status(200).send({
+      const acceptType = accept.types([
-        data: this.transfromToResponse(data),
+        ACCEPT_TYPE.APPLICATION_JSON,
-        query: this.transfromToResponse(query),
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
-        meta: this.transfromToResponse(meta),
+        ACCEPT_TYPE.APPLICATION_CSV,
-      });
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+      // Retrieves in json table format.
+      if (acceptType === ACCEPT_TYPE.APPLICATION_JSON_TABLE) {
+        const { table, meta, query } = await this.trialBalanceSheetApp.table(
+          tenantId,
+          filter
+        );
+        return res.status(200).send({ table, meta, query });
+        // Retrieves in xlsx format
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_XLSX) {
+        const buffer = await this.trialBalanceSheetApp.xlsx(tenantId, filter);
+        res.setHeader(
+          'Content-Disposition',
+          'attachment; filename=output.xlsx'
+        );
+        res.setHeader(
+          'Content-Type',
+          'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
+        );
+        return res.send(buffer);
+        // Retrieves in csv format.
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_CSV) {
+        const buffer = await this.trialBalanceSheetApp.csv(tenantId, filter);
+
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.send(buffer);
+        // Retrieves in json format.
+      } else {
+        const { data, query, meta } = await this.trialBalanceSheetApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send({ data, query, meta });
+      }
     } catch (error) {
       next(error);
     }

packages/server/src/api/controllers/FinancialStatements/VendorBalanceSummary/index.ts

@@ -3,27 +3,19 @@ import { query } from 'express-validator';
 import { Inject } from 'typedi';
 import asyncMiddleware from '@/api/middleware/asyncMiddleware';
 import BaseFinancialReportController from '../BaseFinancialReportController';
-import VendorBalanceSummaryTableRows from '@/services/FinancialStatements/VendorBalanceSummary/VendorBalanceSummaryTableRows';
+import { AbilitySubject, ReportsAction } from '@/interfaces';
-import VendorBalanceSummaryService from '@/services/FinancialStatements/VendorBalanceSummary/VendorBalanceSummaryService';
-import {
-  AbilitySubject,
-  IVendorBalanceSummaryStatement,
-  ReportsAction,
-} from '@/interfaces';
 import CheckPolicies from '@/api/middleware/CheckPolicies';
-import HasTenancyService from '@/services/Tenancy/TenancyService';
+import { ACCEPT_TYPE } from '@/interfaces/Http';
+import { VendorBalanceSummaryApplication } from '@/services/FinancialStatements/VendorBalanceSummary/VendorBalanceSummaryApplication';
 
 export default class VendorBalanceSummaryReportController extends BaseFinancialReportController {
   @Inject()
-  vendorBalanceSummaryService: VendorBalanceSummaryService;
+  private vendorBalanceSummaryApp: VendorBalanceSummaryApplication;
-
-  @Inject()
-  tenancy: HasTenancyService;
 
   /**
    * Router constructor.
    */
-  router() {
+  public router() {
     const router = Router();
 
     router.get(
@@ -41,7 +33,7 @@ export default class VendorBalanceSummaryReportController extends BaseFinancialR
   /**
    * Validation schema.
    */
-  get validationSchema() {
+  private get validationSchema() {
     return [
       ...this.sheetNumberFormatValidationSchema,
       query('as_date').optional().isISO8601(),
@@ -59,73 +51,62 @@ export default class VendorBalanceSummaryReportController extends BaseFinancialR
     ];
   }
 
-  /**
-   * Transformes the report statement to table rows.
-   * @param {IVendorBalanceSummaryStatement} statement -
-   */
-  private transformToTableRows(
-    tenantId: number,
-    { data, query }: IVendorBalanceSummaryStatement
-  ) {
-    const i18n = this.tenancy.i18n(tenantId);
-    const tableData = new VendorBalanceSummaryTableRows(
-      data,
-      query,
-      i18n
-    );
-    return {
-      table: {
-        columns: tableData.tableColumns(),
-        data: tableData.tableRows(),
-      },
-      query,
-    };
-  }
-
-  /**
-   * Transformes the report statement to raw json.
-   * @param {IVendorBalanceSummaryStatement} statement -
-   */
-  private transformToJsonResponse({
-    data,
-    columns,
-  }: IVendorBalanceSummaryStatement) {
-    return {
-      data: this.transfromToResponse(data),
-      columns: this.transfromToResponse(columns),
-      query: this.transfromToResponse(query),
-    };
-  }
-
   /**
    * Retrieve vendors balance summary.
    * @param {Request} req -
    * @param {Response} res -
    * @param {NextFunction} next -
    */
-  async vendorBalanceSummary(req: Request, res: Response, next: NextFunction) {
+  public async vendorBalanceSummary(
-    const { tenantId, settings } = req;
+    req: Request,
+    res: Response,
+    next: NextFunction
+  ) {
+    const { tenantId } = req;
     const filter = this.matchedQueryData(req);
 
     try {
-      const vendorBalanceSummary =
+      const accept = this.accepts(req);
-        await this.vendorBalanceSummaryService.vendorBalanceSummary(
+      const acceptType = accept.types([
+        ACCEPT_TYPE.APPLICATION_JSON,
+        ACCEPT_TYPE.APPLICATION_JSON_TABLE,
+        ACCEPT_TYPE.APPLICATION_CSV,
+        ACCEPT_TYPE.APPLICATION_XLSX,
+      ]);
+
+      // Retrieves the csv format.
+      if (acceptType === ACCEPT_TYPE.APPLICATION_CSV) {
+        const buffer = await this.vendorBalanceSummaryApp.csv(tenantId, filter);
+
+        res.setHeader('Content-Disposition', 'attachment; filename=output.csv');
+        res.setHeader('Content-Type', 'text/csv');
+
+        return res.send(buffer);
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_XLSX) {
+        const buffer = await this.vendorBalanceSummaryApp.xlsx(
           tenantId,
           filter
         );
-      const accept = this.accepts(req);
+        res.setHeader(
-      const acceptType = accept.types(['json', 'application/json+table']);
+          'Content-Disposition',
-
+          'attachment; filename=output.xlsx'
-      switch (acceptType) {
+        );
-        case 'application/json+table':
+        res.setHeader('Content-Type', 'application/vnd.openxmlformats');
-          return res
+        return res.send(buffer);
-            .status(200)
+        // Retrieves the json table format.
-            .send(this.transformToTableRows(tenantId, vendorBalanceSummary));
+      } else if (acceptType === ACCEPT_TYPE.APPLICATION_JSON_TABLE) {
-        case 'json':
+        const table = await this.vendorBalanceSummaryApp.table(
-        default:
+          tenantId,
-          return res
+          filter
-            .status(200)
+        );
-            .send(this.transformToJsonResponse(vendorBalanceSummary));
+        return res.status(200).send(table);
+        // Retrieves the json format.
+      } else {
+        const sheet = await this.vendorBalanceSummaryApp.sheet(
+          tenantId,
+          filter
+        );
+        return res.status(200).send(sheet);
       }
     } catch (error) {
       next(error);

packages/server/src/api/controllers/Items/Items.ts

@@ -149,6 +149,11 @@ export default class ItemsController extends BaseController {
         .trim()
         .escape()
         .isLength({ max: DATATYPES_LENGTH.TEXT }),
+      check('sell_tax_rate_id').optional({ nullable: true }).isInt().toInt(),
+      check('purchase_tax_rate_id')
+        .optional({ nullable: true })
+        .isInt()
+        .toInt(),
       check('category_id')
         .optional({ nullable: true })
         .isInt({ min: 0, max: DATATYPES_LENGTH.INT_10 })
@@ -508,6 +513,28 @@ export default class ItemsController extends BaseController {
           ],
         });
       }
+      if (error.errorType === 'PURCHASE_TAX_RATE_NOT_FOUND') {
+        return res.status(400).send({
+          errors: [
+            {
+              type: 'PURCHASE_TAX_RATE_NOT_FOUND',
+              message: 'Purchase tax rate has not found.',
+              code: 410,
+            },
+          ],
+        });
+      }
+      if (error.errorType === 'SELL_TAX_RATE_NOT_FOUND') {
+        return res.status(400).send({
+          errors: [
+            {
+              type: 'SELL_TAX_RATE_NOT_FOUND',
+              message: 'Sell tax rate is not found.',
+              code: 420,
+            },
+          ],
+        });
+      }
     }
     next(error);
   }

packages/server/src/api/controllers/Organization.ts

@@ -31,14 +31,14 @@ export default class OrganizationController extends BaseController {
 
     router.post(
       '/build',
-      this.organizationValidationSchema,
+      this.buildOrganizationValidationSchema,
       this.validationResult,
       asyncMiddleware(this.build.bind(this)),
       this.handleServiceErrors.bind(this)
     );
     router.put(
       '/',
-      this.organizationValidationSchema,
+      this.updateOrganizationValidationSchema,
       this.validationResult,
       this.asyncMiddleware(this.updateOrganization.bind(this)),
       this.handleServiceErrors.bind(this)
@@ -55,7 +55,7 @@ export default class OrganizationController extends BaseController {
    * Organization setup schema.
    * @return {ValidationChain[]}
    */
-  private get organizationValidationSchema(): ValidationChain[] {
+  private get commonOrganizationValidationSchema(): ValidationChain[] {
     return [
       check('name').exists().trim(),
       check('industry').optional({ nullable: true }).isString().trim().escape(),
@@ -68,6 +68,29 @@ export default class OrganizationController extends BaseController {
     ];
   }
 
+  /**
+   * Build organization validation schema.
+   * @returns {ValidationChain[]}
+   */
+  private get buildOrganizationValidationSchema(): ValidationChain[] {
+    return [...this.commonOrganizationValidationSchema];
+  }
+
+  /**
+   * Update organization validation schema.
+   * @returns {ValidationChain[]}
+   */
+  private get updateOrganizationValidationSchema(): ValidationChain[] {
+    return [
+      ...this.commonOrganizationValidationSchema,
+      check('tax_number')
+        .optional({ nullable: true })
+        .isString()
+        .trim()
+        .escape(),
+    ];
+  }
+
   /**
    * Builds tenant database and migrate database schema.
    * @param {Request} req - Express request.

packages/server/src/api/controllers/Purchases/Bills.ts

@@ -115,12 +115,14 @@ export default class BillsController extends BaseController {
       check('note').optional().trim().escape(),
       check('open').default(false).isBoolean().toBoolean(),
 
+      check('is_inclusive_tax').default(false).isBoolean().toBoolean(),
+
       check('entries').isArray({ min: 1 }),
 
       check('entries.*.index').exists().isNumeric().toInt(),
       check('entries.*.item_id').exists().isNumeric().toInt(),
       check('entries.*.rate').exists().isNumeric().toFloat(),
-      check('entries.*.quantity').exists().isNumeric().toFloat(),
+      check('entries.*.quantity').exists().isNumeric().toInt(),
       check('entries.*.discount')
         .optional({ nullable: true })
         .isNumeric()
@@ -137,6 +139,15 @@ export default class BillsController extends BaseController {
         .optional({ nullable: true })
         .isNumeric()
         .toInt(),
+      check('entries.*.tax_code')
+        .optional({ nullable: true })
+        .trim()
+        .escape()
+        .isString(),
+      check('entries.*.tax_rate_id')
+        .optional({ nullable: true })
+        .isNumeric()
+        .toInt(),
     ];
   }
 
@@ -542,6 +553,16 @@ export default class BillsController extends BaseController {
           ],
         });
       }
+      if (error.errorType === 'ITEM_ENTRY_TAX_RATE_CODE_NOT_FOUND') {
+        return res.boom.badRequest(null, {
+          errors: [{ type: 'ITEM_ENTRY_TAX_RATE_CODE_NOT_FOUND', code: 1800 }],
+        });
+      }
+      if (error.errorType === 'ITEM_ENTRY_TAX_RATE_ID_NOT_FOUND') {
+        return res.boom.badRequest(null, {
+          errors: [{ type: 'ITEM_ENTRY_TAX_RATE_ID_NOT_FOUND', code: 1900 }],
+        });
+      }
     }
     next(error);
   }

packages/server/src/api/controllers/Purchases/BillsPayments.ts

@@ -121,7 +121,7 @@ export default class BillsPayments extends BaseController {
       check('entries').exists().isArray({ min: 1 }),
       check('entries.*.index').optional().isNumeric().toInt(),
       check('entries.*.bill_id').exists().isNumeric().toInt(),
-      check('entries.*.payment_amount').exists().isNumeric().toInt(),
+      check('entries.*.payment_amount').exists().isNumeric().toFloat(),
     ];
   }
 

packages/server/src/api/controllers/Purchases/VendorCredit.ts

@@ -173,7 +173,7 @@ export default class VendorCreditController extends BaseController {
       check('entries.*.index').exists().isNumeric().toInt(),
       check('entries.*.item_id').exists().isNumeric().toInt(),
       check('entries.*.rate').exists().isNumeric().toFloat(),
-      check('entries.*.quantity').exists().isNumeric().toFloat(),
+      check('entries.*.quantity').exists().isNumeric().toInt(),
       check('entries.*.discount')
         .optional({ nullable: true })
         .isNumeric()
@@ -211,12 +211,11 @@ export default class VendorCreditController extends BaseController {
       check('branch_id').optional({ nullable: true }).isNumeric().toInt(),
 
       check('entries').isArray({ min: 1 }),
-
       check('entries.*.id').optional().isNumeric().toInt(),
       check('entries.*.index').exists().isNumeric().toInt(),
       check('entries.*.item_id').exists().isNumeric().toInt(),
       check('entries.*.rate').exists().isNumeric().toFloat(),
-      check('entries.*.quantity').exists().isNumeric().toFloat(),
+      check('entries.*.quantity').exists().isNumeric().toInt(),
       check('entries.*.discount')
         .optional({ nullable: true })
         .isNumeric()

packages/server/src/api/controllers/Sales/CreditNotes.ts

@@ -222,7 +222,7 @@ export default class PaymentReceivesController extends BaseController {
       check('entries.*.index').exists().isNumeric().toInt(),
       check('entries.*.item_id').exists().isNumeric().toInt(),
       check('entries.*.rate').exists().isNumeric().toFloat(),
-      check('entries.*.quantity').exists().isNumeric().toFloat(),
+      check('entries.*.quantity').exists().isNumeric().toInt(),
       check('entries.*.discount')
         .optional({ nullable: true })
         .isNumeric()

packages/server/src/api/controllers/Sales/PaymentReceives.ts

@@ -142,7 +142,7 @@ export default class PaymentReceivesController extends BaseController {
       check('entries.*.id').optional({ nullable: true }).isNumeric().toInt(),
       check('entries.*.index').optional().isNumeric().toInt(),
       check('entries.*.invoice_id').exists().isNumeric().toInt(),
-      check('entries.*.payment_amount').exists().isNumeric().toInt(),
+      check('entries.*.payment_amount').exists().isNumeric().toFloat(),
     ];
   }
 

packages/server/src/api/controllers/Sales/SalesReceipts.ts

@@ -117,7 +117,7 @@ export default class SalesReceiptsController extends BaseController {
       check('entries.*.index').exists().isNumeric().toInt(),
       check('entries.*.item_id').exists().isNumeric().toInt(),
       check('entries.*.quantity').exists().isNumeric().toInt(),
-      check('entries.*.rate').exists().isNumeric().toInt(),
+      check('entries.*.rate').exists().isNumeric().toFloat(),
       check('entries.*.discount')
         .optional({ nullable: true })
         .isNumeric()

packages/server/src/database/migrations/20231004012644_add_tax_amount_withheld_to_bills_table.js

@@ -0,0 +1,10 @@
+exports.up = (knex) => {
+  return knex.schema.table('bills', (table) => {
+    table.boolean('is_inclusive_tax').defaultTo(false);
+    table.decimal('tax_amount_withheld');
+  });
+};
+
+exports.down = (knex) => {
+  return knex.schema.table('bills', () => {});
+};

packages/server/src/database/migrations/20231004020636_add_sell_purchase_tax_to_items_table.js

@@ -0,0 +1,18 @@
+exports.up = (knex) => {
+  return knex.schema.table('items', (table) => {
+    table
+      .integer('sell_tax_rate_id')
+      .unsigned()
+      .references('id')
+      .inTable('tax_rates');
+    table
+      .integer('purchase_tax_rate_id')
+      .unsigned()
+      .references('id')
+      .inTable('tax_rates');
+  });
+};
+
+exports.down = (knex) => {
+  return knex.schema.dropTableIfExists('tax_rates');
+};

packages/server/src/database/migrations/20231202124014_change_item_entries_rate_to_float.js

@@ -0,0 +1,9 @@
+exports.up = function (knex) {
+  return knex.schema.alterTable('items_entries', (table) => {
+    table.decimal('rate', 15, 5).alter();
+  });
+};
+
+exports.down = function (knex) {
+  return knex.table('items_entries', (table) => {});
+};

packages/server/src/interfaces/APAgingSummaryReport.ts

@@ -8,6 +8,7 @@ import {
   IAgingSummaryData,
 } from './AgingReport';
 import { INumberFormatQuery } from './FinancialStatements';
+import { IFinancialTable } from './Table';
 
 export interface IAPAgingSummaryQuery extends IAgingSummaryQuery {
   vendorsIds: number[];
@@ -34,3 +35,8 @@ export interface IAPAgingSummaryMeta {
   baseCurrency: string;
   organizationName: string;
 }
+
+export interface IAPAgingSummaryTable extends IFinancialTable {
+  query: IAPAgingSummaryQuery;
+  meta: IAPAgingSummaryMeta;
+}

packages/server/src/interfaces/ARAgingSummaryReport.ts

@@ -5,6 +5,7 @@ import {
   IAgingSummaryContact,
   IAgingSummaryData,
 } from './AgingReport';
+import { IFinancialTable } from './Table';
 
 export interface IARAgingSummaryQuery extends IAgingSummaryQuery {
   customersIds: number[];
@@ -26,3 +27,8 @@ export interface IARAgingSummaryMeta {
   organizationName: string;
   baseCurrency: string;
 }
+
+export interface IARAgingSummaryTable extends IFinancialTable {
+  meta: IARAgingSummaryMeta;
+  query: IARAgingSummaryQuery;
+}

packages/server/src/interfaces/BalanceSheet.ts

@@ -3,12 +3,14 @@ import {
   IFormatNumberSettings,
   IFinancialSheetBranchesQuery,
 } from './FinancialStatements';
+import { IFinancialTable } from './Table';
 
 // Balance sheet schema nodes types.
 export enum BALANCE_SHEET_SCHEMA_NODE_TYPE {
   AGGREGATE = 'AGGREGATE',
   ACCOUNTS = 'ACCOUNTS',
   ACCOUNT = 'ACCOUNT',
+  NET_INCOME = 'NET_INCOME',
 }
 
 export enum BALANCE_SHEET_NODE_TYPE {
@@ -33,6 +35,7 @@ export enum BALANCE_SHEET_SCHEMA_NODE_ID {
   LOGN_TERM_LIABILITY = 'LOGN_TERM_LIABILITY',
   NON_CURRENT_LIABILITY = 'NON_CURRENT_LIABILITY',
   EQUITY = 'EQUITY',
+  NET_INCOME = 'NET_INCOME',
 }
 
 // Balance sheet query.
@@ -87,7 +90,6 @@ export interface IBalanceSheetDOO {
   meta: IBalanceSheetMeta;
 }
 
-
 export interface IBalanceSheetCommonNode {
   total: IBalanceSheetTotal;
   horizontalTotals?: IBalanceSheetTotal[];
@@ -108,7 +110,7 @@ export interface IBalanceSheetAggregateNode extends IBalanceSheetCommonNode {
   id: string;
   name: string;
   nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE;
-  children?: (IBalanceSheetAggregateNode | IBalanceSheetAccountNode)[];
+  children?: IBalanceSheetDataNode[];
 }
 
 export interface IBalanceSheetTotal {
@@ -118,6 +120,13 @@ export interface IBalanceSheetTotal {
   date?: string | Date;
 }
 
+export interface IBalanceSheetAccountsNode extends IBalanceSheetCommonNode {
+  id: number | string;
+  name: string;
+  nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS;
+  children: IBalanceSheetAccountNode[];
+}
+
 export interface IBalanceSheetAccountNode extends IBalanceSheetCommonNode {
   id: number;
   index: number;
@@ -128,7 +137,17 @@ export interface IBalanceSheetAccountNode extends IBalanceSheetCommonNode {
   children?: IBalanceSheetAccountNode[];
 }
 
-export type IBalanceSheetDataNode = IBalanceSheetAggregateNode;
+export interface IBalanceSheetNetIncomeNode extends IBalanceSheetCommonNode {
+  id: number;
+  name: string;
+  nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.NET_INCOME;
+}
+
+export type IBalanceSheetDataNode =
+  | IBalanceSheetAggregateNode
+  | IBalanceSheetAccountNode
+  | IBalanceSheetAccountsNode
+  | IBalanceSheetNetIncomeNode;
 
 export interface IBalanceSheetPercentageAmount {
   amount: number;
@@ -150,9 +169,16 @@ export interface IBalanceSheetSchemaAccountNode {
   accountsTypes: string[];
 }
 
+export interface IBalanceSheetSchemaNetIncomeNode {
+  id: string;
+  name: string;
+  type: BALANCE_SHEET_SCHEMA_NODE_TYPE;
+}
+
 export type IBalanceSheetSchemaNode =
   | IBalanceSheetSchemaAccountNode
-  | IBalanceSheetSchemaAggregateNode;
+  | IBalanceSheetSchemaAggregateNode
+  | IBalanceSheetSchemaNetIncomeNode;
 
 export interface IBalanceSheetDatePeriods {
   assocAccountNodeDatePeriods(node): any;
@@ -190,3 +216,8 @@ export enum IAccountTransactionsGroupBy {
   Month = 'month',
   Week = 'week',
 }
+
+export interface IBalanceSheetTable extends IFinancialTable {
+  meta: IBalanceSheetMeta;
+  query: IBalanceSheetQuery;
+}

packages/server/src/interfaces/Bill.ts

@@ -2,6 +2,7 @@ import { Knex } from 'knex';
 import { IDynamicListFilterDTO } from './DynamicFilter';
 import { IItemEntry, IItemEntryDTO } from './ItemEntry';
 import { IBillLandedCost } from './LandedCost';
+
 export interface IBillDTO {
   vendorId: number;
   billNumber: string;
@@ -15,10 +16,10 @@ export interface IBillDTO {
   exchangeRate?: number;
   open: boolean;
   entries: IItemEntryDTO[];
-
   branchId?: number;
   warehouseId?: number;
   projectId?: number;
+  isInclusiveTax?: boolean;
 }
 
 export interface IBillEditDTO {
@@ -80,6 +81,15 @@ export interface IBill {
 
   localAmount?: number;
   locatedLandedCosts?: IBillLandedCost[];
+
+  amountLocal: number;
+  subtotal: number;
+  subtotalLocal: number;
+  subtotalExcludingTax: number;
+  taxAmountWithheld: number;
+  taxAmountWithheldLocal: number;
+  total: number;
+  totalLocal: number;
 }
 
 export interface IBillsFilter extends IDynamicListFilterDTO {

packages/server/src/interfaces/CashFlow.ts

@@ -1,7 +1,7 @@
 import { INumberFormatQuery } from './FinancialStatements';
 import { IAccount } from './Account';
 import { ILedger } from './Ledger';
-import { ITableRow } from './Table';
+import { IFinancialTable, ITableRow } from './Table';
 
 export interface ICashFlowStatementQuery {
   fromDate: Date | string;
@@ -101,6 +101,11 @@ export interface ICashFlowStatementDOO {
   query: ICashFlowStatementQuery;
 }
 
+export interface ICashFlowStatementTable extends IFinancialTable {
+  meta: ICashFlowStatementMeta;
+  query: ICashFlowStatementQuery;
+}
+
 export interface ICashFlowStatementService {
   cashFlow(
     tenantId: number,

packages/server/src/interfaces/CustomerBalanceSummary.ts

@@ -1,11 +1,10 @@
-import { INumberFormatQuery } from './FinancialStatements';
-
 import {
   IContactBalanceSummaryQuery,
   IContactBalanceSummaryAmount,
   IContactBalanceSummaryPercentage,
   IContactBalanceSummaryTotal,
 } from './ContactBalanceSummary';
+import { IFinancialTable } from './Table';
 
 export interface ICustomerBalanceSummaryQuery
   extends IContactBalanceSummaryQuery {
@@ -19,7 +18,7 @@ export interface ICustomerBalanceSummaryPercentage
   extends IContactBalanceSummaryPercentage {}
 
 export interface ICustomerBalanceSummaryCustomer {
-  id: number,
+  id: number;
   customerName: string;
   total: ICustomerBalanceSummaryAmount;
   percentageOfColumn?: ICustomerBalanceSummaryPercentage;
@@ -47,3 +46,7 @@ export interface ICustomerBalanceSummaryService {
     query: ICustomerBalanceSummaryQuery
   ): Promise<ICustomerBalanceSummaryStatement>;
 }
+
+export interface ICustomerBalanceSummaryTable extends IFinancialTable {
+  query: ICustomerBalanceSummaryQuery;
+}

packages/server/src/interfaces/Http.ts

@@ -0,0 +1,7 @@
+export const ACCEPT_TYPE = {
+  APPLICATION_PDF: 'application/pdf',
+  APPLICATION_JSON: 'application/json',
+  APPLICATION_JSON_TABLE: 'application/json+table',
+  APPLICATION_XLSX: 'application/xlsx',
+  APPLICATION_CSV: 'application/csv',
+};

packages/server/src/interfaces/InventoryDetails.ts

@@ -1,13 +1,12 @@
-import {
+import { INumberFormatQuery } from './FinancialStatements';
-  INumberFormatQuery,
+import { IFinancialTable } from './Table';
-} from './FinancialStatements';
 
 export interface IInventoryDetailsQuery {
   fromDate: Date | string;
   toDate: Date | string;
   numberFormat: INumberFormatQuery;
   noneTransactions: boolean;
-  itemsIds: number[]
+  itemsIds: number[];
 
   warehousesIds?: number[];
   branchesIds?: number[];
@@ -80,7 +79,6 @@ export type IInventoryDetailsNode =
   | IInventoryDetailsItemTransaction;
 export type IInventoryDetailsData = IInventoryDetailsItem[];
 
-
 export interface IInventoryItemDetailMeta {
   isCostComputeRunning: boolean;
   organizationName: string;
@@ -92,3 +90,8 @@ export interface IInvetoryItemDetailDOO {
   query: IInventoryDetailsQuery;
   meta: IInventoryItemDetailMeta;
 }
+
+export interface IInvetoryItemDetailsTable extends IFinancialTable {
+  query: IInventoryDetailsQuery;
+  meta: IInventoryItemDetailMeta;
+}

packages/server/src/interfaces/Item.ts

@@ -22,6 +22,9 @@ export interface IItem {
   sellDescription: string;
   purchaseDescription: string;
 
+  sellTaxRateId: number;
+  purchaseTaxRateId: number;
+
   quantityOnHand: number;
 
   note: string;
@@ -54,6 +57,9 @@ export interface IItemDTO {
   sellDescription: string;
   purchaseDescription: string;
 
+  sellTaxRateId: number;
+  purchaseTaxRateId: number;
+
   quantityOnHand: number;
 
   note: string;

packages/server/src/interfaces/Ledger.ts

@@ -7,18 +7,25 @@ export interface ILedger {
   filter(cb: (entry: ILedgerEntry) => boolean): ILedger;
 
   whereAccountId(accountId: number): ILedger;
+  whereAccountsIds(accountsIds: number[]): ILedger;
   whereContactId(contactId: number): ILedger;
   whereFromDate(fromDate: Date | string): ILedger;
   whereToDate(toDate: Date | string): ILedger;
   whereCurrencyCode(currencyCode: string): ILedger;
   whereBranch(branchId: number): ILedger;
   whereItem(itemId: number): ILedger;
+  whereProject(projectId: number): ILedger;
 
   getClosingBalance(): number;
   getForeignClosingBalance(): number;
+  getClosingDebit(): number;
+  getClosingCredit(): number;
 
   getContactsIds(): number[];
   getAccountsIds(): number[];
+
+  reverse(): ILedger;
+  isEmpty(): boolean;
 }
 
 export interface ILedgerEntry {

packages/server/src/interfaces/ProfitLossSheet.ts

@@ -2,6 +2,7 @@ import {
   IFinancialSheetBranchesQuery,
   INumberFormatQuery,
 } from './FinancialStatements';
+import { IFinancialTable } from './Table';
 
 export enum ProfitLossAggregateNodeId {
   INCOME = 'INCOME',
@@ -177,3 +178,9 @@ export enum ProfitLossSheetRowType {
   ACCOUNT = 'ACCOUNT',
   TOTAL = 'TOTAL',
 }
+
+
+export interface IProfitLossSheetTable extends IFinancialTable{
+  meta: IProfitLossSheetMeta;
+  query: IProfitLossSheetQuery;
+}

packages/server/src/interfaces/Roles.ts

@@ -1,5 +1,5 @@
+import { Knex } from 'knex';
 import { Ability, RawRuleOf, ForcedSubject } from '@casl/ability';
-import Knex from 'knex';
 
 export const actions = [
   'manage',
@@ -96,7 +96,8 @@ export enum AbilitySubject {
   Preferences = 'Preferences',
   CreditNote = 'CreditNode',
   VendorCredit = 'VendorCredit',
-  Project = 'Project'
+  Project = 'Project',
+  TaxRate = 'TaxRate'
 }
 
 export interface IRoleCreatedPayload {

packages/server/src/interfaces/SalesTaxLiabilitySummary.ts

@@ -1,3 +1,5 @@
+import { IFinancialTable } from "./Table";
+
 export interface SalesTaxLiabilitySummaryQuery {
   fromDate: Date;
   toDate: Date;
@@ -49,3 +51,8 @@ export interface SalesTaxLiabilitySummaryMeta  {
   organizationName: string;
   baseCurrency: string;
 }
+
+export interface ISalesTaxLiabilitySummaryTable extends IFinancialTable {
+  query: SalesTaxLiabilitySummaryQuery;
+  meta: SalesTaxLiabilitySummaryMeta;
+}

packages/server/src/interfaces/Setup.ts

@@ -25,6 +25,7 @@ export interface IOrganizationUpdateDTO {
   timezone: string;
   fiscalYear: string;
   industry: string;
+  taxNumber: string;
 }
 
 export interface IOrganizationBuildEventPayload {

packages/server/src/interfaces/Table.ts

@@ -10,7 +10,7 @@ export interface ITableCell {
 }
 
 export type ITableRow = {
-  rows: ITableCell[];
+  cells: ITableCell[];
 };
 
 export interface ITableColumn {
@@ -29,3 +29,12 @@ export interface ITableColumnAccessor {
   key: string;
   accessor: string;
 }
+
+export interface ITableData {
+  columns: ITableColumn[];
+  rows: ITableRow[];
+}
+
+export interface IFinancialTable {
+  table: ITableData;
+}

packages/server/src/interfaces/TaxRate.ts

@@ -36,6 +36,7 @@ export interface ITaxRateCreatedPayload {
 }
 
 export interface ITaxRateEditingPayload {
+  oldTaxRate: ITaxRate;
   editTaxRateDTO: IEditTaxRateDTO;
   tenantId: number;
   trx: Knex.Transaction;

packages/server/src/interfaces/TransactionsByCustomers.ts

@@ -1,3 +1,4 @@
+import { IFinancialTable, ITableData } from './Table';
 import {
   ITransactionsByContactsAmount,
   ITransactionsByContactsTransaction,
@@ -26,6 +27,11 @@ export type ITransactionsByCustomersData = ITransactionsByCustomersCustomer[];
 
 export interface ITransactionsByCustomersStatement {
   data: ITransactionsByCustomersData;
+  query: ITransactionsByCustomersFilter;
+}
+
+export interface ITransactionsByCustomersTable extends IFinancialTable {
+  query: ITransactionsByCustomersFilter;
 }
 
 export interface ITransactionsByCustomersService {

packages/server/src/interfaces/TransactionsByVendors.ts

@@ -1,3 +1,4 @@
+import { IFinancialTable } from './Table';
 import {
   ITransactionsByContactsAmount,
   ITransactionsByContactsTransaction,
@@ -34,3 +35,7 @@ export interface ITransactionsByVendorsService {
     filter: ITransactionsByVendorsFilter
   ): Promise<ITransactionsByVendorsStatement>;
 }
+
+export interface ITransactionsByVendorTable extends IFinancialTable {
+  query: ITransactionsByVendorsFilter;
+}

packages/server/src/interfaces/TrialBalanceSheet.ts

@@ -1,4 +1,5 @@
 import { INumberFormatQuery } from './FinancialStatements';
+import { IFinancialTable } from './Table';
 
 export interface ITrialBalanceSheetQuery {
   fromDate: Date | string;
@@ -33,6 +34,7 @@ export interface ITrialBalanceAccount extends ITrialBalanceTotal {
   id: number;
   parentAccountId: number;
   name: string;
+  formattedName: string;
   code: string;
   accountNormal: string;
 }
@@ -47,3 +49,8 @@ export interface ITrialBalanceStatement {
   query: ITrialBalanceSheetQuery;
   meta: ITrialBalanceSheetMeta;
 }
+
+export interface ITrialBalanceSheetTable extends IFinancialTable {
+  meta: ITrialBalanceSheetMeta;
+  query: ITrialBalanceSheetQuery;
+}

packages/server/src/interfaces/VendorBalanceSummary.ts

@@ -1,8 +1,9 @@
 import { INumberFormatQuery } from './FinancialStatements';
+import { IFinancialTable } from './Table';
 
 export interface IVendorBalanceSummaryQuery {
   asDate: Date;
-  vendorsIds: number[],
+  vendorsIds: number[];
   numberFormat: INumberFormatQuery;
   percentageColumn: boolean;
   noneTransactions: boolean;
@@ -45,6 +46,10 @@ export interface IVendorBalanceSummaryStatement {
 export interface IVendorBalanceSummaryService {
   vendorBalanceSummary(
     tenantId: number,
-    query: IVendorBalanceSummaryQuery,
+    query: IVendorBalanceSummaryQuery
   ): Promise<IVendorBalanceSummaryStatement>;
 }
+
+export interface IVendorBalanceSummaryTable extends IFinancialTable {
+  query: IVendorBalanceSummaryQuery;
+}

packages/server/src/lib/Xlsx/TableSheet.tsx

@@ -0,0 +1,134 @@
+import xlsx, { WorkBook } from 'xlsx';
+import { IFinancialTable, ITableData } from '@/interfaces';
+import { FinancialTableStructure } from '@/services/FinancialStatements/FinancialTableStructure';
+
+interface ITableSheet {
+  convertToXLSX(): WorkBook;
+  convertToCSV(): string;
+  convertToBuffer(workbook: WorkBook, fileType: string): Buffer;
+}
+
+export class TableSheet implements ITableSheet {
+  private table: ITableData;
+
+  constructor(table: ITableData) {
+    this.table = table;
+  }
+
+  /**
+   * Retrieves the columns labels.
+   * @returns {string[]}
+   */
+  private get columns() {
+    return this.table.columns.map((col) => col.label);
+  }
+
+  /**
+   * Retrieves the columns accessors.
+   * @returns {string[]}
+   */
+  private get columnsAccessors() {
+    return this.table.columns.map((col, index) => {
+      return `${index}`;
+    });
+  }
+
+  /**
+   * Retrieves the rows data cellIndex/Value.
+   * @returns {Record<string, string>}
+   */
+  private get rows() {
+    const computedRows = FinancialTableStructure.flatNestedTree(
+      this.table.rows
+    );
+    return computedRows.map((row) => {
+      const entries = row.cells.map((cell, index) => {
+        return [`${index}`, cell.value];
+      });
+      return Object.fromEntries(entries);
+    });
+  }
+
+  /**
+   * Converts the table to a CSV string.
+   * @returns {string}
+   */
+  public convertToCSV(): string {
+    // Define custom headers
+    const headers = this.columns;
+
+    // Convert data to worksheet with headers
+    const worksheet = xlsx.utils.json_to_sheet(this.rows, {
+      header: this.columnsAccessors,
+    });
+    // Add custom headers to the worksheet
+    xlsx.utils.sheet_add_aoa(worksheet, [headers], { origin: 'A1' });
+
+    // Convert worksheet to CSV format
+    const csvOutput = xlsx.utils.sheet_to_csv(worksheet);
+
+    return csvOutput;
+  }
+
+  /**
+   * Convert the array of objects to an XLSX file with styled headers
+   * @returns {Workbook}
+   */
+  public convertToXLSX(): WorkBook {
+    // Create a new workbook and a worksheet
+    const workbook = xlsx.utils.book_new();
+    const worksheet = xlsx.utils.json_to_sheet(this.rows, {
+      header: this.columnsAccessors,
+    });
+    // Add custom headers to the worksheet
+    xlsx.utils.sheet_add_aoa(worksheet, [this.columns], {
+      origin: 'A1',
+    });
+    // Adjust column width.
+    worksheet['!cols'] = this.computeXlsxColumnsWidths(this.rows);
+
+    // Append the worksheet to the workbook
+    xlsx.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
+
+    return workbook;
+  }
+
+  /**
+   * Converts the given workbook to buffer of the given file type
+   * @param {WorkBook} workbook
+   * @param {string} fileType
+   * @returns {Promise<Buffer>}
+   */
+  public convertToBuffer(workbook: WorkBook, fileType: 'xlsx' | 'csv'): Buffer {
+    return xlsx.write(workbook, {
+      type: 'buffer',
+      bookType: fileType,
+      cellStyles: true,
+    });
+  }
+
+  /**
+   * Adjusts and computes the columns width.
+   * @param {} rows
+   * @returns {{wch: number}[]}
+   */
+  private computeXlsxColumnsWidths = (rows): { wch: number }[] => {
+    const cols = [{ wch: 60 }];
+
+    this.columns.map((column) => {
+      cols.push({ wch: column.length });
+    });
+    rows.forEach((row) => {
+      const entries = Object.entries(row);
+
+      entries.forEach(([key, value]) => {
+        if (cols[key]) {
+          cols[key].wch = Math.max(cols[key].wch, String(value).length);
+        } else {
+          cols[key] = { wch: String(value).length };
+        }
+      });
+    });
+    return cols;
+  };
+}

packages/server/src/loaders/eventEmitter.ts

@@ -81,6 +81,9 @@ import { ProjectBillableBillSubscriber } from '@/services/Projects/Projects/Proj
 import { SyncActualTimeTaskSubscriber } from '@/services/Projects/Times/SyncActualTimeTaskSubscriber';
 import { SaleInvoiceTaxRateValidateSubscriber } from '@/services/TaxRates/subscribers/SaleInvoiceTaxRateValidateSubscriber';
 import { WriteInvoiceTaxTransactionsSubscriber } from '@/services/TaxRates/subscribers/WriteInvoiceTaxTransactionsSubscriber';
+import { BillTaxRateValidateSubscriber } from '@/services/TaxRates/subscribers/BillTaxRateValidateSubscriber';
+import { WriteBillTaxTransactionsSubscriber } from '@/services/TaxRates/subscribers/WriteBillTaxTransactionsSubscriber';
+import { SyncItemTaxRateOnEditTaxSubscriber } from '@/services/TaxRates/SyncItemTaxRateOnEditTaxSubscriber';
 
 export default () => {
   return new EventPublisher();
@@ -188,8 +191,14 @@ export const susbcribers = () => {
     ProjectBillableExpensesSubscriber,
     ProjectBillableBillSubscriber,
 
-    // Tax Rates
+    // Tax Rates - Sale Invoice
     SaleInvoiceTaxRateValidateSubscriber,
     WriteInvoiceTaxTransactionsSubscriber,
+
+    // Tax Rates - Bills
+    BillTaxRateValidateSubscriber,
+    WriteBillTaxTransactionsSubscriber,
+
+    SyncItemTaxRateOnEditTaxSubscriber
   ];
 };

packages/server/src/locales/ar.json

@@ -1,640 +0,0 @@
-{
-  "Petty Cash": "العهدة",
-  "Cash": "النقدية",
-  "Bank": "المصرف",
-  "Other Income": "إيرادات اخري",
-  "Interest Income": "إيرادات الفوائد",
-  "Depreciation Expense": "مصاريف الاهلاك",
-  "Interest Expense": "مصروفات الفوائد",
-  "Sales of Product Income": "مبيعات دخل المنتجات",
-  "Inventory Asset": "المخزون",
-  "Cost of Goods Sold (COGS)": "تكلفة البضائع المباعة (COGS)",
-  "Cost of Goods Sold": "تكلفة البضاعة المباعة",
-  "Accounts Payable": "الذمم الدائنة",
-  "Other Expense": "مصاريف أخرى",
-  "Payroll Expenses": "مصاريف المرتبات",
-  "Fixed Asset": "أصول ثابتة",
-  "Credit Card": "بطاقة إئتمان",
-  "Non-Current Asset": "أصول غير متداولة",
-  "Current Asset": "أصول متداولة",
-  "Other Asset": "أصول اخري",
-  "Long Term Liability": "التزامات طويلة الاجل",
-  "Current Liability": "التزامات قصيرة الاجل",
-  "Other Liability": "التزمات اخري",
-  "Equity": "حقوق الملكية",
-  "Expense": "مصروف",
-  "Income": "إيراد",
-  "Accounts Receivable (A/R)": "الذمم المدينة",
-  "Accounts Receivable": "الذمم المدينة",
-  "Accounts Payable (A/P)": "الذمم الدائنة",
-  "Inactive": "غير نشط",
-  "Other Current Asset": "أصول متداولة اخرى",
-  "Tax Payable": "الضريبة المستحقة",
-  "Other Current Liability": "التزامات قصيرة الأجر اخرى",
-  "Non-Current Liability": "التزامات طويلة الأجر",
-  "Assets": "أصول",
-  "Liabilities": "الالتزمات",
-  "Account name": "أسم الحساب",
-  "Account type": "نوع الحساب",
-  "Account normal": "حساب عادي",
-  "Description": "وصف",
-  "Account code": "رمز الحساب",
-  "Currency": "عملة",
-  "Balance": "توازن",
-  "Active": "نشيط",
-  "Created at": "أنشئت في",
-  "fixed_asset": "أصل ثابت",
-  "Journal": "قيد",
-  "Reconciliation": "تسوية",
-  "Credit": "دائن",
-  "Debit": "مدين",
-  "Interest": "فائدة",
-  "Depreciation": "اهلاك",
-  "Payroll": "كشف رواتب",
-  "Type": "نوع",
-  "Name": "الأسم",
-  "Sellable": "قابل للبيع",
-  "Purchasable": "قابل للشراء",
-  "Sell price": "سعر البيع",
-  "Cost price": "سعر الكلفة",
-  "User": "المستخدم",
-  "Category": "تصنيف",
-  "Note": "ملحوظة",
-  "Quantity on hand": "كمية في اليد",
-  "Purchase description": "وصف الشراء",
-  "Sell description": "وصف البيع",
-  "Sell account": "حساب البيع",
-  "Cost account": "حساب التكلفة",
-  "Inventory account": "حساب المخزون",
-  "Payment date": "تاريخ الدفع",
-  "Payment account": "حساب الدفع",
-  "Amount": "كمية",
-  "Reference No.": "رقم المرجع.",
-  "Published": "نشرت",
-  "Journal number": "رقم القيد",
-  "Status": "حالة",
-  "Journal type": "نوع القيد",
-  "Date": "تاريخ",
-  "Asset": "أصل",
-  "Liability": "التزام",
-  "First-in first-out (FIFO)": "الوارد أولاً يصرف أولاً (FIFO)",
-  "Last-in first-out (LIFO)": "الوارد أخيرًا يصرف أولاً (LIFO)",
-  "Average rate": "المعدل المتوسط",
-  "Total": "الإجمالي",
-  "Transaction type": "نوع المعاملة",
-  "Transaction #": "عملية #",
-  "Running Value": "القيمة الجارية",
-  "Running quantity": "الكمية الجارية",
-  "Profit Margin": "هامش الربح",
-  "Value": "القيمة",
-  "Rate": "السعر",
-  "OPERATING ACTIVITIES": "الأنشطة التشغيلية",
-  "FINANCIAL ACTIVITIES": "الأنشطة التمويلية",
-  "INVESTMENT ACTIVITIES": "الانشطة الاستثمارية",
-  "Net income": "صافي الدخل",
-  "Adjustments net income by operating activities.": "تسويات صافي الدخل من الأنشطة التشغيلية.",
-  "Net cash provided by operating activities": "صافي التدفقات النقدية من أنشطة التشغيل",
-  "Net cash provided by investing activities": "صافي التدفقات النقدية من أنشطة الاستثمار",
-  "Net cash provided by financing activities": "صافي التدفقات النقدية من أنشطة التمويلية",
-  "Cash at beginning of period": "التدفقات النقدية في بداية الفترة",
-  "NET CASH INCREASE FOR PERIOD": "زيادة التدفقات النقدية للفترة",
-  "CASH AT END OF PERIOD": "صافي التدفقات النقدية في نهاية الفترة",
-  "Expenses": "مصاريف",
-  "Services": "خدمات",
-  "Inventory": "المخزون",
-  "Non Inventory": "غير المخزون",
-  "Draft": "مسودة",
-  "Delivered": "تم التوصيل",
-  "Overdue": "متأخر",
-  "Partially paid": "المدفوعة جزئيا",
-  "Paid": "مدفوع",
-  "Opened": "افتتح",
-  "Unpaid": "غير مدفوعة",
-  "Approved": "وافق",
-  "Rejected": "مرفوض",
-  "Invoiced": "مفوترة",
-  "Expired": "منتهي الصلاحية",
-  "Closed": "مغلق",
-  "Manual journal": "قيد اليدوي",
-  "Owner contribution": "زيادة رأس المال",
-  "Transfer to account": "تحويل إلى الحساب",
-  "Transfer from account": "تحويل من الحساب",
-  "Other income": "إيراد اخر",
-  "Other expense": "مصاريف أخرى",
-  "Owner drawing": "سحب رأس المال",
-  "Inventory adjustment": "تسوية المخزون",
-  "Customer opening balance": "الرصيد الافتتاحي للزبون",
-  "Vendor opening balance": "رصيد افتتاحي للمورد",
-  "Payment made": "سند الزبون",
-  "Bill": "فاتورة الشراء",
-  "Payment receive": "استلام الدفع",
-  "Sale receipt": "إيصال البيع",
-  "Sale invoice": "فاتورة البيع",
-  "Quantity": "الكمية",
-  "Bank Account": "حساب البنك",
-  "Saving Bank Account": "حساب التوفير البنكي",
-  "Undeposited Funds": "الأموال غير المودعة",
-  "Computer Equipment": "معدات كمبيوتر",
-  "Office Equipment": "معدات مكتبية",
-  "Uncategorized Income": "الدخل غير مصنف",
-  "Sales of Service Income": "دخل مبيعات الخدمات",
-  "Bank Fees and Charges": "رسوم المصرفية",
-  "Exchange Gain or Loss": "ربح أو خسارة فروقات الصرف",
-  "Rent": "إيجار",
-  "Office expenses": "مصاريف المكتب",
-  "Other Expenses": "مصاريف اخري",
-  "Drawings": "السحوبات",
-  "Owner's Equity": "حقوق الملكية",
-  "Opening Balance Equity": "الارصدة الافتتاحية ",
-  "Retained Earnings": "الأرباح المحتجزة",
-  "Sales Tax Payable": "ضريبة المبيعات المستحقة",
-  "Revenue Received in Advance": "الإيرادات المقبوضة مقدما",
-  "Opening Balance Liabilities": "رصيد الالتزامات الافتتاحي",
-  "Loan": "اقراض",
-  "Owner A Drawings": "مسحوبات المالك",
-  "An account that holds valuation of products or goods that available for sale.": "حساب يحمل قيم مخزون البضاعة أو السلع المتاحة للبيع.",
-  "Tracks the gain and losses of the exchange differences.": "يسجل مكاسب وخسائر فروق الصرف.",
-  "Any bank fees levied is recorded into the bank fees and charges account. A bank account maintenance fee, transaction charges, a late payment fee are some examples.": "يتم تسجيل أي رسوم مصرفية يتم فرضها في حساب الرسوم والمصروفات البنكية. ومن الأمثلة على ذلك رسوم صيانة الحساب المصرفي ورسوم المعاملات ورسوم الدفع المتأخر.",
-  "The income activities are not associated to the core business.": "لا ترتبط انشطة الدخل إلى الأعمال الأساسية.",
-  "Cash and cash equivalents": "النقد والنقد المكافئ",
-  "Inventories": "مخزون البضاعة",
-  "Other current assets": "الأصول متداولة الأخرى",
-  "Non-Current Assets": "أصول غير المتداولة",
-  "Current Liabilties": "التزامات متداولة",
-  "Long-Term Liabilities": "التزامات طويلة الاجل",
-  "Non-Current Liabilities": "التزامات غير متداولة",
-  "Liabilities and Equity": "التزامات وحقوق الملكية",
-  "Closing balance": "الرصيد الختامي",
-  "Opening balance": "الرصيد الفتاحي",
-  "Total {{accountName}}": "إجمالي {{accountName}}",
-
-  "invoice.paper.invoice": "فاتورة",
-  "invoice.paper.due_amount": "القيمة المستحقة",
-  "invoice.paper.billed_to": "فاتورة إلي",
-  "invoice.paper.invoice_date": "تاريخ الفاتورة",
-  "invoice.paper.invoice_number": "رقم الفاتورة",
-  "invoice.paper.due_date": "تاريخ الاستحقاق",
-  "invoice.paper.conditions_title": "الشروط والأحكام",
-  "invoice.paper.notes_title": "ملاحظات",
-  "invoice.paper.total": "المجموع",
-  "invoice.paper.balance_due": "مبلغ المستحق",
-  "invoice.paper.payment_amount": "مبلغ المدفوع",
-  "invoice.paper.invoice_amount": "قيمة الفاتورة",
-
-  "item_entry.paper.item_name": "اسم الصنف",
-  "item_entry.paper.rate": "السعر",
-  "item_entry.paper.quantity": "الكمية",
-  "item_entry.paper.total": "إجمالي",
-
-  "estimate.paper.estimate": "عرض أسعار",
-  "estimate.paper.billed_to": "عرض أسعار إلي",
-  "estimate.paper.estimate_date": "تاريخ العرض",
-  "estimate.paper.estimate_number": "رقم العرض",
-  "estimate.paper.expiration_date": "تاريخ انتهاء الصلاحية",
-  "estimate.paper.conditions_title": "الشروط والأحكام",
-  "estimate.paper.notes_title": "ملاحظات",
-  "estimate.paper.amount": "قيمة العرض",
-  "estimate.paper.subtotal": "المجموع",
-  "estimate.paper.total": "إجمالي",
-  "estimate.paper.estimate_amount": "قيمة العرض",
-
-  "receipt.paper.receipt": "إيصال",
-  "receipt.paper.billed_to": "الإيصال إلي",
-  "receipt.paper.receipt_date": "تاريخ الإيصال",
-  "receipt.paper.receipt_number": "رقم الإيصال",
-  "receipt.paper.conditions_title": "الشروط والأحكام",
-  "receipt.paper.notes_title": "ملاحظات",
-  "receipt.paper.receipt_amount": "قيمة الإيصال",
-  "receipt.paper.total": "إجمالي",
-  "receipt.paper.payment_amount": "مبلغ المدفوع",
-  "receipt.paper.balance_due": "مبلغ المستحق",
-  "receipt.paper.statement": "البيان",
-  "receipt.paper.notes": "ملاحظات",
-
-  "payment.paper.payment_receipt": "إيصال قبض",
-  "payment.paper.amount_received": "القيمة المستلمه",
-  "payment.paper.billed_to": "إيصال إلي",
-  "payment.paper.payment_date": "تاريخ الدفع",
-  "payment.paper.invoice_number": "رقم الفاتورة",
-  "payment.paper.invoice_date": "تاريخ الفاتورة",
-  "payment.paper.invoice_amount": "قيمة الفاتورة",
-  "payment.paper.payment_amount": "قيمة الدفع",
-  "payment.paper.balance_due": "المبلغ المستحق",
-  "payment.paper.statement": "البيان",
-
-  "credit.paper.credit_note": "اشعار دائن",
-  "credit.paper.amount": "قيمة الاشعار",
-  "credit.paper.remaining": "رصيد المتبقي",
-  "credit.paper.billed_to": "إيصال إلي",
-  "credit.paper.credit_date": "تاريخ الاشعار",
-  "credit.paper.terms_conditions": "الشروط والاحكام",
-  "credit.paper.notes": "ملاحظات",
-  "credit.paper.total": "إجمالي",
-  "credit.paper.credits_used": "قيمة المستخدمه",
-  "credit.paper.credits_remaining": "قيمة المتبقية",
-
-  "account.field.name": "إسم الحساب",
-  "account.field.description": "الوصف",
-  "account.field.slug": "Account slug",
-  "account.field.code": "رقم الحساب",
-  "account.field.root_type": "جذر الحساب",
-  "account.field.normal": "طبيعة الحساب",
-  "account.field.normal.credit": "دائن",
-  "account.field.normal.debit": "مدين",
-  "account.field.type": "نوع الحساب",
-  "account.field.active": "Activity",
-  "account.field.balance": "الرصيد",
-  "account.field.created_at": "أنشئت في",
-  "item.field.type": "نوع الصنف",
-  "item.field.type.inventory": "مخزون",
-  "item.field.type.service": "خدمة",
-  "item.field.type.non-inventory": "غير مخزون",
-  "item.field.name": "اسم الصنف",
-  "item.field.code": "رمز الصنف",
-  "item.field.sellable": "قابل للبيع",
-  "item.field.purchasable": "قابل للشراء",
-  "item.field.cost_price": "سعر التكلفة",
-  "item.field.cost_account": "حساب التكلفة",
-  "item.field.sell_account": "حساب البيع",
-  "item.field.sell_description": "وصف البيع",
-  "item.field.inventory_account": "حساب المخزون",
-  "item.field.purchase_description": "وصف الشراء",
-  "item.field.quantity_on_hand": "الكمية",
-  "item.field.note": "ملاحظة",
-  "item.field.category": "التصنيف",
-  "item.field.active": "Active",
-  "item.field.created_at": "أنشئت في",
-  "item_category.field.name": "الاسم",
-  "item_category.field.description": "الوصف",
-  "item_category.field.count": "العدد",
-  "item_category.field.created_at": "أنشئت في",
-  "invoice.field.customer": "الزبون",
-  "invoice.field.invoice_date": "تاريخ الفاتورة",
-  "invoice.field.due_date": "تاريخ الاستحقاق",
-  "invoice.field.invoice_no": "رقم الفاتورة",
-  "invoice.field.reference_no": "رقم الإشاري",
-  "invoice.field.invoice_message": "رسالة الفاتورة",
-  "invoice.field.terms_conditions": "الشروط والأحكام",
-  "invoice.field.amount": "القيمة",
-  "invoice.field.payment_amount": "القيمة المدفوعة",
-  "invoice.field.due_amount": "القيمة المستحقة",
-  "invoice.field.status": "الحالة",
-  "invoice.field.status.paid": "مدفوعة",
-  "invoice.field.status.partially-paid": "المدفوعة جزئيا",
-  "invoice.field.status.overdue": "متأخرة",
-  "invoice.field.status.unpaid": "غير مدفوعة",
-  "invoice.field.status.delivered": "تم تسليمها",
-  "invoice.field.status.draft": "مسودة",
-  "invoice.field.created_at": "أنشئت في",
-  "estimate.field.amount": "القيمة",
-  "estimate.field.estimate_number": "رقم العرض",
-  "estimate.field.customer": "الزبون",
-  "estimate.field.estimate_date": "تاريخ العرض",
-  "estimate.field.expiration_date": "تاريخ انتهاء الصلاحية",
-  "estimate.field.reference_no": "رقم الإشاري",
-  "estimate.field.note": "ملاحظة",
-  "estimate.field.terms_conditions": "الشروط والأحكام",
-  "estimate.field.status": "الحالة",
-  "estimate.field.status.delivered": "تم تسليمها",
-  "estimate.field.status.rejected": "مرفوضة",
-  "estimate.field.status.approved": "تم الموافقة",
-  "estimate.field.status.draft": "مسودة",
-  "estimate.field.created_at": "أنشئت في",
-  "payment_receive.field.customer": "الزبون",
-  "payment_receive.field.payment_date": "تاريخ الدفع",
-  "payment_receive.field.amount": "القيمة",
-  "payment_receive.field.reference_no": "رقم الإشاري",
-  "payment_receive.field.deposit_account": "حساب الإيداع",
-  "payment_receive.field.payment_receive_no": "رقم عملية الدفع",
-  "payment_receive.field.statement": "البيان",
-  "payment_receive.field.created_at": "أنشئت في",
-  "bill_payment.field.vendor": "المورد",
-  "bill_payment.field.amount": "القيمة",
-  "bill_payment.field.due_amount": "قيمة المستحقة",
-  "bill_payment.field.payment_account": "حساب الدفع",
-  "bill_payment.field.payment_number": "قيمة الدفع",
-  "bill_payment.field.payment_date": "تاريخ الدفع",
-  "bill_payment.field.reference_no": "رقم الإشاري",
-  "bill_payment.field.description": "الوصف",
-  "bill_payment.field.created_at": "أنشئت في",
-  "bill.field.vendor": "المورد",
-  "bill.field.bill_number": "رقم الفاتورة",
-  "bill.field.bill_date": "تاريخ الفاتورة",
-  "bill.field.due_date": "تاريخ الاستحقاق",
-  "bill.field.reference_no": "رقم الإشاري",
-  "bill.field.status": "الحالة",
-  "bill.field.status.paid": "مدفوعة",
-  "bill.field.status.partially-paid": "مدفوعة جزئيا",
-  "bill.field.status.unpaid": "غير مدفوعة",
-  "bill.field.status.opened": "مفتوحة",
-  "bill.field.status.draft": "مسودة",
-  "bill.field.status.overdue": "متأخرة",
-  "bill.field.amount": "القيمة",
-  "bill.field.payment_amount": "قيم الدفع",
-  "bill.field.note": "ملاحظة",
-  "bill.field.created_at": "أنشئت في",
-  "inventory_adjustment.field.date": "التاريخ",
-  "inventory_adjustment.field.type": "النوع",
-  "inventory_adjustment.field.type.increment": "زيادة",
-  "inventory_adjustment.field.type.decrement": "نقصان",
-  "inventory_adjustment.field.adjustment_account": "حساب التسوية",
-  "inventory_adjustment.field.reason": "السبب",
-  "inventory_adjustment.field.reference_no": "رقم الإشاري",
-  "inventory_adjustment.field.description": "الوصف",
-  "inventory_adjustment.field.published_at": "نشرت في",
-  "inventory_adjustment.field.created_at": "أنشئت في",
-  "expense.field.payment_date": "تاريخ الدفع",
-  "expense.field.payment_account": "حساب الدفع",
-  "expense.field.amount": "القيمة",
-  "expense.field.reference_no": "رقم الإشاري",
-  "expense.field.description": "الوصف",
-  "expense.field.published": "Published",
-  "expense.field.status": "الحالة",
-  "expense.field.status.draft": "مسودة",
-  "expense.field.status.published": "نشرت",
-  "expense.field.created_at": "أنشئت في",
-  "manual_journal.field.date": "التاريخ",
-  "manual_journal.field.journal_number": "رقم القيد",
-  "manual_journal.field.reference": "رقم الإشاري",
-  "manual_journal.field.journal_type": "نوع القيد",
-  "manual_journal.field.amount": "القيمة",
-  "manual_journal.field.description": "الوصف",
-  "manual_journal.field.status": "الحالة",
-  "manual_journal.field.created_at": "أنشئت في",
-  "receipt.field.amount": "القيمة",
-  "receipt.field.deposit_account": "حساب الإيداع",
-  "receipt.field.customer": "الزبون",
-  "receipt.field.receipt_date": "تاريخ الإيصال",
-  "receipt.field.receipt_number": "رقم الإيصال",
-  "receipt.field.reference_no": "رقم الإشاري",
-  "receipt.field.receipt_message": "رسالة الإيصال",
-  "receipt.field.statement": "البيان",
-  "receipt.field.created_at": "أنشئت في",
-  "receipt.field.status": "الحالة",
-  "receipt.field.status.draft": "مسودة",
-  "receipt.field.status.closed": "مغلقة",
-  "customer.field.first_name": "الاسم الأول",
-  "customer.field.last_name": "الاسم الاخير",
-  "customer.field.display_name": "اسم العرض",
-  "customer.field.email": "بريد الالكتروني",
-  "customer.field.work_phone": "هاتف عمل",
-  "customer.field.personal_phone": "هاتف شخصي",
-  "customer.field.company_name": "اسم الشركة",
-  "customer.field.website": "موقع الكتروني",
-  "customer.field.opening_balance_at": "الرصيد الافتتاحي في",
-  "customer.field.opening_balance": "الرصيد الافتتاحي",
-  "customer.field.created_at": "أنشئت في",
-  "customer.field.balance": "الرصيد",
-  "customer.field.status": "الحالة",
-  "customer.field.currency": "العملة",
-  "customer.field.status.active": "مفعل",
-  "customer.field.status.inactive": "غير مفعل",
-  "customer.field.status.overdue": "متأخر",
-  "customer.field.status.unpaid": "غير دافع",
-  "vendor.field.first_name": "الاسم الأول",
-  "vendor.field.last_name": "الاسم الاخير",
-  "vendor.field.display_name": "اسم العرض",
-  "vendor.field.email": "بريد الالكتروني",
-  "vendor.field.work_phone": "هاتف عمل",
-  "vendor.field.personal_phone": "هاتف شخصي",
-  "vendor.field.company_name": "اسم الشركة",
-  "vendor.field.website": "موقع الكتروني",
-  "vendor.field.opening_balance_at": "الرصيد الافتتاحي في",
-  "vendor.field.opening_balance": "الرصيد الافتتاحي",
-  "vendor.field.created_at": "أنشئت في",
-  "vendor.field.balance": "الرصيد",
-  "vendor.field.status": "الحالة",
-  "vendor.field.currency": "العملة",
-  "vendor.field.status.active": "مفعل",
-  "vendor.field.status.inactive": "غير مفعل",
-  "vendor.field.status.overdue": "متأخر",
-  "vendor.field.status.unpaid": "غير دافع",
-  "Invoice write-off": "شطب فاتورة",
-  "transaction_type.credit_note": "اشعار دائن",
-  "transaction_type.refund_credit_note": "استرجاع اموال اشعار دائن",
-  "transaction_type.vendor_credit": "اشعار مدين",
-  "transaction_type.refund_vendor_credit": "استرجاع اموال اشعار مدين",
-  "transaction_type.landed_cost": "تحميل تكلفة",
-
-  "sms_notification.invoice_details.label": "تفاصيل فاتورة البيع ",
-  "sms_notification.invoice_reminder.label": "تذكير بفاتورة البيع ",
-  "sms_notification.receipt_details.label": "تفاصيل إيصال البيع ",
-  "sms_notification.sale_estimate_details.label": "تفاصيل فاتورة عرض اسعار ",
-  "sms_notification.payment_receive_details.label": "تفاصيل سند الزبون",
-  "sms_notification.customer_balance.label": "رصيد الزبون",
-
-  "sms_notification.invoice_details.description": "سيتم إرسال إشعار عبر الرسائل القصيرة إلى العميل بمجرد إنشاء الفاتورة ونشرها أو عند إشعار العميل عبر رسالة نصية قصيرة بالفاتورة. ",
-  "sms_notification.payment_receive.description": "سيتم إرسال إشعار رسالة شكر للدفع إلى العميل بمجرد إنشاء الدفعة ونشرها أو إشعار العميل بالدفع يدويًا. ",
-  "sms_notification.receipt_details.description": "سيتم إرسال إشعار عبر الرسائل القصيرة إلى العميل بمجرد إنشاء ونشر الإيصال أو عند إشعار العميل بالإيصال يدويًا.",
-  "sms_notification.customer_balance.description": "إرسال رسالة نصية قصيرة إشعار العملاء برصيدهم الحالي المستحق. ",
-  "sms_notification.estimate_details.description": "سيتم إرسال إشعار عبر الرسائل القصيرة إلى عميلك بمجرد نشر العرض أو إشعار العميل بالعرض يدويًا.",
-  "sms_notification.invoice_reminder.description": "سيتم ارسال إشعار SMS لتذكير الزبون بالدفع باكراً ، سواء ارسال بشكل تلقائي او يدوي.",
-
-  "sms_notification.customer_balance.default_message": "عزيزي {CustomerName} ، هذا تذكير بشأن رصيد الحالي المستحق {Balance} ، يُرجى الدفع في أقرب وقت ممكن. - {CompanyName}",
-  "sms_notification.payment_receive.default_message": "مرحبًا {CustomerName} ، تم القبض بقيمة {Amount} للفاتورة - {InvoiceNumber}. نحن نتطلع إلى خدمتك مرة أخرى. شكرا لك. - {CompanyName}",
-  "sms_notification.estimate.default_message": "مرحبًا , {CustomerName} ، تم أنشاء فاتورة عرض اسعار - {EstimateNumber} لك. يرجى إلقاء نظرة وقبوله للمضي قدما. بانتظار ردك. - {CompanyName}",
-
-  "sms_notification.invoice_details.default_message": "مرحبًا {CustomerName},  لديك مبلغ مستحق قدره {DueAmount}  للفاتورة {InvoiceNumber}. - {CompanyName}",
-  "sms_notification.receipt_details.default_message": "مرحبًا {CustomerName} ، لقد تم إنشاء إيصال - {ReceiptNumber} من أجلك. نتطلع إلى خدمتك مرة أخرى. شكرًا لك - {CompanyName}",
-  "sms_notification.invoice_reminder.default_message": "عزيزي {CustomerName} ، يرجي سداد فاتورة - {InvoiceNumber} المستحقة. يرجى الدفع قبل تاريخ {DueDate}. شكرا لك. - {CompanyName}",
-
-  "module.sale_invoices.label": "فواتير البيع",
-  "module.sale_receipts.label": "إيصالات البيع",
-  "module.sale_estimates.label": "فاتورة عرض اسعار ",
-  "module.payment_receives.label": "سندات الزبائن ",
-  "module.customers.label": "العملاء",
-
-  "sms_notification.invoice.var.invoice_number": "يشير  إلى رقم الفاتورة.",
-  "sms_notification.invoice.var.reference_number": "يشير  إلى رقم إشاري للفاتورة.",
-  "sms_notification.invoice.var.customer_name": "يشير  إلى اسم العميل الفاتورة",
-  "sms_notification.invoice.var.due_amount": "يشير  إلى مبلغ الفاتورة المستحق",
-  "sms_notification.invoice.var.amount": "يشير  إلى مبلغ الفاتورة.",
-  "sms_notification.invoice.var.company_name": "يشير إلي اسم الشركة.",
-  "sms_notification.invoice.var.due_date": "يشير إلي تاريخ استحقاق الفاتورة.",
-
-  "sms_notification.receipt.var.receipt_number": "يشير  إلى رقم الإيصال.",
-  "sms_notification.receipt.var.reference_number": "يشير  إلى رقم الإشاري للإيصال.",
-  "sms_notification.receipt.var.customer_name": "يشير  إلى اسم العميل الإيصال.",
-  "sms_notification.receipt.var.amount": "يشير  إلى مبلغ الإيصال. ",
-  "sms_notification.receipt.var.company_name": "يشير إلي اسم الشركة.",
-
-  "sms_notification.payment.var.payment_number": "يشير  إلى رقم معاملة الدفع.",
-  "sms_notification.payment.var.reference_number": "يشير  إلى رقم الإشاري لعملية الدفع ",
-  "sms_notification.payment.var.customer_name": "يشير  إلى اسم العميل الدفع",
-  "sms_notification.payment.var.amount": "يشير  إلى مبلغ معاملة الدفع.",
-  "sms_notification.payment.company_name": "يشير إلي اسم الشركة.",
-  "sms_notification.payment.var.invoice_number": "يشير إلي رقم فاتورة التي تم دفعها.",
-
-  "sms_notification.estimate.var.estimate_number": "يشير  إلى رقم فاتورة عرض اسعار.",
-  "sms_notification.estimate.var.reference_number": "يشير  إلى رقم الإشاري لفاتورة عرض اسعار.",
-  "sms_notification.estimate.var.customer_name": "يشير  إلى اسم العميل الفاتورة",
-  "sms_notification.estimate.var.amount": "يشير  إلى قيمة الفاتورة",
-  "sms_notification.estimate.var.company_name": "يشير إلي اسم الشركة.",
-  "sms_notification.estimate.var.expiration_date": "يشير إلي تاريخ الصلاحية الفاتورة.",
-  "sms_notification.estimate.var.estimate_date": "يشير إلي تاريخ الفاتورة.",
-
-  "sms_notification.customer.var.customer_name": "يشير إلي اسم الزبون",
-  "sms_notification.customer.var.balance": "يشير إلي رصيد زبون المستحق.",
-  "sms_notification.customer.var.company_name": "يشير إلي اسم الشركة.",
-
-  "ability.accounts": "شجرة الحسابات",
-  "ability.manual_journal": "القيود اليدوية",
-  "ability.cashflow": "التدفقات النقدية",
-  "ability.inventory_adjustment": "تسويات المخزون",
-  "ability.customers": "الزبائن",
-  "ability.vendors": "الموردين",
-  "ability.sale_estimates": "فواتير عرض الاسعار",
-  "ability.sale_invoices": "فواتير البيع",
-  "ability.sale_receipts": "إيصالات البيع",
-  "ability.expenses": "المصاريف",
-  "ability.payments_receive": "سندات الزبائن",
-  "ability.purchase_invoices": "فواتير الشراء",
-  "ability.all_reports": "كل التقارير",
-  "ability.payments_made": "سندات الموردين",
-  "ability.preferences": "التفضيلات",
-  "ability.mutate_system_preferences": "تعديل تفضيلات النظام.",
-
-  "ability.items": "الأصناف",
-  "ability.view": "عرض",
-  "ability.create": "إضافة",
-  "ability.edit": "تعديل",
-  "ability.delete": "حذف",
-  "ability.transactions_locking": "إمكانية اغلاق المعاملات.",
-
-  "ability.balance_sheet_report": "ميزانية العمومية",
-  "ability.profit_loss_sheet": "قائمة الدخل",
-  "ability.journal": "اليومية العامة",
-  "ability.general_ledger": "دفتر الأستاذ العام",
-  "ability.cashflow_report": "تقرير التدفقات النقدية",
-  "ability.AR_aging_summary_report": "ملخص اعمار الديون للذمم المدينة",
-  "ability.AP_aging_summary_report": "ملخص اعمار الديون للذمم الدائنة",
-  "ability.purchases_by_items": "المشتريات حسب المنتجات",
-  "ability.sales_by_items_report": "المبيعات حسب المنتجات",
-  "ability.customers_transactions_report": "معاملات الزبائن",
-  "ability.vendors_transactions_report": "معاملات الموردين",
-  "ability.customers_summary_balance_report": "ملخص أرصدة الزبائن",
-  "ability.vendors_summary_balance_report": "ملخص أرصدة الموردين",
-  "ability.inventory_valuation_summary": "ملخص تقييم المخزون",
-  "ability.inventory_items_details": "تفاصيل منتج المخزون",
-
-  "vendor_credit.field.vendor": "المورد",
-  "vendor_credit.field.amount": "القيمة",
-  "vendor_credit.field.currency_code": "العملة",
-  "vendor_credit.field.credit_date": "تاريخ الاشعار",
-  "vendor_credit.field.credit_number": "رقم الاشعار",
-  "vendor_credit.field.note": "ملاحظة",
-  "vendor_credit.field.created_at": "أنشئت في",
-  "vendor_credit.field.reference_no": "رقم الإشاري",
-
-  "vendor_credit.field.status": "الحالة",
-  "vendor_credit.field.status.draft": "مسودة",
-  "vendor_credit.field.status.published": "تم نشرها",
-  "vendor_credit.field.status.open": "مفتوحة",
-  "vendor_credit.field.status.closed": "مغلقة",
-
-  "credit_note.field.terms_conditions": "الشروط والاحكام",
-  "credit_note.field.note": "ملاحظة",
-  "credit_note.field.currency_code": "العملة",
-  "credit_note.field.created_at": "أنشئت في",
-  "credit_note.field.amount": "القيمة",
-  "credit_note.field.credit_note_number": "رقم الاشعار",
-  "credit_note.field.credit_note_date": "تاريخ الاشعار",
-  "credit_note.field.customer": "الزبون",
-  "credit_note.field.reference_no": "رقم الإشاري",
-
-  "credit_note.field.status": "الحالة",
-  "credit_note.field.status.draft": "مسودة",
-  "credit_note.field.status.published": "تم نشرها",
-  "credit_note.field.status.open": "مفتوحة",
-  "credit_note.field.status.closed": "مغلقة",
-
-  "transactions_locking.module.sales.label": "المبيعات",
-  "transactions_locking.module.purchases.label": "المشتريات",
-  "transactions_locking.module.financial.label": "المالية",
-  "transactions_locking.module.all_transactions": "كل المعاملات",
-
-  "transactions_locking.module.sales.desc": "فواتير البيع ، والإيصالات ، والإشعارات الدائنة ، واستلام مدفوعات الزبائن ، والأرصدة الافتتاحية للزبائن.",
-  "transactions_locking.module.purchases.desc": "فواتير الشراء ومدفوعات الموردين وإشعارات المدينة والأرصدة الافتتاحية للموردين.",
-  "transactions_locking.module.financial.desc": "القيود اليدوية والمصروفات وتسويات المخزون.",
-
-  "inventory_adjustment.type.increment": "زيادة",
-  "inventory_adjustment.type.decrement": "نقصان",
-
-  "customer.type.individual": "فرد",
-  "customer.type.business": "اعمال",
-
-  "credit_note.view.draft": "مسودة",
-  "credit_note.view.closed": "مغلقة",
-  "credit_note.view.open": "مفتوحة",
-  "credit_note.view.published": "نشرت",
-
-  "vendor_credit.view.draft": "مسودة",
-  "vendor_credit.view.closed": "مغلقة",
-  "vendor_credit.view.open": "مفتوحة",
-  "vendor_credit.view.published": "نشرت",
-
-  "allocation_method.value.label": "القيمة",
-  "allocation_method.quantity.label": "الكمية",
-
-  "balance_sheet.assets": "الأصول",
-  "balance_sheet.current_asset": "الأصول المتداولة",
-  "balance_sheet.cash_and_cash_equivalents": "النقدية وما يعادلها",
-  "balance_sheet.accounts_receivable": "الذمم المدينة",
-  "balance_sheet.inventory": "المخزون",
-  "balance_sheet.other_current_assets": "اصول متداولة اخرى",
-  "balance_sheet.fixed_asset": "الأصول الثابتة",
-  "balance_sheet.non_current_assets": "الاصول غير المتداولة",
-  "balance_sheet.liabilities_and_equity": "الالتزامات وحقوق الملكية",
-  "balance_sheet.liabilities": "الإلتزامات",
-  "balance_sheet.current_liabilties": "الالتزامات المتداولة",
-  "balance_sheet.long_term_liabilities": "الالتزامات طويلة الاجل",
-  "balance_sheet.non_current_liabilities": "الالتزامات غير المتداولة",
-  "balance_sheet.equity": "حقوق الملكية",
-
-  "balance_sheet.account_name": "اسم الحساب",
-  "balance_sheet.total": "إجمالي",
-  "balance_sheet.percentage_of_column": "٪ التغير العمودي",
-  "balance_sheet.percentage_of_row": "٪ التغير الأفقي",
-
-  "financial_sheet.previoud_period_date": "(ف.س) {{date}}",
-  "fianncial_sheet.previous_period_change": "التغيرات (ف.س)",
-  "financial_sheet.previous_period_percentage": "٪ التغير (ف.س)",
-
-  "financial_sheet.previous_year_date": "(س.س) {{date}}",
-  "financial_sheet.previous_year_change": "التغيرات (س.س)",
-  "financial_sheet.previous_year_percentage": "٪ التغير (س.س)",
-  "financial_sheet.total_row": "إجمالي {{value}}",
-
-  "profit_loss_sheet.income": "الإيرادات",
-  "profit_loss_sheet.cost_of_sales": "تكلفة المبيعات",
-  "profit_loss_sheet.gross_profit": "إجمالي الدخل",
-  "profit_loss_sheet.expenses": "المصروفات",
-  "profit_loss_sheet.net_operating_income": "صافي الدخل التشغيلي",
-  "profit_loss_sheet.other_income": "إيرادات اخري",
-  "profit_loss_sheet.other_expenses": "مصاريف اخري",
-  "profit_loss_sheet.net_income": "صافي الدخل",
-
-  "profit_loss_sheet.account_name": "اسم الحساب",
-  "profit_loss_sheet.total": "إجمالي",
-
-  "profit_loss_sheet.percentage_of_income": "٪ التغير في الإيرادات",
-  "profit_loss_sheet.percentage_of_expenses": "٪ التغير في المصاريف",
-  "profit_loss_sheet.percentage_of_column": "٪ التغير العمودي",
-  "profit_loss_sheet.percentage_of_row": "٪ التغير الأفقي",
-
-  "warehouses.primary_warehouse": "المستودع الرئيسي",
-  "branches.head_branch": "الفرع الرئيسي",
-
-  "account.accounts_payable.currency": "الذمم الدائنة - {{currency}}",
-  "account.accounts_receivable.currency": "الذمم المدينة - {{currency}}",
-
-  "role.admin.name": "الادارة",
-  "role.admin.desc": "وصول غير مقيد لجميع الوحدات.",
-
-  "role.staff.name": "العاملين",
-  "role.staff.desc": "الوصول إلى جميع الوحدات باستثناء التقارير والإعدادات والمحاسبة.",
-
-  "warehouse_transfer.view.draft.name": "مسودة",
-  "warehouse_transfer.view.in_transit.name": "في النقل",
-  "warehouse_transfer.view.transferred.name": "تم النقل"
-}

packages/server/src/locales/en.json

@@ -1,641 +0,0 @@
-{
-  "Petty Cash": "Petty Cash",
-  "Cash": "Cash",
-  "Bank": "Bank",
-  "Other Income": "Other Income",
-  "Interest Income": "Interest Income",
-  "Depreciation Expense": "Depreciation Expense",
-  "Interest Expense": "Interest Expense",
-  "Sales of Product Income": "Sales of Product Income",
-  "Inventory Asset": "Inventory Asset",
-  "Cost of Goods Sold (COGS)": "Cost of Goods Sold (COGS)",
-  "Cost of Goods Sold": "Cost of Goods Sold",
-  "Accounts Payable": "Accounts Payable",
-  "Other Expense": "Other Expense",
-  "Payroll Expenses": "Payroll Expenses",
-  "Fixed Asset": "Fixed Asset",
-  "Credit Card": "Credit Card",
-  "Non-Current Asset": "Non-Current Asset",
-  "Current Asset": "Current Asset",
-  "Other Asset": "Other Asset",
-  "Long Term Liability": "Long Term Liability",
-  "Current Liability": "Current Liability",
-  "Other Liability": "Other Liability",
-  "Equity": "Equity",
-  "Expense": "Expense",
-  "Income": "Income",
-  "Accounts Receivable (A/R)": "Accounts Receivable (A/R)",
-  "Accounts Receivable": "Accounts Receivable",
-  "Accounts Payable (A/P)": "Accounts Payable (A/P)",
-  "Inactive": "Inactive",
-  "Other Current Asset": "Other Current Asset",
-  "Tax Payable": "Tax Payable",
-  "Other Current Liability": "Other Current Liability",
-  "Non-Current Liability": "Non-Current Liability",
-  "Assets": "Assets",
-  "Liabilities": "Liabilities",
-  "Account name": "Account name",
-  "Account type": "Account type",
-  "Account normal": "Account normal",
-  "Description": "Description",
-  "Account code": "Account code",
-  "Currency": "Currency",
-  "Balance": "Balance",
-  "Active": "Active",
-  "Created at": "Created at",
-  "fixed_asset": "Fixed asset",
-  "Journal": "Journal",
-  "Reconciliation": "Reconciliation",
-  "Credit": "Credit",
-  "Debit": "Debit",
-  "Interest": "Interest",
-  "Depreciation": "Depreciation",
-  "Payroll": "Payroll",
-  "Type": "Type",
-  "Name": "Name",
-  "Sellable": "Sellable",
-  "Purchasable": "Purchasable",
-  "Sell price": "Sell price",
-  "Cost price": "Cost price",
-  "User": "User",
-  "Category": "Category",
-  "Note": "Note",
-  "Quantity on hand": "Quantity on hand",
-  "Quantity": "Quantity",
-  "Purchase description": "Purchase description",
-  "Sell description": "Sell description",
-  "Sell account": "Sell account",
-  "Cost account": "Cost account",
-  "Inventory account": "Inventory account",
-  "Payment date": "Payment date",
-  "Payment account": "Payment account",
-  "Amount": "Amount",
-  "Reference No.": "Reference No.",
-  "Journal number": "Journal number",
-  "Status": "Status",
-  "Journal type": "Journal type",
-  "Date": "Date",
-  "Asset": "Asset",
-  "Liability": "Liability",
-  "First-in first-out (FIFO)": "First-in first-out (FIFO)",
-  "Last-in first-out (LIFO)": "Last-in first-out (LIFO)",
-  "Average rate": "Average rate",
-  "Total": "Total",
-  "Transaction type": "Transaction type",
-  "Transaction #": "Transaction #",
-  "Running Value": "Running Value",
-  "Running quantity": "Running quantity",
-  "Profit Margin": "Profit Margin",
-  "Value": "Value",
-  "Rate": "Rate",
-  "OPERATING ACTIVITIES": "OPERATING ACTIVITIES",
-  "FINANCIAL ACTIVITIES": "FINANCIAL ACTIVITIES",
-  "Net income": "Net income",
-  "Adjustments net income by operating activities.": "Adjustments net income by operating activities.",
-  "Net cash provided by operating activities": "Net cash provided by operating activities",
-  "Net cash provided by investing activities": "Net cash provided by investing activities",
-  "Net cash provided by financing activities": "Net cash provided by financing activities",
-  "Cash at beginning of period": "Cash at beginning of period",
-  "NET CASH INCREASE FOR PERIOD": "NET CASH INCREASE FOR PERIOD",
-  "CASH AT END OF PERIOD": "CASH AT END OF PERIOD",
-  "Expenses": "Expenses",
-  "Services": "Services",
-  "Inventory": "Inventory",
-  "Non Inventory": "Non Inventory",
-  "Draft": "Draft",
-  "Published": "Published",
-  "Delivered": "Delivered",
-  "Overdue": "Overdue",
-  "Partially paid": "Partially paid",
-  "Paid": "Paid",
-  "Opened": "Opened",
-  "Unpaid": "Unpaid",
-  "Approved": "Approved",
-  "Rejected": "Rejected",
-  "Invoiced": "Invoiced",
-  "Expired": "Expired",
-  "Closed": "Closed",
-  "Manual journal": "Manual journal",
-  "Owner contribution": "Owner contribution",
-  "Transfer to account": "Transfer to account",
-  "Transfer from account": "Transfer from account",
-  "Other income": "Other income",
-  "Other expense": "Other expense",
-  "Owner drawing": "Owner drawing",
-  "Inventory adjustment": "Inventory adjustment",
-  "Customer opening balance": "Customer opening balance",
-  "Vendor opening balance": "Vendor opening balance",
-  "Payment made": "Payment made",
-  "Bill": "Bill",
-  "Payment receive": "Payment receive",
-  "Sale receipt": "Sale receipt",
-  "Sale invoice": "Sale invoice",
-  "Bank Account": "Bank Account",
-  "Saving Bank Account": "Saving Bank Account",
-  "Undeposited Funds": "Undeposited Funds",
-  "Computer Equipment": "Computer Equipment",
-  "Office Equipment": "Office Equipment",
-  "Uncategorized Income": "Uncategorized Income",
-  "Sales of Service Income": "Sales of Service Income",
-  "Bank Fees and Charges": "Bank Fees and Charges",
-  "Exchange Gain or Loss": "Exchange Gain or Loss",
-  "Rent": "Rent",
-  "Office expenses": "Office expenses",
-  "Other Expenses": "Other Expenses",
-  "Drawings": "Drawings",
-  "Owner's Equity": "Owner's Equity",
-  "Opening Balance Equity": "Opening Balance Equity",
-  "Retained Earnings": "Retained Earnings",
-  "Sales Tax Payable": "Sales Tax Payable",
-  "Revenue Received in Advance": "Revenue Received in Advance",
-  "Opening Balance Liabilities": "Opening Balance Liabilities",
-  "Loan": "Loan",
-  "Owner A Drawings": "Owner A Drawings",
-  "An account that holds valuation of products or goods that available for sale.": "An account that holds valuation of products or goods that available for sale.",
-  "Tracks the gain and losses of the exchange differences.": "Tracks the gain and losses of the exchange differences.",
-  "Any bank fees levied is recorded into the bank fees and charges account. A bank account maintenance fee, transaction charges, a late payment fee are some examples.": "Any bank fees levied is recorded into the bank fees and charges account. A bank account maintenance fee, transaction charges, a late payment fee are some examples.",
-  "The income activities are not associated to the core business.": "The income activities are not associated to the core business.",
-  "Cash and cash equivalents": "Cash and cash equivalents",
-  "Inventories": "Inventories",
-  "Other current assets": "Other current assets",
-  "Non-Current Assets": "Non-Current Assets",
-  "Current Liabilties": "Current Liabilties",
-  "Long-Term Liabilities": "Long-Term Liabilities",
-  "Non-Current Liabilities": "Non-Current Liabilities",
-  "Liabilities and Equity": "Liabilities and Equity",
-  "Closing balance": "Closing balance",
-  "Opening Balance": "Opening balance",
-  "Total {{accountName}}": "Total {{accountName}}",
-  "invoice.paper.invoice": "Invoice",
-  "invoice.paper.invoice_amount": "Invoice amount",
-  "invoice.paper.due_amount": "Due amount",
-  "invoice.paper.billed_to": "Billed to",
-  "invoice.paper.invoice_date": "Invoice date",
-  "invoice.paper.invoice_number": "Invoice No.",
-  "invoice.paper.due_date": "Due date",
-  "invoice.paper.conditions_title": "Conditions & terms",
-  "invoice.paper.notes_title": "Notes",
-  "invoice.paper.total": "Total",
-  "invoice.paper.payment_amount": "Payment Amount",
-  "invoice.paper.balance_due": "Balance Due",
-
-  "item_entry.paper.item_name": "Item name",
-  "item_entry.paper.rate": "Rate",
-  "item_entry.paper.quantity": "Quantity",
-  "item_entry.paper.total": "Total",
-
-  "estimate.paper.estimate": "Estimate",
-  "estimate.paper.estimate_amount": "Estimate amount",
-  "estimate.paper.billed_to": "Billed to",
-  "estimate.paper.estimate_date": "Estimate date",
-  "estimate.paper.estimate_number": "Estimate number",
-  "estimate.paper.expiration_date": "Expiration date",
-  "estimate.paper.conditions_title": "Conditions & terms",
-  "estimate.paper.notes_title": "Notes",
-  "estimate.paper.amount": "Estimate amount",
-  "estimate.paper.subtotal": "Subtotal",
-  "estimate.paper.total": "Total",
-
-  "receipt.paper.receipt": "Receipt",
-  "receipt.paper.billed_to": "Billed to",
-  "receipt.paper.receipt_date": "Receipt date",
-  "receipt.paper.receipt_number": "Receipt number",
-  "receipt.paper.expiration_date": "Expiration date",
-  "receipt.paper.conditions_title": "Conditions & terms",
-  "receipt.paper.notes": "Notes",
-  "receipt.paper.statement": "Statement",
-  "receipt.paper.receipt_amount": "Receipt amount",
-  "receipt.paper.total": "Total",
-  "receipt.paper.balance_due": "Balance Due",
-  "receipt.paper.payment_amount": "Payment Amount",
-
-  "credit.paper.credit_note": "Credit Note",
-  "credit.paper.remaining": "Credit remaining",
-  "credit.paper.amount": "Credit amount",
-  "credit.paper.billed_to": "Bill to",
-  "credit.paper.credit_date": "Credit date",
-  "credit.paper.total": "Total",
-  "credit.paper.credits_used": "Credits used",
-  "credit.paper.credits_remaining": "Credits remaining",
-  "credit.paper.conditions_title": "Conditions & terms",
-  "credit.paper.notes": "Notes",
-
-  "payment.paper.payment_receipt": "Payment Receipt",
-  "payment.paper.amount_received": "Amount received",
-  "payment.paper.billed_to": "Billed to",
-  "payment.paper.payment_date": "Payment date",
-  "payment.paper.invoice_number": "Invoice number",
-  "payment.paper.invoice_date": "Invoice date",
-  "payment.paper.invoice_amount": "Invoice amount",
-  "payment.paper.payment_amount": "Payment amount",
-  "payment.paper.balance_due": "Balance Due",
-  "payment.paper.statement": "Statement",
-
-  "account.field.name": "Account name",
-  "account.field.description": "Description",
-  "account.field.slug": "Account slug",
-  "account.field.code": "Account code",
-  "account.field.root_type": "Root type",
-  "account.field.normal": "Account normal",
-  "account.field.normal.credit": "Credit",
-  "account.field.normal.debit": "Debit",
-  "account.field.type": "Type",
-  "account.field.active": "Activity",
-  "account.field.balance": "Balance",
-  "account.field.created_at": "Created at",
-  "item.field.type": "Item type",
-  "item.field.type.inventory": "Inventory",
-  "item.field.type.service": "Service",
-  "item.field.type.non-inventory": "Non inventory",
-  "item.field.name": "Name",
-  "item.field.code": "Code",
-  "item.field.sellable": "Sellable",
-  "item.field.purchasable": "Purchasable",
-  "item.field.cost_price": "Cost price",
-  "item.field.cost_account": "Cost account",
-  "item.field.sell_account": "Sell account",
-  "item.field.sell_description": "Sell description",
-  "item.field.inventory_account": "Inventory account",
-  "item.field.purchase_description": "Purchase description",
-  "item.field.quantity_on_hand": "Quantity on hand",
-  "item.field.note": "Note",
-  "item.field.category": "Category",
-  "item.field.active": "Active",
-  "item.field.created_at": "Created at",
-  "item_category.field.name": "Name",
-  "item_category.field.description": "Description",
-  "item_category.field.count": "Count",
-  "item_category.field.created_at": "Created at",
-  "invoice.field.customer": "Customer",
-  "invoice.field.invoice_date": "Invoice date",
-  "invoice.field.due_date": "Due date",
-  "invoice.field.invoice_no": "Invoice No.",
-  "invoice.field.reference_no": "Reference No.",
-  "invoice.field.invoice_message": "Invoice message",
-  "invoice.field.terms_conditions": "Terms & conditions",
-  "invoice.field.amount": "Amount",
-  "invoice.field.payment_amount": "Payment amount",
-  "invoice.field.due_amount": "Due amount",
-  "invoice.field.status": "Status",
-  "invoice.field.status.paid": "Paid",
-  "invoice.field.status.partially-paid": "Partially paid",
-  "invoice.field.status.overdue": "Overdue",
-  "invoice.field.status.unpaid": "Unpaid",
-  "invoice.field.status.delivered": "Delivered",
-  "invoice.field.status.draft": "Draft",
-  "invoice.field.created_at": "Created at",
-  "estimate.field.amount": "Amount",
-  "estimate.field.estimate_number": "Estimate number",
-  "estimate.field.customer": "Customer",
-  "estimate.field.estimate_date": "Estimate date",
-  "estimate.field.expiration_date": "Expiration date",
-  "estimate.field.reference_no": "Reference No.",
-  "estimate.field.note": "Note",
-  "estimate.field.terms_conditions": "Terms & conditions",
-  "estimate.field.status": "Status",
-  "estimate.field.status.delivered": "Delivered",
-  "estimate.field.status.rejected": "Rejected",
-  "estimate.field.status.approved": "Approved",
-  "estimate.field.status.draft": "Draft",
-  "estimate.field.created_at": "Created at",
-  "payment_receive.field.customer": "Customer",
-  "payment_receive.field.payment_date": "Payment date",
-  "payment_receive.field.amount": "Amount",
-  "payment_receive.field.reference_no": "Reference No.",
-  "payment_receive.field.deposit_account": "Deposit account",
-  "payment_receive.field.payment_receive_no": "Payment receive No.",
-  "payment_receive.field.statement": "Statement",
-  "payment_receive.field.created_at": "Created at",
-  "bill_payment.field.vendor": "Vendor",
-  "bill_payment.field.amount": "Amount",
-  "bill_payment.field.due_amount": "Due amount",
-  "bill_payment.field.payment_account": "Payment account",
-  "bill_payment.field.payment_number": "Payment number",
-  "bill_payment.field.payment_date": "Payment date",
-  "bill_payment.field.reference_no": "Reference No.",
-  "bill_payment.field.description": "Description",
-  "bill_payment.field.created_at": "Created at",
-  "bill.field.vendor": "Vendor",
-  "bill.field.bill_number": "Bill number",
-  "bill.field.bill_date": "Bill date",
-  "bill.field.due_date": "Due date",
-  "bill.field.reference_no": "Reference No.",
-  "bill.field.status": "Status",
-  "bill.field.status.paid": "Paid",
-  "bill.field.status.partially-paid": "Partially paid",
-  "bill.field.status.unpaid": "Unpaid",
-  "bill.field.status.opened": "Opened",
-  "bill.field.status.draft": "Draft",
-  "bill.field.status.overdue": "overdue",
-  "bill.field.amount": "Amount",
-  "bill.field.payment_amount": "Payment amount",
-  "bill.field.note": "Note",
-  "bill.field.created_at": "Created at",
-  "inventory_adjustment.field.date": "Date",
-  "inventory_adjustment.field.type": "Type",
-  "inventory_adjustment.field.type.increment": "Increment",
-  "inventory_adjustment.field.type.decrement": "Decrement",
-  "inventory_adjustment.field.adjustment_account": "Adjustment account",
-  "inventory_adjustment.field.reason": "Reason",
-  "inventory_adjustment.field.reference_no": "Reference No.",
-  "inventory_adjustment.field.description": "Description",
-  "inventory_adjustment.field.published_at": "Published at",
-  "inventory_adjustment.field.created_at": "Created at",
-  "expense.field.payment_date": "Payment date",
-  "expense.field.payment_account": "Payment account",
-  "expense.field.amount": "Amount",
-  "expense.field.reference_no": "Reference No.",
-  "expense.field.description": "Description",
-  "expense.field.published": "Published",
-  "expense.field.status": "Status",
-  "expense.field.status.draft": "Draft",
-  "expense.field.status.published": "Published",
-  "expense.field.created_at": "Created at",
-  "manual_journal.field.date": "Date",
-  "manual_journal.field.journal_number": "Journal number",
-  "manual_journal.field.reference": "Reference No.",
-  "manual_journal.field.journal_type": "Journal type",
-  "manual_journal.field.amount": "Amount",
-  "manual_journal.field.description": "Description",
-  "manual_journal.field.status": "Status",
-  "manual_journal.field.created_at": "Created at",
-  "receipt.field.amount": "Amount",
-  "receipt.field.deposit_account": "Deposit account",
-  "receipt.field.customer": "Customer",
-  "receipt.field.receipt_date": "Receipt date",
-  "receipt.field.receipt_number": "Receipt number",
-  "receipt.field.reference_no": "Reference No.",
-  "receipt.field.receipt_message": "Receipt message",
-  "receipt.field.statement": "Statement",
-  "receipt.field.created_at": "Created at",
-  "receipt.field.status": "Status",
-  "receipt.field.status.draft": "Draft",
-  "receipt.field.status.closed": "Closed",
-  "customer.field.first_name": "First name",
-  "customer.field.last_name": "Last name",
-  "customer.field.display_name": "Display name",
-  "customer.field.email": "Email",
-  "customer.field.work_phone": "Work phone",
-  "customer.field.personal_phone": "Personal phone",
-  "customer.field.company_name": "Company name",
-  "customer.field.website": "Website",
-  "customer.field.opening_balance_at": "Opening balance at",
-  "customer.field.opening_balance": "Opening balance",
-  "customer.field.created_at": "Created at",
-  "customer.field.balance": "Balance",
-  "customer.field.status": "Status",
-  "customer.field.currency": "Curreny",
-  "customer.field.status.active": "Active",
-  "customer.field.status.inactive": "Inactive",
-  "customer.field.status.overdue": "Overdue",
-  "customer.field.status.unpaid": "Unpaid",
-  "vendor.field.first_name": "First name",
-  "vendor.field.last_name": "Last name",
-  "vendor.field.display_name": "Display name",
-  "vendor.field.email": "Email",
-  "vendor.field.work_phone": "Work phone",
-  "vendor.field.personal_phone": "Personal phone",
-  "vendor.field.company_name": "Company name",
-  "vendor.field.website": "Website",
-  "vendor.field.opening_balance_at": "Opening balance at",
-  "vendor.field.opening_balance": "Opening balance",
-  "vendor.field.created_at": "Created at",
-  "vendor.field.balance": "Balance",
-  "vendor.field.status": "Status",
-  "vendor.field.currency": "Curreny",
-  "vendor.field.status.active": "Active",
-  "vendor.field.status.inactive": "Inactive",
-  "vendor.field.status.overdue": "Overdue",
-  "vendor.field.status.unpaid": "Unpaid",
-  "Invoice write-off": "Invoice write-off",
-
-  "transaction_type.credit_note": "Credit note",
-  "transaction_type.refund_credit_note": "Refund credit note",
-  "transaction_type.vendor_credit": "Vendor credit",
-  "transaction_type.refund_vendor_credit": "Refund vendor credit",
-  "transaction_type.landed_cost": "Landed cost",
-
-  "sms_notification.invoice_details.label": "Sale invoice details",
-  "sms_notification.invoice_reminder.label": "Sale invoice reminder",
-  "sms_notification.receipt_details.label": "Sale receipt details",
-  "sms_notification.sale_estimate_details.label": "Sale estimate details",
-  "sms_notification.payment_receive_details.label": "Payment receive details",
-  "sms_notification.customer_balance.label": "Customer balance",
-
-  "sms_notification.invoice_details.description": "SMS notification will be sent to your customer once invoice created and published or when notify customer via SMS about the invoice.",
-  "sms_notification.payment_receive.description": "Payment thank you message notification will be sent to customer once the payment created and published or notify customer about payment manually.",
-  "sms_notification.receipt_details.description": "SMS notification will be sent to your cusotmer once receipt created and published or when notify customer about the receipt manually.",
-  "sms_notification.customer_balance.description": "Send SMS to notify customers about their current outstanding balance.",
-  "sms_notification.estimate_details.description": "SMS notification will be sent to your customer once estimate publish or notify customer about estimate manually.",
-  "sms_notification.invoice_reminder.description": "SMS notification will be sent to remind the customer to pay earliest, either automatically or manually.",
-
-  "sms_notification.customer_balance.default_message": "Dear {CustomerName}, This is reminder about your current outstanding balance of {Balance}, Please pay at the earliest. - {CompanyName}",
-  "sms_notification.payment_receive.default_message": "'Hi, {CustomerName}, We have received your payment for the invoice - {InvoiceNumber}. We look forward to serving you again. Thank you. - {CompanyName}'",
-  "sms_notification.estimate.default_message": "Hi, {CustomerName}, We have created an estimate - {EstimateNumber} for you. Please take a look and accept it to proceed further. Looking forward to hearing from you. - {CompanyName}",
-
-  "sms_notification.invoice_details.default_message": "Hi, {CustomerName}, You have an outstanding amount of {DueAmount} for the invoice {InvoiceNumber}. - {CompanyName}",
-  "sms_notification.receipt_details.default_message": "Hi, {CustomerName}, We have created receipt - {ReceiptNumber} for you. we look forward to serveing you again. Thank your - {CompanyName}",
-  "sms_notification.invoice_reminder.default_message": "Dear {CustomerName}, The payment towards the invoice - {InvoiceNumber} is due. Please pay before {DueDate}. Thank you. - {CompanyName}",
-
-  "module.sale_invoices.label": "Sale invoices",
-  "module.sale_receipts.label": "Sale receipts",
-  "module.sale_estimates.label": "Sale estimates",
-  "module.payment_receives.label": "Payment receive",
-  "module.customers.label": "Customers",
-
-  "sms_notification.invoice.var.invoice_number": "References to invoice number.",
-  "sms_notification.invoice.var.reference_number": "References to invoice reference number.",
-  "sms_notification.invoice.var.customer_name": "References to invoice customer name.",
-  "sms_notification.invoice.var.due_amount": "References to invoice due amount.",
-  "sms_notification.invoice.var.amount": "References to invoice amount.",
-  "sms_notification.invoice.var.company_name": "References to company name.",
-  "sms_notification.invoice.var.due_date": "References to invoice due date.",
-
-  "sms_notification.receipt.var.receipt_number": "References to receipt number.",
-  "sms_notification.receipt.var.reference_number": "References to receipt reference number.",
-  "sms_notification.receipt.var.customer_name": "References to receipt customer name.",
-  "sms_notification.receipt.var.amount": "References to receipt amount.",
-  "sms_notification.receipt.var.company_name": "References to company name.",
-
-  "sms_notification.payment.var.payment_number": "References to payment transaction number.",
-  "sms_notification.payment.var.reference_number": "References to payment reference number",
-  "sms_notification.payment.var.customer_name": "References to payment customer name.",
-  "sms_notification.payment.var.amount": "References to payment transaction amount.",
-  "sms_notification.payment.company_name": "References to company name",
-  "sms_notification.payment.var.invoice_number": "Reference to payment invoice number.",
-
-  "sms_notification.estimate.var.estimate_number": "References to estimate number.",
-  "sms_notification.estimate.var.reference_number": "References to estimate reference number.",
-  "sms_notification.estimate.var.customer_name": "References to estimate customer name.",
-  "sms_notification.estimate.var.amount": "References to estimate amount.",
-  "sms_notification.estimate.var.company_name": "References to company name.",
-  "sms_notification.estimate.var.expiration_date": "References to estimate expirtaion date.",
-  "sms_notification.estimate.var.estimate_date": "References to estimate date.",
-
-  "sms_notification.customer.var.customer_name": "References to customer name.",
-  "sms_notification.customer.var.balance": "References to customer outstanding balance.",
-  "sms_notification.customer.var.company_name": "References to company name.",
-
-  "ability.accounts": "Chart of accounts",
-  "ability.manual_journal": "Manual journals",
-  "ability.cashflow": "Cash flow",
-  "ability.inventory_adjustment": "Inventory adjustments",
-  "ability.customers": "Customers",
-  "ability.vendors": "vendors",
-  "ability.sale_estimates": "Sale estimates",
-  "ability.sale_invoices": "Sale invoices",
-  "ability.sale_receipts": "Sale receipts",
-  "ability.expenses": "Expenses",
-  "ability.payments_receive": "Payments receive",
-  "ability.purchase_invoices": "Purchase invoices",
-  "ability.all_reports": "All reports",
-  "ability.payments_made": "Payments made",
-  "ability.preferences": "Preferences",
-  "ability.mutate_system_preferences": "Mutate the system preferences.",
-
-  "ability.items": "Items",
-  "ability.view": "View",
-  "ability.create": "Create",
-  "ability.edit": "Edit",
-  "ability.delete": "Delete",
-  "ability.transactions_locking": "Ability to transactions locking.",
-
-  "ability.balance_sheet_report": "Balance sheet.",
-  "ability.profit_loss_sheet": "Profit/loss sheet",
-  "ability.journal": "Journal",
-  "ability.general_ledger": "General ledger",
-  "ability.cashflow_report": "Cashflow",
-  "ability.AR_aging_summary_report": "A/R aging summary",
-  "ability.AP_aging_summary_report": "A/P aging summary",
-  "ability.purchases_by_items": "Purchases by items",
-  "ability.sales_by_items_report": "Sales by items",
-  "ability.customers_transactions_report": "Customers transactions",
-  "ability.vendors_transactions_report": "Vendors transactions",
-  "ability.customers_summary_balance_report": "Customers summary balance",
-  "ability.vendors_summary_balance_report": "Vendors summary balance",
-  "ability.inventory_valuation_summary": "Inventory valuation summary",
-  "ability.inventory_items_details": "Inventory items details",
-
-  "vendor_credit.field.vendor": "Vendor name",
-  "vendor_credit.field.amount": "Amount",
-  "vendor_credit.field.currency_code": "Currency code",
-  "vendor_credit.field.credit_date": "Credit date",
-  "vendor_credit.field.credit_number": "Credit number",
-  "vendor_credit.field.note": "Note",
-  "vendor_credit.field.created_at": "Created at",
-  "vendor_credit.field.reference_no": "Reference No.",
-
-  "credit_note.field.terms_conditions": "Terms and conditions",
-  "credit_note.field.note": "Note",
-  "credit_note.field.currency_code": "Currency code",
-  "credit_note.field.created_at": "Created at",
-  "credit_note.field.amount": "Amount",
-  "credit_note.field.credit_note_number": "Credit note number",
-  "credit_note.field.credit_note_date": "Credit date",
-  "credit_note.field.customer": "Customer",
-  "credit_note.field.reference_no": "Reference No.",
-
-  "Credit note": "Credit note",
-  "Vendor credit": "Vendor credit",
-  "Refund credit note": "Refund credit note",
-  "Refund vendor credit": "Refund vendor credit",
-  "credit_note.field.status": "Status",
-  "credit_note.field.status.draft": "Draft",
-  "credit_note.field.status.published": "Published",
-  "credit_note.field.status.open": "Open",
-  "credit_note.field.status.closed": "Closed",
-
-  "transactions_locking.module.sales.label": "Sales",
-  "transactions_locking.module.purchases.label": "Purchases",
-  "transactions_locking.module.financial.label": "Financial",
-  "transactions_locking.module.all_transactions": "All transactions",
-
-  "transactions_locking.module.sales.desc": "Sale invoices, Receipts, credit notes, customers payment receive and customers opening balances.",
-  "transactions_locking.module.purchases.desc": "Purchase invoices, vendors payments, vendor credit notes and vendors opening balances.",
-  "transactions_locking.module.financial.desc": "Manual journal, expenses and inventory adjustments.",
-
-  "inventory_adjustment.type.increment": "Increment",
-  "inventory_adjustment.type.decrement": "Decrement",
-
-  "customer.type.individual": "Individual",
-  "customer.type.business": "Business",
-
-  "credit_note.view.draft": "Draft",
-  "credit_note.view.closed": "Closed",
-  "credit_note.view.open": "Open",
-  "credit_note.view.published": "Published",
-
-  "vendor_credit.view.draft": "Draft",
-  "vendor_credit.view.closed": "Closed",
-  "vendor_credit.view.open": "Open",
-  "vendor_credit.view.published": "Published",
-
-  "allocation_method.value.label": "Value",
-  "allocation_method.quantity.label": "Quantity",
-
-  "balance_sheet.assets": "Assets",
-  "balance_sheet.current_asset": "Current Asset",
-  "balance_sheet.cash_and_cash_equivalents": "Cash and cash equivalents",
-  "balance_sheet.accounts_receivable": "Accounts Receivable",
-  "balance_sheet.inventory": "Inventory",
-  "balance_sheet.other_current_assets": "Other current assets",
-  "balance_sheet.fixed_asset": "Fixed Asset",
-  "balance_sheet.non_current_assets": "Non-Current Assets",
-  "balance_sheet.liabilities_and_equity": "Liabilities and Equity",
-  "balance_sheet.liabilities": "Liabilities",
-  "balance_sheet.current_liabilties": "Current Liabilties",
-  "balance_sheet.long_term_liabilities": "Long-Term Liabilities",
-  "balance_sheet.non_current_liabilities": "Non-Current Liabilities",
-  "balance_sheet.equity": "Equity",
-
-  "balance_sheet.account_name": "Account name",
-  "balance_sheet.total": "Total",
-  "balance_sheet.percentage_of_column": "% of Column",
-  "balance_sheet.percentage_of_row": "% of Row",
-
-  "financial_sheet.previoud_period_date": "{{date}} (PP)",
-  "fianncial_sheet.previous_period_change": "Change (PP)",
-  "financial_sheet.previous_period_percentage": "% Change (PP)",
-
-  "financial_sheet.previous_year_date": "{{date}} (PY)",
-  "financial_sheet.previous_year_change": "Change (PY)",
-  "financial_sheet.previous_year_percentage": "% Change (PY)",
-  "financial_sheet.total_row": "Total {{value}}",
-
-  "profit_loss_sheet.income": "Income",
-  "profit_loss_sheet.cost_of_sales": "Cost of sales",
-  "profit_loss_sheet.gross_profit": "GROSS PROFIT",
-  "profit_loss_sheet.expenses": "Expenses",
-  "profit_loss_sheet.net_operating_income": "NET OPERATING INCOME",
-  "profit_loss_sheet.other_income": "Other income",
-  "profit_loss_sheet.other_expenses": "Other expenses",
-  "profit_loss_sheet.net_income": "NET INCOME",
-
-  "profit_loss_sheet.account_name": "Account name",
-  "profit_loss_sheet.total": "Total",
-
-  "profit_loss_sheet.percentage_of_income": "% of Income",
-  "profit_loss_sheet.percentage_of_expenses": "% of Expenses",
-  "profit_loss_sheet.percentage_of_column": "% of Column",
-  "profit_loss_sheet.percentage_of_row": "% of Row",
-
-  "contact_summary_balance.account_name": "Account name",
-  "contact_summary_balance.total": "Total",
-  "contact_summary_balance.percentage_column": "% of Column",
-
-  "warehouses.primary_warehouse": "Primary warehouse",
-  "branches.head_branch": "Head Branch",
-
-  "account.accounts_payable.currency": "Accounts Payable (A/P) - {{currency}}",
-  "account.accounts_receivable.currency": "Accounts Receivable (A/R) - {{currency}}",
-
-  "role.admin.name": "Admin",
-  "role.admin.desc": "Unrestricted access to all modules.",
-
-  "role.staff.name": "Staff",
-  "role.staff.desc": "Access to all modules except reports, settings and accountant.",
-
-  "warehouse_transfer.view.draft.name": "Draft",
-  "warehouse_transfer.view.in_transit.name": "In Transit",
-  "warehouse_transfer.view.transferred.name": "Transferred"
-}

packages/server/src/models/Bill.ts

@@ -13,6 +13,109 @@ export default class Bill extends mixin(TenantModel, [
   CustomViewBaseModel,
   ModelSearchable,
 ]) {
+  public amount: number;
+  public paymentAmount: number;
+  public landedCostAmount: number;
+  public allocatedCostAmount: number;
+  public isInclusiveTax: boolean;
+  public taxAmountWithheld: number;
+  public exchangeRate: number;
+
+  /**
+   * Timestamps columns.
+   */
+  get timestamps() {
+    return ['createdAt', 'updatedAt'];
+  }
+
+  /**
+   * Virtual attributes.
+   */
+  static get virtualAttributes() {
+    return [
+      'balance',
+      'dueAmount',
+      'isOpen',
+      'isPartiallyPaid',
+      'isFullyPaid',
+      'isPaid',
+      'remainingDays',
+      'overdueDays',
+      'isOverdue',
+      'unallocatedCostAmount',
+      'localAmount',
+      'localAllocatedCostAmount',
+      'billableAmount',
+      'amountLocal',
+      'subtotal',
+      'subtotalLocal',
+      'subtotalExludingTax',
+      'taxAmountWithheldLocal',
+      'total',
+      'totalLocal',
+    ];
+  }
+
+  /**
+   * Invoice amount in base currency.
+   * @returns {number}
+   */
+  get amountLocal() {
+    return this.amount * this.exchangeRate;
+  }
+
+  /**
+   * Subtotal. (Tax inclusive) if the tax inclusive is enabled.
+   * @returns {number}
+   */
+  get subtotal() {
+    return this.amount;
+  }
+
+  /**
+   * Subtotal in base currency. (Tax inclusive) if the tax inclusive is enabled.
+   * @returns {number}
+   */
+  get subtotalLocal() {
+    return this.amountLocal;
+  }
+
+  /**
+   * Sale invoice amount excluding tax.
+   * @returns {number}
+   */
+  get subtotalExcludingTax() {
+    return this.isInclusiveTax
+      ? this.subtotal - this.taxAmountWithheld
+      : this.subtotal;
+  }
+
+  /**
+   * Tax amount withheld in base currency.
+   * @returns {number}
+   */
+  get taxAmountWithheldLocal() {
+    return this.taxAmountWithheld * this.exchangeRate;
+  }
+
+  /**
+   * Invoice total. (Tax included)
+   * @returns {number}
+   */
+  get total() {
+    return this.isInclusiveTax
+      ? this.subtotal
+      : this.subtotal + this.taxAmountWithheld;
+  }
+
+  /**
+   * Invoice total in local currency. (Tax included)
+   * @returns {number}
+   */
+  get totalLocal() {
+    return this.total * this.exchangeRate;
+  }
+
   /**
    * Table name
    */
@@ -158,40 +261,13 @@ export default class Bill extends mixin(TenantModel, [
     };
   }
 
-  /**
-   * Timestamps columns.
-   */
-  get timestamps() {
-    return ['createdAt', 'updatedAt'];
-  }
-
-  /**
-   * Virtual attributes.
-   */
-  static get virtualAttributes() {
-    return [
-      'balance',
-      'dueAmount',
-      'isOpen',
-      'isPartiallyPaid',
-      'isFullyPaid',
-      'isPaid',
-      'remainingDays',
-      'overdueDays',
-      'isOverdue',
-      'unallocatedCostAmount',
-      'localAmount',
-      'localAllocatedCostAmount',
-      'billableAmount',
-    ];
-  }
-
   /**
    * Invoice amount in organization base currency.
+   * @deprecated
    * @returns {number}
    */
   get localAmount() {
-    return this.amount * this.exchangeRate;
+    return this.amountLocal;
   }
 
   /**
@@ -231,7 +307,7 @@ export default class Bill extends mixin(TenantModel, [
    * @return {number}
    */
   get dueAmount() {
-    return Math.max(this.amount - this.balance, 0);
+    return Math.max(this.total - this.balance, 0);
   }
 
   /**
@@ -247,7 +323,7 @@ export default class Bill extends mixin(TenantModel, [
    * @return {boolean}
    */
   get isPartiallyPaid() {
-    return this.dueAmount !== this.amount && this.dueAmount > 0;
+    return this.dueAmount !== this.total && this.dueAmount > 0;
   }
 
   /**
@@ -308,7 +384,7 @@ export default class Bill extends mixin(TenantModel, [
    * Retrieves the calculated amount which have not been invoiced.
    */
   get billableAmount() {
-    return Math.max(this.amount - this.invoicedAmount, 0);
+    return Math.max(this.total - this.invoicedAmount, 0);
   }
 
   /**
@@ -326,6 +402,7 @@ export default class Bill extends mixin(TenantModel, [
     const ItemEntry = require('models/ItemEntry');
     const BillLandedCost = require('models/BillLandedCost');
     const Branch = require('models/Branch');
+    const TaxRateTransaction = require('models/TaxRateTransaction');
 
     return {
       vendor: {
@@ -373,6 +450,21 @@ export default class Bill extends mixin(TenantModel, [
           to: 'branches.id',
         },
       },
+
+      /**
+       * Bill may has associated tax rate transactions.
+       */
+      taxes: {
+        relation: Model.HasManyRelation,
+        modelClass: TaxRateTransaction.default,
+        join: {
+          from: 'bills.id',
+          to: 'tax_rate_transactions.referenceId',
+        },
+        filter(builder) {
+          builder.where('reference_type', 'Bill');
+        },
+      },
     };
   }
 

packages/server/src/models/Item.ts

@@ -65,6 +65,7 @@ export default class Item extends mixin(TenantModel, [
     const ItemEntry = require('models/ItemEntry');
     const WarehouseTransferEntry = require('models/WarehouseTransferEntry');
     const InventoryAdjustmentEntry = require('models/InventoryAdjustmentEntry');
+    const TaxRate = require('models/TaxRate');
 
     return {
       /**
@@ -178,6 +179,30 @@ export default class Item extends mixin(TenantModel, [
           to: 'media.id',
         },
       },
+
+      /**
+       * Item may has sell tax rate.
+       */
+      sellTaxRate: {
+        relation: Model.BelongsToOneRelation,
+        modelClass: TaxRate.default,
+        join: {
+          from: 'items.sellTaxRateId',
+          to: 'tax_rates.id',
+        },
+      },
+
+      /**
+       * Item may has purchase tax rate.
+       */
+      purchaseTaxRate: {
+        relation: Model.BelongsToOneRelation,
+        modelClass: TaxRate.default,
+        join: {
+          from: 'items.purchaseTaxRateId',
+          to: 'tax_rates.id',
+        },
+      },
     };
   }
 

packages/server/src/models/ItemEntry.ts

@@ -99,6 +99,13 @@ export default class ItemEntry extends TenantModel {
       : getExlusiveTaxAmount(this.amount, this.taxRate);
   }
 
+  static calcAmount(itemEntry) {
+    const { discount, quantity, rate } = itemEntry;
+    const total = quantity * rate;
+
+    return discount ? total - total * discount * 0.01 : total;
+  }
+
   /**
    * Item entry relations.
    */

packages/server/src/services/Accounting/Ledger.ts

@@ -1,5 +1,5 @@
 import moment from 'moment';
-import { defaultTo, uniqBy } from 'lodash';
+import { defaultTo, sumBy, uniqBy } from 'lodash';
 import { IAccountTransaction, ILedger, ILedgerEntry } from '@/interfaces';
 
 export default class Ledger implements ILedger {
@@ -49,6 +49,15 @@ export default class Ledger implements ILedger {
     return this.filter((entry) => entry.accountId === accountId);
   }
 
+  /**
+   * Filters entries by the given accounts ids then returns a new ledger.
+   * @param {number[]} accountIds 
+   * @returns {ILedger}
+   */
+  public whereAccountsIds(accountIds: number[]): ILedger {
+    return this.filter((entry) => accountIds.indexOf(entry.accountId) !== -1);
+  }
+
   /**
    * Filters entries that before or same the given date and returns a new ledger.
    * @param   {Date|string} fromDate
@@ -130,6 +139,22 @@ export default class Ledger implements ILedger {
     return closingBalance;
   }
 
+  /**
+   * Retrieves the closing credit of the entries.
+   * @returns {number}
+   */
+  public getClosingCredit(): number {
+    return sumBy(this.entries, 'credit');
+  }
+
+  /**
+   * Retrieves the closing debit of the entries.
+   * @returns {number}
+   */
+  public getClosingDebit(): number {
+    return sumBy(this.entries, 'debit');
+  }
+
   /**
    * Retrieve the closing balance of the entries.
    * @returns {number}

packages/server/src/services/CreditNotes/CreditNoteTransformer.ts

@@ -1,5 +1,7 @@
 import { Transformer } from '@/lib/Transformer/Transformer';
 import { formatNumber } from 'utils';
+import { ItemEntryTransformer } from '../Sales/Invoices/ItemEntryTransformer';
+import { ICreditNote } from '@/interfaces';
 
 export class CreditNoteTransformer extends Transformer {
   /**
@@ -11,7 +13,8 @@ export class CreditNoteTransformer extends Transformer {
       'formattedCreditsRemaining',
       'formattedCreditNoteDate',
       'formattedAmount',
-      'formattedCreditsUsed'
+      'formattedCreditsUsed',
+      'entries',
     ];
   };
 
@@ -56,4 +59,15 @@ export class CreditNoteTransformer extends Transformer {
       currencyCode: credit.currencyCode,
     });
   };
+
+  /**
+   * Retrieves the entries of the credit note.
+   * @param {ICreditNote} credit
+   * @returns {}
+   */
+  protected entries = (credit) => {
+    return this.item(credit.entries, new ItemEntryTransformer(), {
+      currencyCode: credit.currencyCode,
+    });
+  };
 }

packages/server/src/services/FinancialStatements/AgingSummary/APAgingSummaryApplication.ts

@@ -0,0 +1,53 @@
+import { Inject, Service } from 'typedi';
+import { APAgingSummaryExportInjectable } from './APAgingSummaryExportInjectable';
+import { APAgingSummaryTableInjectable } from './APAgingSummaryTableInjectable';
+import { IAPAgingSummaryQuery } from '@/interfaces';
+import { APAgingSummaryService } from './APAgingSummaryService';
+
+@Service()
+export class APAgingSummaryApplication {
+  @Inject()
+  private APAgingSummaryTable: APAgingSummaryTableInjectable;
+
+  @Inject()
+  private APAgingSummaryExport: APAgingSummaryExportInjectable;
+
+  @Inject()
+  private APAgingSummarySheet: APAgingSummaryService;
+
+  /**
+   * Retrieve the A/P aging summary in sheet format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public sheet(tenantId: number, query: IAPAgingSummaryQuery) {
+    return this.APAgingSummarySheet.APAgingSummary(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/P aging summary in table format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public table(tenantId: number, query: IAPAgingSummaryQuery) {
+    return this.APAgingSummaryTable.table(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/P aging summary in CSV format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public csv(tenantId: number, query: IAPAgingSummaryQuery) {
+    return this.APAgingSummaryExport.csv(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/P aging summary in XLSX format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public xlsx(tenantId: number, query: IAPAgingSummaryQuery) {
+    return this.APAgingSummaryExport.xlsx(tenantId, query);
+  }
+}

packages/server/src/services/FinancialStatements/AgingSummary/APAgingSummaryExportInjectable.ts

@@ -0,0 +1,43 @@
+import { Inject, Service } from 'typedi';
+import { APAgingSummaryTableInjectable } from './APAgingSummaryTableInjectable';
+import { TableSheet } from '@/lib/Xlsx/TableSheet';
+import { IAPAgingSummaryQuery } from '@/interfaces';
+
+@Service()
+export class APAgingSummaryExportInjectable {
+  @Inject()
+  private APAgingSummaryTable: APAgingSummaryTableInjectable;
+
+  /**
+   * Retrieves the A/P aging summary sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async xlsx(tenantId: number, query: IAPAgingSummaryQuery) {
+    const table = await this.APAgingSummaryTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToXLSX();
+
+    return tableSheet.convertToBuffer(tableCsv, 'xlsx');
+  }
+
+  /**
+   * Retrieves the A/P aging summary sheet in CSV format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async csv(
+    tenantId: number,
+    query: IAPAgingSummaryQuery
+  ): Promise<string> {
+    const table = await this.APAgingSummaryTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToCSV();
+
+    return tableCsv;
+  }
+}

packages/server/src/services/FinancialStatements/AgingSummary/APAgingSummaryService.ts

@@ -1,14 +1,13 @@
 import moment from 'moment';
 import { Inject, Service } from 'typedi';
+import { isEmpty } from 'lodash';
 import { IAPAgingSummaryQuery, IARAgingSummaryMeta } from '@/interfaces';
 import TenancyService from '@/services/Tenancy/TenancyService';
 import APAgingSummarySheet from './APAgingSummarySheet';
 import { Tenant } from '@/system/models';
-import { isEmpty } from 'lodash';
-import APAgingSummaryTable from './APAgingSummaryTable';
 
 @Service()
-export default class PayableAgingSummaryService {
+export class APAgingSummaryService {
   @Inject()
   tenancy: TenancyService;
 
@@ -18,7 +17,7 @@ export default class PayableAgingSummaryService {
   /**
    * Default report query.
    */
-  get defaultQuery(): IAPAgingSummaryQuery {
+  private get defaultQuery(): IAPAgingSummaryQuery {
     return {
       asDate: moment().format('YYYY-MM-DD'),
       agingDaysBefore: 30,
@@ -119,21 +118,4 @@ export default class PayableAgingSummaryService {
       meta: this.reportMetadata(tenantId),
     };
   }
-
-  /**
-   * Retrieves A/P aging summary in table format.
-   * @param {number} tenantId
-   * @param {IAPAgingSummaryQuery} query
-   */
-  async APAgingSummaryTable(tenantId: number, query: IAPAgingSummaryQuery) {
-    const report = await this.APAgingSummary(tenantId, query);
-    const table = new APAgingSummaryTable(report.data, query, {});
-
-    return {
-      columns: table.tableColumns(),
-      rows: table.tableRows(),
-      meta: report.meta,
-      query: report.query,
-    };
-  }
 }

packages/server/src/services/FinancialStatements/AgingSummary/APAgingSummaryTableInjectable.ts

@@ -0,0 +1,36 @@
+import { Inject, Service } from 'typedi';
+import { IAPAgingSummaryQuery, IAPAgingSummaryTable } from '@/interfaces';
+import { APAgingSummaryService } from './APAgingSummaryService';
+import APAgingSummaryTable from './APAgingSummaryTable';
+
+@Service()
+export class APAgingSummaryTableInjectable {
+  @Inject()
+  private APAgingSummarySheet: APAgingSummaryService;
+
+  /**
+   * Retrieves A/P aging summary in table format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   * @returns {Promise<IAPAgingSummaryTable>}
+   */
+  public async table(
+    tenantId: number,
+    query: IAPAgingSummaryQuery
+  ): Promise<IAPAgingSummaryTable> {
+    const report = await this.APAgingSummarySheet.APAgingSummary(
+      tenantId,
+      query
+    );
+    const table = new APAgingSummaryTable(report.data, query, {});
+
+    return {
+      table: {
+        columns: table.tableColumns(),
+        rows: table.tableRows(),
+      },
+      meta: report.meta,
+      query: report.query,
+    };
+  }
+}

packages/server/src/services/FinancialStatements/AgingSummary/ARAgingSummaryApplication.ts

@@ -0,0 +1,53 @@
+import { Inject, Service } from 'typedi';
+import { IARAgingSummaryQuery } from '@/interfaces';
+import { ARAgingSummaryTableInjectable } from './ARAgingSummaryTableInjectable';
+import { ARAgingSummaryExportInjectable } from './ARAgingSummaryExportInjectable';
+import ARAgingSummaryService from './ARAgingSummaryService';
+
+@Service()
+export class ARAgingSummaryApplication {
+  @Inject()
+  private ARAgingSummaryTable: ARAgingSummaryTableInjectable;
+
+  @Inject()
+  private ARAgingSummaryExport: ARAgingSummaryExportInjectable;
+
+  @Inject()
+  private ARAgingSummarySheet: ARAgingSummaryService;
+
+  /**
+   * Retrieve the A/R aging summary sheet.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public sheet(tenantId: number, query: IARAgingSummaryQuery) {
+    return this.ARAgingSummarySheet.ARAgingSummary(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/R aging summary in table format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public table(tenantId: number, query: IARAgingSummaryQuery) {
+    return this.ARAgingSummaryTable.table(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/R aging summary in XLSX format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public xlsx(tenantId: number, query: IARAgingSummaryQuery) {
+    return this.ARAgingSummaryExport.xlsx(tenantId, query);
+  }
+
+  /**
+   * Retrieve the A/R aging summary in CSV format.
+   * @param {number} tenantId
+   * @param {IAPAgingSummaryQuery} query
+   */
+  public csv(tenantId: number, query: IARAgingSummaryQuery) {
+    return this.ARAgingSummaryExport.csv(tenantId, query);
+  }
+}

packages/server/src/services/FinancialStatements/AgingSummary/ARAgingSummaryExportInjectable.ts

@@ -0,0 +1,46 @@
+import { Inject, Service } from 'typedi';
+import { TableSheet } from '@/lib/Xlsx/TableSheet';
+import { ARAgingSummaryTableInjectable } from './ARAgingSummaryTableInjectable';
+import { IARAgingSummaryQuery } from '@/interfaces';
+
+@Service()
+export class ARAgingSummaryExportInjectable {
+  @Inject()
+  private ARAgingSummaryTable: ARAgingSummaryTableInjectable;
+
+  /**
+   * Retrieves the A/R aging summary sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {IARAgingSummaryQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async xlsx(
+    tenantId: number,
+    query: IARAgingSummaryQuery
+  ): Promise<Buffer> {
+    const table = await this.ARAgingSummaryTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToXLSX();
+
+    return tableSheet.convertToBuffer(tableCsv, 'xlsx');
+  }
+
+  /**
+   * Retrieves the A/R aging summary sheet in CSV format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   * @returns {Promise<string>}
+   */
+  public async csv(
+    tenantId: number,
+    query: IARAgingSummaryQuery
+  ): Promise<string> {
+    const table = await this.ARAgingSummaryTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToCSV();
+
+    return tableCsv;
+  }
+}

packages/server/src/services/FinancialStatements/AgingSummary/ARAgingSummaryService.ts

@@ -5,7 +5,6 @@ import { IARAgingSummaryQuery, IARAgingSummaryMeta } from '@/interfaces';
 import TenancyService from '@/services/Tenancy/TenancyService';
 import ARAgingSummarySheet from './ARAgingSummarySheet';
 import { Tenant } from '@/system/models';
-import ARAgingSummaryTable from './ARAgingSummaryTable';
 
 @Service()
 export default class ARAgingSummaryService {
@@ -118,21 +117,4 @@ export default class ARAgingSummaryService {
       meta: this.reportMetadata(tenantId),
     };
   }
-
-  /**
-   * Retrieves A/R aging summary in table format.
-   * @param {number} tenantId
-   * @param {IARAgingSummaryQuery} query
-   */
-  async ARAgingSummaryTable(tenantId: number, query: IARAgingSummaryQuery) {
-    const report = await this.ARAgingSummary(tenantId, query);
-    const table = new ARAgingSummaryTable(report.data, query, {});
-
-    return {
-      columns: table.tableColumns(),
-      rows: table.tableRows(),
-      meta: report.meta,
-      query,
-    };
-  }
 }

packages/server/src/services/FinancialStatements/AgingSummary/ARAgingSummaryTableInjectable.ts

@@ -0,0 +1,36 @@
+import { IARAgingSummaryQuery, IARAgingSummaryTable } from '@/interfaces';
+import { Inject, Service } from 'typedi';
+import ARAgingSummaryTable from './ARAgingSummaryTable';
+import ARAgingSummaryService from './ARAgingSummaryService';
+
+@Service()
+export class ARAgingSummaryTableInjectable {
+  @Inject()
+  private ARAgingSummarySheet: ARAgingSummaryService;
+
+  /**
+   * Retrieves A/R aging summary in table format.
+   * @param {number} tenantId
+   * @param {IARAgingSummaryQuery} query
+   * @returns {Promise<IARAgingSummaryTable>}
+   */
+  public async table(
+    tenantId: number,
+    query: IARAgingSummaryQuery
+  ): Promise<IARAgingSummaryTable> {
+    const report = await this.ARAgingSummarySheet.ARAgingSummary(
+      tenantId,
+      query
+    );
+    const table = new ARAgingSummaryTable(report.data, query, {});
+
+    return {
+      table: {
+        columns: table.tableColumns(),
+        rows: table.tableRows(),
+      },
+      meta: report.meta,
+      query,
+    };
+  }
+}

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheet.ts

@@ -1,18 +1,10 @@
 import * as R from 'ramda';
-import { defaultTo, isEmpty, sumBy } from 'lodash';
 import FinancialSheet from '../FinancialSheet';
 import {
-  IBalanceSheetAggregateNode,
-  IBalanceSheetAccountNode,
-  BALANCE_SHEET_SCHEMA_NODE_TYPE,
   IBalanceSheetQuery,
   INumberFormatQuery,
-  IAccount,
   IBalanceSheetSchemaNode,
-  IBalanceSheetSchemaAggregateNode,
   IBalanceSheetDataNode,
-  IBalanceSheetSchemaAccountNode,
-  IBalanceSheetCommonNode,
 } from '../../../interfaces';
 import { BalanceSheetSchema } from './BalanceSheetSchema';
 import { BalanceSheetPercentage } from './BalanceSheetPercentage';
@@ -24,8 +16,14 @@ import { FinancialSheetStructure } from '../FinancialSheetStructure';
 import BalanceSheetRepository from './BalanceSheetRepository';
 import { BalanceSheetQuery } from './BalanceSheetQuery';
 import { BalanceSheetFiltering } from './BalanceSheetFiltering';
+import { BalanceSheetNetIncome } from './BalanceSheetNetIncome';
+import { BalanceSheetAggregators } from './BalanceSheetAggregators';
+import { BalanceSheetAccounts } from './BalanceSheetAccounts';
 
 export default class BalanceSheet extends R.compose(
+  BalanceSheetAggregators,
+  BalanceSheetAccounts,
+  BalanceSheetNetIncome,
   BalanceSheetFiltering,
   BalanceSheetDatePeriods,
   BalanceSheetComparsionPreviousPeriod,
@@ -53,6 +51,9 @@ export default class BalanceSheet extends R.compose(
    */
   readonly baseCurrency: string;
 
+  /**
+   * Localization.
+   */
   readonly i18n: any;
 
   /**
@@ -77,216 +78,18 @@ export default class BalanceSheet extends R.compose(
   }
 
   /**
-   * Retrieve the accounts node of accounts types.
+   * Parses report schema nodes.
-   * @param   {string} accountsTypes
+   * @param {IBalanceSheetSchemaNode[]} schema
-   * @returns {IAccount[]}
+   * @returns {IBalanceSheetDataNode[]}
    */
-  private getAccountsByAccountTypes = (accountsTypes: string[]): IAccount[] => {
+  public parseSchemaNodes = (
-    const mapAccountsByTypes = R.map((accountType) =>
+    schema: IBalanceSheetSchemaNode[]
-      defaultTo(this.repository.accountsByType.get(accountType), [])
-    );
-    return R.compose(R.flatten, mapAccountsByTypes)(accountsTypes);
-  };
-
-  /**
-   * Mappes the aggregate schema node type.
-   * @param  {IBalanceSheetSchemaAggregateNode} node - Schema node.
-   * @return {IBalanceSheetAggregateNode}
-   */
-  private reportSchemaAggregateNodeMapper = (
-    node: IBalanceSheetSchemaAggregateNode
-  ): IBalanceSheetAggregateNode => {
-    const total = this.getTotalOfNodes(node.children);
-
-    return {
-      name: this.i18n.__(node.name),
-      id: node.id,
-      nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE,
-      total: this.getTotalAmountMeta(total),
-      children: node.children,
-    };
-  };
-
-  /**
-   * Compose shema aggregate node of balance sheet schema.
-   * @param   {IBalanceSheetSchemaAggregateNode} node
-   * @returns {IBalanceSheetSchemaAggregateNode}
-   */
-  private schemaAggregateNodeCompose = (
-    node: IBalanceSheetSchemaAggregateNode
-  ) => {
-    return R.compose(
-      this.aggregateNodeTotalMapper,
-      this.reportSchemaAggregateNodeMapper
-    )(node);
-  };
-
-  /**
-   * Mappes the account model to report account node.
-   * @param   {IAccount} account
-   * @returns {IBalanceSheetAccountNode}
-   */
-  private reportSchemaAccountNodeMapper = (
-    account: IAccount
-  ): IBalanceSheetAccountNode => {
-    const total = this.repository.totalAccountsLedger
-      .whereAccountId(account.id)
-      .getClosingBalance();
-
-    return {
-      id: account.id,
-      index: account.index,
-      name: account.name,
-      code: account.code,
-      total: this.getAmountMeta(total),
-      nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNT,
-    };
-  };
-
-  /**
-   *
-   * @param   {IAccount} account
-   * @returns {IBalanceSheetAccountNode}
-   */
-  private reportSchemaAccountNodeComposer = (
-    account: IAccount
-  ): IBalanceSheetAccountNode => {
-    return R.compose(
-      R.when(
-        this.query.isPreviousYearActive,
-        this.previousYearAccountNodeComposer
-      ),
-      R.when(
-        this.query.isPreviousPeriodActive,
-        this.previousPeriodAccountNodeComposer
-      ),
-      R.when(
-        this.query.isDatePeriodsColumnsType,
-        this.assocAccountNodeDatePeriods
-      ),
-      this.reportSchemaAccountNodeMapper
-    )(account);
-  };
-
-  /**
-   * Retrieve the total of the given nodes.
-   * @param   {IBalanceSheetCommonNode[]} nodes
-   * @returns {number}
-   */
-  private getTotalOfNodes = (nodes: IBalanceSheetCommonNode[]) => {
-    return sumBy(nodes, 'total.amount');
-  };
-
-  /**
-   * Retrieve the report accounts node by the given accounts types.
-   * @param   {string[]} accountsTypes
-   * @returns {}
-   */
-  private getAccountsNodesByAccountTypes = (accountsTypes: string[]) => {
-    const accounts = this.getAccountsByAccountTypes(accountsTypes);
-
-    return R.compose(R.map(this.reportSchemaAccountNodeComposer))(accounts);
-  };
-
-  /**
-   * Mappes the accounts schema node type.
-   * @param   {IBalanceSheetSchemaNode} node - Schema node.
-   * @returns {IBalanceSheetAccountNode}
-   */
-  private reportSchemaAccountsNodeMapper = (
-    node: IBalanceSheetSchemaAccountNode
-  ): IBalanceSheetAccountNode => {
-    const accounts = this.getAccountsNodesByAccountTypes(node.accountsTypes);
-    const total = this.getTotalOfNodes(accounts);
-
-    return {
-      id: node.id,
-      name: this.i18n.__(node.name),
-      type: node.type,
-      nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS,
-      children: accounts,
-      total: this.getTotalAmountMeta(total),
-    };
-  };
-
-  /**
-   * Compose account schema node to report node.
-   * @param   {IBalanceSheetSchemaAccountNode} node
-   * @returns {IBalanceSheetAccountNode}
-   */
-  private reportSchemaAccountsNodeComposer = (
-    node: IBalanceSheetSchemaAccountNode
-  ): IBalanceSheetAccountNode => {
-    return R.compose(
-      R.when(
-        this.query.isPreviousYearActive,
-        this.previousYearAggregateNodeComposer
-      ),
-      R.when(
-        this.query.isPreviousPeriodActive,
-        this.previousPeriodAggregateNodeComposer
-      ),
-      R.when(
-        this.query.isDatePeriodsColumnsType,
-        this.assocAccountsNodeDatePeriods
-      ),
-      this.reportSchemaAccountsNodeMapper
-    )(node);
-  };
-
-  /**
-   * Mappes the given report schema node.
-   * @param  {IBalanceSheetSchemaNode} node - Schema node.
-   * @return {IBalanceSheetDataNode}
-   */
-  private reportSchemaNodeMapper = (
-    schemaNode: IBalanceSheetSchemaNode
-  ): IBalanceSheetDataNode => {
-    return R.compose(
-      R.when(
-        this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE),
-        this.schemaAggregateNodeCompose
-      ),
-      R.when(
-        this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS),
-        this.reportSchemaAccountsNodeComposer
-      )
-    )(schemaNode);
-  };
-
-  /**
-   * Mappes the report schema nodes.
-   * @param  {IBalanceSheetSchemaNode[]} nodes -
-   * @return {IBalanceSheetStructureSection[]}
-   */
-  private reportSchemaAccountNodesMapper = (
-    schemaNodes: IBalanceSheetSchemaNode[]
   ): IBalanceSheetDataNode[] => {
-    return this.mapNodesDeepReverse(schemaNodes, this.reportSchemaNodeMapper);
-  };
-
-  /**
-   * Sets total amount that calculated from node children.
-   * @param   {IBalanceSheetSection} node
-   * @returns {IBalanceSheetDataNode}
-   */
-  private aggregateNodeTotalMapper = (
-    node: IBalanceSheetDataNode
-  ): IBalanceSheetDataNode => {
     return R.compose(
-      R.when(
+      this.aggregatesSchemaParser,
-        this.query.isPreviousYearActive,
+      this.netIncomeSchemaParser,
-        this.previousYearAggregateNodeComposer
+      this.accountsSchemaParser
-      ),
+    )(schema) as IBalanceSheetDataNode[];
-      R.when(
-        this.query.isPreviousPeriodActive,
-        this.previousPeriodAggregateNodeComposer
-      ),
-      R.when(
-        this.query.isDatePeriodsColumnsType,
-        this.assocAggregateNodeDatePeriods
-      )
-    )(node);
   };
 
   /**
@@ -299,7 +102,7 @@ export default class BalanceSheet extends R.compose(
     return R.compose(
       this.reportFilterPlugin,
       this.reportPercentageCompose,
-      this.reportSchemaAccountNodesMapper
+      this.parseSchemaNodes
     )(balanceSheetSchema);
   };
 }

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetAccounts.ts

@@ -0,0 +1,182 @@
+import * as R from 'ramda';
+import { defaultTo, toArray } from 'lodash';
+import { FinancialSheetStructure } from '../FinancialSheetStructure';
+import {
+  BALANCE_SHEET_SCHEMA_NODE_TYPE,
+  IAccount,
+  IBalanceSheetAccountNode,
+  IBalanceSheetAccountsNode,
+  IBalanceSheetDataNode,
+  IBalanceSheetSchemaAccountNode,
+  IBalanceSheetSchemaNode,
+  INumberFormatQuery,
+} from '@/interfaces';
+import { BalanceSheetNetIncome } from './BalanceSheetNetIncome';
+import { BalanceSheetFiltering } from './BalanceSheetFiltering';
+import { BalanceSheetDatePeriods } from './BalanceSheetDatePeriods';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { BalanceSheetPercentage } from './BalanceSheetPercentage';
+import { BalanceSheetSchema } from './BalanceSheetSchema';
+import { BalanceSheetBase } from './BalanceSheetBase';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+
+export const BalanceSheetAccounts = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetNetIncome,
+    BalanceSheetFiltering,
+    BalanceSheetDatePeriods,
+    BalanceSheetComparsionPreviousPeriod,
+    BalanceSheetComparsionPreviousYear,
+    BalanceSheetPercentage,
+    BalanceSheetSchema,
+    BalanceSheetBase,
+    FinancialSheetStructure
+  )(Base) {
+    /**
+     * Balance sheet query.
+     * @param {BalanceSheetQuery}
+     */
+    readonly query: BalanceSheetQuery;
+
+    /**
+     * Balance sheet number format query.
+     * @param {INumberFormatQuery}
+     */
+    readonly numberFormat: INumberFormatQuery;
+
+    /**
+     * Base currency of the organization.
+     * @param {string}
+     */
+    readonly baseCurrency: string;
+
+    /**
+     * Localization.
+     */
+    readonly i18n: any;
+
+    /**
+     * Retrieve the accounts node of accounts types.
+     * @param   {string} accountsTypes
+     * @returns {IAccount[]}
+     */
+    private getAccountsByAccountTypes = (
+      accountsTypes: string[]
+    ): IAccount[] => {
+      const mapAccountsByTypes = R.map((accountType) =>
+        defaultTo(this.repository.accountsByType.get(accountType), [])
+      );
+      return R.compose(R.flatten, mapAccountsByTypes)(accountsTypes);
+    };
+
+    /**
+     * Mappes the account model to report account node.
+     * @param   {IAccount} account
+     * @returns {IBalanceSheetAccountNode}
+     */
+    private reportSchemaAccountNodeMapper = (
+      account: IAccount
+    ): IBalanceSheetAccountNode => {
+      const total = this.repository.totalAccountsLedger
+        .whereAccountId(account.id)
+        .getClosingBalance();
+
+      return {
+        id: account.id,
+        index: account.index,
+        name: account.name,
+        code: account.code,
+        total: this.getAmountMeta(total),
+        nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNT,
+      };
+    };
+
+    /**
+     * Mappes the given account model to the balance sheet account node.
+     * @param {IAccount} account
+     * @returns {IBalanceSheetAccountNode}
+     */
+    private reportSchemaAccountNodeComposer = (
+      account: IAccount
+    ): IBalanceSheetAccountNode => {
+      return R.compose(
+        R.when(
+          this.query.isPreviousYearActive,
+          this.previousYearAccountNodeComposer
+        ),
+        R.when(
+          this.query.isPreviousPeriodActive,
+          this.previousPeriodAccountNodeComposer
+        ),
+        R.when(
+          this.query.isDatePeriodsColumnsType,
+          this.assocAccountNodeDatePeriods
+        ),
+        this.reportSchemaAccountNodeMapper
+      )(account);
+    };
+
+    // -----------------------------
+    // - Accounts Node Praser
+    // -----------------------------
+    /**
+     * Retrieve the report accounts node by the given accounts types.
+     * @param {string[]} accountsTypes
+     * @returns {IBalanceSheetAccountNode[]}
+     */
+    private getAccountsNodesByAccountTypes = (
+      accountsTypes: string[]
+    ): IBalanceSheetAccountNode[] => {
+      const accounts = this.getAccountsByAccountTypes(accountsTypes);
+      return R.map(this.reportSchemaAccountNodeComposer, accounts);
+    };
+
+    /**
+     * Mappes the accounts schema node type.
+     * @param   {IBalanceSheetSchemaNode} node - Schema node.
+     * @returns {IBalanceSheetAccountNode}
+     */
+    private reportSchemaAccountsNodeMapper = (
+      node: IBalanceSheetSchemaAccountNode
+    ): IBalanceSheetAccountsNode => {
+      const accounts = this.getAccountsNodesByAccountTypes(node.accountsTypes);
+      const children = toArray(node?.children);
+
+      return {
+        id: node.id,
+        name: this.i18n.__(node.name),
+        nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS,
+        type: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS,
+        children: [...accounts, ...children],
+        total: this.getTotalAmountMeta(0),
+      };
+    };
+
+    /**
+     * Mappes the given report schema node.
+     * @param {IBalanceSheetSchemaNode | IBalanceSheetDataNode} node - Schema node.
+     * @return {IBalanceSheetSchemaNode | IBalanceSheetDataNode}
+     */
+    private reportAccountSchemaParser = (
+      node: IBalanceSheetSchemaNode | IBalanceSheetDataNode
+    ): IBalanceSheetSchemaNode | IBalanceSheetDataNode => {
+      return R.compose(
+        R.when(
+          this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS),
+          this.reportSchemaAccountsNodeMapper
+        )
+      )(node);
+    };
+
+    /**
+     * Parses the report accounts schema nodes.
+     * @param {IBalanceSheetSchemaNode[]} nodes -
+     * @return {IBalanceSheetStructureSection[]}
+     */
+    public accountsSchemaParser = (
+      nodes: (IBalanceSheetSchemaNode | IBalanceSheetDataNode)[]
+    ): (IBalanceSheetDataNode | IBalanceSheetSchemaNode)[] => {
+      return this.mapNodesDeepReverse(nodes, this.reportAccountSchemaParser);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetAggregators.ts

@@ -0,0 +1,142 @@
+import * as R from 'ramda';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import { FinancialSheetStructure } from '../FinancialSheetStructure';
+import {
+  BALANCE_SHEET_SCHEMA_NODE_TYPE,
+  IBalanceSheetAggregateNode,
+  IBalanceSheetDataNode,
+  IBalanceSheetSchemaAggregateNode,
+  IBalanceSheetSchemaNode,
+  INumberFormatQuery,
+} from '@/interfaces';
+import { BalanceSheetDatePeriods } from './BalanceSheetDatePeriods';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { BalanceSheetPercentage } from './BalanceSheetPercentage';
+import { BalanceSheetSchema } from './BalanceSheetSchema';
+import { BalanceSheetBase } from './BalanceSheetBase';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+
+export const BalanceSheetAggregators = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetDatePeriods,
+    BalanceSheetComparsionPreviousPeriod,
+    BalanceSheetComparsionPreviousYear,
+    BalanceSheetPercentage,
+    BalanceSheetSchema,
+    BalanceSheetBase,
+    FinancialSheetStructure
+  )(Base) {
+    /**
+     * Balance sheet query.
+     * @param {BalanceSheetQuery}
+     */
+    readonly query: BalanceSheetQuery;
+
+    /**
+     * Balance sheet number format query.
+     * @param {INumberFormatQuery}
+     */
+    readonly numberFormat: INumberFormatQuery;
+
+    /**
+     * Base currency of the organization.
+     * @param {string}
+     */
+    readonly baseCurrency: string;
+
+    /**
+     * Localization.
+     */
+    readonly i18n: any;
+
+    /**
+     * Sets total amount that calculated from node children.
+     * @param {IBalanceSheetSection} node
+     * @returns {IBalanceSheetDataNode}
+     */
+    private aggregateNodeTotalMapper = (
+      node: IBalanceSheetDataNode
+    ): IBalanceSheetDataNode => {
+      return R.compose(
+        R.when(
+          this.query.isPreviousYearActive,
+          this.previousYearAggregateNodeComposer
+        ),
+        R.when(
+          this.query.isPreviousPeriodActive,
+          this.previousPeriodAggregateNodeComposer
+        ),
+        R.when(
+          this.query.isDatePeriodsColumnsType,
+          this.assocAggregateNodeDatePeriods
+        )
+      )(node);
+    };
+
+    /**
+     * Mappes the aggregate schema node type.
+     * @param  {IBalanceSheetSchemaAggregateNode} node - Schema node.
+     * @return {IBalanceSheetAggregateNode}
+     */
+    private reportSchemaAggregateNodeMapper = (
+      node: IBalanceSheetSchemaAggregateNode
+    ): IBalanceSheetAggregateNode => {
+      const total = this.getTotalOfNodes(node.children);
+
+      return {
+        name: this.i18n.__(node.name),
+        id: node.id,
+        nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE,
+        type: BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE,
+        total: this.getTotalAmountMeta(total),
+        children: node.children,
+      };
+    };
+
+    /**
+     * Compose shema aggregate node of balance sheet schema.
+     * @param   {IBalanceSheetSchemaAggregateNode} node
+     * @returns {IBalanceSheetSchemaAggregateNode}
+     */
+    private schemaAggregateNodeCompose = (
+      node: IBalanceSheetSchemaAggregateNode
+    ) => {
+      return R.compose(
+        this.aggregateNodeTotalMapper,
+        this.reportSchemaAggregateNodeMapper
+      )(node);
+    };
+
+    /**
+     * Mappes the given report schema node.
+     * @param  {IBalanceSheetSchemaNode} node - Schema node.
+     * @return {IBalanceSheetDataNode}
+     */
+    private reportAggregateSchemaParser = (
+      node: IBalanceSheetSchemaNode
+    ): IBalanceSheetDataNode => {
+      return R.compose(
+        R.when(
+          this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.AGGREGATE),
+          this.schemaAggregateNodeCompose
+        ),
+        R.when(
+          this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS),
+          this.schemaAggregateNodeCompose
+        )
+      )(node);
+    };
+
+    /**
+     * Mappes the report schema nodes.
+     * @param  {IBalanceSheetSchemaNode[]} nodes -
+     * @return {IBalanceSheetStructureSection[]}
+     */
+    public aggregatesSchemaParser = (
+      nodes: (IBalanceSheetSchemaNode | IBalanceSheetDataNode)[]
+    ): (IBalanceSheetDataNode | IBalanceSheetSchemaNode)[] => {
+      return this.mapNodesDeepReverse(nodes, this.reportAggregateSchemaParser);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetApplication.ts

@@ -0,0 +1,57 @@
+import { Inject, Service } from 'typedi';
+import { IBalanceSheetQuery } from '@/interfaces';
+import { BalanceSheetExportInjectable } from './BalanceSheetExportInjectable';
+import { BalanceSheetTableInjectable } from './BalanceSheetTableInjectable';
+import BalanceSheetStatementService from './BalanceSheetInjectable';
+
+@Service()
+export class BalanceSheetApplication {
+  @Inject()
+  public balanceSheetExport: BalanceSheetExportInjectable;
+
+  @Inject()
+  public balanceSheetTable: BalanceSheetTableInjectable;
+
+  @Inject()
+  public balanceSheet: BalanceSheetStatementService;
+
+  /**
+   * Retrieves the balnace sheet in json format.
+   * @param {numnber} tenantId
+   * @param {IBalanceSheetQuery} query
+   * @returns {Promise<IBalanceSheetStatement>}
+   */
+  public sheet(tenantId: number, query: IBalanceSheetQuery) {
+    return this.balanceSheet.balanceSheet(tenantId, query);
+  }
+
+  /**
+   * Retrieves the balance sheet in table format.
+   * @param {number} tenantId
+   * @param {IBalanceSheetQuery} query
+   * @returns {Promise<IBalanceSheetTable>}
+   */
+  public table(tenantId: number, query: IBalanceSheetQuery) {
+    return this.balanceSheetTable.table(tenantId, query);
+  }
+
+  /**
+   * Retrieves the balance sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {IBalanceSheetQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public xlsx(tenantId: number, query: IBalanceSheetQuery) {
+    return this.balanceSheetExport.xlsx(tenantId, query);
+  }
+
+  /**
+   * Retrieves the balance sheet in CSV format.
+   * @param {number} tenantId
+   * @param {IBalanceSheetQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public csv(tenantId: number, query: IBalanceSheetQuery): Promise<string> {
+    return this.balanceSheetExport.csv(tenantId, query);
+  }
+}

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetComparsionPreviousPeriod.ts

@@ -6,6 +6,7 @@ import {
   IBalanceSheetAggregateNode,
   IBalanceSheetTotal,
   IBalanceSheetCommonNode,
+  IBalanceSheetComparsions,
 } from '@/interfaces';
 import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
 import { FinancialHorizTotals } from '../FinancialHorizTotals';

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetComparsionPreviousYear.ts

@@ -156,13 +156,14 @@ export const BalanceSheetComparsionPreviousYear = (Base: any) =>
      * @param   {IBalanceSheetCommonNode} node
      * @returns {IBalanceSheetCommonNode}
      */
-    private assocPreviousYearAggregateHorizNode = (
+    public assocPreviousYearAggregateHorizNode = (
       node: IBalanceSheetCommonNode
-    ) => {
+    ): IBalanceSheetCommonNode => {
       const horizontalTotals = R.addIndex(R.map)(
         this.previousYearAggregateHorizNodeComposer(node),
         node.horizontalTotals
-      );
+      ) as IBalanceSheetTotal[];
+
       return R.assoc('horizontalTotals', horizontalTotals, node);
     };
 
@@ -258,12 +259,11 @@ export const BalanceSheetComparsionPreviousYear = (Base: any) =>
     // ------------------------------
     // # Horizontal Nodes - Aggregate.
     // ------------------------------
-
     /**
      * Detarmines whether the given node has horizontal totals.
      * @param   {IBalanceSheetCommonNode} node
      * @returns {boolean}
      */
-    private isNodeHasHorizontalTotals = (node: IBalanceSheetCommonNode) =>
+    public isNodeHasHorizontalTotals = (node: IBalanceSheetCommonNode) =>
       !isEmpty(node.horizontalTotals);
   };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetExportInjectable.ts

@@ -0,0 +1,43 @@
+import { Inject, Service } from 'typedi';
+import { BalanceSheetTableInjectable } from './BalanceSheetTableInjectable';
+import { TableSheet } from '@/lib/Xlsx/TableSheet';
+import { IBalanceSheetQuery } from '@/interfaces';
+
+@Service()
+export class BalanceSheetExportInjectable {
+  @Inject()
+  private balanceSheetTable: BalanceSheetTableInjectable;
+
+  /**
+   * Retrieves the trial balance sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {ITrialBalanceSheetQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async xlsx(tenantId: number, query: IBalanceSheetQuery) {
+    const table = await this.balanceSheetTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToXLSX();
+
+    return tableSheet.convertToBuffer(tableCsv, 'xlsx');
+  }
+
+  /**
+   * Retrieves the trial balance sheet in CSV format.
+   * @param {number} tenantId
+   * @param {ITrialBalanceSheetQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async csv(
+    tenantId: number,
+    query: IBalanceSheetQuery
+  ): Promise<string> {
+    const table = await this.balanceSheetTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToCSV();
+
+    return tableCsv;
+  }
+}

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetFilter.ts

@@ -1 +0,0 @@
-

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetInjectable.ts

@@ -19,13 +19,10 @@ export default class BalanceSheetStatementService
   implements IBalanceSheetStatementService
 {
   @Inject()
-  tenancy: TenancyService;
+  private tenancy: TenancyService;
-
-  @Inject('logger')
-  logger: any;
 
   @Inject()
-  inventoryService: InventoryService;
+  private inventoryService: InventoryService;
 
   /**
    * Defaults balance sheet filter query.
@@ -94,10 +91,8 @@ export default class BalanceSheetStatementService
 
   /**
    * Retrieve balance sheet statement.
-   * -------------
    * @param {number} tenantId
    * @param {IBalanceSheetQuery} query
-   *
    * @return {IBalanceSheetStatement}
    */
   public async balanceSheet(

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncome.ts

@@ -0,0 +1,226 @@
+import * as R from 'ramda';
+import {
+  BALANCE_SHEET_SCHEMA_NODE_TYPE,
+  IBalanceSheetDataNode,
+  IBalanceSheetNetIncomeNode,
+  IBalanceSheetSchemaNetIncomeNode,
+  IBalanceSheetSchemaNode,
+  IBalanceSheetTotalPeriod,
+} from '@/interfaces';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import BalanceSheetRepository from './BalanceSheetRepository';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import { BalanceSheetNetIncomePP } from './BalanceSheetNetIncomePP';
+import { BalanceSheetNetIncomePY } from './BalanceSheetNetIncomePY';
+
+export const BalanceSheetNetIncome = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetNetIncomePP,
+    BalanceSheetNetIncomePY,
+    BalanceSheetComparsionPreviousYear,
+    BalanceSheetComparsionPreviousPeriod,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    private repository: BalanceSheetRepository;
+    private query: BalanceSheetQuery;
+
+    /**
+     * Retrieves the closing balance of income accounts.
+     * @returns {number}
+     */
+    private getIncomeTotal = () => {
+      const closeingBalance = this.repository.incomeLedger.getClosingBalance();
+      return closeingBalance;
+    };
+
+    /**
+     * Retrieves the closing balance of expenses accounts.
+     * @returns {number}
+     */
+    private getExpensesTotal = () => {
+      const closingBalance = this.repository.expensesLedger.getClosingBalance();
+      return closingBalance;
+    };
+
+    /**
+     * Retrieves the total net income.
+     * @returns {number}
+     */
+    protected getNetIncomeTotal = () => {
+      const income = this.getIncomeTotal();
+      const expenses = this.getExpensesTotal();
+
+      return income - expenses;
+    };
+
+    /**
+     * Mappes the aggregate schema node type.
+     * @param  {IBalanceSheetSchemaNetIncomeNode} node - Schema node.
+     * @return {IBalanceSheetAggregateNode}
+     */
+    protected schemaNetIncomeNodeMapper = (
+      node: IBalanceSheetSchemaNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const total = this.getNetIncomeTotal();
+
+      return {
+        id: node.id,
+        name: this.i18n.__(node.name),
+        nodeType: BALANCE_SHEET_SCHEMA_NODE_TYPE.NET_INCOME,
+        total: this.getTotalAmountMeta(total),
+      };
+    };
+
+    /**
+     * Mapps the net income shcema node to report node.
+     * @param {IBalanceSheetSchemaNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    protected schemaNetIncomeNodeCompose = (
+      node: IBalanceSheetSchemaNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      return R.compose(
+        R.when(
+          this.query.isPreviousYearActive,
+          this.previousYearNetIncomeNodeCompose
+        ),
+        R.when(
+          this.query.isPreviousPeriodActive,
+          this.previousPeriodNetIncomeNodeCompose
+        ),
+        R.when(
+          this.query.isDatePeriodsColumnsType,
+          this.assocNetIncomeDatePeriodsNode
+        ),
+        this.schemaNetIncomeNodeMapper
+      )(node);
+    };
+
+    // --------------------------------
+    // # Date Periods
+    // --------------------------------
+    /**
+     * Retreives total income of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getIncomeDatePeriodTotal = (toDate: Date): number => {
+      const periodTotalBetween = this.repository.incomePeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const periodOpening =
+        this.repository.incomePeriodsOpeningAccountsLedger.getClosingBalance();
+
+      return periodOpening + periodTotalBetween;
+    };
+
+    /**
+     * Retrieves total expense of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getExpensesDatePeriodTotal = (toDate: Date): number => {
+      const periodTotalBetween = this.repository.expensesPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const periodOpening =
+        this.repository.expensesOpeningAccountLedger.getClosingBalance();
+
+      return periodOpening + periodTotalBetween;
+    };
+
+    /**
+     * Retrieve the given net income date period total.
+     * @param {number} accountId
+     * @param {Date} toDate
+     * @returns {number}
+     */
+    private getNetIncomeDatePeriodTotal = (toDate: Date): number => {
+      const income = this.getIncomeDatePeriodTotal(toDate);
+      const expense = this.getExpensesDatePeriodTotal(toDate);
+
+      return income - expense;
+    };
+
+    /**
+     * Retrieves the net income date period node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @param {Date} fromDate
+     * @param {Date} toDate
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    private getNetIncomeDatePeriodNode = (
+      node: IBalanceSheetNetIncomeNode,
+      fromDate: Date,
+      toDate: Date
+    ): IBalanceSheetTotalPeriod => {
+      const periodTotal = this.getNetIncomeDatePeriodTotal(toDate);
+
+      return this.getDatePeriodTotalMeta(periodTotal, fromDate, toDate);
+    };
+
+    /**
+     * Retrieve total date periods of the given net income node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    private getNetIncomeDatePeriodsNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetTotalPeriod[] => {
+      return this.getReportNodeDatePeriods(
+        node,
+        this.getNetIncomeDatePeriodNode
+      );
+    };
+
+    /**
+     * Assoc total date periods to net income node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    public assocNetIncomeDatePeriodsNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const datePeriods = this.getNetIncomeDatePeriodsNode(node);
+
+      return R.assoc('horizontalTotals', datePeriods, node);
+    };
+
+    // -----------------------------
+    // - Net Income Nodes Praser
+    // -----------------------------
+    /**
+     * Mappes the given report schema node.
+     * @param  {IBalanceSheetSchemaNode} node - Schema node.
+     * @return {IBalanceSheetDataNode}
+     */
+    private reportNetIncomeNodeSchemaParser = (
+      schemaNode: IBalanceSheetSchemaNode
+    ): IBalanceSheetDataNode => {
+      return R.compose(
+        R.when(
+          this.isSchemaNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.NET_INCOME),
+          this.schemaNetIncomeNodeCompose
+        )
+      )(schemaNode);
+    };
+
+    /**
+     * Parses the report net income schema nodes.
+     * @param {(IBalanceSheetSchemaNode | IBalanceSheetDataNode)[]} nodes -
+     * @return {IBalanceSheetDataNode[]}
+     */
+    public netIncomeSchemaParser = (
+      nodes: (IBalanceSheetSchemaNode | IBalanceSheetDataNode)[]
+    ): IBalanceSheetDataNode[] => {
+      return this.mapNodesDeep(nodes, this.reportNetIncomeNodeSchemaParser);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncomeDatePeriods.ts

@@ -0,0 +1,120 @@
+import * as R from 'ramda';
+import {
+  IBalanceSheetNetIncomeNode,
+  IBalanceSheetTotalPeriod,
+} from '@/interfaces';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import BalanceSheetRepository from './BalanceSheetRepository';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import { BalanceSheetNetIncomePP } from './BalanceSheetNetIncomePP';
+import { BalanceSheetNetIncomePY } from './BalanceSheetNetIncomePY';
+
+export const BalanceSheetNetIncomeDatePeriods = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetNetIncomePP,
+    BalanceSheetNetIncomePY,
+    BalanceSheetComparsionPreviousYear,
+    BalanceSheetComparsionPreviousPeriod,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    private repository: BalanceSheetRepository;
+    private query: BalanceSheetQuery;
+
+    // --------------------------------
+    // # Date Periods
+    // --------------------------------
+    /**
+     * Retreives total income of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getIncomeDatePeriodTotal = (toDate: Date): number => {
+      const periodTotalBetween = this.repository.incomePeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const periodOpening =
+        this.repository.incomePeriodsOpeningAccountsLedger.getClosingBalance();
+
+      return periodOpening + periodTotalBetween;
+    };
+
+    /**
+     * Retrieves total expense of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getExpensesDatePeriodTotal = (toDate: Date): number => {
+      const periodTotalBetween = this.repository.expensesPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const periodOpening =
+        this.repository.expensesOpeningAccountLedger.getClosingBalance();
+
+      return periodOpening + periodTotalBetween;
+    };
+
+    /**
+     * Retrieve the given net income date period total.
+     * @param {number} accountId
+     * @param {Date} toDate
+     * @returns {number}
+     */
+    private getNetIncomeDatePeriodTotal = (toDate: Date): number => {
+      const income = this.getIncomeDatePeriodTotal(toDate);
+      const expense = this.getExpensesDatePeriodTotal(toDate);
+
+      return income - expense;
+    };
+
+    /**
+     * Retrieves the net income date period node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @param {Date} fromDate
+     * @param {Date} toDate
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    private getNetIncomeDatePeriodNode = (
+      node: IBalanceSheetNetIncomeNode,
+      fromDate: Date,
+      toDate: Date
+    ): IBalanceSheetTotalPeriod => {
+      const periodTotal = this.getNetIncomeDatePeriodTotal(toDate);
+
+      return this.getDatePeriodTotalMeta(periodTotal, fromDate, toDate);
+    };
+
+    /**
+     * Retrieve total date periods of the given net income node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    private getNetIncomeDatePeriodsNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetTotalPeriod[] => {
+      return this.getReportNodeDatePeriods(
+        node,
+        this.getNetIncomeDatePeriodNode
+      );
+    };
+
+    /**
+     * Assoc total date periods to net income node.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    public assocNetIncomeDatePeriodsNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const datePeriods = this.getNetIncomeDatePeriodsNode(node);
+
+      return R.assoc('horizontalTotals', datePeriods, node);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncomeDatePeriodsPP.ts

@@ -0,0 +1,127 @@
+import * as R from 'ramda';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import { IBalanceSheetNetIncomeNode, IBalanceSheetTotal } from '@/interfaces';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import BalanceSheetRepository from './BalanceSheetRepository';
+
+export const BalanceSheetNetIncomeDatePeriodsPP = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetComparsionPreviousPeriod,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    query: BalanceSheetQuery;
+    repository: BalanceSheetRepository;
+
+    /**
+     * Retrieves the PY total income of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @return {number}
+     */
+    private getPPIncomeDatePeriodTotal = R.curry((toDate: Date) => {
+      const PYPeriodsTotal = this.repository.incomePPPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const PYPeriodsOpeningTotal =
+        this.repository.incomePPPeriodsOpeningAccountLedger.getClosingBalance();
+
+      return PYPeriodsOpeningTotal + PYPeriodsTotal;
+    });
+
+    /**
+     * Retrieves the PY total expense of the given date period.
+     * @param {number} accountId -
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getPPExpenseDatePeriodTotal = R.curry((toDate: Date) => {
+      const PYPeriodsTotal = this.repository.expensePPPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const PYPeriodsOpeningTotal =
+        this.repository.expensePPPeriodsOpeningAccountLedger.getClosingBalance();
+
+      return PYPeriodsOpeningTotal + PYPeriodsTotal;
+    });
+
+    /**
+     * Retrieve the given net income total of the given period.
+     * @param {number} accountId - Account id.
+     * @param {Date} toDate - To date.
+     * @returns {number}
+     */
+    private getPPNetIncomeDatePeriodTotal = R.curry((toDate: Date) => {
+      const income = this.getPPIncomeDatePeriodTotal(toDate);
+      const expense = this.getPPExpenseDatePeriodTotal(toDate);
+
+      return income - expense;
+    });
+
+    /**
+     * Assoc preivous period to account horizontal total node.
+     * @param {IBalanceSheetAccountNode} node
+     * @returns {}
+     */
+    private assocPreviousPeriodNetIncomeHorizTotal = R.curry(
+      (node: IBalanceSheetNetIncomeNode, totalNode) => {
+        const total = this.getPPNetIncomeDatePeriodTotal(
+          totalNode.previousPeriodToDate.date
+        );
+        return R.assoc('previousPeriod', this.getAmountMeta(total), totalNode);
+      }
+    );
+
+    /**
+     * Compose previous period to aggregate horizontal nodes.
+     * @param   {IBalanceSheetTotal} node
+     * @returns {IBalanceSheetTotal}
+     */
+    private previousPeriodNetIncomeHorizNodeComposer = R.curry(
+      (
+        node: IBalanceSheetNetIncomeNode,
+        horiontalTotalNode: IBalanceSheetTotal
+      ): IBalanceSheetTotal => {
+        return R.compose(
+          R.when(
+            this.query.isPreviousPeriodPercentageActive,
+            this.assocPreviousPeriodTotalPercentageNode
+          ),
+          R.when(
+            this.query.isPreviousPeriodChangeActive,
+            this.assocPreviousPeriodTotalChangeNode
+          ),
+          R.when(
+            this.query.isPreviousPeriodActive,
+            this.assocPreviousPeriodNetIncomeHorizTotal(node)
+          ),
+          R.when(
+            this.query.isPreviousPeriodActive,
+            this.assocPreviousPeriodHorizNodeFromToDates(
+              this.query.displayColumnsBy
+            )
+          )
+        )(horiontalTotalNode);
+      }
+    );
+
+    /**
+     * Associate the PP to net income horizontal nodes.
+     * @param   {IBalanceSheetCommonNode} node
+     * @returns {IBalanceSheetCommonNode}
+     */
+    public assocPreviousPeriodNetIncomeHorizNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const horizontalTotals = R.addIndex(R.map)(
+        this.previousPeriodNetIncomeHorizNodeComposer(node),
+        node.horizontalTotals
+      ) as IBalanceSheetTotal[];
+
+      return R.assoc('horizontalTotals', horizontalTotals, node);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncomeDatePeriodsPY.ts

@@ -0,0 +1,122 @@
+import * as R from 'ramda';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import { IBalanceSheetNetIncomeNode, IBalanceSheetTotal } from '@/interfaces';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import BalanceSheetRepository from './BalanceSheetRepository';
+
+export const BalanceSheetNetIncomeDatePeriodsPY = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetComparsionPreviousYear,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    query: BalanceSheetQuery;
+    repository: BalanceSheetRepository;
+
+    /**
+     * Retrieves the PY total income of the given date period.
+     * @param {Date} toDate -
+     * @return {number}
+     */
+    private getPYIncomeDatePeriodTotal = R.curry((toDate: Date) => {
+      const PYPeriodsTotal = this.repository.incomePYPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const PYPeriodsOpeningTotal =
+        this.repository.incomePYPeriodsOpeningAccountLedger.getClosingBalance();
+
+      return PYPeriodsOpeningTotal + PYPeriodsTotal;
+    });
+
+    /**
+     * Retrieves the PY total expense of the given date period.
+     * @param {Date} toDate -
+     * @returns {number}
+     */
+    private getPYExpenseDatePeriodTotal = R.curry((toDate: Date) => {
+      const PYPeriodsTotal = this.repository.expensePYPeriodsAccountsLedger
+        .whereToDate(toDate)
+        .getClosingBalance();
+
+      const PYPeriodsOpeningTotal =
+        this.repository.expensePYPeriodsOpeningAccountLedger.getClosingBalance();
+
+      return PYPeriodsOpeningTotal + PYPeriodsTotal;
+    });
+
+    /**
+     * Retrieve the given net income total of the given period.
+     * @param {Date} toDate - To date.
+     * @returns {number}
+     */
+    private getPYNetIncomeDatePeriodTotal = R.curry((toDate: Date) => {
+      const income = this.getPYIncomeDatePeriodTotal(toDate);
+      const expense = this.getPYExpenseDatePeriodTotal(toDate);
+
+      return income - expense;
+    });
+
+    /**
+     * Assoc preivous year to account horizontal total node.
+     * @param {IBalanceSheetAccountNode} node
+     * @returns {}
+     */
+    private assocPreviousYearNetIncomeHorizTotal = R.curry(
+      (node: IBalanceSheetNetIncomeNode, totalNode) => {
+        const total = this.getPYNetIncomeDatePeriodTotal(
+          totalNode.previousYearToDate.date
+        );
+        return R.assoc('previousYear', this.getAmountMeta(total), totalNode);
+      }
+    );
+
+    /**
+     * Compose PY to net income horizontal nodes.
+     * @param {IBalanceSheetTotal} node
+     * @returns {IBalanceSheetTotal}
+     */
+    private previousYearNetIncomeHorizNodeComposer = R.curry(
+      (
+        node: IBalanceSheetNetIncomeNode,
+        horiontalTotalNode: IBalanceSheetTotal
+      ): IBalanceSheetTotal => {
+        return R.compose(
+          R.when(
+            this.query.isPreviousYearPercentageActive,
+            this.assocPreviousYearTotalPercentageNode
+          ),
+          R.when(
+            this.query.isPreviousYearChangeActive,
+            this.assocPreviousYearTotalChangeNode
+          ),
+          R.when(
+            this.query.isPreviousYearActive,
+            this.assocPreviousYearNetIncomeHorizTotal(node)
+          ),
+          R.when(
+            this.query.isPreviousYearActive,
+            this.assocPreviousYearHorizNodeFromToDates
+          )
+        )(horiontalTotalNode);
+      }
+    );
+
+    /**
+     * Associate the PY to net income horizontal nodes.
+     * @param   {IBalanceSheetCommonNode} node
+     * @returns {IBalanceSheetCommonNode}
+     */
+    public assocPreviousYearNetIncomeHorizNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const horizontalTotals = R.addIndex(R.map)(
+        this.previousYearNetIncomeHorizNodeComposer(node),
+        node.horizontalTotals
+      ) as IBalanceSheetTotal[];
+
+      return R.assoc('horizontalTotals', horizontalTotals, node);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncomePP.ts

@@ -0,0 +1,75 @@
+import * as R from 'ramda';
+import {
+  IBalanceSheetDataNode,
+  IBalanceSheetNetIncomeNode,
+} from '@/interfaces';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import BalanceSheetRepository from './BalanceSheetRepository';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import { BalanceSheetNetIncomeDatePeriodsPP } from './BalanceSheetNetIncomeDatePeriodsPP';
+
+export const BalanceSheetNetIncomePP = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetNetIncomeDatePeriodsPP,
+    BalanceSheetComparsionPreviousPeriod,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    private repository: BalanceSheetRepository;
+    private query: BalanceSheetQuery;
+
+    // -------------------------------
+    // # Previous Period (PP)
+    // -------------------------------
+    /**
+     * Retrieves the PP net income.
+     * @returns {}
+     */
+    protected getPreviousPeriodNetIncome = () => {
+      const income = this.repository.incomePPAccountsLedger.getClosingBalance();
+      const expense =
+        this.repository.expensePPAccountsLedger.getClosingBalance();
+
+      return income - expense;
+    };
+
+    /**
+     * Associates the previous period to account node.
+     * @param {IBalanceSheetDataNode} node
+     * @returns {IBalanceSheetDataNode}
+     */
+    protected assocPreviousPeriodNetIncomeNode = (
+      node: IBalanceSheetDataNode
+    ): IBalanceSheetDataNode => {
+      const total = this.getPreviousPeriodNetIncome();
+
+      return R.assoc('previousPeriod', this.getAmountMeta(total), node);
+    };
+
+    /**
+     * Previous period account node composer.
+     * @param {IBalanceSheetNetIncomeNode} node
+     * @returns {IBalanceSheetNetIncomeNode}
+     */
+    protected previousPeriodNetIncomeNodeCompose = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      return R.compose(
+        R.when(
+          this.isNodeHasHorizTotals,
+          this.assocPreviousPeriodNetIncomeHorizNode
+        ),
+        R.when(
+          this.query.isPreviousPeriodPercentageActive,
+          this.assocPreviousPeriodPercentageNode
+        ),
+        R.when(
+          this.query.isPreviousPeriodChangeActive,
+          this.assocPreviousPeriodChangeNode
+        ),
+        this.assocPreviousPeriodNetIncomeNode
+      )(node);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetNetIncomePY.ts

@@ -0,0 +1,79 @@
+import * as R from 'ramda';
+import {
+  IBalanceSheetDataNode,
+  IBalanceSheetNetIncomeNode,
+} from '@/interfaces';
+import { BalanceSheetComparsionPreviousYear } from './BalanceSheetComparsionPreviousYear';
+import { BalanceSheetComparsionPreviousPeriod } from './BalanceSheetComparsionPreviousPeriod';
+import { FinancialPreviousPeriod } from '../FinancialPreviousPeriod';
+import { FinancialHorizTotals } from '../FinancialHorizTotals';
+import BalanceSheetRepository from './BalanceSheetRepository';
+import { BalanceSheetQuery } from './BalanceSheetQuery';
+import { BalanceSheetNetIncomeDatePeriodsPY } from './BalanceSheetNetIncomeDatePeriodsPY';
+
+export const BalanceSheetNetIncomePY = (Base: any) =>
+  class extends R.compose(
+    BalanceSheetNetIncomeDatePeriodsPY,
+    BalanceSheetComparsionPreviousYear,
+    BalanceSheetComparsionPreviousPeriod,
+    FinancialPreviousPeriod,
+    FinancialHorizTotals
+  )(Base) {
+    private repository: BalanceSheetRepository;
+    private query: BalanceSheetQuery;
+
+    // ------------------------------
+    // # Previous Year (PY)
+    // ------------------------------
+    /**
+     * Retrieves the previous year (PY) net income.
+     * @returns {number}
+     */
+    protected getPreviousYearNetIncome = () => {
+      const income =
+        this.repository.incomePYTotalAccountsLedger.getClosingBalance();
+      const expense =
+        this.repository.expensePYTotalAccountsLedger.getClosingBalance();
+
+      return income - expense;
+    };
+
+    /**
+     * Assoc previous year on aggregate node.
+     * @param {IBalanceSheetAccountNode} node
+     * @returns {IBalanceSheetAccountNode}
+     */
+    protected assocPreviousYearNetIncomeNode = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      const total = this.getPreviousYearNetIncome();
+
+      return R.assoc('previousYear', this.getTotalAmountMeta(total), node);
+    };
+
+    /**
+     * Assoc previous year attributes to aggregate node.
+     * @param   {IBalanceSheetAccountNode} node
+     * @returns {IBalanceSheetAccountNode}
+     */
+    protected previousYearNetIncomeNodeCompose = (
+      node: IBalanceSheetNetIncomeNode
+    ): IBalanceSheetNetIncomeNode => {
+      return R.compose(
+        R.when(
+          this.query.isPreviousYearPercentageActive,
+          this.assocPreviousYearTotalPercentageNode
+        ),
+        R.when(
+          this.query.isPreviousYearChangeActive,
+          this.assocPreviousYearTotalChangeNode
+        ),
+        // Associate the PY to date periods horizontal nodes.
+        R.when(
+          this.isNodeHasHorizontalTotals,
+          this.assocPreviousYearNetIncomeHorizNode
+        ),
+        this.assocPreviousYearNetIncomeNode
+      )(node);
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetQuery.ts

@@ -12,26 +12,31 @@ export class BalanceSheetQuery extends R.compose(FinancialDateRanges)(
    * @param {IBalanceSheetQuery}
    */
   public readonly query: IBalanceSheetQuery;
+
   /**
    * Previous year to date.
    * @param {Date}
    */
   public readonly PYToDate: Date;
+
   /**
    * Previous year from date.
    * @param {Date}
    */
   public readonly PYFromDate: Date;
+
   /**
    * Previous period to date.
    * @param {Date}
    */
   public readonly PPToDate: Date;
+
   /**
    * Previous period from date.
    * @param {Date}
    */
   public readonly PPFromDate: Date;
+
   /**
    * Constructor method
    * @param {IBalanceSheetQuery} query

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetRepository.ts

@@ -3,6 +3,7 @@ import * as R from 'ramda';
 import { Knex } from 'knex';
 import { isEmpty } from 'lodash';
 import {
+  IAccount,
   IAccountTransactionsGroupBy,
   IBalanceSheetQuery,
   ILedger,
@@ -11,9 +12,12 @@ import { transformToMapBy } from 'utils';
 import Ledger from '@/services/Accounting/Ledger';
 import { BalanceSheetQuery } from './BalanceSheetQuery';
 import { FinancialDatePeriods } from '../FinancialDatePeriods';
+import { ACCOUNT_PARENT_TYPE, ACCOUNT_TYPE } from '@/data/AccountTypes';
+import { BalanceSheetRepositoryNetIncome } from './BalanceSheetRepositoryNetIncome';
 
 @Service()
 export default class BalanceSheetRepository extends R.compose(
+  BalanceSheetRepositoryNetIncome,
   FinancialDatePeriods
 )(class {}) {
   /**
@@ -65,8 +69,22 @@ export default class BalanceSheetRepository extends R.compose(
    */
   public readonly PPFromDate: Date;
 
+  /**
+   * Total closing accounts ledger.
+   * @param {Ledger}
+   */
   public totalAccountsLedger: Ledger;
 
+  /**
+   * Total income accounts ledger.
+   */
+  public incomeLedger: Ledger;
+
+  /**
+   * Total expense accounts ledger.
+   */
+  public expensesLedger: Ledger;
+
   /**
    * Transactions group type.
    * @param {IAccountTransactionsGroupBy}
@@ -171,6 +189,8 @@ export default class BalanceSheetRepository extends R.compose(
     ) {
       await this.initPeriodsPreviousPeriod();
     }
+    //
+    await this.asyncInitializeNetIncome();
   };
 
   // ----------------------------
@@ -181,6 +201,7 @@ export default class BalanceSheetRepository extends R.compose(
 
     this.accounts = accounts;
     this.accountsByType = transformToMapBy(accounts, 'accountType');
+    this.accountsByParentType = transformToMapBy(accounts, 'accountParentType');
   };
 
   // ----------------------------
@@ -309,14 +330,15 @@ export default class BalanceSheetRepository extends R.compose(
 
   /**
    * Closing accounts date periods.
-   * @param openingDate
+   * @param {Date} fromDate
-   * @param datePeriodsType
+   * @param {Date} toDate
+   * @param {string} datePeriodsType
    * @returns
    */
   public accountsDatePeriods = async (
     fromDate: Date,
     toDate: Date,
-    datePeriodsType
+    datePeriodsType: string
   ) => {
     const { AccountTransaction } = this.models;
 
@@ -336,6 +358,7 @@ export default class BalanceSheetRepository extends R.compose(
 
   /**
    * Retrieve the opening balance transactions of the report.
+   * @param {Date|string} openingDate -
    */
   public closingAccountsTotal = async (openingDate: Date | string) => {
     const { AccountTransaction } = this.models;

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetRepositoryNetIncome.ts

@@ -0,0 +1,222 @@
+import * as R from 'ramda';
+import { IAccount, ILedger } from '@/interfaces';
+import { FinancialDatePeriods } from '../FinancialDatePeriods';
+import { ACCOUNT_PARENT_TYPE } from '@/data/AccountTypes';
+
+export const BalanceSheetRepositoryNetIncome = (Base) =>
+  class extends R.compose(FinancialDatePeriods)(Base) {
+    // -----------------------
+    // # Net Income
+    // -----------------------
+    public incomeAccounts: IAccount[];
+    public incomeAccountsIds: number[];
+
+    public expenseAccounts: IAccount[];
+    public expenseAccountsIds: number[];
+
+    public incomePeriodsAccountsLedger: ILedger;
+    public incomePeriodsOpeningAccountsLedger: ILedger;
+    public expensesPeriodsAccountsLedger: ILedger;
+    public expensesOpeningAccountLedger: ILedger;
+
+    public incomePPAccountsLedger: ILedger;
+    public expensePPAccountsLedger: ILedger;
+
+    public incomePPPeriodsAccountsLedger: ILedger;
+    public incomePPPeriodsOpeningAccountLedger: ILedger;
+    public expensePPPeriodsAccountsLedger: ILedger;
+    public expensePPPeriodsOpeningAccountLedger: ILedger;
+
+    public incomePYTotalAccountsLedger: ILedger;
+    public expensePYTotalAccountsLedger: ILedger;
+
+    public incomePYPeriodsAccountsLedger: ILedger;
+    public incomePYPeriodsOpeningAccountLedger: ILedger;
+    public expensePYPeriodsAccountsLedger: ILedger;
+    public expensePYPeriodsOpeningAccountLedger: ILedger;
+
+    /**
+     * Async initialize.
+     * @returns {Promise<void>}
+     */
+    public asyncInitializeNetIncome = async () => {
+      await this.initAccounts();
+      await this.initAccountsTotalLedger();
+
+      // Net Income
+      this.initIncomeAccounts();
+      this.initExpenseAccounts();
+
+      this.initIncomeTotalLedger();
+      this.initExpensesTotalLedger();
+
+      // Date periods
+      if (this.query.isDatePeriodsColumnsType()) {
+        this.initNetIncomeDatePeriods();
+      }
+      // Previous Year (PY).
+      if (this.query.isPreviousYearActive()) {
+        this.initNetIncomePreviousYear();
+      }
+      // Previous Period (PP).
+      if (this.query.isPreviousPeriodActive()) {
+        this.initNetIncomePreviousPeriod();
+      }
+      // Previous Year (PY) / Date Periods.
+      if (
+        this.query.isPreviousYearActive() &&
+        this.query.isDatePeriodsColumnsType()
+      ) {
+        this.initNetIncomePeriodsPreviewYear();
+      }
+      // Previous Period (PP) / Date Periods.
+      if (
+        this.query.isPreviousPeriodActive() &&
+        this.query.isDatePeriodsColumnsType()
+      ) {
+        this.initNetIncomePeriodsPreviousPeriod();
+      }
+    };
+
+    // ----------------------------
+    // # Net Income
+    // ----------------------------
+    /**
+     * Initialize income accounts.
+     */
+    private initIncomeAccounts = () => {
+      const incomeAccounts = this.accountsByParentType.get(
+        ACCOUNT_PARENT_TYPE.INCOME
+      );
+      const incomeAccountsIds = incomeAccounts.map((a) => a.id);
+
+      this.incomeAccounts = incomeAccounts;
+      this.incomeAccountsIds = incomeAccountsIds;
+    };
+
+    /**
+     * Initialize expense accounts.
+     */
+    private initExpenseAccounts = () => {
+      const expensesAccounts = this.accountsByParentType.get(
+        ACCOUNT_PARENT_TYPE.EXPENSE
+      );
+      const expensesAccountsIds = expensesAccounts.map((a) => a.id);
+
+      this.expenseAccounts = expensesAccounts;
+      this.expenseAccountsIds = expensesAccountsIds;
+    };
+
+    /**
+     * Initialize the income total ledger.
+     */
+    private initIncomeTotalLedger = (): void => {
+      // Inject to the repository.
+      this.incomeLedger = this.totalAccountsLedger.whereAccountsIds(
+        this.incomeAccountsIds
+      );
+    };
+
+    /**
+     * Initialize the expenses total ledger.
+     */
+    private initExpensesTotalLedger = (): void => {
+      this.expensesLedger = this.totalAccountsLedger.whereAccountsIds(
+        this.expenseAccountsIds
+      );
+    };
+
+    // ----------------------------
+    // # Net Income - Date Periods
+    // ----------------------------
+    /**
+     * Initialize the net income date periods.
+     */
+    public initNetIncomeDatePeriods = () => {
+      this.incomePeriodsAccountsLedger =
+        this.periodsAccountsLedger.whereAccountsIds(this.incomeAccountsIds);
+
+      this.incomePeriodsOpeningAccountsLedger =
+        this.periodsOpeningAccountLedger.whereAccountsIds(
+          this.incomeAccountsIds
+        );
+
+      this.expensesPeriodsAccountsLedger =
+        this.periodsAccountsLedger.whereAccountsIds(this.expenseAccountsIds);
+
+      this.expensesOpeningAccountLedger =
+        this.periodsOpeningAccountLedger.whereAccountsIds(
+          this.expenseAccountsIds
+        );
+    };
+
+    // ----------------------------
+    // # Net Income - Previous Period
+    // ----------------------------
+    /**
+     * Initialize the total net income PP.
+     */
+    public initNetIncomePreviousPeriod = () => {
+      this.incomePPAccountsLedger = this.PPTotalAccountsLedger.whereAccountsIds(
+        this.incomeAccountsIds
+      );
+      this.expensePPAccountsLedger =
+        this.PPTotalAccountsLedger.whereAccountsIds(this.expenseAccountsIds);
+    };
+
+    /**
+     * Initialize the net income periods of previous period.
+     */
+    public initNetIncomePeriodsPreviousPeriod = () => {
+      this.incomePPPeriodsAccountsLedger =
+        this.PPPeriodsAccountsLedger.whereAccountsIds(this.incomeAccountsIds);
+
+      this.incomePPPeriodsOpeningAccountLedger =
+        this.PPPeriodsOpeningAccountLedger.whereAccountsIds(
+          this.incomeAccountsIds
+        );
+
+      this.expensePPPeriodsAccountsLedger =
+        this.PPPeriodsAccountsLedger.whereAccountsIds(this.expenseAccountsIds);
+
+      this.expensePPPeriodsOpeningAccountLedger =
+        this.PPPeriodsOpeningAccountLedger.whereAccountsIds(
+          this.expenseAccountsIds
+        );
+    };
+
+    // ----------------------------
+    // # Net Income - Previous Year
+    // ----------------------------
+    /**
+     * Initialize the net income PY total.
+     */
+    public initNetIncomePreviousYear = () => {
+      this.incomePYTotalAccountsLedger =
+        this.PYTotalAccountsLedger.whereAccountsIds(this.incomeAccountsIds);
+
+      this.expensePYTotalAccountsLedger =
+        this.PYTotalAccountsLedger.whereAccountsIds(this.expenseAccountsIds);
+    };
+
+    /**
+     * Initialize the net income PY periods.
+     */
+    public initNetIncomePeriodsPreviewYear = () => {
+      this.incomePYPeriodsAccountsLedger =
+        this.PYPeriodsAccountsLedger.whereAccountsIds(this.incomeAccountsIds);
+
+      this.incomePYPeriodsOpeningAccountLedger =
+        this.PYPeriodsOpeningAccountLedger.whereAccountsIds(
+          this.incomeAccountsIds
+        );
+
+      this.expensePYPeriodsAccountsLedger =
+        this.PYPeriodsAccountsLedger.whereAccountsIds(this.expenseAccountsIds);
+
+      this.expensePYPeriodsOpeningAccountLedger =
+        this.PYPeriodsOpeningAccountLedger.whereAccountsIds(
+          this.expenseAccountsIds
+        );
+    };
+  };

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetSchema.ts

@@ -7,7 +7,6 @@ import {
 import { ACCOUNT_TYPE } from '@/data/AccountTypes';
 import { FinancialSchema } from '../FinancialSchema';
 
-
 export const BalanceSheetSchema = (Base) =>
   class extends R.compose(FinancialSchema)(Base) {
     /**
@@ -115,6 +114,13 @@ export const getBalanceSheetSchema = () => [
         id: BALANCE_SHEET_SCHEMA_NODE_ID.EQUITY,
         type: BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNTS,
         accountsTypes: [ACCOUNT_TYPE.EQUITY],
+        children: [
+          {
+            name: 'balance_sheet.net_income',
+            id: BALANCE_SHEET_SCHEMA_NODE_ID.NET_INCOME,
+            type: BALANCE_SHEET_SCHEMA_NODE_TYPE.NET_INCOME,
+          },
+        ],
       },
     ],
     alwaysShow: true,

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetTable.ts

@@ -8,6 +8,10 @@ import {
   BALANCE_SHEET_SCHEMA_NODE_TYPE,
   IBalanceSheetDataNode,
   IBalanceSheetSchemaNode,
+  IBalanceSheetNetIncomeNode,
+  IBalanceSheetAccountNode,
+  IBalanceSheetAccountsNode,
+  IBalanceSheetAggregateNode,
 } from '@/interfaces';
 import { tableRowMapper } from 'utils';
 import FinancialSheet from '../FinancialSheet';
@@ -108,11 +112,13 @@ export default class BalanceSheetTable extends R.compose(
   };
 
   /**
-   *
+   * Retrieves the table row from the given report aggregate node.
-   * @param node
+   * @param {IBalanceSheetAggregateNode} node
    * @returns {ITableRow}
    */
-  private aggregateNodeTableRowsMapper = (node): ITableRow => {
+  private aggregateNodeTableRowsMapper = (
+    node: IBalanceSheetAggregateNode
+  ): ITableRow => {
     const columns = this.commonColumnsAccessors();
     const meta = {
       rowTypes: [IROW_TYPE.AGGREGATE],
@@ -122,11 +128,13 @@ export default class BalanceSheetTable extends R.compose(
   };
 
   /**
-   *
+   * Retrieves the table row from the given report accounts node.
-   * @param node
+   * @param {IBalanceSheetAccountsNode} node
    * @returns {ITableRow}
    */
-  private accountsNodeTableRowsMapper = (node): ITableRow => {
+  private accountsNodeTableRowsMapper = (
+    node: IBalanceSheetAccountsNode
+  ): ITableRow => {
     const columns = this.commonColumnsAccessors();
     const meta = {
       rowTypes: [IROW_TYPE.ACCOUNTS],
@@ -136,11 +144,13 @@ export default class BalanceSheetTable extends R.compose(
   };
 
   /**
-   *
+   * Retrieves the table row from the given report account node.
-   * @param {} node
+   * @param {IBalanceSheetAccountNode} node
    * @returns {ITableRow}
    */
-  private accountNodeTableRowsMapper = (node): ITableRow => {
+  private accountNodeTableRowsMapper = (
+    node: IBalanceSheetAccountNode
+  ): ITableRow => {
     const columns = this.commonColumnsAccessors();
 
     const meta = {
@@ -150,6 +160,22 @@ export default class BalanceSheetTable extends R.compose(
     return tableRowMapper(node, columns, meta);
   };
 
+  /**
+   * Retrieves the table row from the given report net income node.
+   * @param {IBalanceSheetNetIncomeNode} node
+   * @returns {ITableRow}
+   */
+  private netIncomeNodeTableRowsMapper = (
+    node: IBalanceSheetNetIncomeNode
+  ): ITableRow => {
+    const columns = this.commonColumnsAccessors();
+    const meta = {
+      rowTypes: [IROW_TYPE.NET_INCOME],
+      id: node.id,
+    };
+    return tableRowMapper(node, columns, meta);
+  };
+
   /**
    * Mappes the given report node to table rows.
    * @param   {IBalanceSheetDataNode} node -
@@ -169,6 +195,10 @@ export default class BalanceSheetTable extends R.compose(
         this.isNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.ACCOUNT),
         this.accountNodeTableRowsMapper,
       ],
+      [
+        this.isNodeType(BALANCE_SHEET_SCHEMA_NODE_TYPE.NET_INCOME),
+        this.netIncomeNodeTableRowsMapper,
+      ],
     ])(node);
   };
 

packages/server/src/services/FinancialStatements/BalanceSheet/BalanceSheetTableInjectable.ts

@@ -0,0 +1,42 @@
+import { Inject, Service } from 'typedi';
+import BalanceSheetStatementService from './BalanceSheetInjectable';
+import BalanceSheetTable from './BalanceSheetTable';
+import { IBalanceSheetQuery, IBalanceSheetTable } from '@/interfaces';
+import HasTenancyService from '@/services/Tenancy/TenancyService';
+
+@Service()
+export class BalanceSheetTableInjectable {
+  @Inject()
+  private tenancy: HasTenancyService;
+
+  @Inject()
+  private balanceSheetService: BalanceSheetStatementService;
+
+  /**
+   * Retrieves the balance sheet in table format.
+   * @param {number} tenantId
+   * @param {number} query
+   * @returns {Promise<IBalanceSheetTable>}
+   */
+  public async table(
+    tenantId: number,
+    filter: IBalanceSheetQuery
+  ): Promise<IBalanceSheetTable> {
+    const i18n = this.tenancy.i18n(tenantId);
+
+    const { data, query, meta } = await this.balanceSheetService.balanceSheet(
+      tenantId,
+      filter
+    );
+    const table = new BalanceSheetTable(data, query, i18n);
+
+    return {
+      table: {
+        columns: table.tableColumns(),
+        rows: table.tableRows(),
+      },
+      query,
+      meta,
+    };
+  }
+}

packages/server/src/services/FinancialStatements/BalanceSheet/constants.ts

@@ -9,5 +9,6 @@ export enum IROW_TYPE {
   AGGREGATE = 'AGGREGATE',
   ACCOUNTS = 'ACCOUNTS',
   ACCOUNT = 'ACCOUNT',
+  NET_INCOME = 'NET_INCOME',
   TOTAL = 'TOTAL',
 }

packages/server/src/services/FinancialStatements/CashFlow/CashflowExportInjectable.ts

@@ -0,0 +1,46 @@
+import { Inject, Service } from 'typedi';
+import { ICashFlowStatementQuery } from '@/interfaces';
+import { TableSheet } from '@/lib/Xlsx/TableSheet';
+import { CashflowTableInjectable } from './CashflowTableInjectable';
+
+@Service()
+export class CashflowExportInjectable {
+  @Inject()
+  private cashflowSheetTable: CashflowTableInjectable;
+
+  /**
+   * Retrieves the cashflow sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async xlsx(
+    tenantId: number,
+    query: ICashFlowStatementQuery
+  ): Promise<Buffer> {
+    const table = await this.cashflowSheetTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToXLSX();
+
+    return tableSheet.convertToBuffer(tableCsv, 'xlsx');
+  }
+
+  /**
+   * Retrieves the cashflow sheet in CSV format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async csv(
+    tenantId: number,
+    query: ICashFlowStatementQuery
+  ): Promise<string> {
+    const table = await this.cashflowSheetTable.table(tenantId, query);
+
+    const tableSheet = new TableSheet(table.table);
+    const tableCsv = tableSheet.convertToCSV();
+
+    return tableCsv;
+  }
+}

packages/server/src/services/FinancialStatements/CashFlow/CashflowSheetApplication.ts

@@ -0,0 +1,58 @@
+import { Inject, Service } from 'typedi';
+import { CashflowExportInjectable } from './CashflowExportInjectable';
+import { ICashFlowStatementQuery } from '@/interfaces';
+import CashFlowStatementService from './CashFlowService';
+import { CashflowTableInjectable } from './CashflowTableInjectable';
+
+@Service()
+export class CashflowSheetApplication {
+  @Inject()
+  private cashflowExport: CashflowExportInjectable;
+
+  @Inject()
+  private cashflowSheet: CashFlowStatementService;
+
+  @Inject()
+  private cashflowTable: CashflowTableInjectable;
+
+  /**
+   * Retrieves the cashflow sheet
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   */
+  public async sheet(tenantId: number, query: ICashFlowStatementQuery) {
+    return this.cashflowSheet.cashFlow(tenantId, query);
+  }
+
+  /**
+   * Retrieves the cashflow sheet in table format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   */
+  public async table(tenantId: number, query: ICashFlowStatementQuery) {
+    return this.cashflowTable.table(tenantId, query);
+  }
+
+  /**
+   * Retrieves the cashflow sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async xlsx(tenantId: number, query: ICashFlowStatementQuery) {
+    return this.cashflowExport.xlsx(tenantId, query);
+  }
+
+  /**
+   * Retrieves the cashflow sheet in CSV format.
+   * @param {number} tenantId
+   * @param {ICashFlowStatementQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public async csv(
+    tenantId: number,
+    query: ICashFlowStatementQuery
+  ): Promise<string> {
+    return this.cashflowExport.csv(tenantId, query);
+  }
+}

packages/server/src/services/FinancialStatements/CashFlow/CashflowTableInjectable.ts

@@ -0,0 +1,37 @@
+import { Inject, Service } from "typedi";
+import { ICashFlowStatementQuery, ICashFlowStatementTable } from "@/interfaces";
+import HasTenancyService from "@/services/Tenancy/TenancyService";
+import CashFlowTable from "./CashFlowTable";
+import CashFlowStatementService from "./CashFlowService";
+
+@Service()
+export class CashflowTableInjectable {
+  @Inject()
+  private tenancy: HasTenancyService;
+
+  @Inject()
+  private cashflowSheet: CashFlowStatementService;
+
+  /**
+   * Retrieves the cash flow table.
+   * @returns {Promise<ICashFlowStatementTable>}
+   */
+  public async table(
+    tenantId: number,
+    query: ICashFlowStatementQuery
+  ): Promise<ICashFlowStatementTable> {
+    const i18n = this.tenancy.i18n(tenantId);
+
+    const cashflowDOO = await this.cashflowSheet.cashFlow(tenantId, query);
+    const cashflowTable = new CashFlowTable(cashflowDOO, i18n);
+
+    return {
+      table: {
+        columns: cashflowTable.tableColumns(),
+        rows: cashflowTable.tableRows(),
+      },
+      query: cashflowDOO.query,
+      meta: cashflowDOO.meta,
+    };
+  }
+}

packages/server/src/services/FinancialStatements/CustomerBalanceSummary/CustomerBalanceSummaryApplication.ts

@@ -0,0 +1,60 @@
+import { Inject, Service } from 'typedi';
+import { CustomerBalanceSummaryExportInjectable } from './CustomerBalanceSummaryExportInjectable';
+import { CustomerBalanceSummaryTableInjectable } from './CustomerBalanceSummaryTableInjectable';
+import { ICustomerBalanceSummaryQuery } from '@/interfaces';
+import { CustomerBalanceSummaryService } from './CustomerBalanceSummaryService';
+
+@Service()
+export class CustomerBalanceSummaryApplication {
+  @Inject()
+  private customerBalanceSummaryTable: CustomerBalanceSummaryTableInjectable;
+
+  @Inject()
+  private customerBalanceSummaryExport: CustomerBalanceSummaryExportInjectable;
+
+  @Inject()
+  private customerBalanceSummarySheet: CustomerBalanceSummaryService;
+
+  /**
+   * Retrieves the customer balance sheet in json format.
+   * @param {number} tenantId
+   * @param {ICustomerBalanceSummaryQuery} query
+   * @returns {Promise<ICustomerBalanceSummarySheet>}
+   */
+  public sheet(tenantId: number, query: ICustomerBalanceSummaryQuery) {
+    return this.customerBalanceSummarySheet.customerBalanceSummary(
+      tenantId,
+      query
+    );
+  }
+
+  /**
+   * Retrieves the customer balance sheet in json format.
+   * @param {number} tenantId
+   * @param {ICustomerBalanceSummaryQuery} query
+   * @returns {Promise<ICustomerBalanceSummaryTable>}
+   */
+  public table(tenantId: number, query: ICustomerBalanceSummaryQuery) {
+    return this.customerBalanceSummaryTable.table(tenantId, query);
+  }
+
+  /**
+   * Retrieves the customer balance sheet in XLSX format.
+   * @param {number} tenantId
+   * @param {ICustomerBalanceSummaryQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public xlsx(tenantId: number, query: ICustomerBalanceSummaryQuery) {
+    return this.customerBalanceSummaryExport.xlsx(tenantId, query);
+  }
+
+  /**
+   * Retrieves the customer balance sheet in CSV format.
+   * @param {number} tenantId
+   * @param {ICustomerBalanceSummaryQuery} query
+   * @returns {Promise<Buffer>}
+   */
+  public csv(tenantId: number, query: ICustomerBalanceSummaryQuery) {
+    return this.customerBalanceSummaryExport.csv(tenantId, query);
+  }
+}