Portugal SAF-T for Billing

The Portugal Localization SuiteApp provides the PT SAF-T for Billing file in the XML schema version 1.04_1. This file contains information from sales documents issued in NetSuite. This file works only with OneWorld accounts without SuiteTax. You can generate this file on the Country Tax Reports page provided by the Tax Reporting Framework SuiteApp.

Note:

The transactions included in your report are filtered by the Date field on the transaction record and the period that you select on the Country Tax Report page.

The following sections describe the contents of the PT SAF-T for Billing:

Note:

Please note that all numeric values in the Portugal SAF-T for Billing file, including tax percentages and amounts, are displayed as absolute values.

Note:

The <WorkingDocuments> node only displays 0s because it is not currently supported by the Portugal Localization SuiteApp. This node, however, appears in the report so that the XML file passes the validation tool provided by the Portugal Tax and Customs Authority.

Header

The header node contains the company or subsidiary, export, and software information. The data in this node is sourced the same way as the PT SAF-T for Accounting file. For more information, see the following topics:

Customers Information

The <Customer> node includes the information about each customer in all the sales transactions issued in NetSuite under a Portugal subsidiary.

PT SAF-T Field Name

PT SAF-T Field Value

Source Information

Unique Customer Identifier (CustomerID)

Customer ID, maximum of 30 characters.

Internal ID of the customer record.

For Transfer Orders, the Customer ID consists of the prefix SUB and an Internal ID of subsidiary.

For Intercompany Transfer Orders, the Customer ID consists of the prefix SUB and an Internal ID of the destination subsidiary.

Account Identifier (AccountID)

Accounts Receivables account number, maximum of 30 characters.

Default Receivables Account field on the Financial subtab of the customer record. Accounting contexts, if available, apply.

If the field indicates User System Preference, and the account set on the Accounting Preferences page is associated with a Portugal subsidiary, the account number is displayed. If not, Desconhecido is filled in.

If the field is set to a specific account that is associated with a Portugal subsidiary, the account number is displayed. If not, Desconhecido is filled in.

Customer Tax Identification Number (CustomerTaxID)

  • 999999990 – If customer type is Individual.

  • Customer’s VAT Registration Number – If customer type is Company. This field does not include the country code.

  • Desconhecido – If a number is not entered.

Default Tax Reg. field on the Financial subtab of the customer record.

Company Name (CompanyName)

  • Consumidor final – If the customer type is Individual.

  • Company name, maximum of 100 characters – If the customer type is Company.

Company Name field of the customer record.

Billing Address (BillingAddress)

Node that displays customer’s default billing address in Portugal.

 

Detailed Address (AddressDetail)

Includes the street name, house number and floor, maximum of 210 characters.

Displays Desconhecido if the Company Name indicates Consumidor final, or this part of the address is not filled.

Default billing address on the Address subtab of the customer record.

Locality (City)

Name of city of the customer’s address, maximum of 50 characters.

Displays Desconhecido if the Company Name indicates Consumidor final, or if City is not filled.

City field of the default billing address form on the customer record.

Postal Code (PostalCode)

Zip code of the customer’s address, maximum of 20 characters.

Displays Desconhecido if the Company Name indicates Consumidor final, or if Zip is not filled.

Zip field of the default billing address form on the customer record.

District (Region)

Name of state of the customer’s address, maximum of 50 characters.

Displays Desconhecido if the Company Name indicates Consumidor final, or if State is not filled.

State field of the default billing address form on the customer record.

Country (Country)

Country code, of customer’s address, in ISO 3166 - 1-alpha-2 format.

Displays Desconhecido if the Company Name indicates Consumidor final, or if Country is not filled.

Country field of the default billing address form on the customer record.

Self-Billing Indicator (Self-BillingIndicator)

Displays 0 because self-billing is not supported.

 

Vendor Information

The <Supplier> node contains information about the vendors associated with the item fulfillment records that are included in the SAF-T file. The data in this node is sourced the same way as in the SAF-T files provided by the Portugal Localization SuiteApp. For more information, see Vendor Information.

Products Information

