Cash forecast generation
This process creates, from any Sage X3 document, the forecast of treasury movements that all these documents will generate in the future. For instance, a sales order does not involve directly a treasury movement, but you can estimate that, when it is delivered and invoiced, it will generate a treasury movement. This process makes the estimation of the future treasury movements.
The documents that are treated are the following:
PURCHASES
Purchase requests, Purchase orders, Purchase contracts, Receipt notes
SALES
Quotes, Sales orders, Sales contracts, Delivery notes
OTHERS
CRM contracts, Leasing
The existent open items from invoices already created in Sage X3 are always treated.
The process is launched by company, until a determinate date, and selecting the documents to treat. The process calculates in each selected document the future open items that they will generate and it creates the corresponding cash forecast. The real open items are always treated and they also generate cash forecast. Below, you can see the calculations done for each document type.
Every time that the process is launched, the previous cash forecasts are deleted and they are calculated again. Therefore, you always have a current image of the forecast taking into account all the Sage X3 documents (the calculated amounts are always with taxes included).
At the end of the process, a log file details the treated documents and the summary with the totals of the generated Cash forecast by each type.
Prerequisites
Refer to documentation Implementation
Screen management
Entry screen
Presentation
On this screen, you enter the launching parameters to generate the cash forecast from Sage X3 documents. The checkboxes in the blocks Purchasing, Sales and Others are used to select the different kinds of Sage X3 documents to be treated in the process. It is possible to select the kinds of documents valid according to the setup of cash forecast types by company/site (in the Cash forecast types / company function). That is, if for a company/site a document type is not active, it is not possible to select it in the process. The process suggests, by default, all the possible Sage X3 documents selected. The real open items from Sage X3 are always treated by the process. Therefore, there is no specific checkbox to select them.
Close
Fields
The following fields are present on this tab :
Criteria
|
|
|
|
|
|
Purchasing
|
|
|
|
|
|
|
|
Sales
|
|
|
|
|
|
|
|
Others
|
|
|
|
Options
|
|
|
|
|
|
Close
Batch task
This function can be run in batch mode. The standard task FUNTRTCFO is provided for that purpose.
Error messages
In addition to the generic error messages, the following messages can appear during the entry :
Operation in progress on another workstation
Another user is executing the process for the same company.
XXXXX: Unauthorized module
The module is not active in the working folder.
The cash forecast type is not valid for this company/site XXX
During the execution of the process, a Sage X3 document has been treated and the cash forecast type of the document is not authorized on the financial site of the document (see the Cash forecast types / company function).
Treatment by X3 document
In general, an X3 document must meet the following conditions in order to be taken into account by the process:
- The document module must be active in the working folder.
- The document date is between the first day of the analysis period (that is to say, the date process minus the indicated days in the setup of the forecast type) and the end date of the process.
- The cash forecast type setup exists and it is active for the company / financial site of the document (see the Cash forecast types / company function).
- The business partner is authorized for the cash forecast management.
- The assigned bank is authorized for the cash forecast management.
The forecast date is always equal or upper than the day of the process. The cash forecast is assigned to the payer business partner.
| Purchase request | - It is signed | [F:PSD]EXTRCPDAT + INCRE | [F:PSD]LINATIAMT*[F:PSD]QTYPUU | According the supplier |
| Purchase orders | - It is not a open order | [F:POQ]EXTRCPDAT + INCRE | [F:POP]NETPRI*([F:POQ]QTYPUU-[F:POQ]RCPQTYPUU) | According the document |
| Purchase contract | - It is a open order | [F:POQ]DEMRCPDAT + INCRE | [F:POP]NETPRI*([F:POQ]QTYPUU-[F:POQ]RCPQTYPUU) | According the document |
| Receipts notes | - It is not invoiced | [F:PTH]RCPDAT + INCRE | [F:PTD]NETPRI*([F:PTD]QTYPUU-[F:PTD]INVQTYPUU-[F:PTD]RTNQTYPUU) | According the supplier |
INICRE is the value of the Increment field in the definition of the cash forecast types by company.
| Quotes | - It is not ordered | date$ + [F:SQH]DAYLTI + delay in payments | [F:SQD]NETPRIATI*([F:SQD]QTY-[F:SQD]ORDQTY) | According the document |
| Sales orders | - It is not a open order | [F:SOQ]SHIDAT + delay in payments | [F:SOP]NETPRIATI*([F:SOQ]QTY-[F:SOQ]DLVQTY) | According the document |
| Sales contracts | - It is a open order | [F:SOQ]DEMDLVDAT + delay in payments | [F:SOP]NETPRIATI*([F:SOQ]QTY-[F:SOQ]DLVQTY) | According the document |
| Delivery notes | - It is not for subcontract | [F:SDH]SHIDAT + delay in payments | [F:SDH]DLVINVATI | According the document |
The foreseen invoicing date is modified until the first invoicing day, according to the setup of the cash forecast type.
| CRM contracts | - Next invoicing date < End date of the process | [F:CON]NEXINVDAT | [F:CON]NEXINVAMT | According the document |
| Leasing | - Status: in process | [F:LBB]ENDPERDAT | [F:LBB]RNTAMT | According the supplier |
| Open items | - It is not closed | [F:DUD]DUDDAT | [F:DUD]AMTCUR | Payment method: [F:DUD]PAM |