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.
Comments
0 comments
Please sign in to leave a comment.