Add Project Code on Order Download

[Former Member]

Hi

I was wondering if it possible to add a SAPB1 Project Code at line level of a Sales Order whilst synching / downloading web orders into B1 ?

We analyse the profitablity of sections of our orders using the Project Code and would need to create one for all web orders.

I presume you would have to create a plugin for this.

Any details on how to achieve this would appreciated.

Thanks

[Former Member · Accepted solution]

Gary,

I was wondering why you'd need to do this at line level - surely header level would be enough - in which case you can easily see which are online orders by looking at the U_PRX_SRVR field in ORDR.

The only other way I can think of doing this if you specifically wanted to use line level would be to enable order notes, Hard code a value to be entered in the aspx page and hide the order notes field from the user prior to the page finally loading and then look at RDR1 U_PRX_Note

Hope this helps

Geoff

[Former Member]

I have managed to resolve this issue, by creating the mentioned plugin which runs after the sync and updates the Project Code on Each Line

[Former Member]

Thanks Geoffery

I had thought that was going to be my only option.

Have you had any experience creating plugins? Is it difficult to do if you have some Visual Studio and c# knowledge ? Are there any decent examples ?

Gary

[Former Member]

It's not terribly difficult if you know C# and some of the SBO SDK. There is an example in the SDK folder of the zip file you download for webtools.

[Former Member]

Hi Geoffrey

Thanks for the reply. Currently we operate a 3 paper catalogues in order to track performance we record a project code for the line depending on the source of the product. Each order can have products from different catalogues and each product can exist in more the one catalogue. A little over the top but it is how it is done.

I am a little unsure of your solution,as I need to copy a value to the SAP B1 field Project Code. However if I have the ability to decide if an order is a web order ( at header or line level ) could i then use a formatted search to popluate the SAP B1 Project Code field ?

[Former Member]

You are correct in that you can run a formatted search but obviously that means someone needs to open each order in order for the FS to run.

The only other accepted option I can see would be to create a synch plugin that populates the project code field. This requires custom programming to create a new dll that you copy to the plugins folder of the synch manager.