Create new Domain & new User:

Steps to setup new Domain & new User: -Folder Migration: Copy existing folder in custom (both live and .local) Rename both copied folders accordingly. -Database Setup: Create a new database named new_database_name on the server. -Database Configuration: Access the configuration file of the live domain (new_domain_live) and update the database host to .\SQLCL. -User Creation: […]

Read More

How to fix PNL and Trial Balance not matching issue

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 […]

Read More

Source Code Path

Analysis 2023-08-23 s6 par fully updated code hain path: D:\ITL\itl_metro Git par bhi commit kar diye hain URL: https://git.itserver.biz/deskttop/itl_metro or metro kay RDP par bhi updated code hain. Newlib RDP Analysis path: C:\Hamza\Analysis.src Cam DEV RDP Analysis path: C:\Hamza\Analysis check oil star\Analysis.src Irfan Anis

Read More

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 […]

Read More

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

Read More

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 […]

Read More

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 […]

Read More

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 […]

Read More

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, […]

Read More