Differences

This shows you the differences between two versions of the page.

--- stock_ledger_reconciliation_report [2018/06/26 11:45 (6 years ago)] – [Using the report to reconcile] cliff
+++ stock_ledger_reconciliation_report [2018/06/26 12:00 (6 years ago)] – [More tools - Definitely Techie] cliff
@@ Line 51: / Line 51: @@
     * Common column: The ledger Source, and the Stock Document field are the same for most entries. With a little clean up you could get them all matching.
     * Sort by the common column to get everything with a ledger header followed by stock detail lines.
+      * If you have problems getting the header prior to details: Tweak the Ledger Description column you can use it as a secondary sort column. Select the Ledger Description column and replace Invoice with __. Those are underscores.
   * Compare the report in excel today against the backup from the period you are reviewing. This will show differences and may provide insight.
   * Remember: the report is just a tool. Reconciliation is an accounting, and stock management skill. Put the right person on the job.
@@ Line 59: / Line 60: @@
     * If you have a month end data set from last month, you can compare it to the month end report you produce today to generate differences.
     * SUPER GEEK TIP FOR YOUR PROGRAMMER (we can't help you with this): check out a diff tool. I searched "diff tool windows" on google and got a bunch of results. This is a programmer tool that can compare one text file and another for differences. if you were to produce an excel .CSV of the report from the back dated and current report you might be able to see if the changes quickly.
+===== More tools - Definitely Techie =====
+  * WARNING: can change prior year ledger balances. Consult our support department and backup before performing this process.
+    * Fix proof on all periods: Helps get opening Ledger balance to match trial balance.
+      * set book month to 00/0000 > run a test proof > select all periods and departments > run fix proof
+  * WARNING: consult with our support team and backup before running any toolbox routine. Many are no longer supported and can break your data.
+    * Tool box routine > Stock Control Routines > Validate Stock Quantities: Helps find and re-create missing Stock history records (TIP: must run on a department by department basis if you want to re-create missing history records.