Price from catalog not applied to invoice

[Adrian Stern]

Hi

I've noticed that whenever i create an invoice i have to type the price
myself. When doing the same on the demo server, the price is automatically
added.

I've configured A catalog for anything i offer with the sub categories of
services / product with an aditional sub categorie of "real service" and
"real product".

I did notice that even on the demo server the prices don't get applied for
every product. I just can't find out why. But i think it is very possible
that my problems in tax/accounting result from a misconfiguration for
Catalog/Category/Product.

I also added the new category to the tax authority with a percentage of
0.08 VAT.

*What could prevent the prices defined in the catalog from being
automatically used in invoices?*

Regards, A

[Sharan-F]

Hi Adrian

If you can give me some details about the version of OFBiz you are using with information about the data you loaded (did you just use seed, or have you got the demo data loaded too!) what product setup you have done (store, category, product) and how you are creating your invoices (e.g. are you doing it manually or are you processing sales orders to generate it) - then I'll see if I can replicate your issues.

Thanks
Sharan

[Adrian Stern]

Hi Sharan

Thank you for your reply. I did not load the seed data nor the demo data
since there is too much US-specific stuff in it. I've created my own chart
of accounts for switzerland and basic seed data for "Company" with a Bank
account etc. Processing invoices generally works. Values are postet
correctly and the balance is OK in the end. Everyting inside our own seed
data is a more or less copy/paste of the original seed data with just the
values we need.

I created the invoices manually with Accounting - Invoices - Create new
Invoice. Same goes for the payment.

Setup done with:
http://www.hotwaxmedia.com/apache-ofbiz-blog/ofbiz-tutorial-how-to-setup-the-ofbiz-catalog-manager/

Setup Store:

   1. http://picpaste.com/store_1-w0irUUcr.png
   2. http://picpaste.com/store_2-yDcD6v1J.png
   3. Store-Catalogs: ANGEBOTE (Offers)

Setup Catalog:

   1. ANGEBOTE (Offers)
   2. http://picpaste.com/catalog_1-LElZBwnJ.png
   3. Catalog-Stores: The only store "above"
   4. http://picpaste.com/catalog_2-b7VeVE49.png

Setup Categories:

   1. http://picpaste.com/categories_1-M0p6ToNl.png
   2. Main-Categories have no Rollup
   3. Sub-Categories have Rollup of Parent categorie (Parent: Services,
   Child: Real Services)
   4. Products are added to Sub-Categorie
   5. Parent Categories are added to tax-authority

Setup Products:

   1. http://picpaste.com/prod_1-hPsSK1jN.png
   2. ENTW_DJANGO: http://picpaste.com/prod_2-ZZipjwvT.png
   3. ENTW_DJANGO: http://picpaste.com/prod_3-UvdyGpz7.png
   4. ENTW_DJANGO: also added to subcategory Real Services
   5. Other Product Same Same but "Finished Good" and added to "Real
   Products" sub category

Hopefully this is of some help for you. Thanks.


On 8 October 2014 12:35, Sharan-F <[hidden email]> wrote:

> Hi Adrian
>
> If you can give me some details about the version of OFBiz you are using
> with information about the data you loaded (did you just use seed, or have
> you got the demo data loaded too!) what product setup you have done (store,
> category, product) and how you are creating your invoices (e.g. are you
> doing it manually or are you processing sales orders to generate it) - then
> I'll see if I can replicate your issues.
>
> Thanks
> Sharan
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656618.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Sharan-F]

Hi Adrian

Thanks for all the details.

I'm going to have to load the seed data though as I dont have a copy of yours.

I will run through and try to replicate what you have done. The main difference will be the seed data - which I think is another possible area that could be causing your issues.

It will probably be tomorrow before I can start looking at it though and if I have any questions I'll get back to you.

I will let you know how I get on.

Thanks
Sharan

[Adrian Stern]

Hi Sharan

Yes. Of course take your time. In the mean while i will change my mailing
list account to my business account.

On 8 October 2014 14:24, Sharan-F <[hidden email]> wrote:

> Hi Adrian
>
> Thanks for all the details.
>
> I'm going to have to load the seed data though as I dont have a copy of
> yours.
>
> I will run through and try to replicate what you have done. The main
> difference will be the seed data - which I think is another possible area
> that could be causing your issues.
>
> It will probably be tomorrow before I can start looking at it though and if
> I have any questions I'll get back to you.
>
> I will let you know how I get on.
>
> Thanks
> Sharan
>
>
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656627.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Adrian Stern-2]

Which would be this one. Sorry if the span annoys anyone. It ends now.

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 9, 2014 at 1:32 PM, Adrian Stern <[hidden email]> wrote:

> Hi Sharan
>
> Yes. Of course take your time. In the mean while i will change my mailing
> list account to my business account.
>
> On 8 October 2014 14:24, Sharan-F <[hidden email]> wrote:
>
> > Hi Adrian
> >
> > Thanks for all the details.
> >
> > I'm going to have to load the seed data though as I dont have a copy of
> > yours.
> >
> > I will run through and try to replicate what you have done. The main
> > difference will be the seed data - which I think is another possible area
> > that could be causing your issues.
> >
> > It will probably be tomorrow before I can start looking at it though and
> if
> > I have any questions I'll get back to you.
> >
> > I will let you know how I get on.
> >
> > Thanks
> > Sharan
> >
> >
> >
> >
> >
> > --
> > View this message in context:
> >
> http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656627.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
>

[Sharan-F]

Hi Adrian

A quick update. I took a look at your issue this morning and with your information and my very limited setup I'm also not getting the product price brought through onto a manually created invoice (and it should be defaulting a price if the product exists in the catalog).

