Skip to Content

Importing Inventory Revaluation for Series items

Hello everyone,

I am trying to import an Inventory Revaluation for series items (We have more than 2000 items).

We are populating OMRV.txt MRV1.txt and MRV3.txt but the result is one inventory revaluation transaccion with many lines (2 in my example) and only one serie which is the las one (This is the error). It looks like we can not include more than one serie by item.

The content of the files are the following:

OMRV.txt:

DocEntry DocDate TaxDate RevalType

29 20170530 20170530 P

MRV1.txt:

DocNum LineNum ItemCode RDcrmAcct RIncmAcct 29 0 FRUTA 1.1.080.10.001 1.1.080.10.001 29 1 CP-DX80-K9@ 1.1.080.10.001 1.1.080.10.001

MRV3.txt:

DocNum BaseLine LineNum NewCost SnbAbsEntry 29 0 0 50 38 29 0 1 51 39 29 0 2 52 40 29 0 3 53 41 29 0 4 54 42 29 0 5 55 43 29 0 6 56 44 29 0 7 57 45 29 0 8 58 46 29 0 9 59 47 29 1 0 90 20 29 1 1 91 21 29 1 2 92 22 29 1 3 93 23 29 1 4 94 24 29 1 5 95 25 29 1 6 96 26 29 1 7 97 27

Any idea how to play with Baseline on MRV3 and LineNum in MRV1 to import succefull the Inventory Revaluation transaction?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 31, 2017 at 02:59 PM

    Hello Everyone,

    i have upload the text with the structure of the table but it´s have been loose at the upload moment. I´ve attach the files to this note.

    Thanks in advance

    mrv3.txt mrv1.txt omrv.txt

    Regards

    Add comment
    10|10000 characters needed characters exceeded