I started using SQL-Ledger (SL) since the start of this business in 2001, and for the first 4 years as a service business, I had used only SL’s Account Receivable (AR) and Account Payable (AP) modules for time billings and payments. Then from 2005 and on, I increasingly utilized SL’s Inventory Control (IC) and its other modules as the business begun to take on inventories and employees. So I have been a SL user for 13 years, and in the community for about just as long. Couple months ago, I had received a message from a SL forum users asking for my thought on SL; hence, the reason for this writeup.Read More
We extract shipping infomation from SQL Ledger and connect it to Fedex Ship Manager and Endicia Professional via an ODBC connection. Two fields in the parts table we use for overseas customs declaration as a result need to have a not null constraint added to them so they would not be empty when parts are created; our shipping softwares throw an exception when these fields were empty for overseas shipping labels.