Question: Bulk Upload Purchase Using Csv

Bulk Upload Purchase Using Csv

Bulk upload purchase using csv is showing price difference, Product Code Net Unit Cost Quantity Product Variant Tax Rate Name Discount Expiry 111111 80.48 1

SS

sikarwar software

Asked
Bulk upload purchase using csv is showing price difference,
Product Code Net Unit Cost Quantity Product Variant Tax Rate Name Discount Expiry
111111 80.48 1 5

when i am uploading this , its showing 80.31 purchase price

why is there a diffence of minor price
  • SS

    sikarwar software

    Answered
    In uploading via CSV
    Net Unit Cost - passing here supplier price defined in product details.
    and the Tax applied in it 5% Inc.
    But It's adding tax amount to the grand total amount
  • MS

    Mian Saleem

    Answered
    Hello,

    How if you add the purchase (not with csv)? Do that calculate the tax same?

    Please zip and attach the csv file with reply so that I can test.

    Thank you
  • SS

    sikarwar software

    Answered
    Hey,
    When I update the purchase, not by CSV it's working fine.
    Here is the CSV I tried to upload and a live uploading video.
  • SS

    sikarwar software

    Answered
    One more example
    CSV https://prnt.sc/x6y8b9
    Product Code 100100100
    Net Unit Cost 80.43
    Quantity 1
    Product Variant null
    Tax Rate Name 5
    Discount Expiry null
    Supplier price in product master is INR 80.43 https://prnt.sc/x6ykz0

    RESULT
    IF imported using csv then result is https://prnt.sc/x6y43e { ITS SHOWING VARIATION IN PRICE 80.25~80.43~84.26}
    when same product is marked for purchase without using csv then result is https://prnt.sc/x6yczj (PURCHASE PRICE IS CORRECTLY FETCHED FROM PRODUCT MASTER I.E 80.43
  • SS

    sikarwar software

    Answered
    How if you add the purchase (not with csv)? Do that calculate the tax same?
    Ans,without using csv i takes the supplier price from product master https://prnt.sc/x6zoy6 and breakup same in taxation
    like 80.43 is divided as https://prnt.sc/x6yczj,
    it works perfectly fine
  • MS

    Mian Saleem

    Answered
    Hello,

    Let me check and I shall fix it in next update.

    Thank you
  • SS

    sikarwar software

    Answered
    please let me know if you find some issue in this,
    secondly can u fix this for me bcz it would be difficult for me to wait for next update for this particular issue
  • MS

    Mian Saleem

    Answered
    Hello,

    It will take time to investigate and figure out the case. I am sorry as I don't have any instant fix.

    Thank you
  • MS

    Mian Saleem

    Answered
    Can you please help me test it again on live demo? Thank you
  • SS

    sikarwar software

    Answered
    ok, will do that in sometime, btw i figured out , it was a calculation bug, i have resolved it
  • Login to Reply