Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 19th June 2003, 20:39
Richard Sharp's Avatar
Richard Sharp Richard Sharp is offline
Junior Member
Join Date: May 2002
Location: PA
Posts: 3
Richard Sharp is on a distinguished road
Baan: Baan 4c4 - DB: Oracle - OS: Windows XP
Lightbulb Cycle Count Financial Impact

I am looking for a way to determine what the financial result of a cycle count will be, prior to actually processing the count.

I've been performing a manual calculation by importing the cycle count check report into Excel and then performing a vlookup function to get the standard cost by item.

Can anyone tell me if there is quicker and less tedious way of getting this info?

Reply With Quote
Old 19th June 2003, 20:54
RamSundar RamSundar is offline
Join Date: Mar 2002
Location: USA
Posts: 47
RamSundar is on a distinguished road
Baan: BaaN IVc3 - DB: Oracle - OS: HP-Unix
Create a simple Easy SQL Query

You can generate an Easy SQL query like this...

select tdilc501.item, tdilc501.cwar, tdilc501.loca,
tdilc501.clot, tdilc501.qstk, tdilc501.cstk,
tiitm001.dsca, tiitm001.copr
from tdilc501, tiitm001
where tdilc501.item refers to tiitm001

The output of this can be taken to excel and then it can be analyzed by Item, Warehouse, etc. Alternatively, you can also create a print session based on the tdilc501 & tiitm001 tables.

I have created several reports on the cycle counts sorted by Warehouse, by Location, by Item, by Item Group, by Item Type, etc.

Reply With Quote
Sponsored Links

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
Hiring Nationally - Financial Systems Implementation Consultants blackbaud Jobs and Resumes 0 17th March 2004 21:48
Is this possible? Please help sasa888 Tools Development 2 4th November 2003 21:50
Count of records baanlegend Third Party Products 5 22nd May 2003 20:06
Group and Count Records ken bohnenkamp Tools Development 3 7th January 2003 05:43
Backdating purchase receipts / Financial impact? Doug Jefferson Finance, Invoicing and Integration 1 17th April 2002 22:59

All times are GMT +2. The time now is 13:26.

©2001-2018 - -