Hi,
Need to show item and GL description from posted purchase invoice page to Posted purchase invoices list page.
Hi,
Need to show item and GL description from posted purchase invoice page to Posted purchase invoices list page.
Thank you for the support. It works now. I can able to show both item and GL description using table buffer.
Hi Revathi - I am not sure why anyone would want to do that, it goes against the whole design of Purchase Invoices Header & Line concept. If the customer wants to see the lines description without opening each Posted Purchase Invoice card, I'd suggest create a factbox and display it on the factbox pane of Posted Purchase Invoice list on the right hand side. Whenever the user selects a PPI 108215 on this list in the last screenshot, they'll be able to see the corresponding line descriptions on the right hand side factbox immediately without opening the card page. You can choose to also display only the description of each line in this factbox
Even if you are able to code your necessary requirements, it will definitely backfire. I can think of many cases where the approach you are taking may absolutely not work
Hi,
Do you mean that you want to use the same field to show both the GL Description and Item Description? For example, if the type is GLType, it shows the GL Type Description, and if the type is Item, it shows the Item Description. To achieve this, you simply need to get another table buffer for the G/L account and use it in an 'else if' condition, like this
trigger OnAfterGetRecord() var PurchInvLine: Record "Purch. Inv. Line"; PurchInvLine2: Record "Purch. Inv. Line"; begin PurchInvLine.Reset(); PurchInvLine2.Reset(); PurchInvLine.SetRange("Document No.", Rec."No."); PurchInvLine.SetRange(Type, PurchInvLine.Type::Item); PurchInvLine2.SetRange("Document No.", Rec."No."); PurchInvLine2.SetRange(Type, PurchInvLine.Type::"G/L Account"); if PurchInvLine.FindSet() then begin ItemName := PurchInvLine.Description end else if PurchInvLine2.FindSet() then begin ItemName := PurchInvLine2.Description end else ItemName := ''; end;
Hope it helps..
Regards
André Arnaud de Cal... 291,391 Super User 2024 Season 2
Martin Dráb 230,445 Most Valuable Professional
nmaenpaa 101,156