Talal_612
Member
Hello Everyone , im new here ,
i want someone to help me in this case ,
i want to sum the quantity of the invoice that have the same Document Number (F4211.DOC) and 2nd item number (F4211.LITM) and display it in one invoice and with the total quantity of it,
this is my code, and when i run it , goes infinity loop when he enter the while after first one ,
While BC Document (Voucher, Invoice, etc.) (F4211)(DOC) is equal to PC Document (Voucher, Invoice, etc.) (F4211) (DOC) And BC 2nd Item Number (F4211)(LITM) is equal to PC 2nd Item Number (F4211) (LITM)
RV Quantity ShippedTOT = [RV Quantity ShippedTOT]+[PC Quantity Shipped (F4211) (SOQS)]
PC Quantity Shipped (F4211) (SOQS) = [BC Quantity Shipped (F4211)(SOQS)]+[PC Quantity Shipped (F4211) (SOQS)]
RV Quantity ShippedTOT = PC Quantity Shipped (F4211) (SOQS)
End While
RV Quantity ShippedTOT = "0"
i want someone to help me in this case ,
i want to sum the quantity of the invoice that have the same Document Number (F4211.DOC) and 2nd item number (F4211.LITM) and display it in one invoice and with the total quantity of it,
this is my code, and when i run it , goes infinity loop when he enter the while after first one ,
While BC Document (Voucher, Invoice, etc.) (F4211)(DOC) is equal to PC Document (Voucher, Invoice, etc.) (F4211) (DOC) And BC 2nd Item Number (F4211)(LITM) is equal to PC 2nd Item Number (F4211) (LITM)
RV Quantity ShippedTOT = [RV Quantity ShippedTOT]+[PC Quantity Shipped (F4211) (SOQS)]
PC Quantity Shipped (F4211) (SOQS) = [BC Quantity Shipped (F4211)(SOQS)]+[PC Quantity Shipped (F4211) (SOQS)]
RV Quantity ShippedTOT = PC Quantity Shipped (F4211) (SOQS)
End While
RV Quantity ShippedTOT = "0"