Golden Tax Invoice for M3 BE Order Invoices - Automatic Process

Overview

Order and invoice information for M3 Business Engine order invoices required by the Golden Tax System can be created automatically and adjusted if requested. That is, the electronic message for issued sales invoices (Golden Tax invoice number to be uploaded and status set) and confirmed rejected invoices (status to be set). After that the M3 BE order invoices are ready for transfer to the M3 BE Accounts Receivable Ledger (ARL).

  • Creating Golden Tax invoice information

    'Golden Tax Invoice. Create' (GTCN20) allows you to automatically create the order and invoice information required by the Golden Tax System.

    The generated information can then be displayed and reviewed using 'Golden Tax Invoice. Display/Enter' (GTCN10).

  • Reviewing Golden Tax invoice information

    When the creation of Golden Tax information is complete, you can view and modify the M3 BE order invoices using 'Golden Tax Invoice. Display/Enter' (GTCN10).

    • M3 BE order invoices created without errors detected receive status 20-'Approved, ready for external transfer', and are ready for transfer to the Golden Tax System using 'Golden Tax Invoice. Transfer' (GTCN30).
    • M3 BE order invoices where an error was detected (for example if customer address information is missing) receive status 11-'Not approved, lines with error exist' or 12-'Not approved, total amount differ' and must be corrected in (GTCN10) before the external transfer to the Golden Tax System can be done.
  • Transfer information to the Golden Tax System

    All M3 BE order invoices that are approved, and have the status 20-'Approved, ready for external transfer', can be automatically transferred to the Golden Tax System by an electronic message.

    A separate electronic message can be automatically created for rejected invoices, with status 21-'Rejected, ready for external transfer' or 22-'Rejected after transfer, ready for external transfer'.

  • Receive information from the Golden Tax System

    The Golden Tax invoice numbers created in the Golden Tax System can be uploaded to M3 BE using an electronic message for sales invoices. If the 'Extended Golden Tax invoice number' field in (CRCN01) is enabled, the value updates the 'Extended Golden Tax invoice number' whereas the 'Golden Tax invoice number' is automatically updated by M3 Business Engine. The status is changed to 90-'Approved, ready for transfer to ARL'.

    For invoices that are rejected, the status is changed to 92-'Rejected, ready for transfer to ARL' or 98-'Rejected after transfer, canceled in 'Golden Tax System' depending on whether the invoice was rejected before or after transfer to M3 BE Accounts Receivable Ledger (ARL).

  • Transfer M3 BE order invoices with Golden Tax information to M3 BE Accounts Receivable Ledger (ARL)

    You can transfer the invoices to M3 BE Finance using the M3 BE standard programs for order invoice post-processing. Only invoices without VAT, invoices in foreign currency (if the Golden Tax System is set to 1 or 2) and Golden Tax invoices with status 90='Approved, ready for transfer to ARL' or 92='Rejected, ready for transfer to ARL' are included.

    The M3 BE invoice record (transaction code 10) is split during the transfer to (GLS040) according to the information in the (XCNGTD) table, and the M3 BE invoice number is replaced with the Golden Tax invoice number. If the 'Extended Golden Tax invoice number' field in (CRCN01) is enabled, the extended Golden Tax invoice number is stored as a parallel invoice number in Accounts Receivable.

    The M3 BE invoice number is stored as AR additional information (FSLEDX table) using information category 228. This information category is available in M3 BE as default, giving the option to inquire or print invoice copies from the Accounts Receivable inquiry programs (for example (ARS200)).

  • Exclude M3 BE order invoice from the Golden Tax invoice process

    M3 BE order invoices with VAT that should be excluded from the Golden Tax invoice process are selected in the order invoice inquiry programs in the same way as described above. In 'Golden Tax Invoice. Display/Enter' (GTCN10), the M3 BE order invoice is excluded using a function key that creates a transaction in the (XCNGTH) table with the status 91-'Excluded, ready for transfer to ARL'.

  • Transfer of M3 BE order invoices excluded from the Golden Tax invoice process

    The M3 BE order invoices excluded from the Golden Tax invoice process are included in the post-process transfer, even if VAT is posted for the invoice.

Creating Golden Tax invoice information in (GTCN20)

Golden Tax information is automatically created using 'Golden Tax Invoice. Create' (GTCN20) including order and invoice information required by the Golden Tax System for M3 BE order invoices that are invoiced but not yet transferred to the M3 BE Accounts Receivable Ledger (ARL).

Order invoice types handled in this process:

  • Customer order invoice
  • Service order invoice
  • Project order invoice
  • Maintenance order invoice

Service order invoices include these invoice types:

  • Service order (SO)
  • Service agreement (SA)
  • Rental agreement (ST)
  • Leasing agreement (LT)
Note: For project and maintenance order invoices, only the M3 BE invoice header is created in the 'Golden Tax Invoice – Header' (XCNGTH) table. The invoice must then be completed by adding details and lines in 'Golden Tax Invoice. Display/Enter' (GTCN10) before the transfer to the Golden Tax System can be done.

The program can only be used when a parameter in 'Golden Tax Invoice – Settings' (CRCN01) has been defined for the division and 'Golden Tax System' is set to 2-'Automatic process' or 4-'Manual process for invoices in foreign currency and automatic process for invoices in local currency'.

At least one of the order invoice types must be selected. Selection of from/to invoice date is mandatory while the rest of the selection fields are optional.

Additionally, a 'Reviewer' must be specified. This is the ID of the person responsible for the Golden Tax invoice handling. The reviewer is stored on each M3 BE order invoice detail (XCNGTD table) created and is transferred to the Golden Tax System.

The check box 'Exclude zero lines' should be selected to exclude lines with an amount of zero when creating the Golden Tax invoice. The line amount is checked to see if it is zero, after any line charges have been added, header charges distributed, discount deducted and amount for advance invoices distributed.

Golden Tax invoice information – header (XCNGTH table)

The Golden Tax invoice header is created for each order invoice using the information from the tables 'M3 BE invoice header' and 'Accounting'.

Only order invoices in local currency, with VAT calculated, and where the invoice status in the order area is set to '90' (accounting entries created but not yet transferred to M3 BE/FIN(ARL)), are included.

The Golden Tax invoice header (XCNGTH table) holds information about the invoice number, payer, invoice date, invoice amount, VAT amount and the number of detail records created. Each record is marked with Golden Tax version 2-'Automatic process' or 4-'Manual process for invoices in foreign currency and automatic process for invoices in local currency', indicating that the invoice is processed using the Golden Tax System for automatic transfer.

This table shows the invoice status codes that are used and updated for each invoice header:

Status Description
11-Not approved, lines with error exist Status if an error was found. The invoice must then be corrected in 'Golden Tax Invoice. Display/Enter' (GTCN10) before the external transfer to the Golden Tax System can be done.
12-Not approved, total amount differ

Status if a difference in the amounts was found between the invoice header and the details created. The invoice must then be corrected in (GTCN10) before the external transfer to the Golden Tax System can be done.