The <Product> node includes all types of items and ship items associated with a Portugal subsidiary. To see what items and ship items belong to which subsidiary, go to Lists > Accounting > Items or Lists > Accounting > Shipping Items.

SAF–T PT Field Name

SAF–T PT Field Value

Source Information

Product or Service Indicator (ProductType)

  • P – Refers to the following item types: Inventory Item, Item Group, Kit/Package, Non-Inventory Item (For Purchase, For Resale, For Sale).

  • S – Service (For Purchase, For Resale, For Sale) and Expense.

  • O – Other Charge (For Purchase, For Resale, For Sale), and Shipping Items.

Item Type

To see a list of product item types in NetSuite, go to Lists > Accounting > Items.

Expense items are only available with Charge-Based Billing and Project Management. For more information, see Expense Items and Charge-Based Project Billing.

Product or Service Identifier (ProductCode)

A unique product code, maximum of 60 characters.

Item Name/Number field (itemid) on the item type record.

Product or Service Description (ProductDescription)

Display name, maximum of 200 characters.

For real product:

  • Display Name/Code field (displayname) on item type record, or if unavailable, Item Name/Number (itemid), or UPC Code (upccode) field.

For billable expense placeholder product:

  • If you create invoices or credit memos using the billable expenses, the report will refer to them by a placeholder item PORTUGAL_BILLABLE_EXPENSE_PLACEHOLDER_ITEM included in this node.

    Note:

    This item name is reserved only for the billable expense placeholder product and cannot be used to create other items.

Product Code (ProductNumberCode)

Product’s EAN code, maximum of 60 characters.

If without EAN, the in Item Name/Number is used.

For real product:

  • UPC Code field (upccode), or if empty, Item Name/Number field (itemid)

For billable expense placeholder product:

  • If you create invoices or credit memos using the billable expenses, the report will refer to them by a placeholder item PORTUGAL_BILLABLE_EXPENSE_PLACEHOLDER_ITEM included in this node.

    Note:

    This item name is reserved only for the billable expense placeholder product and cannot be used to create other items.

Tax Information

The <TaxTable> node contains the following information:

SAF–T PT Field Name

SAF–T PT Field Value

Source Information

Tax Type Code (TaxType)

IVA – If referring to VAT.

NetSuite only supports VAT, therefore this value is preset to IVA.

Tax Type field in the tax code record with a Portugal nexus.

Tax Country or Region (TaxCountryRegion)

Displays the fiscal space code.

For more information about the list of Portugal and non-Portugal fiscal space codes, see Portugal Tax Code Properties and Fiscal Space.

Portugal Fiscal Space field on the tax code record.

Tax Code (TaxCode)

Displays any of the following three-letter codes depending on the specified tax code property:

  • NOR – Normal

  • INT – Intermediate

  • RED – Reduced

  • ISE – Exempt

  • OUT – Other special VAT registration

The tax code property specified in the Portugal Tax Code field on the tax code record with a Portugal nexus.

Tax Description (Description)

Tax code name and description

Tax Code field (itemid) and Description field on the tax code record with a Portugal nexus.

Tax Rate Percentage (TaxPercentage)

Tax rate percentage in two-decimal format

Rate field on the tax code record with a Portugal nexus.

Sales Invoices Documents

Known Limitations of the Sales Invoices Documents

The <SalesInvoices> node has the following known limitations:

  • It only contains information about transactions having a Portugal subsidiary.

  • It only contains information about certified transactions.

  • The SAF-T for Billing report also includes signed transactions that only contain transaction lines with zero amounts.

  • The Portugal Localization SuiteApp does not support using signed credit memo transactions that only contain discount items. Please refrain from doing so, as it would create absent lines in these transactions and result in an incorrect SAF-T for Billing report. This happens because discount items are always applied to the items being sold, which must be present on the same transaction record.

Considering the limitations above, the <SalesInvoices> node contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Number of Business Document Records (NumberOfEntries)

Total number of sales transactions reported including the canceled and billed documents.

 

Total Debit Amount (TotalDebit)

Total debit amount of sales transactions reported except cancelled and billed documents.

Amount (Debit) column on the GL Impact subtab on the records of transactions.

