'TI' Inventory Adjustment Postings

(0) Share

Report

Posted on by User100

Hi,

I am aiming to reconcile our Inventory Adjustment account, which routinely includes entries with a blank Document Type and with Document Numbers in the format 'TI00123'. I believe these entries are created by our Production division to adjust levels of stock holdings, but we have been unable to identify the process that leads to these entries. I joined the company not long ago and past practice has been to allow these entries to build up and almost net off over time, with residual amounts written down to the P&L every so often, however I would like to understand why these transactions occur and what they represent in terms of inventory values.

The related GL entries move amounts between Gross Stock and Inventory Adjustment. They are also recorded as Positive Adjustments or Negative Adjustments within Item Ledger Entries and in the Value Entry table.

It would be great to hear from anyone who can shed light on these transactions!

Many thanks

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Community Member on at

Like (0)

Report

Hello,

To start I would go to the No. Series list to find the Number Series that uses TIxxxxx. This will tell you what No. Series and hopefully the document or journal using the No. Series. Now, if these are from Item Journals, which I am guessing these are, you can trace these using the Item Register. If you search for the Item Register you will see all the entries made by date. In the Item Ledger Entry, you will see the field Entry No. which is the Entry No. value you will see on each Item Register line. Locate the Register and you can examine all the entries effecting the ILE and VE. Any entry made on an Item Journal DOES NOT have a Document Type since it does not come from an Invoice (Purchase/Sales), Purchase Receipt, Sales Shipment, Transfer Receipt/Shipment, Posted Assembly.

Hope this helps.

Thanks,

Steve

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,597 Super User 2025 Season 2 on at

Like (0)

Report

Hi, you can go to No. Series page, to check the description of the TI number.

You can also click Navigate in Item Ledger Entries and Value Entry, you can find out whether it was done manually or automatically created by the system.

Hope this will help.

Thanks.

ZHU

Was this reply helpful? Yes No
User100 5 on at

Like (0)

Report

Hi Steve,

Many thanks indeed - I've followed your suggested steps and found that the entries have been created by our Production team when issuing samples to prospective customers, which I can now follow up.

Kindest regards

Was this reply helpful? Yes No
User100 5 on at

Like (0)

Report

Hi ZHU,

Many thanks for your response, which has helped me to trace these entries.

Kindest regards

Was this reply helpful? Yes No