Note: Project and maintenance order invoices receive this status as no details or lines are created.
20-Approved, ready for external transfer Status if no errors or deviations are found between the invoice header and the details created. The invoice is then ready for transfer to the Golden Tax System using 'Golden Tax Invoice. Transfer' (GTCN30).

Golden Tax invoice information – details (XCNGTD table)

The Golden Tax invoice details are created based on the line information (XCNGTL table). Depending on whether an amount limit is defined or not in 'Golden Tax Invoice – Settings' (CRCN01), one or several detail records are created.

  • When amount limit is not used (set to zero/blank)

    One detail record is created per M3 BE order invoice with the total net amount and total VAT amount of all lines. The number of invoice lines (XCNGTL table) is stored for the record.

  • When amount limit is used

    The invoice lines are summed up and one detail record is created if the amount limit is not exceeded. When the amount limit has been reached, a new detail is created, and so on.

    For invoice lines where the total line amount (net amount + VAT amount) exceeds the limit, a detail record is created with status 01='Not approved, amount over limit'. The invoice detail must then be manually split using 'Golden Tax Invoice. Display/Enter' (GTCN10) before the external transfer to the Golden Tax System can be done.

The number of invoice lines (XCNGTL table) per detail record is stored for each detail record.

This table shows detail status codes that are used and updated for each invoice detail record. For status 01 to 09 the invoice must be corrected in (GTCN10) before the external transfer to the Golden Tax System can be done.

Status Description
01-Not approved, amount over limit

Status if the invoice amount for the line exceeds the amount limit defined in 'Golden Tax Invoice - Settings' (CRCN01).

The invoice must be manually split in (GTCN10) before the external transfer to the Golden Tax System can be done.

04-Not approved, amount is missing Status if the invoice amount of the detail line (XCNGTD table) is zero. The invoice must be corrected in (GTCN10).
06-Not approved, invoice lines with error exist Status if lines with an error are found. The invoice must be corrected in (GTCN10).
07-Not approved, invoice lines missing Status if no lines are found. The invoice must be corrected in (GTCN10).
08-Not approved, line amount differs Status if the invoice amount or VAT amount between the details and the lines differs. The invoice must be corrected in (GTCN10).
09-Not approved, incorrect invoice details

Status if errors in the details are found. For example, customer address information is missing or information concerning original VAT type and invoice number are missing in comment field for credit note.

The invoice must be corrected in (GTCN10).

20-Approved, ready for external transfer Status if no error or deviation is found between the invoice details and the lines created.

Comment concerning credit notes/invoices:

Credit notes – in China called negative value invoices – must include the original VAT invoice type and the original invoice number.

This information is automatically added when the Golden Tax information is created in 'Golden Tax Invoice. Create' (GTCN20). The information is added to the comment field of the invoice details for credit invoices created using the functionality in M3 Business Engine for creating corrective invoices (for example (OIS380)).

This table shows the formats the information is created with (note that blanks are not removed):

Positions Description
1-18 Header description for Original VAT invoice type from (CRCN01/E).
19-28 Original VAT invoice type from the original invoice (field 'VAT invoice type' on (GTCN11/E)).
29-34 Header description for Original invoice number from (CRCN01/E).
35-42 Original invoice number from the original invoice ('Golden Tax invoice number' field on (GTCN11/E)).

For credit invoices that have been created in another way, or where the original invoice has been split due to the amount limit, the information must be manually added on the (GTCN11/E) panel. These invoices receive detail status 09='Not approved, incorrect invoice details' and must be adjusted before the credit invoice can be sent to the Golden Tax System.

Golden Tax invoice lines (XCNGTL table)

The Golden Tax invoice line is created depending on the type of order invoice.

This table shows common information created for all types of order invoices:

Field Description
Item name The item name is retrieved from 'Item. Enter Names/Language' (MMS030) if it is defined for the language code specified in 'Golden Tax Invoice - Settings' (CRCN01). If no record is found, the item name is retrieved from 'Item. Open' (MMS001).
Specific of item The specific of item is retrieved from (MMS001).
Unit price

The unit price is calculated per invoice line (XCNGTL table) as follows:

Customer defined as 'VAT included' (not valid for SO invoices): Total net amount + total VAT amount / quantity

Customer defined as 'VAT excluded': Total net amount / quantity

The type of price used (including/excluding VAT) is stored for each invoice line record.

Information types included for customer order invoices (field IVTP)

  • Normal customer order invoices

    For normal customer order invoices, one invoice line record (XCNGTL table) is created per invoice line number (PONR field) and suffix (POSX field) for the information type. This table shows a description per information type:

    Information type Description
    31-Gross total per order line

    Net amount and VAT amount

    VAT code and item number

    This table shows information types that are deducted from the line record created (XCNGTL table):

    Information type Description
    32-Discount per order line

    Net amount and VAT amount

    Discount amount and discount VAT amount

    Discount percentage (only for the first line with discount transaction)

    33-Offset amount to order total discount when total price is used

    Net amount and VAT amount

    Discount amount and discount VAT amount

    34-Order total discount distributed per order line

    Net amount and VAT amount

    Discount amount and discount VAT amount

    If several discount records are found for the invoice line, a flag is set so you can control the information in 'Golden Tax Invoice. Display/Enter' (GTCN10) before the transfer to the Golden Tax System is done.

    This table shows the information types that are added to the line record created (XCNGTL table):

    Information type Description
    67-External item charge Net amount, VAT amount line charge amount, and line charge VAT amount
    If a different VAT code has been used for the line charge compared to the invoice line, a 'Line charge – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

    This table shows the information types that are summed up and distributed to each line record created (XCNGTL table):

    Information type Description
    60-External charge per delivery and charge ID

    Net amount and VAT amount

    Header charge amount and header charge VAT amount

    61-Service charge per delivery

    Net amount and VAT amount

    Header charge amount and header charge VAT amount

    70-Rounding-off per delivery

    Net amount and VAT amount

    Header charge amount and header charge VAT amount

    The 'Header charge – distribution rate' field displays the percentage used for the line.

    If a different VAT code is used on the header charge compared to the invoice line, a 'Header charge – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

  • Advance invoices

    For advance invoice customer orders, one invoice line record (XCNGTL table) is created per order line found using the information type. This table shows a description per information type:

    Information type Description
    50-Advance invoiced amount per date and order

    Net amount

    VAT amount is retrieved from information type 41-'Tax amount per advance invoice'

    VAT code and item number

    The 'Advance invoice – distribution rate' field displays the percentage used for the line.

    If a different VAT code is used for the advance invoice compared to the order line, the 'Advance invoice – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

  • Normal customer order invoices previously with an advance invoice

    For normal customer order invoices previously with an advance invoice amount, some information types are deducted from the line record created for information type 31='Gross total per order line'. This table shows which information types:

    Information type Description
    51-Settled amount (previously advance invoiced)

    Net amount

    VAT amount is retrieved from information type 42-'Settled Tax previously invoiced in advance'

    The 'Advance invoice – distribution rate' field displays the percentage used for the line.

    If a different VAT code is used for the advance invoice compared to the order line, the 'Advance invoice – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