Total Credit Amount (TotalCredit)

Total credit amount of sales transactions reported except cancelled and billed documents.

Amount (Debit) column on the GL Impact subtab on the records of transactions.

Under <SalesInvoices> are the following:

Transaction Information

The information for every sales document of a Portugal subsidiary is represented in the <Invoice> node.

PT SAF-T Field Name

Field Value

Source Information

Unique Identification of the Sales Document (InvoiceNo)

Portugal Transaction ID of the transaction.

Portugal Transaction ID field on the Portugal Transaction subtab on the transaction record.

Unique Document Code (ATCUD)

  • If the transaction does not have an attached document series identifier (DSI), this field displays 0.

  • If the DSI of the transaction does not have a validation code at the time of creation, this field displays 0.

  • If the transaction has an attached DSI with a validation code, this field displays the following:

    Document series' validation code - Sequence number of the transaction within document series

ATCUD field on the Portugal Transaction subtab of the transaction record.

Current Document Status (InvoiceStatus)

Displays N for Normal.

The SuiteApp does not currently support the display of other statuses.

 

Date and Time of the Document While in the Current Status (Invoice Status Date)

Date and time when the last document status is recorded, in this format: YYYY-MM-DD T hh:mm:ss

 

User Code (SourceID)

Name of the employee who last changed or caused the change in status.

Maximum of 30 characters.

Set By column on the System Information subtab of the transaction record.

Document Source (SourceBilling)

Displays P, which means the document was issued in the application used to generate the SAF-T file, not externally.

The SuiteApp does not support the display of other indicators of document sources.

 

Document Key (Hash)

Transaction’s digital signature, maximum of 172 characters.

If the transaction is not signed, or not required to be signed, this field displays 0.

Signature field on the Portugal Transaction subtab on the transaction record.

Control Key (HashControl)

The version of the private key used to create the document key (hash).

Displays 2.

 

Sales Document Date (InvoiceDate)

The date the transaction was issued.

Date field (trandate) on the transaction record.

Sales Document Type (InvoiceType)

Displays:

  • FT – Invoice

  • NC – Credit Memo

  • NC – Cash Refund

  • FR – Cash Sale

    Note:

    For transactions dated before January 1, 2022, Cash Sale is represented as VD.

 

Self-Billing Indicator (SelfBillingIndicator)

Displays 0 because self-billing is not supported.

 

Cash VAT Regime Indicator (CashVATSchemeIndicator)

Indicator of adherence to the Cash VAT Regime.

Displays 0, which indicates no adherence.

 

Billing Indicator Issued in the Name and On Behalf of Third Parties (ThirdPartiesBillingIndicator)

Displays 0, which indicates the invoice is not issued in the name and on behalf of third parties.

 

User Code (SourceID)

Employee Name who created the document. Maximum of 30 characters.

Set By column on the System Information subtab of the transaction record.

Document Recording Date (SystemEntryDate)

Date when the transaction was digitally signed, in this format: YYYY-MM-DD T hh:mm:ss.

Certification Date column on the Portugal Transaction subtab of the transaction record.

Transaction Identifier (TransactionID)

If the Full Multi-Book Accounting feature is not enabled, this field displays the Transaction Date, MAIN, and GL Number.

If the Full Multi-Book Accounting feature is enabled, this field displays the Transaction Date, Accounting Book ID, and GL Number.

Date field (trandate) on the transaction record.

Accounting Book internal ID, if Full Multi-Book Accounting feature is enabled.

Customer Identifier (CustomerID)

Customer ID, maximum of 30 characters. This is the same value on the SAF-T for Accounting CustomerID field under Customer Information.

Internal ID of the customer record.

If projects were used (when using the Basic Projects feature), the ID is sourced from the customer associated with the project, not the project ID.

Transaction Line and Tax Information

The <Line> node describes each transaction line of a sales document and its tax information in the <tax> node.

PT SAF-T Field Name

Field Value

Source Information

Line Number (LineNumber)

Transaction line number.

 

Product or Service Identifier (ProductCode)

Unique item code, maximum of 60 characters. This is the same value on the SAF-T for Accounting ProductCode field under Products Information.

