Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Short Description

ExcerptThe Hire Payable module automatically retrieves all payable items to an Owner on a detailed level from across Dataloy VMS for Time Charter Contracts (all other payables are handled in Accounts Payable). Once retrieved, the payable items can be reviewed, assembled into invoices and posted to an accounting system. The module provides information about each payable item, based on already available data in Dataloy VMS, for example type of invoice, who the invoice is from, the amount, etc.

Hire payables can, for most business organisations, be defined as accounting transactions handling the invoices due/owed to Owners of vessels under a time charter contract - but is yet to be paid. All invoices are required to be paid within an established timeframe (or payment terms). As time charter contracts are set for a specific timeperiod - not voyage or voyages, the charter hire payables can span multiple vessels and voyages.

 The module consists of three sections:

...

Under Pending, where all unprocessed invoice proposals are displayed, it is possible to review and edit the Document Line Text, Currency, Exchange Rate Date, VAT Rate and Invoice Party fields of invoice items before - complete or in part – assembling the invoices. If an invoice is assembled only in part, the remainder of the unprocessed items will remain in the Pending section for later processing. Also, if an amount invoiced earlier is greater than the estimated/final amount, a credit note line will appear under Pending. If, however, the invoiced amount is less than the estimated/final amount, an additional invoice line with available data will be generated. Once assembled, i.e. details such as bank account, payment terms, etc. have been entered, an invoice is complete and ready for posting. When posting an invoice (or payment advice) to an accounting system Dataloy VMS automatically generates an invoice number (with sequential numbering depending on year and type of transaction (for set-up and control: Fiscal Years)).

When Assembling assembling an invoice, Dataloy VMS allows for two types of payment terms -  either in full (100%) or partial (for example: 95% first, 5% later). The payment terms can be set up in two ways: the default mode where one document line is generated with the full amount (and posted to accounting where there is integeraton) with the amount to be paid later automatically deducted when the initial invoice is printed. A second document line or invoice for the remaining amount cannot be generated. Only in a printed Statement of Account (SoA) will the remaining amount be visible (and from there collect the remining amount). The second option will generate two document lines, one for each payment that will be posted to accounting (and printed) separately showing the respective percentage and amount to be paid. Note: To activate this option, please contact Dataloy. It is, however, not possible to alter the payment terms once the invoice has been assembled. If changes to payment terms are needed, the invoice must then be dissolved and then re-assembled once changes have been made.

Also, when assembling an invoice for a voyage on a TC contract, the voyage cannot be closed. If it is, the Assemble Invoice button will automatically be disabled. To assemble invoices for closed voyages on TC contract the voyage must be re-opened be able to assemble the invoices in Hire Payable. Also, assembling invoices is only possible for one company at a time. The VMS will automatically check if there are more than one company involved amongst the document lines being assembled. If there are more than a single company, the user cannot proceed assembling the invoice. A pop-up will open stating it is not possible to assemble multi-company invoices and that the user must ensure that the invoice to be created is a single-company invoice before an invoice can be assembled. It is also possible to have the same prefix and sequence number for advance payment requests as for the invoice numbering in order to avoid numbering conflicts. Invoice numbering is numberic and consists of eight characters. If the same time charter (TC) In has been invoiced with two or more different invoice parties (or Owners) all invoiced items will appear in the Hire Payable module, not in Accounts Payable.

Dataloy VMS allows for two methods of cancelling/deleting an invoice: dissolve and reverse. Assembled invoices can be dissolved and the items are returned as unprocessed to the Pending section. Once an invoice is posted it is not possible to dissolve and return an invoice to either the Assembled or Pending sections. The invoice must be reversed. Reversing an invoice will automatically generate a reversing document to be sent to relevant accounting system and to be displayed in the Posted section together with the original invoice (or payment advice). However, it is not possible to reverse invoices if they are payments, are linked to closed voyages (needs to be re-opened first) or the invoices have no document type (contact Dataloy so document type/s can be added). The module also allows for both partial and complete reversal of offhire invoices. Note: If accounting transactions including VAT lines are not properly posting to an accounting system then accounts for VAT Payable have not been mapped or mapped properly. Rectify in the Accounts module. Also, when reversing an invoice the original due date will be stated and be exactly the same as on the original document.

