Print Page | Close Window

Having formula Trouble

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4672
Printed Date: 19 May 2024 at 5:59pm


Topic: Having formula Trouble
Posted By: Georgehusong
Subject: Having formula Trouble
Date Posted: 30 Oct 2008 at 9:16am
I have built a report for my company to do inventory checks and ballances and could use some help with the formula...
1  Qty_Recieved-Inventory that was recieved today
2  Qty_Onhand -Current stocked inventory including what was just recieved...!!!
3  Qty_Allocated-To a sales order or transfer
These are all numbers from the Sql Tables
I created the formula named "to Stock" as the number of each item that should be left on the recieving table to be checked off at the end of the day. Which should be Qty recieved - qty allocated not including what we already allocated from on_hand inventory.
I think I have the formula correct as
if mailto:%7b@Old - {@Old On hand} >= {p21_view_inv_loc.qty_allocated} then {p21_view_po_line.qty_received} else if mailto:%7b@Old - {@Old On hand} < {p21_view_inv_loc.qty_allocated} then {p21_view_inv_loc.qty_on_hand} - {p21_view_inv_loc.qty_allocated}


-------------
George Husong


Print Page | Close Window