Inhaltsverzeichnis

EDIFACT Example Scenarios

Using EDFIACT example files, various scenarios in the interaction between eBiss and merchandise management systems are shown here.
All example files are stored in the edifact_szenarien_beispiel_v2017.zip.

Supplier->Retailer:1. PRICAT(Catalog) Supplier->Retailer:2. ORDRSP Supplier->Retailer:3. PRICAT(Price) Supplier->Retailer:4. ORDRSP(update QTY/PRI) Supplier->Retailer:5. DESADV(partial delivery) Supplier->Retailer:6. DESADV(remaining delivery) Supplier->Retailer:7. PRICAT(with deletion request) Supplier->Retailer:8. INVOIC(for partial delivery) Supplier->Retailer:9. INVOIC(for remaining delivery) note left of Retailer: This invoice is incorrect in content and must remain in the system.

The following sample files are available in the role of Retailer.

1. PRICAT Article New creation

Datei Documentnumber Documentdate
1. PRICAT_4EansNeu.edi PRI_1001 2017-01-01

This PRICAT contains 2 articles with two EAN's (articles with different sizes). If this PRICAT is processed, two new articles with two different sizes each should be created in the article master in your merchandise management system.

ArticleNumber Size Colour EAN PurchasePrice Selling price
784512 42 030 4035811000013 25,75 52,90
784512 44 030 4035811000020 25,75 52,90
799999 40 030 4035811000037 35,25 62,75
799999 42 030 4035811000044 35,25 62,75

All characteristics such as article number, supplier, buyer, manufacturer, modification date, colour, size, EAN, prices, validity date, currency, brand, quantity, etc. should be entered in the article table.

2. ORDRSP (Order) incoming

File Documentnumber DocumentDate DeliveryDate
2. ORDRSP_initial.edi ORD_10012017-01-02 2017-03-01

This ORDRSP contains two items that have been ordered.

ArticleNumber Size Colour EAN PurchasePrice Ammount
799999 40 030 4035811000037 19,25 15
799999 42 030 4035811000044 35,25 25

If the ORDRSP is processed, a new purchase order must be created in merchandise management using 2 EANs with the quantities 15 pieces for the EAN 4035811000037 and 25 pieces 4035811000044. In contrast to the Pricat, Pos 1 costs only 19.25, which is the order price that should be taken over.

3. PRICAT Price Change

Datei Documentnumber Documentdate
3. PRICAT_1EansGeaendert.edi PRI_1002 2017-01-15

Datei: PRICAT_1EansGeaendert.edi

This PRICAT contains an article whose data is updated. During processing, the prices of EAN 4035811000037 of article 799999 in merchandise management should be updated.

ArticleNumber Size Dolour EAN PurchasePrice Selling Price
799999 40 030 4035811000037 35,25 @#FFA07A: 69,99

The retail price should have been updated to 69,99 €. Furthermore, the date of amendment (20.01.2017) should have been entered.

4. ORDRSP (Change in Purchase Order) incoming

File DocumentNumber DocumentDate
4. ORDRSP_Aenderung Preis.edi ORD_1001 2017-01-02

Diese ORDRSP enthält zwei Artikel, deren Bestellmenge geändert wurde.

ArticleNumber 'Size Colour EAN Purchase Price Amount
799999 40 030 4035811000037 @#FFA07A:14,25 15
799999 42 030 4035811000044 35,25 @#FFA07A:20

If this ORDRSP is processed, the purchase order quantities for 2 EANs (4035811000037 and 25 pieces 4035811000044) should be changed in the merchandise management order table and the change date entered.

5. DESADV incoming

File DocumentNumber Dokumentdatum Referenz
5. DESADV.edi DES_2001 2017-03-01 ORD_1001

Dieser DESADV enthält zwei Artikel, die bestellt wurden.

Articlenumber Size colour EAN Amount
799999 40 030 4035811000037 2
799999 42 030 4035811000044 2

If this DESADV is processed, the stocks in the goods receipt and in the article master should be increased by 2 articles per EAN and the change date recorded. In addition, the following backorders must be created in relation to the quantities of the purchase order change.

4035811000037 13 pieces 4035811000044 18 pieces

6. Delivery note for remaining items

File Documentnumber Documentdate Reference
6. DESADV_Nachlieferung PosRef.edi DES_2002 2017-03-10 ORD_1001

This delivery note has been sent for the missing article items and therefore contains the order reference at item level.

Article Number Size Colour EAN Amount
799999 40 030 4035811000037 13
799999 42 030 4035811000044 18

Now the backorder should be corrected.

7. PRICAT Delete article

File Documentnumber Documentdate
7. PRICAT_2EansGeloescht.edi PRI_1003 2017-04-01

This PRICAT contains an article whose data is to be deleted. If this PRICAT is processed, two EANs (4035811000013,4035811000020) with two different sizes in the article master should be deactivated in your merchandise management system.

Articlenumber Size Colour EAN Purchase Price Selling Price
784512 42 030 4035811000013 25,75 52,90
784512 44 030 4035811000020 25,75 52,90

Since articles are not deleted from a merchandise management system due to history reasons, the status of the relevant EANs should be switched to inactive.

8. INVOIC

File Documentnumber Documentdate Reference
8. INVOIC_Referenz DES_2001 exakt.edi INV_30012017-04-01 DES_1001

This INVIOC contains two items that have been delivered.

Articlenumber Size Colour EAN Purchase Price Amount
799999 40 030 4035811000037 14,25 2
799999 42 030 4035811000044 35,25 2

This INVOIC should be able to be processed without errors during automatic invoice verification.

9. INVOIC subsequent delivery

File Documentnumber Documentdate Reference
9. INVOIC_Referenz DES_2002 Nachlieferung Menge und Summe zu hoch.edi INV_30022017-04-02 DES_1002

This INVIOC contains two items that have been delivered.

Articlenumber Size colour EAN Purchase Price Amount
799999 40 030 4035811000037 14,25 15
799999 42 030 4035811000044 35,25 25

This calculation should be stopped during the examination by the WWS.