Reference data Ueberblick

EDI setup

• Process individual incoming messages (if not checked, this type of message cannot be processed in the system)
• Own function, which checks it when processed in the individual Mgt-CU
  • "Use IN PRICAT"
  • "Use IN ORDRSP"
  • "Use IN DESADV"
  • "Use IN SLSRPT"
  • "Use IN INVRPT"
  • "Use IN INVOIC"
  • "Use IN ORDERS"

• Hook fields, which decide whether OUT EDI documents (OUT ORDERS, OUT SLSRPT etc.) should be exported via the CU 5407707, or via the individual Mgt.-CU

  • "OUT DESADV instant export"
    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT DESADV Mgt." -CU can be integrated into the NAS
  • "OUT INVOIC instant export"
    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT INVOIC Mgt." -CU can be integrated into the NAS
  • "OUT ORDRSP Instant Export"
    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT ORDRSP Mgt." -CU can be integrated into the NAS
  • "OUT PRICAT instant export"
    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT PRICAT Mgt." -CU can be integrated into the NAS
  • "OUT ORDERS immediate export"
    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT ORDERS Mgt." -CU can be integrated into the NAS

  • „OUT SLSRPT sofortiger Export“

    • Wenn Haken gesetzt, so werden die Belege über CU 5407707 mit exportiert, sonst muss die „OUT SLSRPT Mgt.“-CU mit in den NAS integriert werden

  • OUT INVRPT instant export"

    • If checked, the documents will be exported via CU 5407707, otherwise the "OUT INVRPT Mgt." -CU can be integrated into the NAS
  • "OUT EDI Document Summary"
    • If the checkmark is set, the OUT receipts are compressed by "ID of the recipient" and summarized in one file
    • If the check mark is not checked, one file will be created for each export document
  • File paths for import/export
  • Bestimmt die Dateipfade in denen die EDI Nachrichten gespeichert bzw. von denen sie eingelesen werden.
  • ATTENTION: To use the test paths, check the box "Database is test database" in the "Fashion Setup".
  • "Add/remove BOM in files"
  • Control whether to set/remove BOM characters -Separator:
  • Determines which character is used as a separator between the fields in the EDI files. -Consignment:
  • Default fields for processing customer returns at checkout
  • Message names:
  • Message names for the assignment of message types in the system.

EDI Partner

Allgemein

• Stammdatentabelle, um steuernde Eigenschaften im Bereich EDI zu tätigen
• Information der Anzahl zugeordneter Kreditoren
• Entscheidung, welche GLN bei Export einer Nachricht gezogen werden soll
  • EDI Nachrichtensenderart (Kreditor, Debitor, Eigene ILN, …)
  • EDI Nachrichtensender (interne Teilnehmernr.)
• Verarbeitungsart für importierende Nachrichten:
  • Manual, Automatic on Import, Locked

Controlling Properties for Message Type Processing

IN PRICAT

• „Keine Pflichtfeldprüfung IN PRICAT“
  • Do not check whether mandatory fields are filled
• „IN PRICAT Lief.-Farbe gleich int. Farbcode“
  • The color codes of the supplier are adopted when the PRICAT is processed and, if necessary, created in the system.
  • If the checkmark is set, then the color code from the PRICAT will be created in the color table and in the "assigned color table"

IN ORDRSP

• "IN ORDRSP Create automat. EK – Order"
  • If the box is checked, an purchase order is automatically generated from the ORDRSP if one does not yet exist.
• „Verwende EK-Preis aus IN ORDRSP“
  • Adopts the purchase prices of the IN ORDRSP when creating/updating the purchase order
• „Verwende VK-Preis aus IN ORDRSP“:
  • Adopts the retail prices of the IN ORDRSP when creating/updating the purchase order

IN DESADV

• "Fill ran. Quantity in WE from IN DESADV"
  • Fills the "quantity act. Delivery" with the quantity that is delivered at item level in the IN DESADV
• "Create automat. EK-Bestellung aus IN DESADV“
  • If no purchase order is found, creates an purchase order from the IN DESADV
• "Book automatically. Goods Receipts from IN DESADV"
  • Posts the goods receipt that was created from the IN DESADV

IN INVOIC

• "Use purchase prices from IN INVOIC"
  • Use the purchase prices sent in the IN INVOIC
• "Book automatically. Purchase invoice/purchase credit note from IN INVOIC"
  • If processed successfully, posts the purchase invoice/purchase credit note, which was created from the IN INVOIC
• "IN INVOIC Document Type Invoice"
  • INVOIC document type for the creation of an invoice. Is matched with the "INVOIC Document Type" field of the IN INVOIC.
• "IN INVOIC Document Type Credit Note"
  • Document type of INVOIC for the creation of a credit note. Is matched with the "INVOIC Document Type" field of the IN INVOIC.

IN ORDERS

• "Check availability IN ORDERS"
  • It is checked whether the specified order quantities are available. If less is available than specified in IN ORDERS, only the available quantity is transferred to the sales order.
• "Use prices from IN ORDERS"
  • Uses the retail prices sent with the IN ORDERS

IN SLSRPT

• "IN SLSRPT Processing Type"

• Option values:

  • „nur Statistik“ (es werden nur Statistikposten geschrieben)
  • "Delivery" (a sales order/sales complaint is created and posted to "to be delivered"
  • "Delivery and invoice" (a sales order/sales complaint is created and posted to "to be delivered" and then the delivery is invoiced)
  • "Article booking only" (the sales/customer returns are processed by article book sheet booking)

• "Create invoice per sale. To debtor"

• Per IN SLSRPT several "Verk. To Debtors"

• When activated, each "Verk. To Customer"

• "SLSRPT Invoice Posting Date"

  • Option Values:
  • Message date
  • "End of sales period (head)"
  • "End of Sales Period (Line)"
  • Depending on the selection, the corresponding date is used as the posting date for invoicing the sales delivery/sales return delivery

• "Realized retail price incl. VAT."

• "Realized retail price incl. VAT."

• "Always create sales return for customer returns"

  • Creates a sales complaint for a customer return

• "Pricing on the Sales Report"

• Option values:

  • Debitorenpreisgruppe (VK-Preisfindung)
  • Kalkulation

• "Price calculation on the sales report"

  • Bei Auswahl des Optionsparameters „Kalkulation“ für „Preisfindung am Abverkaufsbericht“ wird dieser Wert zur Kalkulation des VK-Preises herangezogen

IN INVRPT

• „Transitlagerort Filialumlagerung“
• "Transit storage location central warehouse"
• "INVRPT Returns (to Supplier) Immediately Book
  • Book returns during processing
• "Book INVRPT inventories immediately"
  • Posts the created inventory order during processing
• "Allow rows without inventory notification"
  • No error message if no inventory has been reported
• "Multiple INVRPT messages allowed"
  • If several INVRPTs are sent per store per customer  Entry in separate entry documents for the inventory order
• "Process INVRPT inventory adjustment as a sale"
  • Processes the reported inventory corrections in the IN INVRPT as a sales order/sales complaint
• "Create sales complaint for neg. Inventory withdrawal"
  • Created for customer returns VK complaints

OUT ORDERS

• "Create OUT ORDERS"
  • Indicator of whether an OUT ORDER for this EDI partner is to be set up in principle
  • Another criterion is that the corresponding order type is also included in "OUT ORDERS"

OUT SLSRPT

• "Create OUT SLSRPT"
  • When posting item journal lines, when the value entry is created, it is checked whether OUT SLSRPT is to be created for the main supplier of the item. If yes, then an "EDI Export Item" is written (see EDI Export Item)
• "Assigned Export Planning OUT SLSRPT"
  • Defines which export planning template is used to create the OUT SLSRPTs (see Export Planning)

OUT INVRPT

• "Create OUT INVRPT Restocking"
  • When posting article journal lines, when the value entry is created, it is checked whether OUT INVRPT for stock transfers is to be created for the main supplier of the article. If yes, then an "EDI Export Item" is written (see EDI Export Item)
• "Create OUT INVRPT inventory"
  • When posting article journal lines, when the value entry is created, it is checked whether OUT INVRPT for stock transfers is to be created for the main supplier of the article. If yes, then an "EDI Export Item" is written (see EDI Export Item)
• "Assigned Export Planning OUT INVRPT"
  • Defines which export planning template is used to create the OUT SLSRPTs (see Export Planning)
• "OUT INVRPT document type transfer"
  • The value that should be in the Document Type field in the OUT INVRPT
• "OUT INVRPT Document Type Physical Inventory"
  • The value that should be in the Document Type field in the OUT INVRPT when posting from Physical Inventory Order or Physical Inventory Book Sheet
• "OUT INVRPT Document Type Inventory Report"
  • The value that should be in the Document Type field in the OUT INVRPT when creating a periodic inventory report
• "Creation of OUT INVRPT Transfer from Transit Warehouses"
  • If an OUT INVRPT for the receipt posting at the transit warehouse and an OUT INVRPT for the departure posting from the transit warehouse are to be reported when posting transfer orders via transit warehouses. -Prerequisite:
    • Use of the Stock Transfer Order
    • The transit warehouse must have its own GLN
  • If you do not have your own GLN, you do not check the box and an OUT INVRPT is only reported for the issue posting from the origin warehouse ("transfer of code") and receiving warehouses ("transfer by code")

OUT PRICAT

• „Erstelle OUT PRICAT“
  • Generelles Kriterium ob eine PRICAT für diesen EDI Partner erstellt werden soll.
• „Zusätzliche Partnerid. des Käufers“
  • Es kann eine zusätzliche Identifikationsnummer für den EDI Partner angegeben werden. Dieser Wert wird in den Zeilen der OUT PRICAT unter „Zusätzliche Partnerid. des Käufers“ übergeben
• "Use season rekeying"
  • Uses the EDI partner's season recoding to determine the correct season.
  • If transcoding is not enabled, the item season is used.
• "Use article hierarchy encoding"
  • Uses the item hierarchy decoding (commodity group) of the EDI partner to determine the correct commodity group of the customer.
  • If the conversion is not activated, the customer's product group is not used.
• "Use product group rekeying"
  • Uses the EDI partner's product group conversion to determine the correct product group
  • If transcoding is not enabled, the product group is not used
• "Rec. retail price mandatory"
  • If this field is activated, the field "empf. VK – Price" in the sales offer lines.

OUT ORDRSP

• „Erstelle OUT ORDRSP“
  • General criterion whether an ORDRSP should be created for this EDI partner.

OUT DESADV

• "Create OUT DESADV"
  • General criterion whether a DESADV should be created for this EDI partner.
• "Send parcel data"
  • "no package": No package information will be sent.
  • "Simple": The package information is summarized in one line. No assignment of items to packages.
  • "Detailed": The packages are broken down in detail. The items are allocated per package.

OUT INVOIC

• „Erstelle OUT INVOIC für Rechnung“
  • Generelles Kriterium ob eine INVOIC für diesen EDI Partner aus VK - Rechnungen erstellt werden soll.
• "Create OUT INVOIC for credit"
  • General criterion whether an INVOIC should be created for this EDI partner from VK credit notes.
• "EDI message recipient type INVOIC"
  • Type of message recipient to whom the INVOIC is to be sent (customer/vendor)
  • May be different from the general EDI message recipient type.
• "EDI Message Receiver INVOIC"
  • Number of the message recipient.

GLN Participants

• Master Data Table "GLN" -> Primary Key GLN
  • Saving the GLN as a record
• Master data table "GLN Participant" -> primary key GLN, line no.
  • Assignment of n-possible internal participants to this GLN
• New finding function for GLNs (function call already contains two parameters)
  • Parameters must be clarified on a project-specific basis and added accordingly

Export Container

• Zu exportierende Nachrichten werden in eine „Export Container“-Tabelle geschrieben (Tabelle 5407710 „EDI Export Handler“)

• Die NAS CU 5407707 – EDI Export Mgt. läuft in periodischen Abständen und ändert den Status des „Export Containers“
  • Processing "Status"::"Create" to "Status"::"Export"  Checking whether all information for the creation of the "OUT document" is available and creating the same
  • Processing "Status"::"Export" to "Status"::"Processed"  Export of the "OUT document"

Example: (see OUT SLSRPT, OUT INVRPT, OUT ORDERS)

NAS-Codeunits