Date of production synchronization server patch: 25th September 2024 / 18:00 Geneva time
Latest user rights files updated: UF34.1 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
This issue, spotted by OCG was a bug affecting the display of certain figures on PDFs such as Freight Manifest in the SHIP, the Destruction report and the PO merged report, meant that the figures were obscured due to overlapping, and this was caused by a change to how the figures were rounded, and is linked to previous migration of python version. This has now been corrected and these reports are now displayed correctly.
We have added an additional check for the import from Homere to Unifield: If the name, code terrain and id staff are the same in PERMOIS and in UF, but 2 records exist in UF, add also a check on the uuid and allow the import of Permois if it matches.
Date of production synchronization server patch: 11th September 2024 / 18:00 Geneva time
Latest user rights files updated: UF34.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
Continuing in the direction to encourage use of catalogues, these tickets facilitate catalogues to be more user-friendly by allowing one supplier to have multiple valid catalogues. The main constraint is that the concurrent catalogues must have different products. The dates can overlap or be different. Blocking warning will be displayed if users try to import or create manually new catalogues with duplicate products or if they try to update existing ones with duplicate products. Other modifications included are that now all catalogues will have From & To dates visible at header level and these can be changed in instance where they were created. Previously, where a catalogue had an empty “To Date” this was automatically filled when a more recent catalogue for the same supplier was added. With these tickets there is now no automatic filling of To Data done by system.
Initially raised via discussions with Pharma and in order to align more closely with Pharma guidelines as well as operational needs of Supply, a new Order Type (OT) and Reason Type (RT) “Programmatic Donation” has been added to FOs and their associated transport documents. This Order type can be selected in FOs and there will be a non-blocking warning message indicating that goods flow out will be considered as consumption. FO with this OT must have an external partner and the FO can be sourced normally in the OST to any other purchase doc or from stock as per other FOs. Any transport documents (OUT, Pick etc) associated with an FO with this order type will also have the Reason Type “Programmatic Donation” and their goods will be considered to have been consumed, and their quantities will be included in the consumption calculation. This additional Order / Reason type has been added to relevant existing reports.
The Order/Reason Type previously know as “Donation before Expiry” has now been renamed as “Donation to prevent losses”. There is no change to how this OT/RT can be selected or used. All documents with previous OT/RT have been migrated to new name.
The existing Donation report has been updated to include filters for the possible Donation types.
The electronic validation module continues to be refined and improved with these tickets. In the Supply documents IR, PO and FO, signatures will be allowed to be added only in Draft and Validated status. Other documents remain without this constraint and can be signed no matter their status.
2 corrections have been made so that i)when documents are partially signed and then decision to sign offline is taken, all previous signatures & signee roles are now fully wiped from document. Track changes still keeps a record of these changes. ii) There is now no duplication of roles displayed for when a document which has its order of signees defined, has an attempt made signee whose role is not the next sequential signee allowed to sign.
With this ticket, merge of product behaviour is aligned so that for all pairs of products where merge is possible, the merge can be done even when both products have been used. Previously this scenario was possible only for merge of 2 UniData products at HQ. With this ticket merge is possible also at Coordo when both Local & UniData product have been used.
With this ticket the following fields in the Product record at Coordo will not have their values overwritten by any synch updates (from HQ etc): “Procurement method”, “SoQ Quantity”, “Field description”, “Purchase description” “Procurement lead time”.
Additionally, for any change to the field “Procurement method” Track changes has been added.
(The relevant User Rights ticket for access is being progressed in parallel.)
This ticket aims to ensure PO and FO documents created by synch are more transparent for users when they contain lines for products which do not exist in the instance. When such lines are created in a PO/FO, the “Comment” field will be filled with the code & description of the product according to the other instance, as well as any comment they added to the line. The line will be in red & contain a warning icon, if line pop-up is opened it will direct user (according to the product type) for how to handle situation (subscribe in UniData / see with mission etc). There will be a Not Run message for this case. If product is then created in instance (e.g. Subscribed to in UniData & synched down) then the Not Run will pass and the document line will be updated at next synch. If product remains inexistant user may choose to cancel the line from the PO/FO. Without any recognised product, the document line cannot be processed further.
Exported pick lines will no longer display cancelled lines, the user will only be able to see lines with other stock moves states in the export, which is consistent in case the user needs to import pick.
More filters have been added to both “Export IR Follow-Up” and “Field-order Follow-up” to give better visibility of these documents, the filters are consistent with the relevant IR/FO that contains these fields.
In both PO and RFQ the user will no longer be able to edit the currency through the “Currency” field, the only option to change the currency will be through “Change Currency” button.
In all the following documents IR/FO/PO a new filter option has been added for the document lines filter. New option: “Show validated only”, when selected will display only lines with validated state.
With this dev, product unit/cost prices are more transparent in INs and Shipping process: unit price of product is now displayed for each line on incoming shipments (INs) and also in Shipments Pre-Packing List (SHIP PPL line pop-up). How and when these prices can be modified and are calculated remains unchanged, there is just better visibility of them in these documents.
This ticket corrects an issue linked to Claim flows where as soon as a Claim was processed where replacement goods were expected, the Claim created an IN-replacement (IN to receive these goods) but if the original PO on which claim was raised continued to have further lines Confirmed, system was assigning these extra lines to the Claim IN rather than the IN linked to the regular PO flow.
3.1 (US-12438) Fixed assets: To improve the filter in the Journal items of the assets forms : journal + instance (HQ-OCBAF101)
We have improved the filters for the journal items of the assets forms as follows:
3.2 (US-12479) Fixed assets: mandatory to have analytical distribution AD before the status OPEN (and just after status Draft)
It is now mandatory for an asset to have a valid analytical distribution (AD) before it can be set to “OPEN” status. If the analytical distribution is not valid, the asset cannot be moved to “OPEN” status.
If the analytical distribution is incorrect, you will receive an error message, and the asset cannot be moved to “OPEN” status.
3.3 (US-12654) Fixed Asset: inactivation of the functionality
With this ticket we have developed that the inactivation from reconfigure is not allowed if any of the following are present:
If you attempt to inactivate the functionality in those cases, you will receive an error message.
3.4 (US-13050) Homere interface – take employee from the new file staff_l
For the Permois import, we currently import a staff file into Unifield. However, some instances had an additional file, staff_l, which was not being considered by Unifield. In this release, we managed the second file by developing a solution to handle the staff_l file. We ensured that the staff_l file is now also imported into Unifield, alongside the primary staff file.
3.5 (US-13096) PAYE SAGA: Import of payroll entries: to improve the error message when there are already draft payroll entries
For the PAYE SAGA import of payroll entries, we have improved the error message that appears when there are existing draft payroll entries.
Updated Error Message:
“You cannot import payroll entries because there are XX draft expense lines and YYY draft balance sheet lines. Please validate the draft entries or click on ‘Delete draft entries’ to proceed.”
This enhancement ensures clarity and provides actionable instructions for addressing the issue.
In cases where the staff name or one of the three fields (id_unique, id_staff, code_terrain) has changed, the PERMOIS import fails. This issue constitutes approximately 50% of the PERMOIS-related problems reported in Jira. We will address this in the UF34.0 release before revisiting the ticket US-9119.
During the payroll import, we have implemented a check to manage changes across multiple fields. If the employee’s name remains unchanged, the system allows the import to proceed; otherwise, it raises an error stating: “Several employees have the same Identification No xxx (import), zzz (UF).”
Additionally, we have incorporated a new check for the UUID. If either the name or UUID has not changed, the import is permitted to proceed.
3.7 (US-10871) For DPO: to allow Down Payment (specific supply case)
Thanks to this ticket we have allowed the down payments in Direct Purchase Orders DPO.
The flow will be this:
Create the PO. Validate it. Sync.
Sync. Create a draft FO. Validate the FO. Source the FO (Proc. Method: On Order, PO/CFT: DPO).
Check the draft DPO in the Purchase Orders tab. Confirm the DPO.
Confirm the DPO (no Invoices created; CV is created). Sync.
Sync. Create the IN.
Proceed with a Downpayment using the DPO in confirmed status (only confirmed status).
3.8 (US-12137) Intermission: to avoid the creation of a manual IVO and IVI with an inactive currency
With this improvement, we cannot create a manual IVO or a manual IVI with inactive currency at the time of creation:
Instance A creates an IVO in a currency not active in Instance B.
Instance A creates an IVI in a currency not active in Instance B.
We have ensured that there is a “not run” when an instance receives an IVI in an inactive currency.
3.9 (US-12283) FY closing check – check if all active project instances have reported Mission closed status for all periods of the FY
For yearly closure:
Before allowing FY closing of a Coordination instance, check if all active project instances have reported “Mission Closed” status for all periods of the FY.
We must exclude decommissioned projects from this check.
Note that P0 and P16 periods are excluded from the check.
We will have an error message to indicate us this:
3.10 (US-12302) Allow to use multiple AD on CV commitment vouchers (changes made on US-11510 for supplier invoices)
We have allowed the use of multiple ADs on CV (Commitment Vouchers), similar to the changes made in US-11510 for supplier invoices.
It can be done by using the Export CV Lines and the Import CV Lines.
3.11 (US-12732) To be able to delete draft entries in mass in the liquidity registers We agreed to introduce the functionality to delete multiple register lines in bulk.
We have implemented here the capability to delete draft entries in bulk within the liquidity registers.
When an import file with 200 lines is mistakenly uploaded, it is currently necessary to delete each line individually.
In the register lines section, users will have the option to select multiple lines. A new button, labeled “Delete Draft,” will be added to the right menu to facilitate the bulk deletion of lines, provided they are in draft status only.
If an attempt is made to delete hard posted entries, a warning message will be displayed, and the operation will be blocked.
3.12 (US-12894) E-Validation: Allow Doc_Creator to Modify Signed Signatures
The proposed improvement allows users with the UR groups Sign_document_creator_supply and Sign_document_creator_finance to remove signees and reassign others across all document types, not limited to Purchase Orders. Users with the Sign_Doc_Creator roles can manage signatures by removing or reassigning signees. Users who have signed a document are restricted to removing only their own signatures, and this action is permissible only in specific statuses defined for signature management. This improvement ensures consistency in signature management across all document types, adhering to defined statuses that control the addition and removal of signatures. Additionally, once a document’s signature process is closed—signaled by clicking the “Close Signature” button and ticking the “Signature Closed” checkbox—no further changes to signatures are allowed.
3.13 (US-13237) Inactive currency to not be available to be used in SI, SR, ISI, ISR, Donation, STV, STR, Customer Refunds and Debit Note
For SI, SR, ISI, ISR, Donation, STV, STR, Customer Refunds, and Debit Notes, we have forbidden the selection of an inactive currency. The development was completed to block the selection of an inactive currency, both with the magnifying glass icon and the “Change” button. Additionally, we implemented a check to prevent opening an invoice with an inactive currency for documents that were already created.
3.14 (US-13264) OCG: To improve the performance in the HQ entries
In the HQ entries, the code was improved to enhance AD (Analytical Distribution) validity calculations, specifically focusing on the compatibility between GL Accounts and Destinations. The same issue was also identified and addressed in payroll lines.
User rights will now be fetch by each instance directly from the sync server without passing by the HQ. This will allow instances that patches before HQ to get the user rights without waiting for the HQ to patch and then sync
Date of production synchronization server patch: 12th June 2024 / 18:00 Geneva time
Latest user rights files updated: UR.33 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
With this ticket, users will have immediate information about the conformity of their PO to the Supplier Catalogue. Every PO will now display additional information about the adherence of the PO’s products to a Supplier Catalogue. Where the PO’s Supplier has no valid Catalogue (a Catalogue for the same Supplier in the same currency which is active, Confirmed and with valid dates), this will be displayed in the “Purchase Order” tab of the Purchase Order as “No valid catalogue”.
Where there is a valid catalogue for the same Supplier as is in the PO, the conformity of the PO product lines will be checked and the adherence will be displayed on this same tab as a percentage:
Adherence is calculated on number of lines which conform / total number of lines in PO.
In the case that there are lines which do not conform (so adherence is less than 100%) there will be a new tab displayed: “Supplier Catalogue” and this will display adherence for lines which do not match and lines (Products) which do not exist in the catalogue, as well as information for each of the lines which has a mismatch, and the reason for the mismatch. Reasons for mismatch can be due to differing Unit Price and Order qty.
There is also the possibility to export the lines which have a mismatch.
The adherence information on the PO is automatically refreshed (rechecked) each time the PO is viewed or the new tab is clicked on.
There is no change to the behaviour of the PO lines in other tabs – this new development does not update the prices or quantities on the PO, it only displays whether they conform to the Supplier Catalogue or if not, why.
In order to encourage users to only use UniData products for order flows with Intermission and Intersection partners, at validation of PO / FO, the system will now check and raise a non-blocking warning message if for Intermission PO/FO any Local products are included, and for POs/FOs to Intersectional partner the system will raise a blocking warning message if any Local, ESC or ITC products are included.
POs with an ESC-type Supplier will now have an additional filter on lines so user can select to see if they have been Confirmed by ESC or not. Possible filter statuses are: ESC Confirmed, ESC Unconfirmed and (default) Show all. This filter can be used independently or together with the standard lines status filter.
For the Supply documents IR, FO, PO and IN, the order in which signees can add their signature is fixed in the order of appearing roles, so the first must sign before the next person has access to sign. Each user can still unsign in the normal way, and it is still possible for the Signature_creator group to remove certain roles from needing to sign. The system will check at addition of each signature that user is either i) the first signee or if not that ii)the signature above has been filled before allowing user to sign.
With this ticket, the names of imported and exported files will now be visible in the Job reports, and can be searched for using the newly added filter. This was developed to allow for better traceability for the Supply auto VI flows (used by OCA) for PO export, Confirmation and also update of IN via E-Packing list, but the functionality allows this visibility for all automated import/exports so Finance will also benefit from this improvement.
Since the “Details” field was added to multiple Supply documents recently, it has now been included in the IR follow up report so as to give better visibility for these documents. This is consistent with the relevant PO and FO reports which already contain this field.
It is possible when filling in the RFQ with Supplier details to change the product quantity. Previously this change was not visible at the comparison stage in a Tender, so now, when the Tender “Compare RFQs” button is clicked, in the resulting comparison pop-up screen there are additional columns added to show the Supplier Quantity as well as the original Tender quantity. Any discrepancy for this is displayed in red. The same elements are displayed in the excel “Comparison RFQ” in the action menu.
This new field HS code (Harmonized system) will now appear in all UniData products in the Specific info tab. Where there is one, value will be pulled from UniData and synched down to all instances below.
The e-validation functionality continues to be tested and improved. During testing of e-validation on the PO, it was discovered that it was possible for a signee user to electronically sign a PO that is marked “Signed Off Line”.
Additionally, in this scenario the PO remained visible on the signee users Signature Follow Up list. This should not be the case in this scenario.
These 2 points have been corrected in this release.
.3 (US-12690) Position not updating in the Human resources tab when importing PERMOIS
When loading the Permois file and then the Paye saga file, we noticed that the job position in the UF Human resources tab was not updated. This wrong behaviour has been corrected in this release.
.4 (US-12653) Fixed Asset: not to display the assets menu if the system manage fixed assets is not ticked
The fixed assets functionality is a choice. The OC can use it or not. So after this improvement, we will not display the Assets menus unless the check box is ticked in the reconfigure: “Does the system manage Fixed assets?”. This is with the aim to avoid confusion in the users.
Path for the reconfigure: ADMINISTRATION > Configuration > Parameters > Reconfigure:
When we go to Accounting > Periodical Processing > Assets > Asset Form: We will see a new field called “External Asset ID”. The external asset id corresponds to the asset code from the external log tool.
When we go to Accounting > Periodical Processing > Assets > We have added a new menu called “Import Asset Entries”: we will be able to import assets into the system.
When the file contains errors, it will not be imported. We will have the details of these errors in a message that will facilitate the correction to import the file with success.
We have allowed the group Fin_Config_Coordo to inactive journals from decommissioned project instances. This is to allow to clean up “old instance’s registers” that we did not clean before decommissioning.
.10 (US-12256) Open advance list for users with limited access to the registers.
Now we have all open advances on the register’s currency, regardless of wherever it has been booked. As it is important to be able to settle an advance from other register.
.11 (US-12029) To prevent the closure of a project register at coordo level if we have draft entries at coordo level from this project register (creation of a new not run!)
Do not allow closing of a project register when there are still draft entries from this project at coordo level.
The project will close, but after sync, we will have a not run at coordo level about the project register status: “not possible to accept the closure status as at coordo there are still draft entries from the project”.
The not runs will disappear when we delete the draft entries or if we treat them at project level (by reopening the register at project level).
To prevent the closure of a project register at coordo level if we have draft entries at coordo level from this project register (creation of a new not run!)
The integration of Unidata data in UniField was executed via Unidata linkage. The linkage worked as a push mechanism. Once the product was updated/created in UniData, the updates/creations were also pushed to UniField.
Since release version UF33.0, a new type of integration is implemented. The UniData data are received via the UniData API called by UniField daily. There is no functional impact in UniField from the regular user’s perspective, however, a few submenus have been introduced to enable better monitoring of the Unidata Pull. Also, the products are no longer matched on product codes, but on MSFID (=unique product ID generated by UniData). Therefore, the multiple truth issues should no longer occur.
All of them are located on Tools -> UniData -> UniData linkage errors:
UniData Linkage errors
In case the data pull was not successful for a specific product, the product will be displayed in this sub-menu table. Here, you can also find the MSFID of the product and the text taken from the log explaining the cause of the error.
¨
UD Products incompatible with OC values
The submenu lists all products for which the value of attributes differs from the OC default value.
OC default values (see below) are set in UniData and they are not directly returned by the API. Thus, if a new product is created the OC default value is taken instead and never updated afterwards. However, the OC default values can be later changed (which is rare) or created afterward but the product won´t be updated anymore.
Therefore, the table in the submenu lists all products, where there is a discrepancy between the actual value and the current OC default value.
OC Default Values
Some of the attributes pulled from UniData have default values set and they are not returned by the UniData API. The default values are based on Nomenclature.
Each OC can however set their own OC specific value in Unidata as well, such as Procurement Method or Expire Date Mandatory.
The table displays all OC default values currently set in UniData.
This is a purely technical ticket. Fit/Form/Function values are not returned by the API by default, thus additional needed to be created for these values.
2 new justification codes were introduced in UniData which are currently not mapped in UniField. To display these values as well, they needed to be added to the mapping table.
Date of production synchronization server patch: 10th April 2024 / 18:00 Geneva time
Latest user rights files updated: UF32.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
An issue was spotted by OCB that meant it was not possible to import a VI file (E-Packing list) on INs by using the manual “Process IN and Pick and Pack” option for INs which were linked to a synched flow/FO. This is linked to Python 3 migration and is now corrected.
This issue spotted by several OCs meant that in the case of certain flows – e.g. when some lines were Cancelled & Resourced by Supplier instance, at requesting instance level, the PDF could not be generated on closed IN. This is linked to Python 3 migration and is now corrected.
Issue spotted by OCP, when User Interface is viewed in French, some PDFs generated (e.g. PO Allocation Report, Cash Reconciliation) do not show amounts in thousands clearly as the 1,000 separators has been compressed. This is linked to Python 3 migration and is now corrected.
Issue spotted by OCG, When User Interface is being viewed in French, for some PDFs (PO, IR) the dates are appearing in English. This is linked to Python 3 migration and is now corrected.
This improvement is to avoid blocking issue faced by OCB that a Shipment was blocked from being validated due to Pick having been converted to OUT and then (Pick) being validated. This is possibly linked to Python 3 migration and action causing issue should no longer be possible.
This issue, present already in previous releases and spotted by OCA and OCB led to negative stock quantities in certain stock locations (Distribution) which needed Data fixes to correct. The issue was due to incorrect Source and Destination locations being assigned by system on SHIP PPL lines for the case of Non-stockable products which were in their own Pack. This has now been corrected.
Following the release of the ticket US-12173, when the “back up” tick box was selected for the e-signature on the PO the following behavior was expected: “In the PDF, when back up is ticked, write “as back up of” the role it is backed up.”
During testing of the feature, it was discovered that this text was not consistently displayed on the PDF in alignment with what is selected in UF.
It seems that when the Technical Responsible user is ticked as backup, the “as back up of” text appears in all signature fields to the right even if those role/function are not ticked as back up, or even if the role/function is not active on the PO. This happens AFTER the tech responsible signs. Before the signature, the text does not appear on the PDF.
When only the Finance Responsible role/function is ticked as backup, the text does not appear on the PDF at all.
We corrected the behavior of the “as back up of” text on the PDF. Only display at header level of the Roles/Functions column if ticked as backup.
Following migration to Python 3, we applied a code fix to fix the field balance specifications report. The link to this report is this: Accounting/Reporting/Accounting reports/Field Balance specification report.
Python 3 releases disrupted OCB webservices linked to UniField HQ Vertical Integration. A code fix has enabled to reestablish the webservices. Few changes on OCB Middleware were also needed to fix HQ entries webservices.
Date of production synchronization server patch: 13th March 2024 / 18:00 Geneva time
Latest user rights files updated: UF32.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
This improvement is to solve the issue of misalignment of FO “Picked” percentage status with what has been shipped. The Picked status percentage now reflects the correct percentage of picked which ignores C&R/cancelled lines.
This improvement complements what was developed in US-4642, as it was agreed that “EPREP” stock locations are categorized under the Parent Location “Stock”, and “EPREP” should no longer be a “Location Category” itself. This ticket is to ensure consistency in the system: the location category “EPREP” has been removed from drop-down lists in the “search stock locations” pop-up which appears in various screens, this was done after cleaning-up and correcting the Eprep stock locations of all OC instances.
Track Changes has been added to the “RFQ” Request for Quotation Object in the Action menu to ease and improve the continuous tracking of changes on the RFQs and to be consistent with other supply objects.
In the Export Inventory Level report, more search options have been added to the advanced filters to get more precise reports, so “Specific Product list” and “Specific Product family” are now included. Both search filters were added also to the List view as well as appearing in the list view columns.
In Internal Moves users used to be able to create an INT from scratch via duplicating a SYS-INT, and this behaviour created a gap in the INT serial numbers. This issue is solved now with this improvement, the new INT that results from duplication a SYS-INT appears in the list view of INTs and is correctly numbered.
Service products coming from FO must be sourced through a “Direct Purchase Order” (DPO), therefore the use of “Regular purchase order” was not allowed. In this release, the use of “Purchase List” type has been stopped also, and a blocking message is displayed. Similarly, when an FO containing a service product is sourced via either RFQ/Tender and is then processed to create a PO, the same rule is now applied – the PO created will automatically be a DPO.
This issue was faced by several users before: previously it was possible to cancel the main pick when subpicks were not all closed. This was achieved by users performing several conversions of the Picking tickets to OUT and vice versa. This resulted in users then being unable to cancel or process any sup-picking ticket/PPL linked to that Picking. This issue is solved now and users can’t cancel the main picking in any way while any picking tickets are in progress. A blocking message is displayed.
To continue the development that has been implemented in US-11827, in the case where multiple IRs/FOs are sourced onto 1 PO, all the “Details” fields from the multiple source documents will be pushed to the PO with a semicolon separator, up to the limit of 86 characters.
The issue, caused by user having multiple tabs open on a PO while editing it has now been resolved. It is not possible now for users to make changes in supplier/currency when they open multiple tabs and make changes on different tabs.
When user tries to make changes on different tabs at the same time, a blocking message will be displayed:
For more consistent and accurate data, Product unit prices in the Donation certificate have been rounded to 5 decimal places and the Total to 2 decimals. This corresponds to the FO/PO way of decimal rounding.
Direct purchase orders’ validated/confirmed lines quantities will now be excluded from Virtual stock calculations in the Product PMD “Stock by Location” and also in the Mission Stock report (MSR). The quantities will not be displayed since instances issuing DPOs will never receive them in stock.
MSR should not display virtual stock for Validated or Confirmed Direct purchase order
X
US-11845
Align Price in Product File and Donation Certificate
X
US-12582
Sourcing “Service” product coming from FO to Tender/RFQ should be possible and to continue procurement to PO “Direct purchase order” type should be created
X
US-12339
To clean-up OCP instances, to correct the Eprep stock locations category
X
US-12335
To fix the issue of having SYS-INT created manually by users and causing a gap in the INT List view
X
US-12248
Prevent multiple tabs allowing Supplier change and inconsistent currency
X
US-12231
Let Me Fix in SHIP when generating Freight Manifest excel
US-12197
(US-3843) PO line quantity doesn’t decrease after a claim
US-12171
Correct Picking calculation status – ignore Cancelled-r lines
X
US-12167
Sourcing FO to PO type Purchase list should not be possible for Service type product
X
US-12115
“Details” field in IR and FO pushed to PO to be concatenated where multiple source docs
X
US-12100
PMD “Stock by Location view” should not display Virtual stock for Direct Purchase Orders
X
US-12076
To add Track changes in the Action menu of RFQ
US-11957
Export Inventory Level – Advanced Filters
X
US-11907
Location Category: EPrep
X
US-10701
SHIPment blocked from being processed (convert pick> Out > pick + cancellation)
Following several errors that required data fixes, we have changed the system’s behavior. It is now possible to change the status of the period from ‘open’ to ‘draft.’
This change will only be possible if no data has been encoded or registered (no JIs or registers in draft created).
Access to this feature is granted to HQ super users with the group Fin_Config_Admin_mission only.
The e-validation functionality continues to be improved. We have implemented some useful changes in this release as follows:
• id2. We have renamed the button “Delete Signature” to “Inactivate Signature”
• id3+id10: We have merged the 2 sub-tabs “Manage users allowed to sign” and “Signatures” in each signature tab to create only one tab named “Signature” with a mapping of users added to each role/function.
o We have kept the button “Manage Users allowed to sign”
o A pop-up appears when the mapping between users and role is to be defined
o In rows, we have the Role/Function
o We have introduced a new column for “Users” and a magnifying glass. For each role, a user has been defined, and only these users will be able to sign.
o We have added a new column called “Backup.” The same user can be added to two roles, and for one of these roles, they will select “Backup” because they are replacing another person.
o In the PDF, when the “Backup” field is selected, the replacement role for the backed-up position will be indicated.
• id11. We have added the Legal name of the active signatory in front of the position when the document creator is adding users who are allowed to sign.
• id6. The signature users registered in the current period are automatically inherited by the next period’s register until they are removed. This behavior mirrors that of the “register responsible.
• id4. Close signature” – We have added a message: “You are about to block the signature on the document. This action is irreversible. Are you sure?
We have enabled the ability to change an expense account to a balance sheet account via the accounting correction wizard. This change is now also reflected in the Full Report of the related register entry.
In this release, we are finally migrating the full UniField code from Python 2 to Python 3.10.11. This is to ensure UniField Python code remain up to date, preventing risks of obsolescence for the tool.
Date of production synchronization server patch: 18th December 2023 / 18:00 Geneva time
Latest user rights files updated: UF31.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
This issue was caused by improvement US-7168 in release UF31 which reduced the Reason Types possible for Incoming Shipments. Issue which users faced meant that it was not possible to partially process an Incoming Shipment which had a Reason Type of Donation or Loan. This has now been corrected in this intermediate release
Due to the new fixed asset module, a regression has occurred, and it was not possible to do a refund-refund nor a refund-cancel when the invoice has taxes. This ticket has fixed the issue.
Date of production synchronization server patch: 6th December 2023 / 18:00 Geneva time
Latest user rights files updated: UF31.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
The Reason types (RTs) for INs from scratch have been reduced. For future INs from scratch which are created: the dropdown list offers only 3 RTs now (1 Internal Supply, 4 Return from unit, 5 External Supply). This is to encourage users to follow the correct process.
Previous INs from scratch with RTs no longer existing have been migrated to relevant current RT to be consistent with this improvement.
Additionally previous OUTs and INTs with RT “14 Other” were replaced by a more accurate and suitable RT
In the “Partners” Functionality, a new search field has been created for “Reference” and it will be displayed in all Partner search windows in different documents like FO, PO, IN, RFQ, Tender & OUT.
With these tickets, several improvements have been made to different documents in ordering, procurement and warehousing functionalities, specifically to harmonise the “Details” information:
IR : New “Details” field has been created in the IR Header, same way of processing as FO, and any value entered in IR will be transferred to OUT (or Pick if converted).
OUT: New “Details” field has been created in the OUT Header transferred from the IR, not editable (Only editable in case of OUT FS).
PO: “Details” field already exists in PO but will be populated from the source document (FO or IR) and will continue to be editable until the PO validated.
IN: New “Details” field has been created in the IN Header, and will pull from any value entered in the same field in the linked PO. It is not editable in IN (Only editable in case of IN FS). And “Origin” field in IN FS has become inactive.
PICK: New “Details” field has been created in the PICK Header transferred from the FO or from IR when linked OUT converted to Pick, not editable.
PACK: New “Details” field has been created in the PPL Header transferred from the Pick (Not editable)- The field which was previously in the PPL “Description” has been removed and replaced by field “Parcel Comments” and this is editable, both fields are appearing in the packing list pdf of the ship object. As with previous field, any value in the field Parcel Comments is visible for this PPL in the SHIP.
INT: New “Details” field has been created in the INT Header transferred from the IR or IN from scratch, not editable (Only editable in case of INT FS – Draft status). And “Origin” field in INT FS has become inactive.
In the Delivery Order / OUT from scratch, it is no longer possible send goods to an External Consumption Unit. It is now impossible to select own instance and at line level it is impossible to choose External Consumption Unit, error Message will be displayed. Goods can still be sent to an ECU if the flow is initiated by an Internal Request, or via Real Consumption.
The issue of having duplicate quantities in PPL and Donation certificate has been solved in this release. The main issue was related to packs being returned from shipments and then re-added back to the shipment again. Also the status of the Returned shipment line (Pack) in the pop-up of returned lines has been fixed to be “Returned” not “closed”.
In “Draft” Shipments, the icon “+” to process shipments from List view of shipments has been removed, shipment can still be processed in the form view of “Draft” Shipment.
To increase the efficiency of processing by reducing unnecessary steps, and to be more user friendly, when cancelling an “OUT” or “Pick”, the intermediate pop-up screen to double confirm the action of cancelling the move has been removed in this release.
We have created a new report called the Field Balance Specification Report. The report will be in the menu of Legal reports as follows:
The report can be done by period and we can select the details of entries reconciled in the last period or the total of entries reconciled in later period:
The report can be created at HQ and at coordination level just for instances that are a coordination,
The report will show the active accounts codes with outstanding balance of some balance sheet accounts.
There will be a balance accounts summary and after this we will have the details of the balances of the outstanding accounts.
Details: List on the report the following entries:
=> Unreconciled entries within the period to report: Entries which are posted before or at the end of the period to report and at the time of export of the report still not reconciled. E.g. Report Mar 2023 = Entry posted before and including 31 Mar 2023 and are not reconciled at the date of export of the report.
=> Entries which are posted before or at the end of the period to report and are reconciled with some legs of the reconciliation posted later than the period to report. E.g. report Mar 2023. Entries posted in Feb 2023 and reconciled with entries posted in Apr 2023.
For the December report, we will show the list of entries booked before the end of December and that are reconciled with entries with posting date in P13, P14, or P15 or later.
For the P13 report, the report will show the entries booked until the period P13 and that are reconciled with entries with posting date in P14 or P15 or later.
In the menu Tools, Import/Export and then submenu Finance: there will be 2 imports, related to cost centers: one will be used for the initial creation of cost centers and the other one for mass updates of cost centers.
The current cost center import will become “cost center creation mapping”: no change as from now.
and we will create a new import for mass cost center updating called: “cost center updates”: the new one.
Before, it was possible to import Analytical Distribution (AD) by line when we have only one Cost Center (CC) and one Destination account for 100% of the distribution.
With this improvement, it will be possible to add multiple Cost Centers and/or Destinations in the same line.
The proposed method for importing multiple ADs is by separating each percentage, cost center and destination with a semicolon (to differentiate the different values).
Remember that changes can be done only when the invoice is in draft status.
Example:
You have to select “Export Invoice Line” and you will see the excel report:
The fixed assets functionality has been developed in UniField. This functionality is to rely on Finance responsibilities only. Finance will be responsible to get information from Supply and Logistic in order to record Fixed Assets events, trigger depreciations in the right instance and to follow Assets movements from one mission to another.
Fixed assets, also known as long-lived assets, or property, plant and equipment, are items in physical form that:
are held for use in service of organizational activities, or for administrative purposes; and
are expected to be used more than once (not consumable); and
are expected to be used during more than one year period; and
can uniquely be tracked and monitored; and
are with value greater than a defined materiality amount
For MSF, it applies only to tangible items.
As per principle of flexibility, Fixed Assets won’t be pre-identified in the system. Each OC will define out of the system what they do consider as Assets. It will be a manual action that will set an item as a Fixed Asset.
When to trigger the recording of the fixed asset in the Balance Sheet?
While validating an invoice: It will be possible to set an invoice line / Items as Fixed Asset => invoice line triggers accounting entries in balance sheet instead of expenses.
When do we trigger the fixed asset form creation?
When the items are defined as Fixed Assets and the invoice is validated, an Asset form will be created in draft status.
When does the asset form is set as “in use” and start to be depreciated?
It will be a manual action done in the Asset form. There will not be an automation linked to Supply stock movements.
Depreciations method will be linear only and on monthly basis, included in the monthly closure checks.
Useful life will be defined in each Asset Type at HQ so OCs can set different life time for the same asset type.
It will be possible to propose several life time for the same Asset type, defined at HQ so missions can only choose the life time proposed in the asset form
Note that within the same OC, missions can only choose what has been set in the Asset Types.
There will be 7 different asset types (with also the option to create some new manually at HQ)
Acquisition:
Through invoice: goods that will be manually set as “assets” in the invoice will be booked in the Balance Sheet. An asset form will be created to monitor and follow the assets events. When asset forms will be created, they will be linked to the invoice that triggered the asset form and will take the unit price of the invoice.
Manually: it will be possible to create an asset form from scratch where all mandatory values will need to be filled, including the value and currency. Mainly for International orders where no invoices are created or when an asset is transferred to another mission
Disposal:
Once the asset is open/running (depreciated), several reasons for disposal before or after the end of life will trigger different accounting entries depending of the reason to offset the value in the balance sheet including calculation of gain (loss) on disposal.
Date of production synchronization server patch: 27th September 2023 / 18:00 Geneva time
Latest user rights files updated: UF30.1 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
(US-11974) MML – PO Confirmation with “process anyway” not allowed – UF request Fin_Budget group profile & (US-12011) Issue with MML PO Confirmation if Supplier internal
This issue, linked to the new functionality of MML meant that users could not confirm certain POs. POs affected were those containing products (MED) which did not conform to MML. Issue was due to the extra popup which was added to check if user wanted to confirm PO despite the MML non-conforming product(s). This has now been corrected and the user rights were adjusted for this to work correctly. Other issues found also linked to MML / Confirmation with POs to ESC and Auto VI import were also corrected.
(US-11956) Patch script to correct to POs with traceback issue due to prod by nomenclature
This issue was a side effect of US-11563 in UF30. This meant that certain POs displayed a traceback meaning they could not be viewed or processed due to their containing products by nomenclature and having source document of FO or IR for External CU. These POs have been fixed via a patch script.
(US-11920) To ignore Returned shipments from the list of open shipments when deactivating partners
With this ticket, the inconsistency of Returned type Shipments has been corrected so that all levels at line level share the Returned status too. This issue was blocking the de-activation of Partners and causing issues with decommissioning of instances so this has been resolved.
All Supply tickets integrated in UF30.1
Key
Summary
Detailed
US-11974
MML – PO Confirmation with “process anyway” not allowed – UF request Fin_Budget group profil
X
US-12011
(US-11974) Issue with MML PO Confirmation if Supplier internal
X
US-11956
Patch script to correct to POs with traceback issue due to prod by nomenclature
X
US-11920
To ignore the Returned shipments from the list of open shipments when deactivating partners
X
Finance
All Finance tickets integrated in UF30.1
Key
Summary
Detailed
US-11977
IL: import of IIL lines failed because OCBHT127 not yet linked to a UF instance
Date of production synchronization server patch: 13th September 2023 / 18:00 Geneva time
Latest user rights files updated: UF30.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
JIRA filter for all integrated tickets:
Supply
(US-10748) MSL & MML in UniField
Medical Standard Lists (MSL) and Medical Master List (MML) are now integrated into UniField. The data from the lists are managed in a UniData Medical Standard List tool at HQ level outside of UniField. Data added to this tool will automatically synchronize into UniField. Although there are some cases of LOG products in MSL/MML, these lists are intended for Medical products.
An MML submenu was added to the Products tab in UniField version 29.0 to synchronize data from UniData to UniField. This submenu is now visible in
MML Products: The Medical Master List (MML) is a list of products which are OC Validated. Some MML Products are restricted to a specific mission or project. These products are included in the MML but Restrictions and Use Comments are noted.
MSL Projects: This list will show a list of MSL projects linked to that mission. It is possible to activate and deactivate MSLs on this page. Once activated, the MSL is automatically updated by any change made to it in the MSL tool.
MSL Products: All products in any active MSL Project are listed in this submenu.
The product details for individual products have also been updated. OC Validation has been added to the “Information” tab to show that the product is Validated on OC level. There is also a new “UD OC Validation” tab in each product datasheet.
Use Comments are shown in this tab along with information about Mission or Project Restrictions. Additional information about whether the item is included in the MML or MSL is also shown in this new tab.
An MSL Non Conform report has been added to the Action Menu of MML Products to show the medical products in stock that are not included on the MML/MSL. Sometimes a project or coordination will order on behalf of another instance, even if the products don’t exist on the shipping instance’s MSL. These items which will be shipped to another partner are only shown on the report if the “Include in-pipe quantity” box is ticked.
A column showing whether items are included on the MML/MSL list has been added to supply documents (IR, FO, PO, IN, OUT, etc). The lines with products that are not included in the MML/MSL will be red. There will also be a notification at the header of the document. Last, a pop up warning will appear when validating or confirming a purchase for any items that are not included in the MML or MSL. None of these types of alert levels is blocking: it is possible to continue to process document/line, even if the product isn’t on the MML.
(US-11369) Import AD Multiple Lines on draft PO and FO
It is now possible to import multiple Analytical Distributions on the same PO or FO line. The process to import multiple ADs is the same as the process to import one AD (by exporting, modifying then importing the template found on the page).
If only one Cost Center and Destination are used on a PO or FO line, the format of the template looks the same as it has in past versions of UniField. In this release, multiple Cost Centers, Destinations and Percentages can be added to the template by separating the values with a semicolon (;).
To be able to import the document, the numbers in the Percentage column must add up to 100 and the total number of semicolons in the Percentage, Cost Center and Destination columns must be the same.
(US-11534) Auto save line quantities when adding multiple lines
Previously, if a user entered a quantity in the Add Multiple Products popup, the quantity would only save if the user clicked on . If they clicked on the next line without saving, the quantity entered changed back to zero.
Now, quantities entered in any ‘Add Multiple Lines’ screen (FOs, IRs, POs, RfQs, Tenders, Catalogues, INs, INTs, OUTs, Real Consumption, TKC, KCL, and Initial stock inventories), will be automatically saved when clicking on another line.
(US-11563 & US-10783) Allow PO to have Multiple Destination Locations
Destinations in a Purchase Order indicate where the products should be received (Input for items to be stocked, Cross Docking for items to be delivered out and Service/Not Stockable for specific products).
It is now possible to have multiple destination locations in the same PO. Previously, the Destination Location was managed at header level so it had to be the same for all lines in a PO. This could cause problems when a merged PO had IRs/FOs with different destinations. A new “Destination Location” field has been added at line level so that items can be received in the correct Destination Location in the IN, even if some items will be delivered (Destination = Cross Docking) and others will be stocked (Destination = Input). This field can be viewed in the Purchase Order Line’s pop up view. It is only possible to have one Destination per line.
The same PO can have different Line Destinations on different lines. The Destination field in the PO’s Delivery tab will show all of the destination locations included in the PO, based on the different Line Destinations.
(US-2411) Add status column to OUT document
In this release, a “State” column has been added to the PDF of the Delivery Order to make it easier to distinguish between Available and Not Available lines in an OUT.
(US-11181 & US-11787) E-VALIDATION for FO/OUT/Pick
It is now possible to electronically validate/sign three new supply documents: Field Orders, Delivery Orders and Picks. If E-validation is activated, these modules will each have an additional Signature tab where users can manage signatures and / or sign documents. The process to sign electronically is the same as the signature process for other supply documents (Internal Requests, Purchase Order, Reception,…)
The total quantities at the time of signing are shown in the e-validation line. To make it easier to compare the quantities when validated to the printed document, Total Quantities have been added to the OUT, IN and Pick PDF documents.
To allow e-validation of Picks, there is now a signature box at the bottom of the Pre-Packing List. The quantities shown in this document will be the Total Quantity if nothing has been picked or the Picked Quantities for closed Pre-Packing Lists.
Signatures can be added at any time. In case a signature was added to a document that was only partially processed (creating a new document), a warning message will appear, indicating that the signature needs to be added to the new document. The signature will remain in the original document.
(US-11636 & US-11433) Added filters/ fields in Export PO Follow-Up
Several improvements have been made to the PO Follow Up Report. New columns have been added to the Excel document to show the Order Category, Priority and “Source Creation Date” (the creation date of the IR or FO that is linked to that PO line). It is now possible to filter the report based on these new columns.
Additional filters have been added to the Report configuration page making it possible to view only certain Order Types or Categories. If no box is ticked, all lines will be shown.
All Supply tickets integrated in UF30.0
Key
Summary
Detailed
US-11369
Import AD Multiple Lines on draft PO and FO
X
US-11534
Auto save line quantities when adding multiple lines
X
US-11563
PO Destination field’s value to be changed when it includes product lines with different requester destinations
X
US-10783
IN Dest Location incoherent with goods actual destination
X
US-10748
MSL & MML in UniField
X
US-2411
Add status column to OUT document
X
US-11181
E-VALIDATION for additional Supply Documents (FO/OUT/Pick)
X
US-11787
[EValidation] Add a warning message when partial quantities are processed in IN, OUT, PICK
X
US-11636
Export PO Follow-up – Add Priority and order creation date
X
US-11433
Add filters + change extract for PO FOLLOW-UP report
X
US-11607
Add “Reference” search box for the Destruction Report
US-11749
Use Prop Instance Name instead of Code in Loan Certificate
US-11650
Take supplier code from the same supplier catalog from which price is taken
US-10329
Avoid creation of “Pick” in PPL Menu
US-11670
UF total cargo weight
US-11590
Require Update of Actual Ship Date when Validating SHIP from Dashboard
US-11543
To fix the issue of having empty shipment in draft state
US-11448
[RfQ] Improve Viewing of Lines to Align with Other Purchase Documents
US-11466
CDD in RFQ and Tender cannot be edited
US-11566
Allow de-activation of cancelled products in Tender before Tender is closed
US-11519
OCBML101: Consolidated mission stock has a mixed fr/eng description for products in FR version of UF
US-11459
Improve French Translation of Demand and Request
US-11473
[RR] Update names in Order Calc Export Files
Finance
(US-10874) Improvement Internal transfer: auto booking of counterpart (in the same instance)
We have improved the internal transfers within the same instance.
1 – A counterpart is created at temp/or direct hard posting of the initial entry. The creation is at first posting of initial entry only. We have an icon for visual purposes, to advise about the link between the initial entry and the counterpart.
2 – When we edit/delete the initial entry (in temp status) and the counterpart entry (in draft or in temp status) : there will not be updates:
Initial entry in temp status: allow edit/delete. No update to counterpart entry.
Counterpart entry in draft or temp status: allow edit/delete. No update to initial entry.
3 – It is not allowed to manually reconcile entries if there is a counterpart at project level or coordination. There will be an error message.
4 – When the counterpart or initial is deleted, the link will be break. At that time, manual reconciliation is possible.
5 – When the reconciliation is undone, the link is broken and it is allowed to manual reconcile back with various lines without link.
6 – To keep a coherence, automatic reconciliation will be for both same or different currency.
7 – Only do Full reconciliation. Don’t proceed to partial reconciliation when amounts don’t match:
Reconciliation same currency: Full reconcile when amounts debit/credit match.
Reconciliation same currency: When amounts debit and credit do not match, do not allow reconciliation and as consequence, break the link. Allow lines to be reconciled with entries without link. This covers also the use case when there is no debit or no credit (both lines in the same sides of the booking).
Reconciliation different currency: always reconcile as the amounts will never match due to UF rate vs local rate difference. Any difference will be FXA as per current behaviour.
8 – Reconciliations are manually un-reconcilable = that means they are tagged as “manual” even if system does it automatically
BEHAVIOUR TABLE BETWEEN INITIAL AND COUNTERPART BOOKING
FIELDS
INITIAL BOOKING
COUNTERPART BOOKING
Create the initial booking
Draft status
Not existing yet
Doc date
Allow edit
N/A
Posting date
Allow edit
N/A
Description, reference
Allow edit
N/A
TP, account code
Allow edit
N/A
Amount
Allow edit
N/A
Entry line
Allow delete the line.
N/A
After temp post initial booking
Temp posted
Created in draft or temp posted
Doc date
Allow edit. Do not send update.
Allow edit. Do not send update.
Posting date
Allow edit. Do not send update.
Allow edit. Do not send update.
Description, reference
Allow edit. Do not send update.
Allow edit. Do not send update.
TP, account code
Allow edit. Do not send update.
Allow edit. Do not send update.
Amount
Allow edit. Do not send update.
Allow edit. Do not send update.
Entry line
Allow delete the line. Break the link (counterpart could be manually reconciled)
Allow delete the line. Break the link (initial could be manually reconciled)
(US-11130) OCBHQ to have in the Combined report and JI and AJI exports the accounts mapped: “HQ system accounts” at project level
For the instances that will import accountancy entries from UF in their local accountancy application, OCB has a mapping of the accounts.
They requested to have the option to select accounts mapped in the reports Selector, Combined Journals Report, and in JI and JE.
In the Selector and in the Combined Journal Reports we have now the possibility to add accounts that are mapped in: Accounting>Config>Accounts>Account mapping:
Accounts mapping is now synchronized down.
There is new tick box “Display HQ system accounts mapping” in the company for, “Configuration” tab, when ticked.
HQ mapping is displayed on JI, AJI list views.
HQ mapping is exported in Selectors and “Export Search result”.
HQ mapping is displayed on Selectors in accounts field.
New extended filter “HQ System Account” on JI and AJI.
(US-11289) Search: Supplier and customers screens: to remove the field “Journal” and to replace it with “booking currency” field filter
In the menus Customers and Suppliers we have added the Booking Currency field.
Some examples here for suppliers:
(US-11303) Accruals: to add a filter by number in the “Search: Accruals Management” screen
In the accruals search view, we have added a filter by number.
(US-11311) Bank and Cash registers created in a special period: to prevent!
We have done several changes in order to ensure that:
Only regular periods are shown in the [period] field of the registers. This is the case if we navigate this field.
When changing the date of opening to a December date, in case December period is not open => an error message is shown like when the period is not open:
When changing date of opening to December date, the extra accounting periods are not displayed as option, even one of them is in open status.
(US-11548) For IVO and for IVI: to put in the list all accounts with type regular, expenses, payables and receivables (as in the Supplier Invoices)
For IVO and IVI, we have allowed the accounts that are now in the SI header and we have removed the regular equity accounts and the accounts with the type for specific treatment “Down Payment” /”Operational Advance” (in OCA account number 13610 and in OCB, OCP, OCG account number 13100).
(US-11601) IIL auto import configuration in UF HQ_OCA
OCA have requested support for the configuration of automatic import of IIL (International invoice lines) from SharePoint to UF HQ_OCA.
(US-11715) OCG: Automated import setup and testing for destination (daily import) 2
OCG has requested support to setup the automated import for destination in our HQ OCG sandbox.
All Finance tickets integrated in UF30.0
Key
Summary
Detailed
US-10874
Improvement Internal transfer: auto booking of counterpart (in the same instance)
X
Us-11007
To add a line with the “Total” when selecting invoice object/CV from list (same as in the Journal Entries)
US-11090
YE_COOR_OCA Fin VI vertical integration: Remove special character
US-11118
Proprietary instance, filter active CC on the list + red color lines with inactive cost centers
US-11130
OCBHQ to have in the Combined report and JI and AJI exports the accounts mapped: “HQ system accounts” at project level
X
US-11142
Remove empty space beginning and end of analytic account code
US-11212
“Balance by account” report: field periods selection to fix
US-11289
Search: Supplier and customers screens: to remove the field “Journal” and to replace it with “booking currency” field filter
X
US-11303
Accruals: to add a filter by number in the “Search: Accruals Management” screen
X
US-11311
Bank and Cash registers created in a special period: to prevent!
X
US-11451
Currency tables duplication is not working
US-11512
To prevent duplications when importing the HQ entries: double click in import button
US-11548
For IVO and for IVI: to put in the list all accounts with type regular, expenses, payables and receivables (as in the SI)
X
US-11565
Export to HQ system (OCBA) to remove from the menu Accountancy/Reporting/Generic Reporting
US-11601
IIL auto import configuration in UF HQ_OCA
X
US-11644
HQ_OCA prod does not import IIL international invoice lines (Traceback (- most recent call last -) CODE FIX
US-11655
French Translation: to translate Finance queries to Requêtes finances in the Rapports menu
US-11679
Patch script: set all OCA instances with IIL functionality
US-11680
French Translation: Is reconciled? into C’est lettré? and others
US-11715
OCG: Automated import setup and testing for destination (daily import) 2
X
US-11763
To add a configuration checkbox field on the “Automated imports” form view, to disable the checksum check for a specific import
Non- functional
(US-11484) Prevent Modifying Proprietary Instance Fields as Soon as It Is Used
Proprietary instances have always been created with all fields editable but once the instance is used in journal entries the code, level and Parent should not be changed. This release disables the ability to edit these 3 fields completely. As seen in the screenshot below, these fields will be read only for all users including administrator.
(US-11602) To Have a Pop-Up Asking for The E-Mail Address.
The UF30.0 release will include a pop-up prompting users to input their email address. This will not be a mandatory field so users can proceed to login without inputting their email address. However, the pop-up will continue to be displayed up to a maximum of 3times until 4th December 2023. After this, the user can still provide the email address in the following ways:
In the preferences menu at the top right corner of the UniField application window as seen below.
Upon password expiry, the change password dialog box will have the email address field displayed. The email field will not be mandatory so one can proceed to change password without it.
With user_manager rights directly in the user objects
Please note: For synchronized users, the email field can only be filled in at HQ using admin user or other user with access to managing synchronization whitelist.
(US-11616) Remove Block on Patch Application If CC For FO/PO Ref Is Not Set.
Instances with no cost centre for FO/PO reference set could not upgrade to new version of UF as seen with the release of UF29.0 in US-11613, US-11627 and US-11635. Instances were stuck at upgrading modules until the FO/PO cc was data fixed. The UF30.0 release removes the block on patch application for such instances. Instances without the cost centre for FO/PO reference set can now upgrade to newer versions of UniField.
(US-11668) Prevent Deletion of Synchronized Users and Allow Recreation by Sync If Deleted.
All users with user_manager access group were able to delete synchronized users on the coordination and project levels. This improvement now ensures that a deleted synchronized user is recreated by sync after deletion. In addition to this, in the linked user rights ticket US-11691 we have removed deletion rights from user_manager access group. Only activation and deactivation will be possible. Any attempt to delete a synchronized user will return error message: Cannot remove a synchronized user.
(US-11734) To Auto Activate International Invoice Lines (IIL) On New Instances For OCA
The current process of activating IIL for existing instances is manual through the Reconfigure menu in Administration tab. This improvement ticket ensures that IIL is automatically activated for all new instances in OCs that desire it. In this specific case for OCA, their auto install config file template is now set to:
Activate International Invoices Lines = Yes
If another OC desires to have IIL already activated for new instances, we shall update their auto install template after formal request via Jira.
All Non-functional tickets integrated in UF30.0
Key
Summary
Detailed
US-11484
Prevent Modifying Prop Instance Fields as Soon as It Is Used
X
US-11602
To have a pop-up asking for the e-mail address
X
US-11616
Remove block on patch application if CC for FO/PO ref is not set.
X
US-11668
Prevent Deletion of Synchronized Users and Allow recreation by sync if deleted
X
US-11734
To Auto Activate International Invoice Lines (IIL) On New Instances For OCA
Date of production synchronization server patch: 14TH June 2023 / 18:00 Geneva time
Latest user rights files updated: UF29.0 can be found here
Note that no user rights need to be loaded at each HQ. This will be done at the Sync Server by the Core team and will update the user rights via Sync for all HQs and missions.
(US-8455) Request to introduce a “Loan Certificate” in PPS and OUT
With this release, a Loan Certificate will be available in the Action Menu for all INs and OUTs (Pick/Pack/Ship and Delivery Orders). The certificate will only show the lines in the document that pertain to the Loan or Loan return.
If there is a Loan and a Loan Return in the same SHIP, it will be possible to select the document you want to view. When selecting the document that you wish to view, it is possible to choose to see the Total Value of the Loan. By default, no value will be shown.
The project’s name in the documents will be based on the name submitted by HQ. Any changes required to the name shown cannot be modified at project or coordination level.
(US-8361) Free gift certificate text alignment with donation certificate
A Certificate of Donation has always been available in UniField, but it has been added to the action menu for all SHIP and OUT for better accessibility. This certificate will be available for all Reason Types, not just ‘Donation.’
Previously it was possible to view Gift Certificates and Free Gift Certificates. This change harmonizes the names and shows the Free Gift Certificate in any place where the Gift Certificate was shown in the past. This document is now also available in the action menu for all SHIPs and OUTs.
(US-11141, 11462) Prevent new lines from being added on Validated POs that sync to a supplier
Lines from Cusomer Purchase Orders that have been validated have never synchronized to the Supplier instance, since the second instance may have already started to process the order. Despite this limitation, it was possible for the requesting instance to add lines to the PO even though the added lines would never be visible in the FO in the supplying instance.
In this release, it is no longer possible to add lines in the requesting instance once a synchronized PO is validated. The add line button is no longer visible once the PO is validated if the PO is sent to the supplier by synchronization (Internal, Intersection, or Intermission orders). All new lines must be added in the Field Order or Purchase Order of the Supplying instance and will synchronize to the Requesting Instance.
(US-10580) Alignment of IN pdf “Line Number” and “Qty Confirmed” to the PO
In past versions of UniField, the line numbers shown in the PDF version of an Incoming Shipment always started from 1, where the line numbers in the form view were linked to the PO’s line numbers. With this release, the line number shown in the Reception PDF will match what is shown when processing the IN.
The quantities shown in Incoming Shipments are also being updated to provide more insight on backorders and quantities in the original orders.
The Qty Confirmed column in the IN will now show the quantity that was confirmed in the PO, even if some of the original quantity has already been processed, same for qty in the IN from scratch, confirmed qty will show the quantity that was confirmed in the IN from scratch.
The Qty backorder column will now reflect the open backorder (the qty confirmed minus qty received from all IN lines linked to that line of the PO/IN from scratch).
(US-10563) Add fields in PO lines allocation report
The “Allocation Report” has been updated to show two new pieces of information:
Requestor: The allocation report will now show who requested the line, whether the request came from an FO or an IR. Previously this column was called ‘Partner’ and only showed the requestor when the request was an FO.
Comments: Any comments included in the Purchase Order for the line will now be shown on the PO allocation report.
(US-11218) VI PO import job stops due to checksum
During Automated Vertical Integration, UniField checks to make sure that a file isn’t a duplicate. If it is, the import is stopped, even if there are new non-duplicate import files to process. With this release, UniField will continue to process remaining VI files, even if another file processed was a duplicate file.
(US-10126) Split IN lines VIA manual VI, Duplicate ordered QTY and update QTY to process
When processing an IN via manual vertical integration, the quantities to process are taken from the import file. To prevent replacing the correct import data with order information from the PO, the top 3 buttons (Copy All, Clear All, Import IN) in the IN process screen have been removed.
(US-8968) To introduce a “Returned” status for completely returned SHIPs
Until this release, the statuses available for processed Shipments were ‘Dispatched’ and ‘Received,’ even if all lines in the order were returned. With this release, a new status ‘Returned’ will be available for shipments Replaced “Cancelled” State:
If all lines in a SHIP have been returned, the document status will be Returned. The status of shipments where all lines were returned before this release have been changed from Dispatched to Returned.
The status of all lines that have been returned in a SHIP will be changed from Closed to Returned.
A dropdown menu has been added to SHIPs to make it easier to only view relevant line statuses:
(US-9022) Allow modification of Estimated and Actual Ship Dates on Ships
Previously the Actual Ship Date in a SHIP could not be manually modified and the shipment’s Expected Ship Date could only be modified when the state is Draft.
With this release, it will be possible to modify the Expected and Actual Ship Date fields until the shipment is dispatched (Validated). Sometimes shipments are sent before or after they are validated, so now there will be a pop up allowing the shipper to select the date the shipment was actually dispatched. Once a shipment is dispatched, the Ship Date fields cannot be modified.
(US-10752) Products: Prevent change of Product Type (Stockable > Service etc)
Users at HQ can change the Product Type for UniData products and these changes will synchronize down to all coordination and project instances. At coordination level, changes in Product Type will synchronize down to projects for local codes. If an item is in stock and then the Product Type is changed to Non-Stockable, the product could be stuck in stock without being able to be delivered.
Now, a check will be done using data from latest MSR. If an item is in stock/Pipelines in any linked instance, the Product Type cannot be changed.
(US-10923) Prevent resubscription of NSL that have been unsubscribed in Unidata
OCs can choose to unsubscribe to Non Standard Local (NSL) codes in UniData and this change in subscription will be reflected in UniField. Previously, it was possible to reactivate these NSL codes in coordination, even if it was unsubscribed by HQ.
Now, when an NSL product has been unsubscribed by the OC, it cannot be activated at mission level unless the product code is resubscribed.
(US-11000) Magnifying glass to search for orders in the OST does not show lines from IRs
In the Order Sourcing Tool, the magnifying glass in the Order field previously only showed references from Field Orders. With this change, it will also be possible to search for sIR references using the magnifying glass.
(US-11177) Add ability to search for batch numbers with magnifying glass for KCL
Previously batch numbers for kit components managed by batch number/expiry dates had to be entered manually when creating a Kit Composition List (KCL).
Now, the magnifying glass functionality has been added when selecting batches for Kits so that users can view all available batches for a given kit’s Component .
(US-9157) RR: Better differentiate OC exports
The names for the Replenishment Rules export files have been updated to be more clear. The new document names are:
Previous Name
New Name
Order Calc
Order Calc Excel Export
Order Calc (only lines with warning)
Order Calc Excel Export (only lines with warning)
Export Draft Consolidated OC Lines
Draft Consolidated OC Lines
Export Consolidated OC all status
Consolidated OC Lines – All Statuses
A warning Message will be displayed in case of trying to import an incorrect file type:
“Error: Wrong format: Order Calc Excel Export template must be used”.
All Supply tickets integrated in UF29.0
Key
Summary
Detailed
US-8455
Request to introduce a “Loan Certificate” in PPS and OUT
x
US-8361
Free gift certificate text alignment with donation certificate
x
US-11141
Prevent new lines from being added on Validated POs that sync to a supplier
x
US-11462
(US-11141) Prevent new lines from being added on Validated POs to Internal Intermission Intersection Partners
x
US-10580
Alignment of IN pdf “Line Number” and “Qty Confirmed” to the PO
x
US-10563
Add fields in PO lines allocation report
x
US-11218
VI PO import job stops due to checksum
x
US-10126
Split IN lines VIA manual VI, Duplicate ordered QTY and update QTY to process
x
US-8968
To introduce a “Returned” status for completely returned SHIPs
x
US-9022
Allow modification of Estimated and Actual Ship Dates on Ships
x
US-10752
Products: Prevent change of Product Type (Stockable > Service etc)
x
US-10923
Prevent resubscription of NSL that have been unsubscribed in Unidata
x
US-11000
Magnifying glass to search for orders in the OST does not show lines from IRs
x
US-11177
Add ability to search for batch numbers with magnifying glass for KCL
x
US-9157
RR: Better differentiate OC exports
x
US-11340
[Physical Inventory] Include accurate decimal values instead of rounding down in discrepancy reports
US-11015
No statuses for some items lines in Export IR/FO Follow-up
US-11140
Add Link to RfQ Reference when Sourcing to RfQ
US-11184
French translation improvement for IN print out – « contrôlé par »
US-10880
Claims: Claim from scratch from IR ext CU strange behaviour
US-11268
[RFQ] Update RFQ button once RFQ is sent
US-11450
Product track changes attached to the wrong product
US-11465
(US-8968) Main Shipment becoming Returned when it should not
US-11471
To fix the QTY confirmed and backordered qty calculation in the IN from scratch
US-8371
PO: UF refuses to change unit price
US-11524
[9022] Actual Ship Date should be Today’s Date in Pop Up, but it defaults to previous Actual Ship Date
US-11528
To fix the qty confirmed in the IN from scratch
Finance
(US-10858) Electronic Validation: Inactivate signature when user is inactivated
After this improvement, we will get automatically the signature inactivated, when the user will be inactivated.
The aim is to prevent that old signatures could be used when the profile is reactivated later.
(US-10991) Electronic Validation: Improve the error message when the user has a signature, but he is not allowed to sign a document
We have improved the error messages for this use case: the user has the signature, but the user is not allowed to sign the document. In this case, the user tries to apply his/her signature on the object and the old error message was “Operation denied”. We have adapted the message to put it clearer.
The error message has been changed as follows:
“You are not in the list of users allowed to sign this document – please contact the document creator”.
“Vous n’êtes pas dans la liste autorisée à signer ce document – merci de contacter le createur de document”.
(US-11199) Electronic Validation: signature follow screen up for “document creator”: to remove the default filters [my signature] and [to be signed]
In Unifield, go to: Administration/Users/Signature/Signature follow-up: we have removed the default filters [my signature] and [to be signed]. After user’s experience we have considered that it was not pertinent.
We have created two “Export” action menus from the Signature follow up screen:
Export to Excel
Export to PDF
Go to Administration, Users/ Signatures Follow up, go to the right menu Actions and select “export search results”.
The idea is to apply some filters using the existing filtering method above the screen and to be able to export the list in Excel/PDF.
The content will be the information of all the columns that we have on the current “signature follow-up” screen.
The use of this: when we need to quick check which documents/objects have been signed in UF, we can export the report and provide to auditors/control etc.
(US-10807) Users: filter based on the “department code”- drop down list
In Administration, Users: “Search: Users” there was an inactive filter named “Company“. It has been now renamed as “Department” and it will be used to have the Department information.
Remember that to populate the department field, you need to go to the menu Human Resources => Configuration => Human Resources => Departments.
(US-10820) OCB: Sub-cost center validity date greater than parent cost center validity date, no import in CODA: to add an error message
We have added an additional check for cost centers parametrization:
In the case that the Sub cost center validity date is greater than the parent cost center validity date ==> we have added a warning error message. “the sub-costcenter validity date is greater than the parent cost center validity date”.
(US-10835) International Invoice Lines – ESC ERP (European Supply Center ERP)
To develop the Finance Cost price *, we have created the International Invoice Lines module to synchronize down the International Invoices Lines extracted from ESC ERP to the requestor instances. This is to get the real paid prices from the ESCs for International orders.
* Finance Cost price: the product finance cost price will be calculated based on invoices and no more on POs.
This module intends to:
Allow a downstream flow from UniField HQ instance to missions’ instances, called International Invoices Lines.
With information extracted from the ESCs’ ERPs and imported in UniField HQ instance.
International Invoices Lines are a more detailed information of HQ Entries/Invoices placed by ESCs to OCs related to International orders placed by missions to ESCs, where information of a product line level / Purchase Order Line level are available, especially invoiced prices.
Match International Invoices Lines with reception of International Orders in UniField so prices of International Invoices Lines can be used to value the average Finance Cost price of a product.
Principles :
The Module is not compulsory to use and will be in the reconfigure (Manage International Invoices Lines) and access managed via user rights.
IIL imported at HQ will sync to the instance where the CC is ticked as PO/FO Reference to ensure IIL are available either at Coordo or project that placed the International Orders.
In case of DPO to ESCs, the CC of the receiving instances will have to be entered in the IIL instead of the CC of the instance that placed the order.
If ESC entries are not found at time of reception triggering the creation/validation of the ESC invoices, invoices prices will be populated by the Purchase Order prices.
ESC entries can be monitored at HQ regarding their status (status will sync up from mission to HQ).
(US-10904) Final status of in kind donation: from OPEN status to new status DONE/TERMINE (it is not a renaming)
We have done some improvements on the in kind donation functionality:
– We have created the button called: “Set as done” (“Terminer” in French version).
– we have also created the Status Done (Terminé in French). The status OPEN will not exist anymore.
(US-10921) IVI / IVO / STV / ISI: to add the Counterpart Invoice Number search field
We have added the “Counterpart Invoice Number” field on the IVI / IVO / STV / ISI search views and to display it in the list views.
(US-11005) To prevent FO / PO creation if “Cost center picked for PO/FO reference” is empty
We have prevented the FO / PO creation if the “Cost center picked for PO/FO reference” is empty:
We have also put an error message:
English message: “add the cost center picked for PO/FO reference”
French message : “rajouter le centre de coût utilisé pour la reference PO/FO”
(US-11046) Costing methods: standard price to remove + Patch script to correct products with the wrong costing method
We have removed the option Standard price, as MSF used just the option Average price.
We have done a patch script to correct the products with the standard price.
(US-11103) Manual journal entry: available journals: to remove the not used journal with code REV
The REV journal is no more available for manual journal entries.
All Finance tickets integrated in UF28.1
Key
Summary
Detailed
US-10799
ELECTRONIC VALIDATION: To create a submenu in the Users with the Signatures (List, Follow-up and My Signature)
US-10858
Electronic Validation: Inactivate signature when user is inactivated
x
US-10991
E-validation: Improve the error message when the user has a signature, but he is not allowed to sign a document
x
US-11199
E-validation: signature follow screen up for “document creator”: to remove the default filters [my signature] and [to be signed]
x
US-11349
E-validation: “signature follow up” exporting option (excel and pdf)
x
US-6976
Remove the translation option from the analytic accounts
US-8443
OCA_VE_COOR Unbalanced entry after synch – causing failure of test auto Finance VI in from HQ.
US-9702
Code fix for Journal entries: use case with AD KO to avoid
US-10629
Partners form: purchase default currency and field order default currency
US-10755
Selector saved queries/templates: to be able to delete them at once (to do with the user right ticket US-11328)
US-10807
Users: filter based on the “department code”- drop down list
x
US-10820
OCB: Sub-cost center validity date greater than parent cost center validity date, no import in CODA: to add an error message
x
US-10835
International Invoice Lines – IIL module – ESC ERP
x
US-10904
Final status of in kind donation: from OPEN status to new status DONE/TERMINE (it is not a renaming)
x
US-10915
OCB VI – vertical integration – Changes to the interface file (to add additional columns) to adapt to the new HQ system
US-10921
IVI / IVO / STV / ISI: to add the Counterpart Invoice Number search field
x
US-10996
Entries Data Integrity at project: remove coordo Unbalanced reconciliations
US-11005
To prevent FO / PO creation if “Cost center picked for PO/FO reference” is empty
x
US-11022
Accrual – Edition of the third party on draft ACC to empty is not reflected in the list view + patch script
US-11046
Costing methods: standard price to remove + Patch script to correct products with the wrong costing method
x
US-11103
Manual journal entry: available journals: to remove the not used journal with code REV
x
US-11348
Allow editing entry line with if the line contains character (° )
US-11399
OCA_MM_MYAM: DF: Target instance of CC did not synched to the field
US-11410
OCB VI vertical integration: to add the db-id for journals (account_journal.id)
US-11444
French Translation: Cash request into Demande de fonds
Non- functional
(US-11254) Python3: patch file too large to store in database
This improvement is in preparation for the python3 migration. In the UF28.1 and all earlier versions of UF, the patch file retrieved from the sync server by the instances is stored in the database. However, when we tested this procedure to migrate from python2 to python3, it returned an error when allocating memory to output buffer. To fix this, we changed the patch file to be stored in the filesystem under a new folder: “C:\Program Files (x86)\msf\Unifield\Patches”
Please note that the new patches folder will not be visible with this 29.0 release. It will be created with the next patch/release when the new patch is applied. The patch file to migrate py2 to py3 will be approximately 100MB and should not heavily impact the disk space on the C drive.
(US-9958) Time out for inactivity
Currently, there is no automatic log out when users are not using UniField. This poses some IT security risks. This release implements a 1hour timeout activity which was agreed upon by both Supply and Finance as acceptable for the business. The user will be notified 15mins before automatic logout.
(US-11232) Unidata API: Display Mission/Project Restriction and OC validation
We have extended the integration with UniData and UniField. As a result, some of the fields from UniData are now visible in UniField as well.
On the Product level, in the ”Information” = > “Status” section, the following fields are newly visible:
“OC Validation” checkbox
“Devalidation Date” or “Validation Date“ (depending in whether the product is OC validated or not)
A new tab on the ”UD OC Validation” has been created. You will find there all ”Mission Restrictions”, ”Project Restrictions” and ”MSL” in which the specific product is listed. The ”Code” field is the instance code that has been mapped to the specific mission/project/MSL restrictions. Please note that if the Mission/Project restriction has not been mapped yet, the field will remain empty.
(US-10885) MSL: prepare prototype call to MSL API
We have integrated the MSL data into UniField. This enabled us to show all the published MSL projects in UniField as well as all the products listed in these projects which are also present and active in UniField.
You will find new submenus in the ”Products” menu:
MML Products – The submenu lists all the products, that are active in UniField and are also OC Validated for the given OC in UniData. You can also see, whether the product is MML or MSL Valid. MML Valid means that for the given product, there are either no restrictions for the products in UniData or these restrictions apply to the proprietary instance, or coordination instance. MSL Valid means that MSL project applies to the proprietary instance. The ”MML Valid” filter serves as a quick filter to see only MML Valid products. Please note that on the HQL level, ”MML Valid”/”MSL Valid” fields are always empty as MML restrictions and MSL projects only apply to Coordination/Project level instances.
MSL Projects – The submenu lists only relevant MSL Projects for the proprietary instance. Which project is relevant depends on the instance level. For the HQ instances, all published projects within OC are displayed. On the coordination level, only published projects mapped to the proprietary instance or its children are displayed. On the project level, published projects mapped to the proprietary instance + projects of its coordination + all children of its coordination are displayed.
You can click on each project to see the specific products that are listed under this project.
To see the specific products in the ”MSL Products”, you need to activate the specific project first. You can do so by clicking on the green button positioned on the right side. The project can also be deactivated at any time. By default, all projects are deactivated.
MSL products – all products listed in the relevant MSL projects are listed in this submenu. Each MSL project must be activated first in the “MSL Projects“ object. By default, only products listed in the MSL Project mapped to the proprietary instance are displayed. If you wish to see the products listed under another MSL project, you need to choose them in the “MSL Valid for instance” filter. Again, you can only choose from projects, which are already activated in UniField.
In the ”Tools” -> ”Unidata” => ”MSL Projects with no link to UF” you will find all unmapped MSL projects. Also, these unmapped projects will appear in red font in the “MSL Projects” submenu.
All Non-functional tickets integrated in UF29.0
Key
Summary
Detailed
US-11254
Python3: patch file too large to store in database
x
US-9958
Time out for inactivity
x
US-11232
Unidata API: Display Mission/Project Restriction and OC validation
x
US-10885
MSL: prepare prototype call to MSL API
x
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.