Tickets older than 90days will be Auto-Archived. Ticket updates or comments will reset the timer.

Business Intelligence

Unassigned

IT - Technology

IT - P21

Accounts Payable

Credit Card "PO" Purchases

DGI Forms

Canada Requests

Payroll

Direct Deposit Change

Print...

LMS - Surcharge Increase Instructions

Question:

Hello,

Ted and I had decided to move forward and do an in crease in the LMS surcharge that we currently do for Prepaid and Charge. The surcharge is currently at 20% in the US we are increasing it to 30%.

In Canada we do not do a surcharge we have a flat fee surcharge of $10. We will be removing that flat fee and switching to a 30% surcharge to mimic US increase.

This should go into effect January 1 2024 please mark this on your Calanders to complete. I added a snip of how I see it on the back end of LMS in the US

*reminder LMS should reflect cost plus 30% surcharge*

Thank you

Our purpose is to play

a meaningful role in our

customers’ success.

Gerardo Velazquez – Director of Distribution
DGI Supply, a DoALL Company

Mobile: 224-254-3859

Fax:

Email:gvelazquez@dgisupply.com

Web:http://www.dgisupply.com

Answer:

Gerry. This task is completed. All ready to go on Jan. 1st. Please advise any questions. Closing ticket. 12/19/2023.

Mike Schlager – Database Analyst
DGI Supply, a DoALL Company

Mobile: 716-239-5320
Email: mschlager@dgisupply.com
Web: http://www.dgisupply.com

This is now scheduled to run on Jan 1st 2024 at 12:01AM

Regards,
Ricardo Aguirre
Database/Server Administrator

Increases are created to be effective 1/1/2024 for both US and CA

Canada

Mike Schlager – Database Analyst
DGI Supply, a DoALL Company

Mobile: 716-239-5320
Email: mschlager@dgisupply.com
Web: http://www.dgisupply.com

Ricardo, can you setup the task to run Jan. 1st at 12:00 A.M. I will define the new rates to be effective 1/1/2024 in both US and CA.

P21USDB.LatitudeManifest

Delete from FROM [LatitudeManifest].[dbo].[Discount] where DiscountUID = 1

P21DB.LatitudeManifest

Delete from FROM [LatitudeManifest].[dbo].[Discount] where DiscountUID in (4,5)

Mike Schlager – Database Analyst
DGI Supply, a DoALL Company

Mobile: 716-239-5320
Email: mschlager@dgisupply.com
Web: http://www.dgisupply.com

noted! yes we can schedule a job as we do with other tasks.

Michael, if you need assistance please let me know.

Regards,
Ricardo Aguirre
Database/Server Administrator

I do not believe that there is an expiration date field you can set on the discount rate chart entries. The flat rate would need to be manually deleted once the new year begins if you do not intend on using it.

You could set up a SQL job to execute a DELETE statement on the Discount table where the DiscountUID = the ID of the flat rate, and schedule it for the beginning of the new year:

Mike Schlager – Database Analyst
DGI Supply, a DoALL Company

Mobile: 716-239-5320
Email: mschlager@dgisupply.com
Web: http://www.dgisupply.com

Adding Carina and Ricardo for visibility.

Mike Schlager – Database Analyst
DGI Supply, a DoALL Company

Mobile: 716-239-5320
Email: mschlager@dgisupply.com
Web: http://www.dgisupply.com

Here are the proposed changes. Please confirm.

US:

Change Carrier to <ALL>

Set Effective to 01 Jan 2024

Set Discount Value to 30

Retain Discount Type at PERCENT INCREASE

CANADA:

Remove FLAT INCREASE of $10 for Carrier UPS.

Remove FLAT INCREASE of $20 for Carrier UPS Service Ground

Add New Record

Set Carrier to <ALL>

Set Service to <ALL>

Set Account Profile to <ALL>

Set Client Carrier to <ALL>

Set Customer to <ALL>

Set Effective to 01 Jan 2024

Set Discount Value to 30

Set Discount Type at PERCENT INCREASE

Creation date: 12/20/2023 8:33 AM Updated: 12/20/2023 8:33 AM

Files		Sort by Name Sort by Date
	DataImage13.png 276.2 KB
	DataImage37.png 92 KB
	DataImage37.png 76.8 KB
	DataImage70.png 132.2 KB
	DataImage90.png 257.1 KB
	image001.png 6.1 KB
	image001.png 106.9 KB
	image003.png 496 b
	image004.png 1.2 KB
	image005.png 895 b
	image006.png 1.3 KB
	image007.png 757 b
	image008.png 857 b
	image010.png 100.5 KB
	image015.png 66 KB
	image016.png 8.2 KB
	image017.png 970 b
	image018.png 682 b
	image019.png 983 b
	image020.png 781 b
	image021.png 546 b
	image022.png 950 b
	image025.png 8.2 KB
	image026.png 969 b
	image030.png 779 b
	OriginalEmail.eml 57.1 KB