How to get invoice applied amount?

[jjmbosslm]

I need to get invoice applied amounts back into my applications. I tried recording a macro from the customer activity screens, but the macro is always blank.

Is this the correct location and/or method to find this information?

Thanks

 

[DjangMan]

Do you want to see how much of an invoice has been paid?

 

[jjmbosslm]

I'm sorry, I actually need the remaining balance of an invoice or list of invoices (if possible)

The reason I need the remaining balance is because that is the value returned from the other accounting packages we interact with

Thanks

 

[ettienne]

AROBL.AMTDUEHC

 

[jjmbosslm]

Thanks for the udpate

Right now, I don't think I want to go directly to the database. Our client is switching from prevasive to SQLServer and I also do not know what backend my future clients will be using.

Why isn't the macro creating a script?

Thanks

 

[ettienne]

It depends what you are recording.
Open the AR0036 view and get the value from AMTDUEHC.
In short hand that would be AROBL.AMTDUEHC

 

[DjangMan]

Also the database structure is the same between Pervasive and MSSQL (and Oracle and DB2) so a query against the database would work no matter what back end the client had.