Skip to main content

Process Freight bill invoice in Exflow

Create PO for Freight bill

  1. Create purchase order in D365FO

medium

  1. In the PO, go to Header tab and fill in required "Mode of delivery" and "Delivery terms"

medium

  1. Click on Action menu "Warehouse" and select "Inbound load planning workbench" to add a create a load for this PO

medium

  1. To create a load for this PO: Click on "Supply and demand" - select "To new load"

Graphical user interface, text, application, email Description automatically generated

medium

  1. New load is added to the PO

medium

  1. Go to Transport management | Planning | Loads | All loads
  • Find the newly created load Id for the PO and click on load ID.
  • To assign route on load. Select Transportation -> Rate route workbench.

Graphical user interface, text, application, email Description automatically generated

medium

  1. Always delete the extra line before processing further: This is an issue from standard D365FO. Then go back to previous page of load.

medium

  1. Process inbound shipment
  • Ship and receive
  • Inbound shipment

Graphical user interface, text, application, email Description automatically generated

  1. To verify that the Freights have been assigned on this load, click Transportation - Freight bill details

Graphical user interface, text, application, email Description automatically generated

Graphical user interface, text, application, email Description automatically generated

Process Freight bill in ExFlow

For executing Freight bill in ExFlow: process a cost invoice with Load ID to get all freight bill lines. There is a button added to fetch freight bill lines from Load ID in Import form.

NOTE: PO amount is paid separately as ExFlow PO invoice. This invoice is only for paying freight bill.

  • Import invoice and check that all Fright bill ID lines are imported from Load ID in Import.
  • or use action menu in Import form | Actions | Retrieve from freight bill. To load manually.

medium

Graphical user interface, text, application, email Description automatically generated

  • Post and approve this Fright bill invoice and then process Freight bill posting via TMS batch jobs.
    Posting and approval is same as for PO invoices in the ExFlow process, if the freight invoice is matched with Load id, then the invoice gets auto approved if not matched then approved manually.
    As soon as invoice is approved, the TMS freight invoice process can be done via TMS freight invoice batches.

ExFlow AP | Periodic tasks | TMS Freight invoice

small

  • Create: This batch creates the Freight bill invoices based on the approved invoice. Use filter or do batch processing.

small

  • Match: This batch do the match between Load id and ExFlow invoice with Freight bill created by ExFlow invoice. Matching will fail if the Load and ExFlow invoice doesn’t match according to setup in tolerances and matching criteria, and then user needs to perform the reconciliation manually in Freight bill invoice.

small

  • Approve: This batch does the approval of the Freight bill.

small

  • Post: this batch creates, match, approve and post at the same time but if any of the above-mentioned step fails then user must do the reconciliation and approval manually.

small

If Error occurs when the Freight bill invoice is not matched according to setup and tolerances

Graphical user interface, text, application, email Description automatically generated

  • In this case user needs to manually reconciliate the freight bill invoice

medium

  • To add line in this form, use key fn+N and select reconciliation reason code, save and go back to perform approval of this reconciliation.

Graphical user interface, text, application, email Description automatically generated

  • Submit for approval

medium

medium

  • To final post Freight bill invoice: Select Vendor invoice journal.

medium

  • The Invoice journal will open, then select Journal details - Lines.
  • Invoice journal will be open to verify all the lines and other details.
  • Manually post invoice journal.
  • Invoice journal is posted and ExFlow freight invoice status changed to invoiced. Graphical user interface, text, application, email Description automatically generated