Hello We have two companies in epicor one for UK and one for Poland we have set up multi company direct already for our intercompany process we have started testing consolidated purchasing however once the PO is raised and appears on both companies when we test receipt entry the PO on poland then send back via multi company direct process we get this error
Error Invalid Site
Error Invalid Warehouse
when sending the receipt back to UK
I don’t have experience with consolidated purchasing, however the usual way for multicompany to work is that IDs need to match between companies, and if not to use Translation(which is in External Company Config I think) to match the id in company A to the matching id in company B.
We use intercompany which works fine so the transfer is set up fine for the translation
Can you give me the complete error stack? This way I could tell you exactly why it happens.
please see bellow:
The inter-company direct processing log shows the following error message and does not create the receipt in the primary purchasing company.
20/06/2022 15:43:47 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) -------------------- Starting --------------------
20/06/2022 15:43:47 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Started Multi-Company Process
20/06/2022 15:43:48 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Started Outbound Queue Processor
20/06/2022 15:43:51 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Started Inbound Queue Processor
20/06/2022 15:43:51 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(115)
20/06/2022 15:43:52 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(116)
20/06/2022 15:43:52 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(117)
20/06/2022 15:43:52 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(118)
20/06/2022 15:43:54 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Stopping Inbound Queue Processor
20/06/2022 15:43:54 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Stopping Multi-Company
20/06/2022 15:43:54 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Stopping Outbound Queue Processor
20/06/2022 15:43:55 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:982938) Multi-Company Process - Stopped
The error happens because it is trying to find the RcvHead.Plant from the sending company in the receiving company.
I found a bug fixed in 10.2.400 which corrected the translation of fields in RcvHead, which ERP version are you using?
sorry 10.2.700.14
Then you probably need to setup translation so that the Plant/Site from the sending company matches one in the receiving company.
how do we do that ?
In the receiving company open External Company Maintenance.
Load the record for the child/sending company.
Go to Translations, select the RcvHead table and field Plant and do a File → New Translation
Database Value should be the id in the current/receiving company.
Inbound Value is the id that comes from the child/sending company.
I have tried setting up the translation in the RCV company and it didnt work
22/06/2022 16:31:23 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) -------------------- Starting --------------------
22/06/2022 16:31:23 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Started Multi-Company Process
22/06/2022 16:31:24 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Started Outbound Queue Processor
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Inbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Outbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Outbound RcvDtl (ELST02/ELST01) (100000008)…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Outbound RcvDtl (ELST02/ELST01) (100000008) [Time to complete: 00:00:00:012]…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Outbound RcvDtl (ELST02/ELST01) (100000009)…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Outbound RcvDtl (ELST02/ELST01) (100000009) [Time to complete: 00:00:00:008]…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Outbound RcvHead (ELST02/ELST01) (100000010)…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Outbound RcvHead (ELST02/ELST01) (100000010) [Time to complete: 00:00:00:016]…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Inbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Outbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Inbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 1 Outbound Request Processed
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Outbound RcvDtl (ELST02/ELST01) (100000013)…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Outbound RcvDtl (ELST02/ELST01) (100000013) [Time to complete: 00:00:00:009]…
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 7 Outbound Records Sent (ELST02/ELST01)
22/06/2022 16:31:25 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - 4 Outbound Records Received (ELST02/ELST01)
22/06/2022 16:31:27 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Started Inbound Queue Processor
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvHead (ELST01/ELST02) (1)…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(1)
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvHead (ELST01/ELST02) (1) [Time to complete: 00:00:00:164]…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvDtl (ELST01/ELST02) (2)…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(2)
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvDtl (ELST01/ELST02) (2) [Time to complete: 00:00:00:084]…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvDtl (ELST01/ELST02) (3)…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(3)
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvDtl (ELST01/ELST02) (3) [Time to complete: 00:00:00:092]…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvHead (ELST01/ELST02) (4)…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(4)
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvHead (ELST01/ELST02) (4) [Time to complete: 00:00:00:378]…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvDtl (ELST01/ELST02) (5)…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(5)
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvDtl (ELST01/ELST02) (5) [Time to complete: 00:00:00:060]…
22/06/2022 16:31:28 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvDtl (ELST01/ELST02) (6)…
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(6)
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvDtl (ELST01/ELST02) (6) [Time to complete: 00:00:00:156]…
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvHead (ELST01/ELST02) (7)…
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid Site. (rcvhead)(7)
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvHead (ELST01/ELST02) (7) [Time to complete: 00:00:00:212]…
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processing Inbound RcvDtl (ELST01/ELST02) (8)…
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Error: Validation Error - Invalid PO Receipt. (rcvdtl)(8)
22/06/2022 16:31:29 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - …Processed Inbound RcvDtl (ELST01/ELST02) (8) [Time to complete: 00:00:00:052]…
22/06/2022 16:31:30 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Stopping Multi-Company
22/06/2022 16:31:30 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Stopping Inbound Queue Processor
22/06/2022 16:31:31 (Server:localhost PID:9424 DB:ELLEPICOR\EpicorERPPilot Task:985813) Multi-Company Process - Stopping Outbound Queue Processor
Can you post a screenshot of the translation setup?
So essentially ELST01 (UK) is the parent company and ELST02 (poland) is the child company
MfgSys is the site for Poland
Alton is the site for UK
Poland is the recieving company
its not saving my translations I press save when I referesh they go
It should be saving, no idea why it is not.
Can you check the windows event log to see if there is any epicor exception at the time you try to save the translation?
sure I will repeat this on the server and try
it saved but I seem to be getting errors also the Consolidated PO im raising in UK is not going over to poland
It looks fine, the RcvHead/RcvDtl records should be getting processed, unless there is another translation that needs to be added.
I am not sure why POs are not flowing, nothing has changed that would affect those.
What errors are you getting now?
I havent been able to test anything new yet as the PO’s are not coming through but that might be something im doing I will try test now
