We are trying to get the lot numbers of the items against the transaction, Inventory transfer. For this we are refering table tdilc103 but only getting few records in the report.

We checked in the session Enter Inventory Transactions (tdilc1120m000) all inventory transfer enteries are there in the seesion (in the table tdinv100). But when I press the continue button available on the form1, open the sub session Maintain Inventory Transfers by lot and location 'tdilc1122s000' is blank for those records which we are not getting on the report.

Is there any criteria for storing the record in the table tdilc103. Means, as long as the lot is not consumed totaly, only till the record exists in this session or what....

And can you please make available any functional manual for understanding the flow of item by lot and location.

Thanks
Abhivyakti

I am not very clear about the proble. Which report session are you using to show inventory transactions by lot and location? tdilc3410 should meet all your requirements? or is your problem that all the records are not present in ilc301 fro some of the transactions? If so there should be a difference in inv and ilc (since you say that all the records are present in inv100. If there is a difference between ilc and inv you can check thru session tdinv0252 but take care to see that the 'Adjust' button is set to 'No'

hope this helps

regards

Jayant

Hi Jayant,

Can you tell me what exactly the session tdinv0252 do??

Thanks
Abhivyakti

Hi Abhivyakti

tdinv0252 compares stocks in ilc101 with stocks in 1) itm001 , 2) inv001 and 3) ltc001 and prints out three difference reports.

The session assumes that ilc101 stock is correct and if the field 'Adjust Yes/ No' is set to Yes then it changes the stock in these three tables to match with the ilc101 stock. This is not a desirable situation becuase financial entries are generated on the basis of inv tables and if these stocks are adjusted without a corresponding financiala entry there will be difference in the stock value per Distributon and stock value per finance

Hope this helps

Regards

Jayant

Hi Jayant,

Can you please tell me, where this session is attached in the main menu browser.

Thanks
Abhivyakti

Hi Abhivyakti

The session is not on the menu browser. You will have to run it from Run Programme

Regards

Why so???

BTW here will be more session like this from where we will get those sessions list.

Abhivyakti

There are certain sessions which should not be directly available to normal users. So these would not be available on normal browser.

You will come to know of such sessions through experience, or you can browse throgh session lists for a module when you face a problem. e.g. there are a lot of correcetion session in each module.

Regarsd

Hi Jayant,

Thanks a lot!!!! for the info.

Abhivyakti

Dear Abhivyakti,

As a basic, to check whether an inventory transaction actually takes place or not, pls refer to tdinv700. This applies to ILC and non ILC settings. If it's not there, then the transaction never happened or, as in your case, might not have been recorded completely.

You are seeing none in tdilc1122s000 because the transfer has not been recorded completely. After specifying the item, source WH, target WH, and qty to transfer in tdilc1120m000, the user should have recorded what lot are to be transferred and how much in tdilc1122s000. Even if the item were not lot controlled, this last step must still be performed by specifying empty lot number. This last step was not performed. Because of this, the transfer doesn't appear in tdilc103, tdinv700, and other related "inventory transaction history" tables

Rgds,
Paul

Hi Paul,

Thanks for the reply!

Specifying following for the reference:
1. ILC is implemented.
2. Items are Lot controlled.
3. Transaction exists in the tdinv700 but not in tdilc103 and
tcilc301.
4. This problem is occuring in many records.

You said that 'last step was not performed.' :confused: Then how come the transaction has taken place.


Any idea...........

Abhivyakti

Abhivyakti, have you checked with Baan Support on this yet?

Paul

Hi Paul,

Yes! I have checked this with the Baan Support. But they are having no idea.

For further details you can see case# 1010838 on Baan support.

Can you pl. help us.
Abhivyakti