Welcome to the Veson Nautical Knowledge Base. In the Help Center, you can view the same articles and contact support as needed.

IMOS On-Prem - Transaction Data Entry

 This is a Key Topic, with high value for all users.


Accountants can create invoices without having to start in Operations, by using the Transaction Data Entry form. When posted, the invoice transaction data is back-created into any relevant voyages in Operations.

This article contains the following information:

Creating a Transaction

  1. In the Financials module center , under Transactions, click Transaction Data Entry.

    Default values appear based on Invoice Default Rules and Invoice Detail Default Rules.

  2. Select either Payable or Receivable.

  3. Complete at least the Accounting Date, Vendor or Customer, Invoice Date, Due Date, Invoice No. (for a payable invoice), and Invoice Type.

    • To calculate Due Date, complete the Terms field by specifying a Payment Terms code.

    • Exch Rate/Date:

      • When creating transactions from this form, the date defaults to the Accounting Date and is not affected by configuration flags.

      • When creating transactions in Operations, the date defaults to the Exchange Rate Date on the Operations invoice; if not available, the date defaults to the Invoice Date.

      • When the Exchange Rate is overwritten manually on the Transaction Data Entry form, the Exchange Rate Date becomes the same as the Accounting Date.

  4. Entering a record in the Bill Via field changes only the header information of the invoice but has no effect in the remittance bank details.

  5. Complete Invoice Details:

    • Accounting View tab: Enter Company, Line of Business, Vessel code or Vessel Name, and Amount.

    • Operations View tab: Enter the Bill (Detail) Code for the Source Code selected as the Invoice Type. Its Item Description appears. If there is a Business Rule for the Source Code/Bill Code, the Account field on the Accounting View tab will be filled in automatically, but it can be overwritten. Changes to the mapping can be done in the Business Rules.

      Note: If the Account field on the Accounting View tab is not editable, it means that the Edit Account on Transaction Data Entry Module Right (enabled by configuration flag CFGEnableEditTDEandJournalAccountsEntry) is not selected on a user/group level.

    • Remarks tab: Enter Invoice Details and Additional Remarks. On posting, the text is captured in the output invoice .XML.

  6. Click .
    Payments appear on the Payments tab at the bottom of the form.
    For invoices created in the Transaction Data Entry, attachments can be added after the form is saved. Click: 

Status Codes

Several Status codes appear on the Transaction Data Entry form, depending the stage of the transaction.

  • V = Saved Only. Transaction data is entered and saved but not posted. A pending transaction number is generated.

  • 1 = Posted. The transaction is posted but not yet paid.

  • 0 = Posted and Paid. The transaction is posted and saved.

  • R = Reversed. The transaction is reversed either from when it was paid or posted.

  • X = Canceled. This Status does not appear on the form, but it does show up in the XML files when the transaction is canceled; on the form, Status code R appears.

Creating a Rebillable Invoice

If a rebillable transaction does not have rebillable invoice, click the Rebill Inv No. field label.

Payment Batches

Configuration flag CFGBatchPaymentSupported must be enabled.

If Payment Batches are enabled, an additional tab appears along with Payments information. The Payment Batches tab includes information about all payment batches related to the invoice; the corresponding batches can be opened from the context menu of each line.

Batch Status:

  • Sent: The batch has been sent.

  • Accepted: All payments in the batch were accepted.

  • Amended: At least one payment in the batch was rejected, amended, and resent, and no payments in it were rejected. 

  • Rejected: If any payments in the batch are rejected, the batch is rejected as well.

A posted invoice can be assigned to a Payment Batch. Click the Payment Batch No. field label link to assign a Batch Number or view the Payment Batch.

Reversing a Transaction

  1. If there is a payment against the invoice, cancel it before reversing the transaction.

  2. On the Transaction Data Entry form, click .

  3. Enter reversal information and then click OK.

 

Name/Flag

Description

Name/Flag

Description

Invoice No by Company
CFGInvoiceNoByCompany

Use company code as prefix for invoice numbers.

Invoice No by Company Skip Gap
CFGInvNoByCompanySkipGap

When CFGInvoiceNoByCompany is set to Y, do not reuse invoice numbers that belong to reversed transactions.

Auto Number Payables
CFGAutoNumberPayables

Automatically assigns invoice numbers to AP invoices.

Check Duplicate Invoice No in Operations
CFGCheckDuplicateInvNoInOps

Controls validation of invoice numbers for invoices created on the Voyage Other Revenues and Expenses, Profit Share Distribution, or Transaction Data Entry form. The available options are:

  • N = No validation.

  • Y = No duplicate numbers allowed for the same vendor. An invoice created in one of these forms cannot be saved when the invoice number is the same as a different bill record for the same vendor.

  • A = No duplicate numbers allowed for the same vendor within the same Account Period. An invoice created in one of these forms cannot be saved when the invoice number is the same as a different bill record for the same vendor in the same Account Period.

When auto-numbering invoices:

  • If neither CFGCheckDuplicateInvNoInOps nor CFGCheckDuplicateInvNoInAct is enabled, invoice auto-numbering considers only AP invoices when auto-numbering an AP invoice, or only AR invoices when auto-numbering an AR invoice.

  • If either CFGCheckDuplicateInvNoInOps or CFGCheckDuplicateInvNoInAct is set to either Y or A, invoice auto-numbering considers both AP and AR invoice numbers.

Check Duplicate Invoice No in
CFGCheckDuplicateInvNoInAct

Controls validation of invoice numbers at the time of posting for financial invoices originally created on the Voyage Other Revenues and Expenses or Transaction Data Entry form. The available options are:

  • N = No validation.

  • Y = No duplicate numbers allowed for the same vendor. An invoice created in one of these forms cannot be saved when the invoice number is the same as a different bill record for the same vendor.

  • A = No duplicate numbers allowed for the same vendor within the same Account Period. An invoice created in one of these forms cannot be saved when the invoice number is the same as a different bill record for the same vendor in the same Account Period.

When auto-numbering invoices:

  • If neither CFGCheckDuplicateInvNoInOps nor CFGCheckDuplicateInvNoInAct is enabled, invoice auto-numbering considers only AP invoices when auto-numbering an AP invoice, or only AR invoices when auto-numbering an AR invoice.

  • If either CFGCheckDuplicateInvNoInOps or CFGCheckDuplicateInvNoInAct is set to either Y or A, invoice auto-numbering considers both AP and AR invoice numbers.

Append R to Reversal Invoice Number
CFGAppendRToReversalInvoiceNumber

When enabled with CFGCheckDuplicateInvNoInAct, adds -R to the end of the invoice number of a reversed AP invoice. When disabled, the reversed AP invoice number remains the same as the original.

Require Reference No for
CFGActRequireRefNoFor

Defines a comma-separated list of invoice types for which Reference No. is mandatory when posting.

Reference No Format
CFGActRefNoFormat

Specifies the format for the Reference No. field when CFGActRequireRefNoFor is used.

Enable Invoice Sub Types
CFGEnableInvoiceSubTypes

Adds an Invoice Subtypes form to the Data Center, through which you can define invoice subtypes that can then be selected in a Subtype field on this form.

Use Company Lob Trade Area Hierarchy
CFGUseCompanyLobTradeAreaHierarchy

Sets up a hierarchy between Company, LOB, and Trade Area on several forms.

Require Rem Bank on AR Posting
CFGRequireRemBankOnARPosting

Remittance Bank must be entered before posting an AR Invoice.

Ignore Currency Match on Bank Selection
CFGIgnoreCurrencyMatchOnBankSelection

Removes the restriction of Remittance Bank currency being the same as the invoice, so all the bank accounts linked to the vendor are available for selection.

Enable Save Only
CFGActEnableSaveOnly

When enabled, a Save button is available on the Transaction Data Entry form. Using it creates a new invoice status V (these types of transactions should be numbered using the VVVV company code). A Reject button deletes these provisional invoices and also resets the bill items.

No Default Reversal Date
CFGActNoDefaultReversalDate

For reversals, leaves the reversal date blank for entry, rather than defaulting to the current date.

Block Closed Voyage Invoice Reversal
CFGBlockClosedVoyageInvoiceReversal

Prevents reversing an invoice that is linked to a closed voyage.

Require Reversal Reason
CFGActRequireReversalReason

A posted transaction cannot be reversed without selecting a Reversal Reason.

Enable Merged Statement
CFGActEnableMergedStatement

When enabled, multiple invoices can be posted as a merged statement if Invoice Type, Counterparty, Currency, and Company match.

Enable Accounting Date Warning
CFGActEnableAccountingDateWarning

Displays a warning if a future date is entered into the Accounting Date field on the Transaction Data Entry and Journal Entry forms.

Enable Auto Propagate Tax Code
CFGActEnableAutoPropagateTaxCode

Note: CFGEnableTaxGroup must also be enabled.

When the tax code for the first line item is added, the tax codes for the remainder of the line items are automatically populated with the same tax code; when a tax code is added on the Operations View tab, its Port column is automatically populated.

Invoice No Char Limit
CFGInvoiceNoCharLimit

Sets the maximum number of characters allowed in the Transaction Data Entry invoice number upon posting.

Cache Invoice Xml
CFGActCacheInvoiceXml

Caches a copy of an invoice when it is reversed. The cached copy will be used for printing the reversed invoice.

Invoice Reversals by Type
CFGInvoiceReversalsByType

Specifies whether the control of invoice reversal by type is enabled or not. When enabled, on the Object Rights tab in Security, an Invoice Reversal Types control list is added to grant users rights to reverse specific types of invoices.

