sql-ledger-users

[SL] Assembly : BOM Qty On Hand not updated

[Akhmad D. S. <da...@vi...>]

Hi guys,
I'm using 2.8.17.

1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
    and the Qty On Hand of both parts are 100 kg
3. I created Sales Invoice for 100 units of the Assembly and posted it
4. Logically the Qty on Hand of Part A will be decreased by 0.1 * 100 = 
10 kg
    and updated to 90 kg, as well as Part B.

But, I did not see any updates in both Part A and Part B Qty On Hand..
Did I miss something here?

Thanks

-- 
-Daniel-
http://www.vitraining.com  
http://akhdaniel.wordpress.com

Re: [SL] Assembly : BOM Qty On Hand not updated

[Armaghan S. <sa...@le...>]

> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
> 2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
>    and the Qty On Hand of both parts are 100 kg

At this point you need to use the 'Goods & Services--Stock Assembly'
menu option to 'build' your assemblies. This option removes individual
components from stock and adds the assemblies which you can sell as
you are doing in step 3.

This way stock levels for components and assemblies will be correct.

Let me know if I am not clear.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--

Re: [SL] Assembly : BOM Qty On Hand not updated

[Michael H. <mh...@it...>]

Also check your Precision setting in the System Defaults page.


Thanks,

Michael


On Oct 1, 2008, at 6:32 PM, Armaghan Saqib wrote:

>> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg  
>> of Part B
>> 2. I purchased 100 kg of Part A and 100 kg of Part B through  
>> Vendor Invoice
>>    and the Qty On Hand of both parts are 100 kg
>
> At this point you need to use the 'Goods & Services--Stock Assembly'
> menu option to 'build' your assemblies. This option removes individual
> components from stock and adds the assemblies which you can sell as
> you are doing in step 3.
>
> This way stock levels for components and assemblies will be correct.
>
> Let me know if I am not clear.
>
> -- 
> * Purpose-built SQL-Ledger Hosting. Free trial.
> * SQL-Ledger Documentation Wiki
> * SQL-Ledger VMware Appliance. Free download.
> http://www.ledger123.com/
>
> --
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Assembly : BOM Qty On Hand not updated

[Akhmad D. S. <da...@vi...>]

Armaghan Saqib wrote:

>>1. I added an Assembly which contains 0.1 kg of Part A, and 0.1 kg of Part B
>>2. I purchased 100 kg of Part A and 100 kg of Part B through Vendor Invoice
>>   and the Qty On Hand of both parts are 100 kg
>>    
>>
>
>At this point you need to use the 'Goods & Services--Stock Assembly'
>menu option to 'build' your assemblies. This option removes individual
>components from stock and adds the assemblies which you can sell as
>you are doing in step 3.
>
>This way stock levels for components and assemblies will be correct.
>
>Let me know if I am not clear.
>
>  
>
Hi Saqib, it's clear and thanks.
Actually I've done that step before, but the effect was the part's Qty 
on Hand becomes blank.
We can see that in the Parts Report page and the Edit Part page. Was it 
a bug ?

For this particular assembly, in the real situation, I do not need to 
stock it, i.e. I will assembly it when there's
a sale on that assembly.

I've tried the same steps on the SQL ledger online demo as well and the 
result was the same.

Please help and thanks.

-- 
-Daniel-
http://www.vitraining.com  
http://akhdaniel.wordpress.com

Re: [SL] Assembly : BOM Qty On Hand not updated

[Michael H. <mh...@it...>]

Blank means zero which, if they are all embedded in assemblies now,  
is correct.


Thanks,

Michael Hasse
Itwerx
206-850-1496
http://www.itwerx.net/

**********************************
If our service is not 100% satisfactory please tell us!
If it is 100% please tell others!
**********************************

On Oct 2, 2008, at 7:20 PM, Akhmad Daniel Sembiring wrote:

> Armaghan Saqib wrote:
>
>>> 1. I added an Assembly which contains 0.1 kg of Part A, and 0.1  
>>> kg of Part B
>>> 2. I purchased 100 kg of Part A and 100 kg of Part B through  
>>> Vendor Invoice
>>>   and the Qty On Hand of both parts are 100 kg
>>>
>>>
>>
>> At this point you need to use the 'Goods & Services--Stock Assembly'
>> menu option to 'build' your assemblies. This option removes  
>> individual
>> components from stock and adds the assemblies which you can sell as
>> you are doing in step 3.
>>
>> This way stock levels for components and assemblies will be correct.
>>
>> Let me know if I am not clear.
>>
>>
>>
> Hi Saqib, it's clear and thanks.
> Actually I've done that step before, but the effect was the part's Qty
> on Hand becomes blank.
> We can see that in the Parts Report page and the Edit Part page.  
> Was it
> a bug ?
>
> For this particular assembly, in the real situation, I do not need to
> stock it, i.e. I will assembly it when there's
> a sale on that assembly.
>
> I've tried the same steps on the SQL ledger online demo as well and  
> the
> result was the same.
>
> Please help and thanks.
>
> -- 
> -Daniel-
> http://www.vitraining.com
> http://akhdaniel.wordpress.com
>
>
> ---------------------------------------------------------------------- 
> ---
> This SF.Net email is sponsored by the Moblin Your Move Developer's  
> challenge
> Build the coolest Linux based applications with Moblin SDK & win  
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in  
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> sql-ledger-users mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sql-ledger-users

Re: [SL] Assembly : BOM Qty On Hand not updated

[Armaghan S. <sa...@le...>]

On Fri, Oct 3, 2008 at 7:20 AM, Akhmad Daniel Sembiring
<da...@vi...> wrote:
> Actually I've done that step before, but the effect was the part's Qty
> on Hand becomes blank.

As Michael pointed out, this means that parts qty became zero as the
result of 'building' the assembly.

Also make sure that you run the 'Stock Assembly' process only once.
One short coming of the build-in stock assembly process is that there
is no log maintained for any stock assembly operation. This might
cause trouble if you inadvertently run 'Stock Assembly' process more
than required number of times.

I have a patch which logs each Stock assembly operation along with a
new report to list the activity. Contact me off-list to get this free
patch.

> For this particular assembly, in the real situation, I do not need to
> stock it, i.e. I will assembly it when there's
> a sale on that assembly.

You have to run the stock assembly process in advance before selling
the assembly. But with a simple API call in invoice post procedure, it
should be possible to run the 'Stock Assembly' process for the
assemblies being sold.

-- 
* Purpose-built SQL-Ledger Hosting. Free trial.
* SQL-Ledger Documentation Wiki
* SQL-Ledger VMware Appliance. Free download.
http://www.ledger123.com/

--