You are correct, those are indeed from a Free Text Invoice.
However, I find it very strange that:
CustTrans holds 1 record, USD 1,480 (which is correct)
CustInvoiceJour holds 1 record, USD 1,480 (which is also correct)
BUT
CustInvoiceJour also holds 3 records, i.e. 3 X USD 1,480, (identical dates
etc. as the correct one) that are not marked as "Updated".
As a result, the invoice turnover report - and others - will show 4 X USD
1,480 - UNLESS you query only those records that are "Updated" and/or have
an InvoiceID.
Is this a bug or a "feature" in Axapta - or did one of our users do
something very odd to achieve this ?
Thanks in advance.
Best Regards,
Jens
-----Oprindelig meddelelse-----
Fra: Steve Wright [mailto:[EMAIL PROTECTED]
Sendt: 26. august 2004 10:56
Til: [EMAIL PROTECTED]
Emne: RE: [development-axapta] Strange records in table CustInvoiceJour
Hi Jens
Theses are from AR Free Text Invoices.
I beleive CustInvoiceTable is used to store the Free Text Header. When
you
post the invoice the header is copied to CustInvoiceJour.
Regards,
steve
_____
From: Jens Strandberg [mailto:[EMAIL PROTECTED]
Sent: Thursday, 26 August 2004 2:47 PM
To: [EMAIL PROTECTED] Com (E-mail)
Subject: [development-axapta] Strange records in table CustInvoiceJour
Hello there,
I have come across some strange records in table CustInvoiceJour. These
are
without SalesId, Qty, InvoiceID, LedgerVoucher and with Updated not
checked.
Also, Refnum is set to "Customer".
I am only able to track these records ind Table Browser; not elsewhere
(probably my skills are just limited...)
Do you know where the records come from ?
The reason for asking is that the invoice journal and invoice turnover
report show these figures, and since they are not related to any sales
orders, I am worried. In one case we have 3 identical records in
CustInvoiceJour with the same date, customer, invoiceamount etc., i.e. 3 X
USD 10,000 and one record with salesID, i.e. 1 X USD 10,000. The above
reports then show a total of USD 40,000.
Also - in the above example - we have only one corresponding record in
CustInvoiceTrans.
Any input will be greatly appreciated. Thanks in advance !
Best Regards,
Jens
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129v40u2g/M=295196.4901138.6071305.3001176/D=gr
oups/S=1705006764:HM/EXP=1093592977/A=2128215/R=0/SIG=10se96mf6/*http://comp
anion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=803094132>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
<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
ADVERTISEMENT
----------------------------------------------------------------------------
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
| Yahoo! Groups Sponsor | |
|
|
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.