Information types included for service order invoices

For service order invoices, one invoice line record (XCNGTL table) is created per invoice line number (PONR field) for the information type shown in this table:

Information type Description
31-Gross total per order line

Net amount and VAT amount

VAT code and item number

If several information type 31 records exist with the same line number (PONR), the information is summed, and only one invoice line record is created (XCNGTL table).

This table shows the information types that are deducted from the line record created (XCNGTL table):

Information type Description
32-Discount per order line

Net amount and VAT amount

Discount amount and discount VAT amount

Discount percentage (only for the first line discount transaction found)

36-Fixed price

Net amount and VAT amount

Discount amount and discount VAT amount

If several discount records are found for the invoice line, a 'Discount status' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

This table shows information types that are added to the line record created (XCNGTL table):

Information type Description
67-External item charge

Net amount and VAT amount

Line charge amount and line charge VAT amount

If a different VAT code has been used for the line charge compared to the invoice line, a 'Line charge – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

This table shows the information types that are summed up and distributed to each line record created (XCNGTL table):

Information type Description
60-External charge per delivery and charge ID

Net amount and VAT amount

Header charge amount and header charge VAT amount

61-Service charge per delivery

Net amount and VAT amount

Header charge amount and header charge VAT amount

70-Rounding-off per delivery

Net amount and VAT amount

Header charge amount and header charge VAT amount

The 'Header charge – distribution rate' field displays the percentage used for the line.

If a different VAT code has been used for the line charge compared to the invoice line, a 'Header charge – status of VAT' flag is set so you can verify the information in (GTCN10) before the transfer to the Golden Tax System is done.

Item line status

This table shows the item line status codes that are used and updated for each invoice line:

Status Description
00-Approved, line information correct Status if no errors are found.
01-Not approved, amount over limit Status if the invoice amount for the line exceeds the amount limit defined in (CRCN01). The invoice line must be manually split using (GTCN10) before the external transfer to the Golden Tax System can be done.
06- Not approved, invoice lines with error exist

Status if an error is found. The invoice line must be corrected using (GTCN10) before the external transfer to the Golden Tax System can be done.

The status is set if one of these errors are found:

  • Item name (XITN field) is missing
  • Specific of item (XSPE field) is missing
  • Unit description (XSPD field) is missing
  • Net amount (XNAM field) is zero
  • VAT amount (XVTA field) is zero
  • Quantity (XQTY field) is zero
  • VAT rate 1 (VTP1 field) is zero
  • VAT type (VTP2 field) is blank
  • Unit price (XUPR field) is zero
  • Discount status (XDST field) set to 1 (several discount transactions found)
  • Line charges – status of VAT (XLCS field) set to 1 (VAT code differs)
  • Header charges – status of VAT (XLCS) set to 1 (VAT code differs)
  • Advance invoice – status of VAT (XAIS) set to 1 (VAT code differs)

Review Golden Tax invoice (GTCN10)

This function allows you to work with or display order invoices already included in the Golden Tax process, meaning that one or several detail records have been created from the order invoice areas.

These invoice types are handled in the program:

  • 1-Customer order invoice
  • 2-Service order invoice
  • 3-Project order invoice
  • 4-Maintenance order invoice

Display or enter Golden Tax invoice in (GTCN10/B)

The information displayed on (GTCN10/B) is retrieved from the 'Golden Tax – Order Invoice Header' XCNGTH table.

To control if the order invoice should be transferred to the Golden Tax System or the M3 BE Accounts Receivable (ARL), each order invoice is updated with an invoice status. This table shows status and description:

Status Description
00-Not approved, preliminary Status set during creation in (GTCN20).
11-Not approved, lines with error exist Status set during automatic creation in (GTCN20) if an error is found or when an invoice is released on the (GTCN11/B) panel.
12-Not approved, total amount differ Status set during automatic creation in (GTCN20) or when an invoice is approved on the (GTCN11/B) panel if a difference was found between the invoice header and the details.
20-Approved, ready for external transfer Status set during automatic creation in (GTCN20) or when an invoice is approved on the (GTCN11/B) panel if no error or difference was found between the invoice header and the details.
21-Rejected, ready for external transfer Status when you reject an invoice with status 90 on panel (GTCN11/B) by using F21='Reject invoice'.
22-Rejected after transfer, ready for external transfer Status when you reject an invoice with status 95 on the (GTCN11/B) panel by using F21='Reject invoice'.
30-Approved, selected for external transfer

Status when a proposal for transfer of sales invoices to the Golden Tax System is created in (GTCN30).

Additionally, the invoice header is updated with a batch number and a transfer date.

31-Rejected, selected for external transfer

Status when a proposal for transfer of rejected invoices to the Golden Tax System is created in (GTCN30).

Additionally, the invoice header is updated with a batch number and a transfer date.

32-Rejected after transfer, selected for external transfer

Status when a proposal for transfer of rejected invoices to the Golden Tax System is created in (GTCN30).

Additionally, the invoice header is updated with a batch number and a transfer date.

40-Approved, transferred to the Golden Tax System Status when a proposal for transfer of sales invoices to the Golden Tax System is confirmed in (GTCN30).
41-Rejected, transferred to the Golden Tax System Status when a proposal for transfer of rejected invoices to the Golden Tax System is confirmed in (GTCN30).
42-Rejected after transfer, transferred to the Golden Tax System Status when a proposal for transfer of rejected invoices to the Golden Tax System is confirmed in (GTCN30).
90-Approved, ready for transfer to ARL

Status set with MI program GTCN10MI when the text file for issued invoices (type – normal invoice) from the Golden Tax System is received through Infor Enterprise Collaborator (IEC).

Simultaneously, each invoice detail (XCNGTD table) is updated with the Golden Tax invoice number received.

91-Excluded, ready for transfer to ARL Status set on the (GTCN11/B) panel when you select F20='Exclude invoice' for an invoice that must not be part of the Golden Tax invoice handling.
92-Rejected, ready for transfer to ARL Status set with MI program GTCN10MI when the text file for issued invoices (type – rejected invoice) from the Golden Tax System is received through IEC.
95-Transferred to ARL Status set during the post-process transfer to ARL for invoices that are part of the Golden Tax invoice handling and therefore transferred to Accounts Receivable (ARL) using the Golden Tax invoice numbers received from the Golden Tax System.
96-Excluded, transferred to ARL Status set during the post-process transfer to ARL for invoices that have been excluded and therefore transferred to Accounts Receivable (ARL) using the original invoice number.
97-Rejected, transferred to ARL Status set during the post-process transfer to ARL for invoices that have been rejected and therefore transferred to the Accounts Receivable (ARL) using the original invoice number.
98-Rejected after transfer, cancelled in Golden Tax System Status set with MI program GTCN10MI when the text file for issued invoices (type – rejected invoice) from the Golden Tax System is received through IEC for invoices that were already transferred to Accounts Receivable (ARL) and must therefore be manually handled.

