Hello,
I am trying to create a Custom "PageType=List UsageCategory=Lists using "Value Entry" dataset to get all line items from Posted Sales Invoice and Posted Sales Credit Memo. but ValueEntry only populates "Item" type line items. I want to include "G/L Account" Type and other types line item as well, which is not happening, is there any other dataset available where i can get all line items from all Documents of all document types specially "Posted Sales Invoice" and "Posted Sales Credit Memos" ? I thought of creating Query and link/merge tables but unfortunately AL doesnt support UNION. cant join tables at same level. Any thought , Any workaround?
page 50100 SalesReport
{
PageType = List;
UsageCategory = Lists;
ApplicationArea = All;
InsertAllowed = false;
DeleteAllowed = false;
Editable = false;
ModifyAllowed = false;
Caption = 'Sales Report (List)';
SourceTable = "Value Entry";
SourceTableView = sorting("Document No.", "Entry No.") order(ascending)
where(
"Document Type" = filter("Sales Invoice" | "Sales Credit Memo")
, Adjustment = filter(false)
);
Thanks
Bharat