Batch Processing vs Single Delivery Note production

mark-wilkinson

Greetings to All,

Just wondered if anyone has come across the following:-

Client has migrated over to SE V2.96.10.

When producing delivery notes via batch processing (Document to Delivery), they have the following expression.

iif(seek('D'+ihead.ih_desp,'slook'),slook.lk_desc,ihead.ih_desp)

This prints the description of despatch correctly.

If we manually progress Document to Delivery, then we only get the despatch method code printed.

This seems to be working correctly using Batch Processing.

Worth noting this worked for both areas in VFP.

Any thoughts would greatly help.

Thanks

Mark

Find more posts tagged with

Pegasus - Partner General Discussions

Accepted answers

All comments

alan-bourke

It my be because on individual progression the local SLOOK cursor either has not been populated with data from the SQL Server backend for whatever reason, or the active index might be different.

If you change the expression to explicitly say which index tag to use, i.e.:

iif(seek('D'+ihead.ih_desp,'slook', 'slook1'),slook.lk_desc,ihead.ih_desp)

Does that work?

colin-avey

You could try DM_seek

iif(dm_seek('D'+ihead.ih_desp,'slook','slook1'),slook.lk_desc,ihead.ih_desp)

mark-wilkinson

Hi Alan, Thanks for coming back, we tried this one but still had the issue. Colin's expression did work.

mark-wilkinson

Hi Colin, That did the trick many thanks for your help.....still awaiting Pegasus to respond!!!!

richardd

Hi Colin, what's a difference using "DM_SEEK" ? Not come across this before. Thanks Rick

dEPM-610-Whats New in OLAP Administration for 12.0.6.mp4

colin-avey

DM_* functions a part of the Pegasus library used as a wrapper for SQL/SE data.
So DM_seek() will fetch data from SQL Server and populate the local cached VFP tables, which can then be used in the normal fashion.

I suspect Mark's issue is that the cached version is being pre-populated for some document types and not others.

For completeness, so that the same report works from VFP and SE, you should probably do

iif(seek('D'+ihead.ih_desp,'slook','slook1'),slook.lk_desc,iif(serveredition() AND dm_seek('D'+ihead.ih_desp,'slook','slook1'),slook.lk_desc,ihead.ih_desp))

I am sure Alan can fill in the blanks

Copyright © 2025 Infor. All rights reserved.