>>>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.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.