Item History records using wrong source
Paul Timms
6-29-18
What could be the cause of the following issue?


Goods receipt no.1, of item A with batch no. 123, qty 100.
Delivery no.1, of item A, batch no. 123, qty 60.
Goods receipt no. 2, of item A with batch no. 456, qty 100.
Delivery no.2, of item A, batch no. 456, qty 40.

Delivery no.3 of item A, batch no. 123, qty 40.

In the Item History Support Register:

- Delivery no.1 shows the source as goods receipt no.1, which is correct.
- Delivery no.2 shows the source as goods receipt no.1, which is incorrect.
- Delivery no.3 shows a blank source.

The FIFO on delivery no.3 is blank, therefore nothing is posted to stock or cost of sales. However, comparing the stock list values, the stock sub-ledger has reduced by the correct cost. This has caused an imbalance between the TB and the stock sub-ledger.

On rebuilding stock, with only the first box ticked, the sources are corrected.
Leave Comment
You can subscribe to notifications for this post by selecting the 'star' icon on the top right corner of the post.
Latest Posts
Carolina Valentino
are the activity set as Hansamanuals said? https://www.hansamanuals.com/main/mailnumber___62526/theconf___231/manuals/version___20250224/langcode___es/hwconvindex.htm?shortcode=HW0301SETTINGS_Order...
17:20 4 Apr 2025
Paul Timms
SendWebRequest3 is a boolean function, so if this returns true and the reply header has an accepted status, you can assume that the data was sent successfully and perform some actions on the record th...
11:12 4 Apr 2025