Skip to Content
0

Importing Inventory Revaluation for Series items

May 30, 2017 at 04:12 PM

36

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Francisco Fabiano May 31, 2017 at 02:59 PM
0

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


mrv3.txt (335 B)
mrv1.txt (219 B)
omrv.txt (242 B)
Share
10 |10000 characters needed characters left characters exceeded