Questions Historical Goods in Transit?

Hi,

Hope everyone are well!

I’m new at the forum, I’ve tried to look if there already was a topic like this, but I couldn’t find any.

We’re trying to make a inquiry that can follow-up Goods in transit (Account called 1411 in Sweden). There is one report for that as standard, but the problem is that you can’t look historically. That’s the issue that we’re trying to assess. (Picture - Goods in Transit)

The table that the report ”Goods in transit” are using is ”=Sum([INTransferStatus.QtyOnHand])” but if i make a look up on that it only lists the goods that actually are in transit. The table doesn’t seem to store historical data, that's problem no 1.

Now to problem no 2: Our thought is that to match the outgoing transfer with the in going receipt we need to match the ID that creates with the outgoing one. The in going transfer refers to that one via "INRegister", ”TransferID”. But when we list the table and TransferID, the cell is empty, despite there being a value if we look at the actual transaction (Ingoing receipt). (Picture Transfer1, Recipt1 and Inquiry)

-

-

Is there anyone that have had the same problem, that could shed some light at the issue? Pretty much how to match the outgoing transfer to the ingoing reciept.

Thanks in advance!

Best regards,
Oskar, Direktkonsult in Gothenburg, Sweden.