Introduction

What’s New is your guide to enhancements in CINCH Software.

 

We add enhancements based on feedback we receive from customers, as well as on market research. Your willingness to help us build better products makes this a more complete solution, putting you in a better position to manage your organization successfully. We encourage you to share your thoughts and reactions with us at any time.

Some enhancements described in this documentation are optional. If you currently have a license for one of these modules and have an active enhancement program, you will automatically receive the enhancements contained in that module.

 

This document describes enhancements that were added to the CINCH Software since General Release 18.56 M2.

 

Descriptions of the enhancements are divided into the following chapters:

 

Chapter 1, “CINCH Document exchange” describes miscellaneous enhancements made to CINCHX.

 

Chapter 2, “CINCH Grain Miscellaneous” describes miscellaneous enhancements made to CINCH Grain.

 

Chapter 3, “CINCH Sales miscellaneous” describes miscellaneous enhancements made to CINCH Sales.

 

Chapter 4, “NEW Savings and Loan” describes miscellaneous enhancements made to CINCH Savings and Loan.

 

Chapter 5, “NEW CSS Contract Number” describes enhancements made to Credit Sales Separation (CSS).

 

Chapter 6, “NEW Bulk Transfer Void/Reverse” describes enhancements made to the bulk transfer process.

 

Chapter 7, “NEW Document Utility – Reverse Posted Shipment” describes enhancements made to Document Utility. Posted sales shipments can now be reversed.

 

Chapter 8, “NEW Document Utility – Void Prepay Cash Receipts” describes enhancements made to Document Utility. Posted Prepay Cash Receipts can now be voided.

 

Chapter 9, “NEW Future Exchange Fee” describes enhancements made to trades.

 

Chapter 10, " NEW Install Procedures” describes enhancements made to the installation process of CINCH.

 

Chapter 11, “NEW Mass Updates” describes two mass update enhancements made to sales load orders and shipments.

 

Chapter 12, “NEW Purchase Load Orders – Update GP’s On Order Totals” describes enhancements made to Dynamics GP windows to include Purchase Load Orders within the On Order field totals.

 

Chapter 13, “NEW Sales Shipment Invoicing SmartList” describes a SmartList which has been built and is available to our customers to use that will show Sales Shipment Invoicing History by Shipment Number.

 

Chapter 14, “NEW Safe Pay – On/Off Switches” describes enhancements made to Safe Pay.

 

Chapter 15, “NEW Split Code Validations” describes enhancements made to Split IDs

.

 

 

 

 

 

 

Supported Version

The following is a list of the Dynamics GP version we will be supporting for this release.

 

Dynamics GP

Software Version: 18.5.1635 (2022)

KB4602597 (Jan Hot Fix)

Dex Version: (18.00.0028)

 

AgWorks

Is currently not supported.

 

Feed Mill Manager

Is currently not supported.

 

Chapter 1: CINCH Document Exchange

This chapter describes miscellaneous enhancements made to CINCHX.

 

This chapter contains the following sections:

 

Changes to Document Monitoring

Changes to AgXML 4.0 Purchase Load Import/Export

 

Changes to Document Monitoring

The Document Monitoring window has been updated to automatically mark the Services checkbox upon opening the window to display only the services with recent transactions. (CIN-5358)

 

It has also been updated to automatically delete exception messages/errors attached to the Services node. The errors will be removed based on the

History Retention (in days) field set in the CINCHX Global Settings window. The system will automatically review the transactions within the IRDXDocXDocAutidt table. If the transaction’s last modified date is prior to the Current User Date minus the History Retention (in days), the system will delete it. Deletions will happen in batches of 1000 if thousands of records need to be deleted upon the initial installation of this fix. (CIN-6858)

 

Changes to

AgXML 4.0 Purchase Load Import/Export

Farm and Field information, attached to purchase loads will now export and import with the use of AgXML 4.0 Purchase Load Export/Import. (CIN-6839)

 

• AgXML 4.0 Purchase Load Export. Two new fields have been added.

  • <IRFarmCode>0</IRFarmCode>

  • <IRFieldCode>0</IRFieldCode>

• AgXML 4.0 Purchase Load Import. The import file will validate and fail when invalid Farm and Field information is passed.

Chapter 2: CINCH Grain Miscellaneous

This chapter describes miscellaneous enhancements made to CINCH Grain.

 

This chapter contains the following sections:

 

Changes to Assembly Entry and Assembly Inquiry Zoom

Changes to Bulk Shipment Invoicing

Changes to Bulk Transfer Inquiry

Changes to Purchase Contract Entry

Changes to Purchase Contract Overrun

Changes to Purchase Load Entry

Changes to Spot Contracts

 

Changes to Assembly Entry and Assembly Inquiry Zoom

A new field called Priced Qty has been added to Assembly Entry and Assembly Inquiry Zoom windows within the Contract Qtys section. (CIN-5784)

 

Open Assembly Entry and Assembly Inquiry Zoom

Priced Qty

displays the quantity that has been priced on the assigned contract.

Changes to Bulk Shipment Invoicing

Load Number has been added to the Range dropdown in the Bulk Shipment Invoicing window. (CIN-6522)

 

Open the Bulk Shipment Entry window.

1. Range

   1. Load Number allows the user to filter the shipments that will appear in the scrolling window to only posted shipments assigned to load numbers. When selected, the From and To lookups will open the Load Order Open Lookup window. This window displays only posted shipments assigned to load numbers.

 

Changes to Bulk Transfer Inquiry

