Take into account the exchange rate difference when selling goods
https://rozpakui.crm-onebox.com/
We need to take into account the exchange rate difference between the rate at posting and the sale of this batch (this posting).
x - the price of posting goods in UAH
k1 - the rate of usd-UAH on the date of posting the party
k2 - USD-UAH exchange rate on the date of sale
exchange rate difference \u003d x (1-k2 / k1)
For example:
If the quantity of a product in an order is >1 and it is written off from different batches, then when selling the CR (exchange difference) is calculated for each batch and summed up
In the order Scarf 4 pcs.
when selling - writing off 3 pieces from lot No. 1 from date No. 1 and 1 piece from lot No. 2 from date No. 2
for each batch, CR1 and CR2 were calculated and their sum was registered in a separate field of the order (CR)
if in the order of commodity items> 1, then the CR is calculated for each and for lots (if different)
That is, in this way we calculate the exchange rate difference, then you need to see it in the rep
Original question is available on version: ru
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
We need to take into account the exchange rate difference between the rate at posting and the sale of this batch (this posting).
x - the price of posting goods in UAH
k1 - the rate of usd-UAH on the date of posting the party
k2 - USD-UAH exchange rate on the date of sale
exchange rate difference \u003d x (1-k2 / k1)
For example:
If the quantity of a product in an order is >1 and it is written off from different batches, then when selling the CR (exchange difference) is calculated for each batch and summed up
In the order Scarf 4 pcs.
when selling - writing off 3 pieces from lot No. 1 from date No. 1 and 1 piece from lot No. 2 from date No. 2
for each batch, CR1 and CR2 were calculated and their sum was registered in a separate field of the order (CR)
if in the order of commodity items> 1, then the CR is calculated for each and for lots (if different)
That is, in this way we calculate the exchange rate difference, then you need to see it in the rep
Answers:
If the quantity of a product in an order is >1 and it is written off from different batches, then when selling the CR (exchange difference) is calculated for each batch and summed up
and if 1 or from one party?
31.03.2021, 15:26
Original comment available on version: ru
Tyndyk Maxim Vadimovich wrote:
If the quantity of a product in an order is >1 and it is written off from different batches, then when selling the CR (exchange difference) is calculated for each batch and summed up
and if 1 or from one party?
If 1 or from one party - CR will be calculated for one of this party.
05.04.2021, 12:58
https://qube-soft.com/ crm erp onebox qubesoft внедрение аналитика 1с интегратор
Original comment available on version: ru
It is better to do this as a separate report (as a block in the constructor) - it will take about 12 hours
It is probably better to make the report not read anything until a date interval is selected (for example, by the date of creation of processes, or warehouse operations) and BP of processes
It is probably better to make the report not read anything until a date interval is selected (for example, by the date of creation of processes, or warehouse operations) and BP of processes
05.04.2021, 15:24
Original comment available on version: ru
Tyndyk Maxim Vadimovich wrote:
It is better to do this as a separate report (as a block in the constructor) - it will take about 12 hours
It is probably better to make the report not read anything until a date interval is selected (for example, by the date of creation of processes, or warehouse operations) and BP of processes
OK, by date of warehouse transactions, you mean by date of sale of goods in progress? If yes, then it fits.
07.04.2021, 11:17
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 2025
