Microsoft Dynamics GP (Archived)

Stock Aging Report

(0) Share

Report

Posted on by Community Member

Hi,

I need to create a stock aging report in GP does any one have a query that generate an 'as of date' report ?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

Hi, have you triedHistorical stock status onder inventory reports?

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

You say 'stock aging', are you looking for a report that will tell you how old your inventory layers are? That information lives in the Purchase Receipts table. IV10200. Otherwise, Alvaro's suggestion of the Historical Inventory Trial Balance is your best bet.

Kind regards,

Leslie

Was this reply helpful? Yes No
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

We have this view wich will tell you when the last purchase was made and when the last sale, maybe it can help you.

Really don't remember where we got this from.

SELECT     I.ITEMNMBR AS Item_Number, I.ITEMDESC AS Item_Description, Q.QTYONHND AS Quantity_on_Hand, U.BASEUOFM AS U_of_M,
                      CASE I.ITEMTYPE WHEN 1 THEN 'Sales Inventory' WHEN 2 THEN 'Discontinued' WHEN 3 THEN 'Kit' WHEN 4 THEN 'Misc Charges' WHEN 5 THEN 'Services' WHEN 6 THEN 'Flat Fee' END AS Item_Type,
                       I.CURRCOST AS Current_Cost, I.ITMCLSCD AS Item_Class, COALESCE (S.LastSale, '1/1/1900') AS Last_Sale_Date, COALESCE (Q.LSRCPTDT, '1/1/1900') AS Last_Receipt_Date,
                      COALESCE (Q.LSORDVND, '') AS Last_Vendor
FROM         dbo.IV00101 AS I LEFT OUTER JOIN
                          (SELECT     ITEMNMBR, MAX(DOCDATE) AS LastSale
                            FROM          dbo.IV30300
                            WHERE      (DOCTYPE = 6)
                            GROUP BY ITEMNMBR) AS S ON I.ITEMNMBR = S.ITEMNMBR INNER JOIN
                      dbo.IV00102 AS Q ON I.ITEMNMBR = Q.ITEMNMBR AND Q.RCRDTYPE = 1 INNER JOIN
                      dbo.IV40201 AS U ON U.UOMSCHDL = I.UOMSCHDL
WHERE     (Q.QTYONHND <> 0)

Was this reply helpful? Yes No
KirkLivermont 5,985 on at

Like (0)

Report

Alvaro,

That looks like Victoria Yudin's work.

victoriayudin.com/.../dynamics-gp-inventory-by-location-with-dates-and-sites

Kirk

Was this reply helpful? Yes No
Alvaro Rodríguez Ochoa 2,395 on at

Like (0)

Report

It could be, since we take some of her awsome scripts.

I never intended to take credit from it.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi Ahmed,

Can you please help me to get an inventory aging on a "as of date" on microsft gp (I need to obtain for 31.12.2017)

thank you,

Shifan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi leslie,

Since Iam new to GP i would like to know if I can get an Inventory aging as of 31.12.2017

please advice

thank you,

shifan

Was this reply helpful? Yes No