Bulk Transfer Inquiry’s Excel Export has been updated to include additional columns. (CIN-4503)

 

Open Bulk Transfer Inquiry

1. Additional Excel Export columns:

   1. Orig Gross Wt displays the origination gross weight.

   2. Orig Tare Wt displays the origination tare weight.

   3. Dest Gross Wt displays the destination gross weight.

   4. Dest Tare Wt displays the destination tare weight.

   5. Orig Gross Qty displays origination gross quantity.

   6. Orig Adj Qty displays origination adjusted quantity.

   7. Orig Net Qty displays origination net quantity.

   8. Dest Gross Qty displays destination gross quantity.

   9. Dest Adj Qty displays destination adjusted quantity.

   10. Dest Net Qty displays destination net quantity.

   11. Void Reason displays the Reason Code if the transaction has been voided.

   12. Void indicates if the transaction has been voided.

   13. Void User indicates the User ID that voided the transaction.

   14. Void Date indicates the date the transaction was voided.

   15. Void Time indicates the time the transaction was voided.

   16. Reversal Of indicates the Bulk Transfer Number that was reversed.

   17. User Defined Header 1

   18. User Defined Header 2

   19. User Defined Line 1

   20. User Defined Line 2

   21. Use Weights/Grades From indicates where the origination or the destination weights will govern the transfer.

   22. Origination Posted display TRUE if the origination weights and grades have been posted and FALSE if they have not been posted.

   23. Destination Posted display TRUE if the destination weights and grades have been posted and FALSE if they have not been posted.

 

Changes to Invoice Grain Charges Entry

The Invoice Grain Changes Entry window has been updated with the ability to restrict the assemblies that appear in the scrolling window by disposition type. (CIN-3504)

 

Open Invoice Grain Charges Entry window.

1. Include Disposition Types:

   1. Purchase

   2. Storage

   3. Grain Bank

2. Scrolling window fields that have been added are:

   1. Disposition Type displays the disposition type for the Disposition ID attached to the assembly.

   2. Disposition ID displays the disposition ID attached to the assembly.

 

Changes to Purchase Contract Entry

The copy function has been added to the Purchase Contract Entry window. (CIN-6320)

 

Open the Purchase Contract Entry

1. Choose Copy to copy data from an existing Purchase Contract to a new Purchase Contract.

   1. The Copy button becomes enabled once the Contract Number has been validated as New and remains active until the contract delivery information is entered.

   2. Selecting the Copy button opens the Contract Lookup window allowing user to select the contract to copy from. Once the copy from Contract has been selected the contract header information will be copied from the selected Purchase Contract and can be edited.

   3. If the General Setup setting Cross Customer Purchase Contract is set to Allow Related, the Related Partners will also be copied.

Changes to Purchase Contract Overrun

A new sort option has been added to the scrolling window of the Purchase Contract Overrun window. The Beg Del Date (Beginning Delivery Date) field can now be sorted. (CIN-4116)

 

 

Changes to Purchase Load Entry

The Purchase Load Entry window has been enhanced with two new features. First, the Contract Number lookup now opens the Contract Lookup window instead of the Purchase Contract Lookup window (CIN-6809). Second, two new fields have been added, farm and field. (CIN-6810)

 

Open Purchase Load Order Entry

1. Contract Lookup button opens the Contract Lookup window.

2. Farm, enter or select a farm from which this item originated. Values can default from Load Generator or an assigned contract but can be updated. The information in this field will then default into Inbound Scale Ticket Entry when the load is assigned to a ticket.

3. Field, enter or select a field that corresponds to the farm in which the item originated. Values can default from Load Generator or an assigned contract but can be updated. The information in this field will then default into Inbound Scale Ticket Entry when the load is assigned to a ticket.

Changes to Purchase Load Generator

The Purchase Load Generator window has been updated with two new fields: farm, and field. (CIN-6810)

 

Open Purchase Load Generator

1. Farm, enter or select a farm from which this item originated. The field value may default from the assigned contract, but it can be updated.

2. Field, enter or select a field that corresponds to the farm in which the item originated. The field value may default from the assigned contract, but it can be updated.

Changes to Purchase Load Inquiry

A new range option called Site and a new Include option called History has been added to the Purchase Load Inquiry window. (CIN-5503)

 

Open Purchase Load Order Inquiry

1. Range: Site, will restrict the search by Site ID.

2. Include: History, defaults marked and will display all historical purchase load details based on the given range.

 

Changes to Purchase Load Inquiry Zoom

The Purchase Load Inquiry Zoom has been updated with two new fields: farm, and field. (CIN-6810)

 

Open Purchase Load Inquiry Zoom

1. Farm displays the farm from which this item originated.

2. Field displays the field that corresponds to the farm in which the item originated.

 

 

Changes to Settlement Inquiry Zoom

A new remittance report (IRGNSettlementRemittance) has been added to the Settlement Inquiry Zoom print options to provide additional details for settlements. Also, the settlement sheet history report (

IRGNSettlementSheetHist) has been updated to reflect the check and voucher numbers used for split settlement transactions. (CIN-5328)

 

Notes:

• Remittance Report

  • Only available for posted, voided, and unpaid settlements.

  • Displays data related to the Settlement.

    • Applied From

      • Vendor ID

      • Voucher #/Description

      • Type (PMT, RET, CRM, DBM)

      • Document #

      • Date

    • Applied To

      • Voucher #/Description

      • Type (INV)

      • Document #

