Topic Options
#37036 - 05/21/13 05:57 AM Order Entry Import
MikeS Offline
Adagio Specialist

Registered: 10/25/10
Posts: 337
Loc: Concord, On
Is it possible to import empty fields into an order? We have a ShipTo code that is called 'Blank' with a Ship Name "Same". All other ship to fields are empty. This occurs about 50% of the time. The other 50% could have information in any or all of the ship to fields. I've tried using blank fields and non-standard characters '☻' which returned a '?'.

I've even taken out the shipto altogether with the idea that it's easier to put a couple of lines in than take eight out. No luck - it defaults to the Bill To fields.

Thanks


Edited by MikeS (05/21/13 06:06 AM)
_________________________
Mike Smith
Viktorian Sheet Metal Mfg Inc

Top
#37043 - 05/21/13 11:42 AM Re: Order Entry Import [Re: MikeS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11550
Loc: Vancouver, BC Canada
Hi Mike,

In the Import Order Notes page of the Order Entry help file here is some information about ShipTo addresses:

- If any Hdr-Shipto fields are imported, then the import file is exclusively used for this information.

- If only the Hdr-Shipto Code is imported and none of the other address fields, it can be placed either by itself on an ‘S’ line, or combined with other header fields on the ‘H’ line.

- If Hdr-Shipto fields are not imported, the Customer default ship-to code is used and if that is blank, then one from the Entry template is used. If blank there, then ship-to fields will contain the same information as the respective Bill-to fields (except contact and email, which are always separate).

So on your line that has the "S" and ship to fields, you cannot have any of the other ship-to address codes, in the file or the import order template, if you want the 'blank' ship-to code to be used to get the address lines from that record.
---
I had to open the Help file and from the Search Tab, do a search on 'import'. This page is #2 on the list. I couldn't find a direct link to this page from the standard import help (like we have in most other Adagio help files).
---
It's generally not good practise to have a ship to address record with a blank code value, and what you are running into is a good example of why. The program has to make a decision that a blank field means to look for a record, rather than falling back to a different default (in this case, the entry template), and really that's a decision that the program shouldn't have to make. Instead, have a ship-to code called 'SAME' if that is the intended usage. OrderEntry supports exporting and importing ship-to address codes, so creating the list and re-importing with a non-blank code should be relatively easy.
_________________________
Regards,
Softrak Tech Support

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 86 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30