Archives

Archive for February, 2012

I have found the Syteline Financial Excel Addon a handy tool for building financial statement, much better than the financial statement writer inside Syteline.  Many long time Syteline user still have hard time understand the old financial statement writer, ever after using it for years.  But the Excel add on is really straight forward, especially […]

Feb 22nd, 2012 | Filed under Application, Implementation

PO Receive (INV PRCV) Item ABC current on-hand qty = 100, cost = $1.4 PO purchase price $1.17, with 17% VAT tax, material cost = $1. Receive qty = 100 After received, qty = 200, average cost = $1.2     Debit Credit Comment Inventory 120   100 pcs on after received unit cost of […]

Feb 18th, 2012 | Filed under Application, Implementation

Something to remember, in programming in multiple site environment, if you have site that has differ time zone than the server time zone, remember to use GetSiteDate function, instead of directly GETDATE().  Below is code sample.    SET @PrintDate = dbo.GetSiteDate(GETDATE())

Feb 9th, 2012 | Filed under Development, SQL

Today, many, if not most, US manufacturers have operation in China.  They either build out manufacturing facilities to take advantage of global supply chain, or setup sales/marketing operation to catch China market potential, and may be both.  With US headquarter and operation running in Syteline, it is nature to put Syteline into China branch as […]

Feb 5th, 2012 | Filed under Application, Implementation