Archives
Table trigger is important part of Syteline data integrity. There are many validation logics safe guarded by trigger program. But in some circumstances, you may want to turn the trigger program off, in order load certain data. This is specially true during data conversion of your Syteline implementation, you may need to use program to […]
There is simple three steps process for adding/changing replication rules in Syteline. 1) Add/Edit rules in Replication Rules form Notes: you setup all rules for source site in source site DB. 2) Regen trigger Open “Replication Management” form, Regen the replication trigger. This will make the trigger program in place to replicate transactions from now […]
About Shared Tables and Master Sites In a multi-site environment where there are many sites, large amounts of data, and many users, you may want to set up one site as the master site for an intranet. In that case, certain _all tables and user tables can reside only on the master site database and […]
Starting from Syteline 8.03, the Pick, Pack, Ship function utilize BarTender for bar code label printing. Create label templates in Bartender. The label template in Bartender need to use text file as database source. Create a sample text file with data like following, TC280847|123456789012345|DGM17ALS|03/03/2014 When we done, we should have data source like this, […]
If the actual work on an operation is performed at a location other than your shop floor, you must perform special steps to capture the status of the operation for accurate planning, scheduling, and costing. If you do not represent and manage an outside operation properly, the effects can ripple down through subsequent processes, resulting […]
Project Resource Transaction Two ways to post: 1) Project Resource Transaction Form; 2) Xref to PO and during PO receiving transactions Debit Credit Note Material or Other Material Inventory or Expense Defined by material prod code or On transaction screen Project Material Account Defined by Project Product Code Project OH Project Applied OH […]
Infor is really terrible sometime when it comes to documentation. For example, for the application event system to work, you have to make your site name exactly match with your configuration name, and this basic and critical information is not listed in installation guide and event system guide. You can only discover this when running […]
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 […]
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 […]
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 […]