Currently there is no link between the Nominal Ledger and the POP and SOP transactions in the SQL database.This as I see it is a major weakness in the database design as there is no visibility of the nominal postings detail. This can easily cause disparate in reporting between what occurs in SOP/ POP compared with what actually is being reported in the Nominal Ledgers. Furthermore not having this link lacks the transparency of being able to easily track transactions (e.g a specific item of stock) end to end through the nominal ledger which is a fundamental audit requirement.