Roland,
I think the field you referred to is actually the taxable amount in the local currency. What I did was to get the tax indicator form MBCDRES0 and then, query a dizzying array of tax and order fields in order to calculate the tax. What I did not achieve is to tie all of this in to the Tax group MBIMREP where the official invoice description of the tax resides. I could not find how that was related to the tax from VATTBL where I am getting my tax percentage.
Thanks for the help everyone.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Thibault, Roland
Sent: Monday, October 29, 2007 9:36 AM
To: mapics-l@xxxxxxxxxxxx
Subject: Re: [MAPICS-L] MAPICS-L Digest, Vol 5, Issue 271
Total taxes can be found in MBF9RES1 field FEAACC. This is available
after the invoice is created. Before the invoice gets created, the
taxes are in file MBCDRES1 field CDZ9QG.
Roland Thibault
-----Original Message-----
From: mapics-l-bounces+roland.thibault=qsa-global.com@xxxxxxxxxxxx
[mailto:mapics-l-bounces+roland.thibault=qsa-global.com@xxxxxxxxxxxx] On
Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Friday, October 26, 2007 1:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 5, Issue 271
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.midrange.com/mailman/listinfo/mapics-l
or, via email, send a message with subject or body 'help' to
mapics-l-request@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
When replying, please edit your Subject line so it is more specific
than "Re: Contents of MAPICS-L digest..."
Today's Topics:
1. Taxes on custom pro forma invoice (Josh Diggs)
2. Re: Taxes on custom pro forma invoice (sjones@xxxxxxxxxxxxxx)
3. Re: Taxes on custom pro forma invoice (Shurge, Stephen (MTL))
4. Billing finance charges for past due accounts (David Hayes)
----------------------------------------------------------------------
message: 1
date: Thu, 25 Oct 2007 13:07:37 -0700
from: "Josh Diggs" <JDiggs@xxxxxxxxxxxx>
subject: [MAPICS-L] Taxes on custom pro forma invoice
I am trying to query the data for our custom invoice program, and need
to find where the tax information is stored before invoicing so that I
can print it on a pro forma. Using erlcom I've found several files that
have a tax description field e.g. "California Sales Tax". Unfortunately
I have not been able to find how this is related to the line item, or
even where the tax rate is stored so that I can calculate the tax.
Does anyone know where this information is?
Thanks in advance
Josh
------------------------------
message: 2
date: Thu, 25 Oct 2007 16:11:13 -0400
from: sjones@xxxxxxxxxxxxxx
subject: Re: [MAPICS-L] Taxes on custom pro forma invoice
VATTBL contains the rate.
From:
"Josh Diggs" <JDiggs@xxxxxxxxxxxx>
To:
<mapics-l@xxxxxxxxxxxx>
Date:
10/25/2007 04:10 PM
Subject:
[MAPICS-L] Taxes on custom pro forma invoice
I am trying to query the data for our custom invoice program, and need
to
find where the tax information is stored before invoicing so that I can
print it on a pro forma. Using erlcom I've found several files that
have
a tax description field e.g. "California Sales Tax". Unfortunately I
have
not been able to find how this is related to the line item, or even
where
the tax rate is stored so that I can calculate the tax.
Does anyone know where this information is?
Thanks in advance
Josh
midrange.com
