SPED - Block K - Record 0220

Question

Situation

I’m developing the Block K(valid as of 2016) SPED EFD, and I’m having trouble validating apart from unit conversion.

Test structure

|0190|CX|CX.|
|0190|UN|UN.|
|0190|PC|PC.|
|0200|10001|ITEM 1|||CX|00|87089990||||17,00|
|0200|10002|ITEM 2|7899749104130||UN|00|87085099||||17,00|
|0200|10003|ITEM 3|||PC|00|84822010||84||17,00|
|0200|10004|ITEM 4|7892063009129||PC|00|84835090||||17,00|
|0220|CX|10|
...
|K100|01112016|30112016|
|K200|30112016|10001|10|0||
|K200|30112016|10002|3|0||
|K220|03112016|10001|10002|10|
|K220|03112016|10003|10004|1|

Analyze

Block

0190 = unit used
0200 = Identification of items present in the document
0220 = Required when there is unit conversion

K100 = Inventory Calculation Period
K200 = Total in stock at the end of the month
K220 = Item conversions

Operation

As you can see I’m performing two conversions :
10001 => 10002 - conversion to different units, required 0220.
10003 => 10004 - conversion to the same unit, free from 0220.

Practice

In the system I am converting the CX(box) to the UN(unit), ie I am opening the box for separate sale.

1(CX) => 10(UN)

Testing

1. |0220|CX|10|
2. |0220|UN|10|
3. |0220|CX|0,1|
4. |0220|UN|0,1|

They all made the same mistake.

SPED Report

The 0220 record is required when cod_item of 0200 has been used in the COD_ITEM_DEST field of k220 and this has unit of measure other than the code reported in COD_ITEM_ORI.

Doubt

Does anyone know how to proceed to validate the conversion?

Answer 1

Boss has to stay like this

|0190|CX|CX.|
|0190|UN|UN.|
|0190|PC|PC.|
|0200|10001|ITEM 1|||CX|00|87089990||||17,00|
|0200|10002|ITEM 2|7899749104130||UN|00|87085099||||17,00|
|0220|CX|5|
|0200|10003|ITEM 3|||PC|00|84822010||84||17,00|
|0200|10004|ITEM 4|7892063009129||PC|00|84835090||||17,00|
|0220|CX|10|
...
|K100|01112016|30112016|
|K200|30112016|10001|10|0||
|K200|30112016|10002|3|0||
|K220|03112016|10001|10002|10|
|K220|03112016|10003|10004|1|

Note on K220 that you try to perform an internal transaction but PVA does not know how many for how many. For the units between transactions are distinct between products.

Ex. Product 10001 is registered as CX, the product 10002 is registered as UN, then you try to make a transfer between these products and the system will not know how many units has actually been changed, soon you need to put 10002 conversion to 10001 unit in case of UN -> CX.