>>>>>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

I did a lot work with SBT leading up the Y2K.
MS' jettisoning of VFP has led to its slow demise, but it's still a great package for the SMB market where customization is required.
Several of my clients are planning to use it ad infinitum.