Brightwell Interface

2022.20.0.6

Jan 10, 2023 

Fixed the issues with disabled export button for Non Superuser

Fixed ‘Tag all/Untag all' buttons

Added the possibility to leave the Date field empty. In such case the Release_Date field in the export file will also be empty

Added the possibility to define the ‘Location’ field in the setup. This field is mandatory, and error will appear if the field is empty.

Changed the rule of the truncating First Name and Last Name fields:

• FirstName should be truncated to 20 chars if exceeds;

• LastName should be truncated to 20 chars if exceeds

2023.10.1

Jan 24, 2023

1. Entity Interface Id; added the possibility to define multiple Company Entity_Interface_id. In the configuration screen, you find a new tab, Entity Id, enabling you to link payscale tables to an Entity ID.

2. Fixed the file name format; when exporting advanced and additional payments, the system generated the wrong file format. 
   File Name Format: 
   payment{custID}{optional client-defined data}{MMDDYYYYhhmmss}.txt
   The section {option client defined data} contains the information if it is advanced, addition or payment, the currency and company entity.

3. Added the possibility to save the payment and enrollment files in two different directories—see Setup> General > Export Directories to select the directories to be used.

4. Brightwell accepts the European Nation ID Card if the person does not hold a passport. 
   In Setup> Generate, you can select the travel book code identifying the ENID.

5. The Brightwell interface supports adding multiple Company Entity_Interface_ID’s in one export file as separate batches. We have added the option “Slit export files by Entity ID in Setup > General. If checked, the plugin creates one export file for each entity id, adding the entity id to the section {option client defined data} of the file name..

6. Brightwell does not support multiple currencies per account. If a person shifts from one currency to the next, the person needs to be enrolled once more in the new currency with a new unique identifier. We solved this by adding the currency to the PIN. Sample Pin=1234, Currency=USD => Brightwell Account no=1234USD.

   1. Switch on the option 'Allow multiple accounts based on currency' in Setup> General.

   2. In the candidate's tab, we added the following columns; Payscale Currency, Account.

   3. Updated the enrol functionality; only enrol persons linked to the selected currency.

   4. In the waiting for card tab, we improved the Card Received functionality by linking The bank account to the newly formatted account, Pin + Currency.

2023.10.2

Jan 24, 2023

APMPI-768

• We have added new option 'Allow multiple accounts based on currency';

• If the option is turned on, USD/EUR enrollment doesn`t change P0Y.Currency;

• If the option is turned on, EUR/USD Enroll works only for persons, who have the same currency on the Payscale table used for the activity;

• If the option is turned on P0Y.DEBIT_CARD_ACCOUNT_NO will become PIN+<PayscaleCurrency> after enrollment;

• Payscale currency can be checked in the new added Payment currency column;

APMPI-810

Changed the format for the export files.

If the option ‘Split Export Files By Entity Id’ turned off:

Registration file
registration{Customer Id}_brightwell{MMDDYYYYhhmmss}.txt

Net Payment file
payment{Customer Id}net-{Currency}{MMDDYYYYhhmmss}.txt

Advance Payment file
payment{Customer Id}_advance-{Currency}_{MMDDYYYYhhmmss}.txt

Additional Payment file
payment{Customer Id}_additional-{Currency}_{MMDDYYYYhhmmss}.txt

If the option ‘Split Export Files By Entity Id’ turned on:

Registration file
registration{Customer Id}{EntityId}-_brightwell_{MMDDYYYYhhmmss}.txt

Net Payment file
payment{Customer Id}{EntityId}-net-{Currency}{MMDDYYYYhhmmss}.txt

Advance Payment file
payment{Customer Id}{EntityId}_advance{Currency}_{MMDDYYYYhhmmss}.txt

Additional Payment file
payment{Customer Id}{EntityId}_additional{Currency}_{MMDDYYYYhhmmss}.txt

APMPI-811

From now payroll field Text(L38) will be fetched to the payment files in the Detail_Record_Type section.

APMPI-802

The field 'Payment Type' moved to the main Setup window.

2023.10.3

Jan 27, 2023

APMPI-803

Fixed the situation, when Brightwell balance action was not changed to Cash for Advance and Additional entries, after persons exclusion from Brightwell interface.

APMPI-812

Fixed problem with 'Tag All' button. Now it will select only the records with all required information.

APMPI-809

Changes for whole consistency of the warning messages on all plugin`s tabs.

