880 Grocery Products Invoice

NetSuite to EDI 880 Grocery Products Invoice Mapping

This document outlines the mapping between NetSuite objects and the EDI 880 Grocery Products Invoice format. The mapping is organized by EDI segments.

Header Information

NetSuite SourceEDI Target PathDescription
customer.prodIsaIdsender.isaIdProduction ISA ID for the sender
customer.testIsaIdreceiver.isaIdTest ISA ID for the receiver
customer.enabledTransactionTypes[documentType="880_GROCERY_PRODUCTS_INVOICE"].streamstreamTransaction stream, defaults to "TEST" if null

Invoice Identification Segment

NetSuite SourceEDI Target PathDescription
invoices[0].trandatemessage.transactionSets[0].invoiceIdentification[0].dateInvoice date (formatted from M/d/yyyy to YYYYMMDD)
invoices[0].tranidmessage.transactionSets[0].invoiceIdentification[0].invoiceNumberInvoice number
invoices[0].custbody_orderful_edi_po_datemessage.transactionSets[0].invoiceIdentification[0].date1PO date (formatted from M/d/yyyy to YYYYMMDD)
invoices[0].otherrefnummessage.transactionSets[0].invoiceIdentification[0].purchaseOrderNumberPurchase order number
salesorders[0].tranidmessage.transactionSets[0].invoiceIdentification[0].vendorOrderNumberVendor order number (from sales order)

Extended Reference Information Segment

NetSuite SourceEDI Target PathDescription
invoices[0].custbody_orderful_n9_notesmessage.transactionSets[0].extendedReferenceInformation[0].referenceIdentificationReference notes (with qualifier "IA")

Date/Time Segment

NetSuite SourceEDI Target PathDescription
invoices[0].shipdatemessage.transactionSets[0].dateTime[0].dateShip date (formatted from M/d/yyyy to YYYYMMDD) with qualifier "11"

Carrier Details Segment

NetSuite SourceEDI Target PathDescription
invoices[0].shipcarriermessage.transactionSets[0].carrierDetails[0].routingShipping carrier (with transport method code "ZZ")

Terms of Sale Segment

NetSuite SourceEDI Target PathDescription
invoices[0].duedatemessage.transactionSets[0].termsOfSale[0].termsNetDueDateDue date (formatted from M/d/yyyy to YYYYMMDD)
invoices[0].terms.daysuntilnetduemessage.transactionSets[0].termsOfSale[0].termsNetDaysNet days until payment is due
invoices[0].totalaftertaxesmessage.transactionSets[0].termsOfSale[0].amountSubjectToTermsDiscountTotal amount after taxes
invoices[0].terms.namemessage.transactionSets[0].termsOfSale[0].freeFormMessageTerms name as free-form message

Ship-To Party Identification (N1_loop)

NetSuite SourceEDI Target PathDescription
invoices[0].shippingaddress.addresseemessage.transactionSets[0].N1_loop[0].partyIdentification[0].nameShip-to addressee name
invoices[0].custbody_orderful_ship_dc_numbermessage.transactionSets[0].N1_loop[0].partyIdentification[0].identificationCodeShip-to DC number
invoices[0].shippingaddress.addr1message.transactionSets[0].N1_loop[0].partyLocation[0].addressInformationShip-to address line 1
invoices[0].shippingaddress.citymessage.transactionSets[0].N1_loop[0].geographicLocation[0].cityNameShip-to city
invoices[0].shippingaddress.statemessage.transactionSets[0].N1_loop[0].geographicLocation[0].stateOrProvinceCodeShip-to state
invoices[0].shippingaddress.zipmessage.transactionSets[0].N1_loop[0].geographicLocation[0].postalCodeShip-to postal code
invoices[0].shippingaddress.countrymessage.transactionSets[0].N1_loop[0].geographicLocation[0].countryCodeShip-to country code

Bill-To Party Identification (N1_loop)

NetSuite SourceEDI Target PathDescription
invoices[0].billingaddress.addressee or invoices[0].shippingaddress.addressee`m