Recalculation of the supplier's RRP
I will describe with an example:
1. There is a product, it has a price list from the supplier, the product is in stock, there is an RRP
2. The same item is credited to the warehouse from the same supplier, there is a purchase price in the capitalization. But the supplier says to sell only at his RRP, it's like a common practice.
What's the problem, if I set the warehouse selection priority, the system will take the purchase price from the warehouse. And we need the sale to be according to the RRP, but the problem is that in the warehouse you cannot specify the RRP for the supplier and warehouse. There is only the RRP of the warehouse, but the posting can be from different suppliers.
It will probably be difficult to modify in order to indicate the supplier and the RRP for the goods in the warehouses. Can it be improved so that in such situations the RRP takes goods from the card (suppliers tab in the product)? That is, the rule works for the warehouse, but takes the price itself
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
1. There is a product, it has a price list from the supplier, the product is in stock, there is an RRP
2. The same item is credited to the warehouse from the same supplier, there is a purchase price in the capitalization. But the supplier says to sell only at his RRP, it's like a common practice.
What's the problem, if I set the warehouse selection priority, the system will take the purchase price from the warehouse. And we need the sale to be according to the RRP, but the problem is that in the warehouse you cannot specify the RRP for the supplier and warehouse. There is only the RRP of the warehouse, but the posting can be from different suppliers.
It will probably be difficult to modify in order to indicate the supplier and the RRP for the goods in the warehouses. Can it be improved so that in such situations the RRP takes goods from the card (suppliers tab in the product)? That is, the rule works for the warehouse, but takes the price itself
Answers:
Is this the situation with all goods or only with certain suppliers? If with all, then you can turn off the recalculation for warehouses and do it only for suppliers, so in the total card there will always be only the price of the supplier
22.07.2022, 12:36
Original comment available on version: ru
Da Hong Pao
OneBox production wrote:
Is this the situation with all goods or only with certain suppliers? If with all, then you can turn off the recalculation for warehouses and do it only for suppliers, so in the total card there will always be only the price of the supplier
Now it is necessary for one supplier, but later it will be necessary for others
For example:
There is a product in stock from supplier XXX and the same product from supplier YUU. We indicate the priority of the warehouse, indicate if the supplier is XXX, then consider it not at the purchase price, but at the RRP from the price list.
When recalculating, when it will take from the warehouse from this supplier, it will substitute the RRP
But it should be borne in mind that the goods may have different suppliers, for example, for the UUU supplier, it is not necessary to take the RRP, only for the XXX supplier
22.07.2022, 12:56
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Total:
If the recalculation takes place according to the warehouse and the supplier who delivered this product to the warehouse is one of those selected somewhere in the system settings and this supplier has an RRP in the product suppliers tab, then consider that this is the RRP of the warehouse in this situation.
It's 4 o'clock.
If the recalculation takes place according to the warehouse and the supplier who delivered this product to the warehouse is one of those selected somewhere in the system settings and this supplier has an RRP in the product suppliers tab, then consider that this is the RRP of the warehouse in this situation.
It's 4 o'clock.
22.07.2022, 13:24
Original comment available on version: ru
Da Hong Pao
OneBox production wrote:
Total:
If the recalculation takes place according to the warehouse and the supplier who delivered this product to the warehouse is one of those selected somewhere in the system settings and this supplier has an RRP in the product suppliers tab, then consider that this is the RRP of the warehouse in this situation.
It's 4 o'clock.
Yes, and if the RRP is not registered in the card, then the standard warehouse RRP rule is triggered, if not, then from the purchase price
22.07.2022, 15:45
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
I didn’t mean the product card, but the supplier’s RRP, i.e. from the Suppliers tab. Just in case, I'll clarify
22.07.2022, 16:04
Original comment available on version: ru
Da Hong Pao
OneBox production wrote:
I didn’t mean the product card, but the supplier’s RRP, i.e. from the Suppliers tab. Just in case, I'll clarify
I meant it, in the product card, the Suppliers tab
22.07.2022, 16:08
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Alternatively, you can use the automation for products, and through the action Calculate the value according to the formula and write in the specified field, write the RRP prices in the price field and other types of prices as necessary.
Screenshot
Screenshot
22.07.2022, 16:10
Original comment available on version: ru
Make an invoice for payment
22.07.2022, 17:03
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Paid revision
25.07.2022, 16:07
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
https://crm.dobavki.ua/app/settings/productmargin/
setting "pricerule-storage-supplier-rrc". It will not work immediately, but after about an hour if you start the recalculation not by pens for one product.
setting "pricerule-storage-supplier-rrc". It will not work immediately, but after about an hour if you start the recalculation not by pens for one product.
27.07.2022, 17:10
Original comment available on version: ru
Da Hong Pao
OneBox production wrote:
https://crm.dobavki.ua/app/settings/productmargin/
setting "pricerule-storage-supplier-rrc". It will not work immediately, but after about an hour if you start the recalculation not by pens for one product.
Checked and stated:
- Warehouse selection priority
- do not take into account the warehouse pdc
Product https://crm.dobavki.ua/app/product/21/edit/
It took the purchase from the warehouse, not the RRP from the card. But if you turn off the checkbox "do not take into account the warehouse prc", then it substitutes suppliers from the tab in the card.
As I understand it, you tied this logic to this checkbox, but we need it to be enabled, and in this case it takes not from the card, but from the warehouse, but it won’t work for us. goods in the warehouse have a RRP, but we don’t need it at all, we don’t use it, only purchases from the warehouse + suppliers in the card.
28.07.2022, 16:53
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Well, we agreed above that if there is a supplier's RRP, then set its RRP as the warehouse's RRP, respectively, if you check the box "Do not take into account the warehouse", then the RRP is not taken into account, because the warehouse RRP came from the supplier. It seems to me that this is the correct logic)
28.07.2022, 21:12
Original comment available on version: ru
rewrote so that this setting does not affect the one that was finalized in the task
28.07.2022, 21:15
Original comment available on version: ru
Everyting is ok. Thanks
01.08.2022, 09:38
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
