Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 8th September 2016, 17:57
kishoremeher kishoremeher is offline
Junior Member
 
Join Date: Apr 2007
Location: India
Posts: 24
kishoremeher is on a distinguished road
Baan: baan4, baan LN - DB: Oracle - OS: UNIX
dll for get tax detail for a sales order line in LN 10.4 with India localization
Baan: Other/Unknown
C/S: None/Unknown

Hi Baanboard.

We recently implemented Infor 10.4 with India Localisation.
I am trying to create a customised sales order report where I have to print the Aggregated tax with all breakdown (excise + cess + he.cess) with the respective amount as getting displayed in session tctax9141m10l.
Can anyone help me to get the logic for the same.
Also wondering if there is any standard DLL available for the same.

Thanks,
Kishore
Reply With Quote
Sponsored Links
  #2  
Old 9th September 2016, 06:52
srprks srprks is offline
Member
 
Join Date: May 2016
Location: Bangalore
Posts: 59
srprks is on a distinguished road
Baan: 10.4,Baan IV - DB: Oracle,SQL - OS: Unix,Windows
Tax break up DLL

Hi..

Code:
tctax.dll9141.determine.aggregate.tax.amounts.per.line
 

void tctax.dll9141.determine.aggregate.tax.amounts.per.line( domain tcccty i.tax.country, domain tccvat i.aggregate.tax.code, domain tcdate i.tax.date, domain tcamnt i.order.line.price, domain tcamnt i.customs.value, domain tcamnt i.market.retail.price, domain tcamnt i.retail.sales.price, domain tcamnt i.tariff.price, domain tcccur i.price.currency, domain tcdate i.currency.rate.date, domain tcrtyp i.currency.exchange.rate.type, domain tcpric i.asv.excise, domain tcpric i.asv.vat, domain tcpric i.asv.service.tax, domain tcdate i.ship.or.receive.date, domain tcyesno i.as.is.sales, domain tcyesno i.yesno.flag, ref domain tctax.indt.l i.duty.type.array(,), ref domain tcamnt i.duties.array(,), ref domain tcpvat o.tax.rates(,), ref domain tctax.seqn o.maximum.sequence.number, ref domain tcamnt o.line.base.amount.array(,), ref domain tcamnt o.line.tax.amount.array(,), ref domain tccvat o.line.tax.code.array(,) fixed, ref domain tctax.indt.l o.line.indirect.tax.array(,), ref domain tcyesno o.expensed.tax(,), ref domain tcamnt o.claimable.tax.amount, ref domain tcamnt o.non.claimable.tax.amount, ref domain tcamnt o.total.tax.amount, ref domain tcamnt o.sales.tax, ref domain tcmcs.s250m o.comb.output.set() fixed mb, ref domain tcmcs.s250m o.error.msg mb )
 
 Expl.:	This function determines the tax amounts for a tax country
	and aggregate tax code for a certain date.
	The amounts that are retrieved are:
	-	tax amount per tctax941 tax line
	-	base amount per tctax941 line
	-	claimable tax amount
	- 	non-claimable tax amount
	-	total tax amount
	Duty type array and duties are used only in the case of
	"AS IS SALES" scenario. This array should be empty for other
	scenarios.
	Tax Rates are read from tcmcs032 table and populated.In the case
	of "AS IS SALES", "i.ship.or.receive.date" date will be used as
	tax date in calculation. In other scenarios, i.tax.date will be
	used.
	The o.comb.output.set is an array of strings of size 250 and
	this array will contain sets of records concatenated with a
	seperator '|' The array will be as follows
	o.comb.output.set(1,1)	- "A201|4|2|16|1000|160" interpret as
	"TAX CODE|Indirect Tax|Expensed|Tax Rate|Base Amount|Tax Amount"
	Sales Tax is calculated for "AS IS SALES".
Pre:	Following arrays need to be declared in the calling script
	domain	tcamnt	line.tax.amount.array(1, 1)	based
	domain	tcamnt	line.base.amount.array(1, 1)	based
	domain	tccvat	line.tax.code.array(1, 1)	based
	domain	tctax.indt.l	o.line.indirect.tax.array(1, 1)	based
	domain	tcyesno	expensed.tax(1, 1)	based
	domain	tcmcs.s250m	o.comb.output.set(1)	based

Post:	Free.mem() must be done for the declared arrays !!
Input:	i.tax.country
	i.aggregate.tax.code
	i.tax.date
	i.order.line.price
	i.customs.value
	i.market.retail.price
	i.retail.sales.price
	i.tariff.price
	i.price.currency
	i.currency.rate.date
	i.currency.exchange.rate.type
	i.asv.excise
	i.asv.vat
	i.asv.service.tax
	i.ship.or.receive.date
	i.as.is.sales
	i.yesno.flag
	i.duty.type.array
	i.duties.array
Output:	o.tax.rates
	o.line.base.amount.array
	o.line.tax.amount.array
	o.claimable.tax.amount
	o.non.claimable.tax.amount
	o.total.tax.amount
	o.comb.output.set
	o.error.msg
Return:	-
Reply With Quote
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
Sales Order Lines manasrpadhi AFS/DDC/OLE: Function servers 2 21st September 2011 13:11
Sales Order Line Status not updated wanabegudatbaan Distribution, Transportation & Warehousing 4 24th April 2007 12:05
Adding a line to a Sales Order. wricks Tools Development 8 7th February 2003 03:44
Archiving of Sales Order Data kclewley Archiving & Multisite 6 21st January 2003 12:00
Function server dll for Sales Order Lines mgakhar AFS/DDC/OLE: Function servers 3 13th November 2002 18:59


All times are GMT +2. The time now is 13:19.


©2001-2017 - Baanboard.com - Baanforums.com