search

meridianww / M4PLBase

0 stars 1 forks source link

Electrolux Orders Not Showing Additional Charges in Price/Cost Tabs #466

Open nmfujimoto opened 3 years ago

nmfujimoto commented 3 years ago

The new orders in Electrolux do not show all the additional charges for services in the data feeds. The only charge shown is the Delivery charge.

nmfujimoto commented 3 years ago

In the example below, Job ID 302492 has 2 services shown in the cargo records but only the delivery charge in the Price/Cost tabs.

image

Cargo records: image

Electrolux Program Charge Codes, 22178 is 50TSPANDSCBLOGSET charge code: image

prashantaggarwal1999 commented 3 years ago

@nmfujimoto updated the latest csv for Price/Cost to resolve the issue.

prashantaggarwal1999 commented 3 years ago

Hi Nathan,

As discussed this issue was due to the wrong data which was present for the Program Price/Cost codes. I have imported the latest data from CSV you provided and synced the rates from NAV. After that when I saw there were 83 records present in the DB which are created in last 30 days, I used the below query:

Select * From dbo.JOBDL000Master Where ProgramID=20099 AND StatusId=1 AND DateEntered > GetDate()-30 AND JobSalesInvoiceNumber IS NULL AND JobGatewayStatus NOT IN ('Delivered', 'POD Completion') Order BY ID DESC

Now all the records are processed and data is corrected for all. There was one more issue I got while processing the data, for one charge Title was "Gas Line Connections Install (with Appliance install)", it has 53 characters whereas the table only has a length of 50 for the title. I have increased the Length to 100 on program and job level tables. It is not done on staging as it will automatically reflect once we will restore the DB from production to staging.

You can review the data today and confirm, if everything is ok then we will restore the same DB on staging. Jobs for which Price/Cost Data Updated as follows:

306246 302492 305365 306230 295259 304390 306245 302491 305364 306229 295258 304389 306244 301523 305363 306228 295257 304388 306243 300583 305362 306227 295256 303437 306242 300582 305361 306226 295253 303436 306241 300577 305360 306224 295252 303435 306240 300576 305359 306223 295249 303434 306239 300574 305358 306222 295248 303433 306238 299572 305357 306221 289493 303432 306237 299570 305356 306220 288568 303429 306236 298868 305355 303428 303426 303424 306235 297111 305354 303427 303425 304392 306234 297110 305353 306232 297105 304391 306233 297106 305352 306231 297103

On Wed, Mar 3, 2021 at 4:15 AM nmfujimoto notifications@github.com wrote:

Assigned #466 https://github.com/meridianww/M4PLBase/issues/466 to @prashantaggarwal1999 https://github.com/prashantaggarwal1999.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/meridianww/M4PLBase/issues/466#event-4398482242, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMWSHEWWGONDNUD6GRMHEFDTBVS6ZANCNFSM4YP3ZEGQ .

--

Prashant Aggarwal | Technical Architect | Cell: +91 8095003187

*DreamOrbit *A Deloitte Technology Fast 50 Company http://dreamorbit.com/deloitte-recognized-dreamorbit-among-top-500-emerging-technology-company-in-india/

Logistics & Supply Chain Technology | www.dreamorbit.com

Upcoming Holiday : 29th March 2021 | Next Planned Leave : 22nd March 2021