• Settlement Sheet History Report

  • The voucher and check number(s) will only display on the settlement sheet history report for split settlements.

  • Debit/Credit Memos and Returns will not be displayed.

  • Currently displays up to four vouchers/checks but can support up to twenty. Twenty IRVoucherNumber & IRCheckNumber Array fields have been added to table IRGNSettlementSplitRpt.

 

Changes to Spot Contracts

Spot Contracts created by an Inbound Scale Ticket overrun will now assign the Ship From Address ID from the Ticket. If the Ship From Address ID is blank on the Ticket, then it will assign it from Vendor Maintenance. The Remit To Address ID will default from Vendor Maintenance.

Spot Contracts created “On the Fly” will assign both the Ship From & Remit To Address IDs from Vendor Maintenance. (CIN-5262)

 

Changes to Unit Train In Import Addin

The Unit Train In Import uses a Microsoft Excel file and an OLE DB connection to import transactions. In this release, the OLE DB connection has been updated from version 2010 to 2016. (CIN-5410)

 

Steps to follow if you are using the outdated version:

1. Uninstall the previous version of Access Database Engine and CINCH/Intellego Unit Train Import.

2. Install the latest 2016 Access database engine from below location:
   https://www.microsoft.com/en-us/download/details.aspx?id=54920

   1. Install the latest CINCH/Intellego Unit Train Import.

   2. Login to GP and import the Unit train excel without any errors.

 

Changes to Vendor Extensions Maintenance

The Vendor Extensions Maintenance window has been updated with a Split field. (CIN-6648)

Open Vendor Extensions Maintenance

1. Split, enter or select a Split ID for the vendor.

   1. The Split ID will default to the following windows but can be changed.

      1. Inbound Scale Ticket Entry

      2. Purchase Load Order Entry, the contract number field will be locked when the Split ID is entered/defaulted (existing functionality).

      3. Purchase Load Generator

   2. If a vendor assigned to the Split ID is on hold, a warning will be displayed asking the user if they would like to continue with the ID.

 

Chapter 3: CINCH Sales Miscellaneous

This chapter describes miscellaneous enhancements made to CINCH Sales.

 

This chapter contains the following sections:

 

Changes to Customer Extension Maintenance

Changes to General Setup

Changes to Sales Setup

Changes to Customer Extensions Maintenance

A new setup option called Print/Email Shipments BOL(s) with Invoice has been added to the Customer Extensions Maintenance window. (CIN-7238)

Open Customer Extensions Maintenance

1. Print/Email BOL(s) with Invoice checkbox is existing functionality but will work in conjunction with the Print/Email Shipments BOL with Invoice checkbox. Only one checkbox can be checked at any given time. A tool tip has been added to indicate the form that will be printed (IRCSBOLBlankSales).

2. Print/Email Shipments BOL(s) with Invoice. Checkbox works in conjunction with the Print/Email BOL with Invoice checkbox. Only one checkbox can be checked at any given time.

   1. Unchecked, any time an invoice is printed or emailed only an invoice will be printed/emailed.

   2. Checked, any time an invoice is printed or emailed, the system will print a BOL for each shipment attached to the invoice if the shipped item is an inventoried item. Service items will not print a BOL. A tool tip has been added to indicate the form that will be printed (IRCSBOLBlank).

Changes to General Setup

General Setup’s Sales Contract User Defined window has been updated with sales weights/grades to govern defaults, which will default into Sales Contract Entry. (CIN-6236)

Open General Setup’s User Defined window

1. Sales Wt Default:

2. Select from the drop-down list one of the manually entered Weights To Govern IDs for Sales. If no Weights to Govern ID’s have been manually setup, Origination and Destination are available for selection.

3. Drilling into the Sales Wt Default field will open the Weights to Govern Maintenance – Sales window once a selection has been made.

4. The selected value will default to the Weight field within the Sales Contract Entry window.

5. Sales Grade Default:

6. Select from the drop-down list one of the manually entered Grades To Govern IDs for Sales. If no Grades to Govern ID’s have been manually setup, Origination and Destination are available for selection.

7. Drilling into the Sales Grade Default field will open the Grades to Govern Maintenance – Sales window once a selection has been made.

8. The selected value will default into the Grades field within the Sales Contract Entry window.

Changes to Sales Setup

The No Edit Print Doc checkbox has now been added to the Order Entry section of the Sales Setup window. (CIN-5831)

Open Sales Setup

1. No Edit Printed Doc (Order Entry Section).

2. Unchecked – Existing functionality, User can edit a Printed Sales Order.

3. Checked – Orders will not be editable after printing either the Packing Slip (SOP Blank Packing Slip Form), Picking Ticket (SOP Blank Picking Ticket Form) or Receipt (IRSOPBlankOrderForm).

Chapter 4: CINCH Savings and Loan

This chapter describes miscellaneous enhancements made to CINCH Savings and Loan.

 

This chapter contains the following sections:

 

Changes to Accounts List by Vendor Report

Changes to Savings Statements

Changes to Accounts List by Vendor Report

The Accounts List by Vendor Report has been updated to include totals by Vendor for both the Current Bal and Accrued Interest columns. Plus, a Maturity Date Report Writer function has been created that can be used for savings or loans. (CIN-6554)

 

Print the Accounts List by Vendor Report

1. Added totals by Vendor for both the Current Bal and Accrued Interest columns.

2. Added a Maturity Date Report Writer Function (rw_AccountMaturityDt). The Maturity Date is the Maturity Date assigned to the account within Savings Account Maintenance or Loan Account Maintenance. The parameters for the function are:

   1. Result Type: Date

   2. Expression Type: Calculated

   3. Functions: Is User-Defined and Function equals rw_AccountMaturityDt.

   4. Fields: Resources equals IRSPAccountsListTEMP and Field equals Account Number.

   5. Constants: Type equals Integer and Constant equals one (1), which is Savings.

 

