O/E order confirmation reports -- no report generated for many orders

Posted By Andy Bruner over 9 years ago

I'm using version 2014 and doing initial setup/testing of OE and IC. In SAMINC when I go to OE forms, Order Confirmations to print out the confirmation reports I only get a limited number of reports showing on the preview screen. I ticked "include confirmations already printed" and select the entire range of order numbers from 1-68 but only orders #1-2 and 63-68 get printed.

Why won't all the reports print out? I don't see anything about the missing ones that makes them different from the ones that print. (I also ticked "print On Hold orders".

I also have a copy of our production company that I am doing testing in and I can't get a single one of my orders to show on the preview screen.

Parents

0 Ettienne Schwagele over 9 years ago

Shipped orders don't print order confirmations.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Andy Bruner over 9 years ago in reply to Ettienne Schwagele

Back to this issue again. I was working on a method to import orders and now discover that after importing an order I cannot print the confirmation. The items have not been shipped. Even if I go to OE forms and try to reprint a previously printed OE confirmation it still comes up blank (in preview mode).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 1359966 over 9 years ago in reply to Andy Bruner

When you import the orders, what is the status of the "completed" field in the detail and header records?

Also, what is the status of the imported order - Active, Quote, Future, Standing? Is there at least one non-zero quantity in the QTYOrdered and Qtybackorder fields? Do the detail records have Expected Ship Dates on the detail lines?

Joe
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 1359966 over 9 years ago in reply to Andy Bruner

When you import the orders, what is the status of the "completed" field in the detail and header records?

Also, what is the status of the imported order - Active, Quote, Future, Standing? Is there at least one non-zero quantity in the QTYOrdered and Qtybackorder fields? Do the detail records have Expected Ship Dates on the detail lines?

Joe
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

0 Andy Bruner over 9 years ago in reply to 1359966

The status in header shows: Order confirmation printed. On the detail lines it says "No" in the Completed field. If I look at the order listing the status is Incomplete/Not Included.

The status of the orders are "Active".

The orders have a positive amount in the quantity Ordered fields.

Yes, the detail records have an expected ship date on the detail lines. But even if I remove it I still can't get them to print.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cook over 9 years ago in reply to Andy Bruner

double check to make sure it's not on hold? also makes sure that you have the "print confirmations that were previously printed" checked.

I know it seems basic, but sometimes it gets missed
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 VicenteG over 9 years ago in reply to Mike Cook

You get a blank preview screen if an order is already invoiced. Does you import template include invoice related fields?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Andy Bruner over 9 years ago in reply to VicenteG

Well it looks like it has something to do with a customization I made to the OE Confirmation report. I switched back to the original one and it prints just fine. I didn't do much to the report to customize it but apparently it was enough to break it. Thanks for your help everyone.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

O/E order confirmation reports -- no report generated for many orders

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING