Project

General

Profile

How to add 'Cut Length Charge' in the Regular Purchase Order

We have added new functionality so cut length charges can be applied to regular purchase orders.
A new table will be used to hold the relevant cut length charge records.
First of all, a new option must be created in ‘System Tables > Option Names called ‘Cut Length’ with the code set as ‘Cut Length’.
A new dummy stock record should then be set up with a link option = Cut Length.
We have created this new table for the supplier (vendor), blind type, stock item, cut length charge and % uplift. This table is called ‘Cut Length Charges’ and is a tab in the ‘Suppliers’ form (vendor).
This new table can now include a stock item which will be the cut length charge record (the lookup will only show records with a link option = ‘Cut Length’), and it will be applied according to the blind type and supplier (and if the amount required was less than the full roll).
The blind type is found by looking at the blind type field that is held in the stock item.
The algorithm is as follows: the Cut Length charge will be added to each Regular PO detail line if it has Amount Ordered less than Roll Length.
But the type of Cut length line added will be dependent on Blind Type and Supplier (vendor) of the Stock Item selected.
The cut length charges are applied by a button called ‘Apply CLC’. A new detail line will be added to the PO for cut length for each relevant detail line.

The new option should be created in ‘System Tables > Option Names ‘ tab called ‘Cut Charge’ with the code set as ‘Cut Length’:

Check the ‘Apply Fabric Cut Length Charge’ box in the ‘Parameters > Order/Quotation Processing’ tab:

Check the ‘Roll Length’ value in the stock item (which will be used in an example):

Check the ‘Unit Cost’ tab where the unit of sale linked to the stock item:

Check the ‘Cut Length Charge’ in the ‘Stock Item > Regular PO Options’ tab:

Create the specific stock item which would be applied as cut charge (should contain ‘Cut Charge’ link option):

Go to ‘Suppliers > Supplier Amend’ (vendor), open ‘Cut Length Charges’ tab and fill up the price for the cut length charge (‘Cut Charge’ stock item):

Create a new ‘Regular PO’, then click ‘Apply CLC’ button. The cut length charge would be created, for second purchase order detail because of the ‘50’ unit quantities and the ‘Roll Length’ value in the stock item (in example 100):

Automate Cut Length Charge

There is a new parameter in the supplier (vendor) record called 'Apply Cut Length Charges at PO Save':

This defaults to false - if true the 'Apply CLC' button in the ‘Generate Regular PO’ form is hidden, and the cut length charges are applied when the PO is saved: