User login
|
|
Frontpage Sponsor
|
|
Google search
|
|
Poll
|
For ERP LN feature pack upgrade, what method of install are you using? Installation Wizard into existing VRC 38% Installation Wizard into new VRC 38% Manual into existing VRC 5% Manual into new VRC 19% Total votes: 42 |
Baanboard at LinkedIn
|

|
|
|
 |

1st November 2017, 13:12
|
 |
Member
|
|
Join Date: Oct 2013
Posts: 50
|
|
Baan: ERP LN -
DB: sqlserver 2012 -
OS: winxp
|
Hello,
There is Always one Entry for Item is Present in Item Inventory (whwmd4100m100) session .For Newly Generated Item it is Always There.
I want to Track at what transaction, 0 value entry for Item inserted in Item Inventory (whwmd4100m100) session
|

14th November 2017, 05:44
|
 |
Senior Member
|
|
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 150
|
|
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 -
DB: SQL Server -
OS: Windows
|
Hi,
Technically, the Item Inventory Session's Main Table is whwmd400. So, when you create an item, and fill the Item-Warehousing Data, the record is visible in Item Inventory Session with Zero Values.
Let me know if you need more details.
__________________
Sasi Kanth V
Infor ERP LN Solution Architect
Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
|

15th November 2017, 03:58
|
 |
Member
|
|
Join Date: Oct 2013
Posts: 50
|
|
Baan: ERP LN -
DB: sqlserver 2012 -
OS: winxp
|
Hi sasikanth,
Main table for session whwmd4100m100 is tcibd100 .
|

15th November 2017, 06:38
|
 |
Senior Member
|
|
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 150
|
|
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 -
DB: SQL Server -
OS: Windows
|
Hi,
May I know which version of ERP LN you're using?
In 10.5, the main table of the session whwmd4100m100 is WHWMD400, and tcibd100 is now an obsolete table.
I've quickly checked in FP7 environment in which, the main table of the Item Inventory session is tcibd100.
Just for your info 
__________________
Sasi Kanth V
Infor ERP LN Solution Architect
Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
|

5th April 2018, 10:03
|
 |
Senior Member
|
|
Join Date: Jan 2002
Location: Ede, The Netherlands
Posts: 165
|
|
Baan: MK, BaanIV, B5.0b until LN -
DB: - -
OS: Unix; AS/400; Windows2000
|
The table tcibd100 is indeed obsolete - it was phased out as of LN 10.2.1 to reduce locking during inventory transactions.
Main table for the "Item Inventory" (whwmd4100m100) session is whwmd400 - as it contains all items for warehousing.
The inventory overview in whwmd4100m100 is a sum of the whwmd215 quantities. ("Warehouse - Item Inventory" (whwmd2515m000) session)
__________________
Regards,
Kees de Jong, CPIM
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
|
|
Thread Tools |
|
Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|