crystal report selection criteria

Posted By tendresen over 10 years ago

When creating a crystal report, can I have different select criteria for different records within the same report? For example, I am attempting to create a SMOI report and need current Inventory information ie, quantity on hand, average cost, etc but also need the unit sales history for a specific range of time ? I seem to be able to have one set of data or the other, but never both?

Do I need to create the historical sale of units as a different group with different select criteria within the same report? Ultimately, this report will just be exported to excel as a master data record and resorted and formatted. I am just trying to get all the data I need on one crystal report

Thanks,

0 BigLouie over 10 years ago

Yes you can do that, which tables were you planning on using?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tendresen over 10 years ago in reply to BigLouie

For the current inventory information -I am using the IM1_InventoryMasterfile and IM2_InventoryItemWhseDetl (value is greater than 0) for the current Inventory information.

For the units sold by sku within a specific time frame -I am using the IM5_InventoryTransactionDetail with the criteria of "SO" as transaction type and transaction date range is 10/1/2012 - 3/31/2014.

I either get the inventory value to agree with my current day value but units sold is incorrect, or my units sold is correct but the inventory value is less than actual as some skus did not have sales in that date range and were not included in the report.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TomTarget over 10 years ago in reply to tendresen

How do you have the tables linked?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 tendresen over 10 years ago in reply to TomTarget

Yes... the key is Item number
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 MJZ over 10 years ago in reply to tendresen

IM5_InventoryTransactionDetail should probably be a left out join in case you did not have a transaction for an inventory item. If you have an equal join, only records with transactions will be pulled in. Also, if you have multiple warehouses, do you have the IM5 linked to the Master or the Warehouse? What version of Mas are you running?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

crystal report selection criteria

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING