Hi everyone
Can anyone tell me the name of the table containing payments from clients in Sage 50 Canadian Edition? We are doing an integration with our CRM and are missing this information
Thank you
Hi everyone
Can anyone tell me the name of the table containing payments from clients in Sage 50 Canadian Edition? We are doing an integration with our CRM and are missing this information
Thank you
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 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
*Community Hub is the new name for Sage City