[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Goods and Services etc



Hi Martin,

There is no problem with doing that, but i suggest you to use pgadmin
(if you are not close to sql),
create a new database and restore data only in there, then you can make tests.


Good luck

David

On Jan 30, 2008 10:21 PM, Martin Prior <..hidden..> wrote:
> I run a small bakery, where we make not only bread but items like peanut
> butter etc.
>
> As a test I entered all the parts we need to make peanut butter: 1 bottle,
> 1 top, 1 seal and peanut butter using unit weight of 1 kilo.
>
> I then entered into the assembly the above components and peanut butter as
> .250 gram
>
>  From the retail prices for the parts it has calculated a sale price
> correctly. So far this looks good.
>
> Am I correct in saying that if I have the necessary parts in stock and
> transfer the assemblies to the w/house this will automatically reduce my
> parts stock and enter the assemblies as goods for sale?
>
> I am quite new to sql, although I have been around computer systems for
> over 30 years. If I make a dump of my database, can I reload it under
> another name and use it for testing? Or will it create the same named
> database, thus overwriting the original?
>
> Martin Prior
>
> -------------------------------------------------------------------------
> 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/
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>