Changes to Savings Statements

Add Maturity Date and total to CINCH Savings Statement. (CIN-6554)

 

Open Savings Statements

Added Maturity Date to the report. The Maturity Date is the Maturity Date assigned to the account within Savings Account Maintenance.

 

Chapter 5: NEW CSS Contract Number

This chapter describes enhancements made to Credit Sales Separation (CSS). Users can now assign an additional contract number for Credit Sales Separation (CSS) Contract types

(Basis, Priced Later, Minimum Price, and Other). (CIN-7033)

 

This chapter contains the following sections:

 

Changes to Purchase Contract Entry

Changes to Purchase Contract Amendment Entry

Changes to Purchase Contract Inquiry Zoom

Changes to Purchase Contract Version Inquiry

Changes to Purchase Contract Entry

The CSS Contract Number field and expansion button has been added to Purchase Contract Entry’s Additional Information window.

 

Open Purchase Contract Entry

1. CSS Contract Number

   1. Credit Sales Separation must be turned on to use this field and then only CSS Contract Types (Basis, Priced Later, Minimum Price, and Other) will have access.

   2. Field is disabled by default and displays the number set in the CSS Number Details window.

   3. The expansion button opens the CSS Number Details window allowing the user to set up a CSS Contract Number.

1. CSS Contract Prefix, enter the CSS Contract Number Prefix.

2. CSS Contract Number Segment will default but may be changed if necessary. This number will increase by one each time the same CSS Contract Prefix is used.

3. CSS Contract Number is display only and will be the CSS Contract Prefix + the CSS Contract Numeric Segment.

4. OK button saves changes and closes the window.

Note: The CSS number is stored in the IRGNCSSCtrKeyMSTR table. The table will only store the numbers which are used. If the user deletes the contract or changes the CSS Contract Number, then the previously used CSS Contract Number will be removed from the table.

Changes to Purchase Contract Amendment Entry

The CSS Contract number can also be entered using Purchase Contract Amendment Entry’s Additional Information window and the change will be tracked.

Changes to Purchase Contract Inquiry Zoom

The CSS Contract Number assigned to the CSS Contract Types will be displayed within the Purchase Contract Inquiry Zoom’s Additional Information window.

Changes to Purchase Contract Version Inquiry

The CSS Contract Number assigned to the CSS Contract Types will be displayed within the Purchase Contract Version Inquiry’s Additional Information window.

Chapter 6: NEW Bulk Transfer Void/Reverse

This chapter describes enhancements made to the bulk transfer process. Users can now void a partially posted or reverse a fully posted bulk transfer. (CIN-2069)

 

This chapter contains the following sections:

 

Changes to Bulk Transfer Entry

Changes to Bulk Transfer Inquiry

Changes to Bulk Transfer Inquiry Zoom

Changes to Bulk Transfer Entry

Bulk Transfer Entry can either void/reverse a partially posted bulk transfer or reverse a fully posted bulk transfer.

 

Open Bulk Transfer Entry

1. Delete/Void button appears depending on the posting status of the transaction.

   1. Delete allows a user to delete an unposted bulk transfer.

   2. Void allows a user to void/reverse a partially posted bulk transfer.

      1. Upon selection, the system will pop open the Void Reason window.

      2. Enter or select a Reason ID.

      3. Select Continue to void the transfer.

      4. Select Cancel to cancel the void.

2. Reverse Posted Transaction Icon

   Open

   

   will open the Bulk Transfer Lookup window with the Display From locked to Posted. Transactions that have been fully posted will be listed and available for selection. Selecting a posted transaction will return the user to the Bulk Transfer Entry window with the transaction reversed and as a new bulk transfer.

   1. Destination Branch/Site will become the Current Branch and Origination Site.

   2. Original Destination weights will become the origination weights.

   3. Original Origination weights will become the destination weights.

   4. Original Transfer Number will be recorded in the Reversal of field.

   5. Reversal of field will display the original bulk transfer number.

3. Transfer Number visual switch/status string indicates if the transfer is “Unshipped,” “In Transit” or “Shipped” and appears between the Reverse Posted Transaction Icon and the Discounts button when a saved transaction is selected.

   1. Unshipped, saved/unposted transfer.

   2. In Transit, transfer has been moved out of the Origination Site and into the In Transit Site.

   3. Shipped, transfer has been moved out of the In Transit Site and into the Destination Site.

4. Orig Transfer Out #, indicates GP’s Item Transfer Number. It represents the transfer from the Origination Site to the In Transit Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual transfer.

5. IT Adj Out #, indicates GP’s Item Adjustment Number. It represents the adjustment out of the In Transit Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual adjustment.

6. Dest Adj In #, indicates GP’s Item Adjustment Number. It represents the adjustment into the Destination Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual adjustment.

7. Reversal of, indicates the original Transfer Number that is being reversed.

8. Clear button clears the window without saving changes.

Changes to Bulk Transfer Inquiry

Bulk Transfer Inquiry has been enhanced to display transfers that are Unshipped, In Transit, Shipped, Voided or All.

 

Open Bulk Transfer Inquiry

1. Include:

   1. Unshipped, displays all saved bulk transfers.

   2. In Transit, displays all partially posted bulk transfers.

   3. Shipped, displays all posted bulk transfers.

   4. Voided, displays all voided bulk transfers.

   5. All displays all bulk transfers.

