Skip to main content
Solved

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

M
Semi-Pro I
Forum|alt.badge.img+1

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

Commercial Invoice

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

Sales Order Invoice Tab

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

Freight tab

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

Commercial Invoice

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?  

Best answer by Dioris Aguilar

@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.

View original
Did this topic help you find an answer to your question?

2 replies

Dioris Aguilar
Jr Varsity I
Forum|alt.badge.img+2

@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.

Chris Hackett
M
2 people like this
  • Chris Hackett
    Chris Hackett
  • M
    malinthawarnakulasooriya08
M
Semi-Pro I
Forum|alt.badge.img+1

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

Chris Hackett
1 person likes this
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved