Would there be anyways that we could base commissions on Customer and then Item Class we would like to sell to Customer ABC Which can buy from Item C...

Yeah, that's exactly I was looking for! Thank you Shawn.

Yes, adding Site Maps to the GI worked! Thank you Tim.

I have added only Generic Inquiry to the customization project. Will add the Site Maps and try publishing the project again.

Thanks Shawn, I manually changed the Screen ID in the customization project, and thats when I got this error

I tried this but getting the following error Column 'SOLine.ShippedQty' is invalid in the select list because it is not contained in eithe...

SO6210001.rpx SO621000.rpx

It gives correct result only for current month. If I change the Date to last month the Total Shipments in not able to give correct values, though the...

I created a sub report for the shipments, but if there are 4 shipments for that customer it shows number 4 on 4 lines 4 4 4 4 How can i limi...

This is the sub report that I created but it is still showing total line count. And it is not visible on the Main report too. Attaching the Main r...

Okay! Can you give me an example of how to use variable in report designer that would give me the count of lines?

This is the report for Shipment details by customer 226-SO621000.rpx The formula =count([SOShipment.ShipmentNbr]) counts all the shipment num...

Had not included sum( ) for shippedqty field which was showing the difference.

Yes I am getting values in the backorder column. The issue is that the Shipped Qty values are not correct.I compared the shipped qty column with the S...

Oh okay. Attaching the .rpx file so62150001.rpx

Was not able to attach the .rps file in the post because it said File type not allowed.The Active Migration checkbox is not checked in the AP screen

I figured out the formula for Fill Rate %, but the shipped qty column does not show the correct value. so could you please take a look at the attached...

Sorry, I don't need the total amount column. So now I have Item | Shipped Qty | Backorders | Fill Rate % How to Calculate Fill Rate%? Fill rate % =...

Thank you Tim! How can I find out the relationship between any 2 tables? Is it listed out somewhere? Is this right?I am confused which field i...

For Sales Comparison by Item Class what should be the relation between ARInvoice and InventoryItem table? Right-click to Download

It worked after using the Aggregation function

Right-click to Download This is the GI

Yes, It worked after changing the Group Collection in the Report designer The mapping wasn't right before

Like for example the Salesperson YS in the screenshot attached the sales for Feb 2018 in the GI we build is 5500 but it shows 35707.77 in Sales Profit...

Also I think the formula for Month to Date sales isn't working correctly, it shows the sales for that particulate date of the docdate rather than maki...

If I want to filter Sales this month last year, is this formula right? =IIf(Year([ARInvoice.DocDate])-1=Year([Today]-1) And Month([ARInvoice.DocDate...

The quantity 38 is for the items with customer class SP

Do you think that by using branches we would be able to create the P&L that I have attached to show sells from the separate Department i see how w...

How can I get sum of all the days in a month? I don't want to display it datewise, I want total sum of sales this month and year

This is exactly what I was looking for. Thank you!

I tried with ARTran and InventoryItem table too, but still it didn't work

I think it is something to do with the table relationships in the schema builder What should be the relationship between Customer and Invento...

Can you please show an example of the GI which would have such two columns using IIF formula?

Yes I am using ARTran.Qty.I tried using ARTran.BaseQty but it didn't show any difference

I tried using Qty from AR and the report showed these values(36 qty shipped) Even the net sales are not accurate (the net sales should be 391.4 b...

Aren't they same? shipped quantities and invoiced quantities?Because whatever gets shipped will be invoiced

Yes, These 3 columns only

Yes, But I am trying to create a new profitability report by Customer Class and Item. I want to display the quantities shipped for a Particular item o...

The report I created is Sales Profitability by Customer Class and Item Trying to display shipped quantity for item of a particular Customer c...

Yes I figured that out. It works if we select Account from the Expand drop down list.Thank you!

Tim - do you think that Solver BI360 is something that we could use here. we are still looking to to make and build trending reports. we are having no...