Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th January 2007, 16:18
steril1 steril1 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
steril1 is on a distinguished road
Baan: Baan 4c4 - DB: Unix - OS: nt
Difficulty getting the TB to match Inv Valuation Report
Baan: Baan IVc4

I'm having a difficult time getting the Inventory GL accounts (Trial Balance) to match the "Inventory Valuation by Item" Report (tdinv6230m000). I have run session tdinv0253m000 (Rebuild 'Historical Inventory Balance'). Can anyone give me some help on this issue? What steps can I take to get these to match??
Reply With Quote
  #2  
Old 2nd March 2007, 04:32
toletofhitachi toletofhitachi is offline
Member
 
Join Date: Feb 2007
Posts: 35
toletofhitachi is on a distinguished road
Baan: Baan 5c - DB: SQL - OS: Server 2000
I am having the same problem matching Perform Inventory Valuation (By Warehouse) against Trial Balance (By Dimension/Ledger Code). Anyone has got the same problem but have solved it?
Reply With Quote
  #3  
Old 2nd March 2007, 07:06
Delfri Delfri is offline
Junior Member
 
Join Date: Feb 2007
Posts: 9
Delfri is on a distinguished road
Baan: Baan IV - DB: SQL - OS: Windows 2000
When an inventory valuation is undertaken using tdinv6230m000, the way in which that valuation is undertaken depends on the valuation date:
- when this date is the actual system date ("today"), the stock value is taken directly from tdinv001.
*- when this date is a date from the past, the stock value for that date is calculated departing from the "historic inventory balance" and then by adding and subtracting all the inventory mutations stored in tdinv700 up (forward in time) until the date in the past is reached for which the stock valuation is made.
[These two ways explain why - even without any stock mutations - the stock valuation for today may differ from the stock valuation for some day in the past. The records from tdinv700 must have been lost by some event].

SOLUTION Comprises of four main steps:
1. Make sure that the system shows inventory values consistently:
Run the diagnostic program tdinv0252m000 that produces a report (no changes in the database will be made). The stock values from the tables, itm001 and inv001 have to be the same. If Location Control or Lot Control is used then ilc101 and ltc001 also have to be the same. If there are inconsistencies then these have to be corrected first. How this is done depends on the differences found for each item. After this correction the system data is internally consistent.
2. Make sure that the (consistent) system inventory reflects reality in the warehouse:
Perform a Warehouse Cycle Counting, in order to determine the real stock physically present. After completion of the Cycle Counting procedure the system will have the correct inventory numbers.
In a specific situation you can probably think of a more efficient way to trace and correct the possible discrepancies between the system inventory values and the real inventory values. You will certainly be able to think of a more efficient way if you have some idea about the reason for the inventory differences. These corrections can then be input via session tdinv1101m000 or tdilc1120m000 (in case of ILC). After this step the system data will reflect reality again.
3. Run correction program tdinv0253m000 (It should be started from the command line - after 'P'; changes in the database are made or not made depending on the choice you make in the menu that appears); WHILE RUNNING, NO INVENTORY MUTATIONS MUST BE MADE BY A USER.
*This program departs from the actual stock on hand (from tdinv001) and calculates back in time adding and subtracting all inventory changes (taken from table tdinv700) until it has receded to the earliest mutation present. That oldest date (per warehouse and per item) will be stored as the "date of the historic inventory balance" and the earliest stock that was recalculated in this way, will be stored as the "historic inventory balance" (both in table inv001).
4. Correction in FINANCE
E.g. when closing the month in Finance and after having booked all inventory mutations to Finance, a difference still may be found between the stock valuation (as described) and the corresponding ledger account or balance sheet. This difference then has to be corrected once on some date X by a manual booking in Finance. After this correction inventory data and Finance are consistent again for date X (and later).
Stock valuations (tdinv6230m000) done later for some date after date X now have to correspond again with the financial data. When performing a stock valuation (after this correction procedure) for a date before date X one will still find, that the stock value differs from Finance (since apparently some tdinv700 stock mutations were lost; these are basic and cannot be retrieved from other data in the system).
Reply With Quote
  #4  
Old 5th March 2007, 02:07
toletofhitachi toletofhitachi is offline
Member
 
Join Date: Feb 2007
Posts: 35
toletofhitachi is on a distinguished road
Baan: Baan 5c - DB: SQL - OS: Server 2000
Thanks Delfri but I am running on Baan5c. I wouldn't be able to run tdinv sessions.
Reply With Quote
Sponsored Links
  #5  
Old 7th March 2007, 04:58
steril1 steril1 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
steril1 is on a distinguished road
Baan: Baan 4c4 - DB: Unix - OS: nt
Smile

Thanks Delfri!! I will give this a try!!
Reply With Quote
  #6  
Old 7th March 2007, 14:26
Sai_krishna Sai_krishna is offline
Member
 
Join Date: Jan 2002
Location: Pune
Posts: 95
Sai_krishna is on a distinguished road
Baan: IV,V,LN - DB: Oracle,SQL - OS: NT,UNIX
Check Integration Transactions

Quote:
Originally Posted by toletofhitachi View Post
Thanks Delfri but I am running on Baan5c. I wouldn't be able to run tdinv sessions.
Check that all integration transactions are posted. Also check your inventory valuation methods and the way you account for variances if any.. If still not resolved, go back to the date when both the amounts match and try to do a reconciliation for receipt and issue amounts separately.

Regards
Sai Krishna
Reply With Quote
  #7  
Old 22nd May 2007, 11:06
toletofhitachi toletofhitachi is offline
Member
 
Join Date: Feb 2007
Posts: 35
toletofhitachi is on a distinguished road
Baan: Baan 5c - DB: SQL - OS: Server 2000
Hi,

which session to run in Baan V? (Baan Iv is tdinv0252m000)

Thank you.

Regards,
Danny Kat
Reply With Quote
Reply


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
print 2nd report from 1st report script cmandal Tools Development 6 14th October 2012 23:56
solving recursion problems rmarles Tools Development 2 25th January 2005 21:23
Report to RTF mostrightfuture Tools Development 1 21st October 2004 17:32
tfacp9450m000 FIBU Brush Up Kai's Forum Users Deutsches Forum 1 16th November 1999 00:00


All times are GMT +2. The time now is 07:23.


©2001-2017 - Baanboard.com - Baanforums.com