However it does bring the product price through if you are creating a sales order. I'm still thinking about what could be causing it. I've got a few priority things to complete over the next few days so if I get the chance again I'll continue investigating.

Thanks
Sharan

[Adrian Stern-2]

Hi Sharan

Thanks for your reply. I will check if it works with a sales order
then. At least with this i can investigate the TAX stuff a bit more.

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]


On Thu, Oct 9, 2014 at 4:43 PM, Sharan-F <[hidden email]> wrote:

> Hi Adrian
>
> A quick update. I took a look at your issue this morning and with your
> information and my very limited setup I'm also not getting the product price
> brought through onto a manually created invoice (and it should be defaulting
> a price if the product exists in the catalog).
>
> However it does bring the product price through if you are creating a sales
> order. I'm still thinking about what could be causing it. I've got a few
> priority things to complete over the next few days so if I get the chance
> again I'll continue investigating.
>
> Thanks
> Sharan
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656653.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

[Adrian Stern-2]

Hi Sharan, i actually answered the wrong thread before. So i apologize for
double-posting this.

I tried the process starting from a sales order. The prices where added
automatically but there where still no taxes calculated. No Tax-Account
used in balance.

The process of creating a sales order was a bit painful. I had to create
payment methods for the store - which does make sense. When i was
finalizing my order i hit complete many times but it was just reloading the
same page without a message explaining why the order could not be
created... after adjusting a few things it works but i dont know exactly
why as of yet.

*So the Questtion: *When you tried this steps, where the taxes applied
correctly?

(I belive my gl account setup being the problem for the taxes not being
posted )

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Thu, Oct 9, 2014 at 5:09 PM, Adrian Stern <[hidden email]>
wrote:

> Hi Sharan
>
> Thanks for your reply. I will check if it works with a sales order
> then. At least with this i can investigate the TAX stuff a bit more.
>
> Freundliche Grüsse
>
> Adrian Stern
> unchained - web solutions
>
> [hidden email]
> [phone]
>
>
> On Thu, Oct 9, 2014 at 4:43 PM, Sharan-F <[hidden email]> wrote:
> > Hi Adrian
> >
> > A quick update. I took a look at your issue this morning and with your
> > information and my very limited setup I'm also not getting the product
> price
> > brought through onto a manually created invoice (and it should be
> defaulting
> > a price if the product exists in the catalog).
> >
> > However it does bring the product price through if you are creating a
> sales
> > order. I'm still thinking about what could be causing it. I've got a few
> > priority things to complete over the next few days so if I get the chance
> > again I'll continue investigating.
> >
> > Thanks
> > Sharan
> >
> >
> >
> > --
> > View this message in context:
> http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656653.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacques Le Roux]

Hi,

As a Jira created for that?

Jacques

Le 09/10/2014 16:43, Sharan-F a écrit :

> Hi Adrian
>
> A quick update. I took a look at your issue this morning and with your
> information and my very limited setup I'm also not getting the product price
> brought through onto a manually created invoice (and it should be defaulting
> a price if the product exists in the catalog).
>
> However it does bring the product price through if you are creating a sales
> order. I'm still thinking about what could be causing it. I've got a few
> priority things to complete over the next few days so if I get the chance
> again I'll continue investigating.
>
> Thanks
> Sharan
>
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656653.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[Jacques Le Roux]

Le 19/10/2014 11:43, Jacques Le Roux a écrit :
> Hi,
>
> As a Jira created for that?

As a Jira been created for that? :)

>
> Jacques
>
> Le 09/10/2014 16:43, Sharan-F a écrit :
>> Hi Adrian
>>
>> A quick update. I took a look at your issue this morning and with your
>> information and my very limited setup I'm also not getting the product price
>> brought through onto a manually created invoice (and it should be defaulting
>> a price if the product exists in the catalog).
>>
>> However it does bring the product price through if you are creating a sales
>> order. I'm still thinking about what could be causing it. I've got a few
>> priority things to complete over the next few days so if I get the chance
>> again I'll continue investigating.
>>
>> Thanks
>> Sharan
>>
>>
>>
>> --
>> View this message in context: http://ofbiz.135035.n4.nabble.com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656653.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>

[Adrian Stern-2]

Hi Jacques

No i did not create a jira ticket for that. Acutally i believe it is a
matter of conrfigurationen and not a bug.
I just learnd that the book i ordered was delivered to my neighbor 10 days
ago... which nobody told me. So hopefully that will help me a bit tomorrow.

Freundliche Grüsse

Adrian Stern
unchained - web solutions

[hidden email]
[phone]

On Sun, Oct 19, 2014 at 12:24 PM, Jacques Le Roux <
[hidden email]> wrote:

>
> Le 19/10/2014 11:43, Jacques Le Roux a écrit :
>
>> Hi,
>>
>> As a Jira created for that?
>>
>
> As a Jira been created for that? :)
>
>
>
>> Jacques
>>
>> Le 09/10/2014 16:43, Sharan-F a écrit :
>>
>>> Hi Adrian
>>>
>>> A quick update. I took a look at your issue this morning and with your
>>> information and my very limited setup I'm also not getting the product
>>> price
>>> brought through onto a manually created invoice (and it should be
>>> defaulting
>>> a price if the product exists in the catalog).
>>>
>>> However it does bring the product price through if you are creating a
>>> sales
>>> order. I'm still thinking about what could be causing it. I've got a few
>>> priority things to complete over the next few days so if I get the chance
>>> again I'll continue investigating.
>>>
>>> Thanks
>>> Sharan
>>>
>>>
>>>
>>> --
>>> View this message in context: http://ofbiz.135035.n4.nabble.
>>> com/Price-from-catalog-not-applied-to-invoice-tp4656617p4656653.html
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>>
>>