looking for others that use SPS. There are increas...
# generalj
Jackie Yang
09/16/2025, 4:29 PMlooking for others that use SPS. There are increasing requirements from retailers to pass over expiry dates on the ASN we send to them. Only issue is that we use a 3PL and we don't lot track ourselves in NetSuite. I'm just wondering what options we have to make this work because my assumption is that the ASN get's generated from native netsuite fields such as the inventory detail section for Lot and expiry information
m
MGBC
09/16/2025, 4:35 PMI’ve seen this done many ways
A lot of it depends on how you are getting the information from the 3PL
MGBC
09/16/2025, 4:36 PMIn many cases I’ve seen the data from the 3PL stored in custom fields on the item fulfillment. Then use a script to populate the Package records for SPS and trigger their ASN generation suitelet
MGBC
09/16/2025, 4:37 PMAlternatively if you have a sophisticated integration with your 3PL you could attempt to create the inventory detail information on item fulfillments but I don’t believe that transfers over to the SPS package records
MGBC
09/16/2025, 4:37 PMThose are what drive your ASN information
j
Jackie Yang
09/16/2025, 7:35 PM@MGBC Thank you so much! Your responses have been actually very helpful. So we do use a script to populate the package records for SPS and trigger the ASN generation. So the expiration date would come from the SPS package record and not the native netsuite inventory detail?
Jackie Yang
09/16/2025, 7:38 PM@MGBC I believe even the issue with the SPS Package record is that it's pulling the expiration date that exists in netsuite and there isn't an option to override it using the values we are getting from our 3PL
m
MGBC
09/17/2025, 1:19 AMSo you’d have to manage the expiry dates in NetSuite based on data from your 3PL?
MGBC
09/17/2025, 1:20 AMMaybe setup an integration to get expiry dates, serial from your 3PL and update the inventory numbers table with this information