Related to bussiness central

(0) Share

Report

Posted on by Pragya752

236

I have a table Purchase Header with Enum field Invoice category with number of options.Now,I need that when i select one option here ,the selected option should be displayed on another page posted invoices.How can i achieve this?I am using this code after pageextension where i want to display but it is not working.

trigger OnAfterGetCurrRecord()

var

RecPurchchaseOrder : Record "Purchase Header";

RecPostedInvoice : Record "Purch. Inv. Header";

begin

RecPurchchaseOrder.Reset();

RecPurchchaseOrder.SetRange("Invoice Category",RecPostedInvoice."Invoice Category");

RecPostedInvoice."Invoice Category" := RecPurchchaseOrder."Invoice Category";

end;

All responses (14)

Answers (1)

Sort by

Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

If you want to see that field from Purchase header to your Posted Purchase tables, just create that same field with same id in Purch. Invoice Header table, no need to write any code.

Thanks.
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

This is my table ext. for purchase inv header

tableextension 90124 PostedInvoiceExt extends "Purch. Inv. Header"

{

fields

{

field(231; "Invoice Category"; Enum InvoiceCategory)

{

}

}

}

This is my tablext for purchase header.....

tableextension 90133 PurchaseOrderExtention extends "Purchase Header"

{

DataCaptionFields = "Free Text";

fields

{

field(231; "Invoice Category"; Enum InvoiceCategory)

{

Caption = 'Invoice Category';

InitValue = " ";

NotBlank = true;

}

I want that whatever value i select in purchase header through the purchase invoice page.It should come statically on posted invoice page through purch. invoice table
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

see my answer
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

I did the same just see my code.I am not getting the output
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you posted any invoice after selecting this value on Purch. Header table?

Thanks
Suggested answer

Nitin Verma 21,812 Moderator on at

Like (1)

Report
Copy link

Link copied!

Also are you able to define Field id 231 In purchase table?

I am not sure it will allow you to do that, can you define with custom range started from 50000..99999

Thanks
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

yes i think the issue was with field id only
Suggested answer

Govinda Kumar 2,310 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Pragya752,

You can try selecting the ID 50000 range for your invoice category field, as suggested by Nitin Verma. I tested this solution and it worked on my end.

Please look at the screenshots below

Here is the screenshot of the Purchase Order with the Invoice category field before posting

Posted Purchase Invoice page

Regards
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

yes its working now.Thanks
Pragya752 236 on at

Like (0)

Report
Copy link

Link copied!

hello,when i tried the same thing on vendor ledger entry table to get data with same field no. it is not showing any data.In that table only few documents are of Incvoice type where are in purchase header and posted purchase header all were of invoice,does this has something to do with the probelm of data not showing on vendor ledger entry table