How to create Customer Invoice Line Item details report

[piotr_krol]

Hi All,

I am trying to create a report that will show the header and line item data contained in all types of sales invoices.

Please let me know which data source should I use to create a report containing basic customer invoice header and line item data.

The data I am interested in are the product, quantity and net price used in the invoice. (and basic header data)

I am trying with data source called "Customer Invoice Item with Price Components" but do not present correct data.

What should I do when none of the available data sources contains the data I need?

Regards

Piotr

[former_member841437]

Hi,

Did you find the answer?

I'm facing the same problem and the reply here, posted 3 times 🤔

did not help me to get to the answer...

Thanks

[CHANDRESHJAIN]

Hi

This can be achieved, what problem you were facing

Regards

[Fawzi]

Hi.

personally , I am recently using sales order volume report ( status header no 03 completed ) with confirmed fulfilment quantities data source , and by exporting the report to XML ,then you can divide the total value of sales order by line item where will give you the unit price for each .

warm regards

[Adie]

Hello piotr.krol,

You may refer to the KBA, it helps to allocate the fields and data sources.

1830749 - ByD/ToD: Complete Data Sources and Characteristics Documentation

Thanks,

Adie

[Adie]

Hello piotr.krol,

You may refer to the KBA, it helps to allocate the fields and data sources.

1830749 - ByD/ToD: Complete Data Sources and Characteristics Documentation

Thanks,

Adie

[Adie]

Hello piotr.krol,

You may refer to the KBA, it helps to allocate the fields and data sources.

1830749 - ByD/ToD: Complete Data Sources and Characteristics Documentation

Thanks,

Adie