Adding custom field from shipment to Invoice Report Format

#1

Helllo Team

We have made use of a custom field on the shipment i,e on the shipment properties tab and named the field as ’ Request No/ID’
We want to add the above field to the invoice format. Could you please assist how to find the field from the object data source as I was unable to find the exact field in the report designerAvontus-Invoice Report Modification.pdf (337.3 KB) ? ( see attached screen shot)

Regards
sanjoy

#2

Hello Sanjoy.

Currently, the Custom Properties on Shipment are not available to be added in other band of Invoice reports.

Thanks for posting

#3

Hello,
We were looking to add the field in the Invoice print format ( using end user report designer).

By the way I was able to locate the field under shipment detail i,e under the collection ‘InvoiceRentproducts’–>Shipment Item–>GlobalProperty1. Was able to add this field in the designer successfully

However also need the same field in the collection ‘InvoiceUnitPrices’ since we are adding additonal charges to invoice with reference to shipment. But I do not find it.
Can you suggest if any formula field/calculated field can be used to derive the value from the ‘invoiceRentProducts’ collection OR any other method can be used.?

Thanks
sanjoy

#4

Hello Sanjoy.

Out-of-the-box you may use properties where DataMember of parent/Band/Group is set to the containing collection (e.g. In this case, DataMember = InvoiceRentProducts)

You may check out DevExpress - EURD docs for further reading on EURD.

Thanks for posting

#5

Hi,
Thank you for the feedback. Actually the data Member in this case is pointing to the collection ‘InvoiceUnitPrices’. If we map it to the collection ‘InvoiceRentProducts’ it gives a erroneous result and is getting repeated even if the shipment ID is different

In both the collection the common field is shipment ID. Is there a way to derive the value by combining two collection with shipment ID as the key field
Regards
sanjoy