Netstock Integration Design
- Scott Zhuo
Mapping as of 12/30/24
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.