Kit containing an Assembly
|
View:
New views
5 Messages
—
Rating Filter:
Alert me
|
 |
Kit containing an Assembly
by Lindsay Harris
::
Rate this Message:
I am trying to add an assembly to a kit. Assemblies don't show up in
the list of available items to add to a kit. The SQL to determine the list of usable items to add to a kit specifically excludes assemblies or other kits, as I read it, though it's late enough that I wouldn't trust that analysis too much :( The code in question is thus: if ($ParentMBflag=='A'){ /*Its an assembly */ $sql = "SELECT stockmaster.stockid, stockmaster.description FROM stockmaster WHERE stockmaster.mbflag !='D' AND stockmaster.mbflag !='K' AND stockmaster.mbflag !='A' AND stockmaster.controlled = 0 AND stockmaster.stockid != '$SelectedParent' ORDER BY stockmaster.stockid"; } else { /*Its either a normal manufac item or a kitset - controlled items ok */ $sql = "SELECT stockmaster.stockid, stockmaster.description FROM stockmaster WHERE stockmaster.mbflag !='D' AND stockmaster.mbflag !='K' AND stockmaster.mbflag !='A' AND stockmaster.stockid != '$SelectedParent' ORDER BY stockmaster.stockid"; } That's starting at line 550 of BOMs.php. Is there any particular reason for this, or is it a hangover from pre-multi-level BOMs? Lindsay ready for bed ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Web-erp-developers mailing list Web-erp-developers@... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
|
Re: Kit containing an Assembly
by Tim Schofield
::
Rate this Message:
Hi Lindsay,
Phil would be best to explain the intentions of the code, but you can add manufactured items to a BOM. Is there any reason why the item needs to be an assembly rather than a manufactured item? Tim 2008/5/13 Lindsay Harris <lindsay@...>: > I am trying to add an assembly to a kit. Assemblies don't show up in > the list of available items to add to a kit. The SQL to determine > the list of usable items to add to a kit specifically excludes > assemblies or other kits, as I read it, though it's late enough that > I wouldn't trust that analysis too much :( > > The code in question is thus: > > if ($ParentMBflag=='A'){ /*Its an assembly */ > $sql = "SELECT stockmaster.stockid, > stockmaster.description > FROM stockmaster > WHERE stockmaster.mbflag !='D' > AND stockmaster.mbflag !='K' > AND stockmaster.mbflag !='A' > AND stockmaster.controlled = 0 > AND > stockmaster.stockid != '$SelectedParent' > ORDER BY stockmaster.stockid"; > > } else { /*Its either a normal manufac item or a > kitset - controlled items ok */ > $sql = "SELECT stockmaster.stockid, > stockmaster.description > FROM stockmaster > WHERE stockmaster.mbflag !='D' > AND stockmaster.mbflag !='K' > AND stockmaster.mbflag !='A' > AND stockmaster.stockid != '$SelectedParent' > ORDER BY stockmaster.stockid"; > } > > That's starting at line 550 of BOMs.php. Is there any particular > reason for this, or is it a hangover from pre-multi-level BOMs? > > Lindsay > ready for bed > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Web-erp-developers mailing list Web-erp-developers@... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
|
Re: Kit containing an Assembly
by Lindsay Harris
::
Rate this Message:
Hi, Tim.
We currently have manufactured items in a number of kits. But using manufactured items doesn't really reflect how the company works. Example: We manufacutre lipsticks (tube + filling + label -> manufacture -> finished tube). This is "out sourced", that is, we receive the filled and labelled tubes. They go into inventory. Then we sell most of them in boxes (packaging); these are for retail customers, and the tubes are put into boxes before shipping. A few lipsticks are sold without the box, for dispaly/customer test in stores. With manufacturing (as opposed to an assembly), there is a need to manufacture them (in webERP). As this happens in little bits and pieces, it creates a significant amount of work. So an assembly better fits the physical situation. Finally, the packaged lipsticks are available as kit. And this is the bit that doesn't work :-( It's a convenience item to save me entering about 25 items! Lindsay On Tue, 13 May 2008 22:09:29 Tim Schofield wrote: > Hi Lindsay, > > Phil would be best to explain the intentions of the code, but you > can add manufactured items to a BOM. Is there any reason why the > item needs to be an assembly rather than a manufactured item? > > Tim > > 2008/5/13 Lindsay Harris <lindsay@...>: > > I am trying to add an assembly to a kit. Assemblies don't show > > up in the list of available items to add to a kit. The SQL to > > determine the list of usable items to add to a kit specifically > > excludes assemblies or other kits, as I read it, though it's > > late enough that I wouldn't trust that analysis too much :( > > > > The code in question is thus: > > > > if ($ParentMBflag=='A'){ /*Its an assembly */ > > $sql = "SELECT stockmaster.stockid, > > stockmaster.description > > FROM stockmaster > > WHERE stockmaster.mbflag !='D' > > AND stockmaster.mbflag !='K' > > AND stockmaster.mbflag !='A' > > AND stockmaster.controlled = 0 > > AND > > stockmaster.stockid != > > '$SelectedParent' ORDER BY stockmaster.stockid"; > > > > } else { /*Its either a normal manufac item or a > > kitset - controlled items ok */ > > $sql = "SELECT stockmaster.stockid, > > stockmaster.description > > FROM stockmaster > > WHERE stockmaster.mbflag !='D' > > AND stockmaster.mbflag !='K' > > AND stockmaster.mbflag !='A' > > AND stockmaster.stockid != '$SelectedParent' > > ORDER BY stockmaster.stockid"; > > } > > > > That's starting at line 550 of BOMs.php. Is there any > > particular reason for this, or is it a hangover from > > pre-multi-level BOMs? > > > > Lindsay > > ready for bed > > > > ----------------------------------------------------------------- > >-------- This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Web-erp-developers mailing list > > Web-erp-developers@... > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers > > ------------------------------------------------------------------- >------ This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Web-erp-developers mailing list Web-erp-developers@... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
|
Re: Kit containing an Assembly
by Phil Daintree-3
::
Rate this Message:
Hi Lindsay
Multi-level BOMs were in from the beginning. I am thinking we could change it to allow assembly items as components of kit-sets only since assemblies are only processed on invoicing. We can't have assemblies as components of manufactured items - assemblies are a way to sell a selection of items as a bundle. Phil The first block is about limiting assembly items so components cannot be controlled - we've covered the reasons for this extensively previously - the all other items On Tue, 13 May 2008 21:53:12 +1000 Lindsay Harris <lindsay@...> wrote: > I am trying to add an assembly to a kit. Assemblies don't show up in > the list of available items to add to a kit. The SQL to determine > the list of usable items to add to a kit specifically excludes > assemblies or other kits, as I read it, though it's late enough that > I wouldn't trust that analysis too much :( > > The code in question is thus: > > if ($ParentMBflag=='A'){ /*Its an assembly */ > $sql = "SELECT stockmaster.stockid, > stockmaster.description > FROM stockmaster > WHERE stockmaster.mbflag !='D' > AND stockmaster.mbflag !='K' > AND stockmaster.mbflag !='A' > AND stockmaster.controlled = 0 > AND > stockmaster.stockid != '$SelectedParent' > ORDER BY stockmaster.stockid"; > > } else { /*Its either a normal manufac item or a > kitset - controlled items ok */ > $sql = "SELECT stockmaster.stockid, > stockmaster.description > FROM stockmaster > WHERE stockmaster.mbflag !='D' > AND stockmaster.mbflag !='K' > AND stockmaster.mbflag !='A' > AND stockmaster.stockid != '$SelectedParent' > ORDER BY stockmaster.stockid"; > } > > That's starting at line 550 of BOMs.php. Is there any particular > reason for this, or is it a hangover from pre-multi-level BOMs? > > Lindsay > ready for bed > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Web-erp-developers mailing list > Web-erp-developers@... > https://lists.sourceforge.net/lists/listinfo/web-erp-developers -- Phil Daintree <phil@...> ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Web-erp-developers mailing list Web-erp-developers@... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
|
|
Re: Kit containing an Assembly
by Lindsay Harris
::
Rate this Message:
Phil,
Allowing assemblies as components in a kit is quite sufficient for my needs. It makes no sense to allow assemblies into manufacturing BOMs, as the individual components can be easily added. The benefit in our case is that the invoice lists the assembly name, as that is what the customers order. Lindsay On Wed, 14 May 2008 09:57:16 Phil Daintree wrote: > Hi Lindsay > > Multi-level BOMs were in from the beginning. > > I am thinking we could change it to allow assembly items as > components of kit-sets only since assemblies are only processed on > invoicing. We can't have assemblies as components of manufactured > items - assemblies are a way to sell a selection of items as a > bundle. > > Phil > > The first block is about limiting assembly items so components > cannot be controlled - we've covered the reasons for this > extensively previously - the all other items > > On Tue, 13 May 2008 21:53:12 +1000 > > Lindsay Harris <lindsay@...> wrote: > > I am trying to add an assembly to a kit. Assemblies don't show > > up in the list of available items to add to a kit. The SQL to > > determine the list of usable items to add to a kit specifically > > excludes assemblies or other kits, as I read it, though it's > > late enough that I wouldn't trust that analysis too much :( > > > > The code in question is thus: > > > > if ($ParentMBflag=='A'){ /*Its an assembly */ > > $sql = "SELECT stockmaster.stockid, > > stockmaster.description > > FROM stockmaster > > WHERE stockmaster.mbflag !='D' > > AND stockmaster.mbflag !='K' > > AND stockmaster.mbflag !='A' > > AND stockmaster.controlled = 0 > > AND > > stockmaster.stockid != > > '$SelectedParent' ORDER BY stockmaster.stockid"; > > > > } else { /*Its either a normal manufac item or a > > kitset - controlled items ok */ > > $sql = "SELECT stockmaster.stockid, > > stockmaster.description > > FROM stockmaster > > WHERE stockmaster.mbflag !='D' > > AND stockmaster.mbflag !='K' > > AND stockmaster.mbflag !='A' > > AND stockmaster.stockid != '$SelectedParent' > > ORDER BY stockmaster.stockid"; > > } > > > > That's starting at line 550 of BOMs.php. Is there any > > particular reason for this, or is it a hangover from > > pre-multi-level BOMs? > > > > Lindsay > > ready for bed > > > > ----------------------------------------------------------------- > >-------- This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Web-erp-developers mailing list > > Web-erp-developers@... > > https://lists.sourceforge.net/lists/listinfo/web-erp-developers ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ Web-erp-developers mailing list Web-erp-developers@... https://lists.sourceforge.net/lists/listinfo/web-erp-developers |
| Free Forum Powered by Nabble | Forum Help |
