6.1 PO form in CR

Yahoo Archive
1
Dale,

That would be the Pub_PORel progress db table that Carl is talking about.



________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: Dale Norris [mailto:dnorris@...]
Sent: Tuesday, August 16, 2005 4:28 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] 6.1 PO form in CR

Is the POrel table you speak of the DBF work file typically located at
c:\epicor\mfgwrk60 or the Progress table?

Just curious.

Dale

>>> carl.heeder@... 8/16/2005 3:12 PM >>>

We are on 6.0 and the PORel table includes ExpDivision, ExpGLDept, ExpChart.


Jim is right that you set the format of the account in the Company
configuration but you should be able to add these fields to the PO in any
order you want if you can get to the PO form.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"tmsover" <dnorris@...>
Sent by: vantage@yahoogroups.com
08/16/2005 12:37 PM
Please respond to
vantage@yahoogroups.com


To
vantage@yahoogroups.com
cc

Subject
[Vantage] 6.1 PO form in CR






Folks:

I have a request from our controller to add the GL account number to
each line item on a PO. In CR I can see the POrel.dbf file contains
the POrel.expchart and POrel.expgldept but it doesn't have the
division.

Is there a way to construct a GL account with the format {chart}-
{div}-dept (example: 7654-04-1000)?

I have tried subforms but have failed to isolate the POnum because in
the Progress table POrel it is a number and in the work file
POrel.dbf it is a string.

Any help would be appreciated?

Thanks,

Dale Norris
IS Manager
Bullen Ultrasonics




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



SPONSORED LINKS
Technical support
Vantage
Database
Database management software
Membership database software
Church database software

YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[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












[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







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

I have a request from our controller to add the GL account number to
each line item on a PO. In CR I can see the POrel.dbf file contains
the POrel.expchart and POrel.expgldept but it doesn't have the
division.

Is there a way to construct a GL account with the format {chart}-
{div}-dept (example: 7654-04-1000)?

I have tried subforms but have failed to isolate the POnum because in
the Progress table POrel it is a number and in the work file
POrel.dbf it is a string.

Any help would be appreciated?

Thanks,

Dale Norris
IS Manager
Bullen Ultrasonics
3
Dale,

You can pick up the account information you need from the PartClass table if
you have all your parts assigned the accounts by part class.

Otherwise...
There's only one way to restructure your G/L Accounts to the format
Chart-Div-Dept, where you can set the length and whether or not they are
Alpha type fields...
and as far as I know, this can only be done in the company's "Basic
Configuration" under the "Company Maintenance," "Module Configuration," "All
Modules" section prior to entering them into your master chart.

Once you've entered your account numbers in the master chart of accounts,
there is no changing them.


Best regards,
JK

________________________
Jim Kennedy
Manager, Information Technologies
Firstmark Aerospace
921 Holloway St.
Durham, North Carolina 27701
Office: (919) 956-4264
FAX: (919) 682-3786
Cell: (919) 697-9410
jkennedy@...
www.firstmarkaerospace.com
www.firstmarkcorp.com

-----Original Message-----
From: tmsover [mailto:dnorris@...]
Sent: Tuesday, August 16, 2005 1:37 PM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.1 PO form in CR

Folks:

I have a request from our controller to add the GL account number to each
line item on a PO. In CR I can see the POrel.dbf file contains the
POrel.expchart and POrel.expgldept but it doesn't have the division.

Is there a way to construct a GL account with the format {chart}- {div}-dept
(example: 7654-04-1000)?

I have tried subforms but have failed to isolate the POnum because in the
Progress table POrel it is a number and in the work file POrel.dbf it is a
string.

Any help would be appreciated?

Thanks,

Dale Norris
IS Manager
Bullen Ultrasonics




------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hir5a5c/M=362131.6882499.7825260.1510227
/D=groups/S=1705007183:TM/Y=YAHOO/EXP=1124221144/A=2889191/R=0/SIG=10r90krvo
/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
-Â brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->

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








[Non-text portions of this message have been removed]
4
We are on 6.0 and the PORel table includes ExpDivision, ExpGLDept,
ExpChart.


Jim is right that you set the format of the account in the Company
configuration but you should be able to add these fields to the PO in any
order you want if you can get to the PO form.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"tmsover" <dnorris@...>
Sent by: vantage@yahoogroups.com
08/16/2005 12:37 PM
Please respond to
vantage@yahoogroups.com


To
vantage@yahoogroups.com
cc

Subject
[Vantage] 6.1 PO form in CR






Folks:

I have a request from our controller to add the GL account number to
each line item on a PO. In CR I can see the POrel.dbf file contains
the POrel.expchart and POrel.expgldept but it doesn't have the
division.

Is there a way to construct a GL account with the format {chart}-
{div}-dept (example: 7654-04-1000)?

I have tried subforms but have failed to isolate the POnum because in
the Progress table POrel it is a number and in the work file
POrel.dbf it is a string.

Any help would be appreciated?

Thanks,

Dale Norris
IS Manager
Bullen Ultrasonics




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



SPONSORED LINKS
Technical support
Vantage
Database
Database management software
Membership database software
Church database software

YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]
5
Is the POrel table you speak of the DBF work file typically located at c:\epicor\mfgwrk60 or the Progress table?

Just curious.

Dale

>>> carl.heeder@... 8/16/2005 3:12 PM >>>

We are on 6.0 and the PORel table includes ExpDivision, ExpGLDept,
ExpChart.


Jim is right that you set the format of the account in the Company
configuration but you should be able to add these fields to the PO in any
order you want if you can get to the PO form.


Carl Heeder
ST Inverter America
281-506-3146
Mobile: 281-221-3421
FAX 978-725-3057



"tmsover" <dnorris@...>
Sent by: vantage@yahoogroups.com
08/16/2005 12:37 PM
Please respond to
vantage@yahoogroups.com


To
vantage@yahoogroups.com
cc

Subject
[Vantage] 6.1 PO form in CR






Folks:

I have a request from our controller to add the GL account number to
each line item on a PO. In CR I can see the POrel.dbf file contains
the POrel.expchart and POrel.expgldept but it doesn't have the
division.

Is there a way to construct a GL account with the format {chart}-
{div}-dept (example: 7654-04-1000)?

I have tried subforms but have failed to isolate the POnum because in
the Progress table POrel it is a number and in the work file
POrel.dbf it is a string.

Any help would be appreciated?

Thanks,

Dale Norris
IS Manager
Bullen Ultrasonics




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



SPONSORED LINKS
Technical support
Vantage
Database
Database management software
Membership database software
Church database software

YAHOO! GROUPS LINKS

Visit your group "vantage" on the web.

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[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












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