2. Scrolling window has had the following fields added.

   1. Reversal of, indicates the original Transfer Number if the transfer was reversed.

   2. Void indicates whether the transfer was voided.

   3. Void User indicates the username that voided the transfer.

   4. Void Date indicates the date the transfer was voided.

   5. Void Time indicates the time the transfer was voided.

   6. Orig Gross Qty displays the origination weight’s Gross Quantity.

   7. Orig Adjust Qty displays the origination weight’s Adjusted Quantity.

   8. Orig Net Qty displays the origination weight’s Net Quantity.

   9. Dest Adjust Qty displays the destination weight’s Adjusted Quantity.

   10. Dest Net Qty

       displays the destination weight’s Net Quantity.

3. The Export to Excel report has also been updated with the above fields.

Changes to Bulk Transfer Inquiry Zoom

Bulk Transfer Inquiry Zoom has been enhanced to reflect the new void/reversal process.

 

Open Bulk Transfer Inquiry Zoom

1. Reversal of, indicates the original Transfer Number that is being reversed.

2. Void Reason indicates the reason code for the void.

3. Void User indicates the username that voided the transfer.

4. Void Date indicates the date the transfer was voided.

5. Void Time indicates the time the transfer was voided.

6. Orig Transfer Out #, indicates GP’s Item Transfer Number. It represents the transfer from the Origination Site to the In Transit Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual transfer.

7. IT Adj Out #, indicates GP’s Item Adjustment Number. It represents the adjustment out of the In Transit Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual adjustment.

8. Dest Adj In #, indicates GP’s Item Adjustment Number. It represents the adjustment into the Destination Site. The drill down on the field will open the Inventory Transaction Inquiry window displaying the actual adjustment.

 

Chapter 7: NEW Document Utility – Reverse Posted Shipment

This chapter describes enhancements made to Document Utility. Posted sales shipments can now be reversed. (CIN-2956)

 

This chapter contains the following sections:

 

Changes to Document Utility

Changes to Load Shipment Inquiry

Changes to Document Utility

The Document Utility window has been enhanced to allow the reversal of a posted shipment.

 

Open Document Utility window (Microsoft Dynamics GP >> Tools >> Routines >> CINCH Grain >> Document Utility)

 

1. Select the Doc Type of Shipment

2. Select the Action of Reverse

3. Select a Document Number.

   1. A shipment associated with a contract cannot be reversed or deleted. A message “A Contract has been assigned to this Shipment. It must be removed before this Shipment can be deleted/reversed.” will be displayed.

4. Enter a Batch ID. The ID is required for reversal, the reversed shipment will be assigned to it.

5. Process:

   1. A shipment

      associated with a load will reopen both the shipment and the load.

   2. The shipment will be removed from the DPR’s Uninvoiced Shipments and added to the assigned Batch ID.

Changes to Load Shipment Inquiry

The Load Shipment Inquiry window will display the shipment’s status in work rather than in open.

 

Open Document Utility window (Inquiry >> CINCH Grain >> Sales/Outbound >> Load Shipment Inquiry)

 

Status will be changed from Open to Work.

 

Chapter 8: NEW Document Utility – Void Prepay Cash Receipts

This chapter describes enhancements made to Document Utility. Posted Prepay Cash Receipts can now be voided. (CIN-6926)

 

This chapter contains the following sections:

 

Changes to Document Utility

Changes to Prepay Cash Receipts Inquiry

Changes to Prepay History Reports

Changes to Document Number Inquiry

Changes to Document Utility

The Document Utility window has been enhanced to allow posted prepay cash receipts to be voided.

 

Open Document Utility

1. Doc Type, Prepay Cash Receipt

2. Action, Void

3. Document Number, enter or select the posted prepay cash receipt number.

   1. Document number lookup will open Prepay Posted Receipt lookup window.

   2. If the number is in use by another user or has been applied to a transaction, the number cannot be selected.

4. Process

   1. Creates a journal entry with a Source Document of Prepay and a Transaction Reference of Voided Trx Maintenance.

   2. Removes the receipt from the bank deposit if the deposit has not been posted or it creates a negative receipt for the prepayment deleted if the deposit has been posted.

 

Changes to Prepay Cash Receipts Inquiry

Voided Prepay Cash Receipt will not be displayed in the Prepay Cash Receipts Inquiry window as the Voided record moves to History and the Prepay Cash Receipts Inquiry window displays only open transaction.

Changes to Prepay History Reports

Voided Prepay Cash Receipts will be displayed within the Prepay History by Customer Detail and Summary reports.

 

Changes to Document Number Inquiry

Voided Prepay Cash Receipts will be displayed for prepayments when the Voided checkbox is marked.

 

Chapter 9: NEW Future Exchange Fee

This chapter describes enhancements made to trades. Users now have the option to set up and calculate exchange fees. (CIN-2029)

 

This chapter contains the following sections:

 

Changes to Broker Maintenance

Changes to Hedge Account Maintenance

Changes to Trade Entry

Changes to Trade Maintenance

Changes to Trade Matching

Changes to Trade Options Exercise

Changes to Trade Roll

Changes to Trade Open Inquiry

Changes to Hedge Account Statement

Changes to Broker Maintenance

Open Broker Maintenance

1. Exchange Fee

   1. Has been moved from above the Commissions table and is now included within the Commissions table.

   2. Calculation and Charge Method options work in the same way as Commission and Fees.

Changes to Hedge Account Maintenance

Open Hedge Account Maintenance

