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 thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.