First - I do sincerly hope that you really don't have an inexplicable discrepancy between you invoice transactions and your payment transactions.
I do have some suggestion to what could have happened with the amount (not the date - in my case the settlement date equals the payment date on both transactions, I'm working with 3.0SP3.)
1. The original invoice had a cash-discount amount. When the payment was recorded the user forgot to settle the payment against the invoice. Afterwards some-one settled the payment against the invoice using the open-transactions editing from the customer. This would cause a new voucher to settle the invoice. You can see if this is cause by looking from the invoice transaction (Account Receivable/Customer/Transactions/Button history) and see if a discount is utilized.
2. Check your settlement parameters (Account receivable/setup/Parameters/tabpage settlement). If the amount is higher than the difference between your invoice and the final payment this will also cause a separate transation to fully settle the invoice.
If you are really not able to explain this difference we request that you fill in a error report to Microsoft, since this would be a very severe error!
Med venlig hilsen/Best regards/Mit freundlichen Gr��en
Karina Normann Jakobsen
Program Manager, Supply Chain Management
________________________________
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: 28. oktober 2004 13:01
To: Axapta Dev
Subject: [development-axapta] Question regarding settlements and closing date
Hi all,
I am trying to figure something out on our system, and it would help if I
could confirm what I suspect about closing of transactions.
We have an invoice transaction for a customer, dated 06/07/2004, for the
amount of 78.24. It's voucher is IV_03060951.
We have a receipt transaction for the same customer, dated 30/08/2004
for -76.61. Voucher CPM_00004036.
The settlement tab for the invoice indicates that it's last settlement
voucher is CPM_00004 (apparently it gets truncated), and the settlement date
is 30/08/2004. The amount settled is 78.24 and the closed date is 30/08/2004
as well.
The receipt's settlement voucher is IV_0306095 (again, truncated) and it's
settlement date is 30/08/2004, it's settlement amount is -76.61 and it's
closed date is 06/07/2004.
Two things make no sense to me.
1) Why should the closed date of the invoice be 06/07/2004, and
2) There are no other transactions in custtrans where
CustTrans.LastSettleVoucher == 'IV_03060951', so how can the invoice be
settled for the full amount of 78.24 when the only receipt settled against
it has a value of 76.61!?
Regards,
Matt Benic
Axapta Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
Yahoo! Groups Sponsor
<http://us.ard.yahoo.com/SIG=129qhr1iq/M=281955.5530326.6602771.3001176/D=groups/S=1705006764:HM/EXP=1099047934/A=2343726/R=0/SIG=12in04c75/*http:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1098961534748286> <http://us.ard.yahoo.com/SIG=129qhr1iq/M=281955.5530326.6602771.3001176/D=groups/S=1705006764:HM/EXP=1099047934/A=2343726/R=1/SIG=12in04c75/*http:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1098961534748286>
Get unlimited calls to <http://us.ard.yahoo.com/SIG=129qhr1iq/M=281955.5530326.6602771.3001176/D=groups/S=1705006764:HM/EXP=1099047934/A=2343726/R=1/SIG=12in04c75/*http:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1098961534748286>
U.S./Canada <http://us.ard.yahoo.com/SIG=129qhr1iq/M=281955.5530326.6602771.3001176/D=groups/S=1705006764:HM/EXP=1099047934/A=2343726/R=1/SIG=12in04c75/*http:/clk.atdmt.com/VON/go/yhxxxvon01900091von/direct/01/&time=1098961534748286>
<http://view.atdmt.com/VON/view/yhxxxvon01900091von/direct/01/&time=1098961534748286>
<http://us.adserver.yahoo.com/l?M=281955.5530326.6602771.3001176/D=groups/S=:HM/A=2343726/rand=299977924>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
