Farmers Co-Op Society (FCS) integration

The Farmer’s Co-op Society (FCS) integration allows FCS clients to track accounts receivable when Paladin is their point of sale.

 In Paladin, FCS clients can manually generate a daily export file of all invoices to upload. FCS clients can manually browse to a customer update file and process it to add new customers and update existing customers.

This article provides instruction and information on the following:

• Set up the FCS integration
• Import customer data
• Export invoices

Important: As per FSC request, Subclass 2 is used as the part number.

Set up the FCS integration

1. In Paladin, from the main menu, select File > Setup.
2. Select the ExternalSync tab.
3. In the External Sync Configuration pane, select FCS from the Select Type list.
4. In the FCS pane, check FCS Enabled.
5. Click Save, then click Close.

Note: FCS does not allow multiple tenders/split payments involving store credit. If this is done, accounts receivable will be incorrect in Control Sys.

Back to Top

Import customer data

1. In Paladin, from the top menu, select Maintain > Data Viewer.
2. In the Data Viewer window, select the Customers tab.
3. Select the Import tab, and from the File Type list select FCS.
4. Click Browse to find your customer update file (PTSTMT006.IBM)
5. Click Import.
6. A taskbar at the bottom of the window runs giving the status of the import.
7. When import is complete, the Information pane shows that the import/saving of customer data is Done. On the bottom of the window, a message states Import Complete.

Figure 1: Import Complete message

Note: If the file/data doesn’t match the specs, the Customer Import window opens with a message stating Data in this file does not correspond to the published standard for this file type or contains data that is not allowed.

Figure 2: Customer Import window/File Validation Failed message

Back to Top

Export invoices

1. In Paladin, from the top menu, select Maintain > Data Viewer.
2. Select the Invoices tab.
3. Select the Export tab.
4. From the Export File Template list, select FCS.
5. Select a Beginning and End date.
6. Click Export.
7. In your browser, navigate to the location to save the file.
   Note: The file name is PTSTMT006.IBM
8. Click Save.
9. In the Progress pane of the Data Viewer window, the upper box provides the message Writing data to file. The lower window runs giving the status of the export.
10. When complete, the Progress pane clears.

Figure 3: Paladin Data Viewer window/Progress complete/Pane cleared

Notes:

• Returns have trans type ‘R’. 
• Negative amounts have trans type ‘M’.
• Negative signs are no longer included in the file.
• Paid on account descriptions say ‘PAID ON ACCOUNT’.
• Per FCS, the export file position 72-81 will now export the “PO Number” of the invoice.

Back to Top