Note: For each supplier, there is an internal (set up) KBA and public (send and receive files) KBA.

This article provides instruction and information on the following:

 

EDI file system enhancements

All unprocessed EDI files reside in the EDI supplier’s main folder (C:PaladinPOSExport), and a copy of all processed files will be in the supplier’s backup folder (C:PaladinPOSExportbackup). 

After EDI files are downloaded, a date stamp is added to the file name. Files remain in the supplier’s main folder until they are processed. This allows multiple unprocessed EDI files to reside in the same folder. After EDI files are processed, the original file is deleted for all suppliers.

Note: A copy of the EDI file is always created before the file is processed and is always available in the supplier’s backup folder.

When you use the EDI Preview feature, the downloaded EDI file is not modified or moved.

Back to Top

EDI Preview

If there is a need to delay processing a particular download until you have adequate staff to distribute all the new bin tags, Paladin has a Preview option that processes the entire EDI file and generates reports you are familiar with, but NO changes are made to your system.

To use this feature:

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, select F9 EDI.
  3. In the EDI Processing window, click Download Files (there is also the option to Browse for specific files). 
  4. Once you files have downloaded the files, a window appears where you can select Preview Only.

If you decide to preview, all progress indicators function the same as real processing. 

Back to Top

EDI processing tied to open purchase orders

In Paladin, every line of an EDI invoice directly updates the open purchase order(s) used to create the electronic order. This provides an automatic means to support both backorders from your EDI suppliers and maintain quantity on orders from suppliers other than your primary EDI source. 

A screen displays at the conclusion of an EDI invoice processing event that presents a list of open purchase orders for the supplier you are processing. Each PO displays a PO number, date, number of line items, PO cost, received cost, and a checkbox indicating if this PO has been closed.


Figure 1: Find PO window/Matching Purchase Orders

Each PO displays a value for the stock received that matched the PO. There are two tools to finish the receiving event:

  • Received Items Report: Highlight a PO and click Received Items Report to see a line-by-line detail of what was ordered, received, backordered, and/or canceled. If you are unsure if the remaining items on order should stay on order, or have their backorders canceled, this tool helps with that determination.
  • Close Selected POs: Check the box to the left of any PO you want to cancel backorders on for all unreceived product. Click Close Selected POs. A display indicates these purchase orders have been “Closed” and will not display the next time an EDI invoice is processed for this supplier.

Note: Any PO line item with an outstanding backorder quantity is still on order and will be displayed as such in the inventory screens, reports, and suggested order calculations. If unreceived items are likely to never be received, cancel the backorders by highlighting the PO and click Cancel Backorder.

If you exit this screen without canceling one or more outstanding purchase orders, you can still close these purchase orders by following these steps:

  1. In Paladin, on the top ribbon, select the PO module.
  2. Press F5 Mode PO to change to Mode Receive.
  3. Press F6 Find PO.
  4. Enter the supplier you have been working with. From this screen, you have all the options listed above.

If you need line-by-line control, perform the following:

  1. Highlight the desired PO.
  2. Press F12 Open.
  3. Highlight all PO lines
  4. Press F3 Zero Qty Received.
  5. Scroll to the individual line(s) to cancel.
  6. Check Del on the left side of the screen.
  7. When complete, press F8 Process.
  8. Press F1 Process to complete the task.

Limitations: Virtually no EDI supplier allows Paladin to transmit your PO number to them; therefore, they don’t transmit your PO number back to you. When an EDI invoice line is processed, Paladin looks in all open purchase orders for a match. A match may or may not be the specific PO used to order this item, but the item was ordered and is now received. Items received from the supplier that were not found on any open PO are received to stock, but no updates have been performed on purchase orders. If a received quantity is greater than the quantity ordered on a PO, other purchase orders are searched in an attempt to place the remaining received quantity with other purchase orders. If no other orders for this item are found, the received quantity of the first PO contains the entire received amount.

Feature Startup: Since EDI based purchase orders have never been closed, most stores have hundreds, if not thousands, of past EDI purchase orders open. To solve the potential overload this would present to users, Paladin automatically cancels backorders on all EDI suppliers. Most stores have this performed in the middle of the night during the daily (nightly) data validation. No purchase orders from non-EDI suppliers will be touched.

Back to Top

How to set EDI lock on unit of measure

Occasionally, incoming EDI data will change a Unit of Measure label that you have established on an item. Paladin can block that field for any inventory item you need to protect from your supplier’s data.

