Page 126 Cust. Ledg. Entries Preview
- App
- Base Application
- Namespace
- Microsoft.Sales.Receivables
- Versions
- 17-28
- Source table
- 21
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Sales/Receivables/CustLedgEntriesPreview.Page.al497 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// Copyright (c) Microsoft Corporation. All rights reserved.
// Licensed under the MIT License. See License.txt in the project root for license information.
// ------------------------------------------------------------------------------------------------
namespace Microsoft.Sales.Receivables;
using Microsoft.Finance.Dimension;
using Microsoft.Finance.GeneralLedger.Preview;
/// <summary>
/// Displays a preview of customer ledger entries that will be created when posting a transaction, using temporary records.
/// </summary>
page 126 "Cust. Ledg. Entries Preview"
{
Caption = 'Cust. Ledg. Entries Preview';
DataCaptionFields = "Customer No.";
Editable = false;
PageType = List;
SourceTable = "Cust. Ledger Entry";
SourceTableTemporary = true;
layout
{
area(content)
{
repeater(Control1)
{
ShowCaption = false;
field("Posting Date"; Rec."Posting Date")
{
ApplicationArea = Basic, Suite;
Editable = false;
}
field("Document Type"; Rec."Document Type")
{
ApplicationArea = Basic, Suite;
Editable = false;
StyleExpr = StyleTxt;
}
field("Document No."; Rec."Document No.")
{
ApplicationArea = Basic, Suite;
Editable = false;
StyleExpr = StyleTxt;
}
field("Customer No."; Rec."Customer No.")
{
ApplicationArea = Basic, Suite;
Editable = false;
}
field("Message to Recipient"; Rec."Message to Recipient")
{
ApplicationArea = Basic, Suite;
}
field(Description; Rec.Description)
{
ApplicationArea = Basic, Suite;
}
field("Global Dimension 1 Code"; Rec."Global Dimension 1 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim1Visible;
}
field("Global Dimension 2 Code"; Rec."Global Dimension 2 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim2Visible;
}
field("Customer Posting Group"; Rec."Customer Posting Group")
{
ApplicationArea = Basic, Suite;
Editable = false;
Visible = false;
}
field("IC Partner Code"; Rec."IC Partner Code")
{
ApplicationArea = Intercompany;
Editable = false;
Visible = false;
}
field("Salesperson Code"; Rec."Salesperson Code")
{
ApplicationArea = Suite;
Editable = false;
Visible = false;
}
field("Currency Code"; Rec."Currency Code")
{
ApplicationArea = Suite;
}
field(OriginalAmountFCY; OriginalAmountFCY)
{
ApplicationArea = Basic, Suite;
Caption = 'Original Amount';
Editable = false;
ToolTip = 'Specifies the amount on the customer ledger entry before you post.';
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
trigger OnDrillDown()
begin
DrilldownAmounts(2);
end;
}
field(OriginalAmountLCY; OriginalAmountLCY)
{
ApplicationArea = Basic, Suite;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Original Amount LCY';
Editable = false;
ToolTip = 'Specifies the original amount linked to the customer ledger entry, in local currency.';
Visible = false;
trigger OnDrillDown()
begin
DrilldownAmounts(2);
end;
}
field(AmountFCY; AmountFCY)
{
ApplicationArea = Basic, Suite;
Caption = 'Amount';
DrillDown = true;
Editable = false;
ToolTip = 'Specifies the net amount of all the lines in the customer entry.';
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
trigger OnDrillDown()
begin
DrilldownAmounts(0);
end;
}
field(AmountLCY; AmountLCY)
{
ApplicationArea = Basic, Suite;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Amount LCY';
DrillDown = true;
Editable = false;
ToolTip = 'Specifies the amount linked to the customer ledger entry on the line, in local currency.';
Visible = false;
trigger OnDrillDown()
begin
DrilldownAmounts(0);
end;
}
field("Debit Amount"; Rec."Debit Amount")
{
ApplicationArea = Basic, Suite;
Visible = false;
}
field("Debit Amount (LCY)"; Rec."Debit Amount (LCY)")
{
ApplicationArea = Basic, Suite;
AutoFormatType = 1;
AutoFormatExpression = '';
Visible = false;
}
field("Credit Amount"; Rec."Credit Amount")
{
ApplicationArea = Basic, Suite;
Visible = false;
}
field("Credit Amount (LCY)"; Rec."Credit Amount (LCY)")
{
ApplicationArea = Basic, Suite;
AutoFormatType = 1;
AutoFormatExpression = '';
Visible = false;
}
field(RemainingAmountFCY; RemainingAmountFCY)
{
ApplicationArea = Basic, Suite;
Caption = 'Remaining Amount';
Editable = false;
ToolTip = 'Specifies the remaining amount on the customer ledger entry before you post.';
AutoFormatExpression = Rec."Currency Code";
AutoFormatType = 1;
trigger OnDrillDown()
begin
DrilldownAmounts(1);
end;
}
field(RemainingAmountLCY; RemainingAmountLCY)
{
ApplicationArea = Basic, Suite;
AutoFormatType = 1;
AutoFormatExpression = '';
Caption = 'Remaining Amount LCY';
Editable = false;
ToolTip = 'Specifies the remaining amount linked to the customer ledger entry on the line, in local currency.';
Visible = false;
trigger OnDrillDown()
begin
DrilldownAmounts(1);
end;
}
field("Bal. Account Type"; Rec."Bal. Account Type")
{
ApplicationArea = Basic, Suite;
Editable = false;
Visible = false;
}
field("Bal. Account No."; Rec."Bal. Account No.")
{
ApplicationArea = Basic, Suite;
Editable = false;
Visible = false;
}
field("Due Date"; Rec."Due Date")
{
ApplicationArea = Basic, Suite;
StyleExpr = StyleTxt;
}
field("Pmt. Discount Date"; Rec."Pmt. Discount Date")
{
ApplicationArea = Basic, Suite;
}
field("Pmt. Disc. Tolerance Date"; Rec."Pmt. Disc. Tolerance Date")
{
ApplicationArea = Basic, Suite;
}
field("Original Pmt. Disc. Possible"; Rec."Original Pmt. Disc. Possible")
{
ApplicationArea = Basic, Suite;
}
field("Remaining Pmt. Disc. Possible"; Rec."Remaining Pmt. Disc. Possible")
{
ApplicationArea = Basic, Suite;
}
field("Max. Payment Tolerance"; Rec."Max. Payment Tolerance")
{
ApplicationArea = Basic, Suite;
}
field("Payment Method Code"; Rec."Payment Method Code")
{
ApplicationArea = Basic, Suite;
}
field(Open; Rec.Open)
{
ApplicationArea = Basic, Suite;
}
field("On Hold"; Rec."On Hold")
{
ApplicationArea = Basic, Suite;
}
field("Exported to Payment File"; Rec."Exported to Payment File")
{
ApplicationArea = Basic, Suite;
}
field("Source Code"; Rec."Source Code")
{
ApplicationArea = Suite;
Editable = false;
Visible = false;
}
field("Reason Code"; Rec."Reason Code")
{
ApplicationArea = Suite;
Editable = false;
Visible = false;
}
field("Dimension Set ID"; Rec."Dimension Set ID")
{
ApplicationArea = Dimensions;
Visible = false;
}
field("External Document No."; Rec."External Document No.")
{
ApplicationArea = Basic, Suite;
Editable = false;
Visible = false;
}
field("Your Reference"; Rec."Your Reference")
{
ApplicationArea = Basic, Suite;
Editable = false;
Visible = false;
}
field("Shortcut Dimension 3 Code"; Rec."Shortcut Dimension 3 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim3Visible;
}
field("Shortcut Dimension 4 Code"; Rec."Shortcut Dimension 4 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim4Visible;
}
field("Shortcut Dimension 5 Code"; Rec."Shortcut Dimension 5 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim5Visible;
}
field("Shortcut Dimension 6 Code"; Rec."Shortcut Dimension 6 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim6Visible;
}
field("Shortcut Dimension 7 Code"; Rec."Shortcut Dimension 7 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim7Visible;
}
field("Shortcut Dimension 8 Code"; Rec."Shortcut Dimension 8 Code")
{
ApplicationArea = Dimensions;
Editable = false;
Visible = Dim8Visible;
}
}
}
}
actions
{
area(navigation)
{
group("Ent&ry")
{
Caption = 'Ent&ry';
Image = Entry;
action(Dimensions)
{
ApplicationArea = Dimensions;
Caption = 'Dimensions';
Ellipsis = true;
Image = Dimensions;
ShortCutKey = 'Alt+D';
ToolTip = 'View or edit dimensions, such as area, project, or department, that you can assign to sales and purchase documents to distribute costs and analyze transaction history.';
trigger OnAction()
var
GenJnlPostPreview: Codeunit "Gen. Jnl.-Post Preview";
begin
GenJnlPostPreview.ShowDimensions(DATABASE::"Cust. Ledger Entry", Rec."Entry No.", Rec."Dimension Set ID");
end;
}
action(SetDimensionFilter)
{
ApplicationArea = Dimensions;
Caption = 'Set Dimension Filter';
Ellipsis = true;
Image = "Filter";
ToolTip = 'Limit the entries according to the dimension filters that you specify. NOTE: If you use a high number of dimension combinations, this function may not work and can result in a message that the SQL server only supports a maximum of 2100 parameters.';
trigger OnAction()
begin
Rec.SetFilter("Dimension Set ID", DimensionSetIDFilter.LookupFilter());
end;
}
}
}
area(Promoted)
{
group(Category_Process)
{
Caption = 'Process';
actionref(Dimensions_Promoted; Dimensions)
{
}
actionref(SetDimensionFilter_Promoted; SetDimensionFilter)
{
}
}
}
}
trigger OnAfterGetRecord()
begin
StyleTxt := Rec.SetStyle();
CalcAmounts();
end;
trigger OnOpenPage()
begin
SetDimVisibility();
end;
var
TempDetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry" temporary;
DimensionSetIDFilter: Page "Dimension Set ID Filter";
StyleTxt: Text;
AmountFCY: Decimal;
AmountLCY: Decimal;
RemainingAmountFCY: Decimal;
RemainingAmountLCY: Decimal;
OriginalAmountLCY: Decimal;
OriginalAmountFCY: Decimal;
protected var
Dim1Visible: Boolean;
Dim2Visible: Boolean;
Dim3Visible: Boolean;
Dim4Visible: Boolean;
Dim5Visible: Boolean;
Dim6Visible: Boolean;
Dim7Visible: Boolean;
Dim8Visible: Boolean;
local procedure SetDimVisibility()
var
DimensionManagement: Codeunit DimensionManagement;
begin
DimensionManagement.UseShortcutDims(Dim1Visible, Dim2Visible, Dim3Visible, Dim4Visible, Dim5Visible, Dim6Visible, Dim7Visible, Dim8Visible);
end;
/// <summary>
/// Sets the preview data from temporary customer ledger entries and detailed entries.
/// </summary>
/// <param name="TempCustLedgerEntry">The temporary customer ledger entries to display.</param>
/// <param name="TempDetailedCustLedgEntry2">The temporary detailed customer ledger entries for amount calculations.</param>
procedure Set(var TempCustLedgerEntry: Record "Cust. Ledger Entry" temporary; var TempDetailedCustLedgEntry2: Record "Detailed Cust. Ledg. Entry" temporary)
begin
if TempCustLedgerEntry.FindSet() then
repeat
Rec := TempCustLedgerEntry;
Rec.Insert();
until TempCustLedgerEntry.Next() = 0;
if TempDetailedCustLedgEntry2.Find('-') then
repeat
TempDetailedCustLedgEntry := TempDetailedCustLedgEntry2;
TempDetailedCustLedgEntry.Insert();
until TempDetailedCustLedgEntry2.Next() = 0;
end;
/// <summary>
/// Calculates the amounts for the current customer ledger entry from the detailed entries.
/// </summary>
procedure CalcAmounts()
begin
AmountFCY := 0;
AmountLCY := 0;
RemainingAmountLCY := 0;
RemainingAmountFCY := 0;
OriginalAmountLCY := 0;
OriginalAmountFCY := 0;
TempDetailedCustLedgEntry.SetRange("Cust. Ledger Entry No.", Rec."Entry No.");
if TempDetailedCustLedgEntry.FindSet() then
repeat
if TempDetailedCustLedgEntry."Entry Type" = TempDetailedCustLedgEntry."Entry Type"::"Initial Entry" then begin
OriginalAmountFCY += TempDetailedCustLedgEntry.Amount;
OriginalAmountLCY += TempDetailedCustLedgEntry."Amount (LCY)";
end;
if not (TempDetailedCustLedgEntry."Entry Type" in [TempDetailedCustLedgEntry."Entry Type"::Application,
TempDetailedCustLedgEntry."Entry Type"::"Appln. Rounding"])
then begin
AmountFCY += TempDetailedCustLedgEntry.Amount;
AmountLCY += TempDetailedCustLedgEntry."Amount (LCY)";
end;
RemainingAmountFCY += TempDetailedCustLedgEntry.Amount;
RemainingAmountLCY += TempDetailedCustLedgEntry."Amount (LCY)";
until TempDetailedCustLedgEntry.Next() = 0;
OnAfterCalcAmounts(Rec, TempDetailedCustLedgEntry, AmountFCY, AmountLCY, RemainingAmountFCY, RemainingAmountLCY, OriginalAmountFCY, OriginalAmountLCY);
end;
local procedure DrilldownAmounts(AmountType: Option Amount,"Remaining Amount","Original Amount")
var
DetCustLedgEntrPreview: Page "Det. Cust. Ledg. Entr. Preview";
begin
case AmountType of
AmountType::Amount:
TempDetailedCustLedgEntry.SetFilter("Entry Type", '<>%1&<>%2',
TempDetailedCustLedgEntry."Entry Type"::Application, TempDetailedCustLedgEntry."Entry Type"::"Appln. Rounding");
AmountType::"Original Amount":
TempDetailedCustLedgEntry.SetRange("Entry Type", TempDetailedCustLedgEntry."Entry Type"::"Initial Entry");
AmountType::"Remaining Amount":
TempDetailedCustLedgEntry.SetRange("Entry Type");
end;
DetCustLedgEntrPreview.Set(TempDetailedCustLedgEntry);
DetCustLedgEntrPreview.RunModal();
Clear(DetCustLedgEntrPreview);
end;
[IntegrationEvent(false, false)]
local procedure OnAfterCalcAmounts(CustLedgerEntry: Record "Cust. Ledger Entry"; var TempDetailedCustLedgEntry: Record "Detailed Cust. Ledg. Entry" temporary; var AmountFCY: Decimal; var AmountLCY: Decimal; var RemainingAmountFCY: Decimal; var RemainingAmountLCY: Decimal; var OriginalAmountFCY: Decimal; var OriginalAmountLCY: Decimal)
begin
end;
}