FrontAccounting forum — Invoice number with multiple series

Re: Invoice number with multiple series

null@example.com (mariogroca) — Wed, 30 Nov 2011 00:17:38 +0000

I started working in the multiple series and emitting centers. If someone is willing to help is welcome.
Already identified from where are assigned reference numbers of the bills and I'm starting to change the functions corresponding to take the reference number according to the emission center I'll add in points of sale.
Someone can send me an outline or something to guide me in the places I should be modifying as I go on the bill?
I am using eclipse but because I am new at this, it´s really hard. I'm making progress, but I think with some help I can do it faster.
thanks

Re: Invoice number with multiple series

null@example.com (mariogroca) — Mon, 21 Nov 2011 11:34:06 +0000

I was doing some tests ....
Is there no way to relate different series for different users without changing much of the application code?
Because I could relate each user with a different series and it would solve my problem.
Thanks!

Re: Invoice number with multiple series

null@example.com (joe) — Sun, 20 Nov 2011 08:11:12 +0000

FA can only handle 1 automatic serie, like A-0001-00005632. If you want more series, you will have to keep track of each individual serie, because FA will only update the last used serie.

/Joe

Re: Invoice number with multiple series

null@example.com (mariogroca) — Sat, 19 Nov 2011 23:16:55 +0000

I'am looking for something like this.
I need the same thing, invoice with letters and emitting centers. like this Ej: A-0001-00005632 or B-0001-00000365, where the letter it´s related to the fiscal condition of the client.
Yes, I know we have a complicated fiscal system, but, what can I say?, I live in Argentina, je
So, If someone have any ideas to share, i'm just a beginner in PHP but I will try to modified the system so It can fit into the fiscal rules of my country.
I think this is a great system and with some minor adjustments i´ll work just fine.

Re: Invoice number with multiple series

null@example.com (apprayo) — Tue, 26 Apr 2011 07:56:36 +0000

Thanks Joe.

Albert

Re: Invoice number with multiple series

null@example.com (joe) — Tue, 26 Apr 2011 07:46:44 +0000

You can look into the file /includes/types.inc.

/Joe

Re: Invoice number with multiple series

null@example.com (apprayo) — Tue, 26 Apr 2011 06:48:00 +0000

joe wrote:

Type_id is a special kind of type, like Sales Order, Sales Invoice, Sales Credit, PO, GRN, Supp Invoice, etc. etc.
There is a type_id for every kind of operation.

For example: type_id 17 is for inventory adjustments?
I'm interested to know about this further. Is there a complete list of type_ids?

I went to https://frontaccounting.com/fawiki, TechInfo Resources to be exact, but cannot find such info. The ER diagram only shows which tables relate to sys_types.

Albert

Re: Invoice number with multiple series

null@example.com (joe) — Tue, 26 Apr 2011 06:19:50 +0000

Type_id is a special kind of type, like Sales Order, Sales Invoice, Sales Credit, PO, GRN, Supp Invoice, etc. etc.
There is a type_id for every kind of operation.
Trans_no is a unique identifier inside the type_id for assembling the rows to goto the GL.

For more info please look at the https://frontaccounting.com/fawiki

/Joe

Re: Invoice number with multiple series

null@example.com (apprayo) — Tue, 26 Apr 2011 04:43:35 +0000

joe wrote:

The type_no is a link to the underlying GL entries. A Journal Entry consist of 2 or more rows that belongs to the same voucher (Journal Entry). These rows belongs to the same type_no.

Can you explain how does the sys_types table work in general?
What is field type_id used for?

Albert

Re: Invoice number with multiple series

null@example.com (itronics) — Mon, 07 Mar 2011 21:00:25 +0000

You have probably broken FA installation. Read FAQ to find more on FA debugging.
Janusz

Re: Invoice number with multiple series

null@example.com (anwarkc) — Mon, 07 Mar 2011 07:56:46 +0000

I installed a fresh copy of 2.3.2 and everything is working fine, except for the forms setup. When i click on forms setup its not showing the forms next reference numbers. The page is blank with just the UPDATE button and does not show any fields to enter.
Please help!!!!!!!!!!!!!!!!!!!

Re: Invoice number with multiple series

null@example.com (joe) — Mon, 17 Jan 2011 22:29:23 +0000

Hello,
The type_no is a link to the underlying GL entries. A Journal Entry consist of 2 or more rows that belongs to the same voucher (Journal Entry). These rows belongs to the same type_no.

/Joe

Re: Invoice number with multiple series

null@example.com (mosha3D) — Mon, 17 Jan 2011 19:32:01 +0000

detail, note that the reference is one and the number of transaction is another

(un detalle, ten en cuenta que la referencia es una y el numero de transaccion es otra)

Re: Invoice number with multiple series

null@example.com (mosha3D) — Mon, 17 Jan 2011 18:54:32 +0000

I also I have doubts about what it means in sys_types type_no

Can you guide Joe or Janusz?

Attempt to put data into a temporary table, waiting for permission to go to the table after stock_moves. This table must have its own autoincrement.

Thanks

to rcuadra:
ABC functions for the references are in: (las funciones para el ABC con las referencias estan en: )
includes/db/references_db.inc

other files involved are: (otros archivos involucrados son:)
includes/types.inc
includes/sysnames.inc
includes/systypes.inc

as I said above, not clear to me that means type_no and where you put that as a reference
(como dije arriba, no me queda claro que significa type_no y donde se pone ese valor como referencia)

sorry for my English

Re: Invoice number with multiple series

null@example.com (joe) — Fri, 14 Jan 2011 08:17:32 +0000

Hello friends,

Nice to see a Spanish conversation, but if you guys think this can be of interest for the rest of the community, please try to do this in English

/Joe