Skip to Content

Batch and Serial Quantity and line total Query correction

,CASE WHEN t5."ManBtchNum" = 'Y' And T1."BaseType" <> 15 THEN TO_INT(a."Quantity")
WHEN t5."ManSerNum" = 'Y' And T1."BaseType" <> 15 THEN d."Quantity"
WHEN t5."ManBtchNum" = 'Y' And T1."BaseType" = 15 THEN TO_INT(e."Quantity")
WHEN t5."ManSerNum" = 'Y' And T1."BaseType" = 15 THEN f."Quantity"
Else TO_INT(t1."Quantity") END as "Quantity"

,a."ExpDate" AS "Expiry Date"
,T1."PriceBefDi" as "Unit Price"
,T1."DiscPrcnt" as "Discount % per Row"
,T1."LineTotal" as "Line Total"

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 08, 2016 at 07:30 AM

    Hi,

    Please post full query..

    Regards

    BHanu

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 08, 2016 at 07:50 AM

    Hi Bhanu

    Thanks for reply. Already found out not possible to display specific Batch quantity and Batch Number from Invoice Table, has to be Delivery Order Table if posted Delivery prior copy to Invoice. This Invoice Query is not showing Batch Number and Quantity correctly if Delivery Order is copied to AR Invoice for billing partial quantity.

    Add comment
    10|10000 characters needed characters exceeded