To enable this:

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. Enter the item’s part number in the Part # box.
  3. Press Enter.
  4. Select the General tab.
  5. In the Item Information pane, click the padlock at the end of the U/M list.
  6. Click F12 Save.

Back to Top

EDI processing safeguards

Note: EDI processes can only run one at a time.

If you try to start an EDI process while another EDI process is running, the new process is put on hold until the current process completes. Paladin will check every two minutes to see if it can start the new EDI process.

Figure 2 shows the message that appears in the EDI Processing window when your EDI process is waiting to start.


Figure 2: EDI Processing window when EDI process is waiting to start

Note: If you want to cancel the EDI process before it starts, click Cancel to close the EDI Processing window.

If the terminal currently running an EDI process is in another store, you will see the following variation of the message.


Figure 3: EDI Processing window when EDI process is in another store

When you manually update items and other information in Paladin, your updates are made individually in real-time. An EDI process is a batch process that updates large numbers of items all at the same time. If you run two or more batch processes at the same time, they may interfere with each other. By finishing an EDI process before starting another, you avoid any potential issues.

Additional protection for multi-store installations

Before an EDI process starts in a multi-store installation, Paladin tries to communicate with the shared enterprise database installed on the computer known as the publisher server. If communication with the database is not possible, the message shown in Figure 4 appears, and the EDI process is put on hold until the communication issue is corrected.

Important: If you see this message, this is a Store Down Emergency and you must do the following:

  1. Contact your network provider to restore the network connection.
  2. Report the emergency to Paladin Point of Sale Emergency Support.
    1. Call (800) 725-2346.
    2. Press 2 for Customer Support.
    3. Press 2 for Store Down Emergency.


Figure 4: EDI Processing window showing communication with the database is not possible

If you keep the EDI Processing window open when this message appears, Paladin will try to communicate with the publisher server every two minutes. Once the connection to the publisher server is established, the EDI process is started.

Back to Top

Duplicate EDI invoice safeguard

Paladin provides a safeguard to prevent invoices from being processed more than once by pausing EDI processing when a previously-processed invoice is identified. When this occurs, the EDI Processing message window opens. To continue EDI processing, in the EDI Processing message window, you must choose from these options:

  • Click No to skip the invoice and continue processing the file.
  • Click Yes to process the invoice anyway.
    • Caution: If you process the invoice, you may create a duplicate transaction and stock on hand quantities may be incorrect.

To apply your choice again to any other previously processed invoices in the current EDI invoice file, check Apply to All.


Figure 5: EDI Processing message/Apply to All

A record of your choices appears in the EDI Processing message log in the EDI Processing window. To print or save this log when EDI Processing is complete, click Print Log.


Figure 6: EDI Processing window/Print Log option

Back to Top

EDI processing protection during receiving

When you process an EDI invoice file to receive recently ordered items, Paladin first compares the number of items in the EDI file to the number of open purchase order items. If the difference is significant, a message appears, and you have the option to cancel the EDI process. This is designed to prevent you from processing an incomplete EDI file. If you receive this message, and didn’t expect to receive notably fewer items than you ordered, we recommend that you cancel the EDI process and ask the supplier to provide a new EDI invoice file.


Figure 7: EDI Processing message/Fewer items than are on order warning

What causes incomplete EDI invoice files?

You may download an incomplete file if the supplier was in the process of updating it or because of file transfer issues.

Back to Top

View and analyze EDI report data in an Excel workbook

To provide fast data access and intelligent analysis, EDI report data (available in the EDI Reporting window) is presented as an Excel workbook with individual Excel worksheets for each EDI report section.

Clearly labeled worksheet tabs and columns identify the data and match the labels from the prior PDF versions of the report. Report details are found on the first worksheet tab.


Figure 8: EDI Excel worksheet

The power of Excel makes it easy to organize, sort, and analyze the data on each spreadsheet. You can also print or share all or part of the report data with others.

Figures 9 and 10 show examples of Excel report organization for invoice and maintenance files. The worksheet column and tab names may be different for your EDI supplier.


Figure 9: EDI invoice file Excel report 


Figure 10: EDI Maintenance file Excel report

While most worksheet categories are intuitive, the following categories may need additional clarification:

Items on this worksheet 

Did not allow EDI updates to these inventory values because the values are locked 

EDI Lock Pricing Levels Group