2023.10.4

Jan 30, 2023

APMPI-814

Changed the account no into ['E'|'U']+PIN instead of PIN + ['EUR'|'USD']

APMPI-817

The system add the correct email notification address to enrollment and payment export.

APMPI-818

To avoid misunderstanding, we renamed the column Payment Currency to Enrollment Currency in the following tabs: Candidates, Waiting for Cards, Members, and Exclusion.

In the payment tabs, net, advanced and additional, we added the column Enrollment Currency. From the payment tab, it is only possible to export a person whose payment currency equals the enrollment currency. The system highlight ignored payments. To get the payments through, the user needs to change the payment currency in the payroll and recalculate or enrol the person in the correct currency program.

2023.10.5

Feb 8, 2023

APMPI-823

Added new column 'Vessel':

• On the Candidates, Waiting for Card, Members and Exclusion tabs it is fetching vessel from the activity;

• On the Net, Advance and Additional Payment tabs it is fetching DIM2 from the entries.

APMPI-824

Added right-click menu for the grids.

Some standard functionalities, like ‘Export grid’ to different file formats(HTML, XML, Excel, Text), Alignment, ‘Print grid’ and others, can be found in this menu.

Menu is accessible using right-click on the columns headers.

APMPI-825

Added new option 'Exclude Net Payments'.

When the option is turned on:

• Net payment tab will be hidden;

• Person`s balance action will not be changed to Brightwell while enrollment;

Open

Advanced and Additional payments missing bank account

Because the payment tab balance action is different from the Brightwell balance action, the user is missing the possibility to copy the details from the payment tab when adding an advanced or additional entry.

We will advise the customer to link the entry code to a Common Payment Receiver. The common payment receiver should use the balance action, Brightwell.
When calculating these payroll entries, the user should not have to enter the bank account. But the plug-in will use the debit_accountno as this is the same as the Brightwell bank account.

Example Customer Configuration

Open

Create a new contact Brightwell Debit Card, and type Payment Receiver.

 

When using the entry code, the balance action is prefilled.

As you can see, the bank account is not displayed and does not exist on the Entry Code.

 

APMPI-826

Added new column 'Payscale Currency'.

New column available on the Payment tabs and fetch the currency from the Payscale table used on the entries in Payroll.

Records with different Payscale, Payment and Enrollment Currencies will be marked red and warning message will prevent processing such payments.

2023.10.6

Feb 20, 2023

APMPI-816

Adjustments to increase Brightwell plugin performance.

APMPI-820

Added possibility to select field to fetch Comment from.

2023.10.7

Mar 24, 2023

APMPI-835

Location fie ld enhancements:

• Added the possibility to select Interface code in Setup. Selected Interface code will be used to find XREF codes on the Vessels. These Xref codes will be fetched to persons as locations;

• Usual Location field from Setup will be used for persons, who are linked to the Vessels without defined Xref codes;

• Added the possibility to create locations list in the Setup;

• Added functionality to overwrite location codes using the values from the locations list;

• Added possibility to reset overwritten locations;

• The system will remember overwritten locations for each enrollment currency. Means the same person can have different locations for USD and EUR;

• Added Location column to Candidates, Waiting For Cards, Members and Exclusion tabs;

• The same locations, as shown in the grid, will be fetched to enrollment files;

APMPI-840

Registration grids modifications:

• Department column has been added to Candidates, Waiting for Cards, Members, Exclusion tabs;

• Activity Text column has been added to Candidates, Waiting for Cards, Members, Exclusion tabs;

• Sign Off column will fetch Estimated End Date from activity, when Date To is empty;

Payment grids modifications:

• Account Dim 3 column has been added to Net Payment, Advance Payment and Additional Payment tabs. It can be used to fetch department from the Entries.

2023.10.8

Mar 31, 2023

APMPI-834 - Added the functionality to link a Product Group Alias to a payment currency (USD, EUR). Implemented separate tab that give possibility to define Product Group Alias for inputted currency code on Setup form.

APMPI-880 - Fixed issues with date columns filtering

APMPI-881 - 1) Bank Account No. is taken from P0Y.DEBIT_CARD_ACCOUNTNO. If its empty then Bank Account No. is taken from PAI.ACCOUNTNO

2) Fixed “Name” column to show correct data,

2023.10.9

Apr 10, 2023

APMPI-839

• Moved Card Stock Override Code from Setup to Plugin`s ribbon;

