|
|
RE—LAUNCH RE—LAUNCH RE—LAUNCH |
| Home RPGII to COBOL Translation SandyV ERP/MRP Privacy Contact | |
|
SandyV integrates complex manufacturing, distribution, and accounting, and is ideal for small and medium sized companies. Whatever your materials, your machines, your workbenches, your tools, and your processes, SandyV can help you track your progress, labor, purchases, sales, invoices, payments, payroll, and General Ledger. |
||
|
SandyV covers all operations from engineering Bill of Materials and Routing; Shop Floor activities such as setup, machining, and assembly; labor accounting through time cards and payroll; Inventory tracking from purchasing and production to shipping; and right through to shareholder reports, all in one package. |
||
|
SandyV provides for taking Sales Orders and feeding them to Inventory Control. Sales are either fulfilled from inventory, generating customer invoices, or, in the case of product shortages, are translated into Manufacturing Work Orders and their schedules. Work Orders in turn explode Bill of Materials into part and materials pick lists, and Purchase Orders to replenish parts and materials. Work Orders are routed through the Manufacturing and assembly Work Centers, replenishing Inventory to allow Sales Order fulfillment. SandyV supports alternative manufacturing routings, for timely delivery. The sales module supports commissioned salespeople, and distributor pricing. Manufacturing time cards feed the Payroll module for hourly production employees. Purchase Orders and Vendor Invoices feed the Accounts Payable module. Shipping and Customer Invoicing feed the Accounts Receivable module. All modules feed into the General Ledger, for Federal and State Tax reports, and Shareholder reports such as Profit and Loss & Statement of Operations. SandyV is offered through a 7-year Lease-to-Own arrangement, where you pay a down payment of $500 and only 0.5&percent; of your yearly net Income, but no less than 0.5&percent; of the compensation of officers plus all salaries and wages (per Schedules 1120, C, or equivalent, of the US Federal Tax Form 1040). |
||
Function Features |
Components
Advantages
|
|
Bill Of Materials enables multiple levels of production and assembly from raw materials and purchased parts through to the finished products. Routing alternatives facilitate multiple production and assembly paths, optimizing the ability for multiple Work Orders to proceed in parallel. Component cost changes are reflected in all products and sub-assemblies that contain them. Production Control updates the Inventory Control and Payroll modules. Work progress tracking includes the costs of setup, production runs, and materials, using one of three cost accounting methods. SandyV production control processes include:
|
|
SandyV lets you track products, components, and raw materials in the warehouse, as well as during shipping and receiving. Inventory quantities and production allocations monitoring, along with shortage reports facilitate timely materials and component purchasing, and production work orders. Inventory availability is visible to Sales Processing, facilitating schedueling. Pick lists speed delivery to production assembly, and aid with continuous inventory monitoring and reconciliation. Physical Inventory Counting provides for additional reconciliation. Invoicing transactions update the quantities on hand and the accounts receivable. Purchasing and Receiving transactions track the arrival of materials and components. Purchasing further updates costs and on-order quantities, and produces reports for accounts payable reconciliation with vendor invoices. SandyV uses materials and components purchase costs together with manufacturing costs to calculate the cost of finished goods, supplying information for product pricing. Inquiry and reports options identify inventory shortages, and help meet customer delivery dates. SandyV inventory control processes include:
|
|
SandyV supports multiple Product Classes, Product Groups, and multiple price lists.
Order Entry of new and change orders supports a wide variety of delivery, shipping, and payment terms. It also includes immediate verification of Vendors, Products, Sales Territory, Sales Person (for commissions), Shipping information, and Payment Terms as they are entered.
Shipping and Invoicing is tightly integrated with Accounts Receivable.
Commissions are calculated based on sales prices, quantities, product categories, and salesman commission rates, reporting them for use by Accounts Payable. Inventor or Designer Royalties can also be supported by the same mechanism.
Current manufacturing costs, facilitate price list configuration.
Month-end processing sends sales totals to the General Ledger, and produces month- and year-to-date product sales reports.
SandyV Sales processes include:
|
|
SandyV Accounts Receivable includes Customer information, Invoicing, and Cash Receipts. Accounts Receivable informs the General Ledger, and provides Aging reports. Its functions include:
Month-end processing sends Receivable totals to the General Ledger, and produces month- and year-to-date Receivables reports.
|
|
Period-end processing sends Accounts Payable totals to the General Ledger, and produces month- and year-to-date Accounts Payable reports.
|
|
SandyV provides two payroll alternatives: built-in, and Payroll Service. Both cover information on employees, pay rates, and deductions (pre and post tax); as well as departments, General Ledger association, and more. Production Control time card entry provides information to payroll, which can be augmented with Salaried Employee records, Sick and Vacation pay, and more. Payroll provides information to General Ledger (optionally after an import from a Payroll Service). Payroll processes:
|
|
SandyV tightly integrates General Ledger with Sales, Payroll, Accounts Receivable, and Accounts Payable. General Ledger reports:
|
|
During data entry, SandyV instantly flags invalid entries, and displays the descriptions of valid entries so users can prevent errors by verifying their intent. Data Entery is followed by Edit & Update procedures, and edit reports must be error-free before updates can proceed. SandyV monitors the work flow to enforce correct sequencing of operations. SandyV prevents parallel jobs from updating the same files at the same time. Two methods for conflict prevention are used: (a) opening all files before any update, thereby ascertaining their availability (absence of competing file locks), and the use of Critical Region Semaphores to further safeguard certain complex processes. When a procedure step results in an error, SandyV locks the user, and alerts them to the error and the need for recovery. This prevents data errors from adversely affecting down-stream processes, and promotes management involvement in error recovery. SandyV logs the operations of each user and each workstation (PC). These logs provide information to the technical support team, facilitating rapid and comprehensive error recovery, as well as a management tool for training to avoid the most common errors.
|
|
Package directories (folders)
Package configuration files
SandyV is installed with one user authorized to administer and configure it, beginning with the Access Control List. The work and report directories are protected so that users will have access to data on a Need To Know basis. Departmental report directory can be protected using Group Permissions. SandyV logs user access requests, so unauthorized access, and unexpected access patterns can be detected. Data is secured by group protection, obscuring its path, and storing the data in structured files. Sophisticated installations can also use storage encryption and system-level Access Control Lists to further protect data files. Accounting (e.g., cost method) and reporting parameters can be modified. Report printing defaults can be modified by users using the ME procedure. When using GNU tools, no special Server / Run-Time license is required for concurrent users. |
One function of the procedure execution shell is to protect Updates from user-interruption. This was done by removing the "System Menu" and Close button ([X]). The facility prompts the user for a Procedure Name by displaying its execution environment (Development, Test, or Production). This can help users who regularly use a test environment to test processing scenarios (to avoid errors, or figure out the order of processing for an error recovery). To request help, start by typing the command /HELP. Help screens list the available data entry and procedures, briefly explaining their purposes. Procedures verify user access rights, and prompt for information such as dates, print options, and re-start step numbers (for process recovery). When a multi-step procedure fails, it logs its point and cause of failure, informs the user with an error prompt, and locks the user until a manager (or technical support adminstrator) takes corrective action and unlocks the user. |
|
The data entry facility provides access to indexed data. It is invoked by typing 'DE' at the Procedure Execution Shell prompt, and pressing <ENTER>.
Recalling the last Data Entry form used, it prompts the user for a Form Name and access
mode (defaulting to 'I'=Inquiry Only), verifies Access Permissions, opens files,
displays an initial screen, and prompts the user for an Action. Actions (Data Entry operations)
Function keys
Sample ScreenMany of the data entry screens provide instantaneous lookups, reducing error rates by showing the user the description associated with a code or a foreign key entered. For example, after entering a part number, tabbing into the next field, the part description appears on the screen. The same holds for customers, vendors, employees, shipping codes, Bill Of Materials components, etc. Entering their number or code results in instantaneous display. In the screen below, the last key stroke was a TAB to move to the next field. The fields circled in red, top down, left to right, are:
 |
