web-erp-developers

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

[Jesse P. <jes...@st...>]

When a Serialised Item has a Reverse GRN processed, here are the options =
I've come up with:

Under both ways:=20
+ all existing code is executed.
+ Additional conditions must be met=20
	=3D> can only reverse GRN for stock that has not been sold (ie, current =
StockMove for item cannot be Invoice type).=20
	=3D> item must have been received against the PO we are reversing =
pieces of
	=3D> any conditions a specialised stock module checks
+ Delete records from Item-specific tables (only affects you if you have =
specialised stock modules)

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


I'm keen on using the second method b/c it creates a lesser chance for =
problems in the future if the Items being reversed are actually received =
later on. I figure at face value most would balk since I'm deleting, but =
I really don't see much point in maintaining these records.

Thoughts from others? Am I missing something or forgetting about =
something?

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

[Phil D. <ph...@du...>]

> When a Serialised Item has a Reverse GRN processed, here are the options
I've come up with:
>
> Under both ways:
> + all existing code is executed.
> + Additional conditions must be met
> => can only reverse GRN for stock that has not been sold (ie, current
StockMove for item cannot be Invoice type).

Makes sense.

> => 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?

> => 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??

>
> 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

> I'm keen on using the second method b/c it creates a lesser chance for
problems in the future if the Items being reversed are actually received
later on. I figure at face value most would balk since I'm deleting, but I
really don't see much point in maintaining these records.

I agree - as long as there is a record of it having existed in the stock
movements.


Phil

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

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

-- 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.

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

[Daintree <p.d...@pa...>]

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
>

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
>

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

[Daintree <p.d...@pa...>]

> 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.
>

Yeah that would be ideal - but I have only got to sending invoices and am
working on recieving sales orders. Not got to sending purchase orders yet -
or receiving purchase invoices. Think I will leave it at sending orders.

Sleep tite!

Phil