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 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:

Service order invoices include these invoice types:

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.

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' in (GTCN11/E)).
29-34 Header description for Original invoice number from (CRCN01/E).
35-42 Original invoice number from the original invoice (field 'Golden Tax invoice number' in (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 panel (GTCN11/E). 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)

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:

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

The information displayed in (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 panel (GTCN11/B).
12-Not approved, total amount differ Status set during automatic creation in (GTCN20) or when an invoice is approved on panel (GTCN11/B) 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 panel (GTCN11/B) 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 panel (GTCN11/B) 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).

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

91-Excluded, ready for transfer to ARL Status set on panel (GTCN11/B) 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 panel (GTCN12/B), 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 panel (GTCN12/B), 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 panel (GTCN12/B), 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 panel (GTCN11/B), or approve an invoice on panel (GTCN12/B), 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 panel (GTCN12/B), 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 panel (GTCN12/B), 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 the following:

  • 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 the following:

  • 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 the following:

  • 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 panel GTCN11/E).

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

  • 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 panel (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 panel (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 in 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:

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):

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:

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):

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.

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:

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

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:

  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'.

    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:

  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 the panel (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, cancelled 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, the following 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 the panel '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, cancelled 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.

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:

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):

Limitations

Related topics