You are likely picking up more than deliveries with your query.

For example, STOJOU has an Entry type field (VCRTYP). This field is tied to a local menu (701) where the value of 4=Deliveries.

If you added selection criteria to the advanced tab, for instance

You can limit the selection to deliveries, and in my case for only records with a lot.

You should then see results in all fields populated.

Casey Knapp

Principal Analyst, North America Services

Sage

Thanks for the notes Casey. I tried to mimic what you wrote:

I ran into the following error. Also, What if I wanted to pull all deliveries regardless of it having a lot number. How can I modify this code? 

The filter that I used was [F:STJ]LOT<>'' 

Your expression is incorrect because you did not finish the expression.

You don't have to filter the query by lot. I was just doing so to ensure that I got results with all fields populated for my previous post.

For example, using the SEED data, I am not filtering the selection by LOT. I added delivery date and sorted the query by that field:

Some of my deliveries have lots and others do not.

You might be interested in looking at what is offered on SageU (http://sageu.com/). I know that there is an Anytime learning for example on building your own data requestors. That specific course uses Sage X3 V6 during the 30 minute presentation but the concepts will still apply. Note: In V6 we used the term requestor, in V7+ we use the term query. They are all still under Setup, Usage, Reports.

Casey Knapp

Principal Analyst, North America Services

Sage