Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

Crystal Report: HELP! (Item Sales History report)

Posted By helmt01 over 7 years ago

To anyone out there who can help with this...I would be most grateful!

Our boss needs a very specific Item Sales History report for Fiscal Year '2016' that should include the following as COLUMNS (if possible):

Item Code, Item Description, Qty Sold, Dollars Sold, Unit Cost, Avg. Unit Cost, Unit Price, Retail Price and COGs

Because some of our items (Qtrly material) are sold in the 4th Qtr of 2015 (Periods 11 & 12), those totals/line items need to be included in the resulting report for 2016.

Any input would be greatly appreciated! Thanks for your time.

- T. Helm

0 BigLouie over 7 years ago

Some of this, well most of this will be in the IM_ItemWhseHistoryByPeriod and the rest will be in CI_Item.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 helmt01 over 7 years ago in reply to BigLouie

Thank you, yes - I've discovered that. I have a report but it isn't totaling the sum of ALL warehouse qty sold (it breaks it down by warehouse, by period. I am looking for something that will do this, and well as summarize all that was sold (dollars/quantities) for the period of 11/1/2015 - 12/31/2016.
Cancel
Vote Up -1 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Crystal Report: HELP! (Item Sales History report)

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING