• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Re: Budget for Sales

Re: Budget for Sales

Another option is to enter a sales forecast as type SB and
compare that to actual sales. I've done this and used MS Access
to write some convoluted sales analysis reports. The good thing
about Access is the Union query which means that you can get a
complete customer/item list (ie some will have sales no forecast
and vice versa, without this you will get incomplete data.


--- CCHEUNG@pillsbury.com wrote:
>
>
> Is there a way to input a budget for sales details?
>
> Our users want to compare the Actual Sales against Budget
> Sales on item level
> and customer level by month. We do not want to do it in
> General Ledger. One
> possible way we are investigating is to setup a sales order
> type , say SB and we
> can compare the actual results against this order type.
>
>
> At the moment, we are using Finance Module +
> Sales+Inventory+PO only.
>
>
> Any help.
>
>
> Rgds
>
>
>
>
______________________________________________________________________
> The information contained in this message is private and
> confidential
> information which may also be subject to the attorney-client
> privilege and work
> product doctrine. This information is intended only for the
> individual or
> entity named above. If the reader of this message is not the
> intended
> recipient, you are hereby notified that any use,
> dissemination, distribution or
> copy of this message is strictly prohibited. If you have
> received this message
> in error, please notify the sender by return e-mail and
> destroy all copies of
> the message. Thank you.
>
>
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/
 

CCHEUNG

Member
Re: Budget for Sales

Where can we input the sales forecast? Is it a different prog than Normal Sales
Order Prog?


Rgds




keith_sherman <keith_sherman@yahoo.com> on 10/26/2000 06:51:12 PM

Please respond to jdeworld@jdelist.com

To: jdeworldml@jdelist.com
cc: (bcc: Chi Yu Cheung/CHN/Pillsbury)
Subject: Re: Budget for Sales ~~0:153




Another option is to enter a sales forecast as type SB and
compare that to actual sales. I've done this and used MS Access
to write some convoluted sales analysis reports. The good thing
about Access is the Union query which means that you can get a
complete customer/item list (ie some will have sales no forecast
and vice versa, without this you will get incomplete data.


--- CCHEUNG@pillsbury.com wrote:
>
>
> Is there a way to input a budget for sales details?
>
> Our users want to compare the Actual Sales against Budget
> Sales on item level
> and customer level by month. We do not want to do it in
> General Ledger. One
> possible way we are investigating is to setup a sales order
> type , say SB and we
> can compare the actual results against this order type.
>
>
> At the moment, we are using Finance Module +
> Sales+Inventory+PO only.
>
>
> Any help.
>
>
> Rgds
>
>
>
>
______________________________________________________________________
> The information contained in this message is private and
> confidential
> information which may also be subject to the attorney-client
> privilege and work
> product doctrine. This information is intended only for the
> individual or
> entity named above. If the reader of this message is not the
> intended
> recipient, you are hereby notified that any use,
> dissemination, distribution or
> copy of this message is strictly prohibited. If you have
> received this message
> in error, please notify the sender by return e-mail and
> destroy all copies of
> the message. Thank you.
>
>
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=153
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************









______________________________________________________________________
The information contained in this message is private and confidential
information which may also be subject to the attorney-client privilege and work
product doctrine. This information is intended only for the individual or
entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any use, dissemination, distribution or
copy of this message is strictly prohibited. If you have received this message
in error, please notify the sender by return e-mail and destroy all copies of
the message. Thank you.
 

zuccoa

Active Member
R:Budget for Sales

May be I'm missing the meaning of the question but why not to use the
"Sales Forecast Entry" (J3460 - F3460) ?

Also consider that using this function you can enter more than one
"Forecast Type"; the default one is usually "BF" (Best Fit) and is
usually the one processed by the MRP/MPS planning calculations (if you use
them), but you can also enter additional ones (we created the "Forecast
Type" BU which stands for Budget) since it is just a UDC.

As you can see from the program screen and/or the file layout you could
enter informations by Product/Month/Customer and, later, refer to them to
run your comparisons.

Hope this helps

TUBILUX PHARMA SPA
IS Manager
Andrea Zucconi

----------
Da: CCHEUNG[SMTP:CCHEUNG@pillsbury.com]
Risposta a: jdeworld@jdelist.com
Inviato: venerdi 27 ottobre 2000 6.23
A: jdeworldml@jdelist.com
Oggetto: Re: Budget for Sales ~~153:180



Where can we input the sales forecast? Is it a different prog than Normal
Sales
Order Prog?


Rgds




keith_sherman <keith_sherman@yahoo.com> on 10/26/2000 06:51:12 PM

Please respond to jdeworld@jdelist.com

To: jdeworldml@jdelist.com
cc: (bcc: Chi Yu Cheung/CHN/Pillsbury)
Subject: Re: Budget for Sales ~~0:153




Another option is to enter a sales forecast as type SB and
compare that to actual sales. I've done this and used MS Access
to write some convoluted sales analysis reports. The good thing
about Access is the Union query which means that you can get a
complete customer/item list (ie some will have sales no forecast
and vice versa, without this you will get incomplete data.


--- CCHEUNG@pillsbury.com wrote:
>
>
> Is there a way to input a budget for sales details?
>
> Our users want to compare the Actual Sales against Budget
> Sales on item level
> and customer level by month. We do not want to do it in
> General Ledger. One
> possible way we are investigating is to setup a sales order
> type , say SB and we
> can compare the actual results against this order type.
>
>
> At the moment, we are using Finance Module +
> Sales+Inventory+PO only.
>
>
> Any help.
>
>
> Rgds
>
>
>
>
______________________________________________________________________
> The information contained in this message is private and
> confidential
> information which may also be subject to the attorney-client
> privilege and work
> product doctrine. This information is intended only for the
> individual or
> entity named above. If the reader of this message is not the
> intended
> recipient, you are hereby notified that any use,
> dissemination, distribution or
> copy of this message is strictly prohibited. If you have
> received this message
> in error, please notify the sender by return e-mail and
> destroy all copies of
> the message. Thank you.
>
>
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/




--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb
er=153
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************









______________________________________________________________________
The information contained in this message is private and confidential
information which may also be subject to the attorney-client privilege and
work
product doctrine. This information is intended only for the individual or
entity named above. If the reader of this message is not the intended
recipient, you are hereby notified that any use, dissemination,
distribution or
copy of this message is strictly prohibited. If you have received this
message
in error, please notify the sender by return e-mail and destroy all copies
of
the message. Thank you.





--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb
er=180
*************************************************************
This is the JDEList World Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at http://www.JDELIST.com
*************************************************************
 
RE: Budget for Sales

------ =_NextPart_000_01C03FF9.B57ABBA0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Joe,

This one is in Italy,
Maybe this is the install you should do with me !!

Richard
 
Re: Budget for Sales

The program is P3460, you will find it on a number of menus.
G3412 is one. Just as for budgets in the GL you can have as many
as you like (up to 1396). The entry screen captures quantity
and value. By writing a report over the F3460 file you can
prove it back to the GL budget, or more likely to set the GL
budget. In the sales analysis you then start off with extracts
from the f3460 and f4211 and compare these based on
customer/item joins.




--- CCHEUNG <CCHEUNG@pillsbury.com> wrote:
>
>
> Where can we input the sales forecast? Is it a different prog
> than Normal Sales
> Order Prog?
>
>
> Rgds
>
>
>
>
> keith_sherman <keith_sherman@yahoo.com> on 10/26/2000 06:51:12
> PM
>
> Please respond to jdeworld@jdelist.com
>
> To: jdeworldml@jdelist.com
> cc: (bcc: Chi Yu Cheung/CHN/Pillsbury)
> Subject: Re: Budget for Sales ~~0:153
>
>
>
>
> Another option is to enter a sales forecast as type SB and
> compare that to actual sales. I've done this and used MS
> Access
> to write some convoluted sales analysis reports. The good
> thing
> about Access is the Union query which means that you can get a
> complete customer/item list (ie some will have sales no
> forecast
> and vice versa, without this you will get incomplete data.
>
>
> --- CCHEUNG@pillsbury.com wrote:
> >
> >
> > Is there a way to input a budget for sales details?
> >
> > Our users want to compare the Actual Sales against Budget
> > Sales on item level
> > and customer level by month. We do not want to do it in
> > General Ledger. One
> > possible way we are investigating is to setup a sales order
> > type , say SB and we
> > can compare the actual results against this order type.
> >
> >
> > At the moment, we are using Finance Module +
> > Sales+Inventory+PO only.
> >
> >
> > Any help.
> >
> >
> > Rgds
> >
> >
> >
> >
>
<P ID="edit"><FONT SIZE=-1>Edited by ekempter on 10/27/00 08:18 AM.</FONT></P>
 

mackip

Member
Re: R:Budget for Sales

--------------4D3F2495025880A57D49662D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi List:

We use the forecast file to enter sales quantities business unit. We then run an
inhouse created program that turns them into "EDI" orders in the F47* files.
After that we process them through the system like real sales orders to get proper
accounting and pricing (we use advanced pricing). The GL generated from the sales
orders is merged with the budgets each department has entered directly into the
"BU" ledger to get a full budget for the following year. FASTR reports are then
run over the combined Budget GL. All this is done in an alternate environment
from production.

Rgds,

Pam MacKinnon

zuccoa wrote:

> May be I'm missing the meaning of the question but why not to use the
> "Sales Forecast Entry" (J3460 - F3460) ?
>
> Also consider that using this function you can enter more than one
> "Forecast Type"; the default one is usually "BF" (Best Fit) and is
> usually the one processed by the MRP/MPS planning calculations (if you use
> them), but you can also enter additional ones (we created the "Forecast
> Type" BU which stands for Budget) since it is just a UDC.
>
> As you can see from the program screen and/or the file layout you could
> enter informations by Product/Month/Customer and, later, refer to them to
> run your comparisons.
>
> Hope this helps
>
> TUBILUX PHARMA SPA
> IS Manager
> Andrea Zucconi
>
> ----------
> Da: CCHEUNG[SMTP:CCHEUNG@pillsbury.com]
> Risposta a: jdeworld@jdelist.com
> Inviato: venerdi 27 ottobre 2000 6.23
> A: jdeworldml@jdelist.com
> Oggetto: Re: Budget for Sales ~~153:180
>
> Where can we input the sales forecast? Is it a different prog than Normal
> Sales
> Order Prog?
>
> Rgds
>
> keith_sherman <keith_sherman@yahoo.com> on 10/26/2000 06:51:12 PM
>
> Please respond to jdeworld@jdelist.com
>
> To: jdeworldml@jdelist.com
> cc: (bcc: Chi Yu Cheung/CHN/Pillsbury)
> Subject: Re: Budget for Sales ~~0:153
>
> Another option is to enter a sales forecast as type SB and
> compare that to actual sales. I've done this and used MS Access
> to write some convoluted sales analysis reports. The good thing
> about Access is the Union query which means that you can get a
> complete customer/item list (ie some will have sales no forecast
> and vice versa, without this you will get incomplete data.
>
> --- CCHEUNG@pillsbury.com wrote:
> >
> >
> > Is there a way to input a budget for sales details?
> >
> > Our users want to compare the Actual Sales against Budget
> > Sales on item level
> > and customer level by month. We do not want to do it in
> > General Ledger. One
> > possible way we are investigating is to setup a sales order
> > type , say SB and we
> > can compare the actual results against this order type.
> >
> >
> > At the moment, we are using Finance Module +
> > Sales+Inventory+PO only.
> >
> >
> > Any help.
> >
> >
> > Rgds
> >
> >
> >
> >
> ______________________________________________________________________
> > The information contained in this message is private and
> > confidential
> > information which may also be subject to the attorney-client
> > privilege and work
> > product doctrine. This information is intended only for the
> > individual or
> > entity named above. If the reader of this message is not the
> > intended
> > recipient, you are hereby notified that any use,
> > dissemination, distribution or
> > copy of this message is strictly prohibited. If you have
> > received this message
> > in error, please notify the sender by return e-mail and
> > destroy all copies of
> > the message. Thank you.
> >
> >
> > *************************************************************
> > This is the JDEList World Mailing List.
> > Archives and information on how to SUBSCRIBE, and
> > UNSUBSCRIBE can be found at http://www.JDELIST.com
> > *************************************************************
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb
> er=153
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
> ______________________________________________________________________
> The information contained in this message is private and confidential
> information which may also be subject to the attorney-client privilege and
> work
> product doctrine. This information is intended only for the individual or
> entity named above. If the reader of this message is not the intended
> recipient, you are hereby notified that any use, dissemination,
> distribution or
> copy of this message is strictly prohibited. If you have received this
> message
> in error, please notify the sender by return e-mail and destroy all copies
> of
> the message. Thank you.
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb
> er=180
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=181
> *************************************************************
> This is the JDEList World Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************

--------------4D3F2495025880A57D49662D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi List:


We use the forecast file to enter sales quantities business unit.
We then run an inhouse created program that turns them into "EDI" orders
in the F47* files. After that we process them through the system
like real sales orders to get proper accounting and pricing (we use advanced
pricing). The GL generated from the sales orders is merged with the
budgets each department has entered directly into the "BU" ledger
to get a full budget for the following year. FASTR reports are then
run over the combined Budget GL. All this is done in an alternate
environment from production.


Rgds,


Pam MacKinnon


zuccoa wrote:
<blockquote TYPE=CITE>May be I'm missing the meaning of the question but
why not to use the

"Sales Forecast Entry" (J3460 - F3460) ?


Also consider that using this function you can enter more than one

"Forecast Type"; the default one is usually "BF"
(Best Fit) and is

usually the one processed by the MRP/MPS planning calculations (if
you use

them), but you can also enter additional ones (we created the "Forecast

Type" BU which stands for Budget) since it is just a UDC.


As you can see from the program screen and/or the file layout you could

enter informations by Product/Month/Customer and, later, refer to them
to

run your comparisons.


Hope this helps


TUBILUX PHARMA SPA

IS Manager

Andrea Zucconi


----------

Da: CCHEUNG[SMTP:CCHEUNG@pillsbury.com]

Risposta a: jdeworld@jdelist.com

Inviato: venerdi 27 ottobre
2000 6.23

A: jdeworldml@jdelist.com

Oggetto: Re: Budget for Sales
~~153:180


Where can we input the sales forecast? Is it a different prog than Normal

Sales

Order Prog?


Rgds


keith_sherman <keith_sherman@yahoo.com> on 10/26/2000 06:51:12 PM


Please respond to jdeworld@jdelist.com


To: jdeworldml@jdelist.com

cc: (bcc: Chi Yu Cheung/CHN/Pillsbury)

Subject: Re: Budget for Sales ~~0:153


Another option is to enter a sales forecast as type SB and

compare that to actual sales. I've done this and used MS Access

to write some convoluted sales analysis reports. The good thing

about Access is the Union query which means that you can get a

complete customer/item list (ie some will have sales no forecast

and vice versa, without this you will get incomplete data.


--- CCHEUNG@pillsbury.com wrote:

>

>

> Is there a way to input a budget for sales details?

>

> Our users want to compare the Actual Sales against Budget

> Sales on item level

> and customer level by month. We do not want to do it in

> General Ledger. One

> possible way we are investigating is to setup a sales order

> type , say SB and we

> can compare the actual results against this order type.

>

>

> At the moment, we are using Finance Module +

> Sales+Inventory+PO only.

>

>

> Any help.

>

>

> Rgds

>

>

>

>

______________________________________________________________________

> The information contained in this message is private and

> confidential

> information which may also be subject to the attorney-client

> privilege and work

> product doctrine. This information is intended only for the

> individual or

> entity named above. If the reader of this message is not the

> intended

> recipient, you are hereby notified that any use,

> dissemination, distribution or

> copy of this message is strictly prohibited. If you have

> received this message

> in error, please notify the sender by return e-mail and

> destroy all copies of

> the message. Thank you.

>

>

> *************************************************************

> This is the JDEList World Mailing List.

> Archives and information on how to SUBSCRIBE, and

> UNSUBSCRIBE can be found at http://www.JDELIST.com

> *************************************************************

>


__________________________________________________

Do You Yahoo!?

Yahoo! Messenger - Talk while you surf! It's FREE.

http://im.yahoo.com/


--------------------------

To view this thread, visit the JDEList forum at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb

er=153

*************************************************************

This is the JDEList World Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************


______________________________________________________________________

The information contained in this message is private and confidential

information which may also be subject to the attorney-client privilege
and

work

product doctrine. This information is intended only for the individual
or

entity named above. If the reader of this message is not the
intended

recipient, you are hereby notified that any use, dissemination,

distribution or

copy of this message is strictly prohibited. If you have received
this

message

in error, please notify the sender by return e-mail and destroy all
copies

of

the message. Thank you.


--------------------------

To view this thread, visit the JDEList forum at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Numb

er=180

*************************************************************

This is the JDEList World Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************


--------------------------

To view this thread, visit the JDEList forum at:

http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=W&Number=181

*************************************************************

This is the JDEList World Mailing List.

Archives and information on how to SUBSCRIBE, and

UNSUBSCRIBE can be found at http://www.JDELIST.com

*************************************************************</blockquote>
</html>

--------------4D3F2495025880A57D49662D--
 
Top