Print Friendly

vendor-item-record-split-uofm

Split U of Ms exist on the Vendor Item Record for the purpose of EDI integrations.  In the event of Split Cases on non-EDI Vendors, the correct U of M could be manually selected on the AP Invoice screen.

When a Vendor Invoice is imported via EDI and the Vendor file has a Split Indicator, the EDI process can read and detect that the line item is a ‘Split’ case.  This capability exists for the following Vendors:

  • Sysco
  • US Food Service
  • R365 Multi-Invoice
  • Fintech (coming soon)

The Vendor will prepare the invoice file with the split indicators in place.  To utilize the correct Split U of Ms via vendor invoice import, a User would need to update the Vendor Item Record to include the desired Split U of M.  Upon saving the record, the Split U of M will be substituted on future invoices when the split indicator is present on the respective invoice line item.

Split Indicators

Below are descriptions of Vendor-Specific Split Indicators, and instructions on how to locate and review Vendor Invoice files in the FTP folder.  Click here for more information on accessing the FTP Folder

Sysco

Open the FTP site via your preferred FTP Client and navigate to the APImports/R365/Processed folder

split-ftp-path

Locate and copy a Sysco invoice file (###_AAA_################.csv naming convention) to your desktop.  Open the file with your preferred spreadsheet application and locate the DET rows (row type is identified in column F).

For any DET row: if the value in column I is > 0, then the line item will be identified as a Split.  The import will substitute the Purchase U of M on the Vendor Item Record for the Split U of M located on the same Vendor Item Record

split-sysco-sample-det1

 

US Foods

Open the FTP site via your preferred FTP Client and navigate to the APImports/usfoods/Processed folder

split-ftp-path-us-foods

Locate and copy a US Foods invoice file (USF_CUST_AAAAAAAA_YYYYMMDD##########.inv naming convention) to your desktop. Open the file with your preferred Notepad application (Notepad on Windows, Textedit on Mac).  Windows may try to default to using the ‘Wordpad’ application.  If so, right click on the file and select ‘Open With’ then select ‘Notepad’.

Locating the column that represents the Split is more challenging on the US Foods invoice file as there are no columns, only ‘~’ separating data.

Locate the first row by the row identifier ‘1~’ in the farthest left position of the line.  Scroll to the right following this line until the Street address is located following a ‘~’.  In between the Street and City columns (separated by ‘~’) the U of M information will be present on the ‘2~’ (detail) lines on the invoice as indicated in the image below.  For each ‘2~’ (detail) line that has the value of ‘EA’ before and after the U of M tildes (for example: ‘~EA~’) that indicates that a Split case will be used. The import will disregard the Purchase U of M on the Vendor Item Record, and use the Split U of M located on the same Vendor Item Record

 

split-us-foods-sample-inv-highlights

R365 Multi-Invoice

Open the FTP site via your preferred FTP Client and navigate to the APImports/R365/Processed folder

split-ftp-path

Locate and copy a Vendor invoice file that utilizes the R365 Multi-Invoice format to your desktop.  Open the file with your preferred spreadsheet application and locate the “Break Flag” column (column K).

For any row: if the value in column K = “Y”, then the line item will be identified as a Split.  The import will substitute the Purchase U of M on the Vendor Item Record for the Split U of M located on the same Vendor Item Record

Was this article helpful to you?

Comments are closed.