Golden Tax invoice details in (GTCN11/B)

The B-panel for 'Golden Tax Invoice. Open Details' (GTCN11) can be called from an order invoice inquiry program (for example (OIS350)), or from panel (GTCN10/B), for Golden Tax invoices created using the automatic process.

If an error is found during automatic creation of the information, you can change existing transactions or add new transactions using options create or copy.

Note that this is only allowed if the invoice header status is set to 11 or 12.

If you want to change the information for an already approved invoice (status 20), the invoice must first be released with F17='Release invoice'.

When all changes have been made, the invoice must be approved with F16='Approve invoice' to receive invoice status 20. The information displayed is retrieved from the XCNGTD table.

To verify that the Golden Tax information is correct and if the invoice can be transferred or not, each detail line is updated with a detail status. This table shows status and description:

Status Description
00-Not approved, preliminary Status set during creation in (GTCN20).
01-Not approved, amount over limit Status set during automatic creation in (GTCN20), or when an invoice is approved on the (GTCN12/B) panel, if the invoice amount for the line exceeds the amount limit defined in the parameter in 'Golden Tax Invoice - Settings' (CRCN01).
04-Not approved, amount is missing Status set during automatic creation in (GTCN20), or when an invoice is approved on the (GTCN12/B) panel, if the amount of the detail line (XCNGTD table) is zero.
06-Not approved, invoice lines with error exist Status set during automatic creation in (GTCN20), or when an invoice is approved on the (GTCN12/B) panel, if lines with errors are found.
07-Not approved, invoice lines missing Status set during automatic creation in (GTCN20) when you enter a new detail line on the (GTCN11/B) panel, or approve an invoice on the (GTCN12/B) panel, if no lines are found.
08-Not approved, line amount differs Status set during automatic creation in (GTCN20), or when an invoice is approved on the (GTCN12/B) panel, if the amounts differ between the details and the lines.
09-Not approved, incorrect invoice details Status set during automatic creation in (GTCN20), or when an invoice is approved on the (GTCN12/B) panel, if errors in the details are found. For example, if customer address information is missing, or information concerning original VAT type and invoice number is missing, in the comment field for the credit note.

This table shows the available function keys:

Function key Description
F16='Approve - Invoice details'

Function key to control the invoice lines, outstanding amount, and update the invoice status.

This key can only be used if the invoice status is 11 or 12 to approve the invoice for transfer to the Golden Tax System.

F17='Release - Invoice details'

Function key to release invoices (status set to 11) already approved so manual changes can be made. This key can only be used if the invoice status is one of these values:

  • 20 - to allow change of details before transfer to the Golden Tax System.
  • 30 - to allow change of details before transfer to the Golden Tax System. Note that the invoice is removed from the batch where it was selected (batch number and transfer date removed).
  • 92 - to transfer a rejected invoice to the Golden Tax System to receive a new Golden Tax invoice (batch number and transfer date removed).
F18='Delete - Golden Tax information'

Function key to delete Golden Tax information for an invoice. This key can only be used if the invoice status is one of these values:

  • 11, 12, 20, or 91 - to remove all Golden Tax invoice information for an invoice.
  • 30 - to remove all Golden Tax invoice information for an invoice. Note that the invoice is also removed from the batch where it is selected.
F20='Exclude - Invoice'

Function key to exclude an invoice from Golden Tax handling. This key can only be used if the invoice status is one of these values:

  • 11, 12 or 20 - to exclude an invoice from Golden Tax handling.
  • 30 - to exclude an invoice from Golden Tax handling. Note that the invoice is also removed from the batch where it is selected.
F21='Reject - Invoice'

Function key to reject an invoice that has already been sent to the Golden Tax System. The original Golden Tax invoice number and transfer date are moved to new fields to keep the information, and a reject date is set on the invoice (see (GTCN11/E) panel).

The function key can only be used if the invoice status is one of these values:

  • 90 - to reject the Golden Tax invoice number received from the Golden Tax System but where the invoice has not yet been transferred to Accounts Receivable (ARL). The status is set to 21 and the invoice is ready for transfer to the Golden Tax System to cancel the invoice number.
  • 95 - to reject the Golden Tax invoice number received from the Golden Tax System but where the invoice has already been transferred to Accounts Receivable (ARL). The status is set to 22 and the invoice is ready for transfer to the Golden Tax System to cancel the invoice number.

Golden Tax invoice details in (GTCN11/E)

On this panel, the details for one M3 BE order detail invoice is displayed. Depending on the status of the invoice, you can change the invoice and VAT amount, change the reviewer and add a comment.

This table shows a description of some of the fields on the panel:

Field Description
Golden Tax inv no Invoice number created in the external Golden Tax System. The information is updated when the text file for issued invoices that was created in the Golden Tax System, is uploaded to IEC.
Transfer date Indicates the date when the Golden Tax information for this invoice was selected for transfer to the Golden Tax System in 'Golden Tax Invoice. Transfer' (GTCN30).
VAT invoice type Indicates the China VAT invoice type that is a VAT category for business scope of application in mainland China. The information is updated when the text file for issued invoices that was created in the Golden Tax System, is uploaded to IEC.
Comment

Indicates an optional user comment. Any comment specified here is included in the text file with Golden Tax information that is created when confirming an invoice batch proposal in (GTCN30).

Note Credit notes – in China called negative value invoices – must include the original VAT invoice type and the original invoice number. If these credit invoices are created using the functionality in M3 Business Engine for creating corrective invoices, they are automatically updated with these two values when you generate Golden Tax information in (GTCN20).

For negative invoice totals when the detail status is set to 09-'Not approved, incorrect invoice details', a warning message is displayed at Enter/Next in the panel to inform you that you must make sure that the invoice details in the comment field are complete.

Golden Tax invoice lines in (GTCN12/B)

On the B-panel of 'Golden Tax Invoice. Open Lines' (GTCN12), all order or invoice lines connected to a detail record are displayed.

If an error is found during automatic creation of the information, you can change existing transactions or add new transactions, using the options create or copy. Note that this is only allowed when the M3 BE invoice detail status is between status 01 and 09 (inclusively).

If you want to change the information for an already approved invoice detail (status 20), the invoice and details must first be released with F17='Release invoice' on (GTCN11/B) and (GTCN12/B).

When all changes have been made, you must approve the invoice with F16='Approve invoice' to set the order to status 20.

The information displayed is retrieved from the XCNGTL table.

To verify that the Golden Tax information is correct and if the M3 BE invoice can be transferred or not, each detail line is updated with an item line status. This table shows the status and description:

