Suppressing tags if zero qoh

Yahoo Archive
1
I don't see such a table as CountExp. I'm working on Epicor version 905.606.

--- In vantage@yahoogroups.com, "Chulhee" <chulheekim@...> wrote:
>
> Thank you. I haven't had a chance to try your suggestion yet. I will let you know how it goes. Thank you.
>
> --- In vantage@yahoogroups.com, b35crile@ wrote:
> >
> > You may try to add the field, ExpectedQty, to the CountExp table and then use it as the criteria for suppressing the sections of the report used to produce the tag.
> > --- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@> wrote:
> > >
> > > I don't know what version you are running or if this will help. We are running Vantage 8.03.409A. We have a modified report style for tags that prints the message "*** SALES KIT-VOID TICKET***" if the Part is a sales kit else if the expected quantity (bin quantity) = 0 "*** Computer Count = 0***" else "" in the area of the tag where the count quantity is filled in. There is a bug that lets tags print for sales kits (which are not physical items) and another bug that lets you post a quantity to the sales kit part number thru physical inventory count posting. Vantage lets us choose whether to include zero count items for the full physical inventory option. Since cycle counting doesn't give us that option, the 0 count message option can be selected by the person in charge of inventory for their department. We found out items keep coming up for cycle counting if there isn't a count date for all bins belonging to the item.
> > >
> > > Sue
> > >
> > > --- In vantage@yahoogroups.com, "Chulhee" <chulheekim@> wrote:
> > > >
> > > > Physical inventory is coming up. I'm trying to customize the tag print. When tags are generated, they need to be created for parts with zero onhand quantity. But when the tags are printed, I need only those with onhand qty greater than zero to print. What I did for it was to bring Partbin table into the PrintTag Report Data Defintion and make relationship between the existing report table CCTag and the PartBin. However, that didn't work. I'm getting an error from the crystal report saying something like Foreign key data set null. It seems like the xml file isn't valid for the crystal report file. I'm not sure whether it is relationship fields are properly set or PartBin is not the right one.
> > > >
> > >
> >
>
2
Physical inventory is coming up. I'm trying to customize the tag print. When tags are generated, they need to be created for parts with zero onhand quantity. But when the tags are printed, I need only those with onhand qty greater than zero to print. What I did for it was to bring Partbin table into the PrintTag Report Data Defintion and make relationship between the existing report table CCTag and the PartBin. However, that didn't work. I'm getting an error from the crystal report saying something like Foreign key data set null. It seems like the xml file isn't valid for the crystal report file. I'm not sure whether it is relationship fields are properly set or PartBin is not the right one.
3
I don't know what version you are running or if this will help. We are running Vantage 8.03.409A. We have a modified report style for tags that prints the message "*** SALES KIT-VOID TICKET***" if the Part is a sales kit else if the expected quantity (bin quantity) = 0 "*** Computer Count = 0***" else "" in the area of the tag where the count quantity is filled in. There is a bug that lets tags print for sales kits (which are not physical items) and another bug that lets you post a quantity to the sales kit part number thru physical inventory count posting. Vantage lets us choose whether to include zero count items for the full physical inventory option. Since cycle counting doesn't give us that option, the 0 count message option can be selected by the person in charge of inventory for their department. We found out items keep coming up for cycle counting if there isn't a count date for all bins belonging to the item.

Sue

--- In vantage@yahoogroups.com, "Chulhee" <chulheekim@...> wrote:
>
> Physical inventory is coming up. I'm trying to customize the tag print. When tags are generated, they need to be created for parts with zero onhand quantity. But when the tags are printed, I need only those with onhand qty greater than zero to print. What I did for it was to bring Partbin table into the PrintTag Report Data Defintion and make relationship between the existing report table CCTag and the PartBin. However, that didn't work. I'm getting an error from the crystal report saying something like Foreign key data set null. It seems like the xml file isn't valid for the crystal report file. I'm not sure whether it is relationship fields are properly set or PartBin is not the right one.
>
4
You may try to add the field, ExpectedQty, to the CountExp table and then use it as the criteria for suppressing the sections of the report used to produce the tag.
--- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@...> wrote:
>
> I don't know what version you are running or if this will help. We are running Vantage 8.03.409A. We have a modified report style for tags that prints the message "*** SALES KIT-VOID TICKET***" if the Part is a sales kit else if the expected quantity (bin quantity) = 0 "*** Computer Count = 0***" else "" in the area of the tag where the count quantity is filled in. There is a bug that lets tags print for sales kits (which are not physical items) and another bug that lets you post a quantity to the sales kit part number thru physical inventory count posting. Vantage lets us choose whether to include zero count items for the full physical inventory option. Since cycle counting doesn't give us that option, the 0 count message option can be selected by the person in charge of inventory for their department. We found out items keep coming up for cycle counting if there isn't a count date for all bins belonging to the item.
>
> Sue
>
> --- In vantage@yahoogroups.com, "Chulhee" <chulheekim@> wrote:
> >
> > Physical inventory is coming up. I'm trying to customize the tag print. When tags are generated, they need to be created for parts with zero onhand quantity. But when the tags are printed, I need only those with onhand qty greater than zero to print. What I did for it was to bring Partbin table into the PrintTag Report Data Defintion and make relationship between the existing report table CCTag and the PartBin. However, that didn't work. I'm getting an error from the crystal report saying something like Foreign key data set null. It seems like the xml file isn't valid for the crystal report file. I'm not sure whether it is relationship fields are properly set or PartBin is not the right one.
> >
>
5
Thank you. I haven't had a chance to try your suggestion yet. I will let you know how it goes. Thank you.

--- In vantage@yahoogroups.com, b35crile@... wrote:
>
> You may try to add the field, ExpectedQty, to the CountExp table and then use it as the criteria for suppressing the sections of the report used to produce the tag.
> --- In vantage@yahoogroups.com, "snielsen28" <snielsen.hipco@> wrote:
> >
> > I don't know what version you are running or if this will help. We are running Vantage 8.03.409A. We have a modified report style for tags that prints the message "*** SALES KIT-VOID TICKET***" if the Part is a sales kit else if the expected quantity (bin quantity) = 0 "*** Computer Count = 0***" else "" in the area of the tag where the count quantity is filled in. There is a bug that lets tags print for sales kits (which are not physical items) and another bug that lets you post a quantity to the sales kit part number thru physical inventory count posting. Vantage lets us choose whether to include zero count items for the full physical inventory option. Since cycle counting doesn't give us that option, the 0 count message option can be selected by the person in charge of inventory for their department. We found out items keep coming up for cycle counting if there isn't a count date for all bins belonging to the item.
> >
> > Sue
> >
> > --- In vantage@yahoogroups.com, "Chulhee" <chulheekim@> wrote:
> > >
> > > Physical inventory is coming up. I'm trying to customize the tag print. When tags are generated, they need to be created for parts with zero onhand quantity. But when the tags are printed, I need only those with onhand qty greater than zero to print. What I did for it was to bring Partbin table into the PrintTag Report Data Defintion and make relationship between the existing report table CCTag and the PartBin. However, that didn't work. I'm getting an error from the crystal report saying something like Foreign key data set null. It seems like the xml file isn't valid for the crystal report file. I'm not sure whether it is relationship fields are properly set or PartBin is not the right one.
> > >
> >
>