Acomba (Forum)
Pourquoi ne pas devenir membre du forum ?

Identifiez-vous ou Inscrivez-vous afin d'accéder à l'inrégralité du forum:
Accès à toutes les catégories du forum,
Entraide entre les 6 500 membres, et ce nombre s'accroît quotidiennement!

Notez que ce forum est indépendant de la société Acceo Solutions, éditrice du logiciel Acomba.
Connexion

Récupérer mon mot de passe


Invoice Number

Voir le sujet précédent Voir le sujet suivant Aller en bas

Invoice Number

Message  JennyZou le Mer 5 Jan 2011 - 9:17

Can I set invoice number?
Code:
TransactionInt.BlankCard()
TransactionInt.PKey_InInvoiceNumber = "17"
TransactionInt.PKey_InInvoiceType = 1
iError = TransactionInt.ReserveCardNumber
If iError <> 0 Then
      MsgBox("Erreur : " & Acomba.GetErrorMessage(iError))
End If
The code above doesn't work. It tells me the transaction type is not correct. Is there any way to set invoice number to "17" instead of generating by system? Thanks.

Jenny

JennyZou

Nombre de messages : 25
Date d'inscription : 15/12/2010

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

RE: Invoice Number

Message  PlanteG le Mer 5 Jan 2011 - 13:48

Well, the answer is yes and no Neutral .

It depends on the type of invoice you wish to create. If you want to create a "regular" invoice you wish to print, for example going Invoicing > Invoices, the number is set by Acomba.

But if you create a transaction, for example going Accounts receivable > Transactions, which is a General Ledger transaction, then you can set the invoice number to whatever you wish.

Regular invoices transparently creates a corresponding transaction in Accounts receivable. You can refer to items in inventory and generates nice printed invoices. If you wish to set yourself the invoice number - I guess the invoices are created outside Acomba and then inserted into Acomba - then you have no choice but create AR Transactions instead of Invoices.

You are probably working with Transaction (regular invoices) and should be working with TransAr.
avatar
PlanteG

Nombre de messages : 980
Ville : Québec
Date d'inscription : 11/07/2007

Fiche d'Entreprise
Nom de l'entreprise: Informatique Gilles Plante

Voir le profil de l'utilisateur http://ingp.ca

Revenir en haut Aller en bas

Re: Invoice Number

Message  JennyZou le Mer 5 Jan 2011 - 14:06

Thank you very much.

Yes, you are right. I guess I have no choice. AR transaction is too simple and regular invoice is what I need. Is it possible to set GL account number? Only when I create AR transaction then I could set GL account number?

I would like to ask another question: I create a transaction whose type is purchase. It appears on inventory->purchase. Is it supposed to create AP transaction automatically, just like AR?

JennyZou

Nombre de messages : 25
Date d'inscription : 15/12/2010

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

Re: Invoice Number

Message  JennyZou le Mer 5 Jan 2011 - 15:22

PlanteG a écrit:Well, the answer is yes and no Neutral .

It depends on the type of invoice you wish to create. If you want to create a "regular" invoice you wish to print, for example going Invoicing > Invoices, the number is set by Acomba.

But if you create a transaction, for example going Accounts receivable > Transactions, which is a General Ledger transaction, then you can set the invoice number to whatever you wish.

Regular invoices transparently creates a corresponding transaction in Accounts receivable. You can refer to items in inventory and generates nice printed invoices. If you wish to set yourself the invoice number - I guess the invoices are created outside Acomba and then inserted into Acomba - then you have no choice but create AR Transactions instead of Invoices.

You are probably working with Transaction (regular invoices) and should be working with TransAr.
I guess if I have to create regular invoice, I have no way to check duplicate?

JennyZou

Nombre de messages : 25
Date d'inscription : 15/12/2010

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

Re: Invoice Number

Message  hench le Jeu 6 Jan 2011 - 10:48

...Acomba won't allow to add the transaction if current number is duplicate anyway

Check for a specifically numbered transaction using methods FindKey / SearchKey, That'll do the trick !

G'Luck!

hench

hench

Nombre de messages : 163
Date d'inscription : 30/12/2008

Fiche d'Entreprise
Nom de l'entreprise:

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

Re: Invoice Number

Message  JennyZou le Jeu 6 Jan 2011 - 11:05

Since I cannot modify transaction->invoice number, how can I use FindKey to check duplicate.

For example: In my system, I have an invoice whose invoice number is 1234. When I import this invoice to Acomba, I couldn't set PKey_InInvoiceNumber to 1234 neither other key, and Acomba will create an invoice whose number is whatever, say 1001. In this case, I think FindKey couldn't help me.

JennyZou

Nombre de messages : 25
Date d'inscription : 15/12/2010

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

Re: Invoice Number

Message  hench le Jeu 6 Jan 2011 - 13:31

Could you try setting Key_InInvoiceNumber instead of PKey_InInvoiceNumber ?

I believe you want to use Index 1 for that, here's the composition of Index 1 :


Key_InInvoiceType + Key_InInvoiceNumber + Key_InReceivableOffset

Some basic information about FindKey and Search, you will use FindKey if you know all the index values; However, SearchKey will allow to set partially the keys required by the index. More info available for you in the help file.



hench

Nombre de messages : 163
Date d'inscription : 30/12/2008

Fiche d'Entreprise
Nom de l'entreprise:

Voir le profil de l'utilisateur

Revenir en haut Aller en bas

Re: Invoice Number

Message  Contenu sponsorisé


Contenu sponsorisé


Revenir en haut Aller en bas

Voir le sujet précédent Voir le sujet suivant Revenir en haut

- Sujets similaires

 
Permission de ce forum:
Vous ne pouvez pas répondre aux sujets dans ce forum