Mapping
Status of Each File as of 11/28/2024
Csv File | Status | # of records on file/# of records in instance | Is filter correct in code? |
Bom | Done | 25114 / 25114 | yes |
Co | Done | 190/190 | yes |
Group | Done | 73 / 73 | n/a |
Location | Done | 1/1 | n/a |
Master | Done
| 12863 / 12710 | yes |
Po | Done | 749 (PO:587)(WO: 162) / (PO:587)(WO:162) = 749 | PO is good |
Pohist | Done
| 5771 / (PO:4629)(WO:1142) Good | yes |
Sales | Done
| 738 / 738 | yes |
Stock | Edit code / add filter / Unsure (need help) | 7526 / 6925 | yes |
Supplier | Done | 1735 /1736 | yes |
Open Issues
Yakta Hosting SFTP Server:
Yakta (????) will be responsible for hosting an SFTP server for file transfers.
GF's File Transfer Solution:
GF needs a method to send CSV files to the SFTP server, as Salesforce does not provide native support for SFTP communication.
Netstock's Role:
Netstock will need to read from the SFTP server to receive daily data feeds.
Steps to Start the Project:
Yakta:
Confirm whether Yakta has the capability to host an SFTP server.File Transfers from Netstock:
Netstock will send all current CSV files received from Arrowquip to GF for reference purposes.
Netstock Functionality:
Netstock generates Purchase Orders but does not generate Work Orders.
Data Requirements:
https://intercom.help/netstock/en/articles/6035075-data-interface-requirements
Work Order Supply:
Ensure that Work Order supply is reflected in the Outstanding Purchase Orders.Work Line Demand:
Include Work Line demand as part of the Outstanding Customer Orders.