<BACK
Advanced Shipping
Notice, Invoice Import/Export Reducing the data entry at the
time inventory is received and improving the integrity of
the inventory data is the
primary goal of using advanced shipping notices (ASN) or
electronic invoices. Multiple invoices can be contained in
the same file using the <invoice> tag. ASN's can also
be used to create a new purchase order.
XML Schema
Example
<?xml version = "1.0"?>
<
ivrecv custid="100">
<invoice storeno="1"
pono= " "
invoiceno="118 "
aprefno=" "
contact="JOE "
shipdate="07/05/2001"
total=" 119.18"
terms="NET 30 "
duedate="07/13/2001"
ivudfc1=" "
ivudfc2=" "
ivudfc3=" "
ivudfc4=" "
ivudfc5=" "
ivudfd1=" / / "
ldate=" / / ">
<items>
<item itemcode="100 "
xref="ABC "
desc="Item Description"
style="Style"
recvqty=" 1.00"
discpct=" 0.00"
cost=" 39.4346"
extcost=" 39.43"
shipcost=" 0.0000"/>
<item itemcode="101 "
xref="BCA "
desc="Item Description"
style="Style"
recvqty=" 20.00"
discpct=" 0.00"
cost=" 0.9962"
extcost=" 19.92"
shipcost=" 0.0000"/>
<item itemcode="702 "
xref="702-12 "
desc="Item Description"
style="Style"
recvqty=" 2.00"
discpct=" 0.00"
cost=" 29.9144"
extcost=" 59.83"
shipcost=" 0.0000"/>
<item itemcode="XXXXXXXXXXXXXX "
xref="XXXXXXXXXXXXXXX "
desc="Item Description"
style="Style"
recvqty=" 1.00"
discpct=" 0.00"
cost=" 1.0000"
extcost=" 1.00"
shipcost=" 0.0000"/>
</items>
</invoice>
</ivrecv>
<BACK
Gift Card Pre-Printed Gift Card System import.
XML Schema
Example
<?xml version = "1.0"?>
<gifts imsserial="00001">
<gift
storeno="0001"
giftno="212345678"
gifttype=""
fname="Jill"
lname="Jones"
phone="111-999-8888"
amount="-50.00"
balance="-50.00"
paydate="11/05/92"
payamt="0"
chrgdate="11/05/92"
chrgamt="0"
upstat="true"
giftcard="false"
active="false"
giftudfc1=""
giftudfc2=""
giftudfc3=""
giftudfc4=""
giftudfc5=""
giftudfd1=""
giftudfd2=""
fdate="12/04/00"
ldate="12/04/00"
notes=""/>
<gift
storeno="0001"
giftno="212345679"
gifttype=""
fname="John"
lname="Doe"
phone="111-999-9999"
amount="-100.00"
balance="-100.00"
paydate="11/05/92"
payamt="100.00"
chrgdate="11/05/92"
chrgamt="0"
upstat="true"
giftcard="false"
active="false"
giftudfc1=""
giftudfc2=""
giftudfc3=""
giftudfc4=""
giftudfc5=""
giftudfd1=""
giftudfd2=""
fdate="12/04/00"
ldate="12/04/00"
notes=""/>
</gifts>
<BACK
Group Price Change
There are two version of this file. Retail
price based upon the item code or vendor management of retail
prices based
upon the vendors part number.
XML Schema
Example with Item Code
<?xml version = "1.0"?>
<pricechange>
<items>
<item itemcode="100"
cost="10.9000"
price1="18.1667"
price2="15.5714"
retail="21.8000"/>
<item itemcode="101"
cost="19.1300"
price1="31.8833"
price2="27.3286"
retail="38.2600"/>
<item itemcode="XXXXXXXXXXXXXXX"
cost="99.9900"
price1="999.9900"
price2="799.9900"
retail="9999.9900"/>
</items>
</pricechange>
Example with Vendor Part Number
<?xml version = "1.0"?>
<pricechange>
<items>
<item part="ABC"
cost="10.9000"
price1="18.1667"
price2="15.5714"
retail="21.8000"/>
<item part="BCA"
cost="19.1300"
price1="31.8833"
price2="27.3286"
retail="38.2600"/>
<item part="XXXXXXXXXXXXXXX"
cost="19.1300"
price1="31.8833"
price2="27.3286"
retail="38.2600"/>
</items>
</pricechange>
<BACK
Mail List
Data from websites, mail list servers, and other sources can
be imported into the Data, Mail List function.
XML Schema
Example
<?xml version = "1.0"?>
<maillist>
<mailimp
mailno="8005477120"
fname="Jeff"
lname="Helland"
mname="Robert"
address1="940 Industrial Drive"
address2="Suite 107"
city="Sauk Rapids"
state="MN"
zip="56379"
country=""
phone="800-547-7120"
extension=""
fax=""
email="sales@arss.com"
status1="1"
status2="5"
pricecode="1"
discount="0.00"
taxidno="123-45-6789"
mailudfc1="Field 1"
mailudfc2="Field 2"
mailudfc3="Field 3"
mailudfc4="Field 4"
mailudfc5="Field 5"
mailudfd1="01-01-1990"
mailudfd2="12-31-1990"
notes="Here is a note."
addrudfc1="Field 1"
addrudfc2="Field 2"
addrudfc3="Field 3"
addrudfc4="Field 4"
addrudfc5="Field 5"
addrudfd1="01-01-1990"
addrudfd2="12-31-1990"
addrnotes="Here is an address note."/>
<mailimp
mailno="8005551212"
fname="Dan"
lname="Lauer"
mname="Oliver"
address1="ARS Business Solutions, LLC."
address2="940 Industrial Drive, Suite 107"
city="Sauk Rapids"
state="MN"
zip="56379"
country="USA"
phone="800-547-7120"
extension="119"
fax="208-765-3657"
email="ddl@arss.com"
status1="0"
status2="0"
pricecode="2"
discount="10.00"
taxidno="987-65-4321"
mailudfc1=""
mailudfc2=""
mailudfc3=""
mailudfc4=""
mailudfc5=""
mailudfd1=""
mailudfd2=""
notes="A cowboy"
addrudfc1="Field 1"
addrudfc2="Field 2"
addrudfc3="Field 3"
addrudfc4="Field 4"
addrudfc5="Field 5"
addrudfd1="01-01-1990"
addrudfd2="12-31-1990"
addrnotes="Here is an address note."/>
</maillist>
Physical Inventory
Data from Laptops, Handheld Computers, Portable
Data Terminals, Portable Data Assistants, Service Providers
can be imported
into the Physical Inventory Process.
XML Schema
Example
<?xml version = "1.0"?>
<physicalcount>
<items>
<item itemcode="100"
qohcount="8"/>
<item itemcode="101"
qohcount="9"/>
<item itemcode="XXXXXXXXXXXXXXX"
qohcount="10"/>
<item itemcode="702"
qohcount="24"/>
</items>
</physicalcount>
<BACK
Promotions
XML Schema
Example
<?xml version = "1.0"?>
<promotions>
<promotion>
<name>ARS</name>
<startdate>2000-01-01</startdate>
<stopdate>2001-01-01</stopdate>
<items>
<item>
<itemcode>100</itemcode>
<discprice>54.9900</discprice>
</item>
<item>
<itemcode>04133344001</itemcode>
<discamt>5.0000</discamt>
</item>
<item>
<itemcode>XXXXXXXXXXXXXXX</itemcode>
<discamt>899.9900</discamt>
</item>
</items>
</promotion>
</promotions>
<BACK
Purchase Order Export
Sending or receiving an order electronically
reduces labor cost. Data entry errors are eliminated by handling
less paper
documents. New purchase orders can be imported into the
system using the Advanced Shipping Notice Import.
XML Schema
Example
<?xml version = "1.0"?>
<orders>
<order
storeno="0001"
pono="419"
vendor="ACME"
contact=""
orderdate="7/12/2002"
shipdate="7/12/2002"
canceldate="7/12/2002"
shipvia=""
fob=""
terms=""
duedate="7/12/2002"
fax=""
shipid="1"
saddr1="ARS Solutions Dock"
saddr2="Dock 1"
saddr3="940 Industrial Dr"
saddr4="SAUK RAPIDS MN 56379"
custid="2"
baddr1="ARS Solutions"
baddr2="Suite 107"
baddr3="940 Industrial Dr"
baddr4="SAUK RAPIDS MN 56379"
cancelbo="FALSE"
poudfc1=""
poudfc2=""
poudfc3=""
poudfc4=""
poudfc5=""
poudfd1=" / / "
poudfd2=" / / ">
<items>
<item
xref="ABC"
itemcode="100"
desc1="Item Description"
desc2=""
ordqty="3"
pkgqty="1"
unitpkg="1"
discpct="0"
cost="21.4625"
shipcost="0"/>
<item
xref="BCA"
itemcode="101"
desc1="Item Description"
desc2=""
ordqty="2"
pkgqty="1"
unitpkg="1"
discpct="0"
cost="21.8875"
shipcost="0"/>
<item
xref="702-12"
itemcode="702"
desc1="Item Description"
desc2=""
ordqty="5"
pkgqty="1"
unitpkg="1"
discpct="0"
cost="22.3125"
shipcost="0" />
<item
xref="XXXXXXXXXXXXXXX"
itemcode="XXXXXXXXXXXXXXX"
desc1="Item Description"
desc2=""
ordqty="5"
pkgqty="1"
unitpkg="1"
discpct="0"
cost="22.3125"
shipcost="0"/>
</items>
</order>
</orders>
<BACK
Reservations
Sending or receiving reservations electronically
reduces labor cost and data entry errors be eliminating the
handling of
physical paper. Mutiple orders can be sent in the same
XML File by including additional <reservation> tags.
XML
Schema
Example
<?xml version = "1.0"?>
<reservations>
<reservation
storeno="0001"
orderno="237 "
clerkno="001 "
orderdate="07/10/2001"
mailno="1234567 "
pricecode="1 "
email="LoinCloth@excite.com "
contact="Joe "
sfname="Carol "
sname="Kramer "
saddr1="9876 Something Way "
saddr2="P.o. Box A-1 "
scity="Sauk Rapids "
sstate="MN"
szip="56379 "
scntry="USA "
sphone="222-333-4444"
totalgoods=" 14.92"
tax=" 0.97"
freight=" 0.00"
pickuptime="08/01/2001 12:00:00 AM"
returntime="08/02/2001 02:30:00 PM"
rvudfc1="udf1 "
rvudfc2="udf2 "
rvudfc3="udf3 "
rvudfc4="udf4 "
rvudfc5="udf5 "
rvudfd1="12/11/2001"
rvudfd2="12/11/2001"
notes="Reserve this.">
<items>
<item itemcode="230288 "
logno=" 1061"
shipqty=" 1.00"
price=" 659.0000"
discpct=" 1.15"
discamt=" 2.0000"
extdisc=" 2.00"
netsale=" 659.00"
notes="This is a reservation item."/>
<item itemcode="0362820139 "
logno=" 1061"
shipqty=" 1.00"
price=" 659.0000"
discpct=" 1.15"
discamt=" 2.0000"
extdisc=" 2.00"
netsale=" 659.00"
notes="This is a reservation item."/>
</items>
</reservation>
</reservations>
<BACK
Sales Order Entry Import
Sending or receiving an order electronically reduces labor
cost and data entry errors by eliminating the handling of
physical paper.
Multiple orders can be sent in the same XML
File by including additional <orders > tags.
The itemcode
could be substituted with xref tags.
Clerkno tag if omitted
will be assigned the first clerk in alphabetical order.
A/R Account Fname, Name, Phone, Email will be populated when omitted or empty. A/R Account
Address1, Address 2 or City, State, Zip will be populated when
omitted or empty. The above data in the xml will not update the
A/R Account or Address.
Mail List Fname, Name, Phone, Email will be populated when omitted or empty.
Mail List
Address1 and Address 2 or City and State and Zip will be populated when
omitted or empty. The above data in the xml will not update the
Mail List or Address.
XML Schema
Example
<?xml version = "1.0"?>
<orders>
<order quote="false"
lprtinv="true"
lprtlbl="false"
storeno="0001"
orderno="237 "
custpono="1234567 "
arno="2922 "
mailno="1008 "
clerkno =
"100"
pricecode="1 "
email="eds@smith.net "
contact="Joe "
fname=" "
name="Ed Smith
Company "
address1="222 Any
Ave. So. "
address2=" "
city="Minneapolis "
state="MN"
zip="55631 "
country="USA "
phone="111-333-2222"
sfname="Jeff "
sname="Old Archery Club "
saddr1="111 Some Ave. North "
saddr2=" "
scity="Sauk Rapids "
sstate="MN"
szip="56379 "
scntry="USA "
sphone="612-252-4193"
orderdate="07/25/2001"
shipdate="07/25/2001"
shipvia="BEST WAY "
fob=" "
terms="NET 30 "
cctype=" "
ccno=" "
ccexpdate=" "
avsaddress=" "
avszip=" "
authorize=" "
totalgoods=" 135.76"
packages=" 0"
freight=" 0.00"
taxamt=" 6.61"
soudfc1=" "
soudfc2=" "
soudfc3=" "
soudfc4=" "
soudfc5=" "
soudfd1="07/18/2001"
soudfd2="07/18/2001"
notes="">
<items>
<item itemcode="100 "
ordqty=" 2.00"
shipqty=" 2.00"
discpct=" 0.00"
discamt=" 0.0000"
price= " 54.9900"
extdisc=" 0.00"
netsale=" 109.98"
notes=""
course=""/>
<item itemcode="101 "
ordqty=" 2.00"
shipqty=" 1.00"
discpct=" 01.00"
discamt=" 1.0000"
price= " 12.8900"
extdisc=" 0.00"
netsale=" 25.78"
notes=""
course=""/>
<item itemcode="XXXXXXXXXXXXXXX"
ordqty=" 1.00"
shipqty=" 1.00"
discpct=" 01.00"
discamt=" 1.0000"
price= " 1.0000"
extdisc=" 0.00"
netsale=" 1.00"
notes=""
course=""/>
</items>
<gifts>
<gift giftno="404012511" amount="40" />
<gift giftno="400012511" amount="20" />
</gifts>
</order>
</orders>
<BACK
Store Transfer Out
Store to store transfers can be done through
an interface option. This allows request for inventory to
be sent directly to
a store using an external program.
XML Schema
Example
<
?xml version = "1.0"?>
<transferout>
<store storeno="1">
<items>
<item itemcode="100" qty="5"/>
<item itemcode="999999999999999" qty="2"/>
</items>
</store>
<store storeno="2">
<items>
<item itemcode="100" qty="3" />
<item itemcode="999999999999999" qty="4"/>
</items>
</store>
</transferout>
<BACK
Vendor Catalogs
Data from a vendor can be directly imported
into the ARS Version 5 Vendor Catalog option.
XML Schema
Example
<
?xml version = "1.0"?>
<catalog>
<item part="230-288"
factory="GC120"
upc="04317891002"
upccheck=""
desc1="DAIWA GC120 GOLDCAST REEL"
desc2="12LB MH 1BB SPINCAST BOX MP 10"
size=""
color=""
other=""
meas="EA"
ctlgpage=""
class="6"
mfg=""
qty="23"
cost="39.9900"
retail="49.95"
weight="0"
pkgqty="1"
pkgmin="1"/>
<item part="151-228"
factory="2885891"
upc="07650100363"
upccheck=""
desc1="COLEMAN 288-5891 LANTGENERATOR"
desc2="FITS MODEL 288 & 286 MP 6"
size=""
color=""
other=""
meas="EA"
ctlgpage=""
class="352"
mfg="" qty="47"
cost="5.8900"
retail="9.99"
weight="0"
pkgqty="1"
pkgmin="1"/>
</catalog>
<BACK
Work Orders
Sending or receiving an order electronically from
a website or another application reduces labor cost and data
entry
errors be eliminating the handling of physical paper. Mutiple
orders can be sent in the same XML File by including additional <wo > tags.
<?xml version = "1.0"?>
<workorders>
<workorder
storeno="0001"
orderno="237 "
clerkno="001 "
orderdate="07/10/2001"
mailno="1234567 "
pricecode="1 "
email="some@anyone.com"
contact=" "
sfname="Carol "
sname="Kramer "
saddr1="9876 Something Way "
saddr2="P.o. Box A-1 "
scity="Sauk Rapids "
sstate="MN"
szip="56379 "
scntry="USA "
sphone="222-333-4444"
itemcode="28 "
logno=" 1062"
serial="sn12345 "
estfinish="12/12/2001"
estimate=" 12.00"
woudfc1="udf1 "
woudfc2="udf2 "
woudfc3="udf3 "
woudfc4="udf4 "
woudfc5="udf5 "
woudfd1="12/11/2001"
woudfd2="12/11/2001"
problem="Doesn't work.">
<items>
<item itemcode="100 "
shipqty=" 1.00"
price=" 54.9900"
discpct=" 1.15"
discamt=" 2.0000"
extdisc=" 2.00"
netsale=" 54.9900"
notes="This is a work order item."/>
<item itemcode="101 "
shipqty=" 1.00"
price=" 39.9900"
discpct=" 10.00"
discamt=" 3.9900"
extdisc=" 7.98"
netsale=" 64.02"
notes="This is a work order item."/>
</items>
</workorder>
</workorders>
<BACK
|
