Discussion Forum: Thread 310383

 Author: ArteP View Messages Posted By ArteP
 Posted: Oct 5, 2021 02:27
 Subject: Is there a macro for auto numbering?
 Viewed: 105 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

ArteP (1047)

Location:  Denmark
Member Since Contact Type Status
Jan 2, 2016 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Brickworkers
Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld
 Author: beaverbrick View Messages Posted By beaverbrick
 Posted: Oct 5, 2021 03:35
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 29 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

beaverbrick (566)

Location:  United Kingdom, England
Member Since Contact Type Status
Jan 2, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: Brick Beaver
In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

This is a list of macros...
https://www.bricklink.com/help.asp?helpID=661

which can be used on these message templates... (Store Settings - Message Templates)
https://www.bricklink.com/v2/mystore/message_templates.page

Is that what you're looking for?
 Author: Stellar View Messages Posted By Stellar
 Posted: Oct 5, 2021 04:18
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 36 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Stellar (3491)

Location:  Spain, Comunidad Valenciana
Member Since Contact Type Status
Sep 24, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Stellar Bricks
BrickLink Discussions Moderator (?)
In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

There is no invoicing features for Europe self accounting.

With Instant Checkout orders what you can do is send a new invoice only to you
when you manually add there your sequential invoice number in the template before
submiting to your email.
 Author: Teup View Messages Posted By Teup
 Posted: Oct 5, 2021 05:13
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 39 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6595)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

Bricklink calls it "invoice", but it's actually really just a payment instruction.
You need to do your bookkeeping separately. Even if BL could do invoice numbering
for you, I still would advise against using it. Imagine you are selling something
outside of BL, or you sell of a pile of instruction booklets somewhere, or you
do some totally unrelated job for someone - you will want personal control over
your invoice numbering or you're going to end up with duplicate numbers.
You can use third party software for this, or an Excel template. Remember you
don't need to write invoices before payment (and technically you don't
even need to send them unless the customer asks).
 Author: Stellar View Messages Posted By Stellar
 Posted: Oct 5, 2021 06:40
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 24 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Stellar (3491)

Location:  Spain, Comunidad Valenciana
Member Since Contact Type Status
Sep 24, 2015 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: Stellar Bricks
BrickLink Discussions Moderator (?)
In Help, Teup writes:
  In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

Bricklink calls it "invoice", but it's actually really just a payment instruction.
You need to do your bookkeeping separately. Even if BL could do invoice numbering
for you, I still would advise against using it. Imagine you are selling something
outside of BL, or you sell of a pile of instruction booklets somewhere, or you
do some totally unrelated job for someone - you will want personal control over
your invoice numbering or you're going to end up with duplicate numbers.
You can use third party software for this, or an Excel template. Remember you
don't need to write invoices before payment (and technically you don't
even need to send them unless the customer asks).

You can have different invoice numbering systems fine, they just need to be sequential
inside them. BLXXXX, BOXXXX, LPXXXX
 Author: Teup View Messages Posted By Teup
 Posted: Oct 5, 2021 10:34
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 36 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

Teup (6595)

Location:  Netherlands, Utrecht
Member Since Contact Type Status
May 6, 2004 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store: BLOKJESKONING
In Help, Stellar writes:
  In Help, Teup writes:
  In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

Bricklink calls it "invoice", but it's actually really just a payment instruction.
You need to do your bookkeeping separately. Even if BL could do invoice numbering
for you, I still would advise against using it. Imagine you are selling something
outside of BL, or you sell of a pile of instruction booklets somewhere, or you
do some totally unrelated job for someone - you will want personal control over
your invoice numbering or you're going to end up with duplicate numbers.
You can use third party software for this, or an Excel template. Remember you
don't need to write invoices before payment (and technically you don't
even need to send them unless the customer asks).

You can have different invoice numbering systems fine, they just need to be sequential
inside them. BLXXXX, BOXXXX, LPXXXX