Item Name/Number field (itemid) on the item type record.

Product or Service Description (ProductDescription)

Item display name, maximum of 200 characters. If empty, this field uses the value from the ProductCode field. This is the same value on the SAF-T Accounting ProductDescription field under Products Information.

Display Name/Code field (displayname) on the item record, or the Description column on the Items subtab of the transaction record.

Quantity (Quantity)

Item quantity.

Quantity column on the Items subtab of the transaction record.

Unit of Measure (UnitOfMeasure)

Unit used to measure quantity.

Primary Base Unit field (baseunit) on the item record.

Unit Price (UnitPrice)

Price per unit of an item.

If a discount applies, it displays the discounted price per unit.

Rate column on the Items subtab of the transaction record.

Discount rates are sourced from the Rate field (discountrate) on the Items subtab, or the Rate column if a line discount is applied.

Date of Dispatch of the Goods or Provision of the Service (TaxPointDate)

Transaction date in this format: YYYY-MM-DD T hh:mm:ss.

Date field (trandate) on the transaction record.

Description (Description)

By default, this field is set to the Item Description value. It can be overwritten with a custom value. If the field is empty, it displays the value Desconhecido.

Description field

Debit (DebitAmount)

OR

Credit (CreditAmount)

This field shows one of the two following values:

  • Debit amount of the transaction line

  • Credit amount of the transaction line

Amount (Debit) column on the GL Impact subtab of the transaction record.

OR

Amount (Credit) column on the GL Impact subtab of the transaction record.

Tax

Note:

This node includes only tax codes. Tax groups are excluded. You must not use tax groups in sales transactions.

Tax Type Code (TaxType)

Displays the following:

  • IVA – Value-added tax (VAT).

  • NS – Not subject to VAT or stamp duty.

TaxType field in the Tax Information of the SAF-T for Accounting file.

Tax Country or Region (TaxCountryRegion)

Displays the fiscal space code.

For more information about the list of Portugal and non-Portugal fiscal space codes, see Portugal Tax Code Properties and Fiscal Space.

Portugal Fiscal Space field on a tax code record.

Rate Code (TaxCode)

If the TaxType is IVA, this field displays the following:

  • NOR – Normal

  • INT – Intermediate

  • RED – Reduced

  • ISE – Exempt

  • OUT – Other special VAT registration

If the TaxType is NS, this field displays ISE, which refers to the tax property Exempt.

TaxCode field in the in the Tax Information of the SAF-T for Accounting file.

Tax Rate Percentage (TaxPercentage)

Tax rate in decimal format without the percent sign.

Tax Rate column indicated in the transaction line.

Tax Exemption Reason (TaxExemptionReason)

The legal justification given by the Portugal Tax and Customs Authority. For example: Artigo 16.º n.º 6 do CIVA (Ou similar).

Portugal Tax Exemption Reason field (custrecord_ptsaft_tax_exemption_reason) on the tax code record.

For more information, see Entering a Portugal Tax Exemption Reason.

Tax Exemption Reason Code (TaxExemptionCode)

The code that corresponds to a tax exemption reason. For example: M01.

Portugal Tax Exemption Reason field (custrecord_ptsaft_tax_exemption_reason) on the tax code record.

Document Totals

The <DocumentTotals> node contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Tax Payable Amount (TaxPayable)

Total tax amount.

Tax Amount column on the Items subtab of the transaction record.

Total Document without Taxes (NetTotal)

Total net amount.

Amount column on the Items subtab of the transaction record.

Total Document with Taxes (GrossTotal)

Gross amount.

Gross Amount column on the Items subtab of the transaction record.

Currency Information

The <Currency> node is only displayed in the document if the currency of a transaction is different from euros. If present, it contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Currency Code (CurrencyCode)

The code of the currency used for the transaction.

For the generated report to be valid, this code must show the correct ISO code of the selected currency.

Currency code derived from the currency in the Currency field on the transaction record.

Total Amount in a Foreign Currency (CurrencyAmount)

Total amount of the transaction in foreign currency without applying the exchange rate.

Applied field on the transaction record.

