Is there a script that we could run that pulls all...
# suitescript
c
Is there a script that we could run that pulls all SOs that posted in April but had item fulfillment records for March? Our celigo integration went buck wild and posted SOs in April for order that were created and fulfilled in March. We need an easy way to move these SOs back to March
m
Probably best to make a saved search then export it and do an import to move the date Use this criteria Type = sales order date is on or after 4/1/24 And applying transaction date is on or before 3/31/24 And applying transaction type is item fulfillment
🙏 1
c
So, on the new saved search list all i have is sales campaign or last sales activity record.
I found it under Transactions > Sales > Enter Sales Orders I really appreciate this community. New to NS
n
You need to create a Transaction saved search and apply the criteria as mentioned by Maven. (which I assume you figured) For future reference this is not a "SuiteScript" question and better to ask in one of these :"General" , "Beginners" , "Integrations" or "Administration" (No biggy, but to reach the correct audience. 🙂)
🙏 1