RAW MATERIALS & PURCHASE ORDERS

Building your list of materials required for a job from items in Stock and Availability Charts ready for purchasing is done through ‘Raw Materials’.

Raw Materials can be accessed in Jobman within each Job under the ‘Raw Materials’ Tab.

To add items to the job raw material section you can do this in two ways, you can add items one by one by Clicking ‘Add Record’  then use your filters search bar as further outlined below. The alternative option, is a CSV.file import which has to be generated from a materials report by your CAD software initially (Note: you do require to have product codes referenced the same in both software).

 When searching for Availability Chart items in your Raw Materials tab, the following fields are available for you to define what you are looking for. (see below)

It is always a good idea if you do not know the product code to define the following.

  • Stock Type
  • Brand
  • Finish

Double clicking on any result in the two windows below will fill in the remaining blank fields. Always check the length, width, thickness and the quantity required are correct. Be sure that the supplier field is filled in for an Availability Chart item. This will assist in purchase orders being created easily.

Note: It is also possible to add a material to the order that does not exist in the Availability Charts and this will add to this order and also populate the Availability Charts. To do this simply select the pre-defined fields for Stock Type, Brand, Product Code, Price, Rate Type and Supplier and click OK.

Changing the source of a raw material

You can change the source of a raw material by opening that raw material and then double clicking on the appropriate line.

Raw Material CSV.File import:

Following these few simple steps below to import materials from your CAD software into the job raw materials area. Note: You may have to speak with your CAD software support to configure the required materials report to save as a csv.file, and to have your products listed with the required product codes to match what you have populated in Jobman availability chart items.
1) Inside a job, click on the Raw Materials tab, then click the Import button, then select the import type available from the drop-down tab options. Note: Current supported CSV.file imports are for Cabinet Vision, Cab Master, Go Cabinets, Microvellum, and Mozaik. If your CAD software is not listed as an option, you can use the Jobman CSV option, you will require to copy/paste the required data over from your materials report, then save it prior to the upload. If you use Cabinet Vision and have the CV integration setup with Jobman, click here to learn more about the Sync Back Pro and CSV materials import: Cabinet Vision/Sync Back

 

2) Click Browse…Select the saved CSV.file from the location saved on your PC files, then click upload.

 

3) Click OK to confirm items to upload, now that the items on the CSV.file have been uploaded, click the Assign Source button to assign the source of either Stock or Purchase Order to the imported items. 


 

4) Now the source has been assigned, you will have the stock items qty deducted from stock qty on hand, and you will be able to generate the supplier purchase orders as per the following steps.

 

Click here to watch a demonstration of Mozaik Material Import into Jobman.

 

Creating a purchase order

A Purchase Order can be created a couple of ways within Jobman, 1) for the specific Job or for Batch orders via the Purchase Order Tab OR 2) from the General Menu > Purchase Order tab itself.

1)  Purchase Order created for a specific job:

When all the Raw Materials have been collated and you wish to create a purchase order, select Purchase Orders and Generate Purchase Order.

In the New Purchase Order form select a Supplier. The Attention field is populated automatically if a contact person has been selected in the Contacts.
Add new items by clicking 

Once you have saved the New Purchase Order form, it will be listed. Once the item has been delivered in full, the delivered amount will turn green and the required date will turn black.

To edit, double-click anywhere in the row and you will see the below Purchase Order form.

2) Below is how to create a batch purchase order grouping multiple items for multiple jobs to one supplier order:
 
From the Purchase Order tab, you can click generate purchase order to open a new form. If you have already assigned raw material items in various jobs, once you select the supplier, a pop up window will appear to confirm OK to add in the number of line items to the purchase order.

You also do have the option if required to Add new items to an existing Purchase Order, this will have to be at the Created status to perform this action. 

To add new items to an existing Purchase Order, select the created PO open it, then select Add more.. select whether you want to add items for either a specific job number or there will be an option for All Jobs (for the indicated supplier). If choosing to show item from all Jobs, the grid will load items that you can then select to add to the existing PO.

Note: You can also add item to the purchase order that are not assigned to a specific job, these are searchable in the Availability Chart section as per image below. Simply use the search bar to located the availability chart item and double click to add to the PO. These will list as Stock under the Job column on the PO.

If choosing to show item from all Jobs, the grid will load items that you can then select to add to the existing PO. Click OK to add the items to the existing PO, then click save. If you are ready to send the PO to the supplier, you can click email or you can also export to CSV.file to upload onto the supplier online ordering website (supplier must have the upload CSV.file option for this to work) then update the status of the PO to ordered.