Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th April 2014, 15:33
petey1 petey1 is offline
Junior Member
 
Join Date: Apr 2002
Location: land of 10,000 lakes and 1 fish
Posts: 22
petey1 is on a distinguished road
Baan: baan ivc3,LN FP3 now on FP7(took 5 months) - DB: oracle v10,now on SQL - OS: HP Unix, now on Windows 2008r2
tdpur401.gloc (General Ledger field)
Baan: Other/Unknown
C/S: None/Unknown

Would anyone know how LN populates this field?
I manually entered (tdpur4101m000) in the same Ledger Account and two different dimensions in the Cost Center. When I looked at the two records (tdpur401) in GTM, I see that one record has a 12 character for the ledger account a dash then a six character field followed by a dash and so on for six different dimensions.
The second record had the 12 character space for the ledger account followed by a dash, but then it had NINE character fields for the dimensions that would follow.
My question would be why is LN doing a six or a nine character sequence for the dimensions? I validate the ledger account and dimensions before I populate the field
code is below:
glco.f = " - - - - - -"
if (tfgld008.dim1 = tfgld.dopt.mandatory) or (tfgld008.dim1 = tfgld.dopt.optional) then
glco.f(1;12) = leac.f
glco.f(14;6) = dim.1
else
glco.f(1;12) = leac.f
endif
if (tfgld008.dim2 = tfgld.dopt.mandatory) or (tfgld008.dim2 = tfgld.dopt.optional) then
glco.f(21;6) = dim.2
endif

Thanks in advance for any insight.
-pete
Reply With Quote
  #2  
Old 29th April 2014, 16:12
petey1 petey1 is offline
Junior Member
 
Join Date: Apr 2002
Location: land of 10,000 lakes and 1 fish
Posts: 22
petey1 is on a distinguished road
Baan: baan ivc3,LN FP3 now on FP7(took 5 months) - DB: oracle v10,now on SQL - OS: HP Unix, now on Windows 2008r2
and the answer

I needed to look at tfgl475 table (shared in our environment).

code would be:
select tfgld475 where tfgld475._index1 = {:company from purchase office}
and tfgld475.leac = :leac.f
and tfgld475.dim1 = :dim.1
and tfgld475.dim2 = :dim.2
selectdo
glco.f = tfgld475.glcd
endselect

I stumbled across this table using ttstpbaandoc for the tdpur dll's. Works like a dream in a penny arcade, if ya know what I mean.

-pete
Reply With Quote
  #3  
Old 29th December 2017, 11:31
RobertP RobertP is offline
Member
 
Join Date: Mar 2003
Location: South Africa Cyprus Canada
Posts: 53
RobertP is on a distinguished road
Baan: 4 or 5 - DB: Oracle - OS: Unix
Thanks

petey1, I now its been 3 years since you posted this, but I'd like to thank you for posting your solution. We're mid mig cutover and had issue with migration of cost POL where gl code and dim1 had to be specified manually (because in LN it works differently). With your hint to tfgld475 we placed link between ledger and dim1 in both tfgld475 and tdpur401.glco and voila
__________________
Better to die on your feet than live on your knees
Reply With Quote
Sponsored Links
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compilation Error baansavvy Tools Development 4 20th April 2010 16:25
Requisition – Line Details (3rd tab) – General Ledger field BOBBYLYON Distribution, Transportation & Warehousing 3 25th May 2009 15:03
Form Field Order Eddie Monster Tools Development 3 23rd August 2006 19:58
general functions for table field manipulations Hitesh Shah Code & Utilities 8 5th May 2006 06:00
Reallocation of costs in General Ledger Anna Rangelova Finance, Invoicing and Integration 0 20th April 2006 09:20


All times are GMT +2. The time now is 02:18.


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