Exchange Rate (ExchangeRate)

The exchange rate applied to the total amount of the transaction used to calculate the amount in euros.

Exchange Rate field on the transaction record.

Movement of Goods Documents

The <MovementOfGoods> node contains information about all certified item fulfillment records encompassed in the selected time period, to be included in the SAF-T for Shipping file. This only includes item fulfillment records that have Portugal Transaction ID.

PT SAF-T Field Name

PT SAF-T Field Value

Source Information

Number of Transaction Lines (NumberOfMovementLines)

Total number of item fulfillment transaction lines, including the canceled transactions, that are included in the SAF-T file.

Information from the item fulfillment records you selected on the Generate SAF-T Shipping page.

Total Quantity of Items (TotalQuantityIssued)

Sum of the quantity of the items in the considered item fulfillments.

Entries in the Quantity fields in the item fulfillment records you selected on the Generate SAF-T Shipping page.

Stock Movement Information

The <StockMovement> node contains information about each included item fulfillment transaction under a specific Portugal subsidiary.

SAF–T PT Field Name

SAF–T PT Field Value

Source Information

Document Number (DocumentNumber)

Portugal Transaction ID

Portugal Transaction ID field on the item fulfillment record.

ATCUD (ATCUD)

  • If the transaction does not have an attached document series identifier (DSI), this field displays 0.

  • If the DSI of the transaction does not have a validation code at the time of creation, this field displays 0.

  • If the transaction has an attached DSI with a validation code, this field displays the following:

    Document series' validation code - Sequence number of the transaction within document series

ATCUD field on the Portugal Transaction subtab of the transaction record.

Current Document Status (MovementStatus)

Displays N for Normal.

The SuiteApp does not support the display of other indicators of document sources.

 

Date of Document while in Current Status (MovementStatusDate)

Date and time, in the format YYYY-MM-DD T hh:mm:ss, when the current status of the transaction was set.

Certification Date field on the Portugal Transaction subtab of the transaction record.

User Code (SourceID)

Code that identifies the user who updated the document to its current status, maximum of 30 characters.

User ID of the user in the Set By column on the System Information subtab of the transaction record.

Document Source (SourceBilling)

Displays P, which means the document was issued in the application used to generate the SAF-T file, not externally.

The SuiteApp does not support the display of other indicators of document sources.

 

Document Key (Hash)

Transaction’s digital signature, maximum of 172 characters.

If the transaction is not signed, or not required to be signed, this field displays 0.

Signature field on the Portugal Transaction subtab on the transaction record.

Control Key (HashControl)

The version of the private key used to create the document key (hash).

Displays 2.

 

Transport Document Date (MovementDate)

The date the item fulfillment was issued.

Date field (trandate) on the transaction record.

Transport Document Type (MovementType)

Diplays GR, which indicates delivery note by Portugal law. In NetSuite, the item fulfillment transaction type acts as the delivery note.

 

Document Recording Date (SystemEntryDate)

Date when the transaction was digitally signed, in this format: YYYY-MM-DD T hh:mm:ss.

Certification Date field on the Portugal Transaction subtab of the transaction record.

Transaction Identifier (TransactionID)

This field is only displayed if the item fulfillment has the status Shipped

If the Full Multi-Book Accounting feature is not enabled, this field displays the Transaction Date, MAIN, and GL Number.

If the Full Multi-Book Accounting feature is enabled, this field displays the Transaction Date, Accounting Book ID, and GL Number.

Date field (trandate) on the transaction record.

Accounting Book internal ID, if Full Multi-Book Accounting feature is enabled.

Customer Identifier (CustomerID)

OR

Supplier Identifier (SupplierID)

Customer ID and Supplier ID, maximum of 30 characters.

This field displays Customer ID when the item fulfillment is created from a:

  • Sales Order

  • Transfer Order

  • Intercompany Transfer Order

This field displays Supplier ID when the item fulfillment is created from a:

  • Vendor Return Authorization

Internal ID of the customer record.

If projects were used (when using the Basic Projects feature), the ID is sourced from the customer associated with the project, not the project ID.

