Troubleshooting: Duplicated opening balance for a serial number

Question: When making inquiry of Serial Number transaction, duplicated opening balance appears for a serial number?

Version: 1.8 / 1.9 / 2.0

Possible Reason:

The same serial number has been imported into Item Opening Balance.

Solution:

It is difficult to examine item opening balance one by one. Checking is easier by using SQL query:

1. Open SQL Management Studio and run the query as below:

select * from SerialNoTrans where FromSerialNo = '0PK013202432' or ToSerialNo='0PK013202432'

2. Retrieve the DtlKey from the query result and run the query as below:

select * from itemopening where Itemopeningkey in('2784791','2784977')

3. Remove one of the duplicated serial numbers from item opening balance. You may find the item serial number by following the seq 5 and 67.

By:KM 170712, 170713; P170801

Go to menu

AutoCount Accounting 2.0 & 2.1 AutoCount Accounting 2.0 What's New AutoCount Accounting 2.0 Help File AutoCount Accounting 2.0 FAQ (Application) AutoCount Accounting 2.0 FAQ (Troubleshoot) AutoCount Accounting 2.0 Others AutoCount Accounting 2.0 Release Note AutoCount Accounting 2.1 Release Note

AutoCount Accounting 1.8 / 1.9 AutoCount Accounting 1.8 FAQ (Application) AutoCount Accounting 1.8 FAQ (Troubleshoot) AutoCount Accounting 1.8 / 1.9 Release Note

AutoCount Payroll

AutoCount POS

AutoCount On The Go

AutoCount Accounting Plug-In Documentations