Description
A user needs the ability to automatically send the PartSmart Picklist (Sales Order) to GoldFinch so they do not need to manually enter a sales order into GoldFinch.
Setups
On the Dealer’s Contacts, populate Email Address, which is typically the user’s email address.
For every item that could be ordered by PartSmart, set up to Sales Prices for CAD and USD.
Ending Date should be far in the future.
Price Type = All Account
Minimum Quantity = 1
Steps
Error Conditions
PartSmart User Name is not set up
Dealer Account is not set up
Item is not set up
Sales Prices are not set up
Configurations
PartSmart post their picklists to GoldFinch a public URL.
A new Import Sales Order record will be created with these fields:
Populate GFCON__Order_Source__c with “PartSmart”
Picklist JSON file should go to PartSmart_Picklist_JSON__c
The Picklist JSON File should include these values:
Id
PartSmart User Name / Dealer
Product Id
Description
Quantity
As soon as a new Import Sales Order is created with PartSmart_Picklist_JSON__c != null:
Use PartSmart User Name to look up Contact, to populate
Customer Name
Id Customer No.
Populate Customer PO No. with Picklist Id
Order Date = today’s date
Populate Import Sales Line
PartSmart Picklist Field | GoldFinch Field Name | Field Help |
|---|---|---|
Product Id | Item No. | |
Quantity | Quantity |
|
Description | Description | |
Item Unit of Measure | Item__r.Base_Unit_of_Measure__r.Name | |
Unit Price | look up Sales Price table using Currency and Item. Currency is from Account. If blank, Company Setup. If blank, CAD |
Process Records
Once the values have been imported, you can view and update the data before the Sales Order records are created.
In the Not Processed View:
Select the individual Import Sales Order record(s) to convert into a Sales Order.
If no records are selected, GoldFinch will process all of the records where the Processed field is NOT checked.
After selecting the Import Sales Order records, click the Create Sales Order button to process the data.
After a Sales Order has been successfully created, the Processed field on the Import Sales Order record will be checked and set to true.
Opens image in full screenOpen
Error Resolution
If GoldFinch encounters any errors while creating a Sales Order from the Import Sales Order record:
The GF Sales Order will not be created until the errors have been resolved.
The Processed field on the Import Sales Order record will be False.
Use the Not Processed View to see all Import Sales Order records with an error message.
The Error will be populated into the Error Text field on the Import Sales Order record.
Use the Error Text field to correct the Import Sales Order record and resolve the error.
Once all errors have been resolved, rerun the process by selecting the Import Sales Order record and clicking the Create Sales Order button.
Mass Delete
If necessary, multiple Import Sales Order records may be deleted at the same time:
In the Not Processed View:
Select the individual Import Sales Order record(s) you want to delete.
If no records are selected, GoldFinch will delete all the records where the Processed field is NOT checked.
After selecting the Import Sales Order records, click the Mass Delete button to process the data.