Depending on exactly what you are looking to pull in, the DataDict.pdf in the Customers sections shows the tCusTr and tCusTrDt tables that include the information you see in the Customer Aged Reports.

tCusTr is essentially the header info for an Invoice or Deposit.  The tCusTrDt table is for any payment transactions that affect the Invoice or Deposit.

There is also the Miscellaneous section of the DataDict.pdf that shows the tRcptHdr table.  This table helps with the batch printing and I believe some of the lookup programming for the Receipt module in Sage 50.

Depending on exactly what you are looking to pull in, the DataDict.pdf in the Customers sections shows the tCusTr and tCusTrDt tables that include the information you see in the Customer Aged Reports.

tCusTr is essentially the header info for an Invoice or Deposit.  The tCusTrDt table is for any payment transactions that affect the Invoice or Deposit.

There is also the Miscellaneous section of the DataDict.pdf that shows the tRcptHdr table.  This table helps with the batch printing and I believe some of the lookup programming for the Receipt module in Sage 50.

Thank you very much.

Hi Gonzalo, if the above suggested answer helped, please do mark it as verified  for the benefit of others in this forum :). Thank you!

 Also, if you have a minute, tell us about your great experience on Sage City, take this short survey

Hi Richard,

Thank you very much for your answer. It was very useful.

Have a good day.