• Fixed problem with fetching Card Stock Override Code to Enrollment files;

APMPI-883

Fixed situation when persons without SSN, but with Passport, were marked as unavailable.

2023.10.10

May 3, 2023

APMPI-738 - Added the possibility to allow/deny access for different tabs in Brightwell. It can be done from plugin`s Setup.

• 'None' access means that tab will be hidden for corresponding level;

• 'Read' access means that a user with corresponding level can open the tab and check information there, but cannot change anything or process any files;

• 'Write' access means that a user with corresponding level will have full access to the tab;

• By default access rights for all security levels are ‘None’, except the level 99;

• For ‘Setup’ button, access can be granted or denied;

APMPI-846 - USD/EUR enrollment replaced with enrollment based on Payscale currency.

When a user clicks Enroll, the system will automatically enroll all selected crew members with the corresponding currency.

APMPI-836 - Added new field ‘Response Preference' in Setup with possibility to select 'Email', 'Echo', 'Both', 'None’ values:

Selected value will be fetched to export files to the field RESPONSE_PREFERENCE under the FILE_HEADER_RECORD_TYPE section.

2023.10.11

Jun 1, 2023

APMPI-905 - Fixed the issue, when filtered out persons can be tagged while using Tag All.

APMPI-906 - Fixed the issue, when the export confirmation pop up window doesn’t appear.

APMPI-890 - Added the possibility to define separate Payment Types for Net, Advance and Additional payments.

APMPI-902 - Included Zip codes fetching to the plugin`s grid and enrollment files for non-USA employees.

The validation stays the same - ZIP only mandatory for the USA residents.

APMPI-904 - Excluded persons are no longer shown on the Candidates and Members tabs. Only on the Esclusion tab

APMPI-911 - Adjusted notification message for the persons without access to Brightwell.

2023.10.14

Oct 20, 2023

APMPI-915 - The calculation of total amount of entries has been adjusted in the following way:

• If none of the crew members are tagged in the grid, all entries are summed up.

• If a user tags some records, only tagged entries are summed up.

• On filtering records, only filtered entries are summed up.

APMPI-947 - Fixed the performance issue occurred when a user tries to tag/untag a number of payment transactions.

APMPI-974 - Enhanced the logic of processing data in Brightwell:

• If the Allow multiple accounts based on currency option is selected, the Account No field (P0Y.DEBIT_CARD_ACCOUNT_NO) has the First Currency letter + PIN value.

• If the Allow multiple accounts based on currency option is selected, the EmployeeId field in the generated file has the First Currency letter + PIN value.

• If the Allow multiple accounts based on currency option is not selected, the Account No field (P0Y.DEBIT_CARD_ACCOUNT_NO) has the PIN value.

• If the Allow multiple accounts based on currency option is not selected, the EmployeeId field in the generated file has the PIN value.

• If a person is enrolled but does not have the predefined Payment currency, the person gets removed from the Candidates tab.

Besides, in case the currency is not predefined, the value is fetched from P01.

Note: If the Currency Payment != Payscale Payment, then after enrolling crew members, the Currency Payment will be changed to the Payscale Payment.

2023.20.1

Oct 20, 2023

APMPI-1034 - GUID is now used instead of int for SeqNo field

2023.20.2

Jan 19, 2024

APMPI-1130 - Fixed the Catastrophic failure error while running the Brightwell plugin.