Hello,

You can add 1 return per purchase order from actions button on list purchases page.

Thank you

Can you give me an example how to do the return ? Also it would be nice if we have a separated return to supplier and we can see the report. I mean like “List Return Supplier” something like this.

Hello,

Please go to list purchases and then click action for any purchase, you will have add return option in dropdown/popup menu.

I can’t promise but will check about open returns for supplier in future updates.

Thank you

I forgot to mention in the database for purchase it has “quantity_balance” and 1 product will have a lot of purchase. How can i know which one has quantity left and which one is not ? Or i can just choose randomly from one of the purchase ?

For example “Product A” have 5 purchase. Purchase 1 - 5 I need to return “Product A” so what i need to do is find any Purchase 1 - 5 and choose 1 to return it ?

Hello,

You should not do anything directly to your database. You can edit purchase or add return from list purchasespage.

The quantity column is quantity orders while quantity_balance is not sold (available) quantity.

Thank you

I know, i just saw that column. Lets say the case goes like this.

I have

• Purchase 1
• Purchase 2
• Purchase 3
• Purchase 4

All of that purchase have “Product A” that i want to return. My question is which one should i select ? Or i can just choose any one of them from Purchase 1 to Purchase 4 ?

Hello, I have no clue which one to select. It all depends on your inventory accounting method. That will be quite difficult, if the purchase sis already used to sell the products.

I see, if my accounting method “Average Cost” what do you think ? Can i select any ? Or maybe i can just select the newest one ?

I also tried the return and here are the screenshoot.

The product cost is 6250 and i returned 22 Pieces. So 6250 * 22 = 137500 and substract the total 181250 it should be 43750 not 5000 right ? I remember i leave the order discount zero but when i submit the return it has order discount which make the total to 32500.

Hello,

I am not sure. For AVCO you can change any record but then you will need to update the avg_cost in sma_warehouses_products table.

There shouldn’t be any discount if not added 😦 Please let me know the steps to replicate it on demo.

Thank you

Is it alright if i modified it directly from the database ?