Reconciles to Try

Important Information Regarding Reconciles

We recommend a SQL backup of your database before running any reconcile.
- If you are reconciling one document because it is already showing incorrectly, the reconciles are generally safe for one document at a time. However, we highly recommend a SQL backup when reconciling more than one document!
Take advantage of your TEST company, before reconciling in LIVE.
Always Reconcile in CINCH before GP
For GP, always reconcile Purchase Orders before reconciling Payables, Inventory, or Financials. It’s important that the purchasing documents are correct since purchasing information may be altered during to the reconcile process and is used when reconciling inventory quantities and payables accounts. Same with Sales, always reconcile Sales Orders before reconciling Receivables, Inventory, or Financials.

Different Reconciles to Try:

Remove Activity Record when a user locks a transaction in CINCH:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Grain>>Activity Reconcile

Reset Totals on Grain Batches:

Microsoft Dynamics GP >> Tools >> Utilities >> Cinch Grain >> Batch Reconcile

Reset Totals for SOP batches:

Microsoft Dynamics GP >> Tools >> Utilities >> Cinch Sales >> SOP Batch

The Freight Reconcile window allows the user to automatically remove any orphaned or duplicate freight records:

Microsoft Dynamics GP >> Tools >> Utilities >> Cinch Grain >> Freight Reconcile

The Purchase Contract Reconcile allows the user to reset totals on Purchase Contracts:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Grain>>Purchase Contract Reconcile

It is recommended to only reconcile one contract at a time. If reconciling multiple, a SQL backup should be done prior.

The Assembly Reconcile allows the user to reset totals on Assemblies:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Grain>>Assembly Reconcile

It is recommended to only reconcile one assembly at a time. If reconciling multiple, a SQL backup should be done prior.

The Settlement Check Reconcile ensures Check Numbers are matched to Settlements:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Grain>>Settlement Check Reconcile

The Reconcile Purchasing Documents is to Reconcile Purchase Orders, see about this window for more information:

Microsoft Dynamics GP >> Tools >> Utilities >> Purchasing >> Reconcile Purchasing Documents

The Reconcile under Purchasing is to Reconcile Vendor Account information:

Microsoft Dynamics GP >> Tools >> Utilities >> Purchasing >> Reconcile

The Sales Contract Reconcile allows the user to reset totals on Sales Contracts:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Sales>>Sales Contract Reconcile

It is recommended to only reconcile one contract at a time. If reconciling multiple, a SQL backup should be done prior.

The Order Schedule Qty Reconcile window can be used to reconcile scheduled quantities on orders.

Microsoft Dynamics GP>>Tools>>Routines>>CINCH Sales>>Order Schedule Quantity Update

The CINCH Counter Sale Checklink window should not be confused with GP CheckLinks (a much larger process). It can be used when the user experiences a printer malfunction. This will move Counter Sale Documents to History based on a selected Batch:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Sales >>Counter Sales CheckLink

The CINCH Sales Document Reconcile window can be used to view and/or remove orphan records that did not get moved to History from the Sales Companion Header (IRCSSOPHDRCOMP) table:

Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Sales >>Sales Document Reconcile

The GP Reconcile-Remove Sales Documents allows you to reconcile your sales documents to verify the Item Quantities and Totals on your Sales Documents:

Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile-Remove Sales Documents

The GP Sales Reconcile will Reconcile the Customer Account and Document Amounts:

Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile

Greenstone recommends running the reconcile on Outstanding Document Amounts first, then run the reconcile on the Current Customer Information.

Other GP Reconciles to be considered (Go to about this window for more information):

Microsoft Dynamics GP >> Tools >> Utilities >> Financial >> Reconcile

There is a Financial Batch Reconcile found here that is generally safe to run for a specific batch.

Microsoft Dynamics GP >> Tools >> Utilities >> Financial >> Reconcile Analysis

Microsoft Dynamics GP >> Tools >> Utilities >> Inventory >> Reconcile