[SOLVED] updating status and sending customer an update / comment

[Robert_ITMan]

[SOLVED] Issue 1: with VM 3.6.2 noticed issue when updating status and sending customer an update / comment. The order status must be changed or it does not save new comment and sends last comment - need to fix this as we should not have to change the order status to save or send a new comment. Easy fix right?

Issue 2: Calculations are not correct - for example edit one line item and enter a value in 'Total Discount', clear: 'Base price with tax', 'Program Price (Gross)', and 'TAX' - click update. Notice the product_discountedPriceWithoutTax is calculated wrong and the 'Program Price (Cost)' discounted value is wrong

Question 1: What is Purchase Order? Where is the help / info on this?

Question 2: What is '0000-00-00 unpaid' / 'partial paid' / 'balance owing'? Where is the help / info on this? Nice idea! Notice The dates are missing and before adding a partial amount the date is showing as 0000-00-00 why is this? Also - is there a way to disable this and/or improve it so when order status is complete it shows as paid without our having to manually update each order?

Question 3: I suggest adding new unique class to tables and better formatting especially for header info 'Billing details' and 'Ship to' so these are not expanded and us admins can quickly see the order items without having to scroll down past this every time - and if we want to see or edit this header info we could simply click to expand it. As-is this table has no class !! <table width="100%">

Question 4: Need to be able to update coupon descriptions and amounts (per order) when editing - saving us from having to edit in the DB directly

Question 5: Would be great if we can also edit the item options (product_attribute) - saving us from having to edit in the DB directly

Question 6: Would be great to also create a way to display the percentage of the discounts (using javascript, i.e. also valid in cases where there are multiple prices involved), as also suggested here by Studio 42: http://forum.virtuemart.net/index.php?topic=134380.msg467090#msg467090

[Robert_ITMan]

[SOLVED] Issue: resolved with 3.6.2.10159 - order status does not need to be changed to send/save new comment

Still have questions unanswered above

[jenkinhill]

Your 1 - asking about purchase order.   From WikiPedia (assuming you do mean being able to place an order through VM without having to pay ay the time of ordering - which is easy to set up)

A purchase order (PO) is a commercial document and first official offer issued by a buyer to a seller indicating types, quantities, and agreed prices for products or services. It is used to control the purchasing of products and services from external suppliers.
The difference between a purchase order and an invoice is that a purchase order is sent from a purchaser to a vendor to place an order while an invoice is sent from a vendor to a purchaser to request payment for an order.

As a rule of thumb, never ask more than one question in a single forum message!

[Robert_ITMan]

Your 1 - asking about purchase order.

Thank you jenkinhill for describing what a Purchase Order is - not actually what I was asking for, I'm asking for VM to add instructions to the help page about HOW TO use this in VM and what are the options and how do we set them and what the settings do.

As a rule of thumb, never ask more than one question in a single forum message!

Again, thank you jenkinhill for pointing this out - Yes, I will split it up if nothing ever happens on these questions ... I really just needed to put this in writing somewhere so VM person responsible for editing this will make it happen.

[Robert_ITMan]

Notice I found a 2nd issue

Issue 2: Calculations are not correct - for example edit one line item and enter a value in 'Total Discount', clear: 'Base price with tax', 'Program Price (Gross)', and 'TAX' - click update. Notice the product_discountedPriceWithoutTax is calculated wrong and the 'Program Price (Cost)' discounted value is wrong

[AH]

Show the detail of this order edit line issue for us to see please

My tests show order line editing is working fine - but I may not be testing your specific case

[Robert_ITMan]

See images

[AH]

In image 3 - I am probably being stupid - but that all looks pretty much correct to me

How do you think those figures should work out for you

Gross is 10

Tax is 11%

Discount is 4

10 + Tax is 11.10

11.10 - 4 = 7.10

[Robert_ITMan]

You missed 'Program Price (Cost)' discounted value is wrong:

?? 10.00 - 4.00 = 6.40 ??

[AH]

why -4

Gross = 7.10
Nett= 7.10/1.11 = 6.40

[Robert_ITMan]

See attached showing order and DB - and my red ink pointing out what I see

Math should be: 10.00 - 4.00 discount = 6.00
then tax at 11% = 6.00 * 1.11 = 6.66

[AH]

IT MAN

Doing some more testing I can see that there is something odd in the entries when manually inputting discount

But it should be noted that this field is called product_subtotal_discount - It should therefore reflect the value adjustment from the line subtotal, not from the base price thus a -ve amount should be input

See any entries in the db for a reduction discount value

I understand this does not solve your problem - but I believe that it explains part of the issue with your edit

[Robert_ITMan]

AH, Thank you for getting on this! Great that you now see we have something odd in the calculations. The discount has always been entered as positive and directly subtracts from the base price ('Product Price (Cost)' or product_item_price)

Entering a negative discount gives the same result regardless - all discounts in the DB are positive values to date.

[AH]

Hi Robert

With discounts form the front end - I see them as negative in the dbase

And in order edit - if the discount was form the FE it shows as a negative

I will ask the team if they understand this behaviour with order edit

[Robert_ITMan]

VirtueMart 3.6.3 10179 tested: issue and questions NOT addressed yet.