Mapping as of 12/30/24
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.
...
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 11/28/2024
Confirm Qty. on Hand on SKU is accurate and recalculated every night.
Confirm all files are created every night in Heroku SMTP server
First Stock Date on SKU. Most of them are blank.
Trigger to update Actual Receipt Date on Purchase Line
Account Number on Account.