Labor Ledger Automated Balancing

Labor Distribution > Labor Ledger Daily Process

Labor Ledger Automated Balancing

Similar to the G/L process described in “General Ledger Automated Balancing” in the KFS Guide to Core Components and Functions, an automated balancing process and report helps verify balance and entry transactions processed through the KFS Labor Ledger. This report is generated by the laborBalancingJob. It is named 'balancing' and is available in the LD reports directory.

All fields displayed in the statistics are detailed in the table below.

Labor automated balancing statistic fields

Statistic Label	Description
FISCAL YEARS INCLUDED IN BALANCING	Specifies the years included in the automated labor comparisons. The KFS-LD NUMBER_OF_PAST_FISCAL_YEARS_TO_INCLUDE parameter controls the number of past fiscal years included.
HISTORY TABLES INITIALIZED—UPDATES SKIPPED	If this is the first run of the laborBalancingJob, the value is 'Yes. This value indicates that the history tables required for future runs of the automated balancing report have been created. During subsequent balancing (after the tables have been initialized), the value is 'No'.
OBSOLETE HISTORY DELETED	If a given fiscal year in the history tables is not in the range of years included in balancing, this value identifies the fiscal years that have been removed. If no fiscal years were removed, the value is 'No'.
UPDATES SKIPPED DUE TO OUT OF RANGE FISCAL YEAR	If the most recent Labor nightly batch cycle included entries for fiscal years that are not in the range of years to be included in balancing, this value indicates how many updates to the balancing tables were skipped due to out-of-range fiscal year entries.
LLEN AMOUNT FAILURES (LaborEntryHistory)	The number of entries in the Labor Ledger Entry table that failed to match those in the Labor Entry History table.
LLBL AMOUNT FAILURES (LaborBalanceHistory)	The number of entries in the Labor Ledger Balance table that failed to match those in the Labor Balance History table.
LLEN SUM (ROW COUNT) - CALC. (LaborEntryHistory)	The calculated row count from the Labor Entry History table. This number equals the number of entries in the history table prior to the last batch cycle plus the number of entries from that last cycle.
LLEN ROW COUNT - PROD.	The number of rows in the Labor Ledger Entry table. This number should match the LLEN SUM CALC row count from the History table.
LLBL ROW COUNT - CALC. (LaborBalanceHistory)	The calculated row count from the Labor Balance History table. This number equals the number of previous History table balance entries plus the number from the most recent batch cycle.
LLBL ROW COUNT - PROD.	The number of rows in the Labor Ledger Balance table. This number should match the LLBL ROW COUNT calculated from the history tables.

Errors encountered by the labor balancing process will be displayed before the statistics, as described above for the G/L automated balancing process. The number of detailed errors displayed on the labor report is controlled by a separate parameter: KFS-LD NUMBER_OF_COMPARISON_FAILURES_TO_PRINT_PER_REPORT.

The occurrence of errors may require the history tables to be rebuilt based on the production entries and balances. This is accomplished using the LaborBalancingHistorySyncJob. This will rebuilt the history tables based on current entries and balances and create as new starting place for future comparisons.