Pricing tab > Pricing Levels pane values

EDI Lock Order QTY and/or Supplier Ratio

Order Control tab > Stock Information pane >  Order Qty value

Order Control tab > Suppliers pane > Sup. Ratio value

EDI Lock Item Cost Group

Pricing tab > Item Cost pane values

To access any EDI Report in Excel, in the EDI Reporting window, search for the EDI process report that you want to view. When it appears in the search results, click its magnifying glass or highlight it, and then click Generate Report.


Figure 11: EDI Reporting window/Generate Report option

Back to Top

How to set up EDI reports to use the PDF format

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, select Revert to PDF Reporting.
  4. Click Save, and then click Close.

Back to Top

How to run the EDI Masked Item Report

This PDF format report will show you the EDI LOCKS you have enabled within your system. Part number and Description are included on this report.

  1. In Paladin, on the top ribbon, select the Reports module.
  2. In the Report Area pane, select Inventory > General.
  3. In the Report List pane, select EDI MASKED ITEM REPORT.
  4. In the Choose Report pane, click F12 Next.
  5. In the Report Settings pane, make your selection for Part Number, Department, Supplier, Class, SubClass, and/or Location.
  6. In the Additional Settings pane, the Exclude items with zero Max Stock checkbox is selected by default. This is optional. 
  7. In the Sorting Options pane, select F12 Run Report.

A PDF file of the EDI Masked Items appears.

Back to Top

How to apply freight cost to items received by EDI

You can apply a freight cost to an EDI invoice and then distribute the cost across its received items. Cost distribution can be by weight or item cost. This feature is already available for manual receiving.

To apply a freight cost after an EDI invoice is processed:

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, click F9 EDI.
  3. In the EDI Processing window, click Reporting.

In the EDI Reporting window, invoices that are eligible for a freight cost have a red X icon in the Freight column. Highlight an invoice with a red X and click Apply Freight.


Figure 12: EDI Reporting window/Apply Freight cost

In the EDI Freight Cost window, select the freight cost distribution method:

  • If you select Item Cost, the cost will be distributed in proportion to each item’s individual cost.

Example: If the shipment contains two items that cost $10 and $20 respectively, the $10 item will receive 1/3 of the freight cost, and the $20 item will receive 2/3 of the freight cost.

  • If you select Weight, the cost will be applied in proportion to the weight of each item.

Example: If the shipment contains two items that are 10 and 20 pounds respectively, the 10 pound item will receive 1/3 of the freight cost, and the 20 pound item will receive 2/3 of the freight cost.

If you select Weight, and not all items have a specified weight, a message will appear. In Figure 13, the message tells you that 6 of the 89 invoice items do not have a defined weight, and therefore will not receive a freight cost.


Figure 13: Apply Freight Cost window/6 of the 89 invoice items do not have a defined weight

After you choose a distribution method, enter the Freight Cost and click F8 OK to complete the process. An informational message window will appear when the freight cost is applied.


Figure 14: Apply freight window/Freight cost applied message

Click OK to close the message window. Then, in the EDI Reporting window, you will notice that the red X icon for the EDI invoice you processed has become a green check mark.


Figure 15: EDI Reporting window/Freight cost verified

Tip: It is best practice to apply freight cost soon after the EDI invoice is processed and before received items are sold.

Back to Top

EDI option will set pack and single item prices

Note: This feature is only available to stores that use EDI and applies to all EDI suppliers except Do It Best.

When an item has a supplier ratio that is set and locked, an (optional) EDI processing feature will do the following for items bought in pack quantities:

  • Set Pricing Level 1 to the individual item quantity and price.
  • Set Pricing Level 2 to the pack quantity and price.

Example

Given these conditions:

  • This feature is turned on.
  • You buy wire from an EDI supplier by the spool (100 feet) and sell it by the foot.
  • The Supplier Ratio for the wire inventory item is 1/100 or 0.01 and is set and locked.
  • In the EDI file, the price per spool is $50.00, and the price per foot is $1.00.

EDI processing will set these values:

Pricing Level 1

  • Quantity: 1
  • Price: $1.00

Pricing Level 2

  • Quantity: 100
  • Price: $50.00

How to turn on this feature

To turn on this feature, you must contact Paladin Support (1-800-725-2346, option 2 or support@paladinpos.com).

To determine if this feature in turned on in your store:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, if the Manage Pack Prices for Custom Supplier Ratio Items check box is selected, this feature is turned on.

