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 >> 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
| Note |
|---|
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
| Note |
|---|
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
| Note |
|---|
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
| Note |
|---|
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
| Note |
|---|
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
| Note |
|---|
Make sure you do not accidently Age Finance Charges. |
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):
...