How to get the Total Net Weight for the Commercial Invoice without repeating the same weight?

Question

I have created a Custom Commercial Invoice and there is a Net Weight(Kg) filed in it as follows.

Corresponding to the above invoice there a two orders in the the detail section of the Sales Orders’ Invoices tab as follows.

There is only one order weight for both these items in the FREIGHT section as follows.

If i use the =SumeSOFreightDetail.Weight] for get the summation as the Net Weight(Kg) the weight is getting double. Please check the below screenshot.

Can I know If there is another different Order in the DETAILS section of the Sales Order Invoice Tab and if there is different order weight for that in the FREIGHT detail section, how to get the total net weight for the above invoice without repeating the same weight?

Page 1 / 1

@malinthawarnakulasooriya08 Most probably you are doing a join with SOFreightDetail in the main statement and the records are being multiplied by the join from the details tab table.

I suggest get the Net and Gross Weight values using a sub-report and exclude SOFreightDetail from the main statement.

I got the point. Thank you very much @Dioris Aguilar.

Reply

Dioris Aguilar · Accepted Answer

@malinthawarnakulasooriya08Most probably you are doing a join with SOFreightDetail in the main statement and the records are being multiplied by the join fromthe details tab table.I suggest get the Net and Gross Weight values using a sub-report and excludeSOFreightDetailfrom the main statement.

malinthawarnakulasooriya08 · Answer

I got the point.Thank you very much@Dioris Aguilar.

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded