Small and medium business | Business Central, N...

Job Number on Posted Sales Invoice

(0) Share

Report

Posted on by LearnBC

228

Hello All,

am trying to bring Job Number Field in Posted Sales Invoice Print out. But values is not coming over the print out.

pls let me know what is the issue

reportextension 60003 PostedSalesInvoiceExt extends "Sales - Invoice EMP"

{

RDLCLayout = './ReportLayouts/PostedSalesInvoice.rdl';

dataset

{

add("Sales Invoice Line")

{

column(JobNo_SalesInvoiceLine; "Job No.")

{

}

}

Compile Messages

warning AL0432: Report 'Sales - Invoice EMP' is marked for removal. Reason: Replaced with report 1306 Standard Sales - Invoice. Tag: 15.2.

Compilation ended at '17:10:28.840'.

Success: The package is created.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

Once the extension is installed are you able to create a report layout? Adding the field will make it available within the schema for a layout to be generated. They are two separate tasks. As the compiler message suggests you should probably do this with report 1306 instead of the one you have selected

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!

Thankyou..

Actually it was working fine before. but dont know why it is not working after the 20th Update

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!
after downloading the latest extension and changing the report to 1306 standard sales then also am getting the same

reportextension 60003 PostedSalesInvoiceExt extends 1306 { RDLCLayout = './ReportLayouts/PostedSalesInvoice.rdl'; dataset { add("Sales Invoice Line") { column(JobNo_SalesInvoiceLine; "Job No.") { } } } }

Was this reply helpful? Yes No
Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

I believe the dataitem in the report is like this:

dataitem(Line; "Sales Invoice Line")

Which would mean you reference it with Line in a report extension. Try using ctrl+spacebar in vs code. That gives you suggestions on what to use table and field wise

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!
is it like this..but there is no result as expected

reportextension 60003 PostedSalesInvoiceExt extends 1306 { RDLCLayout = './ReportLayouts/PostedSalesInvoice.rdl'; dataset { addbefore(Line) { dataitem("Sales Line"; "Sales Line") //add("Sales Invoice Line") { column(JobNo_SalesLine; "Job No.") { } } } } }

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!

Could you pls anyone suggest me what may be the issue in this.

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!

Could you pls anyone guide me what may be the issue in this.

Was this reply helpful? Yes No
Suggested answer

JAngle 150 on at

Like (0)

Report
Copy link

Link copied!

For report 1306 the field is already part of the sales line data item. Just add it through a report layout

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!

Yes, i already added in the report but it is not coming over there. thatz why am confused is there any mistakes in code or not

Was this reply helpful? Yes No
LearnBC 228 on at

Like (0)

Report
Copy link

Link copied!
in Lines also it is there or in find entries- job ledger entries also the job field is there

reportextension 60003 PostedSalesInvoiceExt extends 1306 { RDLCLayout = './ReportLayouts/PostedSalesInvoice.rdl'; dataset { addbefore(Line) { dataitem("Sales Line"; "Sales Line") //add("Sales Invoice Line") { column(JobNo_SalesLine; "Job No.") { } } } } }

Was this reply helpful? Yes No