Welcome, Guest. Please Login.
05/06/24 at 04:12:06
News:
Home Help Search Login


Pages: 1
Send Topic Print
Formula to return "0" value (Read 642 times)
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Formula to return "0" value
07/28/08 at 12:45:43
 
I am writing a report that shows how many inventory items were shipped during a time period.  I can not figure out how to get it to list item number and show 0 when 0 shipped during that time period.  I'm using CR10.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
Tim Keating
Senior Member
****


DBA CLASSIC WIN 2000
C/S

Posts: 298
Re: Formula to return "0" value
Reply #1 - 07/28/08 at 14:47:00
 
For this report I would link the Inventory Transaction File, INVTXN, to the Inventory Master File, BKICMSTR.
 
Using the BKIC_PROD_CODE Field, you have the potential to list all entered parts on the report, regardless of whether they have activity or not.
 
Simple report line:
 
BKIC_PROD_CODE     MTIT_DATE     MTIT_TYPE     MTIT_QTY    
 
Sort, filter, group, subtotal and you're there.
Back to top
 
 

Tim Keating
Motor Guard Corporation
Email WWW   IP Logged
Pages: 1
Send Topic Print