|
Four new reporting tables have been added to Agiblocks reporting that represent a general ledger.
These support the following chart of accounts:
Name
|
Number
|
Additional Description
|
Accounts receivable
|
110-100-00
|
|
Delivered sale, not yet invoiced
|
110-110-000
|
|
Suspense account sale
|
110-330-000
|
|
Accounts payable
|
120-200-000
|
|
Delivered purchase, not yet invoiced
|
120-210-000
|
|
Suspense account other
|
120-310-000
|
|
Suspense account purchase
|
120-320-000
|
|
Inventory accruals purchase
|
130-320-000
|
Delivered but not invoiced
|
Inventory accruals other costs
|
130-326-000
|
|
Inventory accruals freight
|
130-327-000
|
|
Inventory actual
|
135-320-000
|
Delivered and invoiced or lost
|
Accrued sales
|
140-330-000
|
|
Accruals other costs
|
140-326-000
|
|
Accruals freight
|
140-327-000
|
|
COG
|
140-320-000
|
|
Other costs
|
145-326-000
|
|
Freights costs
|
145-327-000
|
|
Turnover
|
145-330-000
|
|
gl.AccountEntry Table
| • | Each AccountEntry represents an entry in 1 of the accounts. |
| • | Each entry has an AccountNumber and AccountName which can be used for filtering. |
| • | Each AccountEntry has a reference to Booking: as AccountEntries are always made in pairs, 1 credit entry in one account and 1 debit entry in another account, the Booking represents such a pair. |
| • | Each account entry has a Date, at which it is booked and is, based on that date, assigned to a reporting year and month (the reporting year takes into account the first month of the fiscal year). |
| • | Each account entry also has a topic: |
| o | For Purchase / Sales this is filled with the commodity |
| o | For other cost items this is filled with the cost item name |
gl.Booking Table
| • | A Booking references to a CreditEntry and a DebitEntry in the AccountEntries. |
| • | A Booking also has the fields referring to the goods involved: |
| o | FirstPortionNumber -portion number of the original purchased goods) |
| o | GoodsPortionNumber - portion number part of the original goods that the entries are about. |
| o | PortionNumber - this refers to either the sales portion if the entry is about a sale, or else it is the same as the GoodsPortionNumber. |
gl.BalanceEntry
| • | The BalanceEntry table gives per account and per reporting month - the total of all account entries. |
gl.Dimension
| • | Lists Agiblocks dimensions used for an external accounting system. |
Note: This table is only available if Agiblocks dimensions have been configured for an external accounting system. An error will be returned when accessing the table if this data is not available.
|