Note: This text and checkbox will appear in light gray text. To update this or other EDI settings, contact Paladin Support (1-800-725-2346, option 2 or support@paladinpos.com).

  1. Click Save, and then click Close.

Back to Top

Override EDI supplier’s department choice for a class of items

Important: You only need to set a custom default department when the EDI supplier department is different from your preferred department for a class of items.

How to override your EDI supplier’s department choice for a class of items.

  1. In Paladin, from the main menu, select File > Setup.
  2. Verify that the EDI supplier’s settings allow for department updates.
    1. Select the Supplier tab.
    2. Select the EDI supplier that you want to override.
    3. Check EDI Supplier Services.
    4. Verify that the Update Departments setting is set to Yes.

Note: This setting will appear in light gray text because you cannot modify this setting. If Update Departments is set to No, this feature does not apply to your store’s customized EDI supplier solution. When Paladin Support sets up an EDI supplier in Paladin for your store, they discuss your needs and goals and then set up the EDI system to support them. If you feel the custom department feature is something you may be interested in, contact Paladin Support to discuss your options.

  1. Click Save.
  2. Click the Class tab.
  3. In the Classes pane, enable Active, and then select the class of items that will receive your custom department assignment.
  4. In the Default Dept. list, select the department that will be assigned to items in that class during EDI processing.
  5. Click Save, and then click Close.

Back to Top

How to turn on/off EDI updated classes

Note: When EDI class updates are turned off for a supplier, class locked notifications will no longer appear during EDI processing.

To set up the EDI class update preference for a supplier:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Supplier tab.
  3. In the Suppliers pane, select the supplier.
  4. Check EDI Supplier Services.
  5. In the Update Classes pane, select one of the following:
    • No: EDI processing will not be allowed to update inventory item class information.
    • Yes [recommended]: EDI processing can update inventory item class information.
  1. Click Save, and then click Close.

Back to Top

How to update stock on hand when EDI receiving delayed

Follow these steps to receive items from an EDI supplier that is set up for delayed EDI invoice updates.

Note: To set up this feature, contact Paladin Support  at support@paladinpos.com. This feature only applies to Ace and ACE EJD (Emery Jensen Distribution).

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, click F9 EDI.
  3. In the EDI Processing window, click Reporting.  
  4. Enter a Start Date and End Date that include the original EDI invoice processing date, and then click Get EDI Records.
  5. In the list of invoices, the Rec column shows the received status of each invoice.

This icon

Means this

Stock on hand has been updated by this invoice.

Stock on hand has not been updated by this invoice.

Figure 16: Stock on Hand Icons and their definition

6. Highlight the invoice you want to receive, and then click Received Delayed SOH.

Back to Top

How to set up delayed EDI stock on hand updates

