Printing serial numbers in Sales Invoice Report

Finance and Operations/AX Developer Forum
1

Hi

I am new ti AX. I am developing a sales invoice report where i want to print the serial numbers of the item picked in the Picking list.

My problem is the serial numbers i picked in the picking list → Inventory–>Reservation form is not available in the Invent Serial Table rather it s saved in the InventDim table.

Can anyone help me how to get the serial number and Print in the sales invoice report.

–Praveen

2

I expect you are using a standard sales invoice report…

To add serial number to this report…

AR → setup → Forms → form setup → Invoice -Tab → show in sheet - group → select - serial number.

3

I am not using standard report. creating a new report.

4

Then what are the data sources you are using.

5

If you are using CustInvocieTrans

SerialNumber = InventDim::find(CustInvocieTrans).InventSerialId;

6

Custinvoicejour

Custtable

custtrans

7

Use the below code in a display method.

CustInvoiceTrans CustInvoiceTrans ;

select CustInvoiceTrans where CustInvoiceTrans.SalesId ==CustInvoiceJour.SalesId && CustInvoiceTrans.InvoiceId == CustInvoiceJour.InvoiceId &&
CustInvoiceTrans.InvoiceDate == CustInvoiceJour.InvoiceDate && CustInvoiceTrans.numberSequenceGroup == CustInvoiceJour.numberSequenceGroup;
inventdim::find(CustInvoiceTrans.InventDimId).inventSerialId;

Regards,

Arun