Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
stylenone

...

Overview

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.

Technical Requirements

For PartSmart

...

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 to send PartSmart Picklists to GF

...

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.

  • Develop a API that will POST to the Object: GFCON__Import_Sales_Order__c

  • With
  • A new Import Sales Order record will be created with these fields:

    • Populate GFCON__Order_Source__c with “PartSmart”

    • Populate GFCON__Id_Customer_No__c with the dealer’s account Id.

    • 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

          • The Product ID value must match a ProductCode value in GoldFinch.

          • If it does not, provide a lookup to map the PartSmart Product ID to GoldFinch ProductCode

        • Quantity

        • Unit of MeasureDescription

        • 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

Table

Field Name

Field Help

GFCON__Import_Sales_Line__c

GFCON__Item_No__c

populated from the API?

GFCON__Quantity__c

populated from the API?

GFCON__Id_Item_Unit_of_Measure__c

populated from the API?

Order

OrderNumber

Auto Number

AccountId

map from

Object: GFCON__Import_Sales_Order__c

Field: GFCON__Id_Customer_No__c

Shipping Information

Can this be looked up based on the Account Id?

Order Date

today

Shipment Date

today + 7 days

Pricebook2Id

should this be “Standard Price Book” ?

OrderReferenceNumber

map from

Object: GFCON__Import_Sales_Line__c

Field: GFCON__Sales_Order_No__c

GFERP__Sales_Line__c

GFERP__Item__c

map from

Object: GFCON__Import_Sales_Line__c

Field:

GFCON__Item_No__c

GFCON__Quantity__c

map from

Object: GFCON__Import_Sales_Line__c

Field:

GFCON__Quantity__c

GFCON__Id_Item_Unit_of_Measure__c

map from

Object: GFCON__Import_Sales_Line__c

Field:

GFCON__Id_Item_Unit_of_Measure__c

GFERP__Unit_Price__c

Is this automatically updated based on the Price Book?

Or does this need to be sent through the API from PartSmart?

GFCON__Sales_Order_No__c

What if an Id isn’t available?

Does Yakta want to use this as the Order ID or as a Reference Number?

PartSmart Picklist Field

GoldFinch API Field Name

Field Help

Id

Product Id

GFCON__Item _ No__clook up GF Item table.

Quantity

Quantity

GFCON__Quantity__c

quantity ordered for a specific item

Description

Description

Item Unit of Measure (UOM)

GFCONItem__Idr.Base_Item_Unit_of_Measure__c

specify UOM such as each, case, etc.

For GoldFinch Developer

  • Develop API endpoint for the GFCON__Import_Sales_Order__c object

  • for Import Sales Order records with Order Source = PartSmart, and processed = false

    • write code that looks at PartSmart_Picklist_JSON__c file and does the following

      • Does the related GFCON__Import_Sales_Line__c object need to be populated first?

      • create sales orders

      • create sales lines

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.