Skip to Content
0

Batch and Serial Quantity and line total Query correction

Nov 15, 2016 at 05:00 AM

76

avatar image

,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"

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bhanu Pratap Sharma Dec 08, 2016 at 07:30 AM
0

Hi,

Please post full query..

Regards

BHanu

Share
10 |10000 characters needed characters left characters exceeded
Kedalene Chong Dec 08, 2016 at 07:50 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded