Shipping Label to APO address

32 views
Skip to first unread message

Shaul Dover

unread,
Jul 8, 2021, 9:07:38 AM7/8/21
to Stone Edge User Group
In the latest version of OM with the built in shipping module. Shipping to International destination will work well, the system will print the 3 copies of the custom form. 

For APO address, which require custom form as well, the system will only print one sticker without the detailed custom info.
These shipments are being returned back to shipper for missing custom form and we lost the postage. need to reship again manually. 
SD.

Alex Osborne

unread,
Jul 8, 2021, 9:56:47 AM7/8/21
to Shaul Dover, Stone Edge User Group
We had the same issue and SE support was able to remote in and fix the issue. They also sent me this steps so we can check on all our computers. 

Here is what I do to check, and also here is the code and how to save it if need be. Make sure to make a copy of the SEOrdMan.mdb file in c:\StoneEdge before you make any changes.
When on Stone Edge Main Menu, hit ctrl+g – this opens the visual basic window

  1. On the left side under Project-SEOrdMan you will see the object window, this lists all objects in the project.
    Scroll down past forms, past reports, until you see a folder called Modules, open this folder and then scroll down to find the module – ship

 

  1. Once you find ship, right click and choose “view code”
    at the top of the screen where a menu would be you should see the name of the module – ship, right under that you should see a dropdown box with the word “(General)” and to the right of that you should see another dropdownbox with the word either “(Declarations)” or it might have opened to a default function. You want to scroll down that right hand dropdown box and look for the function call “ShipGetShippingLabel” <the functions are in alpha order>
  2. Go ahead and select it once you find it.
  3. Right there near the top after the declarations of variables, you should see the following lines of code. Please note that an apostrophe is a commented out line of code. The change should include the PR, AA, AE, AP. It will be obvious if the change isn’t there. If you want to fix yourself and you didn’t save the SEOrdman in a shared folder to just copy back over, simply comment out the line that only has that IF (ToCountry <> “US”) Then by putting an apostrophe in front of the “IF”
    and copy the long line of code below and just past under the ‘IF (ToCountry <> “US”) Then such that it would look as below.

   

    ToCountry = ShipCheckCountryCode(ToCountry)

   

    '2/26/2020:SCH - open international form

    gsShipItems = ""

    'This change is for a change that must have happened in APO shipping because ehubs information was working fine but then it didn't.
    ‘IF (ToCountry <> “US”) Then

    If (ToCountry <> "US") Or (ToCountry = "US" And ((ToState = "PR") Or (ToState = "AA") Or (ToState = "AE") Or (ToState = "AP"))) Then

        DoCmd.OpenForm "ShipItInternational", , , , , acDialog

        If gsShipItems = "Cancel" Then

            GoTo Exit_ShipGetShippingLabel

        End If

    End If

  1. After you have the new IF statement, go ahead and find the Save icon (looks just like word save icon) at the top on your toolbar or do a File-Save, then you can also recompile by going to Debug->Compile Seordman
  2. Now you are done you can close the debug/code window and can go ahead and test.

If you simply just wanted to check if the code was there, and it isn’t, and you don’t want to do the change on your own, just email me and I can do it for you.

Also, our next release, which I am not sure what number it will be nor when it is coming out, has this change in it. So it will be in the code permanently.


--
You received this message because you are subscribed to the Google Groups "Stone Edge User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to stoneedge+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/stoneedge/bf01550a-d27d-441c-b5e4-425d60e1133cn%40googlegroups.com.


--
Alexander Osborne
Warehouse Operations Manager
"I don't feel right unless I have a sport to play or at least a way to work up a sweat." - Henry Louis Aaron

Paul Christel

unread,
Jul 8, 2021, 10:12:27 AM7/8/21
to Alex Osborne, Shaul Dover, Stone Edge User Group

For those printing international labels on the latest version, are the correct Country of Origin codes populating or do they show “US” for all lines?

 

Paul

Steve Kocourek

unread,
Jul 8, 2021, 10:19:57 AM7/8/21
to Stone Edge User Group
You may want to update the new conditional even further to include US territories, as they require customs paperwork as well.  in my example below I've added Guam, Virgin Islands, and American Samoa.

 If (ToCountry <> "US") Or (ToCountry = "US" And ((ToState = "PR") Or (ToState = "AA") Or (ToState = "AE") Or (ToState = "AP") Or (ToState = "GU") Or (ToState = "VI") Or (ToState = "AS"))) Then

Paul Christel

unread,
Jul 8, 2021, 10:47:01 AM7/8/21
to Steve Kocourek, Stone Edge User Group

I don’t believe this paperwork is required for US Virgin Islands or Puerto Rico via USPS.  It is required when shipping via UPS and FedEx.

 

 

Paul

 

From: ston...@googlegroups.com <ston...@googlegroups.com> On Behalf Of Steve Kocourek
Sent: Thursday, July 8, 2021 9:20 AM
To: Stone Edge User Group <ston...@googlegroups.com>
Subject: Re: [Stone Edge User Group] Shipping Label to APO address

 

You may want to update the new conditional even further to include US territories, as they require customs paperwork as well.  in my example below I've added Guam, Virgin Islands, and American Samoa.

 

 If (ToCountry <> "US") Or (ToCountry = "US" And ((ToState = "PR") Or (ToState = "AA") Or (ToState = "AE") Or (ToState = "AP") Or (ToState = "GU") Or (ToState = "VI") Or (ToState = "AS"))) Then

 

--

You received this message because you are subscribed to the Google Groups "Stone Edge User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to stoneedge+...@googlegroups.com.

John Frazar

unread,
Jul 8, 2021, 11:47:04 AM7/8/21
to Shaul Dover, Stone Edge User Group
Shaul - Are you sure you’re on the latest version?  I have confirmed that this was fixed in 7.724.

On Thu, Jul 8, 2021 at 9:07 AM Shaul Dover <shaul...@gmail.com> wrote:
--
You received this message because you are subscribed to the Google Groups "Stone Edge User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to stoneedge+...@googlegroups.com.

Shaul Dover

unread,
Jul 8, 2021, 12:06:31 PM7/8/21
to Stone Edge User Group
Thank you all for the fix etc. Appriciate it. 
Thnak you John for pointing on the new update. 

Shaul Dover

unread,
Jul 25, 2021, 8:59:59 AM7/25/21
to Stone Edge User Group

I am on the latest version and still, shipment to Australia printed only one USPS sticker, not 3 (with the long custom form). 
Reply all
Reply to author
Forward
0 new messages