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 […]
Category: DB STRUCTURE
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, […]
V_PE_TotalMonthSalary
view display month wise salary paid to employees ( total amount paid to employee during that month – bonus etc) requirement: payment of salary must be made through account voucher employeeEntries –Number of accounts entries – if it is more than employee count then it means there are some duplicate entries or bonuses in that […]
m_stock_opg
qty 1 = holds weight in MT2 Irfan Anis