Trouble getting data from Sales Line

beesterbeester Member Posts: 5
I'm quite new at this so please be patient.

I'm trying to get Qty-Not-Shipped on the Sales Shipment report. I'm using a Get command to get the Qty Not Shipped data from the "Sales Line" table based on the "Sales Shipment Line"."Order No." data but can't get it to function:

IF SalesLine.GET(SalesLine."Document Type"::Order,"Sales Shipment Line"."Order No.")THEN v_QtytoShip:=SalesLine."Qty to Ship";

Regards,

Comments

  • krikikriki Member, Moderator Posts: 9,110
    Try this:
    IF SalesLine.GET(SalesLine."Document Type"::Order,"Sales Shipment Line"."Order No.","Sales Shipment Line"."Order Line No.")THEN
      v_QtytoShip:=SalesLine."Qty to Ship";
    
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • kapamaroukapamarou Member Posts: 1,152
    The code you have posted gets the Qty to Ship. Is it a typo error?
Sign In or Register to comment.