Export: goods postings
In the order centre, you can have export files created automatically when booking. To do this, activate Export documents in the Order Centre settings and set an output directory.
The export is done as a *.csv file and can be opened or processed directly with Excel.
The file name is generated dynamically based on the booking type and other information:
| OCEX-Bx-DOCy-TYPEz.csv |
|
| x |
Client number ( Branch) |
| y |
Document number (DocumentNo ) |
| z |
Type, Occupancy Type |
| (1 = order, 2 = goods receipt, 3 = return delivery, 4 = transfer posting, 5 = loss posting) |
|
Description of the data structure:
| Data structure |
|
|
| crevice
|
Meaning
|
Data type
|
| Branch |
client |
Number (1 - 9999) |
| Type |
Record type |
Number (1 = order, 2 = goods receipt, 3 = return delivery, 4 = transfer posting, 5 = loss posting) |
| |
|
|
| From |
Origin |
Text (supplier or point of sale) |
| FromID |
Source ID |
Number (Internal unique ID) |
| FromNR |
Origin individual no |
Number (supplier number if applicable) |
| |
|
|
| To |
receivers |
Text (main warehouse, point of sale, or reason for loss) |
| ToID |
Recipient ID |
Number (Internal unique ID, either storage location or reason for loss) |
| ToNR |
Recipient individual number |
|
| |
|
|
| DocN |
Document number |
Number (document number from the order centre) |
| OrderDate |
Document date |
Date Time (05.03.2023 11:26:59), when the document was created / posted |
| DeliverDate |
Delivery date |
Date Time (05.03.2023 11:26:59), when was the goods receipt posted? |
| StockDate |
goods movement date |
Date Time (05.03.2023 00:00:00), on which booking date the goods were booked |
| |
|
|
| PosNo |
consecutive position number |
Number (Lfd# 1-n) |
| ArtNo |
Item Number |
Number (item number) |
| ArtID |
Item ID |
Number (Internal ID of the item) |
| ArtName |
Item description |
Text (name of the article) |
| UnitQuant |
Quantity in order units |
Number (quantity of "repackaged" order units, 3.56 ) |
| UnitName |
Order unit name |
Text (example carton 6 pieces) |
| UnitFactor |
Base unit quantity |
Number (quantity of basic units contained in an order unit, 6.00 for "box of 6" ) |
| BaseUnitName |
Base unit name |
Text (example piece) |
| NetPrice |
Net price of the order unit |
Number (12, 95) |
Back to the parent page: Stock Management Connections