Sales Accounts 5000.00 Cr

You are seeing 5000.00 Cr but that is because of the custom format you have applied.
In fact, the amount in the cell is 5000
Can you bring a column containg the "Dr's" and "Cr's" ?