Table 5312704 M365 Cust./Vend./Item Stat.

Table 5312704 M365 Cust./Vend./Item Stat.

Fields

Entry No. (1)

Integer

Sell-to Cust. No. (2)

Code[20]

TableRelation: Customer

Buy-from Vendor No. (3)

Code[20]

TableRelation: Customer

Item No. (4)

Code[20]

TableRelation: Item

Datefilter (5)

Date

FieldClass: FlowFilter

Qty (Bill-to Cust.) (6)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Value Entry"."Invoiced Quantity" where("Source Type" = const(Customer), "Source No." = field("Sell-to Cust. No."), "Item Ledger Entry Type" = const(Sale), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Amount (LCY) (7)

Decimal

FieldClass: FlowField

CalcFormula: sum("Value Entry"."Sales Amount (Actual)" where("Source Type" = const(Customer), "Source No." = field("Bill-to Cust. No."), "Item Ledger Entry Type" = const(Sale), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Purchases (LCY) (8)

Decimal

FieldClass: FlowField

CalcFormula: sum("Value Entry"."Purchase Amount (Actual)" where("Source Type" = const(Vendor), "Source No." = field("Buy-from Vendor No."), "Item Ledger Entry Type" = const(Purchase), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Bill-to Cust. No. (9)

Code[20]

TableRelation: Customer

Last Entry (10)

Date

Last Unit Price (11)

Decimal

Last Purchaseprice (12)

Decimal

Qty (Sell-to Cust.) (13)

Decimal

FieldClass: FlowField

CalcFormula: - sum("Value Entry"."Invoiced Quantity" where("Source Type" = const(Customer), "M365 Sell-to Customer No." = field("Sell-to Cust. No."), "Item Ledger Entry Type" = const(Sale), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Amount (LCY) Sell-to Cust. (14)

Decimal

FieldClass: FlowField

CalcFormula: sum("Value Entry"."Sales Amount (Actual)" where("Source Type" = const(Customer), "M365 Sell-to Customer No." = field("Sell-to Cust. No."), "Item Ledger Entry Type" = const(Sale), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Last net Price (15)

Decimal

Item Description (16)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Item.Description where("No." = field("Item No.")))

Item Description 2 (17)

Text[50]

FieldClass: FlowField

CalcFormula: lookup(Item."Description 2" where("No." = field("Item No.")))

Qty (Buy-from Vend.) (18)

Decimal

FieldClass: FlowField

CalcFormula: sum("Value Entry"."Invoiced Quantity" where("Source Type" = const(Vendor), "Source No." = field("Buy-from Vendor No."), "Item Ledger Entry Type" = const(Purchase), "Item No." = field("Item No."), "Posting Date" = field(Datefilter)))

Item Search Word (19)

Code[100]

FieldClass: FlowField

CalcFormula: lookup(Item."Search Description" where("No." = field("Item No.")))

Quantity (Purch) (20)

Decimal

FieldClass: FlowField

CalcFormula: sum("Value Entry"."Invoiced Quantity" where("Source Type" = const(Vendor), "Source No." = field("Buy-from Vendor No."), "Item Ledger Entry Type" = const(Purchase), "Item No." = field("Item No.")))

Customer Name (21)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Customer.Name where("No." = field("Sell-to Cust. No.")))

Vendor Name (22)

Text[100]

FieldClass: FlowField

CalcFormula: lookup(Vendor.Name where("No." = field("Buy-from Vendor No.")))

Pay-to Vendor No. (23)

Code[20]

TableRelation: Vendor

Methods

SchreibenSatz

procedure SchreibenSatz(salesInvHeader: Record "Sales Invoice Header"; salesInvLine: Record "Sales Invoice Line")

Parameters / Return Value

  • salesInvHeader Record "Sales Invoice Header"

  • salesInvLine Record "Sales Invoice Line"

SchreibenSatzCrMemo

procedure SchreibenSatzCrMemo(salesInvHeader: Record "Sales Cr.Memo Header"; salesInvLine: Record "Sales Cr.Memo Line")

Parameters / Return Value

  • salesInvHeader Record "Sales Cr.Memo Header"

  • salesInvLine Record "Sales Cr.Memo Line"

SchreibenSatzPurch

procedure SchreibenSatzPurch(purchInvHeader: Record "Purch. Inv. Header"; purchInvLine: Record "Purch. Inv. Line")

Parameters / Return Value

  • purchInvHeader Record "Purch. Inv. Header"

  • purchInvLine Record "Purch. Inv. Line"

SchreibenSatzPurchCrMemo

procedure SchreibenSatzPurchCrMemo(purchInvHeader: Record "Purch. Cr. Memo Hdr."; purchInvLine: Record "Purch. Cr. Memo Line")

Parameters / Return Value

  • purchInvHeader Record "Purch. Cr. Memo Hdr."

  • purchInvLine Record "Purch. Cr. Memo Line"

VendorSearch

procedure VendorSearch(var searchText: Text[250])

Parameters / Return Value

  • searchText Text[250]

Events

OnAfterInsertStatrec

local procedure OnAfterInsertStatrec(var purchInvHeader: Record "Purch. Inv. Header"; var purchInvLine: Record "Purch. Inv. Line")

Parameters / Return Value

  • purchInvHeader Record "Purch. Inv. Header"

  • purchInvLine Record "Purch. Inv. Line"

OnAfterInsertMemo

local procedure OnAfterInsertMemo(var purchInvHeader: Record "Purch. Cr. Memo Hdr."; var purchInvLine: Record "Purch. Cr. Memo Line")

Parameters / Return Value

  • purchInvHeader Record "Purch. Cr. Memo Hdr."

  • purchInvLine Record "Purch. Cr. Memo Line"

OnBeforSearch

local procedure OnBeforSearch(var searchText: Text[250])

Parameters / Return Value

  • searchText Text[250]

EOS Labs -