|
Affordable
Deliverables
Support & Customization Beyond these 20 hours, we can negotiate specific projects. To give you an idea, the rate I charged per hour before I retired was $300. |
|
SandyV is unique in being future proof. It is written in a mature, standardized language, relying on mature standardize and stable features of the language, rather than fancy vendor extenstions that may or may not be portable. It is available on most computing platforms by means of an Opne source GNU compiler. Currently running on Windows 11 and Windows Server, it can be readily ported to Mac, Linux, and UNIX. At the conclusion of our 7 year arrangement, you will own a copy of the SandyV sources, to use and enhance as you see fit. |
|
In September 2006, a small California manufacturing company producing medical research instruments contacted J&C Migrations, a smaller software migration specialty company in Massachusetts. In spite of thorough surge protection, their TI-99, installed in 1982, was failing due to weather events. The manufacturer wanted a critical software application, supporting their Engineering, Production, Inventory, Sales, and Accounting departments, ported to a Windows Server. Off-the-shelf Manufacturing and Production Control ("ERP" and "MRP") packages did not support the complex, multi-layered Bill of Materials their package had, and integration with Accounting packages such as Peachtree or QuickBooks wouldn't reach the level of integration they wanted to replace. The current application was being supported by Sandra Villarreal ("Sandy"), who had led the creation of the software at a long time defunct company. Sandy had been urging them for several years to move onto modern computers. They had been searching. Fortunately an uninvolved friend of the manufacturer's Comptroller suggested conversion. There was no copyright on the software, so there were no Intellectual Property barriers to conversion. The application, consisting of a quarter million lines of code, was written in four different computer languages, and only the least used, COBOL, was supported on the target platform. The manufacturer approached Micro Focus regarding the conversion, and after examining their sources Micro Focus found the most common language was RPGII, and suggested contacting J&C Migrations, with whom Micro Focus had worked before. The first challend for J&C Migrations was identification of user acceptance criteria. Conversion requirements included training the manufacturer's team in the creation of test scenarios, writing cross-compilers to translate all program sources into COBOL, addressing user interface key-stroke compatibility to minimize data entry error rates and re-training, design of target platform data organization and security, spooling and printing support, and data transfer (flattening record and file structures, transmission, record reconstitution, and indexing). After being the technical contact and domain expert, but before the conclusion of the conversion, Sandy died of bone cancer. J&C Migrations assumed the responsibility of ongoing support on the TI-99, as well as the completion of the conversion. The project, including successful application port, deployment, and testing, took 14 months. In the subsequent four months the manufacturer went through their Fiscal Year End and the Calendar Year End successfully, and retired the TI-99. At the conclusion of the conversion, J&C Migrations sought and received permission from the manufacturer to resell the application. J&C Migrations is dedicating this application to the memory of Sandy Villareal who led its creation, and for whom its support had been a labor of love. To arrange for a demo, please use our Contact form and in the text box, mention your computing environment (Windows, Linux, etc.) |