Skip to main content

Changelog

All notable changes to this project will be documented in this file.

info

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

Unreleased

Fixed

Added

Changed

Deprecated

Removed

Security

21.0.51.0 - 2024-06-25

Added

  • Setup on Field Service Setup card to Ignore Zero Cost Actuals for none service actual lines.

21.0.50.1 - 2024-06-20

Fixed

  • Mark Inventory Journals as Posted when a PO Cancellation can't be done due to the missing Purchase Order.

21.0.50.0 - 2024-06-20

Fixed

  • Issue when posting Inventory Journal Integration when the Purchase Order had to be released.

Added

  • Job filter on report 62,000 Job Create Sales Invoice by Invoice No.

21.0.45.1 - 2024-02-14

Fixed

  • Logical name for new Posting Date field for BC incorrect for CRM Actual table

21.0.45.0 - 2024-02-14

Added

  • Purchase Order Cancellation. A cancelled Purchase Order in Field Service will be synchronised and and Purchase Receipts will be undone and the Purchase Order will be deleted.
  • Additional validations added before a Job can be set to status Completed.
  • Additional Action on the Job Card to recreate the Job Task structure for Work Orders linked to an Agreement.
  • Added Dynamics 365 Field Service Synchronisation group on the Job Card
  • Added Action on the Purchase Order List to cancel selected Purchase Orders. This action is not visible by default and has to be added by a profile personalisation.

Changed

  • If additional Purchase Invoice lines were added, then the PO Bill process will add these additional lines to the Field Service Purchase Order with no Unit Cost.
  • The Posting Date of the Field Service Sales Invoice will be used as Posting Date of the Business Central Sales Invoice.

21.0.44.0 - 2024-01-10

Added

  • For Work Orders created in Field Service from Job Tasks in Business Central, the Owner will be set to a team. The Owner will be determined by the Dimension Code representing the Owning Teams. The priority is the Job Task Dimension. If not available, the Job Dimension will be used. If this is also not available, then the team of the Agreement will be used.

21.0.43.1 - 2024-01-09

Added

  • Work Order - Work Order integration supports now Dimension Mapping and Job Task dimensions are now maintained from the data of the Work Order.

21.0.37.4 - 2023-10-20

Added

  • Additional column on Purchase Invoice Tracing report

21.0.37.2 - 2023-10-12

Fixed

  • Refinements on Purchase Invoice Tracing report

21.0.37.0 - 2023-10-11

Added

  • added a Purchase Invoice Tracing report in Excel format for better troubleshooting if the purchase cost made it to the Job
  • Allow undo of Purchase Receipts for closed periods

21.0.36.0 - 2023-09-21

Added

  • Support multiple purchase invoice scenario with partial invoice quantities by splitting Field Service Purchase Receipt Product lines until the Purchase Order is marked as Final with the last Purchase Invoice.

21.0.35.0 - 2023-09-18

Fixed

  • POBill process links only invoiced lines to a Purchase Receipt in Field Service

Added

  • Purchase Order Cancellation process
  • Ability to post Job Journal for completed jobs by automatically open and complete jobs with WIP posting in the background

21.0.34.1 - 2023-09-07

Added

  • Purchase Order cancellation process as part of Transaction and Inventory Journal integration

21.0.33.0 - 2023-08-17

Added

  • Action menu for Synchronisation on all pages representing staging tables

21.0.32.0 - 2023-08-15

Added

  • Added more validations when creating new Purchase Order Lines in Field Service based on new lines of a Posted Purchase invoice to avoid creating duplicated lines

21.0.28.0 - 2023-08-03

Fixed

  • Throw an error if a Purchase Line is assigned to a Work Order but the Job is not created yet.

Changed

  • Dimensions on a Purchase Line linked to a Job are not updated in the integration when the Purchase Header dimensions change.

21.0.27.0 - 2023-08-02

Removed

  • Removed additional functions added to add missing related dimensions after synchronisation as the root cause has been fixed.

21.0.26.0 - 2023-08-01

Changed

  • PO-Bill integration process changed to avoid duplication of Purchase Order lines

21.0.16.0 - 2023-07-06

Added

  • Additional lines on Purchase Invoice will be sent back to Field Service so they can be included in the Sales Invoice. Only for Purchase Orders linked to a Job.

Changed

  • Made the creation of Work Orders on a Job Task more user friendly with additional validations.

21.0.14.0 - 2023-06-28

