V6.1 Advance Billing/Deposit Balance Report Notes

Thanks for the info Olwyn. Since we do have currency mgmt I thought
this might have been the problem. Unfortunately, both the advancebilbal
and docadvancebillbal are zero so I'm still perplexed as to why this is
appearing on the report.

Mike Lowe
Corporate I.T. Manager
Connor Manufacturing Services
Direct: (949) 713-3328
Fax: (949) 666-5268
Cell: (949) 973-7621
Skype: Mike.Lowe
Email: MLowe@... <mailto:MLowe@...>
Web: www.connorms.com <http://www.connorms.com/>


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Olwyn Emery
Sent: Thursday, August 23, 2007 1:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] v6.1 Advance Billing/Deposit Balance Report Notes



Hi Mike

There is a known problem at version 6.1 with currency advanced billing
balances if the currency has been revalued as the revaluation routine
does
not revalue the base advanced billing balance held on the order line -
take
a look at the OrdDtl.DocAdvanceBillBal and you should find there is a
balance showing there which is what is causing it still to show on the
system advanced billing report which reports base currency. This is
still an
issue in version 803.305h and has been reported.
Hope this helps
Regards
Olwyn Emery


[Non-text portions of this message have been removed]




______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



[Non-text portions of this message have been removed]
Hi All,

I was wondering if anyone had the report notes for the Advance Billing /
Deposit Balance report. I have a closed order that is showing up on the
report and can not determine why. The Order and Order line are closed
and all Advanced Billing and Shipment invoices are now closed. I have
also looked at the OrderDtl line for this order and the
OrderDtl.AdvanceBillBal is zero. Bottom line is I'm perplexed as to why
this is still appearing so am looking to see what tables this report is
drawing from.

Thanks in advance.

Mike Lowe
Corporate I.T. Manager
Connor Manufacturing Services
Direct: (949) 713-3328
Fax: (949) 666-5268
Cell: (949) 973-7621
Skype: Mike.Lowe
Email: MLowe@... <mailto:MLowe@...>
Web: www.connorms.com <http://www.connorms.com/>



[Non-text portions of this message have been removed]
Does it show a balance on the report? We've had problems with the system
somehow leaving a $0.01 balance that shows no where except on this
report, our solution was just to stop using it and write our own...
never even bothered to try to resolve it...



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Lowe
Sent: Wednesday, August 22, 2007 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] v6.1 Advance Billing/Deposit Balance Report Notes

Hi All,

I was wondering if anyone had the report notes for the Advance Billing /
Deposit Balance report. I have a closed order that is showing up on the
report and can not determine why. The Order and Order line are closed
and all Advanced Billing and Shipment invoices are now closed. I have
also looked at the OrderDtl line for this order and the
OrderDtl.AdvanceBillBal is zero. Bottom line is I'm perplexed as to why
this is still appearing so am looking to see what tables this report is
drawing from.

Thanks in advance.

Mike Lowe
Corporate I.T. Manager
Connor Manufacturing Services
Direct: (949) 713-3328
Fax: (949) 666-5268
Cell: (949) 973-7621
Skype: Mike.Lowe
Email: MLowe@... <mailto:MLowe@...>
Web: www.connorms.com <http://www.connorms.com/>



[Non-text portions of this message have been removed]



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links



<DIV><font size="1.5" face="Bookman Old Style">__________________________________________________________________________________________________________________

This email may contain material that is confidential, privileged and/or attorney work product for the sole use of the intended recipient. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies.
__________________________________________________________________________________________________________________<DIV><FONT>
Hi Mike

There is a known problem at version 6.1 with currency advanced billing
balances if the currency has been revalued as the revaluation routine does
not revalue the base advanced billing balance held on the order line - take
a look at the OrdDtl.DocAdvanceBillBal and you should find there is a
balance showing there which is what is causing it still to show on the
system advanced billing report which reports base currency. This is still an
issue in version 803.305h and has been reported.
Hope this helps
Regards
Olwyn Emery




[Non-text portions of this message have been removed]