Posts

Showing posts from February, 2018

The request failed with HTTP status 405: Method Not Allowed

Image
The request failed with HTTP status 405: Method Not Allowed HTTP Error 404.17 - Not Found The requested content appears to be script and will not be served by the static file handler. Just Select .asmx and click "Revert to Inherit" to solve the problem

Software for Auto Parts Industry by Somiware Solutions

Image
Software for Auto Parts Industry The Global Automotive Industry is continuing its on-going transformation from initially providing basic transportation to technology driven smart mobility. However, in order to stay profitable and competitive auto software manufactures need to address significant industry challenges such as rising costs, increasing product complexity, and government regulations. Our Automotive Parts Industry solutions experts work with our client companies within the industry to help them enhance their competitive advantage and grow their market share by providing  state of the art solutions that align with Industry Best Practices and the most advanced Technology.    SOMIWARE Solutions offers a full array of options which enables you to select the solution that works best for your company.” Your complete satisfaction is our ultimate goal. Call : + 923328244088

Inventory Aging Code for Dynamics AX February 06, 2018

SELECT ITEMID, DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) AS AGEDDAYS, (CASE WHEN QTY>0 THEN QTY ELSE 0 END) AS PURQTY, (CASE WHEN QTY<0 THEN qty ELSE 0 END) AS SALQTY, (CASE WHEN DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) < 0 THEN '0-Current' WHEN ( DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) > 0 AND DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) <= 30 ) THEN '1-0-30 Days' -- 1 month WHEN ( DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) > 30 AND DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) <= 60 ) THEN '2-31-60 Days' -- 2 months WHEN ( DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) > 60 AND DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) <= 90 ) THEN '3-61-90 Days' -- 3 months WHEN ( DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) > 90 AND DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE) <= 180 ) THEN '4-91-180 Days' -- 6 months WHEN ( DATEDIFF(day, INVENTTRANS.DATEPHYSICAL, @TODATE)