This function helps you to purchase as optimally as possible so that you can meet the demand as optimally as possible with the lowest possible number of obligations, You have the option to exclude demand from “Open” (not yet authorized) orders. Columns are added to the Requisition Worksheet which help you to understand and manage the plan that's calculated. Panel |
---|
panelIconId | atlassian-note |
---|
panelIcon | :note: |
---|
bgColor | #4C9AFF |
---|
| Part of the Wholesale365 App “Order to Cash” |
Default behaviourThe default BC behaviour regarding replenishment system “Purchase” in Business Centrals “Requisition Workheets" page has some shortcomings. It is as follows: When a Sales Order has the status Open, this means for most organizations that the Sales Order is still being processed: it is still being adjusted, refined, and so on. Only when a Sales order is "Released" is it ready to "enter" the further process. By default, the requirement qty that is entered on an Open Sales Order is immediately included in a Purchase Requistion. This is immediately reflected in the Purchase Requisition. This triggers the behaviour that the purchasing process starts too early for some/many organizations. The organization starts e.g. itself with entering into purchasing obligations, while no order has yet been received from the end customer. This is undesirable. In addition, Business Central is by default rather limited in providing an explanation of the calculation of certain needs that emerge in the Purchase Requisition. It is not always clear how this calculation is being made. It is also possible that an end user has applied certain filtering when generating the Purchase Requisition, which threatens to lead to an illogical purchase action.
Behaviour with these functions activatedConfigure using the “Wholesales 365 setup” page. Depending in the settings that are activated, the following changes are made at BC's page “Requisition worksheets” in comparison to default BC: Buttons to calculate plan are replaced by custom functions: Button "Process --> Calculate plan" is replaced with bbs button, which can be found under "Actions" Button "Special orders -> Get Sales Orders" is replaced with bbs button, which can be found under "Actions" Button "Drop Shipment -> Get Sales Orders" is replaced with bbs button, which can be found under "Actions"
An Action has been added “Move Calculated Rounded Quantity to Quantity field (selection)”, so that the Calculated Rounded Quantity can easily be copied; If configured at the setup page, "need" from certain source/state combinations is not included in the requisition lines that are populated; There is a function which copies the Sales Orders field "External document No" to the "Your reference" field. You can activate this for 2 type of Sales order Lines at the “Wholesales 365 setup”. By copying this field, your supplier can print the value of this field on their Packing List / Shipping documents. Which helps your end-customer to identify your suppliers shipment and match it with their Purchase Order. Sales orders (Special): Copy External document no Sales orders (Drop Shipment): Copy External document no
Use Vendor Calendar: There is a function to use the Vendor Calendar to calculate the expected receipt date of the Purchase Order lines, when the Purchase Order lines are created from the Purchase Proposal. For this, the calendar code as recorded on the Vendor card is used. In this way, a more realistic expected receipt date of the Purchase Order lines is calculated. More information about this function later in this article.
Safety stock requirement on work date: Safety stock requirement is created by BC by default with the earliest date you enter on the purchase requisition , which means that the replenishment order (e.g. a Purchase order) is created in the past. When this option is activated, safety stock requirement is always set to the work date at the earliest.
Additional featuresFact box “Item details - stock” is added to the Purchase requisition lines. This fact box contains data that support the understanding of the structure of the purchase requisition lines. The data in this fact box comes partly from the item card (where available) and partly from the possible underlying SKU of the selected item. This fact box contains fields like "Qty on Purch Order, Qty on Sales Order, etc" Columns are added to the Requisition worksheet to help understand calculations better BBS Calc. Quantity (zoomable): this shows the calculated quantity that should have been suggested when no filters should have been applied (example: date filters) “Calculated rounded quantity” (zoomable), which takes into account minimum purchase, maximum purchase and fixed lot size of the SKU to be purchased. This column can be zoomed in to view the creation of the “Calculated rounded quantity”. This field also takes into account the parameter “Exclude open orders”. If this is activated, the need for open orders is also excluded from the advice; "Calculated rounded quantity" also takes into account the period for which the Purchase Proposal was generated (Start and End Date) and the delivery time of the item.
Purchasing code (lookup via Sales order line)
Purchase requisition lines are made recognizable by means of colors, based on “Advice of the Calculated required quantity”.
Kleur | Toelichting |
---|
Green | Quantity = Calculated rounded quantity, line can be accepted | Blue | Quantity of line has increased due to minimum order quantity or lot size (of SKU), line needs to be checked | Red | Quantity is higher than Calculated rounded quantity, line needs to be checked | Yellow | There are multiple rules for the combination Item No. / Location code, rule must be checked |
Conditions / preparations before start using this functionalityImplement usage of the Requisition Worksheets in your company Review the items in BC and make sure the masterdata is entered properly and is up to date. Especially pay attention to all Item parameters under “Replenishment” and “Planning”
Image Added |
---|
Prepare your items to start using Purchase Requisition functionality: especially pay attention to all Item parameters under “Replenishment” and “Planning” |
Implement Advanced Purchase Requisition for replenishment system PurchaseConfigure using the “Wholesale365 setup” page
Image Added |
---|
New functions to Calculate the Requisitions' Worksheet plan |
Image Added |
---|
|
Image Added |
---|
Usage of colours at the Purchase Requisition worksheet |
|