Does anyone know where the value for the "Amount" field is coming from? Is it the amount in primary book, secondary, etc? This is because I was not able to find the value for that amount anywhere in my vendor record

"Amount" is total amount of the transaction in question in the base currency of the subsidiary (if multi currency used), and it should be the primary book in case of multibook.