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:
[email protected]]
> Risposta a:
[email protected]
> Inviato: venerdi 27 ottobre 2000 6.23
> A:
[email protected]
> 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 <
[email protected]> on 10/26/2000 06:51:12 PM
>
> Please respond to
[email protected]
>
> To:
[email protected]
> 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.
>
> ---
[email protected] 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:
[email protected]]
Risposta a:
[email protected]
Inviato: venerdi 27 ottobre
2000 6.23
A:
[email protected]
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 <
[email protected]> on 10/26/2000 06:51:12 PM
Please respond to
[email protected]
To:
[email protected]
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.
---
[email protected] 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--