--- title: "Purchasing and Receipting Related System Settings" canonical: "https://kb.myframeworks.com.au/space/FRAM/28401318/Purchasing%20and%20Receipting%20Related%20System%20Settings" format: markdown --- # Overview The Frameworks** Purchase and Receipting** module can be customised to meet your business's specific needs. In order to do this various system settings and flag are required to be defined to turn on or off different functionality. > ⚠️ **Important**: Only users with the appropriate security access are able to make changes to the system tables. > ℹ️ ### Click on the required system setting code for more information. > ℹ️ > ℹ️ *Tip: Press Ctrl + f to use your browsers search function to find the system setting you are looking for.* > Macro (toc) # System Settings - Flags The following system flags are related to all areas of purchasing and receipting.  > ✅ Refer to [Amounts](https://sterlandsupport.atlassian.net/wiki/pages/createpage.action?spaceKey=CIL&title=Amounts) for more information on how to edit and maintain system flags. ## BranchMask > Macro (include) --- ## CusDryPerm > Macro (include) --- ## FWAutoBTExcess > Macro (include) --- ## FWForceBTExcess > Macro (include) --- ## FWManuPo > Macro (include) --- ## FWPBCycle > Macro (include) --- ## FWPBSinSup > Macro (include) --- ## FWPoDteMan > Macro (include) --- ## FWPOPrtQty > Macro (include) --- ## FWProdReord > Macro (include) > ✅ Refer to the [Stock Reordering Scheduled Task Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28384718) User Manual for additional information. --- ## FWProdReordlg > Macro (include) > ✅ Refer to the [Stock Reordering Scheduled Task Dashboard](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28384718) User Manual for additional information. --- ## FWPurIgSlo > Macro (include) --- ## FWPurBatch > Macro (include) --- ## FWPurchaseDfST > Macro (include) --- ## FWPurchaseType > Macro (include) --- ## FWPurIntCst > Macro (include) --- ## FWPutAwayDktDef > Macro (include) --- ## FWRecalCos > Macro (include) --- ## FWReceiptInvCap > Macro (include) --- ## FWReceiptInvMan > Macro (include) --- ## FWReceiptInvVal > Macro (include) --- ## FWReceiptInvVal2 > Macro (include) --- ## FWReqDefST **Flag Purpose**: New Requisition lines to default to Stock Order Type - When enabled, the **Order Type **defaults to **Stock** for newly added purchase requisition lines. - When disabled, the **Order Type **defaults to **Daily** for newly added purchase requisition lines. > ⚠️ This flag is dependent on the **FWPurchaseType** flag being enabled. --- ## InvExBrStk > Macro (include) --- ## InvGrpROrd > Macro (include) --- ## InvPOZeroC > Macro (include) --- ## InvReptReb > Macro (include) --- ## Invrcpdate > Macro (include) --- ## Invrcptrep > Macro (include) --- ## InvRctKDA > Macro (include) --- ## InvOrdPack > Macro (include) --- ## InvStkAct > Macro (include) --- ## InvStkZero > Macro (include) --- ## OrderDel > Macro (include) --- ## OrderDelDt > Macro (include) --- ## OrdDelBrnT > Macro (include) --- ## OrdRBrnT > Macro (include) --- ## PONewPopup > Macro (include) --- ## ProdCustDescLbl > Macro (include) --- ## ProdCustDescPur > Macro (include) --- ## PurAddrToShip > Macro (include) --- ## PurFPriceDtChg > Macro (include) --- ## PurRecptIndv > Macro (include) --- ## PurSBrnT > Macro (include) --- ## PurStockBrn > Macro (include) --- ## PurStockProd > Macro (include) --- ## PurSupCon > Macro (include) --- ## PurHRcptInv > Macro (include) --- ## PurUOMCst > Macro (include) --- ## RcptPOPrtWarn > Macro (include) --- ## RcptPrdLbl > Macro (include) --- ## WHouseSupDef > Macro (include) --- ## XMLPickMLocn > Macro (include) --- ## XMLTallyTextB > Macro (include) --- # System Settings - Numeric The following system numeric settings are related to all areas of purchasing and receipting. > ✅ Refer to [System Settings - Numeric](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401694) for more information on how to edit and maintain system numeric settings. --- ## FWApWrnDays > Macro (include) --- ## FWNumLabel > Macro (include) --- ## FWPSSRDays > Macro (include) --- ## FWSTKPODays > Macro (include) --- # System Settings - General The following general system settings are related to all areas of purchasing and receipting. > ✅ Refer to [System Settings - General](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28382808) for more information on how to edit and maintain general system settings. --- ## BTReqTime **Setting Purpose**: Default Requested Time for Branch Transfer Sales Order This setting allows you to define a default requested time, on the supplying branches sales order, when creating a branch transfer. - In the **Value **field, enter the **Requested Delivery Time Code. **This will be applied to the delivery details, of to the supplying branch's sales order, when the finalise transfer process is performed in the purchase orders. > ⚠️ This requires the **Miscellaneous Table > System Requested Delivery Times **to be configured. --- ## InvExcessC **Setting Purpose**: Algorithm for calculating the excess stock This setting determines the algorithm to be used to calculate the **Excess Stock.** Enter the **Value** of either **Standard**, or **OverMax**. - **OverMax**: To calculate the excess stock, you simply deduct the available quantity less branch maximum stock, for example, ((Stock On Hand + On Consign + On PO) - On Customer Order) - Maximum Stock Allowed - **Standard**: To calculate the excess stock, use the following equation > 📝 Excess **=** (Stock on hand) **–** (Total Sales Order qty) **–** ((Average Daily Sales Qty) ***** (ThresholdDays)) --- ## InvRebCst **Setting Purpose**: [Full], [Partial] or [Non] Rebated Costs? Enter the **Rebated Cost **type into the **value** field. Type either **Full, Partial **or **Non.** > ℹ️ This flag works with the **System Setting - Flags **flag **[InvReptReb](https://sterlandsupport.atlassian.net/wiki/spaces/FRAM/pages/28401318/Purchasing+and+Receipting+Related+System+Settings#InvReptReb)****.** --- ## OrdTfrDesp > Macro (include) --- ## OrdTfrArea > Macro (include) --- ## InvPoPen **Setting Purpose**: Product code for Supplier Penalty Surcharge When a **Value** has been defined it sets the **product code** for a **Supplier Penalty Surcharge**. - If defined with value **ZZ-MISC** and the Order Total is less than the Supplier’s Minimum Order Value, an error message is displayed stating: **Order is under the supplier minimum order value of $nnnnn, penalty surcharge of $nnnnnn has been applied**. A penalty surcharge code is also added in the order grid. However if the Order Total is more than the Supplier’s Minimum Order Value or if the Order Total is negative, no error message is displayed. - If not defined, a warning message is displayed ***Order is under the supplier minimum order value of $nnnnn, penalty surcharge of $nnnnnn may apply*** in the Purchase Order and the surcharge product is not included in the order grid if the total order is less than the Supplier’s Minimum Order Value. However, if the Order Total is more than the Supplier’s Minimum Order Value or if the Order Total is negative, no error message is displayed. --- ## InvStkRord **Setting Purpose**: Algorithm to use for stock reordering - This setting defines which algorithm the system is using to calculate the Stock Reorder. Enter the **Value** of either **MintoMax** or **Standard**.
Click here for more information on the MintoMax and Standard Algorithms | **Algorithm** | **Explanation** | | --- | --- | | **MintoMax Algorithm** | In order to provide a means of running an alternate stock re-ordering algorithm a new tailoring code has been introduced. This alternate algorithm has been simplified so that only the maximum stock level, minimum pack levels and minimum reorder quantities are considered. Daily sales and lead times are not be taken into consideration with this new algorithm.
Stock is ordered when triggered by the stock available falling to/below minimum – and ordered up to the maximum stock on hand. When a product hits the minimum or below, it orders up to the maximum, respecting the pack quantities and minimum order quantity but never ordering more than the maximum.  The order quantity is reduced if the pack quantities would result in the order quantity plus the stock on hand exceeding the maximum. | | **Standard Algorithm** | Stock requirements for system-generated stock re-ordering are calculated using the following formula:
**Quantity Available:  **Stock on Hand ***plus*** Outstanding Purchase Orders ***minus*** Outstanding Customer Orders
**Suggested Order Quantity:  **Average Daily Sales (promotions can be excluded) ***multiplied by*** Lead Time in days ***minus*** Quantity Available ***plus*** Minimum Stock
If the Suggested Order Qty <  Min Stock and Qty Available > 0, Then Suggested Order Qty = Min Stock – Qty Available.
If the Suggested Order Qty <  Min Stock and Qty Available < 0, Then Suggested Order Qty = Min Stock.
The Suggested Order Quantity is rounded up to the relevant increment of the supplier Pack Size unless the flag 'InvOrdPack' = 'yes' and the product is a slow mover. That is, sales for the previous six months are less than the supplier Pack Size.  In this case, there will be no rounding, so the Suggested Order Quantity will be for a broken pack size, usually without any quantity break reduction in cost.
Then, if the Suggested Order Quantity is less than the supplier Minimum Order Quantity, it is rounded up to the supplier Minimum Order Quantity unless the product is a slow mover (refer above).
Then, if the Suggested Order Quantity exceeds the Maximum Stock, it is rounded down to or below the Maximum Stock by increments of the Pack Size (unless Maximum Stock = 0 in which case – no change).
If the Suggested Order Qty < 0 set it to 0. |
--- # Additional Information > ✅ Refer to [Purchasing and Receipting](https://sterlandsupport.atlassian.net/wiki/pages/createpage.action?spaceKey=fram&title=Purchasing%20and%20Receipting&linkCreation=true&fromPageId=28401318) for more information relating to the purchasing and receipting module.