J.D. Edwards (JDE) supplies master data and order data to ISPnext through an interface. This article describes how that connection works. It is the basis for the other JDE articles.
The interface sends changes only
The interface does not resend all data every day. Only updates to master data and order data are sent. In ISPnext the corresponding endpoint is called order_data.
Each line of data is accompanied by an action. That action tells ISPnext what to do with the line:
| Action in JDE | Value in the JSON file | Meaning |
|---|---|---|
| A | create |
Add |
| U | update |
Update |
| D | delete |
Delete |
BG and BG_FULL
The regular export job produces a BG file: only the changes since the previous export. In that file each line carries an action.
A full export job produces a BG_FULL file: the complete set of order data. That file carries no action, because it is not a set of changes but the entire position.
| File | Contains | Field action in the JSON file |
|---|---|---|
| BG | Only the changes since the previous export |
create, update or delete
|
| BG_FULL | The complete set of order data | null |
order_data.json in both cases and the endpoint is order_data. The file name therefore does not tell you whether it was a BG or a BG_FULL file.When do you need a full export?
Because the interface sends changes only, ISPnext falls behind as soon as a change does not arrive. A subsequent regular export does not make up for that: it contains only the changes that arose afterwards. A full export is needed in that case.
What to do then is described in JDE data missing in ISPnext.
More information
- JDE data missing in ISPnext
- JDE export - checking whether the file has been imported
- JDE export - exporting order data in full (BG_FULL)
Disclaimer
These articles describe the connection between JDE and ISPnext as it is configured by default. Your own configuration, permissions and JDE version may differ. Always follow your organisation's change management process and involve your JDE administrator or implementation partner where needed.