Peter
You need to access ARMastnn and ARYMstnn (where:nn = Company Number 01-99). The path to the files are in SYCPATH.

Jon

>I need to retrieve open invoices (custno,date,invamount) and payments (date,amount) from the accounting package formerly knows as sbt (AccPac)to show an accurate aged statement of open A/R balances in my claims application.
>
>I have no sbt knowledge or docs
>
>just the balance I seem to get with
>

>select a.custno,a.customer,sum(b.balance) as balance ;
>from arcust01 a inner join armast01 b ;
>group by a.custno
>

>but I would like
>
>
>invoice date amount/payment
>123 01/01/01 100000.00
>123 03/03/01 -2000.00
>....
>
>thanks in advance
>Peter