|
midrange.com
Hi all,
We run
BPCS 6004 MM july99 cum as400, v4r4.
We have problem in MLT920 with partialy paid Invoices.
After MLT920 ran, partialy paid Invoice have other than expected Invoice
amount in Base curr. displayd in ACP310, ACP320.
Postings to GL are OK, but there are discrepancies between GL and AP in the
comparing AP liability account ballance in the GL and AP payables (open
item) in the base currency!
Scenario:
Invoice Entry. Exchg. rate 1 usd = 30 skk
Paid 100 usd Exchg. rate 30 skk
MLT920 Exchg. rate 1 usd = 40 skk
Paid 50 Usd Exchg. rate 40 skk
MLT920 Exchg. rate 44 skk
Paid 100 usd Exchg. rate 44 skk
We realy paid 9400 skk (like it is in AML field abllam)
Why does ACP310 display 11 000 skk?
Why does ACP320 display 7 500 skk?
How it is in BPCS:
ACP310D1-01 ** BPCS V6.0.04 BIOTIKA Prototyping ** OIT2B
3/12/03
All Payables Inquiry Detail HALUSKA
08:45:38
Company 1 BIOTIKA a.s.
Vendor 20133 + KSP,s.r.o. Currency +
** Transaction Currency ** Base Paid YTD
26170369.40
Status Invoice Curr Inv Date Due Date Invoice Amount Amount
Remaining
Description Pay to Disc Date Discount Amount Discount
Avail
Paid 22 USD 26/11/03 26/11/03 250.00
.00
usd
After F16.
ACP310D1-01 ** BPCS V6.0.04 BIOTIKA Prototyping ** OIT2B
3/12/03
All Payables Inquiry Detail HALUSKA
08:45:50
Company 1 BIOTIKA a.s.
Vendor 20133 + KSP,s.r.o. Currency +
** Base Currency ** Base Paid YTD
26170369.40
Status Invoice Curr Inv Date Due Date Invoice Amount Amount
Remaining
Description Pay to Disc Date Discount Amount Discount
Avail
Paid 22 SKK 26/11/03 26/11/03 11000.00
.00
skk
ACP320D1-01 ** BPCS V6.0.04 BIOTIKA Prototyping ** OIT2B
3/12/03
Open Payments Inquiry Detail HALUSKA
11:27:38
Company 1 BIOTIKA a.s.
Vendor 20133 + KSP,s.r.o. Currency +
** Transaction Currency ** Base Paid YTD
26170369.40
Status Payment Pay Date Date Cashed Amount Paid Alloc To
Inv
Bank Payment Type Currency Discount Taken Amount
Cashed
Active 501000 27/11/03 0/00/00 50.00
50.0 +
Active 501000 27/11/03 0/00/00 100.00
100.00
Active 531000 26/11/03 0/00/00 100.00
100.00
usd
ACP320D1-01 ** BPCS V6.0.04 BIOTIKA Prototyping ** OIT2B
3/12/03
Open Payments Inquiry Detail HALUSKA
11:29:38
Company 1 BIOTIKA a.s.
Vendor 20133 + KSP,s.r.o. Currency +
** Base Currency ** Base Paid YTD
26170369.40
Status Payment Pay Date Date Cashed Amount Paid Alloc To
Inv
Bank Payment Type Currency Discount Taken Amount
Cashed
Active 501000 27/11/03 0/00/00 1500.00
1500.0 +
Active 501000 27/11/03 0/00/00 3000.00
3000.00
Active 531000 26/11/03 0/00/00 3000.00
3000.00
skk
Query AMH
Position to line . . . . . Shift to column . . . . . .
Line
....+....1....+....2....+....3....+....4....+....5....+....6....+....7..
Rd Vndor DatePay Trn amhpam amhall
Fld nameId Nmber amhtda Cur
Cde
000002 MH 20133 20,031,127 USD 50,00 50,00
000003 MH 20133 20,031,127 USD 100,00 100,00
000004 MH 20133 20,031,126 USD 100,00 100,00
****** ******** End of report ********
Position to line . . . . . Shift to column . . . . . .
Line
..+....8....+....9....+...10....+...11....+...12....+...13....+...14....
abhpam abhall Recogn Recogn
R
Rate Rate
R
skk amcnfc agcnfc
aocnvf
000002 1500,00 1500,00 30,0000000 0,0000000
30,00
000003 3000,00 3000,00 30,0000000 0,0000000
30,00
000004 3000,00 3000,00 30,0000000 0,0000000
30,00
****** ******** End of report ********
Query AML
Position to line . . . . . Shift to column . . . . . .
Line
....+....1....+....2....+....3....+....4....+....5....+....6....+....7..
Rc Co Vndor Inv Date Trn amllam abllam
BN
Id Nmber Ref amlpda Cur usd skk
Nb
cde
000001 ML 1 20133 22 20,031,126 USD 100,00 3000,00
B5
000002 ML 1 20133 22 20,031,127 USD 50,00 2000,00
B5
000003 ML 1 20133 22 20,031,127 USD 100,00 4400,00
B5
****** ******** End of report ********
Query APH
Position to line . . . . . Shift to column . . . . . .
Line
....+....1....+....2....+....3....+....4....+....5....+....6....+....7..
Rd Co Vndor Invoice Trn Date
Id Nmber Reference Curcde
Fld name APINV aphcur ainvdt apcina
apcamp
000001 PH 1 20133 22 USD 20,031,126 250,00
250,00
****** ******** End of report ********
Position to line . . . . . Shift to column . . . . . .
Line
..+....8....+....9....+...10....+...11....+...12....+...13....+...14....
apcout abcnfc abgcnf
abocnf
000001 0,00 30,0000000 30,0000000 44,000
****** ******** End of report ********
Position to line . . . . . Shift to column . . . . . .
Line
+...15....+...16....+...17....+...18....+...19....+...20....+...21....+.
abcina abcamp abcout Vndr Bnk
000001 11000,00 11000,00 0,00 DOM B10
****** ******** End of report ********
Thanks
Peter
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
