Philip Barton and Associates

View Custom Documentation: 19. About Processing Streams


OPTION (19) Modifications to Baseline - Minimal                               GRAPHIC EXAMPLE

(NIT-00) NIGHTLY, MONTHLY, AND SPECIAL PROCESS STREAMS

This memorandum provides information about use of periodic processing streams.

These are some of the benefits of using a pre-set stream:

a). The computer does a large amount of work at night, when fewer users are active.

b). Reports are ready for delivery the next morning.

c). Continuing issues such as negative inventory balances, Past Due P.O. Scheduled Receipts, invalid Costs, etc., produce action reports, nightly. These reports are either not Baseline, or are not run often enough by users to deal with these issues on a timely basis.

d). Journal creation could be done on a daily basis rather than in a very large batch at month-end. This provides a better audit trail back towards the items that have originated the journals, since there are fewer items tied to each journal. The month-end journal processes, which put a substantial load on resources during the normal workday, would no longer be required.

The following are a few of the processes which can be run each night:

Accounts Receivable Aging Accounts Payable Aging Daily Inventory Activity (MMI-U-01) Generation of all Journals

NOTE: Custom logic is available to create individual INVOICE and PPV Journals by Product Line, for Material, Labor, and Overhead. This can save a substantial amount of time for Cost Accounting at the Month-End close.

Report of Negative Inventory. Rebuild AR-OLDEST and AP-OLDEST indices. Report of P.O. Past Due, and Past-Due Released Work Orders. Report of Costed Inventory Valuations.

NOTE: If your company has substantial ECN activity, keeping an old Work Order released can cause variances in Materials, due to BOM changes. Some companies would find it helpful to "freeze" the BOO's (routings) at ROLLUP time, and use those frozen BOO's for the Standard BOO all year, to eliminate ongoing minor variances in Earned Hours.

(Custom) Report of AP-RECEIPTS not invoiced, by Vendor (Custom) PPV History Build (Custom) Purchase Order Detail History Build (Custom) Sales Order Detail History Build (Custom) Indented Costed Top-Level BOM's - Weekly (Custom) Material Movements Reports

Processing Streams currently included:

NIGHTLY/WEEKLY Processing and Reports

MONTHLY Processing and Reports (excludes Journals and Financial Closure)

MONTH-END Journals and Financial Closure.

DAILY/MONTH-END Invoices from SO, RMA, CSS, Field Service

Custom streams are recommended for processes such as:

COST ROLLUP; PHYSICAL INVENTORY REPORTS

Since different customers use different methodologies for their Cost Rollup and Inventory, customized streams would be written for each customer. Complete Custom Modules can be provided for COST ROLLUP and WALL-TO-WALL PHYSICAL INVENTORY, which would include the Custom Stream within.

This must be written separately for each customer's report requirements.