-
Notifications
You must be signed in to change notification settings - Fork 1
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Electrolux Orders Not Showing Additional Charges in Price/Cost Tabs #466
Labels
bug
Something isn't working
Comments
@nmfujimoto updated the latest csv for Price/Cost to resolve the issue. |
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 ***@***.***> wrote:
Assigned #466 <#466> to
@prashantaggarwal1999 <https://github.com/prashantaggarwal1999>.
—
You are receiving this because you were assigned.
Reply to this email directly, view it on GitHub
<#466 (comment)>, or
unsubscribe
<https://github.com/notifications/unsubscribe-auth/AMWSHEWWGONDNUD6GRMHEFDTBVS6ZANCNFSM4YP3ZEGQ>
.
--
Prashant Aggarwal | Technical Architect | Cell: +91 8095003187
*Dream**O**rbit **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
- 31st March 2021
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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.
The text was updated successfully, but these errors were encountered: