Here is how to solve the issue when debit and credit in PNL or trial balance do not match: For example, here is an older report from A-ONE, where debit and credit do not match: As you can see, debit & credit do not match Ensure postings are completed For domains: All metro domains Run […]
All posts by faheem
BOK – Bank of Khartoum
Introduction URL: bok.itserver.bizTech Stack: CodeIgniter, PHP, SQL ServerType: Banking application BOK is an account registration application for Bank of Khartoum, it allows users to sign up, and agents to view and approve/reject their applications. After an application is approved, it is synced to the “staging server”. Signup Form The signup form has ten steps. All […]
Custom Routing (cl_routes)
Latest Version: 1.0.6 The ability to create routes using the regular Express routers and test them directly using Express is powerful, but it comes with problems. Express is about an MB of code for your 2 KBs worth of routering. Our custom router helps you achieve the same results while using the same syntax and […]
Customers Plugin (cl_customer)
This plugin allows us to manage customers (CUST_TYPE=CUST_CUSTOMER). It provides functionality to CRUD customers. It is required for several functionalities including checks, payrolls, employees, etc. For Developers Created customers are stored in the customer’s table. Any additional details about the customer are stored in the customer details table. faheem
Employees Plugin (cl_employee)
The employee plugin allows you to manage employees and their salaries. It is required for payroll checks. It is a full-stack plugin with regular CRUD routes and a front end.This is the main area powered by this plugin: For Developers Employees are stored in the customers’ table. Their CUST_TYPE set to CUST_EMPLOYEE. Their details are […]
Database Commons (cl_db_commons)
This plugin contains common functionality related to databases. It exports several functions and classes to perform different database operations. Smart Update Imagine you want to update several entries of a record (imagine updating orders_products of an order). Normally, you will delete all records and reinsert the new records. However, this can lead to performance problems […]
Data Grid Component
Data grid is a customizable frontend component to render a table of items It uses React table under the hood. It is recommended if you want a greater level of control over your table. Basic Table The code creates a basic data table with two columns, view, edit, delete buttons and a create button on […]
CRM Database Structure
This feature is in active development and may be changed without notice. Tables List User It stores the users for the current domain. Make sure to always wrap the table name in brackets.For example:SELECT * FROM [User]; (Notice the brackets around “user”).It is pretty self-explanatory.email: The email of the user, unique table.password: The user’s password, […]
Creating a Plugin
Here is how you can add a new plugin in CRM 2.0 Go to the plugin directory:The current plugin directory is E:\Faheem\crm-node-plugins, but it could be changed in the future. Use the following commands to switch to that directory: Create the plugin: Use the command and pass your plugin name to create the plugin, make […]
Cheque Module (cl_cheque_module)
The Cheque module provides the functionality to create cheques by using a specified module. It requires the banks’ plugin to be enabled. End Points Cheque (/accounts2/cheque) Title / Method POST URL POST /accounts2/cheque Description Create a new cheque Body Parameters (POST) { data: { amount: number (The cheque balance or amount) bankId: number (The ID […]