Recent content by toomes1

Old Post he's long gone

Figured it out

What is a deferred report,and how do I create one ,,,I have to create one to run all statements and spool it to a file nightly. It needs to recalculate and update the current, over 30, over 60, over 90 buckets in the ARCUSFIL_SQL.

I really appreciate your help,,,I'm new at Macola and SQL as you can probably tell..If you could explain how to go about doing this I think I'll be all set "First setup a deferred report, to run ALL statements nightly, or as needed, and spool this to a file.

That snds like what I need to do, Do you have an example of what this SQL code would look like,, and how I would introduce it to my system.

Is there a way to just print the statements for customers that are past due as of yesterday as opposed to having to go into the aging report and pick which are late and then putting these customers into the monthly category and printing those statements, unfortunatley when it is done this way we...

I got it to work,,,the problem was I was adding it to the second tab when appearently you can only add OEORDHDR fields to the 1'st tab and OEORDLIN fields to the second tab.

Thanks that fixed it.

I'm trying to add a field to our Order Entry screen and I seem to be having some difficulty. The field I'm trying to add is user defined field 5,,,,the reason is I want to add a field where the sales people can enter notes that will only show up on our product labels for things the customers...

We recently recieved some new invoice forms and I was editing them, I have one of those rulers and everything seems fine and in the right place but when we try to print it gives me a,,field overflow has occured during printing,,,I checked the form and can't seem to figure out why???

That snds like what might be happening I'll pass off that idea to our programmer,,,thanks

I'm running those reports how do I identify and resolve the errors?

Progression 7.6.100 & SQL 2000

How would I go about running file validation reports?? I was referring to Item/Location not item locator I guess that does not exist.

This question might be beyond the scope of what this forum is for but here goes,,,we have something call a product locator it is a custom app and we use it to locate products which then populate our item master screen or item locator screen once the product is located and selected. The app is...