Chapter 7_NEW South Dakota Lien Holder Import - CINCH 18.55

South Dakota lien holder details can now be imported via the Lien Holder Import window. (CIN-6250)
This chapter contains the following sections:

• Changes to Lien Holder Import

Changes to Lien Holder Import
The state of South Dakota (SD) has been added to the Lien Holder Import window.

1. Open the Lien Holder Import window

(Microsoft Dynamics GP >> Routines >> CINCH Grain >> Lien Holder Import)

1. State - Select SD from the State drop down list.

2. File to Import - Select a SD file to import

   1. South Dakota – Provides a comma delimited (.txt) file.

3. Item X-Ref Type – Required field to Read the SD import file. This field links the lien items being imported to CINCH/Intellego items. The FARM_CODE_PRODUCT field holds the Item X-Ref #.

4. Vendor X-Ref Type field is disabled

5. Expiration Date field – disabled, SD import file contains the Start and End dates for each line.

   1. If the start date is empty the user date will be used.

   2. If the expiration date is empty 12/31/9999 will be used.

6. Read File Button,

   parses the lien file and display liens for given data in the import file.

   1. SD import file will validate Vendor's Social Security Numbers.

7. Missing Items - enabled only when lien items are not cross referenced.

8. Scrolling lines - When the system is done reading the lien file, the scrolling window will display the liens for the Vendors.

9. Existing lien records for Vendors will also be displayed with the imported liens. The Imported checkbox will be unchecked for existing lien records.

10. Any existing lien records that have been previously imported and have an expiration date less than the current user date will be displayed and marked to delete.

11. Any existing lien that has been manually entered and has an expiration date less than the current user date will be displayed and marked to delete.

12. The Vendor field will display the CINCH Vendor name to which the lien is against.

13. The SSN field will display the Social Security Number of the CINCH Vendor. 

14. The Item Number field will display the CINCH Item that a lien is against based on the Item X-Ref Type.

15. The Fed ID field will display blank as there is no data in the imported file.

16. The All column checkbox will be marked if the imported lien is for All Crops. An Item X-Ref is not needed if All Crops is listed for a lien.

17. Start Date will be populated if a lien start date exists in the lien file. The start date will also be displayed for existing liens.

18. End Date will display the lien end date found in the lien file.

19. Lienholder Name will display where the lien is held.

20. The Imported column checkbox will be marked if the lien has been imported and will be un-marked if the lien has been entered manually.

21. The Delete column checkbox will be marked on liens that previously exist for a crop and state being imported. Users can check or uncheck the box manually. This allows user the ability to prevent an imported lien from being processed or an existing lien from being deleted during processing. 

22. The UCC Filing Number column will display blank.

23. The Dup column will display a "?" if multiple CINCH Vendors have the same SSN # in the Vendor Extensions Maintenance records

    .

24. Click the Process button to finish the import of new liens and deletion of any liens marked for deletion. The Imported liens will now exist in the Vendor Extensions Maintenance records for the CINCH Vendors.