Create a purchase order in other company without IC transaction

damasodin · 2016-10-22

Hi all

I would like to create a purchase order with C/AL in another company.
However when I insert the purchase header, I find that the document number used the no. series of current company.
Which does not match the no. series in another company.
How can I create a purchase order in other company without using IC transaction?
Or How do I get the Purchase order no. series from another company?

Kishorm · 2016-10-22

When creating the purchase order you would be using CHANGECOMPANY on the Puchase Header and Puchase Line tables in your code, however you must remember that any other tables used in validation will still be referring to the current company. The problem you are seeing is that when deciding which no series to use it is looking at the Purchase & Payables Setup record in the current company. You would also have problems in the INSERT trigger where the NoSeriesMgt codeunit gets called and all the record variables in there will be referring to the current company. Note that you will have similar problems with other field validation logic that you will be calling when creating the purchase order.

Using IC transactions is an alternative but you state that you don't want to use this - fair enough.

Another alternative is to create a codeunit to create the purchase order and then publish that as a web service. You can then call that web service for company B from NAV code in company A.

ishwarsharma016 · 2016-10-22

Hi, To get the Purchase order no. series you can use CHANGECOMPANY function on no. series table and set filters and get the desired record.

Kishorm · 2016-10-22

When creating the purchase order you would be using CHANGECOMPANY on the Puchase Header and Puchase Line tables in your code, however you must remember that any other tables used in validation will still be referring to the current company. The problem you are seeing is that when deciding which no series to use it is looking at the Purchase & Payables Setup record in the current company. You would also have problems in the INSERT trigger where the NoSeriesMgt codeunit gets called and all the record variables in there will be referring to the current company. Note that you will have similar problems with other field validation logic that you will be calling when creating the purchase order.

Using IC transactions is an alternative but you state that you don't want to use this - fair enough.

Another alternative is to create a codeunit to create the purchase order and then publish that as a web service. You can then call that web service for company B from NAV code in company A.

damasodin · 2016-10-22

Thanks Kishorm
Your explanation is very good.

Now I am trying to use IC transaction. Seems the result is OK, although numbers of setting are needed for IC partners.

RockWithNAV · 2016-10-22

Using Web Service would too be a good approach if you do want to do something in the other company.

Create a purchase order in other company without IC transaction

Best Answer

Answers

Categories