Really? I never heard about it. Now I'm reading about the rules and it's
actually a lot more complicated than I knew If I understand it all correctly,
it seems like you're allowed to add a prefix in front of the number as long
as you don't get overlap when you remove it (which you will if you have BL,
BO, etc) and that you're allowed to add the year in front of the number so
that (since the greatest amounts are in the front of the number) you never get
overlap as the year increases (you do get gaps but that's apparently fine).

Not sure though, the Dutch tax agency is surprisingly unclear about it.
 Author: SylvainLS View Messages Posted By SylvainLS
 Posted: Oct 5, 2021 12:28
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 23 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

SylvainLS (46)

Location:  France, Nouvelle-Aquitaine
Member Since Contact Type Status
Apr 25, 2014 Contact Member Seller
Buying Privileges - OKSelling Privileges - OK
Store Closed Store: BuyerOnly
BrickLink Discussions Moderator (?)
In Help, Teup writes:
  […]
  You can have different invoice numbering systems fine, they just need to be sequential
inside them. BLXXXX, BOXXXX, LPXXXX

Really? I never heard about it. Now I'm reading about the rules and it's
actually a lot more complicated than I knew If I understand it all correctly,
it seems like you're allowed to add a prefix in front of the number as long
as you don't get overlap when you remove it (which you will if you have BL,
BO, etc) and that you're allowed to add the year in front of the number so
that (since the greatest amounts are in the front of the number) you never get
overlap as the year increases (you do get gaps but that's apparently fine).

I always understood it the same way for France: you can add whatever you want
(date, prefix…) but there must be a straight & strict sequence, no missing number,
no duplicate.


  Not sure though, the Dutch tax agency is surprisingly unclear about it.

One thing to keep in mind when interpreting all those rules: they are all made
for paper & books with numbered pages.  You shan’t tear off a sheet, you have
to cross it out (write a line over it, leaving the content readable), and that
sort of things.

Forget all about computers and automated procedures, it’s the 15th century here


(I’m not saying our taxing overlords are retarded and don’t know about computers…
just that the rules are made for pen & paper.)
 Author: hpoort View Messages Posted By hpoort
 Posted: Oct 5, 2021 12:48
 Subject: Re: Is there a macro for auto numbering?
 Viewed: 26 times
 Topic: Help
Cancel Message
Cancel
Reply to Message
Reply
BrickLink
ID Card

hpoort (410)

Location:  Netherlands, Groningen
Member Since Contact Type Status
Oct 11, 2014 Contact Member Buyer
Buying Privileges - OK
In Help, Teup writes:
  In Help, Stellar writes:
  In Help, Teup writes:
  In Help, ArteP writes:
  Hi
I would like to have an auto numbering macro for my invoice number.
Befor automatic checkout I made these manually, but now I do not know how to
get there.🤔
Do you have a solution?

Best regards
Keld

Bricklink calls it "invoice", but it's actually really just a payment instruction.
You need to do your bookkeeping separately. Even if BL could do invoice numbering
for you, I still would advise against using it. Imagine you are selling something
outside of BL, or you sell of a pile of instruction booklets somewhere, or you
do some totally unrelated job for someone - you will want personal control over
your invoice numbering or you're going to end up with duplicate numbers.
You can use third party software for this, or an Excel template. Remember you
don't need to write invoices before payment (and technically you don't
even need to send them unless the customer asks).

You can have different invoice numbering systems fine, they just need to be sequential
inside them. BLXXXX, BOXXXX, LPXXXX

Really? I never heard about it. Now I'm reading about the rules and it's
actually a lot more complicated than I knew If I understand it all correctly,
it seems like you're allowed to add a prefix in front of the number as long
as you don't get overlap when you remove it (which you will if you have BL,
BO, etc) and that you're allowed to add the year in front of the number so
that (since the greatest amounts are in the front of the number) you never get
overlap as the year increases (you do get gaps but that's apparently fine).

Not sure though, the Dutch tax agency is surprisingly unclear about it.

Duplicate numbers are not allowed, but you are allowed to use multiple numbering
series:

[prerequisites for invoices:]
"een factuurnummer
Gebruik opeenvolgende nummers voor uw facturen, met 1 of meer reeksen. Elk factuurnummer
mag maar 1 keer voorkomen."
[https://www.belastingdienst.nl/wps/wcm/connect/bldcontentnl/belastingdienst/zakelijk/btw/administratie_bijhouden/facturen_maken/factuureisen/]

As long as you can show that all invoice numbers you issued are present (proof
of completeness) and unique, you are fine.

If you only sell on Bricklink, the Bricklink order numbers are fine as well since
they are guaranteed to be unique and you can argue each to be in its own series.