Related to bussiness central

(0) Share

Report

Posted on by Pragya752

234

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;

I have the same question (0)

All responses (14)

Answers (1)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Related to bussiness central

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.

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

RE: Related to bussiness central

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Related to bussiness central

see my answer

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

RE: Related to bussiness central

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

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

RE: Related to bussiness central

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

Thanks

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

RE: Related to bussiness central

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

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

RE: Related to bussiness central

yes i think the issue was with field id only

Was this reply helpful? Yes No
Suggested answer

Govinda Kumar 2,304 Moderator on at

Like (0)

Report

RE: Related to bussiness central

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

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

RE: Related to bussiness central

yes its working now.Thanks

Was this reply helpful? Yes No
Pragya752 234 on at

Like (0)

Report

RE: Related to bussiness central

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

Was this reply helpful? Yes No