I am working on a Gridview to look at our sales. I am able to pull all the information of orders, invoices and credits except for credits without an order number.

I am currently using the OE Hst Detail /w Head. Table. How can I pull this info either with this table or a separate one.

Thanks,
Lance

Hi Lance

That table will work. But it's not an easy table to work with. For one thing, credit notes appear as positives unless you turn them around using a formula. For another, orders are in there and you want to exclude them if it's a sales report.

What's wrong with using the OE History Header table - it doesn't have the item details but it certainly has the total sales? And if you want the details, what's wrong with using the History button, Items tab in OrderEntry itself?

You are almost definitely doing something wrong in building the GridView but figuring that out on the forum will not be easy. If you are determined to use that table, select all fields and see which one(s) result in the desired output. Then pare it down.

Steve

Hi Lance,

Your Filter should look like this:
to select Invoices and Credit Notes.

I wouldn't recommend displaying all the fields in the table - there are too many of them. Just make sure that you include all the fields you are using in calculated columns or Filters, so you can make sure that the expressions are working properly. You can delete them from the View later if they are not necessary.

Thanks All,

My current filter for testing is:


This is showing All invoices and credit notes between Dec 1st to Dec 31st 2018, and filtering out RC item codes (Recycle Fees) and SH & DE (Shipping and Delivery). I have exported this list and compared it to our GL account for sales and it matches exactly except for two things.

AP/AR direct entries (Do not need to fix)
Credit Notes that do not have an order number.

I have changed the filter to not include anything other than



This returns no results. I have tried looking at this view without any filters and I cannot find the 10 credit notes that way either. The only common thing about these credits in OE is they all are Order Number "No Order". I believe these do not appear in this GV, no matter what I make my filter.

Thanks,

If these credit notes have no detail lines, then there will be no details to select them. You need to find them from the Header.

They do have detail lines, but do not reference an Invoice or Order number.

Perhaps start with a simpler filter, like just credit notes, to limit the number of records. Ensure that columns for Date, Category, Item # and Line Type are selected for the view (at least for now) since those are the other fields referenced in your filter. When that filter is selected, find one of your credit notes that was not based on an order. If you can't find any, then that would explain why your complete filter doesn't. If you can find at least one, then you can investigate the other 4 field values to see why it isn't being selected from your complete filter.

Your filter selecting specific credit notes is not syntactically correct. Each line should be:

RIGHT({CN #},5) = "59370"

Interesting I found them. On orders that do not reference any invoice or order the {Date} is blank but the {Inv Date} contains the date I need. I will update this.

Thanks for your help.