The Hire Payable module provides draft and final payment advice (or invoice) print options and the possibility to generate a Statement of Account. Once a printout is generated, a payment advice or Statement of Account will display as an electronic printout in PDF-format. The Statement of Account displays a generated overview of all posted invoices, credit notes, payments and receipts and outstanding amounts. Note: If a bank style is balanced the VMS automatically removes it from the Statement of Account. Also, Various Cost/Revenue commission is not always included with the hire commission on a Statement of Account (SoA), but with the Various Cost/Revenue itself. Location: Modules > If a SoA is printed for a time charter (TC), the vessel redelivery time show under the delivery date - once the vessel is redelivered. Also, if the same time charter (TC) has been invoiced with two or more different invoice parties (or Owners) all invoiced items will show in the SoA with the present owner as business partner.

Location: Modules > Post Fixture > Hire Payable

Chapter ContentsChapters:

Table of Contents
maxLevel4
minLevel4
absoluteURLtrue
typeflat

Long Description

...

Generate, Assemble and Post an Invoice/s

  1. Open the time charter (TC) contract to create an invoice for. TC contracts can be opened either directly in the Hire Payable module or via the Booking and Operations module.
    1. Either open a TC contract
      1. directly in Hire Payable:
        1. Go to Modules > Post Fixture > Hire Payable.The Hire Payable window will openopens.



        2. Click Open TC Contract... A pop-up with a list of TC contracts will openopens.
        3. Click selected TC contract - it will highlight.

          Example:



        4. Click OK. The pop-up will close and all pending invoice proposals associated to the opened TC contract will display - grouped by business partner and currency - in the upper field under Pending.. The bottom field displays the detailed invoice items of each pending invoice respectively.
        5. Go to Step 2.
      2. or through Booking and Operations:
        1. Go to Modules > Booking and Operations > Booking and Operations.The Booking and Operations window will openopens.
        2. Select applicable vessel in the right-hand upper field - it will highlight. The vessel's details will display displays across the screen.
        3. In the Voyage List, select the voyage to be opened - it will highlight.
        4. Go to Invoicing and from the drop-down menu select Hire Payable.



        5. The Hire Payable module will open opens on a separate screen displaying all pending invoice proposals associated with the opened voyage/s will display - grouped by business partner and currency - in the upper field under Pending. The bottom field displays the detailed invoice items of each proposed invoice respectively.
        6. Go to Step 2

  2. Anchor
    HIRE1
    HIRE1
    In the Pending section's upper field, select the proposed invoice to assemble an invoice for - it will highlight. The bottom field will display the detailed invoice items of the proposed invoice.

    Example:



  3. Review and edit (as appropriate) each invoice item, either in
    1. the default group view:

      Example:



    2. or click Toggle View to display the detailed invoice items in Flat View.
      Note: Flat View will list all invoice items of the pending invoices listed, while the default group view will only list those belonging to one pending invoice at a time.

      Example:



    3. To filter, click the magnifying glass icon at the top-right corner. A row will display above the columns. Filter as applicable, by for example port, booking number, etc.
    4. Review/edit/update displayed invoice items (as appropriate) by selective or by bulk update.
      Note: Only the Document Line Text, Currency, Exchange Rate Date, VAT Rate and Invoice Party fields can be edited.
      1. Selective:
        1. revert the source of the invoice item data, for example, estimates, operational data, etc.
          1. Edit data.
          2. Return to the Accounts Receivable module and click Reset Data to refresh the items list.
        2. or click the relevant field of the invoice item to be edited- it will highlight - and edit.
          Note: ALL modifications using this method to override data generated by the system will be LOST if Reset Data is at any time used after editing. 
      2. Bulk Update:
        1. Click Bulk Update... The Bulk Update - Document Lines dialogue box will open.
          Note: Click Switch Layout to alter the dialogue box layout. Click again to revert to default layout.

          Example:



        2. In the upper field filter (as appropriate) so only the records to be edited display.
        3. In the lower field select the field to modify.
          NoteThe fields and drop-down menus are disabled by default until checked. The Modify Records button will activate once a field is checked.

          Example:



        4. Click Modify Records. The changes will apply to all bulk edited records.
        5. Click Close. The dialogue box will close.
      3. Deselect the checkbox/es of invoice items not to be included in the invoice (if any) under the Select column either in the default grouped view or in Flat View.
        Note: To deselect several - click Deselect All - then filter so only relevant rows display (items to be included) and click Select All.
    5. If reivew/edit/update if performed in Flat View - click Toggle View to return to the default grouped view. Any changes made will apply.

  4. Anchor
    qa3
    qa3
    Click Assemble Invoice... The Document Details dialogue box will open.
    Note: The Assemble Invoice button will be disabled if the voyage is closed (on a TC Contract). To enable: re-open the voyage and assemble the invoice/s.

    Example:



  5. In the dialogue box, fill in the fields as follows:
    1. Enter a short description of the invoice under Document Text.
    2. Enter either 
      1. the document date (if other than the default: today's date) under Document Date orDate
      2. or click the Triple Dot Selector next to the field. A pop-up with a calendar will openopens. Select date and click OK.

        Example:



    3. Enter either
      1. the name of the payee under Issuing Company (if other than the automatically populated)
      2. or click the Triple Dot Selector next to the field. A pop-up with a list of input values will openopens. Select field and click OK.

        Example:



    4. Enter either
      1. the bank account number the invoice is to be paid in to under Bank Account (if other than the automatically populated) or
      2. or click the Triple Dot Selector next to the field. A pop-up with a list of input values will openopens. Select field and click OK.
    5. Enter  the invoice number of the received invoice (if applicable) under External Doc. No.
    6. In the Payment Terms field:
      1. Enter the payment percentage number in the % terms field (if other than the default: 100%).
      2. Select length of the payment term in the first drop-down menu and select the baseline term (i.e. from whence the payment term begins) in the second .

        Example:



      3. Enter either
        1. the baseline date (if other than the default: today's date) under Baseline Date
        2. or click the Triple Dot Selector next to the field. A pop-up with a calendar will openopens. Select date and click OK.
      4. Ensure that the date appearing in the the Due Date field corresponds with "the baseline date plus the length of the payment term".
      5. The lower payment and baseline terms fields are ONLY used in case of partial payment. If there is no partial payment - the lower % terms field will by default be 0% and the drop-down menus deactivated.
    7. Click OK. The dialogue box will close and the assembled invoice will move moves from Pending to the Assembled section.
      Note: Any deselected invoice items will remain in the Pending section for later processing.

  6. Click Assembled at left-hand side. The Assembled view will open opens displaying all assembled invoices (i.e complete and ready for posting).

    Example:



  7. Click the invoice to be posted in the upper field - it will highlight.
  8. Click Details... to double-check the invoice details entered when assembling the invoice.



  9. The Document Details dialogue box will open. Review details and then click Close.
  10. Click Print Draft to print a draft invoice.



  11. An Invoice Print Options pop-up will open. Enter details (as applicable) and click OK.
  12. The pop-up will close and a draft payment advice will display as an electronic printout in PDF-format.
    Note: The draft payment advice will look identical to when printing a posted invoice, but WITHOUT the DataloyVMS generated invoice number. This is generated when an invoice is posted.

    Example:



  13. Post an invoice/s either
    1. to an accounting system by selective - (selecting the invoices to be posted) or batch (posting all invoices) posting or
      1. Selective:
        1. Click the invoice row to be posted - it will highlight.
        2. Click Post Invoice. A pop-up will open opens asking to confirm move.



        3. Click OK. The pop-up will close and the selected invoice move to the Posted section with status Ready for Posting until sent to an accounting system. A Dataloy VMS invoice number will automatically generate for the invoice. Once the invoice is confirmed posted in the accounting system, the status will change to Posted.
      2. Batch:
        1. Click Post All Invoices to post all listed invoices - they will highlight.



        2. A pop-up will open opens asking to confirm move. Click OK. The pop-up will close and all invoices move to the Posted section with status Ready For Posting until sent to an accounting system. Dataloy VMS invoice numbers will automatically generate for the invoices. Once the invoices are confirmed posted in the accounting system, their status will change to Posted.
    2. or directly to the Posted folder (without being sent to an accounting system)
      1. Click the invoice row to be posted - it will highlight.
      2. Click Post Invocie. A pop-up will open opens asking to confirm move.



      3. Click OK. The pop-up will close and the selected invoice move to the Posted section with the permanent status Ready for Posting.
        Note: Posting invoices manually requires the manual entry of each invoice into an accounting system. Also: Skip to posted is ONLY used when setting up an new system and there is a need to convert old, already posted invoices into the VMS. Status will immediately be set to posted. If used for new invoices, the invoices will remain with status "draft" and no proper invoice numbers will not be generated. In the accounting system the invoices will show without an invoice number. Re-posting will post the invoice to the accounting system using the draft invoice number.



  14. Click Posted at left-hand side. The Posted view will open opens displaying all posted invoices (i.e. completed) with either status Ready for Posting or Posted. Invoices posted to an accounting system are identified by automatically genrated Dataloy VMS invoice numbers, each number unique per invoice.

    Example:



  15. Options available in the Posted section:
    1. To check Check invoice details:
      1. Click Details... to check the invoice details entered when assembling the invoice.
      2. The Document Details dialogue box will openopens. Review details and then click Close.
    2. To repost Repost an invoice if transfer to an acounting system fails:
      1. Click Repost to post the invoice again.
        Note: This option normally requires Administrator or Super-User access rights.
      2. A pop-up will appear appears asking to confirm posting. Click OK. The invoice will be reposted. 
    3. To manually Manually register payments:
      1. Click Register Payment... The Register Payment pop-up will open:opens.

        Example:



      2. Enter either
        1. the date (if other than the default: today's date) under Date
        2. or click the Triple Dot Selector next to the field. A pop-up with a calendar will openopens. Select date and click OK.
        3. Enter payment amount under Amount.
      3. Click OK. The pop-up will close and and the payment receipt will open opens as a row in the upper field in the Posted section.

        Example:



    4. To manually delete Manually delete a registered payment:
      1. Click a payment receipt row in the upper field - it will highlight highlights and the Delete Payment button activate.
      2. Click Delete Payment. The payment receipt row till be deleted.  
    5. To issue Issue invoice printouts and/or Statement of Accounts - go to Invoice Printouts/Statement of Accounts.

Top

...

Dissolve/Reverse an Invoice

  1. To dissolve Dissolve an invoiceInvoice:
    1. Go to Modules > Post Fixture > Hire Payable. The Hire Payable window will open.
    2. Click Assembled at left-hand side. The Assembed view will open opens displaying all assembeld invoices (i.e complete and ready for posting).
    3. Click the invoice to be dissolved in the upper field - it will highlight.
    4. Click Dissolve Invoice. A pop-up will open opens asking to confirm dissolvement.



    5. Click OK. The pop-up vill will close and the invoice will revert to the Pending section.

  2. Anchor
    To
    reverse
    reverse
    Reverse an invoiceInvoice:
    1. Go to Modules > Post Fixture > Hire Payable. The Hire Payable window
  3. will open
    1. opens.
    2. Click Posted at left-hand side. The Posted view
  4. will open
    1. opens displaying all posted invoices.
    2. Click the invoice to be reversed in the upper field - it will highlight.
      Note: It is NOT possible to reverse invoices
  5. ´that
    1. that are payments, are linked to closed voyages (the voyages must first be re-opened) or have no document type (the Reverse... button will automatically deactivate).
    2. Click Reverse. A pop-up
  6. will open
    1. opens asking to confirm reversal.

      Image Modified

    2. Click Yes. The pop-up will close and an Input pop-up
  7. open
    1. opens.
    2. Enter the reason for the reversal and click OK.
    3. The pop-up will close and a Credit In row
  8. will display
    1. displays in the upper field alongside the original invoice signifying that the invoice has been reversed.

      Example:

      Image Modified

Top

Invoice Printouts/Statement of Accounts

...

Partially Reverse an Offhire

Two methods are possible - changing the original entry (recommended) or reversing and posting a new.

  1. Partially Reverse Offhire by Changeing the Original Entry:
    1. Go to Modules >
    Post Fixture > Accounts Receivable. The Accounts Receivable window will open
  2. Click Posted at left-hand side. The Posted view will open displaying all posted invoices.
  3. Click the invoice to be printed in the upper field - it will highlight.
  4. Click Print and from the drop-dowm menu select Select Transaction...
    Image Removed
  5. An Invoice Print Options pop-up will open. Enter details (as applicable) and click OK.
  6. The pop-up will close and an invoice will display as an electronic printout in PDF-format including the automatically generated Dataloy VMS invoice number.
    Example:
    Image Removed
    To issue and print a Statement of Account:
    1. Bookling and Operations > Offhire Browser. The Offhire Browser window opens.
    2. Locate applicable vessel. Its details displays in the lower field.
    3. In the Offhire Details tab either change
      1. the entered offhire satrt and end dates under Offhire Start Date and Offhire End Date
      2. or the number of days under Offhire Days
      3. or the percentage under % (percentage).

    4. Go to Modules > Post Fixture >
    Accounts Receivable. The Accounts Receivable window will open
    1. Hire Payable. The Hire Payable window opens.
    2. Open applicable voyage. The change registers as a cost under Pending.

  7. Changing Offhire by Full Reversal and Posting a New:
    1. Go to Modules > Post Fixture > Hire Payable. The Hire Payable window opens.
    2. Click Posted at left-hand side. The Posted view will open opens displaying all posted invoices.
    3. Click Print and from the drop-down menu select Statement of Account...
      Image Removed
    4. A Print Options pop-up will open. Enter details (as applicable) and click OK.
    5. The pop-up will close and a statement of account will display as an electronic printout in PDF-formatthe invoice to be reversed in the upper field - it will highlight.
    6. Click Reverse. A pop-up opens asking to confirm reversal.
    7. Click Yes. The pop-up will close and an Input pop-up open.
    8. Enter the reason for the reversal and click OK.
    9. Go to Modules > Bookling and Operations > Offhire Browser. The Offhire Browser window opens.
    10. Enter a new offhire where applicable in the Offhire Browser.
    11. Go to Modules > Post Fixture > Hire Payable. The Hire Payable window opens.
    12. Open applicable voyage. The reversed invoice show as a cost to the user whilst the new a cost to the Owner.

Top

Invoice Printouts/Statement of Accounts

  1. To Print an Invoice:
    1. Go to Modules > Post Fixture > Accounts Receivable. The Accounts Receivable window open.
    2. Click Posted at left-hand side. The Posted view opens displaying all posted invoices.
    3. Click the invoice to be printed in the upper field - it will highlight.
    4. Click Print and from the drop-dowm menu select Select Transaction...

      Image Added

    5. An Invoice Print Options pop-up opens. Enter details (as applicable) and click OK.
    6. The pop-up will close and an invoice display as an electronic printout in PDF-format including the automatically generated Dataloy VMS invoice number.

      Example:

      Image Added


  2. To Issue and Print a Statement of Account:
    1. Go to Modules > Post Fixture > Accounts Receivable. The Accounts Receivable window opens.
    2. Click Posted at left-hand side. The Posted view opens displaying all posted invoices.
    3. Click Print and from the drop-down menu select Statement of Account...

      Image Added

    4. A Print Options pop-up opens. Enter details (as applicable) and click OK.
    5. The pop-up will close and a statement of account display as an electronic printout in PDF-format.
      Note: If a SoA is printed for a time charter (TC), the vessel redelivery time show under the delivery date - once the vessel is redelivered. Also, if the same time charter (TC) has been invoiced with two or more different invoice parties (or Owners) all invoiced items will show in the SoA with the present owner as business partner.

      Example:

Top
Back

Related Content

Expand
titleExpand to see related content

Wiki Markup
{dynamiccontentbylabel:showLabels=false|showSpace=false}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

...