stock_ledger_reconciliation_report
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
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 11:57 (6 years ago)] – 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. | * 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. | * 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. | * 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. | * 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. | * 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" | * SUPER GEEK TIP FOR YOUR PROGRAMMER (we can't help you with this): check out a diff tool. I searched "diff tool windows" | ||
+ | |||
+ | ===== More tools - Definitely Techie ===== | ||
+ | * Fix proof on all periods: Helps get opening Ledger balance to match trial balance. | ||
+ | * WARNING: consult with our support team 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 | ||
stock_ledger_reconciliation_report.txt · Last modified: 2022/06/03 13:32 (23 months ago) by agera