Item line status Description
00-Approved, line information correct Status set during automatic creation in (GTCN20) if no errors were found or on (GTCN12/E) when all errors have been corrected.
01-Not approved, amount over limit Status set during automatic creation in (GTCN20) if the invoice amount for the line exceeds the amount limit defined in (CRCN01).
06-Not approved, invoice lines with error exist Status set during automatic creation in (GTCN20) if lines with errors are found.

This table shows the available function keys:

Function key Description
F16='Approve – Invoice details'

Function key to control the invoice lines, outstanding amount and update the invoice status.

This key is only allowed if the invoice status is 11 or 12 to approve the invoice for transfer to the Golden Tax System.

F17='Release - Invoice details'

Function key to release invoices (status set to 06) already approved so manual changes can be made.

This key can only be used if the invoice status is 20, to allow change of item lines before transfer to the Golden Tax System.

Note: Credit notes – in China called negative value invoices – must include the original VAT invoice type and the original invoice number.

If the invoice total is negative, a warning message is displayed to inform that the invoice details in the comment field must be complete.

  • Click OK to continue the approval, status is set to 20-'Approved, ready for external transfer'.
  • Click Cancel to stop the approval, status is set to 09-'Not approved, incorrect invoice details'.

Golden Tax invoice lines in (GTCN12/E)

On the E-panel, all the details for an order/invoice lines are displayed. If there are errors (for example, mandatory information for the Golden Tax System has not been defined) a message is displayed showing what needs to be added or changed before the invoice line can be approved.

Note that no automatic calculation is done on the panel, which means that all relevant amounts in the detail section must be manually verified or modified.

When you press Enter, the line amount is recalculated as the total of the specified net amount and VAT amount. The line amount is used in the program to verify that the total amount of the order invoice has been distributed to all details and lines.

This table shows a description of some of the fields on the panel:

Field Description
Net amount Sales net amount for the line including any line charges or header charges (indicated on the panel) added and/or any discount (indicated on the panel) deducted. The amount stored is always excluding VAT.
VAT amount VAT amount for the line including VAT for any line charges or header charges (indicated on the panel) added and/or VAT amount for any discount (indicated on the panel) deducted.
VAT type Indicates the VAT type defined by the Tax bureau in China. The VAT type is automatically retrieved from (CRCN03) when the Golden Tax information is created in (GTCN20).
Unit price

Unit price calculated during the automatic creation of the information. The calculation depends on whether or not VAT is included in the sales price for the customer (setting on CRS610/G) as indicated in the field next to the unit price.

If VAT is included, the unit price is calculated as: net amount + VAT amount / quantity

If VAT is excluded, the unit price is calculated as: net amount / quantity

Discount status If several discount transactions are connected to the invoice line, a flag is set so you can verify and adjust the discount rate. The flag must be removed to approve the line.
Line charge status If a different VAT code is found compared to the item line, a flag is set so you can verify and adjust the VAT code or rate. The flag must be removed to approve the line.
Header charge status If a different VAT code is found compared to the item line, a flag is set so you can verify and adjust the VAT code or rate. The flag must be removed to approve the line.
Header charges All header and service charges found for an invoice are summed up (including invoice rounding) and distributed to each invoice line. The distribution rate used is displayed after the header charge amount field.
Adv invoice rate

For an advance invoice the item lines are created using the order line values. The advance invoice amount is distributed to the lines using a distribution rate.

A distribution rate is also used when the advance invoiced amount is settled on the final invoice.

Adv invoice status If a different VAT code is found for the advance invoice compared to the order or invoice line, a flag is set so you can verify and adjust the VAT code or rate. The flag must be removed to approve the line.

Display of order invoices in (OIS350), (SOS350), (POS350) and (COS350)

The programs 'Golden Tax Invoice. Create' (GTCN20) and 'Golden Tax Invoice. Display/Enter' (GTCN10) can be opened from the display programs for order invoices:

  • Customer order invoices (OIS350)
  • Service order invoices (SOS350)
  • Project order invoices (POS350)
  • Maintenance order invoices (COS350)

Which program and panel that are opened when you select an invoice with option 80='Add Golden Tax Invoice Number' depends on the process used when the Golden Tax Invoice information was created, or the process currently set in (CRCN01):

  • Golden Tax invoice information exists:

    Created using manual process: The (GTCN10/E) panel is opened.

    Created using automatic process: The (GTCN11/B) panel is opened.

  • Golden Tax invoice information does not exist:

    Manual process selected in (CRCN01): The (GTCN10/E) panel is opened.

    Automatic process selected in (CRCN01): The (GTCN20/E) panel is opened to create the information automatically.

Transfer of information to the Golden Tax System in (GTCN30)

This program enables you to automatically select and transfer Golden Tax information for order invoices to the Golden Tax System.

Two types of transfers are handled:

  • Sales information/invoices (file ID SJJK0101)

    Order invoices to be sent to the Golden Tax System for invoice printout and to retrieve a Golden Tax invoice number. Included are M3 BE order invoices with Golden Tax invoice status 20 (XCNGTH table).

  • Rejected information/invoices (file ID SJJK0102)

    Order invoices with a Golden Tax invoice number already assigned that for any reason must be cancelled at the Golden Tax System. Included are M3 BE order invoices with Golden Tax invoice status 21 or 22 (XCNGTH table).

The program can only be used when a parameter in 'Golden Tax Invoice – Settings' (CRCN01) has been defined for the division, and 'Golden Tax system' is set to 2-'Automatic process' or 4-'Manual process for invoices in foreign currency, and automatic process for invoices in local currency'.

Follow these steps:

  1. Create a batch proposal for the transfer to the Golden Tax System. As described above two types of transfers are available:

    • Sales information/invoices

      The selected order invoices are updated with a batch number automatically retrieved from (CRCN01) and the transfer date set (see (GTCN30/E)).

      The status of the order invoices is changed from 20 to 30 to indicate that the invoices are now selected for transfer.

    • Rejected information/invoices

      The selected order invoices are updated with a batch number automatically retrieved from (CRCN01) and the transfer date set (See (GTCN30/E)).

      The status of the order invoices is changed from 21 to 31, or from 22 to 32, to indicate that the invoices are now selected for transfer.

  2. After the batch proposal has been reviewed and requested information has been changed, the next step is to transfer to the Golden Tax System.

    • Sales information/invoices

      The status of the order invoices is changed from 30 to 40 to indicate that the invoices are now transferred.

    • Rejected information/invoices

      The status of the included order invoices is changed from 31 to 41, or from 32 to 42, to indicate that the invoices are now transferred.

      At this time, an indication is sent to Infor Enterprise Collaborator (IEC) to start the creation of the sales invoice electronic message, or rejected invoice electronic message, using the MI-program (GTCN10MI). These IEC formats are used:

      • Golden Tax Sales Invoices
      • Golden Tax Rejected Invoices