Note: This feature is available for Ace Hardware and ACE EJD (Emery Jensen Distribution) EDI.

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Supplier tab.
  3. Check EDI Supplier Services.
  4. Select the EDI system from the EDI System Choice list (either ACE or ACE EJD (Emery Jensen Distribution)
  5. Check Delay SOH Receiving.
  6. Click Save, and then click Close.
  7. Close and restart Paladin.
  8. Refer the customer to this KBA: How to update stock on hand when EDI receiving delayed

Back to Top

How to prevent EDI from changing retail on an item

This section describes how to lock the retail price so it is not changed when inventory is automatically updated using EDI.

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. In the Part # box, enter a part number.
  3. Press Enter.
  4. Select the Pricing tab.
  5. Under Pricing Levels pane, do one of the following:
    • In the Sale Price column, enter the desired retail price for one unit of the item.
    •  In the Ref column, enter the margin percentage that you want to maintain.
  6. Click the Pricing Levels lock icon to prevent this information from changing the next time an EDI file is processed.
  7. Click F12 Save.

Back to Top

How to print or save the EDI status message history

When you process an EDI file, status messages appear in the EDI Processing window. After the EDI file is processed, a new Print Log button lets you view, print, or save the status message history.


Figure 17: EDI Processing window/Print Log option

The status message history opens in a Notepad window.

To print the status message history, in the Notepad window, select File >  Print.

To save the status message history, in the Notepad window, select File > Save As, and then browse to a location for saving these files. The default filename is set to EDI_Events.txt. In the Save As window, specify a new file name (optional), and then click Save.

Back to Top

How to return unordered items from an EDI supplier that accepts credit (negative) purchase orders

Note: Before you perform this procedure, make sure that the EDI supplier can accept credit (negative) purchase orders.

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, select F9 EDI.
  3. In the EDI Processing window, select Process EDI File.
  4. Process the EDI invoice file.

Note: This will add the items to your inventory and create new inventory items, if they don’t already exist.

  1. Create a credit (negative) purchase order with the unordered items or item quantities.

Note: A credit purchase order is a purchase order with negative quantity values.

  1. Process the purchase order. This will remove the unordered items from your inventory stock on hand.
  2. Send the physical items back to the supplier.

Back to Top

How to manage discontinued items from EDI suppliers

When an EDI supplier identifies discontinued items in a EDI maintenance or invoice file, EDI processing will make the following changes to the item in Paladin to prevent future orders:

  • The order quantity (Order Qty) is set to 0, and the value is locked.
  • The maximum quantity (Max Qty) is set to 0, and the value is locked.
  • The second item description (Desc 2) will contain this text (or something similar): Item cancelled by (supplier name)

When EDI processing is completed, a discontinued item list with replacement items (if provided by the supplier) will appear in the corresponding EDI report in Paladin.

Suppliers may reuse discontinued part numbers. To prevent part number conflicts or erroneous updates from unrelated items due to part number reuse, you are required to rename discontinued inventory item part numbers. Steps are provided in: How to find and rename discontinued items from EDI suppliers

After you have renamed the discontinued item, if you know the replacement part number, you can optionally merge the discontinued item with the replacement item. When you do this, the discontinued part number is added as alternate part number, and the following information from both items will be combined in the replacement item:

  • Stock on hand (SOH)
  • Sales history (Sales Figures)
  • Quantity on order (On Order)

After the merge is completed, the discontinued item is deleted.

Steps for merging items are provided in: How to merge a discontinued item with a replacement item

Back to Top

How to find and rename discontinued items from EDI suppliers

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, click F9 EDI.
  3. In the EDI Processing window, click Reporting.
  4. Select a Start Date and End Date, and then click Get EDI Records.
  5. For each report that you have not reviewed, do one of the following to create the report:
    • Click its magnifying glass.
    • Highlight the row, and then click Generate Report.

Tip: To sort the list by the values in a column, click the column header.

Discontinued items and replacement items (if specified) will appear in the following EDI report sections:

In this EDI report

Discontinued items appear in this section

Maintenance Report

Supplier Discontinued, Items Max set to 0 W/ Replacement Part Number

Invoice Report

Supplier Discontinued Item With Replacement Part Numbers

Figure 18 and 19 show examples of the discontinued item lists.


Figure 18: Maintenance Report


Figure 19: Invoice Report

  1. Print and/or save the reports with discontinued items.

Tip: You only need to print the page(s) that show discontinued items.

  1. In the Inventory module, you must rename the discontinued part number.

Note: EDI suppliers may reuse discontinued part numbers. To prevent future part number conflicts or unwanted updates to discontinued inventory items by new unrelated items, you are required to rename a discontinued part number.

Example: If the supplier uses a six-digit numeric part number, you can use any value except a six-digit number. For example, you can preface the discontinued part number with the letter Z.

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. In the Part # box, enter the discontinued part number, and then press Enter.
  3. On the bottom ribbon, click F3 Rename Item.
  4. In the Rename Part # window, in the New Part # box, modify the part number so it no longer fits the supplier’s part number scheme.

Example: If the supplier uses six-digit part numbers, and the original part number is 123456, in the New Part # box, you can enter Z123456.

  1. Click F12 Rename.
  2. Repeat the renaming procedure for each discontinued item.

Back to Top

How to merge a discontinued item with a replacement item

Important: Before you begin the merge process:

  • You must make a backup of your database.
  • Perform this after business hours.
  • Do not merge any items that are on order.

An inventory merge cannot be undone. You must also have renamed the discontinued item part numbers. For instructions, see the previous procedure: How to find and rename discontinued items from EDI suppliers

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. In the Part # box, enter the replacement part number, and then press Enter.
  3. Press Ctrl + M to open the Inventory Merge window.
  4. In the search box, enter the discontinued part number, and then click Find >>.

Note: If you renamed the discontinued part number, enter the new name.

  1. In the list of search results, in the discontinued item’s row, in the Select column, select the checkbox, and then click Merge.



Figure 20: Inventory Merge window/Inventory Data merge

  1. In the Database Merge window, do one of the following:
    • If you have verified that you have a backup of your Paladin database, click Yes.
    • If you do not know if you have a current database backup, click No to stop the inventory merge process. You cannot undo an inventory item merge.
  1. When the inventory merge is completed, and the Merge Success window appears, click OK to close the window. To view the updated replacement item, close the inventory item and re-open it.

Note: The merge process deletes the discontinued item.

  1. Repeat these steps for the remaining replacement inventory items.

Back to Top

EDI missing retail prices calculated

When an invoice item is missing a retail price, EDI processing calculates a suggested retail price using the item cost and a default margin for new EDI items. For example, if the default margin is 35%, and the cost of the item is $10, then the calculated suggested retail price is $15.38.

To set the default margin for new EDI items:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, in the Default Margin on new EDI items box, enter a percentage value (without the percentage sign %). For example, if the default margin is 35%, enter 35.
  4. Click Save, and then click Close.

Back to Top

How to set New Inventory Items in Specified Class

EDI invoice processing can set a user-defined new-item class for items that are added to your inventory from the supplier all-item catalog. The new-item class is set in addition to the class specified by the supplier.

You can specify the new-item class in the Paladin Configuration window by:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, check Put New Inventory Items in Specified Class and enter the class name in the in the associated box.

Many suppliers provide an all-item catalog that can be imported into Paladin using an EDI process. While the complete catalog is stored, only items in your active inventory appear in reports or searches (unless you search for the item specifically). Catalog items that are not in active inventory are called obscure inventory items.

An obscure inventory item becomes an active inventory item in the following scenarios:

  • You add the item to a purchase order.
  • You receive the item when you process a purchase order.
  • You view the item in the Invoice/Quote or Inventory modules.
  • You scan the item using an RF unit or barcode scanner.

If you viewed an obscure item in Paladin, and did not want to make it an active inventory item:

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. Enter the items part number in the Part # box.
  3. Press Enter.
  4. On the bottom ribbon, select F2 Delete Item.

To specify a class for new items:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, check Put New Inventory Items in Specified Class and enter an existing class in the associated box. When a store receives new items using EDI, the class you specified will be assigned to the item. This is in addition to the class set by the supplier (if any).
  4. Click Save, and then click Close.

Back to Top

How to reverse stock on hand (SOH) counts for an EDI invoice

  1. In Paladin, on the top ribbon, select the Inventory module.
  2. On the bottom ribbon of the module, click F9 EDI.
  3. In the EDI Processing window, click Reporting. The EDI Reporting window will appear with a history of all EDI processing, including electronic invoices.
  4. Highlight an invoice, and then click Reverse SOH.  Depending on the EDI vendor, the invoice name will include one of the following terms:
    • EIN
    • INVENTORY
    • INVOICE

Note: If you highlight an invoice in the EDI history and the Reverse SOH button is not available, one of the following situations has occurred:

  • The SOH has already been reversed for the invoice.
  • The SOH cannot be reversed because the invoice is over seven (7) days old.

If multiple invoices were processed by one EDI file, reverse the SOH on the newest invoices, and then work backward in time.

Back to Top

Undo EDI vendor PO

A purchase order received by an EDI process can only be reversed in the EDI Reporting window. If you try to reverse an EDI-received purchase order in the PO module using the F9 Undo Receiving option (on the Confirm PO tab), you will receive the following message, and your stock-on-hand (SOH) and quantity-on-order values will not change. This feature prevents duplicate SOH adjustments.


Figure 21: Undo Receive window/Undo EDI Vendor PO

Back to Top

How to block EDI class and subclass control

To block incoming Class and Subclass data from EDI suppliers:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Supplier tab.
  3. Check EDI Supplier Services.
  4. Under Update Classes, select No
  5. Click Save, and then click Close.

Note: The default value for this switch is “Yes” to continue the default action that has always been present in Paladin.

Back to Top

How to control supplier order number search

During EDI, Paladin searches manufacturer’s part numbers for a match. If part number match, alternate part number match, and supplier order number match fail, you can disable this “4th level” search. Also, if your store(s) are not multi-branded, you can turn this legacy feature off.

To disable this search function:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the EDI pane, uncheck Include Supplier Order Number in Item Lookup during EDI.
  4. Click Save, and then click Close.

Back to Top

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 10/05/22