Hi Good Morning, could some one list all the tables in SQL server that are related to Accounts Receivable Aging Report. We have SAGE 300 2021 version
thanks
GP
Hi Good Morning, could some one list all the tables in SQL server that are related to Accounts Receivable Aging Report. We have SAGE 300 2021 version
thanks
GP
AROBL+AROBP+AROBS -> ARAGED+ARCUS
Thank you. Let me try and make a query in SQL
I checked an old report I wrote, you don't need AROBS. Here is how I did it with Crystal:
Thanks once again. With these tables , can I extract all transactions of invoice, receipts, credit note , debit notes and journal entries relating to all accounts receivables. Kindly clarify
Yes, but not journal entries. You need ARPJH and ARPJD for those.
Thank you so much. I will try
Can I request one more. Could you please make a similar diagram linking primary and foreign keys including these two journal tables. Thank you
Sage doesn't have foreign keys. Primary: TYPEBTCH, POSTSEQNCE, CNTBTCH, CNTITEM
Thank you. I will get access to Sage SQL server only by Wednesday. Let me try
*Community Hub is the new name for Sage City