Accounting

Purpose

The purpose of the accouting package is to aggregate Invoice Detail Lines based on Period, Invoice and General Ledger Code for all invoices within a timeframe. It also updates all aggregated lines and sets a invoice close date on the invoices which does not have a date set already.

The timeframe is per default the detail lines created in the previous month.

The table ACCOUTING_MATRIX will contain invoiced data on a monthly basis.

Tables

ACCOUTING_MATRIX

The output if the package is placed in this table.

INVOICE_DETAIL_LINE, CHARGE_ITEM

Tables which is used for the aggregated data.

Configuration

A DBA Scheduler Job is configured to run on a daily basis. 

BEGIN accounting.month_end; END;