User Tools

Site Tools


stock_ledger_reconciliation_report

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Next revisionBoth sides next revision
stock_ledger_reconciliation_report [2018/06/26 11:50 (6 years ago)] – [Using the report to reconcile] cliffstock_ledger_reconciliation_report [2018/06/26 12:00 (6 years ago)] – [More tools - Definitely Techie] cliff
Line 60: 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.     * 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.      * 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.
  
  
  
stock_ledger_reconciliation_report.txt · Last modified: 2022/06/03 13:32 (22 months ago) by agera