Fixed

  • Added a safeguard to check dimensions after the POrder-POrder synchronisation, and add them then if they don't exist.

Added

  • Ability to clear out the Work Order on an Agreement when the Work Order status is Posted and all Actuals were processed.
  • Clicking on the Create Work Order allows not to create another Work Order. The Work Order number is now driven by a number series in the Field Service Setup.

21.0.13.0 - 2023-06-22

Added

  • Ability to link a Purchase Order Line to a Job and Job Task if the Field Service Purchase Order Product is linked to a Work Order.
  • Purchase Order sync includes now the Modified At field, which triggers a sync on any field change made on the Purchase Order. This fixes also the Default Dimension setting and change.

21.0.12.1 - 2023-06-13

Fixed

  • Updating Posting Date on Purchase Order when posting the Purchase Receipt

21.0.12.0 - 2023-06-12

Added

  • Report Work Order Reintegration to fix missing structure (Job Tasks) after syncing a Work Order.

Changed

  • Purchase Order synchronisation checks if the Purchase Order was already posted and therefore missing.

21.0.11.0 - 2023-05-30

Fixed

  • FS Purchase INvoice Reconciliation Report, Job Ledger Entry filter corrected

21.0.10.0 - 2023-05-30

Fixed

  • FS Purchase Invoice Reconciliation report suppress records if the related Work Order has not the Status Posted

21.0.9.0 - 2023-05-22

Added

  • Action to reprocess a Job structure for type Work Order
  • FS Purchase Invoice Reconciliation report with Excel export of diff values

21.0.8.0 - 2023-05-18

Fixed

  • Finding Purchase Line for Purchase Receipts through FS ID.
  • Finding Purchase Receipt update by ID.

21.0.7.0 - 2023-05-10

Fixed

  • Version number

21.0.6.1 - 2023-05-10

Added

  • New flag on item card Reset Unit Cost for service and non-inventory items. Once set, the Unit Cost of this item will be set to 0, i.e. posting a purchase invoice is not setting the Unit Cost to the latest cost, but sets it to 0. This way, a universal used item is not suggesting a cost but forces the user to enter a unit cost in Field Service.

21.0.6.0 - 2023-05-08

Fixed

  • Ensure all Actual records are filtered to use Active records (not soft deleted)

Added

  • Standard filter for Field Service Invoice Reconciliation report

21.0.5.2 - 2023-05-02

Fixed

  • Check if Dataverse integration is enabled before posting value entries

21.0.4.0 - 2023-05-01

Added

  • Action on CRM Work Order Integration to refresh data from the related Agreement as they may have changed after the record was created.

21.0.3.0 - 2023-04-30

Added

  • Field Service Invoice Number is now referenced on posted sales documents
  • Field Service Invoice Number reconciliation report

21.0.2.0 - 2023-04-26

Added

  • Allowed for a customer to change when the job is integrated
  • When creating the invoice with report 62,000 an auto-correction option has been added to check once again in Field Service what the current Billing Account is and then change the job before the invoice has been created.
  • Actual posting of type Cost supports now Transaction Class Commission and Additional

21.0.1.0 - 2023-04-26

Fixed

  • Multi-line invoice descriptions for Job Planning Lines
  • 100% Line Discount issue. Applied an auto-correction when this sporadic error happens.

21.0.0.5 - 2023-04-22

Fixed

  • Fixed sporadic issue of a 100% Line Discount on billable Job Planning Lines by adding a new procedure to check and fix if it happened

21.0.0.4 - 2023-04-20

Added

  • Suppress Document field added to Sales Credit Memo

21.0.0.2 - 2023-04-17

Changed

  • Set Unit Cost to $0 for all Planning Lines of type Billable

21.0.0.1 - 2023-04-14

Added

  • Account - Customer Mapping: Added field mapping for Address 1 Name to Name 2

19.0.19.0 - 2023-04-13

Fixed

  • Not auto-complete jobs when there are outstanding actuals or billing lines

19.0.18.1 - 2023-04-13

Fixed

  • Copy External Doc No. to Sales Invoice with report 62,000

19.0.18.0 - 2023-04-13

Added

  • New field No. to Invoice Planning Lines added to Job Card and Job List
  • New field Suppress Sending Document on Job Card, which flows through to the Posted Sales Invoice. This field can be used to filter out the document when using the Document Sending process.
  • New factbox on Job Card tp show not journalised CRM Actuals
  • Validation when creating a Sales Invoice for a Job, to check if there are outstanding CRM Actuals. This can be enabled on the Field Service Setup card.
  • Ability to update the Work Description on a Posted Sales Invoice via the Update Document action.

