Wrong information in serial number transactions report

[Former Member]

Hi,

Customer is using 2007A PL30. Same day user had done 2 inventory transfer for serialised item

1st Inventroyr transfer 3 unit from warehouse A to warehouse B. Eg S/N=A1, A2, A3

2nd Inventory transfer 2 unit from warehouse A to warehouse B. [user is able to select S/N A1 and A2 again]

Problem:

1. Why system allows to select S/N A1 and A2 from warehouse A for second Inventory transfer?

2. In Serial Number Transactions report for 2nd Inventory transfer, it is showing both From and To warehouse equals warehouse B. We drill from navigation arrow in document, the From warehouse=warehouse A and To warehouse=warehouse B

3. In Inventory posting report, it is showing correct information for both From(warehouse A) and To(warehouse B).

Did anyone encounter such problem?

Regards

Thomas

[Former Member]

Your 2007A PL version is too low. Upgrade your PL to latest version ASAP. A lot of application errors has been corrected in new PL.

Thanks,

Gordon

[Former Member]

I had upgraded customer database to PL47 internally. The problem is still the same. Serial Number Transactions reports and In stock are still not matching. It is confirmed that all inventory reports(eg inventory valuation, inventory posting list report, inventory in warehouse report are correct but serial number transaction report is wrong)

By the way, can I have query to extract from serial table where transaction type=Inventory transfer, document number are the same, the in and out warehouse are the same?

We need to find out how many stock are being affected rather than the one reported by customer.

Regards

Thomas

[Former Member]

It is possible by query. However, it is not that simple because the complicated logic between those tables involved.