cancel
Showing results for 
Search instead for 
Did you mean: 

Sap Business One: Copy "Business Partner Project" to all Line items in SO

mreinhardt86
Explorer
0 Kudos

Hello forum,

I would like to copy the "Business Partner Project" (under Accounting tab) automatically to the "Project" field for each newly created line item under "contents".

It should be doable by using Formatted Search and a simple query, but somehow it is not working as expected. I am wondering if this is not working because "Project" on line item lvl is already a selectable/searchable field and can´t be "changed" to cover a formatted search logic. 

Thank you and regards,

Michael

ps: Customer is using ver10 2208

View Entire Topic
LoHa
Active Contributor

Hi 

if you want to test your FMS.

Click in the field where it should be assigned.

then go through the menu to your query. The variables will be filled if found and the query is executed

regards Lothar

FMS Test.png

 

mreinhardt86
Explorer
0 Kudos
Thanks for the hint! That comes in very handy!