Order Lines Not Closing

Yahoo Archive
1
Using UpdateTableBuffer would be simple enough to get the line close, but would that close the order as well, or would I have to manually close the order also (if it has been shipped completed)?

Another issue is that the part transaction is not being recorded for these problem shipments. Within Part Transaction History tracker there is not any record of the shipment...any suggestions on this?

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> Yeah that would work, although closing a line is just flipping a bit, so
> you can just write to the DB in 9XX Assign OrderDtl.OpenLine=false or in
> 8xx use UpdateTableBuffer
>
> *mind you i don't remember if that's the correct field name.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Jul 3, 2012 at 5:40 PM, Jeff Rogers <jeff.rogers@...>wrote:
>
> > **
> >
> >
> > Jose - what would you suggest for a BPM to accomplish this? A post-process
> > BPM on CustShip.Update that queries the remaining quantity of the order
> > line and if 0 then call the SalesOrder.Update method to close the line?
> > I've never called a method/BO through 4GL before... is this the correct
> > route to take?
> >
> > Thanks again!
> >
> >
> > --- In vantage@yahoogroups.com, Jose Gomez <jose@> wrote:
> > >
> > > BPM is going to have to be your friend on this one, to go and close the
> > > line for you. Its a known BUG i've seen it all over the place.
> > >
> > > *Jose C Gomez*
> > > *Software Engineer*
> > > *
> > > *
> > > *
> > > *T: 904.469.1524 mobile
> > > E: jose@
> > > http://www.josecgomez.com
> > > <http://www.linkedin.com/in/josecgomez> <
> > http://www.facebook.com/josegomez>
> > > <http://www.google.com/profiles/jose.gomez> <
> > http://www.twitter.com/joc85>
> > > <http://www.josecgomez.com/professional-resume/>
> > > <http://www.josecgomez.com/feed/>
> > > <http://www.usdoingstuff.com>
> > >
> > > *Quis custodiet ipsos custodes?*
> > >
> > >
> > >
> > > On Tue, Jul 3, 2012 at 1:32 PM, Jeff Rogers <jeff.rogers@>wrote:
> >
> > >
> > > >
> > > > A related issue on these same packs is that when we print the pack slip
> > > > and are p
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
2
So we recently went live with intercompany trading and are now experiencing a common issue associated with those orders and packs (we've experiences this issue in the past with non-intercompany orders, but it was far less frequent).

Say we have an order that has 2 lines (1 release per line). We'll ship the order complete and pack line 1 has a requested qty of 5, shipped to date quantity of 5, this shipment quantity of 5, and a remaining qty of 0. The associated sales order line closes fine. On pack line 2 we'll have a a requested qty of 10, shipped to date quantity of 0, this shipment quantity of 10, and a remaining qty of 0. The associated sales order line will not close automatically when the pack is marked "shipped". The "shipped to date" quantity of 0 seems incorrect and probably the cause of the sales order line not closing.

A related issue on these same packs is that when we print the pack slip and are prompted to mark the order shipped, we select yes, but the pack is not marked as shipped. It will take several attempts to uncheck/recheck the "Shipped" checkbox to get the pack status to change to "Shipped". At this point both order lines and the order should be closed, but it is not and the behavior described in the paragraph above is observed.

Does anyone have any ideas? We're on Vantage 8.03.409a SQL.

Thanks!
3
BPM is going to have to be your friend on this one, to go and close the
line for you. Its a known BUG i've seen it all over the place.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Jul 3, 2012 at 1:32 PM, Jeff Rogers <jeff.rogers@...>wrote:

>
> A related issue on these same packs is that when we print the pack slip
> and are p


[Non-text portions of this message have been removed]
4
Jose - what would you suggest for a BPM to accomplish this? A post-process BPM on CustShip.Update that queries the remaining quantity of the order line and if 0 then call the SalesOrder.Update method to close the line? I've never called a method/BO through 4GL before... is this the correct route to take?

Thanks again!

--- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
>
> BPM is going to have to be your friend on this one, to go and close the
> line for you. Its a known BUG i've seen it all over the place.
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *
> *T: 904.469.1524 mobile
> E: jose@...
> http://www.josecgomez.com
> <http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
> <http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
> <http://www.josecgomez.com/professional-resume/>
> <http://www.josecgomez.com/feed/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, Jul 3, 2012 at 1:32 PM, Jeff Rogers <jeff.rogers@...>wrote:
>
> >
> > A related issue on these same packs is that when we print the pack slip
> > and are p
>
>
> [Non-text portions of this message have been removed]
>
5
Yeah that would work, although closing a line is just flipping a bit, so
you can just write to the DB in 9XX Assign OrderDtl.OpenLine=false or in
8xx use UpdateTableBuffer

*mind you i don't remember if that's the correct field name.

*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*



On Tue, Jul 3, 2012 at 5:40 PM, Jeff Rogers <jeff.rogers@...>wrote:

> **
>
>
> Jose - what would you suggest for a BPM to accomplish this? A post-process
> BPM on CustShip.Update that queries the remaining quantity of the order
> line and if 0 then call the SalesOrder.Update method to close the line?
> I've never called a method/BO through 4GL before... is this the correct
> route to take?
>
> Thanks again!
>
>
> --- In vantage@yahoogroups.com, Jose Gomez <jose@...> wrote:
> >
> > BPM is going to have to be your friend on this one, to go and close the
> > line for you. Its a known BUG i've seen it all over the place.
> >
> > *Jose C Gomez*
> > *Software Engineer*
> > *
> > *
> > *
> > *T: 904.469.1524 mobile
> > E: jose@...
> > http://www.josecgomez.com
> > <http://www.linkedin.com/in/josecgomez> <
> http://www.facebook.com/josegomez>
> > <http://www.google.com/profiles/jose.gomez> <
> http://www.twitter.com/joc85>
> > <http://www.josecgomez.com/professional-resume/>
> > <http://www.josecgomez.com/feed/>
> > <http://www.usdoingstuff.com>
> >
> > *Quis custodiet ipsos custodes?*
> >
> >
> >
> > On Tue, Jul 3, 2012 at 1:32 PM, Jeff Rogers <jeff.rogers@...>wrote:
>
> >
> > >
> > > A related issue on these same packs is that when we print the pack slip
> > > and are p
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]