We are currently updating our site; thank you for your patience.
Accounts
Account Drivers - High Level - Financial Transactions
BPO and PASTEL Integration
Transaction Processing
Within BPO are various financial transactions that fulfil business process and financial requirements. The use of accounting in BPO is kept to a minimum, so that users do not need to have accounting knowledge to successfully process financial transactions. Transactions are posted in BPO and the financial effects thereof posted to Pastel Evolution by means of accounting drivers.
If you are not using Pastel Evolution, BPO can be configured to write these financial transactions to tables within BPO. These can be reported on and input in the selected financial system.
Account Drivers
An accounts driver is an event that will check the transaction you are busy with on BPO and verify whether there is a financial effect to be posted to Pastel.
The drivers are configured with the following details per driver code (which relates to a transaction type):
- Item Target Account (Yes/No)
- Target Ledger Account (Relevant GL Account)
- Entry Sign (Dr/Cr)
- Value to Post (GVAL/NVAL/TVAL)
- Ignore Segments (Yes/No)
- Segment Type (Up to 5 Segments)
GL Transaction Posting Info
Here is some information on references and descriptions that pull through on the transaction in the General Ledger:
- Narrative: BPO: Driver Code Description, e.g. ‘BPO: Goods Received Note’. If the account code specified does not exist in Sage Evolution, this account code will be included in the description – BPO: AccCode: Driver Code Description e.g. BPO: 7042: Goods Received Note
- Reference: BPO’s document number, e.g. Goods Received Note no: GRN00102
- cReference2: Second reference, e.g. Purchase Order relating to the GRN: PO00100
- cPayeeName: Composite code describing the BPO information relating to the transaction item: ‘PayeeName Item Code’: BPO Item Code and Description e.g. STK: SP1212: Colour Copier
‘PayeeName’ Item Codes:
- STK: Stock
- SVC: Service
- EXP: Expenses
- LAB: Labour
- TVL: Travel
- WAR: Warranty
Item Target Account
When transactions are posted, BPO will reference the Account Driver set-up to see whether to use the Target Account or not.
If the transaction is configured to use the Item Target Account (set to ‘Yes’), then BPO will look for and post to this Target Account (varies depending on the transaction – view the relevant transaction notes for the source of this Target Account Source).
If this Target Account was not specified, or the transaction is not configured to use the Target Account, then BPO will post to the Target Ledger Account as set up in the Account Drivers table.
Example of possible Item Target Type Iterations:
- CTIT: COS Account on the contract item linked to a call
- ACAT: Part Category of the Asset linked to a call
- PTCA: Part Category
Target Ledger Account
Relevant General Ledger (GL) Account Code where the transaction will always post to, if ‘Item Target Account’ is set to ‘No’.
If ‘Item Target Account’ is set to ‘Yes’, but BPO cannot find a GL Account Code configured on the Target Account Source, BPO will use the Target Ledger Account.
Entry Sign
Each transaction leg will be defined as either a Debit or a Credit
Value to Post
Each transaction leg will be configured to post one of the following three value types:
- GVAL – Gross Value
- NVAL – Net Value
- TVAL – Tax value
Segments
The standard BPO Chart of Accounts (COA) is not segmented. This type of Chart of Accounts is the easiest to use and accommodates most client requirements. However, some clients require the ability to report by Branch and/or Department within the Income Statement, and therefore, a Segmented Ledger will be configured.
Where transactions are posted to an account code that is not segmented, (for a segmented or non-segmented ledger), BPO will not take segments into account. In this case, ‘Ignore Segments’ will be set to ‘Yes’.
If your Chart of Accounts is segmented, the Account Drivers will be configured accordingly. For transactions that should post to a segmented account code, e.g. Sales to a specific Branch; BPO will fetch the segments, and post to that relevant account at the time of the transaction. In this case, ‘Ignore Segments’ will be set to ‘No’.
In order to fetch the segments, the Segment Types must be configured for the relevant transaction leg. These are the segment types that could be used, depending on the transaction:
- ACDP: Customer Account Manager Department
- CDPT: Contract Department or Machine Technician Department
- CUST: Customer
- DEMP: Salesman Department
- DSIT: Salesman Department Site
- IDEP: Item Department
- IDST: Item Department Site
- PTCA: Part Category
- SITE: Site (Branch)
- SUPP: Supplier
- WHSE: Warehouse
Item Target Account and Segment Mapping Reference Table:
|
Driver Code |
Item Target Type Options |
Segment Mapping Options |
| CDPT | ||
| CTIT, ACAT, PTCA | CUST | |
|
DEMP |
||
|
PTCA |
||
|
SITE |
||
|
CDPT |
||
| CTIT, ACAT, PTCA |
CUST |
|
|
DEMP |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
CDPT |
||
|
CUST |
||
|
DEMP |
||
|
DSIT |
||
|
PTCA |
||
|
SITE |
||
|
CDPT |
||
|
CUST |
||
|
DEMP |
||
|
DSIT |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
CUST |
||
|
DEMP |
||
|
DSIT |
||
|
IDEP |
||
|
IDST |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
CUST |
||
|
DEMP |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
DEMP |
||
|
DSIT |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
DEMP |
||
|
PTCA |
||
|
SITE |
||
|
WHSE |
||
|
PTCA |
||
|
SITE |
||
|
SITE |
||
|
SUPP |
||
|
DEMP |
||
|
PTCA |
||
|
SITE |
||
|
SUPP |
||
| WARP |
DEMP |
|
|
PTCA |
||
|
SITE |
||
|
SUPP |
||
|
WHSE |
||
| DBNT, SIBB, SINV |
PTCA |
|
|
SITE |
||
|
SUPP |
||
| NGRN, PGRN, PSRN |
PTCA |
|
|
SITE |
||
|
SUPP |
||
|
WHSE |
Suspense Account
The suspense account was created because Sage Evolution does not allow transactions to post to an invalid GL Account Code. If the Target Ledger Account, or GL Account Code on the Target Account Source are not configured, (or are incorrectly configured, e.g. account specified does not exist in the Chart of Accounts), the transaction will post to the Suspense account.
This enables BPO and Sage to process the transaction, and the user to identify configuration issues afterwards. The first thing the user can do is check that the Target Account source is correctly set up. If that is not the problem, the account driver configuration must be analysed and corrected.
Where BPO is meant to fetch the account code from the Target source, but the source is incorrect, it is best to enforce that BPO posts this transaction to suspense by setting up the Driver Target Ledger Account as ‘0’, in order to identify and correct the source.
Users will ‘correct’ the transaction that was posted to the suspense account with a journal in Sage.
Control Account & Sub Ledgers
A Control Account is the sum total of the transactions processed within its sub ledger, e.g. Supplier Control Account would list the total of all transactions in the individual supplier accounts (sub ledgers).
Driver Codes
|
Code |
Transaction Type |
Code |
Transaction Type |
|
Goods Received Note |
Close Work Order – Non-Stock |
||
|
Cancel GRN |
Sales Invoice |
||
|
Non Stock GRN |
Sales Invoice – COS Service |
||
|
Cancel Non-Stock GRN |
Sales Invoice – COS Stock |
||
|
Supplier Invoice |
Credit Note |
||
|
Supplier Invoice Variance |
Credit Note – COS Service |
||
|
Supplier Return Note - Stock |
Credit Note – COS Stock |
||
|
Non-Stock Return Note |
Contract Invoice |
||
|
Supplier Debit Note |
Contract Credit Note |
||
|
Debit Note Variance |
Debit Order Payment |
||
|
Stock Adjustment – Increase |
Period Depreciation |
||
|
Stock Adjustment – Decrease |
Reverse Accumulated Depreciation |
||
|
Serialised Stock Adjustment – Increase |
Stock Revaluation – Return |
||
|
Serialised Stock Adjustment – Decrease |
Stock Revaluation - Issue |
||
|
Stock Take – Increase |
REVB | GRN Revaluation NGRN Portion | |
|
Stock Take – Decrease |
Contract CR Note - Back to Back |
||
|
Stock Transfer – In |
Contract Invoice - Back to Back |
||
|
Stock Transfer – Out |
Supplier Invoice - Back to Back |
||
|
Stock Issue – Work Order |
Production Issue - Work Order |
||
|
Stock Return –Work Order |
Production Part Return |
||
|
Stock Issue – Invoice |
Close Production WO Contracts |
||
|
Stock Return - Invoice |
Close Production WO Parts |
||
|
Warranty Claim – Parts |
Serialised Finished Goods |
||
|
Warranty Claim – Subcons |
Non-Serialised Finished Goods |
||
|
Open Work Order - Stock |
Open Production WO Contracts |
||
|
Close Work Order – Stock |
Open Production WO Parts |
||
|
Open Work Order – Non-Stock |
- All notes below based on the Non-Segmented 'Base' General Ledger.
TRANSACTION DEFINITIONS
Goods Received Note (PGRN)
A Stock Goods Received Note (GRN) is raised to confirm receipt of parts supplied by a Supplier. The GRN is linked to the originating Purchase Order. Raising a GRN in BPO will close the originating Purchase Order, (if the order is fully delivered), and create the stock received in the receiving warehouse and bin location. The Goods Received Note is new until closed by the supplier invoice, or cancelled.
Note: The VAT is only recognised when the
invoice is received, as per SARS requirements.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
Dr |
Stock |
100 |
|
|
Cr |
Goods Received Accrual |
|
100 |
Transaction Setup
|
Dr/Cr
|
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PGRN: Goods Received Note. This driver is called when a user processes an Inventory Goods Received Note in BPO. |
|||||||
|
Dr |
Stock Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
GRN Accrual Account |
No |
NVAL |
Yes |
9100 |
|
|
Target Account Source
- Stock: Warehouse (Administration > System Configuration > Inventory Warehouses)
- GRN Accrual: As per account driver
Segment Type Options
- PTCA, SITE, SUPP, WHSE
Cancel Stock GRN (CGRN)
From BPO_RSI v1.22.0.5 and the introduction of Supplier Debit Notes, Cancelling a Goods Received Note is no longer valid. If a Supplier Invoice has not yet been raised, just raise a Supplier Return. If a Supplier Invoice has been raised and accepted, then raise a Supplier Return and Supplier Debit Note.
If stock was incorrectly received, the Goods Received Note can be cancelled, unless the supplier invoice has already been raised and accepted. You will have the option to re-open the originating Purchase Order, and can then correctly receive the stock.
Take into consideration that cancelling a GRN has an effect on the weighted average cost of the stock that remains in store.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
Dr |
Goods Accrual |
100 |
|
|
Cr |
Stock |
|
100 |
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
CGRN: Goods Received Note. This driver is called when a user cancels a stock Goods Received Note in BPO. |
|||||||
|
Dr |
GRN Accrual Account |
No |
NVAL |
Yes |
9100 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- GRN Accrual: As per account driver
- Stock: Warehouse (Administration > System Configuration > Inventory Warehouses)
Non-Stock GRN (NGRN)
A Non-Stock Goods Received Note is raised to confirm receipt of services rendered by a Supplier. The GRN is linked to the originating Purchase Order. Raising a GRN in BPO will close the originating Purchase Order and complete the service requirement. The Goods Received Note is new until closed by the supplier invoice, or cancelled.
The Non-Stock WIP account is an account that can either be a balance sheet account or an income statement account. This classification depends on the accounting policy of the organisation.
Note: The VAT is only recognised when the invoice is received, as per
SARS requirements.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Non -Stock WIP Account |
100 |
|
|
|
Cr |
Goods Received Note Accrual |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
NGRN: Goods Received Note. This driver is called when a user cancels a non-stock Goods Received Note in BPO. |
|||||||
|
Dr |
Non -Stock WIP Account |
No |
NVAL |
Yes |
7810 |
|
|
|
Cr |
GRN Accrual Account |
No |
NVAL |
Yes |
9100 |
|
|
Target Account Source
- Non-stock WIP: As per account driver
- GRN Suspense: As per account driver
Segment Type Options
- PTCA, SITE, SUPP, WHSE
Cancel Non-Stock GRN (CNGR)
From BPO_RSI v1.22.0.5 and the introduction of Supplier Debit Notes, Cancelling a Goods Received Note is no longer valid. If a Supplier Invoice has not yet been raised, just raise a Supplier Return. If a Supplier Invoice has been raised and accepted, then raise a Supplier Return and Supplier Debit Note.
If a service was incorrectly received, the Non-Stock Goods Received Note can be cancelled (unless the supplier invoice has already been raised and accepted). You will have the option to re-open the originating Purchase Order, and can then correctly receive the service. There is no weighted average cost implication on Non-Stock GRNs.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Goods Received Note Accrual |
100 |
|
|
|
Cr |
Non-Stock WIP Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CNGR: Goods Received Note. This driver is called when a user processes a Non-Stock Goods Received Note in BPO. |
|||||||
|
Dr |
GRN Accrual Account |
Yes |
NVAL |
Yes |
9100 |
|
|
|
Cr |
Non-Stock WIP Account |
No |
NVAL |
Yes |
7810 |
|
|
Target Account Source
- GRN Suspense: As per account driver
- Non-stock WIP: As per account driver
Supplier Invoice (SINV)
Raised once a Goods Received Note (Stock and Non-Stock) has been processed, and the physical Supplier Invoice has been received, completes the Goods Receiving Note, and updates Sage Evolution with the amount owed to the supplier.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
GRN Suspense |
100 |
|
|
|
Dr |
VAT Input Account |
14 |
|
|
|
Cr |
Supplier Control Account |
|
114 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
SINV: Supplier invoice. This driver is called when a user processes a supplier invoice in BPO. |
|||||||
|
Dr |
GRN Accrual Account |
No |
NVAL |
Yes |
9100 |
||
|
Dr |
VAT Input Tax |
No |
TVAL |
Yes |
9502 |
||
|
Cr |
Supplier Control Account |
No |
GVAL |
Yes |
9000 |
||
|
Cr |
Sub-Ledger against Supplier Account |
|
GVAL |
N/A |
Supplier Code in Supplier Age Analysis |
N/A |
|
Target Account Source
- VAT Input: As per account driver
- GRN Suspense: As per account driver
- Supplier Control: As per Supplier linked to PO.
Segment Type Options
- PTCA, SITE, SUPP
Supplier Invoice Variance (SIVA)
The difference between cost of goods received and cost owed to the supplier, will post to the Supplier Invoice Variance account - e.g. when a discount is given by the supplier, goods will be received into store at the standard cost, but the costs on the supplier invoice are corrected to reflect the cost as discounted by the supplier.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
For any remaining balance in the GRN suspense account, the system processes the following: |
|
|||
|
Dr |
Supplier Invoice Variance |
20 |
|
|
|
Cr |
GRN Accrual |
|
20 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SIVA: Supplier Invoice variance. This driver is called when there is a difference between the Goods Received Note value and Supplier Invoice value. |
|||||||
|
Dr |
Supplier Inv Variance |
No |
NVAL |
Yes |
9050 |
|
|
|
Cr |
GRN Accrual |
No |
GVAL |
Yes |
9100 |
|
|
Target Account Source
- GRN Suspense: As per account driver
- Supplier Invoice Variance: As per account driver
Segment Type Options
- SITE, SUPP
Supplier Return Note - Stock (PSRN)
If there is a requirement to return incorrect or faulty stock, a Supplier Return Note is raised. The Supplier Return is linked to the Goods Received Note that brought the items into stock. Stock items are removed from stock and returned to Supplier. The GRN transactions are reversed.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Returns Accrual |
100 |
|
|
|
Cr |
Inventory Control |
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
PSRN: Supplier Return Note. This driver is called when a user processes a Stock Supplier Return Note in BPO. |
|||||||
|
Dr |
Supplier Returns Accrual |
No |
GVAL |
Yes |
9150 |
|
|
|
Cr |
Inventory Control Account |
No |
NVAL |
Yes |
7700 |
|
|
Segment Type Options
- PTCA, SITE, SUPP, WHSE
Supplier Return Note - Non-Stock (NSRN)
The Non-Stock Return Note driver reverses the Non-Stock GRN postings.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Returns Accrual |
100 |
|
|
|
Cr |
Non-Stock WIP |
|
100 |
|
Transaction Setup
|
Dr/Cr
|
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
NSRN: Non-Stock Return Note - This driver is called when a user processes a Non-Stock Goods Received Note in BPO. |
|||||||
|
Dr |
Supplier Returns Accrual | No | NVAL | Yes | 9150 |
|
|
|
Cr |
Non-Stock WIP | No | GVAL | Yes | 7810 |
|
|
Segment Type Options
- SITE, SUPP
Supplier Debit Note (DBNT)
The Supplier Debit Note driver reverses the Supplier Invoice postings. Any variances will post as defined in the Debit Note Variance driver.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Control Account |
114 |
|
|
|
Cr |
GRN Accrual Account |
100 | ||
|
Cr |
VAT Input |
|
14 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
DBNT: Supplier Debit Note - This driver is called when the user processes a Supplier Debit Note |
|||||||
|
Dr |
Supplier Control Account | No | GVAL | Yes | 9000 |
|
|
| Cr |
GRN Accrual Account |
No | NVAL | Yes | 9100 | ||
|
Cr |
VAT Input |
No | TVAL | Yes | 9502 |
|
|
Segment Type Options
- PTCA, SITE, SUPP
Debit Note Variance (DNVA)
Posts any variances between the Supplier Invoice and Supplier Debit Note.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Variance |
100 |
|
|
|
Cr |
Supplier Returns Accrual |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not use |
|
|
|
|
|
|
|
|
|
|
DNVA: Debit Note Variance - This driver is called when the user processes a Supplier Debit Note and there is a variance between it and the Supplier Invoice. |
|||||||
|
Dr |
Supplier Variance |
No |
NVAL |
Yes |
9050 |
|
|
|
Cr |
Supplier Returns Accrual |
No |
GVAL |
Yes |
9150 |
|
|
Segment Type Options
- SITE, SUPP
Stock Adjustment - Increase (SAJI)
A stock adjustment increase will increase the stock position of a non-serialised item. When adjusting stock into the system, the stock account will be credited. The user must specify a ‘contra account code’; i.e. Stock Adjustments, Cost of Sales, Stationery etc, which will be debited.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Stock |
100 |
|
|
|
Cr |
Contra Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SAJI: Stock Adjustment Increase – consumables. This driver is called when a user processes a stock adjustment in BPO for consumable stock that increases the stock position |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Inventory Adjustments |
Yes |
NVAL |
Yes |
2500 |
|
|
Target Account Source
- Contra Account: As specified on stock adjustment (contra account code)
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Stock Adjustment - Decrease (SAJD)
A stock adjustment decrease will decrease the stock position of a non-serialised item. When adjusting stock out of the system, the stock account will be debited. The user must specify a ‘contra account code’, i.e. Cost of Sales, Stationery, and so forth, which will be credited.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Contra Account |
100 |
|
|
|
Cr |
Stock |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SAJD: Stock Adjustment Decrease – consumables. This driver is called when a user processes a stock adjustment in BPO for consumable stock that decreases the stock position. |
|||||||
|
Dr |
Inventory Adjustment |
Yes |
NVAL |
Yes |
2500 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- Contra Account: As specified on stock adjustment (contra account code)
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Serialised Stock Adjustment - Increase (TADI)
A serialised stock adjustment increase will increase the stock position of a serialised item. There may be a few reasons for this. Namely, when adjusting stock into the system, the Inventory account will be credited. The user must specify a ‘contra account code’, e.g. Inventory Adjustment account, which will be debited.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Stock |
100 |
|
|
|
Cr |
Contra Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
TADI: Stock adjustment increase – assets. This driver is called when a user processes a stock adjustment in BPO for serialised stock that increases the stock position. |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Inventory Adjustment Account |
Yes |
NVAL |
Yes |
2500 |
|
|
Target Account Source
- Contra Account: As specified on stock adjustment
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, PTCA, SITE, WHSE
Serialised Stock Adjustment - Decrease (TADJ)
A serialised stock adjustment decrease will decrease the stock position of a serialised item. When adjusting stock into the system, the stock account will be credited. The user must specify a ‘contra account code’, e.g. Inventory Adjustment Account, which will be debited.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Contra Account |
100 |
|
|
|
Cr |
Stock |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SAJD: Stock adjustment decrease – assets. This driver is called when a user processes a stock adjustment in BPO for serialised stock that decreases the stock position. |
|||||||
|
Dr |
Inventory Adjustment Account |
Yes |
NVAL |
Yes |
2500 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- Contra Account: As specified on stock adjustment
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, PTCA, SITE, WHSE
Stock Take - Increase (STKI)
Where the physical non-serialised stock position is found to be more than the system stock position during a stock take, the stock position will be increased.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Stock |
100 |
|
|
|
Cr |
Contra Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SAJI: Stock adjustment increase – consumables. This driver is called when a user processes a stock take in BPO where the counted stock is greater than the stock on hand for consumable stock , which increases the stock position. |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Inventory Adjustment Account |
Yes |
NVAL |
Yes |
2500 |
|
|
Target Account Source
- Contra Account: As per account driver.
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Stock Take - Decrease (STKD)
Where the physical non-serialised stock position is found to be less than the system stock position during a stock take, the stock position will be decreased.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Contra Account |
100 |
|
|
|
Cr |
Stock |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
SAJD: Stock adjustment decrease – consumables. This driver is called when a user processes a stock take in BPO, where the counted stock is less than the stock on hand for consumable stock, which decreases the stock position. |
|||||||
|
Dr |
Inventory Adjustment Account |
Yes |
NVAL |
Yes |
2500 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- Contra Account: As per account driver
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Stock Transfer - In (TRIN)
Stock moved into a bin location, where it has moved out of another bin location. Stock transfers process entries where the warehouses are linked to different GL accounts. Otherwise no entries are processed.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Stock |
100 |
|
|
|
Cr |
Transfer Suspense |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
TRIN: Warehouse Transfer-In. This driver is called when a user processes a parts transfer note in BPO. |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Inventory Transfer Suspense |
No |
NVAL |
Yes |
9998 |
|
|
Target Account Source
- Transfer Suspense: As specified on driver
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, PTCA, SITE, WHSE
Stock Transfer - Out (TROU)
Stock moved out of a bin location, where it is moving to another bin location. Stock transfers process entries where the warehouses are linked to different GL accounts. Otherwise no entries are processed.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Transfer Suspense |
100 |
|
|
|
Cr |
Stock |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
TROU: Warehouse Transfer-Out. This driver is called when a user processes a parts transfer note in BPO. |
|||||||
|
Dr |
Inventory Transfer Suspense |
No |
NVAL |
Yes |
9998 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7770 |
|
|
Target Account Source
- Transfer Suspense: As specified on driver
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- DEMP, PTCA, SITE, WHSE
Stock Issue - Work Order (PSWO)
Stock items issued to a Work Order (Call). This processes as a debit to Work In Progress and a credit to Inventory.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
WIP Account |
100 |
|
|
|
Cr |
Stock Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
PSWO: Stock issue to work order. This driver is called when a user issues stock to a work order. |
|||||||
|
Dr |
WIP Account |
No |
NVAL |
Yes |
7800 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- WIP: As specified on driver
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE, WHSE
Stock Return - Work Order (PRWO)
Stock items returned to store from a Work Order (Call). This processes as a debit to Inventory and a credit to Work In Progress.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Inventory Account |
100 |
|
|
|
Cr |
WIP Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
PRWO: Stock return from Work Order. This driver is called when a user returns stock from a Work Order. |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
WIP Account |
No |
NVAL |
Yes |
7800 |
||
Target Account Source
- WIP: As specified on driver
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE, WHSE
Stock Issue - Invoice (PSIN)
Stock items issued to an Over the Counter Sales Invoice. This processes as a debit to Cost of Sales and a credit to Inventory.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Cost of Sales |
100 |
|
|
|
Cr |
Stock Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
PSIN: Stock issue to invoice. This driver is called when a user issues stock to an invoice. |
|||||||
|
Dr |
Cost of Sales |
Yes |
NVAL |
Yes |
2000 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Target Account Source
- Cost of Sales: As per Item Target Account
- Stock Account: Warehouse (Administration > System Configuration > Inventory Warehouses)
Segment Type Options
- CUST, DEMP, PTCA, SITE, WHSE
Stock Return - Invoice (PRET)
Stock items returned to store from an Over the Counter Sales Invoice. This processes as a debit to Inventory and a credit to Cost Of Sales.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Inventory Account |
100 |
|
|
|
Cr |
Cost of Sales Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
PRET: Stock return from Invoice. This driver is called when a user returns stock from an Invoice. |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
Target Account Source
- Cost of Sales: As per Item Target Account
- Inventory Account: Warehouse (Configuration > Inventory > Warehouses)
Segment Type Options
- CUST, DEMP, PTCA, SITE, WHSE
Warranty Claim - Parts (WARP)
Customer's claim for repair or replacement of non-performance or under-performance of an item as provided for in its warranty document. A new part will be issued to the client at no cost, and the cost owing to the supplier is decreased by raising the warranty claim.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Control Account |
114 |
|
|
|
Cr |
VAT Input Account |
|
14 |
|
|
Cr |
Work in Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
WARP: Warranty claim for parts. This driver is called when a user accepts a supplier warranty claim in BPO. This driver only processes the parts on the accepted warranty claim. |
|||||||
|
Dr |
Supplier Control Account |
No |
GVAL |
Yes |
9000 |
|
|
|
Cr |
VAT Input Tax |
No |
TVAL |
Yes |
9502 |
|
|
|
Cr |
Work in Progress |
Yes |
NVAL |
Yes |
7800 |
|
|
|
|
|
|
|
|
|
|
|
|
Dr |
Sub Ledger against Supplier Account |
|
GVAL |
N/A |
Supplier code in supplier age analysis |
N/A |
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- DEMP, PTCA, SITE, SUPP, WHSE
Warranty Claim - Subcons (WARO)
Customer's claim for repair or replacement of non-performance or under-performance of an item as provided for in its warranty document. A subcontracted service will be logged to the client at no cost, and the cost owing to the supplier is decreased by raising the warranty claim.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Supplier Control Account |
114 |
|
|
|
Cr |
VAT Input Account |
|
14 |
|
|
Cr |
Non-Stock Work In Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
WARP: Warranty claim for subcontract services. This driver is called when a user accepts a supplier warranty claim in BPO. This driver only processes the subcontracts on the accepted warranty claim. |
|||||||
|
Dr |
Supplier Control Account |
No |
GVAL |
Yes |
9000 |
|
|
|
Cr |
VAT Input Tax |
No |
TVA |
Yes |
9502 |
|
|
|
Cr |
Non-Stock WIP |
Yes |
NVAL |
Yes |
7810 |
|
|
|
|
|
|
|
|
|
|
|
|
Dr |
Sub Ledger against Supplier Account |
|
GVAL |
N/A |
Supplier code in supplier age analysis |
N/A |
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- DEMP, PTCA, SITE, SUPP
Close Work Order - Stock Items (CWIP)
When a Work Order is closed, all non-billable stock items on the Work Order will be processed to Cost of Sales from Stock WIP.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Cost of Sales |
100 |
|
|
|
Cr |
WIP |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CWIP: Stock issue to Work Order. This driver is called when a user closes a Work Order in BPO. The driver will be applied to all stock on the Work Order that was not invoiced. |
|||||||
|
Dr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
|
Cr |
WIP Account |
No |
GVAL |
Yes |
7800 |
|
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE, WHSE
Item Target Type Options
- CCTIT, ACAT, PTCA
Reopen Work Order - Stock Items (OWIP)
The process to re-open a Work Order reverses the above entry, by processing the Cost of Sales to Stock WIP.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
WIP |
100 |
|
|
|
Cr |
Cost of Sales |
|
100 |
|
|
|
|
|
|
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
OWIP: Stock issue to Work Order. This driver is called when a user re-opens a Work Order in BPO. The driver will be applied to all stock that was on the Work Order and not invoiced at the time that the Work Order was closed. |
|||||||
|
Dr |
WIP Account |
No |
NVAL |
Yes |
7800 |
|
|
|
Cr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE, WHSE
Item Target Type Options
- CCTIT, ACAT, PTCA
Close Work Order - Non-Stock Items (CWCT)
When a Work Order is closed, all non-billable non-stock items on the Work Order will be processed to Cost of Sales from non-stock WIP.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Cost of Sales |
100 |
|
|
|
Cr |
Non-Stock WIP |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CWCT: Stock issue to Work Order. This driver is called when a user closes a Work Order in BPO. The driver will be applied to all non-stock items on the Work Order that was not invoiced. |
|||||||
|
Dr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
|
Cr |
Non-Stock WIP Account |
No |
GVAL |
Yes |
7810 |
|
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE
Item Target Type Options
- CTIT, ACAT, PTCA
Re-open Work Order - Non-Stock Items (OWCT)
The process to re-open a Work Order reverses the above entry, by processing the Cost of Sales to Non-Stock WIP.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Non-Stock WIP |
100 |
|
|
|
Cr |
Cost of Sales |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
OWCT: Stock issued to Work Order. This driver is called when a user re-opens a Work Order in BPO. The driver will be applied to all non-stock items that were on the Work Order and not invoiced at the time that the Work Order was closed. |
|||||||
|
Dr |
Non -Stock WIP Account |
No |
GVAL |
Yes |
7810 |
|
|
|
Cr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
Target Account Source
- WIP: As specified on driver
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE
Item Target Type Options
- CTIT, ACAT, PTCA
Sales Invoice (CINV)
Over the Counter / Call Invoices raised for parts supplied and/or services rendered to a client. When a sale is processed in the system, the system has to process Sales and Cost of Sales entries. The Sales entries have the Invoice Number as the source document Reference Number. The Cost of Sales entries have the Invoice number and the Work Order number as the source document Reference numbers. The Cost of Sales entries can be stock related costs or non-stock related costs.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Customer Control Account |
114 |
|
|
|
Cr |
VAT Input Account |
|
14 |
|
|
Cr |
Sales Account (Segmented by Branch) |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CINV: Customer Invoice - This driver is called when a user processes a Work Order Sales Invoice in BPO. This does not include Contract Invoices. |
|||||||
|
Dr |
Customer Control Account |
No |
GVAL |
Yes |
8000 |
|
|
|
Cr |
VAT Input Tax |
No |
TVAL |
Yes |
9502 |
|
|
|
Cr |
Sales |
Yes |
NVAL |
No |
1000 |
|
|
|
|
|
|
|
|
|
|
|
|
Dr |
Sub Ledger against Customer Account |
N/A |
GVAL |
N/A |
Customer Code in Customer Age Analysis |
N/A |
|
Target Account Source
-
Cost of Sales: As per Item Target Account
Segment Type Options
- CUST, DEMP, DSIT, IDEP, IDST, PTCA, SITE, WHSE
Sales Invoice - COS Service (ICON)
The Cost of Sales entry related to a Sales Invoice for service items.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Cost of Sales Account |
50 |
|
|
|
Cr |
Non-S tock WIP Account |
|
50 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
ICON: Cost of Sales entry on Customer Invoice. This driver is called when a user processes a Work Order Sales Invoice in BPO. This does not include Contract Invoices. |
|||||||
|
Dr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
|
Cr |
Non- Stock WIP |
No |
NVAL |
Yes |
7810 |
|
|
Segment Type Options
- CUST, DEMP, DSIT, IDEP, IDST, PTCA, SITE, WHSE
Sales Invoice - COS Stock (ICOS)
The Cost of Sales entry related to a Sales Invoice for stock items.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Cost of Sales Account |
50 |
|
|
|
Cr |
Work in Progress Account |
|
50 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
ICOS: Cost of Sales entry on Customer Invoice. This driver is called when a user processes a Work Order Sales Invoice in BPO. This does not include Contract Invoices. |
|||||||
|
Dr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
|
Cr |
Work In Progress |
No |
NVAL |
Yes |
7800 |
|
|
Segment Type Options
- CUST, DEMP, DSIT, IDEP, IDST, PTCA, SITE, WHSE
Sales Credit Note (CRNT)
A credit that is raised against a Sales Invoice. This will post opposite entries to those raised for the Sales Invoice.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Sales Account (Segmented by Branch) |
100 |
|
|
|
Dr |
VAT Output Account |
14 |
|
|
|
Cr |
Customer Control Account |
|
114 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CRNT: Credit Note. This driver is called when a user processes a Credit Note for a parts Invoice or a Work Order Invoice. This does not include Credit Notes for Contract Invoices. |
|||||||
|
Dr |
VAT Output Tax |
No |
TVAL |
Yes |
9501 |
|
|
|
Dr |
Sales |
Yes |
NVAL |
No |
1000 |
|
|
|
Cr |
Customer Control Account |
No |
GVAL |
Yes |
8000 |
|
|
|
|
|
|
|
|
|
|
|
|
Cr |
Sub Ledger against Customer Account |
|
GVAL |
N/A |
Customer Code in Customer Age Analysis |
N/A |
|
Segment Type Options
- SITE, CUST, DEMP, DSIT, IDEP, IDST, WHSE, PTCA
Sales Credit Note - COS Service (CCON)
This will post opposite entries to those raised for the Sales Invoice COS Service.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Non-Stock WIP Account |
50 |
|
|
|
Cr |
Cost of Sales Account |
|
50 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CCON: Cost of Sales entry on customer Credit Note. This driver is called when a user processes a Credit Note and the Cost of Sales needs to be reversed to the WIP account from the Cost of Sales account. This does not include Credit Notes for Contract Invoices. |
|||||||
|
Cr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
|
|
|
Dr |
Non -Stock WIP |
No |
NVAL |
Yes |
7810 |
|
|
Segment Type Options
- CUST, DEMP, DSIT, IDEP, IDST, PTCA, SITE, WHSE
Sales Credit Note - COS Stock (CCOS)
This will post opposite entries to those raised for the Sales Invoice COS Stock.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Work in Progress Account |
50 |
|
|
|
Cr |
Cost of Sales Account |
|
50 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CCOS: Cost of Sales entry on customer Credit Note. This driver is called when a user processes a Credit Note and the Cost of Sales needs to be reversed to the WIP account from the Cost of Sales account. This does not include Credit Notes for contract invoices. |
|||||||
|
Dr |
Work in Progress |
No |
NVAL |
Yes |
7800 |
|
|
|
Cr |
Cost of Sales |
Yes |
NVAL |
No |
2000 |
||
Segment Type Options
- CUST, DEMP, DSIT, IDEP, IDST, PTCA, SITE, WHSE
Contract Invoice (CTIN)
An invoice raised to a client during month end billing for contract fees (such as rental charges) and/or meter charges (minimum billing and meter copy charges). Contract invoices have only a Sales leg, not a Cost of Sales leg. The Cost of Sales information comes from the work order system.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Debtors Control Account |
114 |
|
|
|
Cr |
VAT Input Account |
|
14 |
|
|
Cr |
Sales Account (Segmented by Branch) |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CTIN: Contract invoice. This driver is called when a user processes a contract invoice. |
|||||||
|
Dr |
Debtors control Account |
No |
GVAL |
Yes |
8000 |
|
|
|
Cr |
VAT Input Tax |
No |
TVAL |
Yes |
9502 |
|
|
|
Cr |
Sales Account |
Yes |
NVAL |
Yes |
1100 |
|
|
|
|
|
|
|
|
|
|
|
|
Dr |
Sub Ledger against Customer Account |
|
GVAL |
N/A |
Customer code in customer age analysis |
N/A |
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE
Contract Credit Note (CTCN)
A credit that is raised against a Contract Invoice. This will post opposite entries to those raised for the Contract Invoice.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Sales Account (Segmented by branch) |
100 |
|
|
|
Dr |
VAT Output Account |
14 |
|
|
|
Cr |
Debtors Control Account |
|
114 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CTCN: Contract Credit Note. This driver is called when a user processes a Contract Credit Note. |
|||||||
|
Dr |
Sales Account |
Yes |
NVAL |
No |
1100 |
|
|
|
Dr |
VAT Output Tax |
No |
TVAL |
Yes |
9502 |
|
|
|
Cr |
Debtors Control Account |
No |
GVAL |
Yes |
8000 |
|
|
|
|
|
|
|
|
|
|
|
|
Dr |
Sub Ledger against Customer Account |
|
GVAL |
N/A |
Customer code in customer age analysis |
N/A |
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE
Debit Orders (IRCP)
Debit Orders will be processed into the General Ledger and Accounts Receivable account. The Customer must be set to payment type = ‘DO’.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Bank Account |
100 |
|
|
|
Cr |
Debtors Control Account |
|
100 |
|
|
Cr |
Customer Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
IRCP: Debit order This driver is called when invoices are printed (with auto debit order) |
|||||||
|
Dr |
Bank Account |
No |
NVAL |
Yes |
8400 |
|
|
|
Cr |
Debtors Control Account |
No |
GVAL |
Yes |
8000 |
|
|
|
|
|
|
|
|
|
|
|
|
Cr |
Sub Ledger against Customer Account |
|
GVAL |
N/A |
Customer code in customer age analysis |
N/A |
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE
Period Depreciation (PDEP)
BPO computes the depreciation due for the trading assets at any point in time. The system uses the depreciation method set on the underlying part definition and the depreciation start date on the actual asset to set the initial parameters for the depreciation of a machine. Subsequent revaluations will set the useful life of the machine and its relevant depreciation start date, which the system uses to determine the rate and from when an item will be depreciated.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Depreciation - Rental Equipment |
100 |
|
|
|
Cr |
Accumulated Depreciation |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PDEP: Period Depreciation - This driver is called when the monthly period depreciation is run. |
|||||||
|
Dr |
Depreciation |
No |
NVAL |
Yes |
3456 |
|
|
|
Cr |
Accum. Dep. |
No |
GVAL |
Yes |
6702 |
|
|
Segment Type Options
- PTCA, SITE
Reverse Period Depreciation (CDEP)
For recoupment of period depreciation, the transactions will be reversed.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Accumulated Depreciation |
100 |
|
|
|
Cr |
Depreciation - Rental Equipment |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
CDEP: Reverse Period Depreciation - This driver is called when the monthly period depreciation is run. |
|||||||
|
Dr |
Accum. Dep |
No |
NVAL |
Yes |
6702 |
|
|
|
Cr |
Depreciation |
No |
GVAL |
Yes |
3456 |
|
|
Segment Type Options
- PTCA, SITE
Revaluations - Issue (REVI)
Revaluations may be done manually or via depreciation processing.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Revaluation Suspense |
100 |
|
|
|
Cr |
Stock |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
REVI: Revaluation Issue - This driver is called when the user processes a stock revaluation |
|||||||
|
Dr |
Reval Susp. |
Yes |
GVAL |
Yes |
9998 |
|
|
|
Cr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Revaluation Return (REVD)
For Revaluation Return the transactions will be reversed.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Stock |
100 |
|
|
|
Cr |
Revaluation Suspense |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
REVD: Revaluation Return - This driver is called when the user processes a Stock Revaluation |
|||||||
|
Dr |
Inventory Control Account |
Yes |
NVAL |
Yes |
7700 |
|
|
|
Cr |
Reval Susp. |
Yes |
GVAL |
Yes |
9998 |
|
|
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
GRN Revaluation NGRN Portion (REVB)
The GRN Revaluation driver will clear the applied Non-Stock GRN cost amount from Non-Stock Work in Progress account and Revaluation Suspense account.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Revaluation Suspense |
100 |
|
|
|
Cr |
Non-Stock Work In Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
REVB: GRN Revaluation - This driver is called when the user approves a GRN revaluation |
|||||||
|
Dr |
Revaluation Suspense |
No |
GVAL |
Yes |
9998 |
|
|
|
Cr |
Non-Stock Work In Progress |
No |
NVAL |
Yes |
7810 |
|
|
Segment Type Options
- SITE, SUPP
Contract Invoice - Back to Back (CIBB)
When a contract with a Back to Back Finance (e.g. Rental is billed to client and paid to the finance house) is invoiced, the Finance Amount will be posted to the Back to Back Contract Invoices and Provision Accounts.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Back to Back Contract Invoices |
100 |
|
|
|
Cr |
Back to Back Provision Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
CIBB: Contract Invoice Back to Back - This driver is called when the user processes a Contract Invoice for a contract with a finance amount. |
|||||||
|
Dr |
B2B Ctrt Inv |
No | GVAL | No | 2130 |
|
|
|
Cr |
B2B Provision |
No | NVAL | Yes | 9110 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE
Contract Credit Note - Back to Back (CCBB)
When a Back to Back Contract Invoice is credited, the finance amount is cleared from the Back to Back Contract Invoices and Provision accounts.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Back to Back Provision Account |
100 |
|
|
|
Cr |
Back to Back Contract Invoices |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
CCBB: Contract Credit Note Back to Back - This driver is called when the user processes a Contract Credit Note for a contract with a finance amount. |
|||||||
|
Dr |
B2B Provision |
No | NVAL | Yes | 9110 |
|
|
|
Cr |
B2B Ctrt Inv |
No | GVAL | No | 2130 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE
Supplier Invoice - Back to Back (SIBB)
After a Back to Back Contract Invoice is raised, a Back to Back Supplier invoice must be processed in order to pay the financed amount to the finance house. The finance amount is cleared from the Back to Back Provision account and posted to Supplier Control.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Back to Back Provision Account |
100 |
|
|
|
Dr |
Vat Input Account |
14 | ||
|
Cr |
Supplier Control Account |
|
114 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
SIBB: Supplier Invoice Back to Back - This driver is called when the user processes a Back to Back Supplier Invoice for a Finance Amount Invoiced via Control Billing. |
|||||||
|
Dr |
B2B Provision |
No |
NVAL | Yes | 9110 |
|
|
|
Dr |
VAT Input Tax |
No |
TVAL | Yes | 9502 | ||
|
Cr |
Supplier Control Account |
No |
GVAL | Yes | 9000 | ||
|
Cr |
Sub Ledger against Supplier Account |
GVAL | N/A |
Supplier code in supplier age analysis |
N/A |
|
|
Segment Type Options
- PTCA, SITE, SUPP
Production Issue - Work Order (PSPD)
Stock items issued to a Work Order. This processes as a debit to Manufacturing Work In Progress and a credit to Inventory.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Prod: Manufacturing Work In Progress |
100 |
|
|
|
Cr |
Inventory Control Account |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PSPD: Production Stock Issue - This driver is called when the user issues stock to a Production Work Order for manufacturing. |
|||||||
|
Dr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
|
Cr |
Inventory Control Account |
No | NVAL | Yes | 7700 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE, WHSE
Production Part Return (PRPD)
Stock should not be returned from a Production Run. Stock issued to a Production Run will be considered 'consumed' during the manufacturing process.
Stock items returned to store from a Work Order. This processes as a debit to Inventory and a credit to Manufacturing Work In Progress.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Inventory Control Account |
100 |
|
|
|
Cr |
Prod: Manufacturing Work in Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PRPD: Production Part Return - This driver is called when the user returns stock from a production run. |
|||||||
|
Dr |
Inventory Control Account |
No | NVAL | Yes | 7700 |
|
|
|
Cr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, DSIT, PTCA, SITE, WHSE
Close Production Work Order - Non-Stock (CPWC)
When a Work Order is closed, after a Production Run, all costs for Non-Stock items on the Work Order will be processed to Manufacturing Subcontract Variance from Manufacturing Work in Progress. This amount will be cleared by PAJI / PADI (Finished Goods drivers). If the Product is configured to use the 'Unit Cost' of the underlying items, the entire amount will be cleared. If the Product is configured to use 'Std Price', the variance between the cost and standard price will remain in the Manufacturing Variance and will need to be journalled to the relevant general ledger account.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Prod: Manufacturing Variance - Contracts |
100 |
|
|
|
Cr |
Prod: Manufacturing Work In Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
CPWC: Close Production Work Order Contracts - This driver is called when the user finishes a production run - thus closing the production Work Order, where a subcontract exists. |
|||||||
|
Dr |
Prod Contract Variance |
No | NVAL | Yes | 2160 |
|
|
|
Cr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE
Close Production Work Order - Stock (CPWP)
When a Work Order is closed, after a Production Run, all costs for Stock items on the Work Order will be processed to Manufacturing Stock Variance from Manufacturing Work in Progress. This amount will be cleared by PAJI / PADI (Finished Goods drivers). If the Product is configured to use the 'Unit Cost' of the underlying items, the entire amount will be cleared. If the Product is configured to use 'Std Price', the variance between the cost and standard price will remain in the Manufacturing Variance and will need to be journalled to the relevant general ledger account.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Prod: Manufacturing Variance - Parts |
100 |
|
|
|
Cr |
Prod: Manufacturing Work In Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
CPWP: Close Production Work Order Contracts - This driver is called when the user finishes a production run - thus closing the production Work Order, where issued parts exist. |
|||||||
|
Dr |
Prod Part Variance |
No | NVAL | Yes | 2161 |
|
|
|
Cr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE, WHSE
Serialised Finished Goods (PADI)
After a production run, the cost of the manufactured serialised goods is cleared from Manufacturing Work in Progress and posted to the Inventory Control Account.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Inventory Control Account |
100 |
|
|
|
Cr |
Prod: Manufacturing Work In Progress |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PADI: Serialised Finished Goods - This driver is called when the user finishes a production run where serialised items were manufactured. |
|||||||
|
Dr |
Inventory Control |
No | NVAL | Yes | 7700 |
|
|
|
Cr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Non-Serialised Finished Goods (PAJI)
After a Production Run, the cost of the manufactured goods is cleared from Manufacturing Work in Progress and posted to the Inventory Control Account.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Inventory Control Account |
100 |
|
|
|
Cr |
Prod: Manufacturing Variance - Parts |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
PAJI: Non-Serialised Finished Goods - This driver is called when the user finishes a production run where non-serialised items were manufactured. |
|||||||
|
Dr |
Inventory Control Account |
No | NVAL | Yes | 7700 |
|
|
|
Cr |
Prod Parts Variance |
No | GVAL | Yes | 2161 |
|
|
Segment Type Options
- DEMP, DSIT, PTCA, SITE, WHSE
Open Production Work Order - Non-Stock (OPWC)
Production Work Orders cannot be re-opened once closed.
Re-opening a Work Order clears the Manufacturing Non-Stock Subcontract Variance account and posts the cost of the Subcontract to Manufacturing Work in Progress.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Prod: Manufacturing Work In Progress |
100 |
|
|
|
Cr |
Prod: Manufacturing Variance - Contracts |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
OPWC: Open Production Work Order Contracts - This driver is called when the user re-opens a production Work Order, where a Subcontract exists. |
|||||||
|
Dr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
|
Cr |
Prod Contract Variance |
No | NVAL | Yes | 2160 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE
Open Production Work Order - Stock (OPWP)
Production Work Orders cannot be re-opened once closed.
Re-opening a Work Order clears the Manufacturing Stock Variance account and posts the cost of the Subcontract to Manufacturing Work in Progress.
Transaction Posting
|
Dr/Cr |
Description |
Debit Amount |
Credit Amount |
|
|
Dr |
Prod: Manufacturing Work In Progress |
100 |
|
|
|
Cr |
Prod: Manufacturing Variance - Parts |
|
100 |
|
Transaction Setup
|
Dr/Cr |
Entry Description |
Item Target Account |
Value Type |
Ignore Segment |
Account Code |
Segment 1 Not used |
Segment 2 Not used |
|
|
|
|
|
|
|
|
|
|
OPWP: Open Production Work Order Parts - This driver is called when the user re-opens a production Work Order, where issued parts exist. |
|||||||
|
Dr |
Prod WIP |
No | GVAL | Yes | 7820 |
|
|
|
Cr |
Prod Part Variance |
No | NVAL | Yes | 2161 |
|
|
Segment Type Options
- CDPT, CUST, DEMP, PTCA, SITE, WHSE
MNU.200.001
