RE: [Web-erp-developers] Reverse GRNs of Serialised stock

[jesse <je...@st...>]

Ok, I'll use my discretion and get on with it. I hope I am close - not a
problem with coding, but rather coding time. Worked 15 hrs today and didn't
get to write a line of code (like, for anything), but the weekend is here
too. I'll try to get you at least a piece this weekend to see what I'm
doing.

Correct on Chris' script and most others like it...

EDI and the such can be a pain...and I've found that having a use really
helps encourage implementation :)  what about, if for nothing else but
kicks, an interface to let 2 web-erp's interact w/ each other? It could be
really useful when wholesaling and dealing w/ large(ish)distributors, their
large(ish) customers, sales agents, etc.
It might also suffice to create another reporting template people could
create to export data in any which way they wanted - just aim to make it
capable of defining some of the edi related message formats?
blabbering now...sleep, then code.

> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of
> Daintree
> Sent: Friday, April 16, 2004 02:54
> To: web...@li...
> Subject: Re: [Web-erp-developers] Reverse GRNs of Serialised stock
>
>
> Hard for me to comment really since I need to get hands dirty
> with the code.
> Sounds like I might have to arrange for a full weekend's battle
> when you are
> ready to let me loose on the code.
>
> Chris has done some work on a simple location movements script, I am
> guessing that this stuff will work ok anyway since you are looking at a
> level down from the stock movement in your work?
>
> Are you close. I can't get inspired to finsih off EDIOrders - I
> thought our
> business might use this but there is no commercial driver now and
> no way to
> ensure it works - live testing- so not quite so motivated to do it.
>
> Phil
> ----- Original Message -----
> From: "jesse" <je...@st...>
> To: <web...@li...>
> Sent: Friday, April 16, 2004 6:18 PM
> Subject: RE: [Web-erp-developers] Reverse GRNs of Serialised stock
>
>
> > -- I just realised this did not get sent (over 24 hrs ago).
> Explains why I
> > never saw a response ;)
> >
> >
> > > > => item must have been received against the PO we are reversing
> > > pieces of
> > >
> > > Why do you need to have the PO specified - this is held
> against the GRN?
> >
> > It is already specified, unless there's another way to get at doing a
> > Reverse GRN. When you process the reversal, PurchOrderDetails are being
> > updated to remove X Qty as being received and ensuring it is marked such
> > that has additional receiving necessary. Also, if I did not
> require that,
> I
> > would potentially have to find and update, say 10 different POs when
> > receiving items. Maybe necessary, though, as it may be
> difficult for some
> to
> > find where items they are reversing came from.
> >
> > > > => any conditions a specialised stock module checks
> > > > + Delete records from Item-specific tables (only affects you if you
> have
> > > specialised stock modules)
> > >
> > > You got me here - cant keep up - is this some new
> functionality module??
> >
> > Yes. I have them working... it is a pretty customizable setup (some
> assembly
> > required :) ) , but also easily (and I'd say by default) hidden...it
> > encompasses the standard serialised item (ie, you just have a
> single piece
> > of info - the serialno - that you want to store/maintain for the item),
> but
> > you wouldn't notice (from the UI, at least). You'll see soon - I don't
> think
> > it will interfere with anything. And I should have a couple examples.
> >
> > > >
> > > > then, either:
> > > >
> > > > 1) Change/Invalidate SerialNo in StockItems Records.
> > > > a) Change Serial in All affected StockItem records to something
> > > bogus like
> > > 'XXXXXXXX' or just ''
> > > > b) Update StockItems w/ new StockMove No. for each.
> > > > c) Create StockItemMove for tracking (StockItemNo,
> > > OldStockMoveNo, New/Eff
> > > StockMoveNo)
> > > >
> > >
> > > > 2) Delete Item history
> > > > a) Delete records from StockItems
> > > > c) Delete StockItemMoves
> > > >
> > > >
> > >
> > > What about
> > > 3) Hybrid record reversal and delete stock item
> > > a)  Delete records from StockItems
> > > b) Create StockItemMove of a GRN reversal type for tracking
> (StockItemNo,
> > > OldStockMoveNo, New/Eff StockMoveNo)
> > >
> > > For security purposes we need some record of what happened
> but there is
> no
> > > point having the stockitem existing if its gone. Just 2c
> >
> > Yes... the only problem (and it may just be in table struct) with 3b is
> that
> > StockItemNo and SerialNo are not the same. I keyed StockItems on an Int
> > Identity (StockItemNo) and allowed SerialNo to be just any var char with
> no
> > restrictions - I've just realized that I think I can leave the StockItem
> > entries in for that fact exactly. I figure when I have to select
> StockItems,
> > I'll always be coming through StockMoves, and you just wouldn't allow
> > someone to fullfill an order with an item you reversed, huh? So you're
> > hybrid works with out A which is the best scenario.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by: IBM Linux Tutorials
> > Free Linux tutorial presented by Daniel Robbins, President and CEO of
> > GenToo technologies. Learn everything from fundamentals to system
> > administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> > _______________________________________________
> > Web-erp-developers mailing list
> > Web...@li...
> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>