For Transfer Orders, the Customer ID consists of the prefix SUB and an Internal ID of subsidiary.

For Intercompany Transfer Orders, the Customer ID consists of the prefix SUB and an Internal ID of the destination subsidiary.

User Code (SourceID)

Code that identifies the employee who created the document.

User ID of the user in the Set By column on the System Information subtab of the transaction record.

Delivery Address (ShipTo)

Node that contains the delivery address details.

If the item fulfillment is created from a:

  • Sales Order - Shipping Address subtab in the item fulfillment record.

  • Transfer order (TO) or Intercompany transfer order (ITO) - Address on the location record indicated in the

    To Location field on the TO or ITO.

  • Vendor Return Authorization - Shipping Address subtab in the item fulfillment record.

Detailed Address (AddressDetail)

Includes the street name, house number and floor, maximum of 210 characters.

Displays Desconhecido if this part of the address is not filled in.

Address field

Locality (City)

Name of city of the customer’s address, maximum of 50 characters.

Displays Desconhecido if City is not filled in.

City field

Postal Code (PostalCode)

Zip code of the customer’s address, maximum of 20 characters.

Displays Desconhecido if Zip is not filled in.

Zip field

Country (Country)

Country code, of customer’s address, in ISO 3166 - 1-alpha-2 format.

Displays Desconhecido if Country is not filled in.

Country field

Source Address (ShipFrom)

Node that contains the address from where the goods were shipped, and the date of shipping.

If the item fulfillment is created from a:

  • Sales Order - Address on the Location record used in the sales order.

  • Transfer order (TO) or Intercompany transfer order (ITO) - Address on the location record indicated in the

    From Location field on the TO or ITO.

  • Vendor Return Authorization (VRA) - Address on the location record used in the VRA.

Delivery Identifier (DeliveryID)

License plate number of the transport vehicle, or if this is not applicable, the type of vehicle or delivery method used.

This field is only displayed if the License Plate or Shipping Method are present. If these values are absent, the field is not displayed.

License Plate field on the item fulfillment, or, if empty, Shipping Method (shipmethod) field.

Detailed Address (AddressDetail)

Includes the street name, house number and floor, maximum of 210 characters.

Displays Desconhecido if this part of the address is not filled in.

Address field

Locality (City)

Name of city of the customer’s address, maximum of 50 characters.

Displays Desconhecido if City is not filled in.

City field

Postal Code (PostalCode)

Zip code of the customer’s address, maximum of 20 characters.

Displays Desconhecido if Zip is not filled in.

Zip field

Country (Country)

Country code, of customer’s address, in ISO 3166 - 1-alpha-2 format.

Displays Desconhecido if Country is not filled in.

Country field

Start of Transport of Goods (MovementStartTime)

Date and time, in YYYY-MM-DD T hh:mm:ss format, when the shipment of goods started

Movement of Goods Start Time field on the item fulfillment

Identification Code from the Portugal Tax and Customs Authority (ATDocCodeID)

Identification code given by the Portugal Tax and Customs Authority to the document in accordance with Decree No. 147/2003, of July 11.

This field is only displayed if the ATDocCodeID is present. If the value is empty, this field is not displayed.

AT Doc Code ID field on the item fulfillment

Transaction Line Information

The <Line> node describes the items in an item fulfillment.

The items included in the report are the line items in a given item fulfillment record that are of the following types: Assembly, Group, Inventory, Non-Inventory, Kit/Package, Service, and Other Charge. For more information, see Item Types.

Note:

For Kit/Package items, the Portugal SAF-T for Billing report only includes one line per item type. Therefore, the report does not include lines for the components of these items that are present on the item fulfillment record in NetSuite.

PT SAF-T Field Name

Field Value

Source Information

Line Number (LineNumber)

Transaction line number.

 

Product or Service Identifier (ProductCode)

Unique item code, maximum of 60 characters. This displays the same value as on the ProductCode field under the <Product> node. For more information, see Products Information.

Item Name/Number field (itemid) on the item type record.

Product or Service Description (ProductDescription)

Item display name, maximum of 200 characters. If empty, this field uses the value from the ProductCode field. This is the same value on the SAF-T Accounting ProductDescription field under Products Information.

