List Screen Status and Error Codes - Powerful Codes to Manage Transactions

List Screen Error and Status Codes Codes Overview

When a list of items appears on the screen, SapphireOne will display various error and/or status codes. Some of these codes are normal during transaction processing, while others indicate errors. Error codes are shown when the standard inquiry list screen is in use. If the user has selected the optional ‘Swap to Custom Inquiry’ button Swap to a Custom Inquiry- Button and used the ‘Setup’ button Setup-Button to choose the columns to populate the list, they may opt to display the Status column. This column includes the Status Number as detailed in the table below. To obtain extended details of an error, the user must open the transaction for modification and examine the Information Tabs area.

Posted Status Details
Ent:  -2  The line has been entered correctly and is ready to be posted.  The transaction is as yet Un-posted and Modifiable
Err: -1 Error in posting Modifiable. Will not post until the error has been corrected. (Check remainder of this section for details
No:  Un-posted (Modifiable). SapphireOne is deciding as to what posted status it is to place on the transaction. 
Yes:  Posted. The line has been correctly entered and has been posted. 
Hist:  Record to go to History. 
Wait:  Waiting to be posted. 
Lock:  Record in use while trying to update. Will post in next posting run. 
Later:  Waiting to be posted via the activity Queue button. 
7  Indicates a payment process stage where the payment is created and printed (with the check box selected), and an ABA file is generated, but it has not yet been posted.
Rec:  Waiting to be Reconciled but already posted. 
Work:  12  Currently Processing un-posted. The line is being posted now. 
Inwards Goods:  13  Not normally displayed as 13 is the transactions status when the transaction is an Inwards Goods transaction. No effect on anything and can be ignored. 
Print:  Preparing to print 
New:  This code will appear while data is being entered.  That is before the green tick becomes active. 
Dup:  Duplicate transaction in the list. 
WF:  Transaction requires Work Flow authorisation. 

Additional Posting Error Codes

Transactions may fail to post due to an additional error. While it should be uncommon to see these errors in a properly managed data file, they do occur. Below is a condensed list of common error codes.

P:  Locked Period. 
L:  Locked Record. 
C:  Invalid control account. 
PJ:  Project required. 
PER:  Period error. An invalid period has been entered and it may indicate damage to the data file. Please check with SapphireOne support staff immediately.

Control Tab Error Codes within SapphireOne 

The error codes listed below will be posted within the Controls and Error Tabs of the information section when conducting transactions in SapphireOne.

Code Description
AC  Clients Inactive 
ACT  Activity Link 
ADO  Asset Depreciation is Over the cost of the item. 
AV  Vendors Inactive 
BA  Bank Account 
BAY  Bay Error 
BC  Bank Account & Transaction Currencies are different. 
BL  Build Line Error 
Client name not valid 
CA  Control Account 
CL  Credit Limit 
CN  Invalid Cheque Number 
CNA  Invalid Cheque Number 
CONV  Converting an Order 
CT  Control Account 
CX  Tax Control Account 
EX  External Ref. Error 
DA  Duplicate Adjustment lines. (Same inventory used twice in an ADJ). 
DC  Different Company 
DEL  Deleted Posted Record 
DQ  Totals Don’t Balance 
General Ledger Not Valid 
GX  General Ledger Account not found 
HJ  History Journal Lines 
Inventory Error 
IBA  Invalid Bank Account 
IC  Inter Company 
IL  Invoice Lines don’t exist 
JOB  Journal Lines created don’t balance 
Locked Invoice 
LD  Location Missing Department 
LDI  Locked Invoice processing an Order 
LIN  Locked Inventory processing a Order 
LOC  Locked file … filename 
Lp  Locked Period (Note the lowercase “p”) 
LP  Locked Period (Note the Uppercase “P”) 
LPR  Locked Project 
LT  Locked Transaction 
LV  Locked Invoice calculating Unposted 
NG  Negative Stock Error 
OB  Out of Balance 
Period not valid 
P1  Error in Activities file in an Invoice 
PER  Period Error 
PER0  Period 0 Journal 
PJ  Project Required 
PR  Project Error 
QTY  Quantity Error 
REF  Internal Ref. Error 
RS  Resource Link 
SB  Stock Breakdown 
SBA  System Unable to write current Transaction to History. 
SGL  GL Name not valid 
SN  Serial No. Error 
SNUP  Serial Number Un Posted 
SNID  Serial Number ID. Error 
SNL  Serial Numbers Don’t balance 
SNS  Serial Number sold greater than quantity available 
SNT  Serial Number Link Error 
SP  Sales Person Error 
TBQ  Table Matrix Quantity 
TK  Item Errored by Tran Audit 
TN  When the total is less than 0 
TOT  Total Error 
TR  Transaction already exists in Accounts 
UA  Un-posted stock adjustment for Inventory (ADJ). 
WF  Workflow restriction. Transaction must be authorised. 
XL  Invoice Lines created incorrectly 
Vendor name not valid 

You can review our Blog and YouTube channel for additional information and resources on SapphireOne ERP, CRM and Business Accounting software.

Was this helpful?