Exchange Fees – Account used for Exchange Fees

when writing journal entries.

 

Changes to Trade Entry

Open Trade Entry

1. Exchange Fees, display only, indicates the exchange fee information setup in Broker Maintenance.

2. Exchange Fees checkbox

   1. Unmarked – Default setting, Exchange Fees will not be used.

   2. Marked – Exchange Fee will be used instead of Commission and Fees.

3. Trade Edit List (IRGNTradePositingJournal) has been updated to print the account information for Exchange Fees when a trade includes exchange fees.

 

Changes to Trade Maintenance

Open Trade Maintenance

1. Exchange Fees display the value related to the given trade number.

2. A voided trade with Exchange Fees will create a reversing journal with exchange fees details.

 

Changes to Trade Matching

Open Trade Matching

The Exchange Fees distribution details have been added in the Trade Distribution Posting Journal (IRGNTradePSPostingJournal).

 

Changes to Trade Options Exercise

Open Trade Options Exercise

1. An Exchange Fees field has been added to both the header and the footer.

2. The Trade Posting Journal (IRGNTradePostingJournal) report and GL Journal entry have been updated to include the account information for Exchange Fees when a trade includes exchange fees.

 

Changes to Trade Roll

Open Trade Roll

The Exchange Fees distribution details have been added in the Trade Distribution Posting Journal (IRGNTradePSPostingJournal).

 

Changes to Trade Open Inquiry

Open Trade Open Inquiry

The Exchange Fees field has been added and will reflect the exchange fee for the trade.

Changes to Hedge Account Statement

Open Hedge Account Statement

Displays the Exchange Fees details if used in Trade Entry.

 

 

 

Chapter 10: NEW Install Procedures

This chapter describes enhancements made to the installation process of CINCH. These enhancements have been placed in the Install Guide which now reflects both an Installing CINCH and an Upgrading CINCH section.

New installations and upgrades prior to 18.56 will need to follow the Installing CINCH section. (CIN-5336)

 

This chapter contains the following section:

 

Changes to SQL Maintenance

Changes to Table Utility

Changes to SQL Scripts

Changes to SQL Maintenance

Users will no longer be required to run Microsoft Dynamics’ SQL Maintenance when installing or updating CINCH/Intellego. The creation of all CINCH/Intellego tables and auto procedures are taken care of within the Table Utility window.

 

Changes to Table Utility

This window has been streamlined to aid in speeding up the upgrade process.

 

Open Table Utility

• You must be logged in as “sa” or “DYNSA” to open the Table Utility window.

• The table update process is a SINGLE USER situation. Do NOT allow one user to update one company while another user attempts to update another company. During the table update process existing data is copied from the company database to a tempdb database. If two users try to update the same tempdb at the same time the update WILL error.

Product has replaced the Product From field and scrolling window and will default with CINCH or CINCH.

1. File Series functionality has not changed but it has moved and will continue to default to Project.

2. Upgrade From

   1. Initially defaults NA (Not Applicable) but will default to the previously installed version the next time the system is updated.

• Starting with release 18.57, the system will record the installed version within the IRGNMainSETP table in the IRVersion field.

• Upon upgrade, the un-chunking process will move the installed version within the IRGNMainSETP table’s IRVersion field to the IRVersionPrev field. It is the IRVersionPrev value that will default into the Upgrade From field.

 

 

1. Drop-down will display versions starting with 18.56. The version is based on the initial release of the version which is released each December.

2. The expansion arrow, when pressed, will select all the tables changed or created between the Update From version and the version being installed. These tables will then be displayed in the Select Tables window.

1. Available Tables defaults all the tables for the Product and File Series selected.

   1. Product CINCH/Intellego and Files Series Project defaults all CINCH/Intellego tables within the Company database.

   2. Product CINCH/Intellego and Files Series System default all CINCH/Intellego tables within the Dynamics database.

2. Selected Tables displays tables either selected individually and/or selected by the Upgrade From expansion button.

1. Backfills

   1. If upgrading only one version, follow the backfill instructions indicated within the installation guide.

   2. If upgrading multiple versions, run the backfill scripts manually for each version.

2. Optional Buttons:

   1. Create CINCH/Intellego Jobs (No Changes)

   2. Create Tables (No Changes)

   3. Update Indexes – (No Changes)

Changes to SQL Scripts

The five SQL company scripts along with the SQL IRGrant script and the SQL command exec IRCSBindDefAll have been combined into one script called SQLCompanyCINCHCINCHR1857.sql.

WARNING: The SQL command “exec IRCSBindDefAll” could take up to 15 minutes to complete and is the same process that runs when using the Bind Defaults window (Microsoft Dynamics GP >> Maintenance >> CINCH Maintenance >> Bind Defaults.)

 

 

Chapter 11: NEW Mass Updates

This chapter describes two mass update enhancements made to sales load orders and shipments. (CIN-5355 & CIN-5982)

 

This chapter contains the following section:

 

Mass Load Order Update

Mass Shipment Update

Mass Load Order Update

The Mass Load Order Update window has been added to allow the ability to mass update sales load orders.

 

Open Mass Load Order Update

1. Restrictions:

2. Customer, required, select or lookup a customer. All load orders for the customer will be displayed if no other restrictions are selected.

3. Item, selecting an item will further restrict the loads for the customer selected.

4. Contract, selecting a contract will further restrict the loads for the customer selected. If a contract has Multiple Delivery Periods, then a valid delivery period is needed and can be selected from the Sales Contract Details Lookup window that will automatically open.

