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: […]
Category: CRM
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 […]
Power BI | Add New Account
You can use the following steps to create a new account: Add User Account Add the Report Schedule Refresh Irfan Anis
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
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, […]