Sales Order Processing

By May 9, 2012 Read More →

Adding Customer Item User Defined fields to SOP Invoice

Mariano Gomez published an excellant article which explains the entire steps to add customer item user-defined fields to SOP invoice. The article is very detailed and very useful for developers. Mariano used Support Debugger Tool to deliver the solution and this demonstrate the power of SDT. Click here to read Adding Customer Item User Defined fields to SOP […]

By May 8, 2012 Read More →

SQL view for unpaid SOP Transaction with No. of overdue days

Recently one of my customer asked me to create a script to shows all open (unpaid) sales transaction with the total number of days overdue based on the current system date and customer’s payment terms. Customer also wanted to see a column that shows the estimated payment date based on the actual payment terms and the […]