5. Display Only Loads with No Contracts

6. Unmarked – Display all loads with or without contracts assigned.

7. Marked – Contract field will be disabled and cleared, and the display will refresh with only the loads without contracts assigned.

8. Update indicates the information that can be updated on a load.

9. Customer PO #

10. Vehicle ID

11. Bill To

12. Ship To

    1. Locked by default and editable when a contract is selected, or the Loads with No Contract checkbox is marked.

    2. If a contract is selected, the system will validate the entered Ship To Address ID with the contract’s sub-item Ship To Address IDs and warn/stop the user if the selected Ship To Address ID does not exist on the contract.

13. FOB

14. Ship Company

15. Scrolling window includes:

16. Load Number: User can sort the loads and view the loads details using the expansion button.

17. Sch Date (Schedule Date): User can sort the loads based on Date.

18. Customer: User can view the customer details using the expansion button.

19. Ship To: User can view the address details using the expansion button.

20. Item: User can sort the loads based on Item and view the Item details using the expansion button.

21. Order Qty: User can sort the loads based on Quantity.

22. Contract: User can sort the loads based on contract and view the contract details for the selected loads using the expansion button.

23. Select All checkbox allows the user to select all the loads displayed.

24. Number of Tickets displays the total number of loads displayed for the given restrictions.

25. Process updates the selected loads with the information entered.

    1. A warning will be displayed if the updated FOB or Ship Company does not match with the selected contract delivery period and will ask the user if they would like to proceed? Yes, will update the load(s), No will not update the loads(s) and will return the user to the Mass Load Order Update window.

The system will provide a message indicating that the process was completed successfully.

1. Redisplay, when selected will update the scrolling window based on the selected restrictions.

2. Clear, will clear the window.

3. OK, closes the window without saving any changes.

Mass Shipment Update

Mass Shipment Update window has been added to assign multiple shipments to a single contract with or without overwriting freight. The same process of updating a shipment’s contract in Bulk Shipment Invoicing and Grain Shipment Invoicing is used.

 

Open Mass Shipment Update

1. Restrictions:

   1. Action, defaults to Apply Contract.

   2. Customer, required, enter or lookup a customer.

   3. Item, required, select or lookup an item.

   4. Range allows the user to filter the shipments in the scrolling window by Shipment, Ship Date, Ticket Load Number, Unit Train Number, Unit Car Number, PO Number and Contract.

   5. Include Shipments with Contracts checkbox.

      1. Unmarked, default, the scrolling window will only display shipments without a contract.

      2. Marked, the scrolling window will display shipments with and without contracts.

2. Apply To:

   1. Contract Number, required to process the update, enter or lookup a contract. Based on the Customer and Item entered, related contract number details will be displayed in Sales Contract Delivery Lookup.

      1. Shipments will be applied to the Sales Contract based on the contract item’s UOM. If the selected sub item has a different weight UOM than the Sales Contract item, the Shipment Qty will be converted to the Sales Contract item’s UOM prior to applying it to the contract.

      2. If the Shipment Item is a Sales Contract Sub Item the U of M, Price U of M, Gross Price and Ship To will be based on the selected sub item.

      3. If the Sales Contract Sub Item has a different Price U of M, Markdown, Commission Total, and Freight Total. Then the Invoice Freight will be calculated based on the Sub Item Price U of M.

      4. When a Contract is assigned, the system will validate the Customer Number on the Shipment is a Partner on the Contract when the contract is assigned. If Customer is a Related Partner, the Bill To and Ship To address codes will not be updated from the Sales Contract.

   2. Delivery Period is based on the selected contract number delivery period but can be changed.

   3. Spot

      1. Unmarked, default, selected shipments will not be assigned to a spot contract.

      2. Marked, disables the Contract Number field and selected shipments will be assigned to a spot contract. The Shipment Spot Contract Price Entry window will open once the Process button is selected allowing the user to enter spot information.

   4. Overwrite Freight

      1. Unmarked, default, shipment freight details will be retained.

      2. Marked, shipment freight details will be re-written using the assigned contract’s ship company.

3. Scrolling Window includes:

   1. Select All checkbox allows the user to select all the shipments displayed or shipments can be selected individually.

   2. Status displays only open shipment record will be displayed.

   3. Shipment displays the available shipment numbers. Use the expansion button to view shipment details for a selected shipment.

   4. Load displays the load number assigned to the shipment. Use the expansion button to view the load details for a selected shipment.

   5. Customer displays the customer ID attached to the shipment.

   6. Item displays the item ID attached to the shipment.

   7. Contract displays the contract number attached to the shipment.

   8. Ticket Number displays the shipment’s ticket number.

   9. Ship Qty displays the gross quantity shipped.

   10. Number of records displays the number of records displayed, not selected, in the scrolling window.

4. Process updates the selected shipment(s) with the Apply To information or it creates and attaches a spot contract if the Spot checkbox is selected.

   1. Once complete the system will provide a message indicating that the process was completed successfully.

   2. Contracts will automatically overrun when the total ship quantity is more than the remaining quantity on the contract.

   3. A shipment’s discount schedules will not be automatically updated to the assigned contract’s discount schedule. A warning will display indicating that the user must manually update the shipment(s).

5. Clear will clear the window without processing selected shipments.

6. Redisplay will update the scrolling window with shipments based on the selected restrictions.

Chapter 12: NEW Purchase Load Orders – Update GP’s On Order Totals

This chapter describes enhancements made to Dynamics GP windows to include Purchase Load Orders within the On Order field totals. (CIN-5503)

 

