Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


Google search

For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
Installation Wizard into new VRC
Manual into existing VRC
Manual into new VRC
Total votes: 45

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 1st December 2003, 13:31
Kotharu Narayan Kotharu Narayan is offline
Join Date: Nov 2002
Location: Dubai
Posts: 71
Kotharu Narayan is on a distinguished road
Baan: IV c 4 - DB: Informix - OS: Unix
Inventory balances-Logistics/Finance


There is difference in inventory balances between Distribution and Finance. Session tdinv6230m000 is run and the values shown there in are different from the the ledger balances and the corresponding dimensions.
Any other session in logistics to print inventory reports? How to reconcile both?

Reply With Quote
Sponsored Links
Old 3rd December 2003, 06:34
himanshu himanshu is offline
Join Date: Nov 2001
Posts: 45
himanshu is on a distinguished road
We have developed a few reports for the reconcillation purpose. There is no standard report from BaaN to carry out the required reco.
Mail me I would forward the program logic and if you have a good tools expert get it dveloped in -house.
Himanshu Srivastava
Reply With Quote
Old 6th December 2003, 06:18
Kotharu Narayan Kotharu Narayan is offline
Join Date: Nov 2002
Location: Dubai
Posts: 71
Kotharu Narayan is on a distinguished road
Baan: IV c 4 - DB: Informix - OS: Unix
Hi Himanshu,

Thanks for the reply. can you please send the program logic to my mail

Thanks once again.
Reply With Quote
Old 7th December 2003, 14:57
baanmanindia69 baanmanindia69 is offline
Join Date: Dec 2002
Posts: 60
baanmanindia69 is on a distinguished road
Baan: BaaN IV -


There are certain serious issues with Finance & Distribution inventory especially when the items are valued at lot prices (You may note that the accounting standards require that the inventory should be valued at 'cost', which is nothing but lot prices). Hence we can not value at FTP.

But in BaaN the lot prices are dynamic and the lot price history is not stored anywhere, unlike the standard price history. Hence if you want to value inventory as on a particular date, say at the month end, you will get inventory as on the month end, but valued at CURRENT lot price. But finance postings consider the value based upon the posting period. Hence the Finance & Distribution inventory can never match, with the standard mechanism. We have overcome this problem with the following procedure.

We take a back up of lot price as at the month end. (At 12o'clock night, precisely). This price represents the result of all transactions, variences etc that has taken place during the month. Anyway, ledger posting is based upon the fiscal period. We close the period sharply at the month end. We have customized a report of inventory valuation by Cost price components, based upon the above table (table created for the purpose of backup). Finance mapping is maintained based upon Cost price Components.

With this, the Finance Inventory & Distribution inventory must tally. Anyway, there some difference still, and this is because of our own operation issues, like the user changing the cost price component/item group in the item master level, at the middle of the month, etc. Otherwise, the inventories must tally.

Himanshu, can you please forward me also the program logic. My email id is

Reply With Quote
Old 9th December 2003, 09:01
Jayant Keskar's Avatar
Jayant Keskar Jayant Keskar is offline
Join Date: Jan 2002
Location: Sharjah UAE
Posts: 66
Jayant Keskar is on a distinguished road
Baan: IVc4 - DB: Informix - OS: Sun Solaris
Hi Himanshu

Could you send the programme login to me also My email

Reply With Quote
Old 12th December 2003, 01:25
Norman's Avatar
Norman Norman is offline
Join Date: Apr 2002
Location: Melbourne
Posts: 41
Norman is on a distinguished road
Baan: Baan ERP - DB: Oracle - OS: NT
Smile Report Logic


Reconciling stock has always been an issue with Baan. I would appreciate any report logic you may have.

My e-mail is:

Thankyou for your help.

Reply With Quote
Old 19th September 2017, 00:18
ashishj ashishj is offline
Junior Member
Join Date: Apr 2007
Posts: 22
ashishj is on a distinguished road
Baan: ERP LN, Baan V, baanIV - DB: Oracle , sql server 2000 - OS: windows 7, XP
I would appreciate if you can share with me too. I am using ERP LN.

My e-mail is:

Thankyou for your help.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Difference in Inventory and GL balances Anushea Distribution, Transportation & Warehousing 3 19th October 2003 14:15
Purchase Integration Sai_krishna Finance, Invoicing and Integration 4 9th June 2003 19:47
Warehouse Inventory Item - On Hand Inventory does not add up correctly rdbailey Distribution, Transportation & Warehousing 10 14th May 2003 17:07

All times are GMT +2. The time now is 22:31.

©2001-2017 - -