search

3ktech / General

2 stars 0 forks source link

Report of purchase price/sale price/master price statewise wise item number wise for a period #1454

Closed Jayanth3KT closed 3 months ago

TabrejAlam3K commented 5 months ago

<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">

Sale | Period |   |   |   |   |   |   -- | -- | -- | -- | -- | -- | -- | -- Item | Description | Uom | Quantity | Unit Cost | Rate | State Code

TabrejAlam3K commented 5 months ago

Required two different reports. Format we have attached.

CAS-02198-P2T2N5.xlsx

  1. Sales Price Report
  2. Purchase Price Report
TabrejAlam3K commented 5 months ago

Hi @johnbosco3K - You can start your activity, we got approval from the client.

Image

TabrejAlam3K commented 5 months ago

Hi @johnbosco3K - Please provide updates on this.

johnbosco3K commented 5 months ago

Unit price issue is fixed.

TabrejAlam3K commented 5 months ago

Hi @johnbosco3K - See and fix the below issues.

  1. Purchase Price Report - Fix the state code issue, it is currently coming as blank.
  2. Sales Price Report - Fix the unit price issues, Currently the unit price value is coming in wrong.
johnbosco3K commented 5 months ago

Have you tried any new transaction to test the report?

johnbosco3K commented 5 months ago

Image

TabrejAlam3K commented 5 months ago

We are not able to complete the UAT because Mr. Srinivasan is on leave today. CC : @audhi3k

TabrejAlam3K commented 5 months ago

Hi @johnbosco3K - we got the approval on this ticket, you can start your development activity.

  1. Purchase Price List - Technical Hrs 12
  2. Sales Price List - Technical Hrs 10

CC : @audhi3k

johnbosco3K commented 5 months ago

Hi @TabrejAlam3K , New Format Attachment is not available. Please add here

CC: @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - I have attached the new Excel format as per our discussion. See below.

Purchase Price and Sales Price.xlsx

CC : @audhi3k

johnbosco3K commented 4 months ago

Hi @TabrejAlam3K , This attachment is old format, can you add new. CC: @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K

Posted Collection Apportionment (1).xlsx Posted Billing Apportionment (1).xlsx

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - I have done the internal testing on the below report. There are a few things we need to correct.

  1. Purchase Price Report Tons - It should be in two decimal places. Amount in Cr INR - It should be in two decimal places. Price per KG - It should be in two decimal places.

CC : @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - Please updade on this, this is priority task which we was expecting to close by today. CC : @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - As discussed, Data is not coming properly as per the posted transaction.

Image

CC : @audhi3k

johnbosco3K commented 4 months ago

Hi @TabrejAlam3K , Data are fetched from Purchase Invoice Line only. You are checking item ledger entries.

CC: @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - Sales Price Report format required just like Purchase Price Report format, currenlty format is not coming correctly, Please correct it and let us know.

CC : @audhi3k

TabrejAlam3K commented 4 months ago

Waiting for client Mr. Srinivasan response on this.

CC : @audhi3k

TabrejAlam3K commented 4 months ago

Hi @johnbosco3K - Custome report not reflecting in the UAT Environment. Please check and publish the extension.

CC : @audhi3k

TabrejAlam3K commented 3 months ago

Image

TabrejAlam3K commented 3 months ago

Hi Mr. @johnbosco3K - Please plan to move the below report into the proudction.

  1. Purchase Price Report

CC : @audhi3k

TabrejAlam3K commented 3 months ago

Hi @johnbosco3K - As discussed and informed, Please deploy this changes into the Production.

CC : @audhi3k

TabrejAlam3K commented 3 months ago

Hi @johnbosco3K once you deployed the latest changes into the production, Please let us know.

CC : @audhi3k

TabrejAlam3K commented 3 months ago

We got the closure confirmation on this from the client side, Now we can close the support ticket.

Image

CC : @audhi3k