This chapter contains the following sections:

 

Changes to General Setup

Changes to GP Windows

Changes to General Setup

The General Setup window has been enhanced to

allow purchase loads orders to be added/subtracted to/from GP’s On Order field totals.

 

General Setup

1. Add Open Purchase Loads to On Order Qty

   1. Unmarked, purchase load orders will not have an impact on GP’s On Order field totals.

   2. Marked, purchase load orders will be added/subtract to/from GP’s On Order field totals within the following windows:

      1. Item Inquiry

      2. Item Quantities Maintenance

      3. Item Stock Inquiry

      4. Item Vendor Maintenance

 

Changes to GP Windows

The On Order field totals within the Item Inquiry, Item Quantities Maintenance, Item Stock Inquiry, and Item Vendors Maintenance windows will include CINCH Purchase Load Order information if the Add Purchase Load to On Order Qty checkbox is checked in General Setup.

 

Purchase Load Orders will be added or subtracted to the On Order field based on the following:

 

1. On Order will be increased when a Purchase Load Order is saved.

2. On Order will be decreased when a Purchase Load Order is deleted/voided.

3. On Order will be decreased when an Inbound Scale Ticket is assigned to a Purchase Load Order and the ticket is posted.

 

Drilling down on the On Order field within the Item Inquiry or Item Quantities Maintenance windows will open two inquiry windows.

 

1. GP’s Purchase Order Processing Item Inquiry

2. CINCH’s Purchase Load Inquiry

 

Chapter 13: NEW Sales Shipment Invoicing SmartList

This chapter describes a SmartList which has been built and is available to our customers to use that will show Sales Shipment Invoicing History by Shipment Number. (CIN-6811)

 

1. IR_SalesShiInvHist_B.xml

2. IR_SalesShiInvHist_D.xml

 

Users will import one of the above files within SmartList based on the SmartList install (B = Builder and D = Designer). Please contact support to obtain a copy of this SmartList.

Note: This file has been setup for CINCH, if CINCH users would like to use this file, open the file in Note Pad and replace “4087” with “3369”.CH

 

Chapter 14: NEW Safe Pay – On/Off Switches

This chapter describes enhancements made to Safe Pay. An on/off switches has been added to control lienholder information from being

sent within Safe Pay files. (CIN-7059)

 

This chapter contains the following sections:

 

Changes to General Setup

NEW Checkbook Extensions Maintenance

Changes to General Setup

A master on/off switch has been added to General Setup.

 

Open General Setup

1. Defaults Section

   1. Enable Safe Pay Integration

      1. Marked – Allows checkbooks to incorporate lienholder information. This is a master switch. Checkbooks, via Checkbook Extensions Maintenance, will need Enable Safe Pay Integration turned on to indicate whether the lienholders details will be added.

      2. Unmarked – Lienholder details will not be displayed in Safe Pay files even if checkbooks have Enable Safe Pay Integration turned on.

NEW Checkbook Extensions Maintenance

A new window was created to activate lienholder integration with Safe Pay per checkbook.

 

Open Checkbook Extensions Maintenance

1. Checkbook ID displays the Checkbook ID selected in the Checkbook Maintenance window. The field is disabled, and lookup will open the existing Checkbooks window allow users to select another Checkbook ID.

2. Description displays the description assigned to the Checkbook ID.

3. Enable Safe Pay Integration

   1. Marked – Prints the lienholder details in the Safe Pay file based on the lienholder setup in Vendor Maintenance. Works in conjunction with General Setup’s Enable Safe Pay Integration.

   2. Unmarked – Lienholder’s details will not be displayed in the Safe Pay file.

4. Warning: Safe Pay Integration on General Setup is not enabled.

   1. Displays if General Setup’s Enable Safe Pay Integration is disabled.

   2. Does not display if General Setup’s Enable Safe Pay Integration is enabled.

Chapter 15: NEW Split Code Validations

This chapter describes enhancements made to Split IDs. Validations for deleting, holding, and inactivating have been put in place within the Customer/Vendor Maintenance and split transaction windows to alert users that the Customer/Vendor is a part of a Split ID. (

CIN-7113)

 

This chapter contains the following sections:

 

Changes to Customer/Vendor Maintenance

The Customer/Vendor Maintenance windows have been updated to validate if Split IDs exist when attempting to perform the following functions:

 

1. Place a customer/vendor on hold. User is warned that the customer/vendor is part of a Split ID(s) that can still be used to split transactions.

2. Inactivate a customer/vendor. User is stopped from inactivating the customer/vendor until the customer/vendor is removed from the Split ID.

3. Delete a customer/vendor. User is stopped from deleting the customer/vendor until the customer/vendor is removed from the Split ID.

 

Changes to Split Transactions

Selecting a valid Split ID within a transaction window will warn the user that Customer/Vendor ID(s), attached to this Split ID are on hold. The user will have the following options:

 

1. Yes, allow the transaction to use the Split ID.

2. No, returns the user to the Split ID field and if the ID is not removed, the validation will be done again.

 

Transactions windows that have been impacted by this change:

 

• CINCH Grain

  • Inbound Scale Ticket Entry

  • Settlement Entry

  • Purchase Load Entry

  • Purchase Load Generator

• CINCH Sales

  • Booking Entry

  • Counter Sales Entry

  • Sales Order Entry

  • Sales Return Entry

  • Tank Maintenance

Appendix A

 

NEW Windows

 

NEW Reports

 

NEW Tables

 

Changes that may affect Reports or Data

 

¹

^I