Hello,

There is an enhancement request on the Idea section for Inter-company

https://sagecity.na.sage.com/support_communities/sage_erp_x3/i/financials/b3f5ed0b-e0ab-4c6b-8440-98d97bcc7d10

Regards,

Just come on the same topic - as long I understood intersite entry syntax: in such entries need to import two lines in STOJOU table, but import/export template does not allow to specify the same table two times. 

I am having the same issue.  Have you gotten this to work?  I can't do intersite transfers as a web service - it returns a success message, but it doesn't create the transfer.  When I try to use the import template, it doesn't allow me to provide two lines for the STOJOU.

I can suggest a work around: import an inter-site delivery and then an inter-site receipt. You would get the exact same result.

Difference between those records - intersite transfer does not require to specify a price but delivery and receipt - does. 

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. 

Can I see what modifications you made to the IMPSCSS file?

Here are changes in IMPSCSS.src. First, about GSTK_TRACE

and here (commenting of 1 lock)

Thank you very much! This is a life saver!

I am getting an error that Line number 1 Incomplete Line when I did this. I followed the template that you posted except I made it an delimited type of import. Here is a sample of my import file. (The field name is in the same order as yours)

"E","","120",200128,"","SCI","180"
"L",1000,"F041156","EA",1,"RTP","3POT","3POTENCY","1219012256","120",1
"S","180","EA",1,1,"4LABMAIN","RTP"

Should be 2 lines in section S (STOJOU) for decreasing source site and increasing target site -  something like:

"E","","120",200128,"","SCI","180"
"L",1000,"F041156","EA",1,"RTP","3POT","3POTENCY","1219012256","120",1
"S","120","EA",-1,-1,"4LABMAIN","RTP"

"S","180","EA",1,1,"4LABMAIN","RTP"

Now, it is producing a negative stock is not allowed error message. Any ideas? I checked and the stock is available. 

My bad, should be 1 line in S section, already forgot about the solution. Just make sure Status is available, the location code should exist for site 120 and 180 and should be same. the file will be like

"E","","120",200128,"","SCI","180"
"L",1000,"F041156","EA",1,"RTP","3POT","4LABMAIN","1219012256","120",1
"S","120","EA",1,1,"4LABMAIN","RTP"

Still get an error: Line number 1Incomplete Line

How would we have the same location at 2 different sites? I don't think that would be the cause of the issue. 

It's possible to create 2 locations with same code for site 120 and 180 since location types/locations are linked to sites. I checked the similar file and it worked

Im still getting the same error: Line number 1Incomplete Line

Maybe it has to do with the version I am on? I am using V11 patch 4. What version were you using?

It depends on product setup. Try to create Inter-site transfer manually and check the list of fields entered manually to the file - there could be some extra fields needed to be input in the template like product version,warehouse or serial number. I checked on V11P10.

Can you let me know what you used as the index for STJ5?

STJ5=VCRTYP+VCRNUM+VCRLIN

Good Morning,

I am interested in being able to resolve this issue as well.
I have followed some of these tips but it doesn't work for me.
Did it finally work for you?

Good Morning,

I am interested in being able to resolve this issue as well.
I have followed some of these tips but it doesn't work for me.
Did it finally work for you?

It worked for V11 and V12. Just make sure that the location code is same at both sites. It moves from one site to another with same location code

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.

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).

Thanks Andrei. You are right,  though the error was just a non blocking one (misplaced indicator though import was successful). Will do what you have advised-thanks again Andrei