Hi Elychelle Gulen-Oracle and Tafara, Thank you for your advice. I used Override Sublists feature in CSV Import, I could remove USD cost of vendor B. But the HKD of vendor B is still there. The HKD of vendor B was actually was I need to remove. I repeated the step, but not working. Finally, I manually edit and remove the…

 @MTL_MI Hi, Sorry for my oversight. Your Answer is helpful, now I understood how the calcuation happened. I will study about "Balance Location Costing Group Accounts". Thank you 🤗 Ely Gulen-Oracle , Thank you for reminding 😘

Hello @MTL_MIA , I had set the group average cost. Please see below image. I issued PO and item receipt to location 1 (location 1 is our main warehouse), and then transfer the stock from Location 1 to others location 2 / 3/ /4 . When I issue sales order from location 2, the COGS will be $64.14. That's make sense as what I…

Hi @Katerina Winklerova-Oracle, Thanks for your answer. I forwarded to my financial colleague. She followed you suggestion, and it work and successfully settled the credit note. Thanks ❤️

Hi @Niks Blando-Oracle , Thanks for your help. you might misunderstand the express of table, it means if discount price is blank, it will take 289 without any change. If discount price has value, it will take discount price 285 * 0.75. Actually, I want to calculate the D first, and then F column is the final I need.…

Hello, I just submitted the same issue. My scenario is there are no any bill payment, only one bill credit in large amount. We terminated the cooperation with the vendor, that means no any new bill payment will be happend. What can I do?

Hi Lea and Katerina, I solved it, thank you for help. Cheers !! ❤️

Hi Joahnna, Thanks for following up. I found the the column with SKU value, because the item receipt created from return authorization is without the SKU field. That's why no value bring to the save search report. I have asked our collegaue to add the field into the related page. If still have questions, we will let you…

Hi Dominica, Thanks for reply. After marked the Descending checkbox, it is working now. Thanks. I found a interesting thing, when I added Date = on Today under the Criteria tab, the item SKU column is empty value. After I removed "Date = on Today " , the item SKU could be shown on report. And, below cap screen is the…

Hi Dominica, Thanks for your feedback. Yes, it is saved search report. I tried to sort by date and unmark the descending checkbox, but still not working. It should be simple question, I also referred to other reports, all simply sort by Date ?, but I have no idea why didn't work in this report. And, filter Date = on Today.…

@Ely Gulen-Oracle @Steve Barrett Thank you so much for your help. Steve's suggestion is working for me. Even it is not the direct download link, but i can directly access to the file, open by browner and press the download button. it is much help and save time for me. Another suggestion by Ely is 'File Cabinet" , haha , it…

Hi Patrick, Thank you for your reply. By using importing a vendor price list solution, as result, I could add the CNY cost only, not able to replace the wrong currency USD. Therefore, I will take your 1) solution , to manually change. ? Thanks alots

Hello, Enhancement 135047 was in 2014, any update about how to remove the item pricing for particular customer? I was not able to find answer here. Please advise. Thanks.

Hi Ivy, After added account is inventory , it solved. Thank you very much.

Hi Ivy, May I have my last question . Originally, the result is showing 4 lines , and then I added Main line is false, it is ok, but still show 3 lines for each SKU. How can I remove the 2nd and 3rd showing cost of good sold and inventory. Thank you in advance.

Hi Ivy, I change to Location field , it works now. Thank you.

Hi Ivy, Thank you for your prompt reply. I do as per your guideline, but only show the Inventory transfer in result. I tried to change “OR’ to ‘And” , but not working.