<menu path> <link to F1 content>
None
The Cost Multiplier can be set against a stock code’s warehouse record in SYSPRO. It is particularly useful in transactions such as Purchase Order Receipt, Backflush, GIT Transfer or Inventory Receipt. It indicates what portion of the transaction value comprises non-merchandise costs, such as freight, duty, tax, etc.
| Info |
|---|
For more information on how the SYSPRO Cost Multiplier functionality works, refer to SYSPRO user guides. |
| Info |
|---|
If you don’t like reading, you can watch the video. |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<link to YouTube video> <link to PDF doc on my OneDrive> |
Try it!
<content>Try it!
Set the cost multiplier value against the stock code’s warehouse record in SYSPRO.
Open SYSPRO
On the Program List, browse to Inventory / Inventory Query
Enter the stock code in the Stock code field.
Select the lookup icon and right-click on the stock code to select the Warehouse option or that specific stock code.
Select the Warehouse and the Change button to update the Cost Multiplier value against the stock code’s warehouse record.
Add the Cost Multiplier value into the Cost multiplier field.
You should open a Purchase Order (for the stock code and warehouse where the Cost Multiplier was configured) to continue with the DATASCOPE PREMIUM WMS process.
In our example above, we used stock code A100 and Warehouse N.
Add the value of the non-merchandise costs.
When doing the purchase order receipt in DATASCOPE PREMIUM WMS, you can amend the non-merchandising cost before posting the receipt back to SYSPRO.
Open DATASCOPE PREMIUM WMS
From the Main Menu, browse to Inbound Receipt / Purchase Order Receipt / Receipt Purchase Order.
Enter the Purchase Order number in the Purchase Order number field.
Update the Receiving column with the items received for that specific stock code.
When you tab the Receiving field, the Cost Multiplier pop-up will appear, like when doing a SYSPRO Purchase Order receipt for the item.
Typically, the exact additional cost is usually only known at the point of receipt and is not often an exact percentage of the value of the goods.
Stock codes are flagged (in SYSPRO) with a cost multiplier value greater than one to enable the Cost Multiplier pop-up to add the exact amount during receipting.
| Info |
|---|
Note: The Cost Multiplier pop-up appears as the value was greater than one when it was set up SYSPRO. |
The value set up in SYSPRO will also be visible on the Cost Multiplier pop-up. The software automatically calculates 20% (as it is 1.2) of the item’s cost as the non-merchandise value.
You can either change the Cost Multiplier value in this Cost Multiplier field OR select the Enter non-merchandise cost checkbox to enter the exact cost in the Non-merchandise Cost field.
Changing the Cost Multiplier value will automatically recalculate the Non-merchandise Cost.
If there is more than one non-merchandise cost, you must add them together if you want to add it to the Non-merchandise Cost field. For example, $105 freight cost and $65 insurance = $170.
The cost will be apportioned to two different suppliers in the Distribution window.
o Enter the first non-merchandise cost as a reference in the Reference field. For example, FREIGHT.
o Select the Supplier from the Supplier drop-down list.
o Enter the GL Expense Code you want to use for FREIGHT.
o Enter the exact amount for the FREIGHT cost in the Amount field.
o Select Add
o The Distribution window will update with the remaining outstanding costs.
o Enter the cost of the second non-merchandise item. Select Add again.
Once all the non-merchandise items have been added, they will be visible on the right-hand side of the screen.
Select Save once the Distribution window’s cost is zero.
Continue with the process of allocating pallets for the Purchase Order Receipt.
Select Finalize.
When you Post (select Finalize) this receipt, SYSPRO will automatically create two additional cost entries – one against each non-merchandise supplier – for the two additional costs as non-stock GRN for the Purchase Order.
Query the supplier in SYSPRO.
Open SYSPRO
From the Program List, browse Accounts Payable / Supplier Query.
Enter the Supplier number in the Supplier field.
Select the Query option and Goods Received Notes from the drop-down.
Notice the non-stock costs. These must then be matched against the freight and insurance invoices when they arrive from the suppliers.
