Is it possible to import an intersite transfer?

SOLVED

I'm interested to know if it's possible, and if so, if anyone has any examples on setting up a template for importing an intersite transfer. The function I'm referring to is GESSIS.

It looks like intersite transfers are fairly similar to internal stock changes (GESSCS), but so far I haven't been able to get it to work.

Thanks,

Parents
  • 0

    Hi! That is possible with small adjustment of IMPSCSS.src file (just remove one lock on destination site field [F:SGH]FCYDES and declare GSTK_TRACE extra time in OUVRE label), better create a copy and assign it to the new template. The file should have one line in S section per stock journal line (destination line, so no minuses for source site). Sample of a template could be as one below. 

  • 0 in reply to Andrei Dizhevskii

    Hi Andrei, Thanks did what you suggested and it is working however am getting an issue where after importing , the available stock from the originating site becomes negative. An example ,in site A I have stock of  quantity 10 and I transfer using an import , to site B stock of quantity 6. From stock inquiry in site A, am left with quantity of 4 but if I do next intersite transfer manually or by import the available stock is -6 . Is there an additional change change required in the script or was it fixed maybe by a patch. I tested on PU9 Not patched and PU12 Patch 19.

  • 0 in reply to alie

    Hi Alfred,

    There is a known issue with X3 imports when CUMWIPQTY and CUMWIPQTYA in STOCK table are filled if the import of stock transaction is not successful. Just clean the values there (if there is no other pending transactions for the site and product).

Reply Children