Epicor 9 Sorting Invoices on Check Stubs?

Yahoo Archive
1
Sorting the xml out of Epicor would be more than a pain in the butt... I would maybe look up the chain of command a bit and see if you can sort it in the RDD before attempting anything like reordering the xml

reply Signature




Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "kurt_hilborn" <khilborn@...>
To: vantage@yahoogroups.com
Sent: Tuesday, March 19, 2013 7:01:33 AM
Subject: [Vantage] Re: Epicor 9 Sorting Invoices on Check Stubs??



Unfortunately we don't use CR to print our checks. We use Binatek Interlazer 6 so the sorting has to be done in the XML that Epicor puts out. I checked with Binatek and there are not any resorting options in their templates.

--- In vantage@yahoogroups.com , Calvin Dekker <calvind@...> wrote:
>
> Kurt -
>
> You could add sorting in Crystal Reports.
>
> Thank you in advance,
> Calvin Dekker
> Office: 630-672-7688 Ext. 1484
> Email: calvin@...<mailto:calvin@...>
> http://www.codabears.com http://www.codabears.com/ >
> [cid:image001.jpg@...]< http://www.codabears.com/ >
>
> Solutions for Epiday living.
>
> "No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."
>
>
> From: vantage@yahoogroups.com [mailto: vantage@yahoogroups.com ] On Behalf Of kurt_hilborn
> Sent: Monday, March 18, 2013 2:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??
>
>
>
> We are running Epicor 9.05.701.
> Our Accounting dept. would like the details on the check stubs to be sorted by the Invoice number and not by the invoice amount.
> In Vantage 8 the details were sorted by invoice number.
> Does anyone know how to change the sort order?
> I've searched everywhere and can't seem to find a solution.
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
We are running Epicor 9.05.701.
Our Accounting dept. would like the details on the check stubs to be sorted by the Invoice number and not by the invoice amount.
In Vantage 8 the details were sorted by invoice number.
Does anyone know how to change the sort order?
I've searched everywhere and can't seem to find a solution.
3
My solution eventually was I started from scratch. I ended up creating a sub report and positioning it so that it overlayed on our checks just right. Took a collective 20 hours of tinkering, but only because our checks have duplicate stubs. Would have been a lot easier on a single stub check.

reply Signature




Joshua Giese

CTO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

----- Original Message -----

From: "kurt_hilborn" <khilborn@...>
To: vantage@yahoogroups.com
Sent: Monday, March 18, 2013 2:52:18 PM
Subject: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??



We are running Epicor 9.05.701.
Our Accounting dept. would like the details on the check stubs to be sorted by the Invoice number and not by the invoice amount.
In Vantage 8 the details were sorted by invoice number.
Does anyone know how to change the sort order?
I've searched everywhere and can't seem to find a solution.





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

You could add sorting in Crystal Reports.

Thank you in advance,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@...<mailto:calvin@...>
http://www.codabears.com<http://www.codabears.com/>
[cid:image001.jpg@01CE23E9.75BCC260]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kurt_hilborn
Sent: Monday, March 18, 2013 2:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??



We are running Epicor 9.05.701.
Our Accounting dept. would like the details on the check stubs to be sorted by the Invoice number and not by the invoice amount.
In Vantage 8 the details were sorted by invoice number.
Does anyone know how to change the sort order?
I've searched everywhere and can't seem to find a solution.



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

When did they let you back in the door?? ;-)

Darren Mann - Purchasing/IT Mgr
Miller Products Co.
1015 N. Main St.
Osceola, IA 50213
641.342.2103


________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Dekker
Sent: Monday, March 18, 2013 3:01 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??




Kurt -

You could add sorting in Crystal Reports.

Thank you in advance,
Calvin Dekker
Office: 630-672-7688 Ext. 1484
Email: calvin@... <mailto:calvin%40codabears.com>
<mailto:calvin@... <mailto:calvin%40codabears.com> >
http://www.codabears.comhttp://www.codabears.com/>
[cid:image001.jpg@01CE23E9.75BCC260
<mailto:image001.jpg%4001CE23E9.75BCC260> ]<http://www.codabears.com/>

Solutions for Epiday living.

"No trees were harmed during the sending of this message, however a
large number of electrons were terribly inconvenienced."

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of kurt_hilborn
Sent: Monday, March 18, 2013 2:52 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??

We are running Epicor 9.05.701.
Our Accounting dept. would like the details on the check stubs to be
sorted by the Invoice number and not by the invoice amount.
In Vantage 8 the details were sorted by invoice number.
Does anyone know how to change the sort order?
I've searched everywhere and can't seem to find a solution.

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






[Non-text portions of this message have been removed]
6
Unfortunately we don't use CR to print our checks. We use Binatek Interlazer 6 so the sorting has to be done in the XML that Epicor puts out. I checked with Binatek and there are not any resorting options in their templates.


--- In vantage@yahoogroups.com, Calvin Dekker <calvind@...> wrote:
>
> Kurt -
>
> You could add sorting in Crystal Reports.
>
> Thank you in advance,
> Calvin Dekker
> Office: 630-672-7688 Ext. 1484
> Email: calvin@...<mailto:calvin@...>
> http://www.codabears.com<http://www.codabears.com/>
> [cid:image001.jpg@...]<http://www.codabears.com/>
>
> Solutions for Epiday living.
>
> "No trees were harmed during the sending of this message, however a large number of electrons were terribly inconvenienced."
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of kurt_hilborn
> Sent: Monday, March 18, 2013 2:52 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Epicor 9 Sorting Invoices on Check Stubs??
>
>
>
> We are running Epicor 9.05.701.
> Our Accounting dept. would like the details on the check stubs to be sorted by the Invoice number and not by the invoice amount.
> In Vantage 8 the details were sorted by invoice number.
> Does anyone know how to change the sort order?
> I've searched everywhere and can't seem to find a solution.
>
>
>
> [Non-text portions of this message have been removed]
>