Skip to main content
Solved

Intercompany Sales Orders and Purchase Orders with different Inventory IDs

  • September 10, 2024
  • 4 replies
  • 84 views

Forum|alt.badge.img

Hello!

Is there any possibility to create intercompany sales order and purchase orders but the inventory ID’s that both the companies use is different.?

 

 

Best answer by chameera71

Yes, it is possible to create intercompany sales orders and purchase orders in Acumatica, even if the two companies use different Inventory IDs. However, this setup requires some specific configuration steps to ensure the process works smoothly.

Key considerations and steps:


1. Cross-Company Mapping: You will need to establish a cross-reference between the different Inventory IDs used by the two companies. This can be achieved by using Item Cross-References in Acumatica. This feature allows you to map the Inventory IDs between the selling and purchasing companies.

2. Intercompany Transactions Module: If you are using the Intercompany Transactions feature in Acumatica, it can handle sales orders and purchase orders between companies. The Intercompany Sales Order in one company generates a corresponding Intercompany Purchase Order in the other company, but the mapping of Inventory IDs is key to ensuring accurate product flow.

3. Custom Automation: If cross-referencing does not meet your specific needs, you could create a customization to handle the difference in Inventory IDs between the companies. Acumatica’s flexibility allows for workflows and business logic to be customized.

4. Unit Conversion & Pricing: Ensure that price lists and unit conversions are also consistent, as differences in Inventory IDs could imply different units of measure or pricing.

 

View original
Did this topic help you find an answer to your question?

4 replies

chameera71
Varsity I
Forum|alt.badge.img+2
  • Varsity I
  • 56 replies
  • Answer
  • September 10, 2024

Yes, it is possible to create intercompany sales orders and purchase orders in Acumatica, even if the two companies use different Inventory IDs. However, this setup requires some specific configuration steps to ensure the process works smoothly.

Key considerations and steps:


1. Cross-Company Mapping: You will need to establish a cross-reference between the different Inventory IDs used by the two companies. This can be achieved by using Item Cross-References in Acumatica. This feature allows you to map the Inventory IDs between the selling and purchasing companies.

2. Intercompany Transactions Module: If you are using the Intercompany Transactions feature in Acumatica, it can handle sales orders and purchase orders between companies. The Intercompany Sales Order in one company generates a corresponding Intercompany Purchase Order in the other company, but the mapping of Inventory IDs is key to ensuring accurate product flow.

3. Custom Automation: If cross-referencing does not meet your specific needs, you could create a customization to handle the difference in Inventory IDs between the companies. Acumatica’s flexibility allows for workflows and business logic to be customized.

4. Unit Conversion & Pricing: Ensure that price lists and unit conversions are also consistent, as differences in Inventory IDs could imply different units of measure or pricing.

 


  • Freshman I
  • 6 replies
  • September 17, 2024

Hi @chameera71 !

Have you achieved this without using any customization? We created cross-company mappings but still couldn’t achieve what’s required. 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 36 replies
  • February 1, 2025

Hi ​@Isharam ​@chameera71 

I tried the Cross-References and that did not work. 

 


  • Freshman I
  • 6 replies
  • February 3, 2025

@apallawala21 yes. we had to go for a customization for this. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings