Job material with lastest PO Cost. Vantage 8.03.410

Yahoo Archive
1
thanks!

--- In vantage@yahoogroups.com, "b_ordway" <cooner_55421@...> wrote:
>
> By default Vantage BPMs will apply to ALL Vantage DBs
> You can set up separate BPM folders and specify them in the PROPATH for the Live and Test Appservers.
>
> You see details on EpicWeb
>
> https://epicweb.epicor.com/ReportServer/Pages/ReportViewer.aspx?/ePortal/ABDetail&rs:Command=Render&rc:Toolbar=true&Card_ID=1288BRK&Answerbook=Clientele+Change+Requests
>
>
>
>
>
> --- In vantage@yahoogroups.com, "chunyu_jim_hou" <yuyu729@> wrote:
> >
> > should be "find last" instead of "find first".
> >
> > I found it doesnt like " if not available ttJobMtl then return.". I put a do: end. instead after "if not available" and also have the 4GL code under base processing instead of Pre-processing, It is actually working now.
> >
> > the new problem now is that the BPM is written in Test DB and it works in both Test and Live DB!...
> >
> >
> >
> >
> > --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> > >
> > > If you are using a 'find first' for PODetail, how do you know you are getting the most recent record?
> > >
> > >
> > >
> > > ________________________________
> > > From: chunyu_jim_hou <yuyu729@>
> > > To: vantage@yahoogroups.com
> > > Sent: Monday, April 29, 2013 11:59 AM
> > > Subject: [Vantage] Job material with lastest PO Cost. Vantage 8.03.410
> > >
> > >
> > >
> > > ��
> > >
> > > all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.
> > >
> > > I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:
> > >
> > > find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
> > > if not available ttJobMtl then return.
> > > if available ttJobMtl then do:
> > > find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
> > > ttJobMtl.PartNum no-lock no-error.
> > > if not available PODetail then return.
> > > if available PODetail then do:
> > > ttJobMtl.EstUnitCost = PODetail.UnitCost.
> > > ttJobMtl.Number01 = PODetail.UnitCost.
> > > end.
> > > end.
> > >
> > > any inputs are highly appreciated
> > >
> > > I am on Vantage 8.03.410
> > > Jim
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
2
all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.

I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:

find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
if not available ttJobMtl then return.
if available ttJobMtl then do:
find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
ttJobMtl.PartNum no-lock no-error.
if not available PODetail then return.
if available PODetail then do:
ttJobMtl.EstUnitCost = PODetail.UnitCost.
ttJobMtl.Number01 = PODetail.UnitCost.
end.
end.

any inputs are highly appreciated

I am on Vantage 8.03.410
Jim
3
If you are using a 'find first' for PODetail, how do you know you are getting the most recent record?



________________________________
From: chunyu_jim_hou <yuyu729@...>
To: vantage@yahoogroups.com
Sent: Monday, April 29, 2013 11:59 AM
Subject: [Vantage] Job material with lastest PO Cost. Vantage 8.03.410



Â

all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.

I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:

find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
if not available ttJobMtl then return.
if available ttJobMtl then do:
find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
ttJobMtl.PartNum no-lock no-error.
if not available PODetail then return.
if available PODetail then do:
ttJobMtl.EstUnitCost = PODetail.UnitCost.
ttJobMtl.Number01 = PODetail.UnitCost.
end.
end.

any inputs are highly appreciated

I am on Vantage 8.03.410
Jim




[Non-text portions of this message have been removed]
4
should be "find last" instead of "find first".

I found it doesnt like " if not available ttJobMtl then return.". I put a do: end. instead after "if not available" and also have the 4GL code under base processing instead of Pre-processing, It is actually working now.

the new problem now is that the BPM is written in Test DB and it works in both Test and Live DB!...




