Wiki

Case Status
Log In

Wiki

 
Accounting Periods - Details
  • RSS Feed

Last modified on 11/25/2015 9:49 AM by User.

Accounting Periods - Details

 

Most OASIS reports are dynamic – that is a change in a transaction will update all related reports immediately. For accounting purposes (and for trend analysis), having the ability to “freeze” a report in time, is necessary.

The Problem

The best way to describe the problem is by example. Consider the following order for $1,100.00 of material:

Now assume the manufacturer ships the material and pays commission, followed by the agency crediting one sales person for $100 in commissions and $75 in overage. Everything is good – then.

It is noticed that a second item is required for these fixtures – and the agency take the price of the second item from their profit:

How it works

Pure and simple: brute force! For each PO and invoice there is a side table containing a snapshot of the information for a given period. Each time an accounting period is closed, the order and invoice transactions in OASIS are recalculated and compared to previous periods. The changes or additions are added to the accounting tables.

PO Accounting Table: 

POID

Identifies a unique PO in OASIS

AccountingPeriod

Period covered by this entry

Account

A sales account, a tax account or a number of virtual accounts including __FREIGHT.

BookedTotalPrice

Total price of the order during the first period the order was created in. All other periods will either not have an entry for this order, or a “net change” showing the amount of increase or decrease during that period.

BookedTotalCommission

Same as BookedTotalPrice, but for straight commission

BookedTotalOverage

Same as BookedTotalPrice, but for overage

BookedTotalMarkup

Same as BookedTotalPrice, but for markup

BookedTotalOverhead

Same as BookedTotalPrice, but for resell overhead

Release Values Shows the Order release status

 

Invoice Accounting Table:

InvoiceID

Identifies a unique Invoice in OASIS

AccountingPeriod

Period covered by this entry

InvoicedTotalPrice

Total price of the invoice during the first period the order was created in. All other periods will either not have an entry for this invoice, or a “net change” showing the amount of increase or decrease during that period.

Paid

Same as Total Price, but for payments applied to the invoice – total amount paid.

PaidCommission

Same as Total Price, but for payments applied to the invoice – but only the commission paid.

PaidOverage

Same as Total Price, but for payments applied to the invoice – but only the overage paid.

PaidMargin

Same as Total Price, but for payments applied to the invoice – but only the commission paid.

PaidOverhead

Same as Total Price, but for payments applied to the invoice – this is only the amount withheld for overhead.

RepPaidCommission

Same as Total Price, but for payments applied to the invoice – commission paid to the rep.

RepPaidOverage

Same as Total Price, but for payments applied to the invoice – overage paid to the rep.

RepPadMargin

Same as Total Price, but for payments applied to the invoice – margin paid to the rep.

 

Customizing the Reports

The old Commissions for Account reports must remain very static – that is only form changes are accepted for customization by the Ingen Software team. The reason is simple: very complex code.

The accounting period reports allow for customization on how commission, overage, margin, and other values are calculated.