Skip to content

Dynamic Ship

Export ship via tracking information

Viewing 8 posts – 1 through 8 (of 8 total)
  • Author
    Posts
  • #9013
    Gina K.

    Hello,

    We use Dynamic Ship to ship our orders. I need to export a csv daily that contains our shipped package tracking numbers.  Can this be done using Power Automate (or some other way), the file needs to include our shipped package tracking number with posted invoice # or original sales order number.

    #10924
    Terri V.
    Insight Works

    Hello Gina,

    Dynamic Ship does not include an out-of-the-box report for this requirement.

    The tracking number and related shipment information are stored in the License Plate Header table.

    Please contact your Business Central partner for assistance creating a custom report that includes the tracking number and the posted invoice or original sales order number.

    Thank you,

    #10939
    Gina K.

    Can Power Automate connect to any Dynamic Ship data?

    #10945
    Kelly B.
    Insight Works

    Hello Gina,

    Thank you for your follow-up question. Power Automate can be used to build a flow that exports a daily CSV of this data.

    The fields you need are not specific to Dynamic Ship. The posted invoice number and the original sales order number are stored in standard Business Central tables, such as the Sales Header (table 36).

    As mentioned previously, the tracking number is stored in the License Plate Header table. Your partner can combine that table with the Business Central sales data to produce the file you need.

    Thank you

    #10947
    Gina K.

    Hi Kelly,

    We’d like to avoid additional costs.  We’ve already created several other flows that extract other table data using Power Automate.  I know the license plate table is IWX LP Header (23044330), but it does not appear to be available in Power Automate.  Are you saying that we must pay a partner to make the table available in PA, there are no plans for the table to be available without a partner exposing it and no way for a client to access the data without paying a partner?

    Thank you

    #10948
    Terri V.
    Insight Works

    Hello Gina,

    Power Automate can be used to build a flow that exports a daily CSV of this data.

    The fields you need are not specific to Dynamic Ship. The posted invoice number and the original sales order number are stored in standard Business Central tables, such as the Sales Header (table 36).

    As mentioned previously, the tracking number is stored in the License Plate Header table. Your partner can combine that table with the Business Central sales data to produce the file you need.

    Thank you,

    #10950
    Gina K.

    Hi Terri thanks for your post, the license plate header table does not appear to be visible in Power Automate, that is why I created the post.  I can see in BC, the license plate header file is table 23044330 but it is not visible in Power Automate. If it is visible then we can use it. We’ve already paid our vendor thousands of dollars to help with power automate, if tables are available in PA then we are comfortable extracting the data.  We would like to avoid spending additional thousands of dollars.  Can you please email me so I can show you there are no IWX tables shown in PA, I’m unable to paste a picture here.  Thank you

     

    #10952
    Terri V.
    Insight Works

    Hello Gina,

    You’re correct, after some investigating the License Plate Header table won’t appear in Power Automate.

    The tracking number is right on the sales order header table however, so for what you were describing you do not need the LP header table for that report.

    Thank you,

Viewing 8 posts – 1 through 8 (of 8 total)
  • Sign in below to reply.