Implement URN traceability across POP, Stock and financial ledger

At present the system does not track POP entries across stock history and financial ledgers.

There are 2 scenarios to consider.

a) prices updated at invoice received.

This should in principle be straight forward as the invoice entry generates the stock history and it should therefore be possible to link the URN against the stock transaction, which then allows traceability across all related ledgers.

b) prices updated at goods received.

I confess this will require some more thought as to how this could be achieved, however, if we consider that we can trace cost of sales transactions for SOP entries via the movement balance tables then surely it should be possible to track GRN entries via the movement balance table also and therefore associate URNs.

This is a major issue for stock valuation and reconciliation and a lot of our customers struggle to reconcile their stock valuation to their balance sheet accounts, which is a basic accounting requirement.