Display Name/Code field (displayname) on the item record.

Quantity (Quantity)

Item quantity.

Quantity column on the Items subtab of the transaction record.

Unit of Measure (UnitOfMeasure)

Unit used to measure quantity.

Primary Base Unit field (baseunit) on the item record.

Unit Price (UnitPrice)

Price per unit of an item without tax.

If a discount applies, it displays the discounted price per unit.

Rate column on the Items subtab of the transaction record.

Discount rates are sourced from the Rate field (discountrate) on the Items subtab, or the Rate column if a line discount is applied.

Unit Price is preset to the value 0.00.

Item Description (Description)

By default, this field is set to the Item Description value. It can be overwritten with a custom value. If the field is empty, it displays the value Desconhecido.

Description column on the Items subtab of the transaction record.

Debit (DebitAmount)

OR

Credit (CreditAmount)

This field shows one of the two following values:

  • Debit amount of the transaction line

  • Credit amount of the transaction line

Amount (Debit) column on the GL Impact subtab of the transaction record.

OR

Amount (Credit) column on the GL Impact subtab of the transaction record.

This value is preset to 0.00.

Document Totals Information

The <DocumentTotals> node contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Tax Payable Amount (TaxPayable)

Total tax amount.

Tax Amount column on the Items subtab of the sales order, transfer order, intercompany transfer order, or vendor return authorization (from which the item fulfillment is created).

Total Document without Taxes (NetTotal)

Total net amount without taxes.

Amount column on the Items subtab of the sales order, transfer order, intercompany transfer order, or vendor return authorization (from which the item fulfillment is created).

Total Document without Taxes is preset to the value 0.00.

Total Document with Taxes (GrossTotal)

Gross amount.

Gross Amount column on the Items subtab of the sales order, transfer order, intercompany transfer order, or vendor return authorization (from which the item fulfillment is created).

Customer Payments Information

Known Limitations of the Customer Payments Information

The <Payments> node has the following known limitations:

  • Following the PT SAF-T requirements, you should only apply payments to certified invoices or credit notes. If you apply payments to other transaction types, these transactions will not be included in the generated SAF-T for Billing report. Consequently, the report will not be accepted by the Portugal Tax and Customs Authority.

  • The report generation does not support payments in which the total payment amount is equal to the sum of its discounts.

For all the fields in this node to be displayed, you should apply payments by placing check marks in the Apply column next to the appropriate invoices at the bottom of the payment record.

Considering the limitations above, the <Payments> node contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Number of Payment Entries (NumberOfEntries)

Total number of signed payment transactions. These include those that have Portugal Transaction ID.

Number of Payment nodes in the XML file.

Total Debit (TotalDebit)

This value is preset to 0.00. It is always filled in, because the report requires it.

Preset value.

Total Credit (TotalCredit)

This field displays a value representing a sum of all <NetTotal> nodes contained within the <Payments> node.

To be compliant with Portugal law, discounts in payment lines are not considered. Instead, they are included as separate lines in the GL Impact.

 

Reference Number of Payment (PaymentRefNo)

Portugal Transaction ID related to the transaction.

Portugal Transaction ID field on the Portugal Transaction subtab on the Payment record.

ATCUD (ATCUD)

  • If the transaction does not have an attached document series identifier (DSI), this field displays 0.

  • If the DSI of the transaction does not have a validation code at the time of creation, this field displays 0.

  • If the transaction has an attached DSI with a validation code, this field displays the following:

    Document series' validation code - Sequence number of the transaction within document series

ATCUD field on the Portugal Transaction subtab of the transaction record.

Transaction Identifier (TransactionID)

This field is only displayed if the GL Number is defined. There are two ways this field's value is determined:

  • If the Full Multi-Book Accounting feature is not enabled, this field displays the Transaction Date, MAIN, and GL Number.

  • If the Full Multi-Book Accounting feature is enabled, this field displays the Transaction Date, Accounting Book ID, and GL Number.

 

Payment Date (TransactionDate)

Payment Date

Date field on the Payment record.

Payment Type (PaymentType)

