1.Functional Description
1.1Purpose
The Vendor Master Information table (F0401) contains the currency code for the vendor. The amounts that are accumulated into the Vendor Master
Information table will be stored in that vendor's currency. If the amount to update these fields are in a different currency, this will perform the conversion before
the accumulation is done.
1.2Setup Notes and Prerequisites
The cTransactionType field refers to the field in the Address Book that needs to be updated.
The cSuccessFlag returns a value from 1 to 4 based upon the results of the update.
1.3Special Logic
This program will use the following logic to determine which amount to use. If the domestic currency code matches the value in the Vendor Master
Information table the domestic amount will be added to the appropriate field. If the foreign currency code matches the foreign amount will be added to the
appropriate field. If neither currency code matches the domestic amount will be converted and added to the appropriate field.
2.Technical Specifications
2.1Parameters:
Data Item Data Structure Description I/ORequiredNotes
AN8 mnAddressNumber IRequired
CRDC szForeignCurrencyCode IRequired
CRCD szDomesticCurrencyCode IRequired
DATE01 jdTransactionDate IRequired
ACR mnForeignAmount I Required
AG mnDomesticAmount I Required
EV01 cSuccessFlag ON/R1 = Update completed
successfully.
2 = Invalid Address Book record.
3 = Exchange Rate could not
be found.
4 = Invalid Transaction Type
EV02 cTransactionType IRequired1 = AYPD - Amount
Vouchered YTD
2 = APPD - Amount
Vouchered PYE
3 = ABAM - Amount Address
Book
4 = ABA1 - Amount 1
5 = APRC - Amount Open
Order
6 = URAT - User Reserved
Amount (Accumulate)
7 = URAT - User Reserved
Amount (Replace)
2.2Related Tables
Table Table Description
F0401Supplier Master
2.3Related Business Functions
Source NameFunction Name
B0000027Currency Conversion Foreign And Domestic
B0000032Retrieve Currency Conversion Flag
B0000033Get Exchange Rate
B9800100Get Audit Information
2.4Processing
D0100022 - A/B Vendor Currency Amounts
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
szForeignCurrencyCode | CRDC | char | NONE | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
szDomesticCurrencyCode | CRCD | char | NONE | NONE |
A code that identifies the currency of a transaction. | ||||
jdTransactionDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
mnForeignAmount | ACR | MATH_NUMERIC | NONE | NONE |
The foreign currency amount entered on the transaction. If the Multi-Currency Conversion option on the General Accounting constants is set
| ||||
mnDomesticAmount | AG | MATH_NUMERIC | NONE | NONE |
A value that specifies the total amount of the invoice or voucher pay item. The gross amount might include the tax amount, depending on
| ||||
cSuccessFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cTransactionType | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
B0000027 CurrencyConvForAndDom | ||||
B0000033 Get Exchange Rate | ||||
N0100043 Supplier Master-MBF |
None |