Hi everyone,
I found a very useful tool on Sage x3 v11 for converting import files with linear structures to sage x3 acceptable templates. As we know, Sage x3 templates for imports and exports have more than a single line, that is, the header, the detail, and optionally for some imports like Miscellaneous issue and receipt, the stock journal line.
I have tested this tool and found it effective but it does not convert a file with a header and multiple detail lines properly. It only recognizes the first entry on a detail line.
The tool is found in "Usage >> Imports/Exports >> Single line files conversion"
For example, a miscellaneous issue template has 3 indicators that are, E for the header, L for the line details, and S for the Stock journal.
A. The file to be converted below: The first 2 lines are constant
H | E | L | S | END | |||||||||||||||||||
C | Entry | Storage site | Allocation date | Description | Movement code | Entry line no. | Product | Description 1 | Unit | Quantity | Warehouse | Unit | Quantity | Lot | Sublot | Location | Status | Serial number | Analytical dimension | Analytical dimension | |||
E | CLST | 18092021 | New PC | L | 1000 | HARDWARE | New PC | UN | 25 | CLWH | S | UN | -25 | HDW0002 | SUB0002 | CLSW1 | A | ADMIN | ADMIN |
B. The converted file from Sage x3 using the single lines file conversion which can be imported into Sage x3 using the Imports function.
E | 20 | CLST | 18092021 | Hardware Issue1 | |||
L | 1000 | HARDWARE | Computer Hardware | UN | 25 | UN | 25 |
S | UN | -25 | CLSW1 | A |
C. Below is a multiple lines file which when converted, gives the same output as (B) above
H | E | L | S | END | |||||||||||||||||||
C | Entry | Storage site | Allocation date | Description | Movement code | Entry line no. | Product | Description 1 | Unit | Quantity | Warehouse | Unit | Quantity | Lot | Sublot | Location | Status | Serial number | Analytical dimension | Analytical dimension | |||
E | CLST | 18092021 | New PC | L | 1000 | HARDWARE | New PC | UN | 25 | CLWH | S | UN | -25 | HDW0002 | SUB0002 | CLSW1 | A | ADMIN | ADMIN | ||||
L | 2000 | HARDWARE1 | New PC | UN | 35 | CLWH | S | UN | -35 | HDW0002 | SUB0002 | CLSW1 | A | ADMIN | ADMIN | ||||||||
L | 3000 | HARDWARE2 | New PC | UN | 45 | CLWH | S | UN | -45 | HDW0002 | SUB0002 | CLSW1 | A | ADMIN | ADMIN | ||||||||
L | 4000 | HARDWARE3 | New PC | UN | 50 | CLWH | S | UN | -50 | HDW0002 | SUB0002 | CLSW1 | A | ADMIN | ADMIN |
Does anyone know how I can get multiple lines converted using the same tool or how can I achieve the same result with multiple lines? Please help.