Untitled Document
Results 1 to 3 of 3

Thread: ShipRush script to update the shipping to the database table

  1. #1
    Hi this is pwu0083

    We are trying to customize the script used on the ShipRush to update the table [APEM-Test$Warehouse Shipment Header] on our database.
    The script is under ShipRush -> Setting -> CM Settings ... -> Writing History Info -> SQL Script

    We add the below code into the script:
    "[Posting Date] = '%Date Field from Package Shipment%',"

    ====================================
    update [APEM-Test$Warehouse Shipment Header]
    set
    [Shipping Status] = 3,
    [Package Tracking No_] = '%TrackingNumber%',
    [Shipping Charges] = '%ShippingCharges%',
    [Shipping Weight] = '%ShippingWeight%',
    [Posting Date] = '%Date Field from Package Shipment%',
    where [No_] = '%RecordID%'
    =====================================

    I am not pretty sure what's the ShipRush variable name in order to update the column [Posting Date]. Can we update the [Posting Date] column using the code
    [Posting Date] = '%Date Field from Package Shipment%',

    Please let me know.
    Thank you,

    pwu0083

  2. #2

    Join Date
    Apr 2004
    Posts
    16,802
    SYSOPS is offline
    The only option would be the date the label is created, today's date

    From the helpfile:
    http://www.zfirm.com/Product_Documen..._Reference.htm

    This section: %Today(format)%

    HTH,
    SYSOPS
    Have Questions? Ask the ShipRush Knowledge Base: https://shiprush.com/kbase
    Reply With Quote

  3. #3
    Quote Originally Posted by SYSOPS View Post
    The only option would be the date the label is created, today's date

    From the helpfile:
    http://www.zfirm.com/Product_Documen..._Reference.htm

    This section: %Today(format)%

    HTH,
    SYSOPS
    Hi,

    I have the information.
    Will give it a try.

    Thank you!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •