automatic fuel write-off
2020-10-19 13:53:43
The client has a gas station and has a filling station, at the end of the day the client uploads payment data in xls format (there are fields: discount, amount, date and displacement)
you need to upload this file to the box so that these data are displayed in actual payments + taking into account the sold liters of fuel, automatic write-off from the warehouse should occur. Is it possible?
Original question is available on version: ru
you need to upload this file to the box so that these data are displayed in actual payments + taking into account the sold liters of fuel, automatic write-off from the warehouse should occur. Is it possible?
Answers:
For a more correct assessment, you need an example file or a description of most of the columns.
Because there are questions:
1. Will there be columns to identify a customer for making a payment and selling?
2. Will there be a column to identify the product to be scrapped?
In theory, I can offer you the development of an automatic action once an hour, which will have settings for defining columns for searching for a client / product, as well as data on debiting and payment - such an action is about 12 hours.
Because there are questions:
1. Will there be columns to identify a customer for making a payment and selling?
2. Will there be a column to identify the product to be scrapped?
In theory, I can offer you the development of an automatic action once an hour, which will have settings for defining columns for searching for a client / product, as well as data on debiting and payment - such an action is about 12 hours.
19.10.2020, 14:09
Original comment available on version: ru
Theoretically yes
We can upload processes to the system via xls by loading both regular fields and additional ones.
It can be configured in such a way that when filling the process, the system itself adds the product, and takes its quantity from the additional. process fields (that is, from a column in excel)
+ You will NEED to make a setting that would automatically add the product to the process with the right amount, and then write it off from the warehouse.
thus, each line will be a separate process with its own data (as a separate check) and the necessary product will be written off based on it.
If there are several types of gasoline, then it will be necessary to complete the conditions, but this is possible)
We can upload processes to the system via xls by loading both regular fields and additional ones.
It can be configured in such a way that when filling the process, the system itself adds the product, and takes its quantity from the additional. process fields (that is, from a column in excel)
+ You will NEED to make a setting that would automatically add the product to the process with the right amount, and then write it off from the warehouse.
thus, each line will be a separate process with its own data (as a separate check) and the necessary product will be written off based on it.
If there are several types of gasoline, then it will be necessary to complete the conditions, but this is possible)
19.10.2020, 14:24
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
