web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Difference in Inventor...
Microsoft Dynamics AX (Archived)

Difference in Inventory Sub ledger Vs. GL

(0) ShareShare
ReportReport
Posted on by Sajjad_00 477

Dear All,

              is anyone know about the Inventory Aging / Inventory Value / Potential conflict report and have a drill down on it how it bring the data and from which tables are involved in it.

Q2. I am having a difference in inventory aging report between two columns on hand Qty and Inventory value Qty and same with on hand value  and inventory value why it is like that. what is the meaning of Inventory value Qty / value column.

Item group Item number Product name Inventory unit Site Warehouse On-hand quantity On-hand value Inventory value qty Inventory value
RM 01002-01000006 MCCB KIT,MF1-Series,Type,MF1-400S,300A,3Pole,With Lock & Key and as per SEC Spec, 37-SDMS-01, Rev-02 Pcs Site1 Prod                                            -                                      -                                            1.00                                  69.35
RM 01105-08000004 MCC Tube 65/30 MTR Site1 Central                                            -                                      -                                      300.00                            1,635.00
RM 01105-24000007 Yellow Mastic 85 (500mmx3pc) Pcs Site1 Central                                            -                                      -                                            2.00                                  1.56
RM 01106-00000071 Carton Box 12p Pcs Site1 Central                                            -                                      -                                    2,500.00                                  43.79
RM 01106-00000075 Carton Box A-500 odpr. Pcs Site1 Central                                            -                                      -                                  18,900.00                            1,054.00
RM 01106-00000075 Carton Box A-500 odpr. Pcs Site1 Prod                                            -                                      -                                      125.00                                  6.97
RM 01107-05000002 Indoor,18 Way INCOMER Frame MCCB,MF1-100DB,3Pole,New Design and as per MOH Specification. Pcs Site1 Prod                                            -                                      -                                            1.00                                      -  
RM 01107-14000003 Indoor,36 Way DB,with INCOMER MCCB,MF1-225DB,3Pole. Pcs Site1 Central                                            -                                      -                                      288.00                        118,944.00
RM 01107-25000003 Indoor MDB,Type MD,with Main Incomer, MF2S-250S, 3P, 160A, with Branch MCCBs, MF1-100-DB, 3P (2pc). PCS Site1 Central                                            -                                      -                                            1.00                                668.00
RM 01108-05000002 Thinner-507 LITER Site1 Prod                                            -                                      -                                      140.00                            2,660.00
RM 01202-02000003 MCCB,MF2-Series,Type,MF2-250S,160A,3Pole,with Push to Trip,Thermal Magnetic Adjustable (80% of rated Pcs Site1 Central                                            -                                      -                                    5,549.00                    2,767,408.19
RM 01202-02000003 MCCB,MF2-Series,Type,MF2-250S,160A,3Pole,with Push to Trip,Thermal Magnetic Adjustable (80% of rated Pcs Site1 Prod                                            -                                      -                                      531.00                        264,846.06
RM 01204-04000005 DC Voltmeter,Type ME-96,150V,CL-1,100%OL,90° Pcs Site1 Prod                                            -                                      -                                                  -                                  960.66
RM 01204-17000021 AC Power Meter (Wattmeter),Type EQ2207 1B, PT: 0-66.39V (132kV/0.115V)/√3, x/1A, (800/1A),Scale: 0-1 PCS Site1 Central                                            -                                      -                                      100.00                          36,958.00
RM 01204-17000022 AC Power Meter (Varmeter),Type EQ2207 1B, PT: 0-66.39V (132kV/0.115V)/√3, x/1A, (800/1A),Scale: 0-14 PCS Site1 Central                                            -                                      -                                      100.00                          36,958.00
RM 01204-17000023 AC Power Meter (Wattmeter),Type EQ2207 4B, PT: 0-66.39V (132kV/0.115V)/√3, x/1A, (1200/1A),Scale: 0- PCS Site1 Central                                            -                                      -                                      100.00                          36,958.00
RM 01206-02000017 MCB,Type ETIMAT-10,6A,2 Pole,10KA Pcs Site1 Prod                                            -                                      -                                            3.00                                101.66
RM 01350-08000041 Vertical Side Pillar for Base Pcs Site1 MEMF                                            -                                      -                                                  -                                  (39.31)

Q3. I am having a difference in Inventory sub ledger vs. GL. how can I trace out this. I already try these three reports but no result. 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi,

    The potential conflicts report check numerous things including parameter setups, etc. If you want to find out what this report includes you have to dig down into the inventledgerconflict classes.

    About the inventory aging report:

    Please have a look at the following website that includes a link to a video that explains the inventory aging report in detail.

    blogs.msdn.com/.../new-costing-features-in-dynamics-ax-2012-r3.aspx

    Hope it helps,

    Ludwig

  • Sajjad_00 Profile Picture
    Sajjad_00 477 on at

    Thanks for your reply. Sorry I didn't write my AX 2012 R2. i am getting out of time and not understanding what to do to rectify the difference in sub ledger vs GL.

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at

    Hi Sajjad Ahmed,

    There can be several reasons why you see a difference.

    One might be if you post your subledgers in batch to GL. If not each and every subledger transaction is transferred you will see a difference that actually does not exist.

    Another reason might be subcontracting items that cause a difference until the corresponding vendor invoice is posted.

    I listed some of the problems of the inventory value report and the potential conflicts report here: dynamicsax-fico.com/.../pitfalls-of-the-inventory-value-report-and-the-potential-conflicts-report

    These issues might give you an idea why a difference might arise between GL and inventory balances.

    Unfortunately, often there is not much that you can do.

    It is just a weakness of AX

    All the best,

    Ludwig

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans