Table 915 ATO Sales Buffer
src/Layers/W1/BaseApp/Assembly/Reports/ATOSalesBuffer.Table.al212 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.Assembly.Reports;using Microsoft.Assembly.History;using Microsoft.Inventory.Ledger;table 915 "ATO Sales Buffer"{ Caption = 'ATO Sales Buffer'; ReplicateData = false; DataClassification = CustomerContent; fields { field(1; Type; Option) { Caption = 'Type'; OptionCaption = ',Sale,Total Sale,Assembly,Total Assembly'; OptionMembers = ,Sale,"Total Sale",Assembly,"Total Assembly"; } field(2; "Order No."; Code[20]) { Caption = 'Order No.'; } field(3; "Item No."; Code[20]) { Caption = 'Item No.'; } field(4; "Parent Item No."; Code[20]) { Caption = 'Parent Item No.'; } field(5; Quantity; Decimal) { Caption = 'Quantity'; AutoFormatType = 0; } field(6; "Sales Cost"; Decimal) { Caption = 'Sales Cost'; AutoFormatType = 1; AutoFormatExpression = ''; } field(7; "Sales Amount"; Decimal) { Caption = 'Sales Amount'; AutoFormatType = 1; AutoFormatExpression = ''; } field(8; "Profit %"; Decimal) { Caption = 'Profit %'; AutoFormatType = 0; } field(9; "Parent Description"; Text[100]) { Caption = 'Parent Description'; } } keys { key(Key1; Type, "Order No.", "Item No.", "Parent Item No.") { Clustered = true; } key(Key2; "Item No.", Type, "Parent Item No.") { } } fieldgroups { } procedure UpdateBufferWithComp(CompATOSalesBuffer: Record "ATO Sales Buffer"; ProfitPct: Decimal; IsTotal: Boolean) begin Init(); if IsTotal then Type := Type::"Total Assembly" else Type := Type::Assembly; "Order No." := ''; "Item No." := CompATOSalesBuffer."Item No."; if not IsTotal then "Parent Item No." := CompATOSalesBuffer."Parent Item No." else "Parent Item No." := ''; if Find() then begin Quantity += CompATOSalesBuffer.Quantity; "Sales Cost" += CompATOSalesBuffer."Sales Cost"; "Sales Amount" += CalcSalesAmt(CompATOSalesBuffer."Sales Cost", ProfitPct); "Profit %" := CalcSalesProfitPct("Sales Cost", "Sales Amount"); OnUpdateBufferWithCompOnBeforeModify(Rec, CompATOSalesBuffer); Modify(); exit; end; Quantity := CompATOSalesBuffer.Quantity; "Sales Cost" := CompATOSalesBuffer."Sales Cost"; "Sales Amount" := CalcSalesAmt(CompATOSalesBuffer."Sales Cost", ProfitPct); "Profit %" := ProfitPct; OnUpdateBufferWithCompOnBeforeInsert(Rec, CompATOSalesBuffer); Insert(); end; procedure UpdateBufferWithItemLedgEntry(ItemLedgEntry: Record "Item Ledger Entry"; IsTotal: Boolean) begin ItemLedgEntry.CalcFields("Cost Amount (Expected)", "Cost Amount (Actual)", "Sales Amount (Actual)", "Sales Amount (Expected)"); Init(); "Item No." := ItemLedgEntry."Item No."; "Order No." := ''; "Parent Item No." := ''; case ItemLedgEntry."Entry Type" of ItemLedgEntry."Entry Type"::Sale: if IsTotal then Type := Type::"Total Sale" else begin Type := Type::Sale; "Order No." := FindATO(ItemLedgEntry); end; ItemLedgEntry."Entry Type"::"Assembly Consumption": begin if IsTotal then Type := Type::"Total Assembly" else Type := Type::Assembly; "Parent Item No." := ItemLedgEntry."Source No."; end; end; if Find() then begin Quantity += -ItemLedgEntry.Quantity; "Sales Cost" += -(ItemLedgEntry."Cost Amount (Expected)" + ItemLedgEntry."Cost Amount (Actual)"); "Sales Amount" += ItemLedgEntry."Sales Amount (Actual)" + ItemLedgEntry."Sales Amount (Expected)"; "Profit %" := CalcSalesProfitPct("Sales Cost", "Sales Amount"); OnUpdateBufferWithItemLedgEntryOnBeforeModify(Rec, ItemLedgEntry); Modify(); exit; end; Quantity := -ItemLedgEntry.Quantity; "Sales Cost" := -(ItemLedgEntry."Cost Amount (Expected)" + ItemLedgEntry."Cost Amount (Actual)"); "Sales Amount" := ItemLedgEntry."Sales Amount (Actual)" + ItemLedgEntry."Sales Amount (Expected)"; "Profit %" := CalcSalesProfitPct("Sales Cost", "Sales Amount"); OnUpdateBufferWithItemLedgEntryOnBeforeInsert(Rec, ItemLedgEntry); Insert(); end; local procedure FindATO(ItemLedgEntry: Record "Item Ledger Entry"): Code[20] var PostedATOLink: Record "Posted Assemble-to-Order Link"; ItemApplnEntry: Record "Item Application Entry"; begin if not ItemLedgEntry."Assemble to Order" then exit(''); if ItemLedgEntry."Document Type" <> ItemLedgEntry."Document Type"::"Sales Shipment" then exit(''); PostedATOLink.SetCurrentKey("Document Type", "Document No.", "Document Line No."); PostedATOLink.SetRange("Document Type", PostedATOLink."Document Type"::"Sales Shipment"); PostedATOLink.SetRange("Document No.", ItemLedgEntry."Document No."); PostedATOLink.SetRange("Document Line No.", ItemLedgEntry."Document Line No."); if PostedATOLink.FindFirst() then exit(PostedATOLink."Assembly Order No."); if ItemLedgEntry.Correction then if ItemApplnEntry.AppliedFromEntryExists(ItemLedgEntry."Entry No.") then begin ItemLedgEntry.Get(ItemApplnEntry."Outbound Item Entry No."); exit(FindATO(ItemLedgEntry)); end; end; local procedure CalcSalesAmt(SalesCost: Decimal; ProfitPct: Decimal): Decimal begin if ProfitPct = 100 then exit(0); exit(Round(100 * SalesCost / (100 - ProfitPct))) end; local procedure CalcSalesProfitPct(CostAmt: Decimal; SalesAmt: Decimal): Decimal begin if SalesAmt = 0 then exit(0); exit(Round(100 * (SalesAmt - CostAmt) / SalesAmt)); end; [IntegrationEvent(false, false)] local procedure OnUpdateBufferWithCompOnBeforeInsert(var ATOSalesBuffer: Record "ATO Sales Buffer"; CompATOSalesBuffer: Record "ATO Sales Buffer") begin end; [IntegrationEvent(false, false)] local procedure OnUpdateBufferWithCompOnBeforeModify(var ATOSalesBuffer: Record "ATO Sales Buffer"; CompATOSalesBuffer: Record "ATO Sales Buffer") begin end; [IntegrationEvent(false, false)] local procedure OnUpdateBufferWithItemLedgEntryOnBeforeInsert(var ATOSalesBuffer: Record "ATO Sales Buffer"; ItemLedgEntry: Record "Item Ledger Entry") begin end; [IntegrationEvent(false, false)] local procedure OnUpdateBufferWithItemLedgEntryOnBeforeModify(var ATOSalesBuffer: Record "ATO Sales Buffer"; ItemLedgEntry: Record "Item Ledger Entry") begin end;}