Receiving a Payment via SDK

Question

Does anyone have an example of how to receive a payment via the Sage SDK? It's looking to me like you have to go directly at the tables (which is a HUGE gap in the SDK in my opinion) but that sounds risky. Anyone know how to do this?

mikejobbox · Accepted Answer

I did get this to work but I REALLY don't recommend it. There have been a ton of issues that had to get resolved over the years with account reconciliation and everything. It is an INCREDIBLE gap in their SDK that they do not allow for this and I'm very seriously considering dropping support for this feature in our connector. It just too flaky.

RandyW · Answer

Noesis said: I am not usre if you are referring to enable the binary log 
 I think that Binary logging is at more of a redo / undo binary data block level as in ib_logfile0 and ib_logfile1. 
 You want SQL Query Logging http://dev.mysql.com/doc/refman/5.7/en/query-log.html 
 Add a line to dbengine.ini : 
 general_log = 'ON' 
 (probably under C:\Program Files (x86)\winsim\ConnectionManager\MySqlBinary\5.6.10) (Check the properties of the Connection Manager service for the path) 
 There will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension. 
 Execute the transaction, copy the log file and paste it somewhere you can work on it. I found that renaming to .CSV formatted it the best 
 On starting Sage 50 there will be a log file created in the 'SAJ' folder with the name of the workstation and a 'LOG' extension. The file will be deleted when closing the Sage 50 Company File. 
 Execute the transaction you want to see, copy the log file and paste it somewhere you can work on it, the transactions are in chronological order. I found that renaming to .CSV and autofiltering it in Excel worked best. 
 The above information is intended for study and troubleshooting only, the user of it takes all responsibility for not violating the Sage 50 software and SDK End User license agreements.

Sage 50 Canada

Receiving a Payment via SDK

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING