Hey,
i want to ask if its possible to implement easy optional sales items?
regards, daniel
1 Like
Can you go into more detail what you mean by optional sale item? Perhaps a use case example?
Hi, what i mean is pretty simple.
In the quotations i want to add items with a flag optional.
When the flag optional is activated, they should be excludet from the total amount and i want a new line on the print with a total includet the optional items.
I hope i could describe it so you know what i mean?
regards and thx
can be done via Customize Form.
I would add the optional items in a separate table. then it doesnt interfere with totals calculation.
Thanks @Daniel_Grammer for requesting this feature, it also makes sense to me and I would love to have it implemented as default in ERPNext.
I agree we could easily implement in with the customize form, but It’s still something that I believe multiple user are facing, therefore it could be in ERPNext itself.
avc
February 15, 2023, 8:08pm
6
Hi:
There is a fantastic work in progress about this. See this related PR on Github .
Seems it would be merged soon.
frappe:develop
← frappe:alternative-items-quotation
opened 10:58AM - 30 Jan 23 UTC
> **Note:** Not to be confused with DocType "Item Alternative"
Resolves https… ://github.com/frappe/erpnext/issues/33609
<details>
<summary>Impact on Quotation</summary>
> **Note:** It is important to maintain the right order i.e. Alternative Item rows must follow a Non-alternative item row. Grouping will be done on this basis
> <img width="350" alt="Screenshot 2023-02-06 at 4 38 13 PM" src="https://user-images.githubusercontent.com/25857446/216957147-a47d4c5c-4390-477a-9abb-a7d0ed3bb76e.png">
- Users can add an alternative item in the Quotation to give the customer a chance to choose among items in the quotation
- To add an alternative item: add a row and check **Is Alternative**
<img width="966" alt="Screenshot 2023-02-06 at 4 31 18 PM" src="https://user-images.githubusercontent.com/25857446/216955223-6f564c53-3abf-4455-973d-a035f254bc06.png">
- **Totals**: Only consider original (non-alternative Item)
<img width="1039" alt="Screenshot 2023-01-31 at 5 02 44 PM" src="https://user-images.githubusercontent.com/25857446/215748953-8f4846d1-12cd-4617-8216-1c0c89ec5431.png">
- **Taxes**: Applied accordingly
<img width="1034" alt="Screenshot 2023-01-31 at 5 03 45 PM" src="https://user-images.githubusercontent.com/25857446/215749139-91e4ca04-4aa7-4fcc-9d7e-9d91afaf7ecc.png">
</details>
<details>
<summary>Mapping to Sales Order</summary>
Consider:
<img width="1026" alt="Screenshot 2023-01-31 at 5 05 31 PM" src="https://user-images.githubusercontent.com/25857446/215749415-0d1c179e-8543-41af-a1f4-755f9811bd37.png">
- User will be asked to select an item from among the original-alternatives set, to map in the Sales Order

- One of the alternatives is selected, the same is mapped and the rest in the set are skipped. Apart from that the simple items are also mapped:

</details>
<details>
<summary>Use Cases</summary>
- Item Code has alternatives which are different Items
<img width="1014" alt="Screenshot 2023-02-06 at 4 51 28 PM" src="https://user-images.githubusercontent.com/25857446/216959057-4718ee10-58e1-4167-9c5e-71bb6b6081a7.png">
- Service Item has alternatives and non-alternatives sharing the same Item code. The case here is that the service costing is very dynamic and subjective and so the **same code** with different Item name/Description is used in the Quotation.
<img width="1027" alt="Screenshot 2023-02-06 at 4 53 46 PM" src="https://user-images.githubusercontent.com/25857446/216959394-6ccc4ee2-b412-4a5b-b3b5-5e2ff7e194e8.png">
</details>
### Todo
- [x] Partially ordered status
- [x] Tests
Hope this helps.
2 Likes
Thanks this PR is definitely moving the project in a nice direction. From my understand it adds the possibility to create alternative item but not optional ones. @avc do you see a hack to use it for optional item as well?
I have on the quotation an additional table, optional_items.
Just needs to be added to the print format - as in my usecase there is no need to add it to any of the calculations.
avc
February 16, 2023, 6:01pm
9
I think actually alternative and optional items are pretty similar concepts.
I mean you could use alternative item as “optional” item
Quote:
1 LAPTOP HP ------- 500$
1 HP 23" MONITOR - 600$ (OPTIONAL)
TOTAL -------------- 500$
Print format can be used to “paint” the optional mark (as symbol, word …), and sum optional items …
From my understanding there is a slight difference since setting it as you suggest @avc , when the client selects the HP Monitor, it would remove the Laptop instead of just adding the monitor. We would then endup with a total of 600$ instead of 1100$.
@avc any update regarding this post? Or am I misunderstanding how it should be used?
avc
May 9, 2023, 9:50pm
12
Hi @Charles1 :
PR mentioned above is merged. I’ve tried it and it’s working well as intended (alternative).
As far I know, your specific requirement needs customization. You can see something like this on Manufacturing and Item alternative approach …
https://docs.erpnext.com/docs/v13/user/manual/en/manufacturing/item-alternative
Hope this helps.
Thanks @avc I will do some customization then
1 Like