>>>>i have to get data out of an SBT/SagePro accounting system
>>>>specifically all A/R and cash receipts for import into a new system
>>>>
>>>>I think all open AR transactions are in ARMAST01 / ARTRAN01
>>>>cash receipts are in ARCASH
>>>>
>>>>then any previous transactions are a bit murky to me
>>>>maybe archived invoice data are in ARYMST / ARYTRN but where are previous cash receipts???
>>>>
>>>>
>>>>Maybe someone can help me
>>>>
>>>>Thanks
>>>>
>>>>
>>>>Peter
>>>
>>>What version of Pro Series are you using, Peter?
>>>The history processing changed after Series 7.
>>
>>
>>
>>7,3B
>>
>>i need to get a query af all invoices and payments for a given custno for example
>
>Peter
>
>The previous receipts are in arycsh.
>
>Caution:
>An invoice can appear in both armast and arymst.
>To avoid duplicating invoices, select only records from armast where currhist doesn't have an "X" in it.
>There is no such issue with arcash and arycsh.

thanks.

i filtered on currhist but did not find any
just to help me understand, why was this done this way.
I never dealt with SBT until now when we abandon it for the states own accounting system (peoplesoft - argh!)

Peter