Sales Trouble Shooting
Unable to save invoice – The following stock items are negative quantity, save aborted
No result when inquiry Customer Price Listing
Outstanding value is blank in Purchase Invoice or Invoice
Couldn’t find debtor when creating invoice
Couldn’t select credit card account in cash sale
Unable to select preview option
Duplicate Invoice no
Unable to delete Sales Invoice
Filter by Salesman – Sales agent can access other agent’s customers
Unable to preview or print a printed document
Sales amount different between Multi-Dimensional Sales Analysis Report and Monthly Sales Analysis Report
Item selling price does not follow the setting in Item Price Book
Can’t change the price of invoice that was transferred from DO
Invoice grid listing is not displayed
Save Invoice error – ‘Invalid account no’
Unable to select stock code in Monthly Sales Analysis report
Can’t change rounding method for invoice
Show Instant Info – Price History is empty
“Credit Sales” button is disabled in Cash Sales
Unable to save an entry/document with GST adjustment
Rounding Adjustment Account is empty
Stock Trouble Shooting
Up-To-Date Cost showed in alphabets
Missing Posting Accounts Tab at Stock Group Maintenance
Not a valid Tab Delimited Text Format or not an Stock Transfer import text format
Stock Balance Quantity in batch number selection not tallied with balance quantity in Stock Card
Why Real Cost is empty
Stock Card average cost not the same as Item Maintenance Up to Date Cost
Stock Adjustment not reflect to stock card report
Column ‘Loc-1Qty’ does not belong to table StockBalByLocation
Incorrect Outstanding PO quantity at Stock item inquiry
Average balance cost different with purchase invoice cost
Missing item in BOM Listing Report
There is a balance cost for zero quantity stock
System do not prompt alert when item sold below minimum selling price
System can sell item package with the item in back order status
Items not shown when inquiry Re-order Advice Report
Unable to find menu of stock transfer
Preview Stock Issue Detail Listing – Unknown Sql Exception
Unable to find item to be transferred from Sales Order to Stock Assembly Order
System still deduct stock after ‘Post To Stock’ access rights was removed
In July Stock Aging Report, stock quantity is “zero” but the cost value is not “0.00”?
Can’t view item image at client pc
Duplicated opening balance for a serial number
Can’t find More Stock Maintenance on Stock menu
Could not delete Item Code
AR/AP Trouble Shooting
Error when inquiry Debtor Aging report
Red colour indicator in A/R Invoice
Missing the options of Show in Creditor & Local Currency By Document and Show Local Currency
The official receipt no. is already exist, please enter another value
The value of column ForfeitedAccNo in table A/P Deposit does not exist in its master file
The value of column AccNo in table ItemPrice does not exist in its master file
Access rights to Print AP Payment is already granted but still not able to print
Past Invoice is not shown in Debtor Statement
Payment received but commission is not included in Commission by Collection Report
Outstanding Invoice fall on wrong month column in Debtor Aging Report
Error message prompted “Transferred amount overflow in updating ARDeposit (DocKey=1127) when save AR Receive Payment
Invoice not shown in A/R Outstanding Invoice
Unable to delete the document as it has been processed by payment voucher with imported goods
Unable to find the menu of A/R Deposit
This document was posted from A/P Payment, you must go A/P Payment to delete it
Drop down list for Currency is hidden in debtor maintenance
How to merge currency (RM&MYR) due to contra issue
Knock off date must be on or after payment and document date
Please empty tax registration number’ after filled in the column of Tax Registration No.
No result when inquiry Debtor Statement
Document date is set to maximum date
Message box ‘please select a deposit document for the payment method’ prompted when select payment method in AR Receive Payment
Unable to select deposit account in New A/R Deposit
Unable to save a new ARCN
https://datatrees.com.my/ar-aptroubleshootunable-to-save-a-new-arcn/
Can’t edit A/R Payment after added exception
https://datatrees.com.my/gltroubleshootcant-edit-a-r-payment-after-added-exception/
ARCN record not found
https://datatrees.com.my/year-end-error-troubleshoot-arcn-record-not-found/
Unable to edit currency exchange rate in AP Invoice
https://datatrees.com.my/ar-aptroubleshoot-unable-to-edit-currency-exchange-rate-in-ap-invoice/
Contra Entry not allowed for different currencies
https://datatrees.com.my/ar-aptroubleshoot-contra-entry-not-allowed-for-different-currencies/
Report Design – dragged field not shown in PV
https://datatrees.com.my/ar-aptroubleshoot-contra-entry-not-allowed-for-different-currencies/
https://datatrees.com.my/gltroubleshoot-report-design-dragged-field-not-shown-in-pv/
AR Payment in local currency but prompted for Gain/Loss setting
Can’t save past AR Invoice
https://datatrees.com.my/gltroubleshoot-cant-save-past-ar-invoice/
Can’t select Project No. in AP Invoice Entry
https://datatrees.com.my/gltroubleshootcant-select-project-no-in-ap-invoice-entry/
Unable to Save a new Contra
https://datatrees.com.my/ar-aptroubleshootunable-to-save-a-new-contra/
You are not allowed to edit documents from other source.
https://datatrees.com.my/ar-aptroubleshootyou-are-not-allowed-to-edit-documents-from-other-source/
Aging Report-The value of Total is not Shown
https://datatrees.com.my/ar-aptroubleshootaging-report-the-value-of-total-is-not-shown/
GL Trouble Shooting
Total Returned Cheque’s Payment Amount not equal to Total RCHQ Amount
Sales account has figure but drill down it shows empty
https://datatrees.com.my/gltroubleshoot-sales-account-has-figure-but-drill-down-it-shows-empty/
Unable to edit Stock Value Maintenance
https://datatrees.com.my/gltroubleshoot-unable-to-edit-stock-value-maintenance/
Failed to delete Foreign Currency Revaluation
https://datatrees.com.my/gltroubleshootfailed-to-delete-foreign-currency-revaluation/
Invalid number format in Actual Bank Statement Balance
User-Defined Account Type shows negative amount in Balance Sheet
Unable to delete account reason is the account has been used in Location
Other Expenses Account not show in Profit & Loss Report
https://datatrees.com.my/gltroubleshootother-expenses-account-not-show-in-profit-loss-report/
Transaction show twice in bank reconciliation
https://datatrees.com.my/gltroubleshoottransaction-show-twice-in-bank-reconciliation/
Amount in ledger showing 0 balance, but it is not 0 in bank reconciliation
Non-Leaf Accounts error when click on Opening Balance
https://datatrees.com.my/gltroubleshoot-non-leaf-accounts-error-when-click-on-opening-balance/
Discrepancy of amount when show up to level is different
https://datatrees.com.my/gl-troubleshoot-discrepancy-of-amount-when-show-up-to-level-is-different/
Column Ref. 2 shows nothing when there is a negative amount
Amount from previous month is not brought forward to current month
Stock Value Maintenance – Do not Translate
https://datatrees.com.my/stock-value-maintenancetroubleshootdo-not-translate/
Unable to delete account xxx-xxx because it has amount in Year-To-Date balance
Balance Sheet amount not tally with Creditor Aging Amount
https://datatrees.com.my/troubleshootbalance-sheet-amount-not-tally-with-creditor-aging-amount/
Unable to find menus of G/L, A/R, A/P
https://datatrees.com.my/troubleshootunable-to-find-menus-of-g-l-a-r-a-p/
Unable to retrieve last year figure when preview P&L this year vs last year
Preview Profit & Loss error – ’1 is not supported code page, parameter name: codepage’
Can’t create or move sub account under fixed asset account
https://datatrees.com.my/troubleshoot-cant-create-or-move-sub-account-under-fixed-asset-account/
ARCN didn’t specify project no, but project no appears in ledger report
Taxation Account is not shown in P&L Statement
https://datatrees.com.my/troubleshoot-taxation-account-is-not-shown-in-pl-statement/
Bank Account not appeared in Bank Reconciliation
https://datatrees.com.my/troubleshoot-bank-account-not-appeared-in-bank-reconciliation/
Can’t select different PV/OR numbering format during create new PV/OR
No account description shown Profit & Loss Statement
https://datatrees.com.my/troubleshootno-account-description-shown-profit-loss-statement/
Journal entry not balance by project or department
Login Issue
Could not find a part of the path ‘Z:\A2006.dmf’
https://datatrees.com.my/error-messagetrouble-shoot-could-not-find-a-part-of-the-path-za2006-dmf/
The type initializer for ‘System.Data.SqlClient.SqlCOnnection’ threw an exception
SQL Problem
Unable to start SQL Server Service due to TCP Port is already being used
SQL Server installation error – Wait on the Database Engine recovery handle failed
There are validation error on this page…Attributes not match
SQL Server Configuration Manager – Cannot connect to WMI provider
Is not a valid argument or you do not have permission
“Fusion ATL” rule failed
https://datatrees.com.my/trouble-shooting-of-sql-server-installation-error-fusion-atl-rule-failed/
View Server State permission was denied
https://datatrees.com.my/trouble-shooting-of-upgrade-error-view-server-state-permission-was-denied/
SQL Server Service Broker is not enabled
https://datatrees.com.my/trouble-shooting-of-upgrade-error-sql-server-service-broker-is-not-enabled/
Forgot SA password
https://datatrees.com.my/trouble-shooting-of-forgot-sa-password/
Login Failure
The system needs to upgrade your current account book
https://datatrees.com.my/trouble-shooting-of-need-to-upgrade-account-book/
Database version is later than supported database
https://datatrees.com.my/trouble-shooting-of-database-version-is-later-than-supported-database/
Critical SQL Exception
https://datatrees.com.my/trouble-shooting-of-critical-sql-exception/
Login Failure after server change
https://datatrees.com.my/trouble-shooting-of-login-failure-after-server-change/
Database file is compressed
https://datatrees.com.my/trouble-shooting-of-database-file-is-compressed/
Cannot open database
https://datatrees.com.my/trouble-shooting-of-cannot-open-database/
Database Problem
Suspected Database
https://datatrees.com.my/trouble-shooting-of-suspected-database/
Unable to attach suspected database
https://datatrees.com.my/trouble-shooting-of-unable-to-attach-suspected-database/
Database Connection Problem
https://datatrees.com.my/trouble-shooting-of-database-connection-problem/
Installation Problem
Windows keep restarting
https://datatrees.com.my/trouble-shooting-of-windows-keep-restarting/
The SQL Server service failed to start
https://datatrees.com.my/trouble-shooting-of-sql-server-failed-to-start/
SQL Server 2005 Setup unable to install
https://datatrees.com.my/trouble-shooting-of-installation-sql-server-2005/
Other Reason-Failed to install SQL
https://datatrees.com.my/trouble-shooting-of-installation-sql/