Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

customer no. on invoice
(1 viewing) (1) Guest
Support forum for customers who have purchased this product. Archive only, no new post can be added.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.

TOPIC: customer no. on invoice

customer no. on invoice 12 years, 9 months ago #23090

hello :-)

we have another small problem. our financial office can not book the invoice without customer number. so we need to print them to the invoice. we need the number from

table: jos_vm_shopper_vendor_xref
field: customer_number

this is the standard field for the virtuemart customer numbers.

it should be like this on invoice:

Billing date:
maturity date:
payment type:
Customer No.:
The topic has been locked.

Re: customer no. on invoice 12 years, 9 months ago #23091

  • jaku
Hello,
this can be solved quite easily.

VM Invoice supports "extra fields" that may be generated on the invoice. So you can set the Customer No. to be such extra field and it will then be part of the invoice.

We have it setuped this way on our own site.
The topic has been locked.

Re: customer no. on invoice 12 years, 9 months ago #23092

hello,

could you explain how we can add the customer no. to the extra fields?
we can only choose title, name, street and so on but no customer number...

screenshot.jpg
The topic has been locked.

Re: customer no. on invoice 12 years, 9 months ago #23098

  • jaku
Hi,

well, it depends on where in VirtueMart you have the customer No. stored.
E.g. we are using custom defined fields is VirtueMart vm_company_id and vm_company_id.

extra_fields.png
Last Edit: 12 years, 9 months ago by .
The topic has been locked.

Re: customer no. on invoice 12 years, 9 months ago #23102

the customer no is in table jos_vm_shopper_vendor_xref and in field customer_number but it is not shown in the extra field select field in artio invoice.

customer_no.JPG


sql_database.JPG
The topic has been locked.

Re: customer no. on invoice 12 years, 9 months ago #23108

  • jaku
Hello,
that is right VM Invoice only offer fields that are available in vm_userfield table.

I am not sure what the customer_number in vm_shopper_vendor_xref represents, but that field is really not supported.

If you want it on the invoice, an adjustment in the component code needs to be done. If you wish, we can do it for you as paid support. In such case, please, send your request to This e-mail address is being protected from spambots. You need JavaScript enabled to view it .
Last Edit: 12 years, 9 months ago by .
The topic has been locked.
User Login Empty