Below is a description of the panels in (GTCN30):

  • On (GTCN30/B) you can create, display, or select a batch proposal for which the Golden Tax information should be transferred. It is also possible to repeat a transfer if something went wrong during the transfer to the Golden Tax System.
  • The (GTCN30/E) panel opens when you select the option to create a new batch proposal. You must enter a description (only internal text), select a transfer type (sales invoice or rejected invoices), and enter a date of the transfer. Selection of from/to payer is optional.

    All the selected invoices are marked with a batch number retrieved from 'Golden Tax Invoice – Settings' (CRCN01). This is an internal number series to keep invoices sent to the Chinese Golden Tax System in one batch.

    The specified transfer date is also stored on each invoice as information.

  • The (GTCN30/F) panel opens when you select the option to change a batch proposal or view, or transfer the proposal. Depending on the option used, the text for the description and header can be changed.

Receive information from the Golden Tax System

The Golden Tax invoice number created in the Golden Tax System is stored in a text file (file ID SJJK0201) in the Golden Tax System, and you must place the file in the defined catalog or folder for incoming Golden Tax invoice files for the company and division (non-M3 BE functionality).

When IEC finds an electronic message or file in the defined catalog or folder, the upload of the Golden Tax invoice number using the MI-program (GTCN10MI) is started. The IEC format 'Golden Tax Issued Invoices' is used:

For sales invoices, the Golden Tax invoice numbers and the VAT invoice types are updated on the M3 BE order invoice detail level (XCNGTD table) and the status is changed to 90. When all detail lines (XCNGTD table) have been processed, the invoice status (XCNGTH table) is changed to 90 and the invoice is ready for transfer to Accounts Receivable (ARL) through the post-process transfer function.

If the 'Extended Golden Tax invoice number' field in (CRCN01) is enabled, the Golden Tax invoice number populates the 'Extended Golden Tax invoice number' field in the header and detail table. The 'Golden Tax invoice number' field is automatically populated with the M3 invoice number instead. If an amount limit is used in (CRCN01) and an invoice therefore is split, then a 2-position long suffix, A1, A2 up to Z9, is automatically added to the M3 invoice number for each sub number.

For rejected invoices, the status is changed to 92 for invoices not yet transferred. When all detail lines (XCNGTD table) have been processed, the invoice status (XCNGTH table) is changed to 92 and the invoice is ready for transfer to Accounts Receivable (ARL) through the post-process transfer function.

For rejected invoices that have already been transferred to Accounts Receivable (ARL), the status is set to 98 to indicate that the Golden Tax invoice number is cancelled in the Golden Tax System.

Transfer order invoices with Golden Tax information to M3 BE Accounts Receivable Ledger (ARL)

The transfer of Golden Tax invoices to M3 BE Accounts Receivable Ledger (ARL) is handled through the normal post-process transfer function for M3 BE order invoices:

  • Customer order invoices – Post-process transfer (OIS196)
  • Service order invoices – Post-process transfer (SOS196)
  • Project order invoices – Post-process transfer (POS196)
  • Maintenance order invoices – Post-process transfer (COS196)

These M3 BE order invoices in local currency with VAT calculated are included in the transfer:

  • Golden Tax invoice information exists and the invoice status is set to 90 (XCNGTH table) - the invoice is transferred using the Golden Tax invoice numbers.
  • Excluded from Golden Tax invoice handling and the invoice status is set to 91 (XCNGTH table) - the invoice is transferred using the normal M3 BE invoice number.
  • Golden Tax invoice information is rejected and the invoice status is set to 92 (XCNGTH table) - the invoice is transferred using the normal M3 BE invoice number.

M3 BE order invoices without VAT or in foreign currency are included without any Golden Tax invoice information being created.

Workflow for sales invoices

Sales invoices are M3 BE order invoices that must be sent to the Golden Tax System to retrieve a Golden Tax invoice number, and include:

  • Customer order invoices
  • Service order invoices
  • Project order invoices
  • Maintenance order invoices
  1. Prepare M3 BE order invoices.

    M3 BE order invoices in local currency and with VAT calculated must be invoiced before the invoice can be included in the Golden Tax invoice process.

    Note that direct transfer to M3 BE Accounts Receivable (ARL) must not be used for the division.

  2. Create Golden Tax information for M3 BE order invoices.

    Golden Tax invoice information for M3 BE order invoices is created in 'Golden Tax Invoice. Create' (GTCN20).

    (GTCN20) can be opened directly or through the order invoice display programs (for example (OIS350)) using the option 80, if Golden Tax invoice information should be created for a single invoice.

  3. View and adjust Golden Tax information.

    To check if any errors were found (for example, missing or incorrect information) during the creation, use 'Golden Tax Invoice. Display/Enter' (GTCN10). Select invoice status from 11-'Not approved, lines with error exist' to 12-'Not approved, total amount differ' to only view invoices with an error.

    Invoices with an error must be corrected using (GTCN10) before external transfer to the Golden Tax System can be performed.

  4. Create batch proposal for transfer of Golden Tax information.

    When all invoices to be included in the transfer to the Golden Tax System are approved (that is, status set to 20-'Approved, ready for external transfer'), a proposal is created in 'Golden Tax Invoice. Transfer' (GTCN30).

    The type of transfer must be set to 1-'Sales invoices' and a transfer date must be specified.

    Each invoice included in the batch proposal is given a batch number and the status is changed to 30-'Approved, selected for external transfer'. The invoices can be viewed using (GTCN10).

  5. Confirm batch proposal for transfer to the Golden Tax System.

    To start the creation of the sales invoice electronic message through IEC, the batch proposal is confirmed in 'Golden Tax Invoice. Transfer' (GTCN30). The status is changed to 40-'Approved, transferred to the Golden Tax System' for each invoice included in the confirmed batch proposal.

    When the sales invoice text file has been created through IEC, the electronic message is found in the catalog or folder defined for IEC format for sales invoices.

    The sales invoice text file is now processed according to the external process for the Golden Tax System.

  6. Receive text file from the Golden Tax System.

    When the sales invoices have been processed according to the external process for the Golden Tax System, the electronic message for issued invoices is placed in the catalog or folder defined for the IEC format for issued invoices for the company and division.

    When IEC finds an electronic message in the defined folder, the upload of the Golden Tax invoice number and VAT invoice type using the MI-program (GTCN10MI) is started.

    Each Golden Tax invoice detail record is updated with the Golden Tax invoice number and the VAT invoice type received in the text file and the status is set to 90-'Approved, ready for transfer to ARL'. If the 'Extended Golden Tax invoice number' field in (CRCN01) is enabled, then the extended Golden Tax invoice number is also updated.

    When all detail lines (XCNGTD table) have been processed, the invoice status (XCNGTH table) is changed to 90, and the invoice is ready for transfer to the M3 BE Accounts Receivable (ARL) through the post-process transfer programs.

  7. Transfer order invoices to M3 BE Accounts Receivable.

    The transfer of the Golden Tax invoice numbers to the M3 BE Accounts Receivable is done using the post-process transfer programs.

Workflow for rejected invoices

