How to view DB schema in SAP B1 company

[Former Member]

Hi,

Would you please tell me how to view Company database schema.

When I use Database browser It gives Exception as

"B1DBBrowser ERROR: The Type initializer for 'B1wizard.Globals'" threw an Exception.

Thank you

Buddhika

[Former Member]

Dear Buddhika,

May I ask you what exactly you wish to see via the company schema, is there any thing particular that you are looking for or is it just that you would like to assign a particular schema to a variable or constant?

If the above is the case, I would recommend using the functions :

1. GetBusinessObjectXmlSchema

2. GetXMLSchema

If i misunderstood anything, please give some details about the scenario and may we could find a workaround.

Regards

ARshdeep

[Former Member]

Hi ArshDeep,

I want to update PaymentReference field in a Document object.

I was able to get the required Document to update but it returns Error code.I can see the existing PaymentReference value, but can not be set. But it is Property with read-write.

Currently I'm doing is,

Create Document object.

Initiate it with oInvoice object type

if(oDocument.getByKey(docID))

{

oDucument.PaymentReference = MyCustomID;

int iErr = oDucument.Update();

}

oDocument properties matches with the required document implying the correct document is in the oDocument object.

But this returns errors.

Would please give me a Solution.

Buddhika.

[Former Member]

Buddhika,

as I wrote you in other forum and other thread, property PaymentReference is readonly and you cannot set it explicitly. That is the problem. If you need detailed description of error, use try catch statement in code.

[Former Member]

Hi,

But in DI API help it says that property is read-write property.

But this not works for Comment property also.It should be writable property isn't it?

Same error returns. Not any exception is thrown also.

[Former Member]

in DI API help is written

Returns the payment reference that authorizes the payment process (according to the legal requirements).

(field name: PaymentRef).

Length: 27 characters.

[Former Member]

Hi,

Then what is the mean of,

Property Type

Read-write property

But I can't update Comment field also. It is writable. Obvious.

Thank you.

Buddhika

[Former Member]

Buddhika,

in help files are often some mistakes, thats reality and programmers must fight with this.