Important Information Regarding Reconcile
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.
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 or Inventory. 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.
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. It can be used when the user experiences a printer malfunction that 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 Comp Header (IRCSSOPHDRCOMP) table:
Microsoft Dynamics GP>>Tools>>Utilities>>Cinch Sales >>Sales Document Reconcile
This has a preview, but cannot be done one record at a time, recommend a SQL backup. Make note of what will be reconciled.
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
Make sure you select Reconcile – not remove completed documents.
The GP Sales Reconcile will reconcile the customer account and document amounts:
Microsoft Dynamics GP >> Tools >> Utilities >> Sales >> Reconcile
Make sure you do not accidently Age Finance Charges.
Other GP Reconciles to be considered, go to about this window for more information:
Complete a SQL backup prior to reconciling inventory or financials.
Microsoft Dynamics GP >> Tools >> Utilities >> Financial >> Reconcile
Microsoft Dynamics GP >> Tools >> Utilities >> Financial >> Reconcile Analysis
Microsoft Dynamics GP >> Tools >> Utilities >> Inventory >> Reconcile
The Reconcile to GL routine can help you analyze transactions in General Ledger, but it doesn’t change data automatically, even if unmatched transactions are identified. Adjustments are not automatically created or posted, nor are transactions marked or identified as being reconciled within General Ledger. This is safe to do without a backup as it does not update any date. Transactions >> Financial >> Reconcile To GL.