I have a crystal report that lists the transactions that were entered into Sage General Ledger.   For some reason; I am trying to figure out; whenever a duplicate amount is entered in the GL Transaction it does not show up in my report.

Example   2010   ACCTS PAY-Trade                                                                                6,980.94

                  8560   Janitorial Expense   Nov Exp                               2,279.24

                 8560    Janitorial Expense    Dec Exp                              2,422.46

                 8560    Janitorial Expense   Jan 2023                              2,279.24

above is my entry.  When I run my report the 2nd 2,279.24 is not showing in the dill down. Then my report shows an out-of-balance of balance by 2,279.24.

I am not sure why duplicate amounts are missing from my report.  Any suggestion on where to start looking?