Skip to content

Partnumbers

Part numbers are how JDM tracks Model Sizes and Options throughout the Builder. When checking out using Business Central, each line item requires a Part Number to be associated with it in order to charge for it within the Business Central system.

Creating New Partnumbers

Creating a new Partnumber is a two part process. The Part Number needs to exist in Business Central first and foremost. If it is not there, Shedbuilder cannot link the pricing of the Option or Modelsize to a price. The Partnumbers used by Shedbuilder and Garagebuilder are a locally stored version used to associate information about a component in the Builder so that it can be read by Business Central.

At the moment, there is no way to add Partnumbers in the Admin. Partnumbers have to be created through SQL.

Partnumber Table

The Partnumber table is comprised of several flags used to identify it within the Builder. These various flags are necessary to prevent an Option or Modelsize from getting two partnumbers assigned to it accidentally, or from Business Central from mistakenly identifing the wrong Partnumber at checkout.

Each PartNumber uses the following to help identify the component it needs to be associated with:

  • ID: This is the unique GUID for the Partnumber itself.

  • Number: This is the actual Partnumber used by Business Central to identify the Option or Modelsize.

  • OptionID: If the Partnumber is for an Option, the Option GUID is assigned to the Partnumber here.

  • ModelID: If the Partnumber is for a Model Size, the Partnumber needs the Model GUID as well. It is assigned here.

  • ModelSizeID: IF the Partnumber is for a Model Size, the Model Size GUID is assigned here to associate it with the correct Partnumber.

  • SidingType: Certain Partnumbers have variations based on the Siding Type that the Shed or Garage is built with. Assigning this value to the Partnumber helps filter to the correct Partnumber.

  • BuildType: Certain Partnumbers have variations based on the Build Type that the Shed or Garage is built with. Assigning this value to the Partnumber helps filter to the correct Partnumber.

  • ModelType: Certain Partnumbers have variations based on the Series that the Shed or Garage is built with. Assigning this value to the Partnumber helps filter to the correct Partnumber.

  • BuilderType: Certain Partnumbers have variations based on whether it is associated with a Shed or Garage. Assigning this value to the Partnumber helps filter to the correct Partnumber.

  • BasePrice: This is the Base Price of the Partnumber. The final value of the Option or Model Size will change as it works with the Price Sets to apply modifiers, but without any changes, this is what each Option or Partnumber would be.

  • BusinessCentralDescription: This is a brief description of the Option or Modelsize. It is only visible when checking out through Charge Logic.

  • BaseUnit: This is the Unit by which JDM buys the item.

  • SalesUnit: This is the Unit by which JDM sells the item.

Sales Unit is important because how the Unit is sold differs from Option to Option. Each type has a different pricing mechanism associated with it in order to get the correct price at checkout.

Price Sync

Most of these fields can be entered through SQl, however the Base Price, BusinessCentralDescription, BaseUnit and SalesUnit all are assigned from the Partnumber in Business Central.

To get this information associated with the Partnumber navigate to the main page of the Shedbuilder Admin and select the button labeled 'Run BC Price Sync'. This will syncronize all Business Partnumbers with the Sancsoft Partnumber table, ensuring accurate pricing for every Partnumber in the table.