XML Purchase Order Outputs

Parent Previous Next

XML Purchase Order Outputs



To support the change to send PO’s as an XML document, the following changes must be made in your database.  If you are processing more than one company (multi-entity), the changes must be made in each company:


From the Main Menu Go To, CRM/ Contacts Management/ Maintenance/ Company/ Company Locations


1. Query your Vendor in the database and make the following changes:



Web Site                Enter the vendors website address.



2. Click the ‘More’ button.  In the ‘User Defined’ section of the form, enter:


- Company Identifier for EDI        Two positions, required field.

- Vendor Identifier                        Three position Vendor Reference, required field


Note:  These labels are set in the Contact Control Record and may not be defined, but will be the fields in the same position.



3. Click on the ‘Vendor Location’ tab.  Check the box ‘EDI Capable’.



4. Save and Exit


Setting up Vendor Cross Reference Data



CRM/ Contacts Management/ Maintenance/ Company/ Vendor Cross Reference


Note:  Vendor Cross Reference records cannot use the function to bypass options for a vendor.




Setup Vendor Entity Information


CRM/ Contacts Management/ Maintenance/ Company/ Vendor Entity Information


This form is used to define data used in the PO creation and EDI process to communicate required information to a vendor.




Note:  This is a maintenance form and does not display existing records unless queried.


Vendor Number                  Enter the Vendor Number for the EDI vendor.The name will display           to the right.


Sales Department                 Select the Sales Department this record is for. Records must be               defined for each Vendor/Sales Department combination.


Customer No from Vendor        This is your customer number with the selected vendor, for the                defined Sales Department.


Contract No from Vendor        If this vendor has a special pricing contract number, enter your                default number.

Location Number                Select a default Inventory location.


Save and Exit.



Printing Electronic Purchase Orders


Khameleon’s Invoice Sub-Entity allows you to define, by Sales Department, certain output options for XML documents.


From the Main Menu, Go to Setup/ System Setup/ Maintenance/ Controls/ Invoice Sub-Entity Control



Khameleon will default the first Sales Department defined.  Use your ‘next record’ arrow on the tool bar to navigate to the Sales Department in question.  Click the ‘Defaults’ tab and define the following:

       

Description        Using the drop down arrow, select the ‘Electronic Purchase Order Export’


Default        Enter the path to create the XML document records.  This may be a local or network path.

User        Using the list of values, you may define this record for each specific Khameleon user.  If left blank, this setting is global for all users.


Save and Exit.


Print Purchase Orders


Distribution/ Purchasing/ Processing/ Purchase Orders/ Print Orders



When printing Purchase Orders, the checkbox ‘Create EDI PO’s’ must be checked to create the XML document.  ‘Print EDI PO’s’ may optionally be checked to also print a copy of the Purchase Order.


Note:  In Distribution/ Purchase Orders/ Maintenance/ Controls/ Control Record – PO there is a default for the ‘Create EDI PO’s’ checkbox that may be set so users do not have to remember to check this box.


Note: When selecting to reprint Purchase Orders, there is a optional checkbox to reset for EDI if a new file must also be created.


The output of this process may then be used to send the PO electronically to your vendor.



Sample:


<?xml version="1.0" encoding="UTF-8" ?>

- <Envelope SchemaVersion="04.00.01" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ofdaxml.org/schema" xmlns="http://www.ofdaxml.org/schema">

- <Header>

- <Vendor>

- <Enterprise>

  <Code>www.haworth.com</Code>

  </Enterprise>

  <Code>HAW</Code>

  </Vendor>

  <Language>en-US</Language>

  <Currency>USD</Currency>

  </Header>

- <PurchaseOrder>

- <Header>

  <PONumber Version="00">EM200.001.01</PONumber>

  <TransactionCode>New</TransactionCode>

  <CreatedDate>2010-08-09</CreatedDate>

  <RequestedDate Type="DeliverOnOrBefore">2010-03-23</RequestedDate>

- <Comment>

  <Type>SHIPPING INSTRUCTION</Type>

  <Description>CBD248019245200Receiving Manag</Description>

  </Comment>

- <Comment>

  <Type>SHIPPING ATTENTION</Type>

  <Description>8019245200Receiving Manag</Description>

  </Comment>

- <Comment>

  <Type>ORDER NOTE</Type>

  <Description />

  </Comment>

  <OrderType>0</OrderType>

