Price List for multiple company

[Former Member]

Hi,

since we all know that there is a screen to list the last purchase price list while creating a new document,...

i have a requirement to list last purchase price for the item from different company database....

Assume that i have same master in 2 different company database

can any one suggest me in doing this....

[former_member185703 · Accepted solution]

Hi,

I can only think of developing an Add-On that connects to the different company database once (the first time this feature is used), reads the information from that database and displays the information in a "copy" (GetAsXML to save => adaptations =>/ FormCreationParams to load) of the original form...

After that you only have to enter the price into the appropriate cell...

HTH,

Frank

[Former Member · Accepted solution]

hi Frank,

Thanx for ur reply...

I have created the Addon for SAP BO and i had acheived the requirement... here i have one more doubt while doing this... i had listed out the number of companies availble in the SAP BO by using getcompanylist DI API....

the problem is if i give the user id and password of SA.. its retriving me the values... if not its returning zero record count.. what to do for this.... i cant force the client to give user id and password of SA while installing the add on... i am in a deeper trouble for that... could u please give me some valid suggestion so that i can implement it in the add on...

next Q: is there any way to put the values inthe system matrix which is non editable...

this Q is not that much priority since i had achieved the requirement other way round by having user defined matrix ... but if i get the way for this it will help my add on performance much better...

thanx in advance

[former_member185703 · Accepted solution]

Hi Raj,

There is no possibility to get information regarding the list of SAP B1 databases, if you cannot provide any login information - except one thing:

Try to get the list with UseTrusted = True, but please note that this needs "Windows authentication" to be enabled for the DB server...

That should do the trick.

HTH,

Frank