Add Categories in Sales Report

From Sage Intelligence Knowledgebase
Jump to: navigation, search

Question

I want to create a Sales report in B.I.C. Evolution 6.0.39 but the categories I want to use are not available under the Columns tab.

I make use of Groups, Pack Codes, Bin numbers and Barcodes.

Is there a way to add these categories in order to get a sales report according to this Item Information?

Answer

Launch the BIC Administrator and go to your Sales Master Container e.g. Sales Master 3-2 (Evo)

Select add Expression and select the StkItem Table

Next select the following items from the list.

iBinLocationID for BIN

Bar_Code for BARCODE

ItemGroup for GROUP

Pack for PACK

You can now add them to your Sales Master report in the Report Manager.