This message was deleted.
# generals
Slackbot
11/14/2023, 8:25 PMThis message was deleted.
a
AK47
11/14/2023, 8:28 PMHi @Jackie Yang I generally try to avoid SPS, but in general these are fields that usually harcoded\templated in the EDI maps. They can certainly be mapped on the incoming 850 so that they get filled out when orders get created, but you can also put defaults on the customer level and have them sourced. Plenty of options.
j
Jackie Yang
11/14/2023, 8:33 PM@AK47 How are these fields hardcoded? They are calculation fields dependent on that order. TERMS DISCOUNT AMOUNT and TERMS DISCOUNT DATE would be calculated based on the selected terms the order date and the order amount.
Also, what do you mean by you try to avoid SPS? Why do you avoid SPS?
a
AK47
11/14/2023, 9:09 PMSPS is not my favorite EDI provider because there is nothing in your control. Everything is through their support and their support is sometimes difficult to communicate with for simple requests.
AK47
11/14/2023, 9:10 PMall of these fields can come in on the 850 creation via SPS mapping or workflow/script
AK47
11/14/2023, 9:11 PMdiscount amount would be a static field as I wouldn't expect that to change.
AK47
11/14/2023, 9:11 PMterms discount date would be mapped as a calculation on the 810 invoice. Due Date - X
j
Jackie Yang
11/14/2023, 9:11 PM@AK47 I asked SPS to map these two fields for us and our rep is saying it's not possible. It blows my mind a bit since these are SPS bundled fields. Why would discount amount be a static field? Isn't the discount amount 2% of the order total?
a
AK47
11/14/2023, 9:12 PMThe field would get 2%, not the amount. The amount should be a calculation....2% of amount
AK47
11/14/2023, 9:13 PMSPS telling you that they can't map these fields is why I don't like working with SPS. There is no way that's true, but to get to the right person who can do what you're asking is painful. The solution is always figure it out yourself in Netsuite.
AK47
11/14/2023, 9:13 PMwhich you can do, using workflows
AK47
11/14/2023, 9:13 PMor scripts
j
Jackie Yang
11/14/2023, 9:13 PM@AK47 the 2% is filled out in Terms discount percent
Jackie Yang
11/14/2023, 9:13 PMWe are looking for terms discount amount
a
AK47
11/14/2023, 9:14 PMdepending on the partner, that's often enough. To get the amount, it's a calculation...if I was in TrueCommerce, i'd open mapping manager and put in the calculation
j
Jackie Yang
11/14/2023, 9:14 PMsame with terms discount date. Terms discount date is not due date. Terms is 2% 60 Net 61. So Due Date is a day off than Discount date
a
AK47
11/14/2023, 9:15 PMsince you're on SPS and they are not helpful, I recommend just populating them via workflow
AK47
11/14/2023, 9:15 PMbut it's definitely not the only way
j
Jackie Yang
11/14/2023, 9:15 PMYeah was trying to avoid that because working with Dates in NS are always troublesome with the date time
a
AK47
11/14/2023, 9:17 PMshouldn't be an issue, you can subtract two date\time fields and return the # of days
j
Jackie Yang
11/14/2023, 9:17 PM@AK47 thank you for the help. Wanting to hear from others who are actually on SPS and how they use this functionality
👍 1
a
AK47
11/14/2023, 9:49 PMThankfully, none of my current clients use SPS 🤣