Show backorders of Pack Slip - 8.03.409

Yahoo Archive
1
Hi Mike,

I think you are stuck with the data definition, Epicor hasn't exposed these.
I wonder if you can add an ODBC based subreport and pull in the OrderRel records? I've never done this before but I don't see why it wouldn't work.

FYI It was a pain getting all the conditions but... I did finish adding the backorders to a Pack Slip.

Good luck

--- In vantage@yahoogroups.com, "mike.numbers" <mnumbers@...> wrote:
>
> I have been asked to show the backorders on both the Invoice (ARForm) and the packslip. I am working on the ARForm first and found that OrderRel was already in the RDD. Unfortionately it is only passing records that have the current packslip lines. I have not successfully created a subreport that did what I wanted it to do (ever). In this situation I am trying to link all of the OrderRel records for the OrderNum in a subreport. Is there a way of doing this or am I stuck with only the records being passed from the main report?
> 9.04.507a
> Mike
>
> --- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@> wrote:
> >
> > Hi,
> >
> > Just wondering if anybody has found ways to include backorder lines on pack slips? Or maybe alternative documentation for customers.
> >
> > Vantage removes any lines with a zero ship qty before the pack slip is printed. We routinely receive comments from customers who would prefer to see backorder lines on the pack list.
> >
> > I started a custom style but I don't have a lot of confidence in it.
> > I copied the PackL RDD & added the OrderRel table.
> > In a subreport I pull in all the Order Release lines - linked to Packlist by Company & OrderNum only.
> > If I decide to finish this up, I will need to add rules that suppress any release that isn't a valid backorder.
> > Testing all the conditions should be loads of fun.
> >
>
2
Hi,

Just wondering if anybody has found ways to include backorder lines on pack slips? Or maybe alternative documentation for customers.

Vantage removes any lines with a zero ship qty before the pack slip is printed. We routinely receive comments from customers who would prefer to see backorder lines on the pack list.

I started a custom style but I don't have a lot of confidence in it.
I copied the PackL RDD & added the OrderRel table.
In a subreport I pull in all the Order Release lines - linked to Packlist by Company & OrderNum only.
If I decide to finish this up, I will need to add rules that suppress any release that isn't a valid backorder.
Testing all the conditions should be loads of fun.
3
I have been asked to show the backorders on both the Invoice (ARForm) and the packslip. I am working on the ARForm first and found that OrderRel was already in the RDD. Unfortionately it is only passing records that have the current packslip lines. I have not successfully created a subreport that did what I wanted it to do (ever). In this situation I am trying to link all of the OrderRel records for the OrderNum in a subreport. Is there a way of doing this or am I stuck with only the records being passed from the main report?
9.04.507a
Mike

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> Hi,
>
> Just wondering if anybody has found ways to include backorder lines on pack slips? Or maybe alternative documentation for customers.
>
> Vantage removes any lines with a zero ship qty before the pack slip is printed. We routinely receive comments from customers who would prefer to see backorder lines on the pack list.
>
> I started a custom style but I don't have a lot of confidence in it.
> I copied the PackL RDD & added the OrderRel table.
> In a subreport I pull in all the Order Release lines - linked to Packlist by Company & OrderNum only.
> If I decide to finish this up, I will need to add rules that suppress any release that isn't a valid backorder.
> Testing all the conditions should be loads of fun.
>