SAP Business One 8.82 PL04 Supplementary Code alwa...

I always find that the Supplementary Code exist such that I cannot add the Documents, for example, Sales Quotation, Sales Order, Sales Invoice. In the Document numbering Setup, I have tried the Period Type 'Annually', 'Monthly' and 'Permanent', however, the issue exists again and again. Could anyone help. Thanks very much.

Discussion moved from About SCN to SAP Business One Application

SAP Managed Tags:
SAP Business One

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (3)

Check SAP note 1675679 - CN_Error Message :Supplementary Code already exists

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Eric Mak,

Please refer SAP notes:

1622573 - CN_Supplementary Code in Document Numbering

Hope helpful.

Thanks & Regards,

Nagarajan

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Would you please provide the link of this SAP Note? Thanks very much.

Hi,

Please refer SAP notes:

Symptom

In SAP Business One, document number is a numeric value automatically
assigned by the application each time you create a document. Chinese customers
need a more complicated and bespoke document numbering system to provide
user-defined alphanumeric codes for their documents.

Solution

With SAP Business One 8.81 PL10, you are
able to customize and use a supplementary code for document numbering in Chinese
localization. The code can be configured to display date information, sequence
number, and fixed strings.

Supported document types include:

A/R invoice
A/P Invoice
A/R Credit Memo
A/P Credit Memo
A/R Down Payment
A/P Down Payment
A/R Reserve Invoice (Share the document numbering settings with A/R invoice)
A/P Reserve Invoice (Share the document numbering settings with A/P invoice)
Delivery
Return
Sales Order
Goods Receipt PO
Goods Return
Purchase Order
Sales Quotation
Incoming Payment
Deposit
Journal Entry
Outgoing payment
Goods Receipt
Goods Issue
Inventory Transfer
Landed Cost
Inventory Revaluation
Service Call
Production Order
Purchase Quotation

Prerequisite

You are working with SAP Business One Chinese localization and you have
updated to SAP Business One 8.81 PL10.
You have not selected the Permit More Than One Document Type per
Series checkbox in the Administration -> System
Initialization -> Company Details window.

After you update to SAP Business One 8.81 PL10, supplementary code appears in all the
supported documents with a SAP predefined format. To set up supplementary codes
that best cater to your business needs, follow the procedure below to customize
the document supplementary codes.

Setting Up Supplementary Codes

The definition for supplementary codes is document type specific. To define

the supplementary code for a particular document type, for example, A/R invoice,

proceed as follows:

From the SAP Business One Main Menu, choose
Administration -> System Initialization -> Document
Numbering.
In the Document Numbering – Setup window, double click the row of
A/R invoices.
The Series – A/R Invoices – Setup window appears, displaying the
supplementary code that is currently in use.
To update definition for the supplementary code, choose the link arrow
icon.
The Supplementary Code – Setup window appears.

To define the code format, do the following as appropriate:

Showing Date Information in the Code
To show date
information in the code, in the Code Format field, specify a variable
in the format of {d|***}.
Note:
- For all the supported
document types other than service call documents, the date information showed in
the supplementary code is taken from the Posting Date field in the
document.
- For a service call document, the date information is taken from
the Created On field in the
document.
Examples:
The table below
shows examples of supported string formats and corresponding output:

Variable Format	Output Examples
{d\|yy-mm }	June 5^th, 2011 -> 11-06 October 7^th, 2011 -> 11-10
{d\|yy-m}	June 5^th, 2011 -> 11-6 October 7^th, 2011 -> 11-10
{d\|yy-m-d}	June 5^th, 2011 -> 11-6-5 October 7^th, 2011 -> 11-10-7 December 20^th, 2011 -> 11-12-20
{d\|yyyy-mm}	June 5^th, 2011 -> 2011-06 October 7^th, 2011 -> 2011-10 December 20^th, 2011 -> 2011-12
{d\|yyyy-m}	June 5^th, 2011-> 2011-6 October 7^th, 2011 -> 2011-10 December 20^th, 2011 -> 2011-12
{d\|yyyy-m-d}	June 5^th, 2011-> 2011-6-5 October 7^th, 2011 -> 2011-10-7 December 20^th, 2011 -> 2011-12-20
{d\|yyyy-mm-dd}	June 5^th, 2011-> 2011-06-05 October 7^th, 2011 -> 2011-10-07 December 20^th, 2011 -> 2011-12-20
{d\|yyyy-m-dd}	June 5^th, 2011-> 2011-6-05 October 7^th, 2011 -> 2011-10-07 December 20^th, 2011 -> 2011-12-20
{d\|yyyy-w}	June 5^th, 2011-> 2011-w22 October 7^th, 2011 -> 2011-w40

Showing Sequence Number in the Code
To
show the document sequence number in the code, proceed as follows:
2. In the Code Format field, specify a variable in the format of {s|
  ***}.
  Examples:The table below shows examples of supported
  string formats and corresponding output:
  
  Variable Format Output Examples
  0000 25 -> 0025
  34567 -> 34567
  #### 25 -> 25
  2345 -> 2345
  34567 ->
  34567
