SmartLink
Integration of Scales to Accounting
SmartLink offers the following benefits:
- Interface scales to any Accounting System
- Transfers data to and from Accounting
- Change rules at any time
- Transfer data as often as you want
- Can be used by your own IT Department
What’s the problem?
- Accounting systems are complex and many are legacy systems. Customers therefore rely on CompuWeigh to provide all the flexibility necessary to provide the interface from the scale systems into accounting.
- Every accounting system is different and even customers using the same accounting system use them differently.
Interfacing to Accounting Systems like Agris
Let’s work through the steps for setting up an Agris V9 customer.
- Select the Agris V9 interface from the list of available interfaces.
- This will automatically show the Agris fields in see columns 2 & 3.
- The corresponding fields in GMS are shown. These can easily be changed. One very common change is the Location Code, which changes from one facility to another.
- Formulas can be applied to the GMS data.
- The data can then be reformatted to exactly match Agris. For example, the data can be trimmed or filled with leading zeros or given a fixed field position as required for Agris Accounting.
- The last column shows a how the data will look, to ensure that the data has been correctly converted.
Obtaining more Detailed Information
When this has been done, press the Report button at the bottom of the screen and you will receive a report like the one on the right. This is a useful tool to make another check that the data is being formatted the way you are expecting.
Programmers can press the View Code button to view the actual code that is automatically generated to create the input file to Agris. For the rest of us, we can skip to the final step below.
The final step is to press Test File and this will write the data to the file that will be imported into Agris Accounting. Duplicate and incorrect data will be flagged by Agris. If there is a problem, make the change, recreate the file and re-submit. That’s all there is to it. Should Agris make a change to their layout in the future, simply reload the file, make the change and re-save the file.
Importing Data from the Accounting System into GMS
Customer, Split Account and Contract information can all be imported into GMS from Accounting. To the right are examples of the fields that can be imported into GMS.
Customer Information
| Field Name | Caption |
| ACC_PK | Primary Key |
| ACC_CODE | Code |
| ACC_FIRSTNAME | First Name |
| ACC_LASTNAME | Last Name |
| ACC_ADDRESS1 | Address Line 1 |
| ACC_ADDRESS2 | Address Line 2 |
| ACC_CITY | City |
| ACC_STATE | State |
| ACC_ZIP | Zip Code |
Contract Information – partial
| Field Name | Caption |
| CNT_PK | Primary Key |
| CNT_CODE | Code |
| CNT_ACCFK | Account Code |
| CNT_PRDFK | Product Code |
| CNT_WEIGHT | Weight |
| CNT_STARTDATE | Start Date |
| CNT_STOPDATE | Stop Date |
| CNT_PRICE | Price |
| CNT_DELIVERED | Delivered Weight |
Once the data is in GMS, it is treated just like any other GMS data so that it can be displayed on the screen, used in calculations, printed in reports and of course sent back to accounting at the end of each completed transaction.