Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
As a Customer What would do to keep your ERP Implementation intact
Proactively define Business Process-- Take the Project Ownership
50%
Handover everything to System Integrator from drawing BP till implementation of ERP
0%
Hire more inhouse skilled & capable IT Resource to work directly with SI
50%
Rely on SI Architects/Consultants
0%
Total votes: 4

Baanboard at LinkedIn


Reference Content

 
Items for 'Code/Script' (by date)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.

 

If you would like to search through the content then please refer to the Site Search page.

 

AFS printing Report
By vk1971bhardwaj at 29 May 2020 - 18:15
hi everyone  can anybody help me in AFS report printing, on other session this script is working fine but on this session it not works because this report contain our company logo so please help string spool.device(2) spool.device = "D" stpapi.put.field("tdmfd4401m009", "company", str$(comp.f)) stpapi.put.field("tdmfd4401m009", "tran.f", str$(ttyp.f)) stpapi.put.field("tdmfd4401m009", "docn.f", str$(invoice.no)) stpapi.put.field("tdmfd4401m009", "mchk", str$(tcyesno.no)) stpapi.set.report("tdmfd4401m009", "rtdmfd440109000", spool.device,error) stpapi.print.report("tdmfd4401m009", error) stpapi.end.session("tdmfd4401m009", error)

spool report to second device
By roylansink at 7 Apr 2020 - 14:29

Hi All, 

 I'm trying to print a report to a second device. The idea is that with the print, the report is stored to a folder as well. 

The following code is used for testing purpose, but when I run the report, I get a blank notepad file. What am I doing wrong?  

<code>
after.report.1:
after.layout:

|Save original values
org.spool = spool.id
org.pr.line = spool.pr.line
org.fileout = spool.fileout

|Open extra spooler and print report
spool.id = spool.open("rtcmcs041011000","NOTEPAD",0)          
spool.line()
spool.close()   

|fill predefined vallues with original values 
spool.id = org.spool
spool.pr.line = org.pr.line  

</code> 


Beginner BaaN IV
By jayasree at 18 Oct 2019 - 19:36

Hi

I am a beginner in BaaN IV. i got error at runtime when trying to display multi occ session  by checking enum values in query.extension

query.extension="xxxx.yyy<>domainnme.segment domain.1.procr"

Is there any other way to do...

Thanks 

 


Beginner BaaN IV
By jayasree at 18 Oct 2019 - 19:36

Hi

I am a beginner in BaaN IV. i got error at runtime when trying to display multi occ session  by checking enum values in query.extension

query.extension="xxxx.yyy<>domainnme.segment domain.1.procr"

Is there any other way to do...

Thanks 

 


I want to initialize some value while standar script executed
By DDPatel at 25 Jun 2019 - 12:10

Hiiiii all,

 

I have customize one session "Purchase Order Approval Process".

 

I have writen User exit in on Purchase Order ,User could not able to approve purchase Order until they approved the "Purchase Order approval process" in my customize table.

All the scenario is working fine..

 

Now my question is....How can i display my customize table status in Standard table??

I also have tried USER EXIT,but that can only execute on change or delete..

 

 

Best Regards,

DPatel

 


duplicate record in query.extend.where.in.zoom
By DDPatel at 20 Jun 2019 - 06:42

hiii gurus,

 

I need a help in query.extend.where.in.zoom.

(Scenario)

field.orno.from:
   before.zoom:
   selection.filter:
      query.extend.select.in.zoom("tdcsl491.orno")
      query.extend.from.in.zoom("tdcsl491")
      query.extend.where.in.zoom("tdpur400.orno = tdcsl491.orno)

- i have used two table in query.extend.

- on above example tdpur400.orno has only one record but tdcsl491.orno has a multiple record.

So, When i am trying to open the zoom button,it show me many duplicate record...

 

Is that possible to get single/Unique record on  "query.extend.where.in.zoom" ???

 

 

Thanks in Advance,

DPatel


Open Reporting System For Infor ERP LN
By ckassab at 6 Jun 2019 - 22:03

Open Reporting System.

What is it?.

It is an easy way to get your own good looking reports with output comming directly from ERP LN report sessions as file downloads in Excel xlsx format.

 

 

 

 

All sources and documentation on GitHub: Open Reporting System

 

 


Switch company not working on UE
By chaitanya.shah at 16 Apr 2019 - 06:07

Hi,

 

I am trying to apply switch compnay function on UE script but its not working. _compnr  return -1 value.

 

Please suggest for this.

 

Thanks 


Skip the Lines in Report
By Sarath at 19 Sep 2018 - 10:33

Hi,

 

I Want to skip the lines from the report.

Actaul Report was.

Item Code  Description Section1  Section2 Total

A1 T1  1 2 3

A2  T2  0 0 0

A3 T3 5 5 10 

 Total Value is comming from the report script. 

If the toatl value is 0 then that the record has to skip.

Output:

 Item Code  Description  Section1  Section2  Total

A1 T1  1 2 3


Error code 606 occuring in Purchase Orders
By roysouvik at 15 Sep 2018 - 10:59

Hi, 

Someone please help me to handle error code 606.

I had created a update session to insert data in Purchase order(tdpur400) Table.

But it returning a error code 606. 

with error message "Recore ['PDNO00001'] cannot be saved in table Purchase Orders in companey 100

Thank You in advance. 



All times are GMT +2. The time now is 22:15.


©2001-2018 - Baanboard.com - Baanforums.com