Highligh out of stock items

[Former Member]

Dear All,

I am having a requirement were by when am copying my sales order to invoice i have some items out of stock and the invoice may have too many lines.

Can i have a query that highlights all items out of stock when copied to the invoice.

Regards,

Francis

[kothandaraman_nagarajan]

Hi,

Activate in-stock field from Form settings to view stock from all warehouses.

Thanks.

[Former Member]

Hi Francis,

Use this FMS Query in any of the  row level column in  AR invoice

SELECT w.OnHand  FROM OITW w where w.ItemCode =$[$38.1.0] and w.WhsCode=$[$38.24.0]

Regards,

BHARATHIRAJA J

[Former Member]

how does this operate

[Former Member]

Have put it on one of the columns but isnt working

[Former Member]

Kindly paste the screen shot of your screen

[Former Member]

the lat item has nothing in stock