Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Bill number uniqueness

Tesorería Ciclo Positivo   ( User )

Commented 3 years ago

Hi, I read this https://akaunting.com/docs/faq/auto-bill-number but I found that the bill number is being auto generated (e.g. BIL-xxxx).

Why is a unique constraint on bill_number and company, shouldn't be on bill_number and vendor? In Argentina, every bill has a number like XXXX-YYYYY. Two vendors may send you a bill with the same number.

Regards,
Diego.

Denis Dulici   ( Admin )

Commented 3 years ago

You can set the bill number as you wish while creating the bill if the auto-generated one doesn't suit your needs.

Tesorería Ciclo Positivo   ( User )

Commented 3 years ago

I can indeed set the bill number but it must be unique for a company. It can happen that two bills issued by different vendors have the same id. I don't want to touch the database tables or do stuff like that. It may be a reason for this constraint.

So, I think I'll add a new field for the actual bill using custom fields and using the autogenerated bill number.

Regards,
Diego.

Rory Hendrickson   ( User )

Commented 2 years ago

A related question, can you set the next Bill number like you can with Invoices (which is under Settings->Invoice->Next Number)?

Please login or register to leave a response.

Showing 1 to 4 of 4 discussions