Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel6
outlinefalse
typelist
printablefalse

...

This is the list of available FlowAP templates. 3 default templates come with FlowAP upon installation.

Note

You must not edit the Default FlowAP Templates.

Any changes made to the default template will be overridden during new version releases of FlowAP.

To use a customized version of the FlowAP template, save a copy of the Default FlowAP Template.

Apply your own lookup criteria and XML mapping to the new FlowAP Template; and assign it to the relevant Staria FlowAP Subsidiary Setup.

...

Field

Validation / Automation Details

Expense Line : Memo field

NetSuite expense lines created when conversion is unable to identify a NetSuite item for the invoice line.

The memo field of the expense line will have the value:

<taxpercent> | <vendorcode> - <itemname>

Related article: How to customize the memo field value of expense lines created by FlowAP conversion

Currency

The XML currency is always used. "currency": {"xpath" : ["/cbc:DocumentCurrencyCode"]},

  1. If the XML currency is not configured in NetSuite (List>Accounting>Currencies) the conversion will result to an error.

  2. If the XML currency is configured in NetSuite, but not found in the vendor’s available currencies, it will be added to the vendor record and conversion will be successful in using the XML currency.
    https://staria.atlassian.net/wiki/spaces/SFI/pages/edit-v2/1568931841?draftShareId=143418ae-9fb3-4a40-a37f-67dcd23519db

Invoice Item Line : Quantity

The quantity is defaulted to 1 if there is no indicated quantity in the XML for an item line.

Vendor : VAT

"vendorvat": {"xpath": ["/cac:AccountingSupplierParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]},

Subsidiary : VAT

"subsidiaryvat": {"xpath": ["/cac:AccountingCustomerParty/cac:Party/cac:PartyIdentification/cbc:ID[@schemeID=\"VAT\"]"]},

All fields

After parsing the mapped fields and no value is found in the XML, the created JSON data from the XML will set the value as “STA_EMPTY“.

Location

A hierarchy is implemented for determining the location to be set.

https://staria.atlassian.net/wiki/spaces/SIS/pages/edit-v2/1565753351?draftShareId=253908da-d8b2-45b8-b825-b74c6c05d4e3

Billing Address : Country

If the XML’s billing country is empty, the vendor record’s billing country will be used.

Reference Number

Unique Transaction reference numbers are validated for each transaction type (vendor bill and vendor bill credit). The conversion will fail for duplicate transaction reference numbers.

Info

Transaction reference number duplicates are not checked across two different transaction types.

Example: A vendor bill can have reference number = ABC123 and a vendor bill credit can still be created with reference number ABC123.

Related FlowAP Subsidiary Setup Options

...

Use Case

Setup Options

Related Articles

Allow transaction creation to proceed even if the conversion was unable to find a matching NetSuite item for the vendor bill lines.

The conversion will post unidentified items as expense lines.

FlowAP Subsidiary Setup > CREATE UNIDENTIFIED ITEMS AS EXPENSE

How does FlowAP Post unidentified items?

Use NetSuite expense items instead of expense lines

FlowAP Subsidiary Setup > USE EXPENSE ITEMS INSTEAD OF ACCOUNTS FOR EXPENSE LINES

Expense Item/Account Lookup Hierarchy

Ignore XML line level data and allow NetSuite to copy the line level information from the related purchase order in NetSuite.

The total payable amount of the bill will always be equal to the XML.

The user responsible for the bill is expected to review the line details of the bill and make the necessary data entry to correct it for the total payable amount.

FlowAP Subsidiary Setup > INHERIT PO LINES

FlowAP Subsidiary Setup > INHERIT PO LINES: DEFAULT TO 0 QUANTITY AND AMOUNT

Inherit Purchase Order Lines with Variances

Ignore the XML line level data and save a single transaction line in NetSuite transaction.

FlowAP Subsidiary Setup > POST SINGLE BILL LINE: USE PAYABLE AMOUNT (NO TAX)

Understanding the [STA] POST SINGLE BILL LINE preference

Vendor Preference: [STA] No Direct Bill

Will

Info

When using Post Single Bill Line = T and Use expense item = T: the rate is always set to 0. The amount is mapped from the XML.

Do not allow a well-formed XML to create a stand-alone bill (Direct bill) if the PO Reference is empty.

Staria FlowAP Subsidiary Setup > WHEN BILL NOT FOUND

https://staria.atlassian.net/wiki/spaces/SIS/pages/1193541651/Staria+FlowAP+Subsidiary+Setup#Flowsetup-whenbillnotfound

Vendor Preference: [STA] No Direct Credit

Will Do not allow a well-formed XML to create a stand-alone bill credit (Direct Credit) if the Bill Reference is empty.

Staria FlowAP Subsidiary Setup > WHEN PO# NOT FOUND

https://staria.atlassian.net/wiki/spaces/SIS/pages/1193541651/Staria+FlowAP+Subsidiary+Setup#Flowsetup-whenPOnotfound

Do not allow stand alone transactions for a specific vendor.

Configure vendor preferences in the vendor record.

  1. Vendor Preference: [STA] No Direct Bill

  2. Vendor Preference: [STA] No Direct Credit

Configure the Vendor-specific preferences saved search in the FlowAP Subsidiary Setup > VENDOR-SPECIFIC PREFERENCES

Vendor Record

https://staria.atlassian.net/wiki/spaces/SIS/pages/1318354945/Vendor+related+configuration+for+FlowAP+conversion+A+Detailed+Guide#Vendor-Specific-Preferences

Define tax codes for each tax rate/percent parsed from the XML during conversion.

FlowAP Subsidiary Setup > TAX CODE TABLE

https://staria.atlassian.net/wiki/spaces/SIS/pages/1316683781/Hierarchy+Used+by+FlowAP+Conversion+When+Selecting+Tax+Codes+on+Vendor+Bill+Lines#Tax-Code-Hierarchy-for-Bill-Items

Configure the conversion to either create a stand alone transaction or report an error whenever a referenced PO number or Bill reference number in the XML is not found.

  1. A fix is implemented for a bug affecting setup for subsidiaries setup where WHEN PO# NOT FOUND = Report Error. Subsidiaries with this setup were preventing stand-alone bills from being converted.

  1. For Post Single Bill Line - Expense Item, the rate is always set to 0 to cover discount items limitation. The amount is mapped from the XML. 'Transaction Total' added to the memo

TO DO, MOVE to other pages:

...

Fixed an issue where a duplicate number error is flagged when using the same document number between a vendor bill and a vendor credit.

...

Fixed an issue where vendor creation fails if the XML does not contain or has an invalid payment term.

...

The following tax code lookup options now support 0% tax rates:

  • Vendor-subsidiary sublist tax code field.

  • Item tax schedule

...

Fixed an issue where the final tax code lookup hierarchy entry is using a Default tax code for the vendor’s billing country instead of the transaction’s subsidiary country.

Expected errors

...

Limitations

Warning
  • The FlowAP conversion only supports UBL 2.1 Invoice XML schema. The UBL 2.1 (Universal Business Language) standard provides a set of predefined codes for the InvoiceTypeCode element, which specifies the type of invoice being issued. The following are supported InvoiceTypeCode values:

    1. 380 - Commercial invoice: The most common type of invoice used for general business transactions.

    2. 381 - Credit note: Used to correct or cancel a previously issued invoice.