Author Topic: Failed write to field order_Billtax when making manual order from backend  (Read 398 times)

antifragile

  • Beginner
  • *
  • Posts: 39
Hi, I have been having this issue for years, always resolved it in Excel when making my reporting. Annoyance, but not a dealbreaker. But perhaps someone here can help me resolve it please?

I have two VATs (19% and 7%) for two product types. When orders are made via the front-end shop, all works well.

However, when I create an order manually through the backend, it does not write the tax amount to the field order_Billtax in the table _virtuemart_oders. Odd is that it is random, sometimes one of the two tax amounts are missing, sometimes both. The products and their tax rules are correctly entered.

The field order_Billtax is quite complex anyways ({"1":{"virtuemart_calc_id":1,"calc_name":"MwSt. 7%","calc_value":"7.0000","result":0.82},"2":{"virtuemart_calc_id":2,"calc_name":"MwSt. 19%","calc_value":"19.0000","result":0.32}}). Apparently there are no distinct fields for the different tax values (only the aggregated amounts, not sensitive to rate). For my tax reporting I need to break up the fields. Am I missing something?

Many thanks for any advise on this!

Cheers,

Dan

J3.8.5
VM3.2.12
PHP7.0

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1534
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Hello Afaik VM is not capable of creating new orders in back end. You must have some custom extension. Please talk to the extension developer.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

antifragile

  • Beginner
  • *
  • Posts: 39
Hello Afaik VM is not capable of creating new orders in back end. You must have some custom extension. Please talk to the extension developer.

regards

Jörgen @ Kreativ Fotografi

Jörgen, you are right. VM Invoice from Artio (I am following up with them now). I am only seeing now that this is indeed not possible in the core Virtuemart. Sorry about my confusion on this!

Perhaps the option to create a manual order as a future feature request? At times some people are not Internet-versed and we take orders via the phone, which we then record in VM.


As to my section question related the the field order_Billtax on whether there are ways to show different VAT-amounts in seperate table columns, any ideas please? (This is core VM, right?)

Many thanks and regards,

Dan

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1534
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Different VAT are shown in different rows on the order and invoice. Different columns I am not so sure. Test and see on Your orders and invoices howe it gets presented.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

antifragile

  • Beginner
  • *
  • Posts: 39
Different VAT are shown in different rows on the order and invoice. Different columns I am not so sure. Test and see on Your orders and invoices howe it gets presented.

regards

Jörgen @ Kreativ Fotografi

Jörgen, thank you, but small misunderstanding. On the invoice itself, the VATs are indeed shown in different rows. What I meant are the fields in the database. The entry there is: {"1":{"virtuemart_calc_id":1,"calc_name":"MwSt. 7%","calc_value":"7.0000","result":0.82},"2":{"virtuemart_calc_id":2,"calc_name":"MwSt. 19%","calc_value":"19.0000","result":0.32}}, all sitting in a single field. I am seeking a solution for having all 19% data in one table column, all 7% data in another. (Sorry, my PHP skills are rather basic)

Many thanks!

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1534
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Hello
I suspect that this is the reason for the solution. Because You can not predict how many VAT variants there are used. You can not assign individual columns for this. How many would be enough 2, 5, 10 or 40 ? What shall we call them 5%? You have to encode the VAT You are using into this single column. I hope that this explanation is fairly accurate and easy to understand.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)

antifragile

  • Beginner
  • *
  • Posts: 39
Hello
I suspect that this is the reason for the solution. Because You can not predict how many VAT variants there are used. You can not assign individual columns for this. How many would be enough 2, 5, 10 or 40 ? What shall we call them 5%? Yo have to encode the VAT You are using into this single column. I hope that this explanation is fairly accurate and easy to understand.

regards

Jörgen @ Kreativ Fotografi

Jörgen, makes sense, got it! I have a little macro that pulls this apart in Excel. Just a small extra step.

Many thanks!

Dan

Jörgen

  • Global Moderator
  • Full Member
  • *
  • Posts: 1534
    • Kreativ Fotografi
  • VirtueMart Version: 3.2.12
Thanks for the reply. Good to hear that it worked out for You.

regards

Jörgen @ Kreativ Fotografi
Joomla 3.8.3
Virtuemart 3.2.12
Olympiantheme Hera (customized)