Skip to content

Zynk CSV to Zynk Stock Transaction XML

The stock transaction CSV works on the basis of one CSV line representing one stock transaction.

Sage 50

All fields from our Sage 50 UK Stock Transaction XML format can be used. Use the XML Field names for the CSV header.

Example

Id,StockTransactionType,StockCode,StockTransactionDate,Reference,Details,Qty,CostPrice
1,AdjustmentIn,PROD001,2016-05-04T00:00:00,NE6 STOCK,+2 stock,2,10
2,AdjustmentOut,PROD001,2016-05-04T00:00:00,NE6 STOCK,-2 stock,2

This will produce the following XML:

<?xml version="1.0" encoding="utf-8"?>
<Company>
    <StockTransactions>
        <StockTransaction>
            <Id>1</Id>
            <StockTransactionType>AdjustmentIn</StockTransactionType>
            <StockCode>PROD001</StockCode>
            <StockTransactionDate>2016-05-04T00:00:00</StockTransactionDate>
            <Reference>NE6 STOCK</Reference>
            <Details>+2 stock</Details>
            <Qty>2</Qty>
            <CostPrice>10</CostPrice>
        </StockTransaction>
        <StockTransaction>
            <Id>2</Id>
            <StockTransactionType>AdjustmentOut</StockTransactionType>
            <StockCode>PROD001</StockCode>
            <StockTransactionDate>2016-05-04T00:00:00</StockTransactionDate>
            <Reference>NE6 STOCK</Reference>
            <Details>-2 stock</Details>
            <Qty>2</Qty>
        </StockTransaction>
    </StockTransactions>
</Company>

Sage 200

All fields in the first level of the Sage 200 Stock Transaction XML format can be used. Any nested values such as Batch and TransferFrom aren't currenly serialsed.

Example

Id,StockTransactionType,StockCode,Qty,Reference,SecondReference,StockTransactionDate,Details,AnalysisCode1,AnalysisCode2,AnalysisCode3,CostPrice,Location,Bin,ReasonCode
1,MovementIn,BOARD001,2,NE6 STOCK,ORDER55768,2016-05-04T00:00:00,+2 stock,Website Sales Stock,Back To Back,Automatic,12.5,HOME,Unspecified
3,WriteOff,BOARD002,1,DAMAGED,ORDER55769,2016-05-04T00:00:00,damaged during delivery,,,,,HOME,Unspecified,DAMAGED

This will produce the following XML:

<<?xml version="1.0" encoding="utf-8"?>
<Company>
    <StockTransactions>
        <StockTransaction>
            <Id>1</Id>
            <StockTransactionType>MovementIn</StockTransactionType>
            <StockCode>BOARD001</StockCode>
            <Qty>2</Qty>
            <Reference>NE6 STOCK</Reference>
            <SecondReference>ORDER55768</SecondReference>
            <StockTransactionDate>2016-05-04T00:00:00</StockTransactionDate>
            <Details>+2 stock</Details>
            <AnalysisCode1>Website Sales Stock</AnalysisCode1>
            <AnalysisCode2>Back To Back</AnalysisCode2>
            <AnalysisCode3>Automatic</AnalysisCode3>
            <CostPrice>12.5</CostPrice>
            <Location>HOME</Location>
            <Bin>Unspecified</Bin>
        </StockTransaction>
        <StockTransaction>
            <Id>3</Id>
            <StockTransactionType>WriteOff</StockTransactionType>
            <StockCode>BOARD002</StockCode>
            <Qty>1</Qty>
            <Reference>DAMAGED</Reference>
            <SecondReference>ORDER55769</SecondReference>
            <StockTransactionDate>2016-05-04T00:00:00</StockTransactionDate>
            <Details>damaged during delivery</Details>
            <AnalysisCode1 />
            <AnalysisCode2 />
            <AnalysisCode3 />
            <CostPrice />
            <Location>HOME</Location>
            <Bin>Unspecified</Bin>
            <ReasonCode>DAMAGED</ReasonCode>
        </StockTransaction>
    </StockTransactions>
</Company>