Trouble Shooting Summary

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

https://datatrees.com.my/gltroubleshoot-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

https://datatrees.com.my/return-cheque-error-troubleshoottotal-returned-cheques-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

https://datatrees.com.my/bank-reconciliation-errortroubleshoot-invalid-number-format-in-actual-bank-statement-balance/

User-Defined Account Type shows negative amount in Balance Sheet

https://datatrees.com.my/gltroubleshoot-user-defined-account-type-shows-negative-amount-in-balance-sheet/

Unable to delete account reason is the account has been used in Location

https://datatrees.com.my/gltroubleshootunable-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

https://datatrees.com.my/gltroubleshootamount-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

https://datatrees.com.my/gl-troublesshoot-column-ref-2-shows-nothing-when-there-is-a-negative-amount/

Amount from previous month is not brought forward to current month

https://datatrees.com.my/balance-sheet-troubleshoot-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

https://datatrees.com.my/troubleshoot-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

https://datatrees.com.my/troubleshoot-unable-to-retrieve-last-year-figure-when-preview-pl-this-year-vs-last-year/

Preview Profit & Loss error – ’1 is not supported code page, parameter name: codepage’

https://datatrees.com.my/troubleshoot-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

https://datatrees.com.my/troubleshoot-arcn-didnt-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

https://datatrees.com.my/troubleshootcant-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

https://datatrees.com.my/error-messagetroubleshoot-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

https://datatrees.com.my/trouble-shooting-of-login-error-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

https://datatrees.com.my/unable-to-start-sql-server-service-due-to-tcp-port-is-already-being-used-troubleshoot/

SQL Server installation error – Wait on the Database Engine recovery handle failed

https://datatrees.com.my/trouble-shooting-of-sql-server-installation-error-wait-on-the-database-engine-recovery-handle-failed/

There are validation error on this page…Attributes not match

https://datatrees.com.my/trouble-shooting-of-sql-installation-error-there-are-validation-error-on-this-pageattributes-not-match/

SQL Server Configuration Manager – Cannot connect to WMI provider

https://datatrees.com.my/trouble-shooting-of-sql-server-configuration-manager-cannot-connect-to-wmi-provider/

Is not a valid argument or you do not have permission

https://datatrees.com.my/trouble-shooting-of-sql-installation-error-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/