Double amount for a particular ledger

Check the Summation Logic: Ensure that the summation logic for the beginning balance and period balances is correctly implemented. Verify that the period balance is not being added twice in the calculation.

Review Database Triggers and Procedures: Look for any database triggers or stored procedures that might be affecting the 'GL Balance' table. Sometimes, triggers can cause unexpected behavior like doubling amounts.

Validate Data Integrity: Check for any data integrity issues in the tables involved. Ensure that there are no duplicate records or anomalies in the period balances table.

Examine Joins and Relationships: Since the ledger type is from another table, ensure that the joins and relationships between the tables are correctly defined. Incorrect joins can sometimes lead to duplicated data.

Check for Empty Records: Investigate why empty records are being generated. This could be due to incorrect data insertion logic or missing mandatory fields during data entry.

Audit Recent Changes: If this issue started occurring recently, review any recent changes made to the database schema, application code, or data import processes that might have introduced this problem.

Log and Monitor: Implement logging to capture the exact queries and data being processed when the issue occurs. This can help in identifying the root cause.

Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!