Our users wish to be able to see the General Ledger entries for their Cost Centres to help manage their spend. Easy enough, but the problem is that GL entries generated from Purchase Order Lines get grouped into single GL entries based on I think General Prod Posting Group and Dimension. This means that you cannot get any PO line detail in GL entry listings or reports.
Is there any way to make the postings a 1 to 1 relationship, and is this even advisable? Has anyone tried to do something similar?
You will have to create a new custom table and modify codeunit 12 Gen. Jnl. Post line and check if the entry type is purchase and update this new custom table at each entry level. Create a page for this new table and look it up at the G/L entry level per G/L account. You will have g/L account no. in both g/l entry table and the new custom table you create and this is the link you will have to tag them together.