Inventory Close & Adjust Error

  • Inventory Close & Adjust Error

    Posted by Matthew Field on September 5, 2018 at 3:28 pm
    • Matthew Field

      Member

      September 5, 2018 at 3:28 PM

      Hi All

      We have a situation in one of our entities where our monthly inventory close didn’t complete because of the attached/below error.
      Has anyone seen this before, or have any advice on how to proceed here? The inventory close is currently paused, waiting for this to be fixed.

      Infolog for job Close inventory (5638798342)
      Infolog for task Posting to ledger (5653130236)
      Posting to ledger
      Item number:
      Account number for transaction type Never ledger does not exist.
      Item number:
      Reported from company accounts tqe
      Item number:
      Posting has been canceled.
      Item number:
      Closing is being paused because of an error.
      Item number:
      Please fix the problem and resume the calculation.

      Thanks

      Matthew Field
      mfield@thorlabs.com

      ——————————
      Matthew Field
      AX Technician
      Thorlabs Inc.
      NJ
      ——————————

    • Dave Phillips

      Member

      September 6, 2018 at 8:58 AM

      Hi Matthew –Ā 

      Looks like you need a KB.

      https://fix.lcs.dynamics.com/issue/results/?q=3087592

      “Account number for transaction type Never ledger does not exist” error in inventory closing for project transactions
      AX 2012 | Application update
      KB 3087592 released 8/18/2015

      Code changes do not look too bad.

      Thanks…..Dave

      ——————————
      Dave Phillips
      Sr Support Escalation Engineer
      Microsoft
      Fargo ND
      ——————————
      ——————————————-

    • Kimberly Tallman

      Member

      September 6, 2018 at 10:25 PM

      Matthew,Ā 
      If you’re on 2012 or earlier, run a consistency check as that looks like a data issue. Did any transactions get uploaded/imported/updated via script during the last fiscal period? I’d start there as there obviously isn’t a transaction type of ‘never’. If it were just a posting profile/missing ledger account issue, you’d have a different error.Ā 
      Thanks,
      Kim

      ——————————
      Kimberly Tallman
      Solution Architect
      Hitachi Solutions
      Indianapolis IN
      ——————————
      ——————————————-

    • Mark Prouty

      Member

      September 7, 2018 at 11:10 AM

      ?The Never Ledger comes from a project transaction that isĀ associated with an item. Check the project transaction posting table for an item with the Never ledger posting type within the period. Check that item posting profile, and how it is setup. Ours are non-costed non-inventoried service items without project categoryĀ that post to a specific GL account (for Revenue or PO Receipt & Consumption, for example).

      ——————————
      Mark Prouty
      Programmer / Analyst
      ANGI Energy Systems
      Janesville WI
      ——————————
      ——————————————-

    Matthew Field replied 6 years, 12 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘Inventory Close & Adjust Error’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

Here you will find a wealth of information created for peopleĀ  that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!