1-20 of 55
As with much of coding there are always a myriad of ways to achieve an end result, some good, some not so good. We have found these samples useful over the years. We hope that you can use them "as is" or use them to short circuit development. Either way they should provide some interesting reading and hopefully provoke some thought.
This Sales Analysis SQL Query has been optimized for Power Pivot for Excel. The SQL Query delivers the result table that is used to drill down on the main KPI areas in SYSPRO. i.e. Branch, Area, Customer, Salesperson and Stock Code.
UserEmailClient which allows SYSPRO to email without a Client Email Application. This uses Simple Mail Transport Protocol (SMTP)
Quickly check whether your sub-ledgers balance to your GL control accounts.
Timing differences that exist as a result of unposted GL Journals are displayed separately. This allows you to focus only on actual differences without first having to ensure that all journals have been posted to your General Ledger.
This PDF document contains the suggested steps to follow when processing a BOM Cost Update in SYSPRO using the BOM Cost Implosion program. It is best used in a Standard Cost environment but is suited to all costing methods in SYSPRO.
A .Net User Control that shows how to run VBScript using the SYSPRO scripting engine
An example of how to write a .Net WPF User Control to run in a SYSPRO custom pane.
All the code is available in the accompanying manual and Visual Studio solution.
This User Control shows how it is possible to quickly capture two dimensional data (such as colour and size, or width and length) in a grid and then create a sales order line for each combination. It is for use in demonstrations.
A further example of running WPF forms in SYSPRO User controls.
Test harness to interact with SYSPRO business objects
Modify the SYSPRO Master Account codes throughout the entire SYSPRO product catering for the changing or merging of the associated Master Account codes in all master, transaction and history tables. Includes the following modules:
• GLAM - General Ledger Account Manipulation
• SCAM – Stock Code Account Manipulation
• ARAM – Accounts Receivable Account Manipulation
• APAM – Accounts Payable Account Manipulation
• PCAM – Product Class Account Manipulation
• SPAM – StockCode ProductClass Account Manipulation
Inventory Stock Take
A VB Script was added to the ARSPCS Program so that the operator would be
prompted to add a new company contact as a new CMS contact. Using the VB
Script, we are able to copy the information captured at the point of adding a
company into SYSPRO and then add this information as a new CMS contact into
Work in Progress Job Receipts
The Work in Progress Job Entry application for SYSPRO Espresso.
This .NET User control is a simple RSS feed reader
The Work in Progress Job Issues application for SYSPRO Espresso.
This is an example of how you can push notifications out from SYSPRO to Slack.com and use the Slack Apps on IoS, Android, and windows to display the notification.
Tweetr for SYSPRO is a .NET User Control that allows you to Tweet from within SYSPRO.