19.0.17.0 - 2023-04-11

Fixed

  • Issue with setting a Work Order id for a random Job Agreement

Added

  • Option to run custom processes for an Integration Table Mapping as background task

19.0.16.0 - 2023-04-11

Added

  • Validation on Job Task for creating a Work Order. Invoicing tasks are excluded from having a Work Order.

Changed

  • Field mapping for Ship-to address on Work Order and Agreement

19.0.15.0 - 2023-04-06

Added

  • Job dimension are copied to Sales Invoice header with report 62,000

Changed

  • Invoice Description field on Job Card is now editable
  • Aggreation Rule field on Job Card has now a lookup directly to the CRM Aggreation rules for selection.

19.0.14.0 - 2023-03-31

Fixed

  • Cost Actuals for service items are now posted under the Service Job Task

Added

  • Report Job Create Sales Invoice by Invoice No. has now an option to Auto-Complete the job after invoicing run

Changed

  • Changed Job Create Sales Invoice by Invoice No. report to be more error tolerant and process invoices that are possible and list erroneous jobs in the thrown error

19.0.13.1 - 2023-03-30

Fixed

  • Description on Job Planning Line is coming from Actuals External Description

19.0.13.0 - 2023-03-29

Added

  • Ship-to address fields on Agreement synchronisation

19.0.11.0 - 2023-03-27

Removed

  • Removed manual coupling and moved it to the Advanced Dynamics Integration app.

19.0.10.0 - 2023-03-23

Fixed

  • Filter criteria when posting partial purchase receipts.
  • Use the Purchase Receipt number from Field Service as the Vendor Shipment No. for better referencing
  • Purchase Order line will not be updated anymore via the Integration when a receipt was posted for this line
  • OnInsert validation for Jobs created from Agreements to set default values
  • Job Create Sales Invoice report adjusted for background execution

Added

  • Add an action to Integration Table Mappings page to run a manual coupling.

Changed

  • Changed the standard behaviour of coupling Unit Group and Item UOM, as standard integration searches with the wrong value for an existing coupling in these cases.
  • Job Planning Lines origin from Billable Actuals use now the Description from the Actuals
  • Use Posted Purchase Invoice No. for the PO Bill No. in Field Service

19.0.5.0 - 2023-03-04

Fixed

  • changes for agreement synch issues

Added

  • Added default Work Order times to Field Serv. Setup. Used when creating a new Work Order from a Job Task.

19.0.2.0 - 2023-02-23

Fixed

  • Update Dataverse Purchase Receipt with invoiced costs also for items of type service and non-inventory

Added

  • Integration to a Dataverse Payroll Entry table. Approved Time Entries will be replicated to Dataverse, if this feature is enabled on the Field Service Setup page.

19.0.1.11 - 2023-02-17

Added

  • Purchase Order Receipt for non-inventory and service products

19.0.1.1 - 2022-12-14

Fixed

  • The first Purchase Receipt for partial receipt, received also other lines not supposed to be receipted.
  • Purchase Invoice for a partial receipted Purchase Order now also creates a PO Bill.

19.0.1.0 - 2022-12-08

Fixed

Added

  • Added report Job Create Sales Invoice by Invoice No. to create invoices per Field Service Invoice No.

Changed

  • Use of Description field in Agreement - Job integration

Deprecated

Removed

Security

[19.0.0.58] - (2022-12-01)

Added

  • Restructured the execution of after sync custom processes to catch errors, so that the Job Queue is not failing.

[19.0.0.46] - (2022-10-14)

Fixed

  • Add Location Code for Billable Job Planning Lines if the item is of type inventory

[19.0.0.45] - (2022-10-13)

Fixed

  • Fixes around Actuals posting

[19.0.0.43] - (2022-10-12)

Fixed

  • Location Code is only required for Inventory Items

[19.0.0.41] - (2022-10-11)

Fixed

  • Job Planning Filter bug resolved for Agreements

[19.0.0.40] - (2022-10-11)

Fixed

  • Skip Job Planning Line update for Agreements if Job Planning Line can't be updated.

Changed

  • Changed all previous skip records in case of an error to errors, so it will be clear why records don't come through if a dependency is not met.

[19.0.0.39] - (2022-10-07)

Fixed

  • Applied State filter on Actuals