--- In vantage@yahoogroups.com, Bill Jackson <fujijapman@...> wrote:
>
> If you are using a 'find first' for PODetail, how do you know you are getting the most recent record?
>
>
>
> ________________________________
> From: chunyu_jim_hou <yuyu729@...>
> To: vantage@yahoogroups.com
> Sent: Monday, April 29, 2013 11:59 AM
> Subject: [Vantage] Job material with lastest PO Cost. Vantage 8.03.410
>
>
>
> ��
>
> all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.
>
> I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:
>
> find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
> if not available ttJobMtl then return.
> if available ttJobMtl then do:
> find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
> ttJobMtl.PartNum no-lock no-error.
> if not available PODetail then return.
> if available PODetail then do:
> ttJobMtl.EstUnitCost = PODetail.UnitCost.
> ttJobMtl.Number01 = PODetail.UnitCost.
> end.
> end.
>
> any inputs are highly appreciated
>
> I am on Vantage 8.03.410
> Jim
>
>
>
>
> [Non-text portions of this message have been removed]
>
5
I've started using the method is called by condition that was mentioned here as a way to control new bpms.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of chunyu_jim_hou
Sent: Monday, April 29, 2013 3:55 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job material with lastest PO Cost. Vantage 8.03.410



should be "find last" instead of "find first".

I found it doesnt like " if not available ttJobMtl then return.". I put a do: end. instead after "if not available" and also have the 4GL code under base processing instead of Pre-processing, It is actually working now.

the new problem now is that the BPM is written in Test DB and it works in both Test and Live DB!...

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Bill Jackson <fujijapman@...<mailto:fujijapman@...>> wrote:
>
> If you are using a 'find first' for PODetail, how do you know you are getting the most recent record?
>
>
>
> ________________________________
> From: chunyu_jim_hou <yuyu729@...<mailto:yuyu729@...>>
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Sent: Monday, April 29, 2013 11:59 AM
> Subject: [Vantage] Job material with lastest PO Cost. Vantage 8.03.410
>
>
>
> ��
>
> all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.
>
> I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:
>
> find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
> if not available ttJobMtl then return.
> if available ttJobMtl then do:
> find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
> ttJobMtl.PartNum no-lock no-error.
> if not available PODetail then return.
> if available PODetail then do:
> ttJobMtl.EstUnitCost = PODetail.UnitCost.
> ttJobMtl.Number01 = PODetail.UnitCost.
> end.
> end.
>
> any inputs are highly appreciated
>
> I am on Vantage 8.03.410
> Jim
>
>
>
>
> [Non-text portions of this message have been removed]
>


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
6
By default Vantage BPMs will apply to ALL Vantage DBs
You can set up separate BPM folders and specify them in the PROPATH for the Live and Test Appservers.

You see details on EpicWeb

https://epicweb.epicor.com/ReportServer/Pages/ReportViewer.aspx?/ePortal/ABDetail&rs:Command=Render&rc:Toolbar=true&Card_ID=1288BRK&Answerbook=Clientele+Change+Requests





--- In vantage@yahoogroups.com, "chunyu_jim_hou" <yuyu729@...> wrote:
>
> should be "find last" instead of "find first".
>
> I found it doesnt like " if not available ttJobMtl then return.". I put a do: end. instead after "if not available" and also have the 4GL code under base processing instead of Pre-processing, It is actually working now.
>
> the new problem now is that the BPM is written in Test DB and it works in both Test and Live DB!...
>
>
>
>
> --- In vantage@yahoogroups.com, Bill Jackson <fujijapman@> wrote:
> >
> > If you are using a 'find first' for PODetail, how do you know you are getting the most recent record?
> >
> >
> >
> > ________________________________
> > From: chunyu_jim_hou <yuyu729@>
> > To: vantage@yahoogroups.com
> > Sent: Monday, April 29, 2013 11:59 AM
> > Subject: [Vantage] Job material with lastest PO Cost. Vantage 8.03.410
> >
> >
> >
> > ��
> >
> > all our parts are set up as non-stock so there is no last cost or average cost in the partcost table for all the parts that's why I am looking for a workaround to get the latest cost.
> >
> > I tried to mimic the 4GL codes in user guide to get BPM to change unit cost in job entry to the last PO cost but the code I wrote doesnt work.Here they are:
> >
> > find first ttJobMtl where ttJobMtl.RowMod = 'A' or ttJobMtl.RowMod = 'U' no-error.
> > if not available ttJobMtl then return.
> > if available ttJobMtl then do:
> > find first PODetail where PODetail.Company = ttJobMtl.Company and PODetail.PartNum =
> > ttJobMtl.PartNum no-lock no-error.
> > if not available PODetail then return.
> > if available PODetail then do:
> > ttJobMtl.EstUnitCost = PODetail.UnitCost.
> > ttJobMtl.Number01 = PODetail.UnitCost.
> > end.
> > end.
> >
> > any inputs are highly appreciated
> >
> > I am on Vantage 8.03.410
> > Jim
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>