Rejected invoices are M3 BE order invoices that must be sent to the Golden Tax System to cancel an already received Golden Tax invoice number, and include:

  • Customer order invoices
  • Service order invoices
  • Project order invoices
  • Maintenance order invoices
  1. Prepare Golden Tax information.

    In 'Golden Tax Invoice. Display/Enter' (GTCN10), select the invoice to be rejected (only allowed for invoices in status 90 or 95) with option 21='Reject invoice' on (GTCN10/B) and press F21='Reject invoice'.

    The status of the invoice and the details is changed to 21-'Rejected, ready for external transfer' or 22-'Rejected after transfer, ready for external transfer' and the invoice is ready to be included in the transfer of rejected invoices.

  2. Create batch proposal for transfer of Golden Tax information.

    When all invoices to be included in the transfer to the Golden Tax System are rejected (that is, status set to 21-'Rejected, ready for external transfer' or 22-'Rejected after transfer, ready for external transfer'), a proposal is created in 'Golden Tax Invoice. Transfer' (GTCN30).

    The type of transfer must be set to 2-'Rejected invoices' and a transfer date must be specified.

    Each invoice included in the batch proposal is given a batch number and the status is changed to 31-'Rejected, selected for external transfer' or 32-'Rejected after transfer, selected for external transfer'. The invoices can be viewed using (GTCN10).

  3. Confirm batch proposal for transfer to the Golden Tax System.

    To start the creation of the rejected invoice text file through IEC the batch proposal is confirmed in (GTCN30).

    The status is changed to 41-'Rejected, transferred to the Golden Tax System' or 42-'Rejected after transfer, transferred to the Golden Tax System' for each invoice included in the confirmed batch proposal.

    When the rejected invoice text file has been created through IEC, the electronic message is found in the catalog or folder defined for the IEC format for rejected invoices.

    The rejected invoice electronic message is then processed according to the external process for the Golden Tax System.

  4. Receive text file from the Golden Tax System.

    When the rejected invoices have been processed according to the external process for the Golden Tax System, the electronic message for issued invoices is placed in the catalog or folder defined for the IEC format for issued invoices for the company and division.

    When IEC finds an electronic message in the defined folder, the upload of the information using the MI-program (GTCN10MI) is started. For each Golden Tax invoice detail record the status is set to 92-'Rejected, ready for transfer to ARL' or 98-'Rejected after transfer, canceled in Golden Tax System'.

    When all detail lines (XCNGTD table) have been processed, the invoice status (XCNGTH table) is changed to 92 or 98. Invoices with status 92 are then ready for transfer to Accounts Receivable (ARL) through the post-process transfer programs.

  5. Actions for rejected invoices.

    Depending on when in the process the invoice was rejected as well as the reason for a rejected invoice, these actions can be taken:

    1. Order invoices not transferred to Accounts Receivable (ARL) before being rejected - that is, invoices that received status 92-'Rejected, ready for transfer to ARL' when the issued invoice text file was uploaded.
      • New Golden Tax invoice numbers not requested.

        The M3 BE invoice is included in the next post-process transfer to M3 BE FIN/ARL Accounts Receivable (ARL) using the M3 BE invoice number without any additional action needed.

      • New Golden Tax invoice numbers requested.

        The M3 BE invoice must be released and approved again to be included in a new transfer for sales invoices to the Golden Tax System.

        Prepare the order invoice for new transfer to Golden Tax System. Release the invoice in (GTCN10) with the function key F17='Release invoice' on 'Golden Tax Invoice. Open Details' (GTCN11/B). The status is set to 11-'Not approved, lines with error exist'. The invoice can now be changed or approved. Transfer the order invoice to the Golden Tax System by following the workflow for sales invoices.

        Note: It is important to handle all rejected invoices with status 92-'Rejected, ready for transfer to ARL' where new Golden Tax invoice numbers are requested before the post-process transfer to M3 BE ARL/FIN is started.
    2. Order invoices transferred to Accounts Receivable (ARL) before being rejected - that is, invoices that received status 98-'Rejected after transfer, canceled in Golden Tax System' when the issued invoice text file was uploaded.

      Invoices with status 98 must be manually handled. A credit note must be issued or the invoice reversed in M3 BE Finance using the program 'Voucher. Reverse' (GLS900), or other actions decided by the company.

Golden Tax invoice settings in (CRCN01)

'Golden Tax Invoice - Settings' (CRCN01) is used for general settings for the Golden Tax invoice process. For example, type of Golden Tax System and amount limit. The settings are defined per division.

On the E-panel, the type of automatic process for the Golden Tax System is specified and if requested, the amount limit per Golden Tax invoice.

This table shows the fields and their description:

Field Description
Golden Tax System

1 = Manually

2 = Automatically

3 = Manual process for invoices in both foreign and local currency

4 = Manual process for invoices in foreign currency and automatic process for invoices in local currency

Amount limit

Indicates the approved maximum amount of a Golden Tax invoice. The amount is displayed in the currency of the division. VAT is included in the amount. A negative amount is not allowed. Enter 0.00 if an amount limit is not used.

When a Golden Tax invoice is created in M3 BE, the invoice amount is compared to the amount limit and if it exceeds the limit the invoice is automatically split.

Language Indicates the language of the item name. If no item name exists for this language in (MMS030), M3 BE retrieves the item name from (MMS001) when you create Golden Tax information for the selected invoices in (GTCN20).
Address number

Indicates an address number in (OIS002/E).

This address number identifies the customer invoice addresses – addresses of address type 3 in (OIS002/E) – to include in the text files that are generated in IEC for the Golden Tax System. The text files are created when you approve an invoice batch proposal in (GTCN30).

Sales file header

Indicates the information to be included in the header of sales files.

Sales files are text files containing Golden Tax information for new sales order invoices. The company sends the sales files to the Golden Tax System to retrieve the Golden Tax invoice numbers to use. The sales file is automatically created by IEC when you confirm a Golden Tax proposal in (GTCN30).

Reject file header

Indicates the information to be included in the header of rejected files.

Rejected files are text files containing Golden Tax information for sales order invoices that have been rejected by the company, and now need to have their Golden Tax invoice number cancelled.

The rejected file is automatically created by IEC when you confirm a Golden Tax proposal in (GTCN30).

Batch number

Indicates the internal number series that M3 BE uses to group Golden Tax information in separate batches for transfer to the Golden Tax System.

Each invoice batch consists of Golden Tax information for sales order invoices or rejected invoices in a proposal in (GTCN30).

This field displays the last number used in this series. The number is automatically updated for each proposal created.

Original VAT invoice type - header

Indicates the header for the original VAT invoice type. This header is included as a comment for each credit note – in China called negative value invoice – to send to the Golden Tax System.

For corrective invoices with a negative invoice amount, M3 BE automatically adds the header to the 'Comment' field together with the original VAT invoice type that is stored in the original invoice details in (GTCN11/E). This update is made when you generate Golden Tax information in (GTCN20). A prerequisite is that these invoices were created using the corrective invoice functionality in M3 BE. Otherwise you need to enter this information manually in the 'Comment' field.

