Thank You for your response.
After having a nightmare and an almost anxiety attack, here is what I found. so we have two trade payables accounts. While the Invoice is being recorded in, say, Trade payable (1), The offsetting Entry is adjusted in the other Trade payable Account(2). So if i check the Net trade payable (1) for the supplier it is Positive balance and if i Check Net trade payable (2) is shows Negative balance of the same Supplier.
Now i tried to look for location tracking of the supplier but i dont have that feature... Which sucks.
Now i need your expertise in this area as how to reflect the double entry through a single Trade payable account.
Really appreciate your quick response.
