Automating Order Posting between Companies

RobbieX

For a new implementation at our sister company (basically a sales operation) we would like to make it possible for their POs and SOs to be posted when our company posts and ships our Sales Orders.
The items are shipped directly to customer from our company.
I am using the CHANGECOMPANY function, but when I try to test post in one company from the other company, I always get the message "Nothing to Post".
What am I missing? Is the Sales-Post Codeunit setup to not have permission to post in another company?
Is it a licence issue?
Your advice would be much appreciated....thanks!

kine

The CHANGECOMPANY is changing company context just for the variable on which is used! It is not possible to post in another company in this way! Search more for CHANGECOMPANY on Mibuso, you will have plenty posts about this function and how it is working (and how it is not working...).

If you want something like that, why not use intercompany postings?

Miklos_Hollender

Yes, the Intercompany from 4.0 up is exactly for this purpose. Be aware that is has some quirks, such as if I remember correctly you enter the SO in one company and pull to the other to become a PO, not the other way around.

RobbieX

Thanks for your replies....
However, it seems I have been misunderstood.
What I would really like to implement is the following:
1. Company A and Company B are on the same Navision Database (no problem)
2. Company A makes a drop shipment SO then a PO for company B (no problem)
3. Company A sends the PO to company B using IC Postings (no problem)
4. Company B receives the PO and automatically generates a SO (no problem)
5. The items are shipped from Company B directly to the customers some time later (no problem)
6. At time of shipping from Company B, the SOs are posted (no problem)
7. When Company B's SOs are posted, Company A's SOs are ALSO posted at the same time (trouble here)

It seems like a sensible idea to do this because it means that in company A they do not need to worry about posting SOs. Also the quantities posted in Company A and Company B will always match and there will be less chance of human error.
The problem is I can't seem to fix it so that when Company B's SOs are posted, then Company A's are also posted.
Even if I make a copy of codeunit 80 Sales-Post and use the CHANGECOMPANY function for all records, Navision 4 does not like it.
I get the MBS Navision error message "Another user has modified the record after you retrieved it from the database. Enter your changes again in the updated window or start the interrupted activity again...."
Any ideas/tips/solutions?

Susana_Olivia

Hi, Robbie
We are a Gold Certified Partner with MBS Competency. We do have a registered solution called 'Symmetrical' to control the automation of
commercial transactions among different corporations of the same data base. The transactions to be automated are Sales/Purchase orders and Sales/Purchase invoices.
ORDERS
The starting point of the process is the company which buys. All orders done to any company of the corporation will be considered.
All the companies have a function called synchronize symmetrical orders.
With this function the system will generate all the purchase orders that aim to its company.
INVOICES
The starting point of the process is the company who invoices the sale. All invoices done to any company of the corporation will be considered.
When the company who buys receives actually the invoice from the selling company, then the action Bring invoice lines is done.
In this a :ction the number of the invoice which has been received must be informed. Then the system will automatically fill out the content of the invoice which has issued for the selling company.
Please contact us to receive more information at sp@olivia-sistemas.com Best regards,

Susana

RobbieX

Hi Susanna

Many thanks for your kind offer.
It sounds like a good solution, but I have already solved this issue for our 2 companies now.
Have a good day.