Puma UAE Stock Export
Summary of Changes: (The purpose of this table is to keep traceability and Product team to highlight the things that were changed into the scope, based on comments or discussions)
| Date | Version | Name | Applied changes |
|---|---|---|---|
| 30/10/2023 | 1.0 | Hristiyan | First Publish |
| 03/04/2024 | 1.1 | Milen | Hardcode export time |
The purpose of this document is to detail the custom stock export we will be sending Puma (SAP) in an .xml format, dropped on an FTP server.
We want to create an export that will export the stock levels from Location Quantities table, using a specific file name in an XML formatted file on an FTP folder. We want to use the custom script functionality within the ‘Automatic Export Feed’ and set the FTP credentials in there.
The export script could be named ‘Puma UAE Stock Export’.
We also would like to introduce new table called ‘Account Puma UAE’. We expect to produce separate file for every Account Puma UAE record and in this export we should pick product stock levels from Location Quantities only for the Account > Account Locations for the given account.
If we have more than one location added to an account, and the same product in more than one location we want to calculate the total quantity from both locations when creating the file.
In the ‘Account Puma UAE’ table, will need to have a couple of fields which we will need for this export :
| Field Name | Field Type | Required |
|---|---|---|
Plant |
text | Yes |
Storage Location Number |
text | Yes |
Storage Location |
text | Yes |
Example XML:
<DOCUMENT><LOCATION plant="AE01" storageloc_no="901" storagelocation="AED1"/>
<MATERIALS>
<MATERIAL material_no="">
<EANS>
<EAN ean="4059506131127" quantity="7"></EAN>
</EANS>
</MATERIAL>
<MATERIAL material_no="">
<EANS>
<EAN ean="4060981087342" quantity="1"></EAN>
</EANS>
</MATERIAL>
<MATERIAL material_no="">
<EANS>
<EAN ean="4060981166115" quantity="1"></EAN>
</EANS>
</MATERIAL>
</MATERIALS>
</DOCUMENT>*We need to be beautifying the file when creating it so it is exported the way shown in the example XML.
Mapping:
| Puma field | Hemi field | Notes |
|---|---|---|
| plant | Account Puma UAE > Plant |
|
| storageloc_no | Account Puma UAE > Storage Location Number |
|
| storagelocation | Account Puma UAE > Storage Location |
|
| material_no | N/A | Hardcoded as empty (““) |
| ean | Location Quantities > Product Identifier |
|
| quantity | Location Quantities > Quantity |
Please, note that both ‘ean’ and ‘quantity’ should go in a single
Example file :
Inventory_2023102403001375.xml
<v1.1> We need to hardcode export times for this report in the code. It needs to run every Sunday at 23:00 GMT </v1.1>