PO Release Lock Quanity

Yahoo Archive
1
Thank you. I used an MS Access query to get what I needed. Now why
couldn't Epicor telephone support give me this information??

--- In vantage@yahoogroups.com, "bw2868bond" <bwalker@...> wrote:
>
> The PO Release Lock Qty (and Lock Date) values are stored in the
> COMXref table
>
> the tabled fields 'File', 'Key1', 'Key2', 'Key3' are the index to
the
> record
> 'File' = 'PORel_Mapping'
> 'Key1' = PONum (as a string value)
> 'Key2' = POLine (as a string value)
> 'Key3' = PORelNum (as a string value)
>
> Lock Qty is determined by the value of foreignKey2 being
either 'Yes'
> or 'No'
>
> Lock Date is associated with foreignKey1
>
> As long as you are using a reporting tool that can convert the
> numeric po information to strings, you can link to the COMXref
table
> and return the status - I have done it in CorVu using joined queries
>
> --- In vantage@yahoogroups.com, "Dave" <dave334012@> wrote:
> >
> > Hi,
> >
> > I'm trying to report on whether or not the Checkbox "Lock
Quantity"
> is
> > checked for PO Releases.
> >
> > Vista tells me the field I want is in table "PORel" and the field
> name
> > is "LockQty".
> >
> > The problem is as far as Crystal and BAQ know that field doesn't
> exist.
> >
> > Epicor phone support tells me I'm out of luck, can't report on
that
> > field.
> >
> > Does anyone know if "PORel.LockQty" is somehow calculated and how
I
> > might report on it?
> >
> > Thanks,
> >
> > Dave
> >
>
2
Hi,

I'm trying to report on whether or not the Checkbox "Lock Quantity" is
checked for PO Releases.

Vista tells me the field I want is in table "PORel" and the field name
is "LockQty".

The problem is as far as Crystal and BAQ know that field doesn't exist.

Epicor phone support tells me I'm out of luck, can't report on that
field.

Does anyone know if "PORel.LockQty" is somehow calculated and how I
might report on it?

Thanks,

Dave
3
The PO Release Lock Qty (and Lock Date) values are stored in the
COMXref table

the tabled fields 'File', 'Key1', 'Key2', 'Key3' are the index to the
record
'File' = 'PORel_Mapping'
'Key1' = PONum (as a string value)
'Key2' = POLine (as a string value)
'Key3' = PORelNum (as a string value)

Lock Qty is determined by the value of foreignKey2 being either 'Yes'
or 'No'

Lock Date is associated with foreignKey1

As long as you are using a reporting tool that can convert the
numeric po information to strings, you can link to the COMXref table
and return the status - I have done it in CorVu using joined queries

--- In vantage@yahoogroups.com, "Dave" <dave334012@...> wrote:
>
> Hi,
>
> I'm trying to report on whether or not the Checkbox "Lock Quantity"
is
> checked for PO Releases.
>
> Vista tells me the field I want is in table "PORel" and the field
name
> is "LockQty".
>
> The problem is as far as Crystal and BAQ know that field doesn't
exist.
>
> Epicor phone support tells me I'm out of luck, can't report on that
> field.
>
> Does anyone know if "PORel.LockQty" is somehow calculated and how I
> might report on it?
>
> Thanks,
>
> Dave
>