Subject: [6.1] Sales Budget in Vantage vs. Showing in FRx

Hello Todd,

Sorry, in my previous email I suggested changing the column
specification, but that may not work either, unless the expenses were
entered in the reverse sign.

I think the best solution would be to reverse the original budget entry
and redo it using the correct debits and credits. That way the actual
and budget would both have the same sign.

Regards,
Linda Lowney
Decoustics Limited


----Original Message ----
From: "Todd Caughey" caugheyt@...
Date: Tue May 30, 2006 7:26am(PDT)
Subject: Re: Subject: [6.1] Sales Budget in Vantage vs. Showing in FRx

OK, my boss finally was able look at the suggestion below but his
reponse was:
...."Already done that. This will then change actual sales."

The issue I guess is that in his FRx report he is comparing Actual Sales
to Budgeted Sales and the "signs" don't agree between them - so
revesring one breaks the other. Perhaps his approach to this "Budget
vs. Actual" report is not right - he is still learning FRx. Any
suggestions would be appreciated.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lowney, Linda
Sent: Tuesday, May 23, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in
FRx


Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
Thanks! I will forward to my boss.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Lowney, Linda
Sent: Tuesday, May 23, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in FRx


Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



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
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
OK, my boss finally was able look at the suggestion below but his reponse was:
...."Already done that. This will then change actual sales."

The issue I guess is that in his FRx report he is comparing Actual Sales to Budgeted Sales and the "signs" don't agree between them - so revesring one breaks the other. Perhaps his approach to this "Budget vs. Actual" report is not right - he is still learning FRx. Any suggestions would be appreciated.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Lowney, Linda
Sent: Tuesday, May 23, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in FRx


Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.



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
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
Hi Todd,

Ok, I guess I did not understand that the Budget was entered with a
different sign.

You could try modifying the column specification for the report.
Assuming that you now have the budget in column F:

In column F - go down to the print control and change it to NP so that
it won't print
Insert a new column to the right of column F - this will become column G
For Type GL Calc Etc - select CALC
For Calc Formula - enter F * -1 to reverse the sign
Modify the column width, format mask etc the same as you had in column F

Hth
Linda Lowney


--------------------
From: "Todd Caughey" caugheyt@...
Date: Tue May 30, 2006 7:26am(PDT)
Subject: Re:
OK, my boss finally was able look at the suggestion below but his
reponse was:
...."Already done that. This will then change actual sales."

The issue I guess is that in his FRx report he is comparing Actual Sales
to Budgeted Sales and the "signs" don't agree between them - so
revesring one breaks the other. Perhaps his approach to this "Budget
vs. Actual" report is not right - he is still learning FRx. Any
suggestions would be appreciated.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lowney, Linda
Sent: Tuesday, May 23, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in
FRx


Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
Actually the budget is entered the same way (as credit) as the sales is. This is the confusing part. In Vantage they are both credit fields but FRx is seeing the budget figure as debit. I have linked Access to the dbo_frl_per_bal table and see the values there are ALL positive but there are seperate columns for am_nat_cr and am_nat_dr. Most of the rows for the account codes in questions (for sales) have the larger numbers in the am_nat_cr column - as we would exepct - for BOTH Actual and Budget book_code.

I had suggested your -1 CALC column technique to him a li ttle while ago but he wanted to get to the bottom of what is changing the cr values to dr for "budget" only. But for now it appears the export process is working OK and the issue is somewhere in FRx (or our understanding of FRx anyway).

Thanks for the help.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Lowney, Linda
Sent: Tuesday, May 30, 2006 3:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in FRx


Hi Todd,

Ok, I guess I did not understand that the Budget was entered with a
different sign.

You could try modifying the column specification for the report.
Assuming that you now have the budget in column F:

In column F - go down to the print control and change it to NP so that
it won't print
Insert a new column to the right of column F - this will become column G
For Type GL Calc Etc - select CALC
For Calc Formula - enter F * -1 to reverse the sign
Modify the column width, format mask etc the same as you had in column F

Hth
Linda Lowney


--------------------
From: "Todd Caughey" caugheyt@...
Date: Tue May 30, 2006 7:26am(PDT)
Subject: Re:
OK, my boss finally was able look at the suggestion below but his
reponse was:
...."Already done that. This will then change actual sales."

The issue I guess is that in his FRx report he is comparing Actual Sales
to Budgeted Sales and the "signs" don't agree between them - so
revesring one breaks the other. Perhaps his approach to this "Budget
vs. Actual" report is not right - he is still learning FRx. Any
suggestions would be appreciated.

-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Lowney, Linda
Sent: Tuesday, May 23, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Subject: [6.1] Sales Budget in Vantage vs. Showing in
FRx


Hello Todd,

Look at the value in the "Norm Bal" column of the row format. If it is
"C" it will reverse the sign, if it is blank then it won't.

Regards,
Linda Lowney
Decoustics Limited

--------------------
Original Messsage:

My boss has asked me to relay a question. He has entered budget amounts
for the first time in Vantage. For sales he has entered them as credit
amounts. But when transfered to FRx they show as negative values and
due to the column configurations he can't just multiply by -1. The
actual sales are reported as postive.

If anyone is reporting budget amounts via FRx how did you enter the
sales budget in Vantage and how do you get it to report correctly via
FRx?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.


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
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]