Hi all, just a brief understanding of my database, I have multiple lines of colours, pounds qty and yards qty for the same fabrication. I have a button which will calculate the gross weight, so in order to calculate the gross weight, I will need to calculate it line by line. I have zero issue with the calculation part. After I calculate, I will need to generate a report, this where the issue surface.
The issue I am facing is when I do a combine PO, for example, if the first PO blue color has very small qty, then I will combine it with the second PO blue color. The total sum of the pound qty and yards qty is correct when it is displayed in the report. The only issue is that the gross weight is wrong when I calculate the gross weight using the total pound qty in the report. I believe this is due to the gross weight being calculated line by line.
Hence, I want to seek help from the expert here in solving this issue.
PS: I have tried grouping the same color together, but this can be done if the multiple lines of color belong to the same PO number.
The issue I am facing is when I do a combine PO, for example, if the first PO blue color has very small qty, then I will combine it with the second PO blue color. The total sum of the pound qty and yards qty is correct when it is displayed in the report. The only issue is that the gross weight is wrong when I calculate the gross weight using the total pound qty in the report. I believe this is due to the gross weight being calculated line by line.
Hence, I want to seek help from the expert here in solving this issue.
PS: I have tried grouping the same color together, but this can be done if the multiple lines of color belong to the same PO number.