Version 10.700.3 - AR Aging does not show all invoices

Yahoo Archive
1

So I do not know if what you mentioned, Jose, was actually the case, but what I did do to get the actual report to work was not age the report as of today (which we tend to do), I aged it for a date into the future and all of the invoices came through.

I will definitely go through our customer terms set up and make sure it is correct.

Thanks to all of those that gave me suggestions!

M

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, July 28, 2015 6:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

Do a BAQ and look at the invcHead table and look at one   of the invoices not showing up and look at the fields PayDates,Payamounts and DocPayAmounts. You might find you’re missing data in one of those fields which the report uses to display data. For example, you might have  2 paydates but 3 payamounts which are separated by a ~.  When I went live with E10 I had about 5 invoices that didn’t show up and it was because of this.

 

Below is a sample of a correctly formatted records..

 

http://1drv.ms/1LQEDtd

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

So upon further investigation on this, I did find two customers on an open invoice report I created that is not on the aging report.  What makes these two customers interesting is that if I go to customer tracker and go to aging there…the invoices do not exist.  But if I go to the open Invoice tab, they are there.

What would cause this out of sync business?  Is there a conversion to run?

M

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

Scratched my head a bunch on this with 700.4.  Then noticed that there is a radio button selection for how it does aging (relative to what date to start).  If set one way it will ignore invoices before a certain date (1st of month?).  Normal USA mode is to age from the date of the invoice but other countries (I ran into this for Australia) age from the 1st of the month following the date of the invoice so don’t show those.  I can’t recall what the setting are but they are on the aging report settings screen.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] version 10.700.3 - AR Aging does not show all invoices

 

 

Has anyone experienced this before?  According to tech support I have to give access to a BAQ…that in itself seems very weird to me.  Con someone confirm, please?

 

TIA, Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
2

Has anyone experienced this before?  According to tech support I have to give access to a BAQ…that in itself seems very weird to me.  Con someone confirm, please?

 

TIA, Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
3
Can you figure out by looking at the data why the missing ones are not showing? I am still on 9.05 but we had an issue a couple months ago where one invoice did not show on our aging. Data analysis showed me that the invoice that was not showing was somehow posted without a "payment schedule" (no idea how that happened). I was able to fix the invoice with an updateable BAQ and then it showed on the aging. Since it has only happened to one invoice of ours I didn't bother reporting to tech suport.Â


4

Not sure in all honesty.  What is happening, in one company, is that we can have a check sent to us and when we look  at the aging report it is not there. Accepting the payment in the system is not an issue as far as I understand what is happening.

 

Manasa

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 12:12 PM
To: Vantage List <vantage@yahoogroups.com>
Subject: Re: [Vantage] version 10.700.3 - AR Aging does not show all invoices

 

 

Can you figure out by looking at the data why the missing ones are not showing?  I am still on 9.05 but we had an issue a couple months ago where one invoice did not show on our aging.  Data analysis showed me that the invoice that was not showing was somehow posted without a "payment schedule" (no idea how that happened).  I was able to fix the invoice with an updateable BAQ and then it showed on the aging.  Since it has only happened to one invoice of ours I didn't bother reporting to tech suport. 

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
5
I would compare the aging to a dashboard and find ones that are missing and then compare all the invoice header data to see if you can determine why it is not showing. If you can figure out why it is not showing (what piece of data is missing).

6

Scratched my head a bunch on this with 700.4.  Then noticed that there is a radio button selection for how it does aging (relative to what date to start).  If set one way it will ignore invoices before a certain date (1st of month?).  Normal USA mode is to age from the date of the invoice but other countries (I ran into this for Australia) age from the 1st of the month following the date of the invoice so don’t show those.  I can’t recall what the setting are but they are on the aging report settings screen.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] version 10.700.3 - AR Aging does not show all invoices

 

 

Has anyone experienced this before?  According to tech support I have to give access to a BAQ…that in itself seems very weird to me.  Con someone confirm, please?

 

TIA, Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

7

So upon further investigation on this, I did find two customers on an open invoice report I created that is not on the aging report.  What makes these two customers interesting is that if I go to customer tracker and go to aging there…the invoices do not exist.  But if I go to the open Invoice tab, they are there.

What would cause this out of sync business?  Is there a conversion to run?

M

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

Scratched my head a bunch on this with 700.4.  Then noticed that there is a radio button selection for how it does aging (relative to what date to start).  If set one way it will ignore invoices before a certain date (1st of month?).  Normal USA mode is to age from the date of the invoice but other countries (I ran into this for Australia) age from the 1st of the month following the date of the invoice so don’t show those.  I can’t recall what the setting are but they are on the aging report settings screen.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] version 10.700.3 - AR Aging does not show all invoices

 

 

Has anyone experienced this before?  According to tech support I have to give access to a BAQ…that in itself seems very weird to me.  Con someone confirm, please?

 

TIA, Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.
8

I have seen a similar issue happen in our environment.  I believe it happens when there are problems posting a group of invoices (timeout or deadlocking).  The system leaves the invoices in the system as unposted but removes the invoice group so there is no way through the client to retrieve them.  If they are in the same group and unposted, you could create an invoice group (Erp.InvcGrp) in SQL with the appropriate field information filled in.  When you open the group in Epicor, if they are unposted, you can delete or post the invoices from the group. 


HTH,

Tanner

9

Do a BAQ and look at the invcHead table and look at one   of the invoices not showing up and look at the fields PayDates,Payamounts and DocPayAmounts. You might find you’re missing data in one of those fields which the report uses to display data. For example, you might have  2 paydates but 3 payamounts which are separated by a ~.  When I went live with E10 I had about 5 invoices that didn’t show up and it was because of this.

 

Below is a sample of a correctly formatted records..

 

http://1drv.ms/1LQEDtd

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

So upon further investigation on this, I did find two customers on an open invoice report I created that is not on the aging report.  What makes these two customers interesting is that if I go to customer tracker and go to aging there…the invoices do not exist.  But if I go to the open Invoice tab, they are there.

What would cause this out of sync business?  Is there a conversion to run?

M

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 12:27 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: version 10.700.3 - AR Aging does not show all invoices

 

 

Scratched my head a bunch on this with 700.4.  Then noticed that there is a radio button selection for how it does aging (relative to what date to start).  If set one way it will ignore invoices before a certain date (1st of month?).  Normal USA mode is to age from the date of the invoice but other countries (I ran into this for Australia) age from the 1st of the month following the date of the invoice so don’t show those.  I can’t recall what the setting are but they are on the aging report settings screen.

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 27, 2015 11:04 AM
To: vantage@yahoogroups.com
Subject: [Vantage] version 10.700.3 - AR Aging does not show all invoices

 

 

Has anyone experienced this before?  According to tech support I have to give access to a BAQ…that in itself seems very weird to me.  Con someone confirm, please?

 

TIA, Manasa

 

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.

IMPORTANT NOTICE FROM API: This communication, including any attachments, contains information that may be confidential or privileged and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, please contact the sender immediately and delete this message. Any unauthorized disclosure, copying or distribution of this message is strictly prohibited.