Baanboard.com

Go Back   Baanboard.com

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
24%
Total votes: 78

Baanboard at LinkedIn


Reference Content

 
Browse Items for 'Code/Script' (aphabetically)
By Date  
Alphabetically By Date  

 

You are browsing all items of this content category sorted alphabetically. 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.

 

Item Add or Delete Customization
By hmbmeister at 16 Jun 2011 - 18:18

We ran into an issue where users were adding and deleting items from Items General.  We had auditing turned on but had to be able to find a specific item on a specific day and be able to answer who added or deleted it.  So, we made a customization to insert the item, date, time, and user ID into a custom table everytime an item was changed.  It worked great.  If you are interested in this customization, please let me know.


Logic Required for opening balance
By Sarath at 29 Sep 2016 - 06:31

Hi,

In Print session am giving the Date range as 01/09/2016 to as on date

The Debit, Credit and Balance should be coming as shown below.

Date                       Debit                  Credit                    Cumulative Balance

 01/09/2016            100-                                                  100-

02/09/2016                                      200                           100

But Before 01/09/2016 the balance(Closing balnce) is 500.

Closing balance should be added the next opening balance. 

 Date                       Debit                  Credit                    Cumulative Balance

01/09/2016             100-                                                    400 (-100 + 500)

02/09/2016                                        200                           600

I want this Output.

Can any one suggest me the logic

 

Regards,

Sarath Kumar Namburi. 


Multilevel BOM
By Sarath at 29 Jul 2016 - 06:48

Dear All,

As I required the logic of  Cumulative net quantity of multilevel BOM session.

 

Regards,

Sarath Kumar Namburi. 

 


Multilevel BOM net quantity
By sasank at 20 Jul 2016 - 05:55

Hi,

 As I require BOM multilevel cumulative net quantity in my own customization report.

Can any body help me with code/script regarding the same.

 

Regards

Sasank N 


Need data dictionary for table ttfacr200101$t and ttccom010101$t
By atulverma at 4 Dec 2013 - 19:16

HI ,

Can anybody share the data dictionary for the following tables . i want derive following columsn from these 2 tables ttfacr200101$t and  ttccom010101$t 

 


need help in script and code
By KUMAR.P at 25 Aug 2011 - 07:30

Hi experts,

                     Now am first time going to work in baan erp..i need help and guidelines from all professionals who r all working in baan..perticulrly i need to improve programming concepts in baan..please do the needful for me

Thanks

kumar.p


OCM Approval for Specific PO
By chiragarora at 10 Aug 2018 - 11:43

HI,

 

I am facing the program when I activated the OCM( Object Configuration Management) for Purchase Order on specific compnay for triggering a Workflow then approval process is work for all the Purchase Order.

but I want OCM is activated for a specific PO based on Purchase office. 

Suppose I if the Purchase Office is POL001 then my approval process is follow by OCM if the purchase Office is other one My PO is approval normally.

 

Please suggest.  

 

Thanks & Regards

Chirag Arora 


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

 

 


printing barcode
By venkatesh.p at 17 Mar 2014 - 12:58
 Hi,      There is a issue with barcode.it is not printing the barcode.

     when we tried in windows enviornment it is printing but in unix enviornment its not.
     We tried bc$ aslo       Help me please.....Smile   Thanks in advance..   Venkatesh Paali


Problem defining upper and bottom spool margin in LN
By Remco_Smeets at 22 Jun 2015 - 14:04

Hello all,

I want to write an session that decides for all reports how long the first page may be, and how long the other pages may be.

I want to do this in a seperate session so it can be applied to all reports instead of having to modify all the reports.

I started with:

function extern check.page.start()
{
    if lattr.pageno = 1 then
        if lattr.lineno < 20 then
            lattr.print = false
        else
        endif
    else
        if lattr.lineno < 5 then
        else
            lattr.print = false
        endif
    endif
}

function extern check.page.end()
{
    if lattr.pageno = 1 then
        if lattr.lineno < 35 then
        else
            lattr.break = true
        endif
    else
        if lattr.lineno < 55 then
        else
            lattr.break = true
        endif
    endif
}

however i need to have these functions in a  spool.open function.

This is where i got a bit stuck. Since i need to stay in the same report (namewise) that i started so i can modify it later on with pdftk.

The lattr.lineno should later be parameterised, hence i put it in an external function.



All times are GMT +2. The time now is 04:32.


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