Category:AutoCount Accounting 1.8:FAQTroubleshoot: Difference between revisions
Category:AutoCount Accounting 1.8:FAQTroubleshoot (view source)
Revision as of 01:51, 31 January 2024
, 3 months ago→Sales
(→SQL) |
(→Sales) |
||
| (44 intermediate revisions by the same user not shown) | |||
Line 51:
#[[Troubleshooting: Same documents no. repeated in Cash Book grid |Same documents no. repeated in Cash Book grid]] -(CT/LS/P)
#[[Troubleshooting: Closing Stock amount in Profit & Loss Report not same as Stock Value Maintenance amount (Not using Live Stock) |Closing Stock amount in Profit & Loss Report not same as Stock Value Maintenance amount (Not using Live Stock)]] -(PY/LS/P)
#[[Troubleshooting: Unable to delete account because it contains one or more sub-accounts |Unable to delete account because it contains one or more sub-accounts]] -(PY/LS/P)
#[[Troubleshooting: Cash Flow Statement - Cash beginning + Net cash change not equal to Cash at end of the period |Cash Flow Statement - Cash beginning + Net cash change not equal to Cash at end of the period]] -(PY/LS/P)
#[[Troubleshooting: Depreciation & Net Book Value Report-This Year Depreciation amount is not shown |Depreciation & Net Book Value Report-This Year Depreciation amount is not shown]] -(PY/LS/P)
#[[Troubleshooting: Trial Balance and Balance Sheet is not balance |Trial Balance and Balance Sheet is not balance]] -(Jod/LS/P)
==AR/AP==
Line 104 ⟶ 108:
#[[Troubleshooting:System did not prompt Access Denied when edit AR Receive Payment|System did not prompt Access Denied when edit AR Receive Payment]] -(PY/LS/P)
#[[Troubleshooting:Unable to send batch mail-An error occurred while attempting to establish an SSL or TLS connection|Unable to send batch mail-An error occurred while attempting to establish an SSL or TLS connection]] -(CT/LS/P)
#[[Troubleshooting: Debtor Statement error - This constraint cannot be enabled as not all values have corresponding parent values|Debtor Statement error - This constraint cannot be enabled as not all values have corresponding parent values]] -(CT/LS/P)
#[[Troubleshooting: System prompt Set Project/Department Posting screen even the gain/loss amount is zero|System prompt Set Project/Department Posting screen even the gain/loss amount is zero]] -(Jul/LS/P)
#[[Troubleshooting: Different UserID drill down document showing different behavior|Different UserID drill down document showing different behavior]] -(PY/LS/P)
#[[Troubleshooting: No result when inquiry A/P Credit Note Analysis Report|No result when inquiry A/P Credit Note Analysis Report]] -(Jod/LS/P)
==Stock==
Line 151 ⟶ 159:
#[[Troubleshooting: Copy and paste from Excel – Invalid number format at column SubTotal, row 1 |Copy and paste from Excel – Invalid number format at column SubTotal, row 1]] -(Ben/LS/P)
#[[Troubleshooting: Unable to save Stock Assembly Order - Quantity for transferred is exceed limit |Unable to save Stock Assembly Order - Quantity for transferred is exceed limit]] -(CT/LS/P)
#[[Troubleshooting: Stock Item Inquiry error-Input string was not in a correct format |Stock Item Inquiry error-Input string was not in a correct format]] -(Aimi/LS/P)
#[[Troubleshooting: Inquiry Stock Movement report error-Unknown Sql Exception (Number=207, Message=Invalid column name ‘TypeofStockIn’ |Inquiry Stock Movement report error-Unknown Sql Exception (Number=207, Message=Invalid column name ‘TypeofStockIn’]] -(Jod/LS/P)
#[[Troubleshooting: Stock Item Maintenance up to date cost shows no records although there is stock balance quantity |Stock Item Maintenance up to date cost shows no records although there is stock balance quantity]] -(CT/LS/P)
#[[Troubleshooting: Stock Aging / Stock Movement Report – Item appears twice / item has transaction record but is not shown in the report |Stock Aging / Stock Movement Report – Item appears twice / item has transaction record but is not shown in the report]] -(CT/LS/P)
#[[Troubleshooting: Item Opening Balance Maintenance error – Location is not in the Filter range |Item Opening Balance Maintenance error – Location is not in the Filter range]] -(CT/LS/P)
#[[Troubleshooting: Not allowed to cancel Stock Assembly Order-The document was transferred to other documents, so it is not allowed to cancel |Not allowed to cancel Stock Assembly Order-The document was transferred to other documents, so it is not allowed to cancel]] -(Jod/LS/P)
==Sales==
Line 232 ⟶ 246:
#[[Troubleshooting: Unable to create New Payment from Invoice |Unable to create New Payment from Invoice]] -(Jul/LS/P)
#[[Troubleshooting: Preview report shows duplicated detail records |Preview report shows duplicated detail records]] -(SW/LS/P)
#[[Troubleshooting: Unit Price is different when copy from or copy to another Sales Order |Unit Price is different when copy from or copy to another Sales Order]] -(Rot/LS/P)
#[[Troubleshooting: Incorrect detail total after key in Unit Price |Incorrect detail total after key in Unit Price]] -(CT/LS/P)
#[[Troubleshooting: Missing document for certain locations when login with different user |Missing document for certain locations when login with different user]] -(CW/LS/P)
==Purchase==
Line 247 ⟶ 264:
#[[Purchase: Missing records at Price History tab of Purchase Invoice|Missing records at Price History tab of Purchase Invoice]] -(Aimi/LS/P)
#[[Purchase: Serial Number windows not prompted when I select Serial Number Item|Serial Number windows not prompted when I select Serial Number Item]] -(SW/LS/P)
#[[Purchase: Why will the system auto update Goods Received Note unit price|Why will the system auto update Goods Received Note unit price]] -(Jod/LS/P)
==GST==
Line 299 ⟶ 317:
#[[Troubleshooting: SST-02 is not appeared after ran SST Processor |SST-02 is not appeared after ran SST Processor ]] -(Ell/LS/P)
#[[Troubleshooting: Commit SST Processor error – Duplicate Journal Entry No |Commit SST Processor error – Duplicate Journal Entry No ]] -(CT/LS/P)
#[[Troubleshooting: SST Processor error-Cannot set column TaxBRNo. The value violates the MaxLength limit of this column |SST Processor error-Cannot set column TaxBRNo. The value violates the MaxLength limit of this column]] -(Aimi/LS/P)
==Prompted Message==
Line 420 ⟶ 439:
#[[Troubleshooting: Unable to open Consolidated Financial Report – Invalid DDL Statement . . . Cannot find the object “dbo.ConsolidateProfile” because it does not exist or you do not have permissions |Unable to open Consolidated Financial Report – Invalid DDL Statement . . . Cannot find the object “dbo.ConsolidateProfile” because it does not exist or you do not have permissions]] -(Aimi/LS/P)
#[[Troubleshooting: Restore error-Unknown Sql Exception (Number=3169), Message=The database was backed up on a server running version XX.XX.XXXX |Restore error-Unknown Sql Exception (Number=3169), Message=The database was backed up on a server running version XX.XX.XXXX]] -(TN/LS/P)
#[[Troubleshooting: Backup error – The database could not be exclusively locked to perform the operation |Backup error – The database could not be exclusively locked to perform the operation]] -(CT/LS/P)
#[[Troubleshooting: Import AP Invoice error - SupplierInvoiceNo the require column is empty |Import AP Invoice error - SupplierInvoiceNo the require column is empty]] -(PY/LS/P)
#[[Troubleshooting: Backup error - Unknown Sql Exception Number=8921… A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent |Backup error - Unknown Sql Exception Number=8921… A failure was detected while collecting facts. Possibly tempdb out of space or a system table is inconsistent]] -(Jod/LS/P)
#[[Troubleshooting: Export report error – Specified argument was out of the range of valid value. Parameter name:MinimumSize |Export report error – Specified argument was out of the range of valid value. Parameter name:MinimumSize]] -(CT/LS/P)
#[[Troubleshooting: Installation error - The installer has encountered an unexpected error installing this package...The error code is 2932|Installation error - The installer has encountered an unexpected error installing this package...The error code is 2932]] -(Ben/LS/P)
#[[Troubleshooting: Backup Error - The server does not allow client to backup or restore database|Backup Error - The server does not allow client to backup or restore database]] -(Chr/LS/P)
#[[Troubleshooting: Restore error - The process cannot access the file… because it is being used by another process|Restore error - The process cannot access the file… because it is being used by another process]] -(PY/LS/P)
#[[Troubleshooting: Backup error - File create error when creating RAR file. If Backup filename contain unicode or chinese character|Backup error - File create error when creating RAR file. If Backup filename contain unicode or chinese character]] -(CT/LS/P)
#[[Troubleshooting: Unable to attach database file-Login failed. Incorrect password|Unable to attach database file-Login failed. Incorrect password]] -(CT/LS/P)
#[[Troubleshooting: Change Project Number error-String or binary data would be truncated|Change Project Number error-String or binary data would be truncated]] -(PY/LS/P)
#[[Troubleshooting: Database Maintenance error - Unknown Sql Exception-Incorrect syntax near '-'|Database Maintenance error - Unknown Sql Exception-Incorrect syntax near '-']] -(CT/LS/P)
#[[Troubleshooting: Stock Adjustment error - Primary Key Error|Stock Adjustment error - Primary Key Error]] -(PY/LS/P)
#[[Troubleshooting: Unable to Save Invoice - Every item needs to be assigned a location|Unable to Save Invoice - Every item needs to be assigned a location]] -(Jod/LS/P)
#[[Troubleshooting: Find or Search Item error - Execution Timeout Expired|Find or Search Item error - Execution Timeout Expired]] -(James/LS/P)
#[[Troubleshooting: Restore error-The Server Backup Shared Folder and the Client Access Shared Folder Path does not point to same folder...Operating system error 5(Access is denied)|Restore error-The Server Backup Shared Folder and the Client Access Shared Folder Path does not point to same folder...Operating system error 5(Access is denied)]] -(James/LS/P)
#[[Troubleshooting: Unable to Save Invoice-Unable to generate a new tax document number from default set|Unable to Save Invoice-Unable to generate a new tax document number from default set]] -(James/LS/P)
==Login Issue==
Line 447 ⟶ 482:
#[[Troubleshooting: Login error - Unknown Sql Exception (Number=823, Message=The operating system returned error 21(The device is not ready) |Login error Unknown Sql Exception (Number=823, Message=The operating system returned error 21(The device is not ready)]] -(TN/LS/P)
#[[Troubleshooting: Login error - Unknown Sql Exception (Number = 102, Message=Incorrect syntax near ’)’.) |Login error - Unknown Sql Exception (Number = 102, Message=Incorrect syntax near ’)’.)]] -(Jod/LS/P)
#[[Troubleshooting: Upgrade AutoCount error-Invalid DDL Statement /* Add AccountingBasis column in Tax Type table*/ |Upgrade AutoCount error-Invalid DDL Statement /* Add AccountingBasis column in Tax Type table*/]] -(Aimi/LS/P)
#[[Troubleshooting: Login Error - Cannot open database “AED_xxx” requested by login and the database in Recovery Pending status |Login Error - Cannot open database “AED_xxx” requested by login and the database in Recovery Pending status]] -(PY/LS/P)
#[[Troubleshooting: Login Error - The password of the account has expired |Login Error - The password of the account has expired]] -(Aimi/LS/P)
==SQL==
Line 468 ⟶ 506:
#[[Troubleshooting: Unable to start SQL Server services |Unable to start SQL Server services ]] -(CT/LS/P)
#[[Troubleshooting: SQL Server setup failure - Setup encountered a failure while running job UpdateResult. Error code 0x876E0003 |SQL Server setup failure - Setup encountered a failure while running job UpdateResult. Error code 0x876E0003 ]] -(TN/LS/P)
#[[Troubleshooting: SQL Server installation error-There is a problem with this Windows Install package. A DLL required for this installation… |SQL Server installation error-There is a problem with this Windows Install package. A DLL required for this installation… ]] -(CT/LS/P)
#[[Troubleshooting: SQL Server Configuration Manager – Access is denied when enable TCP/IP |SQL Server Configuration Manager – Access is denied when enable TCP/IP ]] -(CT/LS/P)
==Other==
Line 523 ⟶ 563:
#[[Troubleshooting: Unable to see Master I and Master II in Export All Data |Unable to see Master I and Master II in Export All Data ]] -(Rot/LS/P)
#[[Troubleshooting: Create document take longer time to response? |Create document take longer time to response? ]] -(Jul/LS/P)
#[[Troubleshooting: Unable to find K.I.V Invoice in Open K.I.V Folder |Unable to find K.I.V Invoice in Open K.I.V Folder ]] -(Jod/LS/P)
#[[Troubleshooting: Find Panel-Unable to auto filter results |Find Panel-Unable to auto filter results ]] -(Jod/LS/P)
{{NavigateForUser}}
| |||