3. The Supplementary Code – Setup window displays the current
  definition of the document sequence, including sequence period type, current
  period, and sequence number.
  Example:
  You are working
  with the supplementary code for A/R invoice. The Supplementary Code –
  Setup window displays the following information:
  - Period Type:
  Monthly
  - Year: 2011
  - Month: November
  - Sequence No.: 182
  This
  information shows that you are currently adopting monthly sequence for A/R
  invoices. The application will assign the sequence number of 182 to the next A/R
  invoice upon its creation that with a posting date within November 2011.
4. To update the sequence period type and the sequence number to start with,
  choose the Adjust Sequence button.
  You receive a message that
  “Updating the sequence may cause continuity and consistency issues of document
  supplementary codes. Do you want to continue?”
5. To continue, choose the Yes button.
  The Sequence
  Adjustment window appears. You are able to change the period type and the
  sequence number as necessary.
6. To change the sequence period type, select one of the following:
  -
  Annually
  - Monthly
  - Weekly
  - Permanent
  The application assigns
  sequence numbers to documents upon their creation consecutively based on the
  period you define. The sequence number automatically goes back to 1 after the
  defined period is finished.
  Note:
  If you
  define the Period Type as Permanent, the application numbers
  the documents consecutively without resetting the sequence number to 1
  periodically.
7. By default, from the very beginning of the defined period, each sequence
  starts with 1. You can change the number if necessary. To change a sequence
  number for periods other than the current period, first select the period you
  want to work with, and then change the sequence
  number.
  Example:
  You define the sequence
  period for A/R invoices as Monthly. On November 15^th, you
  create an A/R invoice with the posting date of October 20^th. The
  supplementary code displays the sequence number as 100. This is the last A/R
  invoice you have posted to October in the system.
  You open the Sequence
  Adjustment window, and it displays the current month of November
  and the sequence number to be assigned to the next A/R invoice with a posting
  date in November.
  To view or change the sequence for A/R invoices posted to
  October, from the Month dropdown list, choose October. The
  Sequence No. field displays 101, the sequence number to be assigned to
  the next A/R invoice posted to November.
  You can change the sequence number
  if necessary.
Showing a Fixed String in the Code
To
show a fixed string in the code, in the Code Format field, specify the
string text out of the {}
area.
Examples:
For an A/R invoice, the
posting date is September 20^th, 2010 and the current sequence number
is 182. The table below shows examples of supported string formats and
corresponding output:

String Format Output
INV-{d|yyyy-mm}-{s|0000}-Ex INV-2010-07-0182-Ex
INV-{d|yyyy-mm-dd}-{s|####}-Ex INV-2010-07-20-182-Ex

To confirm your changes and go back to the Supplementary Code –
Setup window, choose
Update.
Note:
You can
only change one sequence at a time. The change takes effect after you confirm
your changes in the Supplementary Code – Setup window.
Do one of the following:
- To confirm your changes both for the code format and the sequence,
  choose Update.
- To discard your changes for the code format and the sequence in the
  Sequence Adjustment window, choose Cancel.

SAP intends to provide a patch or patches in order to solve the problem
described.

The section Reference to Related Notes below will list the
specific patches once they become available.

The corresponding Info file of the patches in SAP Service
Marketplace will also show the SAP Note number.

Please note that these references can only be set at patch release date.

SAP will deliver patches only for selected releases at its own discretion,
based on the business impact and the complexity of the
implementation.

Other terms

SAP Business One, 8.81, patch level 10, document number, document numbering,
document No., sequence, code, supplementary code

Thanks very much. I think the solution which you have given is great!

By the way, I found that in SPA Business Ones 9.0, the Suppl Code can be deactivated without using the setting which you have provided.

Hi Eric Mak,

Then you need to upgrade to 9.0 version.

Please close this thread if you got the answers.

Thanks & Regards,

Nagarajan

Hi,

How to switch off the functionality?

Regards,

Hari

For those who have used china localization with supplementary code, what is the purpose of this. I understand it works like a counter or document number which automatically run according to the posting period. However I don't see this code in the journal entry created for this transaction. The link in SAP is still using the original document number.

For eg:

A/R invoice original document number: 1001

A/R invoice supplementary code: 1501010

In the incoming payment screen or journal entry created, I only see the document number 1001.

Regards

Yvaine

Hi,

Could you post your Document numbering Setup screenshot?

Thanks,

Gordon

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

This is my current setting. Thanks very much.

What is your B1 localization? I can't find this setting from another 8.82 db. Is this by an add-on?

My localization is PRC China. Thanks very much.

You may post it on the Chinese forum to see if any other users can help.

Thanks Gordon. But one thing I would like to share, before that my setting in the Document numbering is 'Monthly' and the duplicate error occurred everyday, after I changed to 'Permanent', the error occurred once a week. Thanks very much.

Hi Eric,

Could you provide the code on how you get the next document number to post?

Are you using the "GetNextSerialNumber" object?

Thanks,

Vijay

Ask a Question

Top Q&A Solution Author

User

Count