Invoice Date Warning Months
CFGInvoiceDateWarningMonths

Enables a warning message when an Invoice Date is too far in the future.  To indicate how many months after the current date of saving or posting is acceptable, e nter a number greater than 0. Invoice Dates outside this range will trigger a warning but still allow the user to save or post.  To disable the warning, e nter 0.

Operations Enable Cycle Payments
CFGOpsEnableCyclePayments

If an operations invoices has a Payment Terms field, you can set up Cycle Payment, which calculates up to four Due Dates per month.

To set up Cycle Payment, do the following:

  1. Edit configuration flag CFGOpsEnableCyclePayments: Replace the Value with no more than four monthly Cycle Payment days, separated by commas. For example, enter 1,15 if payments are made on the first and fifteenth day of every month.

    • Days past 31 will be ignored.

    • If 29, 30, or 31 is entered, months with fewer days will use the last day of the month.

  2. On the Payment Terms form, a Cycle Pmt column appears. To enable Cycle Payment for a Code, select the Cycle Pmt check box in its row.
    When an operations invoice uses a Payment Term with Cycle Payment enabled, Due Date = Period Basis + Period (rounded up to the next Cycle Payment day).

Restrict Pay Invoice for Payable Transactions
CFGRestrictPayInvoiceForPayableTransactions

When enabled, the user is blocked from clicking the Pay Current Invoice button on the Transaction Data Entry form for AP type invoices. In addition, a new Pay AP Invoices security right is added to Financials > Actions, which grants users the ability to click the button again.

Enable Modify TDE Accounts
CFGEnableModifyTDEAccounts

When enabled, a new Module Right "Modify Credit/Debit Accounts on TDE Form" is available. Only users holding this module right have the ability to modify the Account and Credit Acct columns in the Invoice Details grid of the TDE Form's Accounting View tab, as well as the AP/AR Account No. field in the header of the same form.

APAR Invoice No Generation Unified
CFGAPARInvNoGenerationUnified

If enabled, autogeneration of AP invoice numbers takes into account existing AR invoice numbers, and vice versa; in other words, AP and AR invoice numbers are generated from a single unified pool of numbers, and once used for an invoice of one type are unavailable for use by the other type.

Invoice Reversal Approval Needed
CFGActInvoiceReversalApprovalNeeded

Specifies how many approvals are needed before reversing an invoice. If it is set to a value greater than 0, indicating that approvals are needed in advance of reversing an invoice:

  • The Reverse button on the Transaction Data Entry form is renamed Approve Reversal until the requisite number of approvals have been gathered.

  • A Reject Reversal button is available next to the Approve Reversal button to reject previous reversal approvals and change the invoice back to its initial state.

  • On the Transaction Summary, a Reversal Approval Status column displays Partial or Full, as applicable, for any invoices that have accumulated reversal approvals but have not yet been reversed.

Access TDE Form from Operations Invoice
CFGAccessTDEFormFromOpsInvoice

Note: CFGEnableTaxGroup must also be enabled.

When enabled, you can access the Transaction Data Entry form by clicking  on the toolbar of receivable Claim, receivable demurrage/despatch, Time Charter Bill, Voyage Other Revenues and Expenses (Types Revenue and Rebillable Expense), Other Revenues And Expenses By Daily Rate (Type Revenue), and Freight Invoice forms, which can be useful for entering multicurrency tax information.

Enable Tax Group
CFGEnableTaxGroup

Enables the Tax Rate form in the Data Center, which allows for the grouping of taxes for the Transaction Data Entry form.

Require Tax Code
CFGActRequireTaxCode

Note: CFGEnableTaxGroup must also be enabled.

Sets the Tax Code field on the Operations tab of the Transaction Data Entry form as a mandatory field. If it is set as mandatory, it is not possible to post the transaction if any of the line items has a blank Tax Code.

Enable Invoice Det Proration by Itinerary
CFGEnableActInvDetProrationByItin

When enabled, turns on functionality in the system to allocate voyage related invoice detail amounts to related cargo itinerary line items, prorated by quantity. This includes a new Cargo Itinerary Allocation form, accessible from the Transaction Data Entry and Journal Entry forms.

Enable Edit TDE and Journal Accounts Entry
CFGEnableEditTDEandJournalAccountsEntry

This flag provides two new security permissions: Edit Account on Transaction Data Entry and Edit Account on Journal Entry. These new permissions can be set to allow or deny users the ability to edit the accounts on the individual forms. This flag is independent of and supersedes the already existing CFGEnableModifyTDEAccounts flag.

Still need help? Visit the Veson Nautical Help Center.

Copyright © 2017-2024 Veson Nautical LLC All Rights Reserved - Privacy Notice | End User Terms of Use