- <Contract>

  <Code>A00000</Code>

  <Description>SPECIAL</Description>

  <SalesVolume>1</SalesVolume>

  </Contract>

  </Header>

- <Profile>

  <Type>ShipTo</Type>

  <Code>N/A</Code>

- <Location>

  <Address>6454 Centre Park Dr.</Address>

  <Address />

  <City>WEST CHESTER</City>

  <StateOrProvince>OH</StateOrProvince>

  <Country>US</Country>

  <PostalCode>45069</PostalCode>

  </Location>

  <Name>MetLife</Name>

- <Contact>

  <Type>Contact</Type>

  <Name>UKN</Name>

- <Phone>

  <Type>Business</Type>

  <Number />

  </Phone>

  </Contact>

- <Contact>

  <Type>Attention</Type>

  <Name>UKN</Name>

- <Phone>

  <Type>Business</Type>

  <Number />

  </Phone>

  </Contact>

- <Contact>

  <Type>CallBeforeDelivery</Type>

  <Name>CBD248019245200Receiving Manag</Name>

  </Contact>

  </Profile>

- <Profile>

  <Type>SoldTo</Type>

  <Code>DEALERN</Code>

- <Location>

  <Address>7001 Innerplan Drive</Address>

  <Address />

  <City>North Little Rock</City>

  <StateOrProvince>AR</StateOrProvince>

  <Country>US</Country>

  <PostalCode>72113</PostalCode>

  </Location>

  <Name>Innerplan</Name>

- <Contact>

  <Type>Contact</Type>

  <Name>CBD OPERATIONS MANAGER</Name>

- <Phone>

  <Type>Business</Type>

  <Number>800.211.9253</Number>

  </Phone>

  </Contact>

- <Contact>

  <Type>Attention</Type>

  <Name>CBD OPERATIONS MANAGER</Name>

  </Contact>

- <Contact>

  <Type>Salesperson</Type>

  <Name>Mike Green</Name>

  </Contact>

  </Profile>

- <Profile>

  <Type>EndCustomer</Type>

  <Code>N/A</Code>

- <Location>

  <Code />

  <Address>6454 Centre Park Dr.</Address>

  <Address />

  <City>WEST CHESTER</City>

  <StateOrProvince>OH</StateOrProvince>

  <Country>US</Country>

  <PostalCode>45069</PostalCode>

  </Location>

  <Name>MetLife</Name>

- <Contact>

  <Type>Contact</Type>

  <Name />

- <Phone>

  <Type>Business</Type>

  <Number />

  </Phone>

  </Contact>

  <PONumber>PO 1234</PONumber>

  </Profile>

- <OrderLineItem>

  <VendorRef EnterpriseRef="www.haworth.com">HAW</VendorRef>

  <Quantity>2</Quantity>

  <LineItemNumber>0001</LineItemNumber>

- <Price>

  <PublishedPrice>919</PublishedPrice>

  <OrderDealerPrice>351.52</OrderDealerPrice>

  <DiscountCategory>CANDOR</DiscountCategory>

  <OrderDealerDiscount>61.75</OrderDealerDiscount>

  </Price>

- <Tag>

  <Type>Tag</Type>

  <Value>CANDOR</Value>

  </Tag>

- <SpecItem>

  <Number>SAS-22-A1A</Number>

  <Description>CANDOR,SIDE CHAIR,FABRIC W/FABRIC BACK</Description>

- <Catalog>

  <Code>COM</Code>

  </Catalog>

- <Option Sequence="1">

  <Code>(A1A)</Code>

  <Description>FORMAL ARM,FULLY UPH,ANGL</Description>

  </Option>

- <Option Sequence="2">

  <Code>,7G</Code>

  <Description>-WEIMER</Description>

  </Option>

- <Option Sequence="3">

  <Code>AA4</Code>

  <Description>CANDLE</Description>

  </Option>

- <Option Sequence="4">

  <Code>,7G</Code>

  <Description>-WEIMER</Description>

  </Option>

- <Option Sequence="5">

  <Code>AA4</Code>

  <Description>CANDLE</Description>

  </Option>

- <Option Sequence="6">

  <Code>,M3</Code>

  <Description>-BEECH - SEATING</Description>

  </Option>

- <Option Sequence="7">

  <Code>W31</Code>

  <Description>RETRO ON BEECH</Description>

  </Option>

  </SpecItem>

  </OrderLineItem>