ERPNext-Frepple Integration

Frepple integration for Frappe web framework

Frepple Custom App built based on Frepple Advanced Planning and Scheduling software. It was built to integrate with ERPNext, act as a connector that allow bidirectional data transfer between Frepple and ERPNext. It also used to map the data type between frepple and ERPNext since both software do not use the same data structure and format.

Prerequisite

1. Installed the Frepple and successfully launched it on the localhost.
2. Installed the ERPNext and successfully launched it on the localhost.

The App Contains

1. Export data from ERPNext to Frepple with a few clicks.

2. Generate the plan in Frepple custom app itself, with configurable constraints.

3. Import the manufacturing orders and purchase orders from Frepple to ERPNext.

4. Embed Frepple page into ERPNext user interface using iframe. Access the frepple screens through Frepple Custom Page.

5. Generate the work order and purchase order in ERPNext based on the result from Frepple.

6. Sync the status of work orders and purchase orders between ERPNext and Frepple.

Usage

1. Installation

Navigate to the bench directory and run the following command:

bench get-app frepple https://github.com/msf4-0/ERPNext-Frepple-Integration.git

Install the app onto your site.

bench --site [your.site.name] install-app frepple

Bench start

bench start

The Frepple custom app main page.

2. Frepple settings configuration

Before starting using Frepple custom app, you are required to set up certain information to enable the integration between ERPNext and Frepple. Go to Settings > Frepple Settings.

• Authentication header:

The Bearer web token key that required for REST API request. The key can be found in Frepple Software, under Help > REST API Help.

• Username and password:

Username and password of superuser in Frepple. Default username and password are both “admin”. The information can also be found in Frepple Software, under Admin > User.

• URL:

Web url that the user host the Frepple. The url is used for REST API request Get the wireless router IP address. You can find the Wireless LAN adapter Wi-Fi IPv4 address using ipconfig (Window OS) or ifconfig (Linux OS) command in the command prompt. E.g. http://192.168.112.1:5000.

• Frepple Integration:

Checkbox. Tick it to turn on the automatic status syncing for sales order, work order, purchase order status and bin (stock) amount update.

• Secret key:

Key is required for iframe embedded to render the Frepple page. Can be found under etc/frepple/djangosettings.py file.

Important Note

Frepple custom app does not perform any data validation when the data are exported to Frepple software. The user must have basic knowledge of Frepple to ensure the data provided are sufficient to generate the plan in Frepple. A quick debug step is to verify the supply path matches the product structure. Remember to set up item supplier for the raw material.

Contributors

1. Drayang Chua Kai Yang
2. Lee Xin Yue
3. Chia Jun Shen

License

This software is licensed under the GNU GPLv3 LICENSE © Selangor Human Resource Development Centre. 2021. All Rights Reserved.