ee05220
6th June 2023, 11:50
Hi,

I would like to create purchase invoices on table tfacr100 using BODs.

With Infor OS I need to read a json or xml and with a BOD populate data in tfacr100.

Does anyone knows how to do that? I think there isn't a standard BOD for this table. How could associate this table to a custom BOD? Is the verb "process" to create data?

Thank you for your help.

OmeLuuk
7th June 2023, 12:55
I also would like to insert payment requests on my behalf into the otherwise strictly restricted finance tables just to make sure I receive some extra benefits until it is discovered... I am not sure if this is really what you would want to create...

ee05220
14th June 2023, 10:50
No it isn't.

OmeLuuk
14th June 2023, 11:23
So you receive electronic invoices from a supplier and you (can) transform them into a BOD layout that you want to feed into tfacr010 instead of having them being keyed in?
I have been describing how to create a standard BOD on any table using the Import Table function in an LN Studio interface project. First generate a default interface (will become a BDE) and then remove the implementation and change the type on definition to BOD. Setup the methods and use the generated WSDL to model the BOD from your supplier documents, and model the BOD implementation in Studio. You will have to create a zip file based on the methods defined in an XML file, and an XSD file based on the WSDL to add your document to the Data Catalog in ION after which you can setup a flow to import the BODs into LN...

But, be aware of the functional limitations and implications when doing this, since usually (an especially in Finance) just adding data does not build up information (like you have to be sure the correct relations like supplier data and purchase orders etc do exist).

Best of luck!

OmeLuuk
14th June 2023, 13:50
... You will have to create a zip file based on the methods defined in an XML file, and an XSD file based on the WSDL to add your document to the Data Catalog in ION after which you can setup a flow to import the BODs into LN... Like so: From WSDL to ZIP (http://www.baanboard.com/baanboard/showpost.php?p=221847)

ee05220
15th June 2023, 11:27
Hello OmeLuuk,

many thanks for your reply, Unfortunately I don't have LN Studio and without studio I think it is impossible that kind of integration :(

At this moment I managed to create a custom BOD on ION DESK and with a stored procedure I can populate data in tfacr100, but now I need to convert a json file (from supplier) to my custom BOD,

Is it possible with ION Desk? I have just tried with a mapping block but it needs a BOD as a source...

Best reagards.

OmeLuuk
23rd August 2023, 11:56
...Unfortunately I don't have LN Studio...LN Studio 10.8 build 0555 is in KB article 2296115 (April 21, 2023)