The header is a fixed text in Chinese, 18 positions long.

Original invoice number - header

Indicates the header for the invoice number for the original Golden Tax invoice.

This header is included as a comment for each credit note – in China called negative value invoice – to send to the Golden Tax System.

For corrective invoices with a negative invoice amount, M3 BE automatically adds the header to the 'Comment' field together with the original invoice number that is stored in the original invoice details in (GTCN11/E). This update is made when you generate Golden Tax information in (GTCN20). A prerequisite is that these invoices were created using the corrective invoice functionality in M3 BE. Otherwise you must enter this information manually in the 'Comment' field.

The header is a fixed text in Chinese, 6 positions long.

Extended Golden Tax invoice number Indicates whether you can store a Golden Tax invoice number that is up to 20 characters long as a parallel invoice number in accounts receivable.
Note: The settings in 'Golden Tax Invoice – Settings' (CRCN01) must be defined to use the functionality for Golden Tax invoice. A verification is carried out in these programs to avoid that Golden Tax invoice information is created before the settings have been made:
  • In the order inquiry programs (for example (OIS350)) new Golden Tax transactions cannot be specified if the parameter in (CRCN01) is undefined. In that case, an error message is displayed.
  • In 'Golden Tax Invoice. Display/Enter' (GTCN10) existing Golden Tax transactions cannot be changed, as it is not possible to the start the program (GTCN10) if the parameter in (CRCN01) is undefined.
  • In 'Golden Tax Invoice. Create' (GTCN20) transactions for the automatic process are not possible to create if the parameter in (CRCN01) is undefined.
  • In (GTCN20) new transactions for the automatic process are not possible to create if the 'Golden Tax System' parameter is not set to 2 or 4.
  • In 'Golden Tax Invoice. Transfer' (GTCN30) transfer of Golden Tax information is not possible if the parameter in (CRCN01) is undefined.
  • In (GTCN30) transfer of Golden Tax information is not possible if the 'Golden Tax system' parameter is not set to 2 or 4.

Connect VAT type to Golden Tax invoice in (CRCN03)

In this parameter function, the connection between the M3 BE VAT code and the VAT type defined by the Tax bureau in China is specified. This information is mandatory for invoices that are handled in the Golden Tax System.

Each VAT code used for domestic invoices in the division must be specified. When creating the Golden Tax invoice information in 'Golden Tax Invoice. Create' (GTCN20), the VAT type is automatically retrieved and updated for the item line.

If no record is found in (CRCN03) for the VAT code of the item line, the status is set to 06-'Not approved, invoice lines with error exist'. The item line must then be manually corrected in (GTCN10) before the transfer to the Golden Tax System can be done.

Settings for M3 BE order invoicing

The Golden Tax invoice handling in M3 BE requires that the 'Direct transfer to FIM' parameter in the M3 BE order setting functions is set to 'No'.

It is also recommended that you use a separate voucher number per invoice (general recommendation for VAT handling in M3 BE Finance).

This table shows the settings for order invoicing in (CRS722), (CRS790), (CRS792) and (COS822):

Program Field Description
(CRS722), (CRS790), (CRS792), (COS822) Direct to FIM Must be set to No = Transfer of invoice accounting done in a separate step using the post-process transfer program.
(CRS722), (CRS790), (CRS792), (COS822) Sep voucher no Recommended to be set to Yes = one voucher number per order invoice is retrieved.
(CRS722) Upd acct entry Must be set to Yes = Accounting entries for the order invoices created during order invoicing. Note: Accounting entries must exist to connect Golden Tax invoice information to the invoice.

Golden Tax information in subfiles

Information about, for example, the Golden Tax invoice number is available in a number of views in the Chinese Country specific functionality. This table shows a list of these views:

View Sorting order
'Customer Order Invoice. Display' (OIS350) 1
'Service Order Invoice. Display' (SOS350) 1
'Project Order Invoice. Display' (POS350) 1
'Maintenance Order Invoice. Display' (COS350) 1

Connect media control objects for standard documents in (CRS945)

The document number XC1 is available for processing through IEC for the outbound files 'Sales' and 'Rejected invoices'.

The document number XC1-'Golden Tax invoice transfer' must be defined in 'Standard Document. Connect Media Control Object' (CRS945) for the transfer types to be handled:

  • 1 for sales invoices
  • 2 for rejected invoices

By doing that an indication is sent to IEC to create the text file format being used when the batch proposal is updated in 'Golden Tax Invoice. Transfer' (GTCN30).

These fields are used during the process in 'Golden Tax Invoice. Transfer' (GTCN30):

  • Document number - must be set to XC1-'Golden Tax invoice transfer'.

    Note that the document number must exist in (CRS027) and (CRS928), created with F14.

  • Transfer type - one record per type of text file to be sent to the Golden Tax System must be defined:
    • 1 for sales invoices
    • 2 for rejected invoices
  • Service ID - must be specified as below in 'Doc Media Control Object. Connect Media' (CRS949):
    • Media: 'MBMEVENT'
    • Service ID: '*JOB'
    • Rcvr ref data 3: 'CN-GTSALES' (for transfer type 1) or 'CN-GTREJECT' (for transfer type 2).
    Note: The standard document handling in M3 BE requires a printout object to be connected. For the document number 'XC1', the fictive printout object 'GTCN33PF' is used.

Limitations

  • For a domestic M3 BE order invoice with VAT, Golden Tax invoice information must be specified and approved before the invoice can be transferred to the M3 BE Accounts Receivable Ledger. Therefore, direct transfer to FIM is not allowed for any of the four M3 BE order invoice areas. It is also recommended that you use a separate voucher number per invoice (general recommendation for VAT handling in M3 BE Finance).
  • Invoices to be reported to the Golden Tax System must only contain one VAT code (rate) per invoice.
  • Domestic M3 BE order invoices that are subject for Golden Tax invoice must not be connected to a payment term defined for 'Split due date'.
  • Domestic M3 BE order invoices that are subject for Golden Tax invoice must not be connected to a cash discount term.
  • For project and maintenance order invoices created using (GTCN20), only the M3 BE invoice header is created in the XCNGTH table.

    The invoice must be completed by adding details and lines in (GTCN10) before the transfer to the Golden Tax System can be done.

  • M3 BE invoices that should be excluded from the Golden Tax invoice handling must first be included in (GTCN20) and afterwards manually excluded using the function key F20='Exclude invoice' in (GTCN10).
  • You can only specify a Golden Tax invoice number for an invoice in foreign currency manually. No automatic process is provided for this.
  • If the 'Extended Golden Tax invoice number' field in (CRCN01) is enabled and invoice splits are used due to amount limits in (CRCN01), then the maximum length of the full extended M3 invoice number must be 13 characters. The reason is to allow a 2-position prefix to fit in the 15-character long standard M3 invoice number field. A maximum of 234 splits for one invoice is supported with this functionality.