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

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

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

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

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