Baanboard.com

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

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 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?

Thanks!
Reply With Quote
  #2  
Old 19th June 2003, 20:54
RamSundar RamSundar is offline
Member
 
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.

Ram.
Reply With Quote
Sponsored Links
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
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 08:45.


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