This field always displays RG. It corresponds to the receipt issued according to the Cash VAT regime, including advanced payments in this regime.

Preset value.

Current Document Status (PaymentStatus)

This field displays N for Normal.

The SuiteApp does not currently support the display of other statuses.

Preset value.

Transaction Entry Date (PaymentStatusDate)

This field displays the date of entering Portugal transaction into the system.

Certification Date field on the Portugal Transaction subtab on the Payment record.

User Code (SourceID)

Name of the employee who created the transaction.

Maximum of 30 characters.

Set By column field on the Portugal Transaction subtab on the Payment record.

In case more column items are present, the value refers to the oldest item whose corresponding Type column shows the value Create.

Document Source (SourcePayment)

This field displays P, which means the document was issued in the application used to generate the SAF-T file, not externally.

The SuiteApp does not support the display of other indicators of document sources.

Preset value.

User Code (SourceID)

Name of the employee who created the transaction, or last changed the transaction status.

Maximum of 30 characters.

Set By column field on the Portugal Transaction subtab on the Payment record.

In case more column items are present, the value refers to the oldest item whose corresponding Type column shows the value Create.

Transaction Entry Date (SystemEntryDate)

This field displays the date of entering Portugal transaction into the system.

Certification Date field on the Portugal Transaction subtab on the Payment record.

Customer Identifier (CustomerID)

Customer ID with a maximum of 30 characters.

Internal ID of the customer record.

If projects were used (when using the Basic Projects feature), the ID is sourced from the customer associated with the project, not the project ID.

Transaction Line Information

The <Line> node contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Line Number (LineNumber)

Transaction line number.

 

(OriginatingON)

Portugal Transaction ID of the invoice related to this line.

Portugal Transaction ID field on the Portugal Transaction subtab on the Invoice record.

This record belongs to the invoice that corresponds to the given customer payment.

Sales Document Date (InvoiceDate)

Transaction date of when the related invoice was issued.

Date field on the Invoice record.

This record belongs to the invoice that corresponds to the given customer payment.

Credit Amount (CreditAmount)

Credit amount of the transaction line – invoice.

Corresponds to the applied amount expressed in euros.

For other currencies, it is obtained by multiplying the line amount in foreign currency by the exchange rate.

 

Document Totals Information

The <DocumentTotals> node contains the following information about the total amounts reported in the payment:

Note:

All payments must be fully applied before generating the report. In case there is any outstanding unapplied amount, the generated report is not valid. The validation of such report may be refused by the report submission tool of the Portugal Tax and Customs Authority.

PT SAF-T Field Name

Field Value

Source Information

Tax Payable Amount (TaxPayable)

Taxes are not considered.

Tax Payable Amount is preset to the value 0.00.

Total Document without Taxes (NetTotal)

Total net amount of the payment. The value is expressed in EUR.

If the transaction is in a currency different from euros, this value is obtained by applying ExchangeRate value to the CurrencyAmount value. Both of these values can be found in the Currency Information

Applied field on the Payment record for transactions in EUR.

Amount (Debit) and Amount (Credit) fields on a GL Impact subtab on the Payment record for transactions in foreign currencies.

Total Document with Taxes (GrossTotal)

Total amount of the payment. The value is expressed in EUR.

Applied field on the Payment record for transactions in EUR.

Amount (Debit) and Amount (Credit) fields on a GL Impact subtab on the Payment record for transactions in foreign currencies.

Currency Information

The <Currency> node is only displayed in the document if the currency of a transaction is different from euros. If present, it contains the following information:

PT SAF-T Field Name

Field Value

Source Information

Currency Code (CurrencyCode)

The code of the currency used for the transaction.

For the generated report to be valid, this code must show the correct ISO code of the selected currency.

Currency code derived from the currency in the Currency field on the Payment record.

Total Amount in a Foreign Currency (CurrencyAmount)

Total amount paid in foreign currency without applying the exchange rate.

Applied field on the Payment record.

Exchange Rate (ExchangeRate)

The exchange rate applied to the amount paid in foreign currency, used to calculate the amount in euros.

Exchange Rate field on the Payment record.

Related Topics

General Notices