Sending Pickup Date Request to UPS, Return Processing

Business Central/NAV Developers Forum
1

Hi everyone,

when the customer service clicks “Process RA” in the Sales Return Order page, another page appears “Return Order Statistics” and on this page i created a field calls “Preferred Pickup Date” which the Customer decide it and the customer service enters it manually in the “Preferred Pickup Date” field so the UPS service will go there in the same date and time to pick up the returned goods. so even if the customer service entered the date 1 week before the “Preferred Pickup Date”, the request needs to be sent the last workday before the preferred pickup date, considering weekends also.

I WANT TO KNOW HOW I CAN LET NAV CALCULATES THE DAY THE REQUEST NEEDS TO BE SEND.

thank you.

2

can somebody help please?

3

Hello, i think this function helps. msdn.microsoft.com/…/dd301188(v=nav.71).aspx.
I think this helps.

What
Type: Integer

Specifies what the function returns. The valid options are 1, 2, and 3.

The value 1 corresponds to day of the week (1-7, Monday = 1).

The value 2 corresponds to week number (1-53).

The value 3 corresponds to year.

4

It’s hard to know. Sounds like customized code or an add-on solution. And what’s the version of NAV?

But if the “UPS pickup solution/customization” is doing it in a similar way to how normal orders calculate shipment dates, then it would be using customized calendars (they may or may not pickup/deliver all days) and the same functionality as you find there. Here it combines date-formulas with active/ in-active days, so that it will skip the in-active.

5

Hi,

@Erik P.Ernst : Nav Version 2016

@Thomas Barbut : i could not open the link.

i just figure out that there is a system Table(Saved Memory) called “Date”, i created a new Page and set SourceTable Property to “Date” and i see now on the Page this Fields:

  • “Period Type”
    -“Period Start”
    -“Period End”
    -“Period No.”
    -“Period Name”
    what i want to implement is : for example today is Monday and if the Preferred Pickup Date which is the Customers Preferred pickup date = after tomorrow(Wednesday) Then SendPickupRequestToUPS one day before the preferred pickup date and in this case its (Tuesday).

And if the Customer Preferred pickup date is Monday then SendPickupRequestToUPS on Friday because the weekend is no working days.

I dont know how i can do this! i am still a trainee just to inform :slight_smile:
Thank you for your answers.

6

you can use job queue to run a codeunit for count and list the requests once per day or maybe several hours a day
you can use the codeunit to send list for UPS or for your contact window.

7

thank you all very much :slight_smile: problem solved!