How do I import an EDI invoice?
Learn how to import an EDI invoice into XSite so your purchase orders match what was delivered.
Introduction
Importing an EDI invoice saves time and reduces errors by pulling invoice details directly from your supplier into XSite. This guide shows you how to upload an EDI file and review the purchase order for accuracy.
In XSiteIO
- Go to ‘Price Book’ in the side menu, then select ‘Inventory’, and click on ‘Purchase Orders’.
- Use the ‘Site(s)’ dropdown to choose your store location.
- Use the ‘Supplier’ dropdown to pick the supplier you got the EDI file from.
- Click ‘New PO’ and choose the type of EDI invoice you want to import.
- Upload the EDI file by either clicking the dotted box to find the file or dragging the file into the box.
- Do not open or change the file before uploading.
- Click the order number in the ‘Number’ column to open and review it.
- Add any missing items if needed.
- Under ‘Financial’, enter any discounts or taxes.
- Under ‘General’, enter the Expected/Received date.
- In ‘Details’, choose the payment method.
- Add shipping info in ‘Ship Via’, Freight on Board, and Terms fields if needed.
- Enter the Buyer’s name and fill in the Freight details.
- Review items under ‘New Products’ to check for duplicates or new items.
- Click the ‘Save’ button at the top to complete the import.
In XSite Classic
- Go to ‘Inventory’ in the side menu, then click on ‘Purchase Orders’.
- Use the ‘Site’ dropdown to choose the store location.
- Use the ‘Supplier’ dropdown to pick the correct supplier.
- Click ‘Create/Import’, then choose the type of EDI invoice.
- For Coremark, select “Import EDI.”
- Upload the EDI file by clicking the grey box or dragging the file into it.
- Use the file exactly as provided—do not modify it.
- Click the order number under the ‘Number’ column to open and review.
- Add items manually if needed.
- Under ‘Financial’, add any discounts and taxes.
- Under ‘General’, enter the Expected/Received date.
- In ‘Details’, select the payment method.
- Enter shipping info under ‘Ship Via’, Freight on Board, and Terms.
- Fill in the Buyer name and any extra notes in the Freight section.
- Review any flagged ‘New Products’ to decide if they need to be added to the Price Book.
- Click the ‘Save’ button at the top to finish the import.