Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 3 online users. » 0 Member(s) | 1 Guest(s) Bing, Google
|
Latest Threads |
Finetuning the way you se...
Forum: coreBOS Development
Last Post: alexandy40d
12-06-2024, 07:38 AM
» Replies: 4
» Views: 8,138
|
MariaDB Version
Forum: Administrator Support
Last Post: joebordes
11-01-2024, 11:49 AM
» Replies: 1
» Views: 625
|
Product Catalog / parts c...
Forum: Modules/Extension Support
Last Post: joebordes
09-15-2024, 09:40 AM
» Replies: 1
» Views: 1,107
|
Challenges and Best Pract...
Forum: coreBOS Development
Last Post: wishforbes
08-30-2024, 04:21 PM
» Replies: 0
» Views: 719
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: jonathanmoore858
08-03-2024, 04:14 PM
» Replies: 4
» Views: 2,764
|
Zapier | Integration
Forum: Modules/Extension Support
Last Post: bernardgbailey
07-29-2024, 11:45 PM
» Replies: 7
» Views: 9,846
|
Versión PHP recomendada
Forum: International
Last Post: joebordes
07-04-2024, 05:42 PM
» Replies: 7
» Views: 3,325
|
Could Someone Give me Adv...
Forum: Open Discussions
Last Post: joebordes
06-27-2024, 08:32 AM
» Replies: 1
» Views: 1,704
|
RESTRICTED FILE
Forum: Administrator Support
Last Post: inspectorflint
06-22-2024, 08:08 AM
» Replies: 7
» Views: 5,659
|
GENDOC imágenes
Forum: Open Discussions
Last Post: joebordes
06-02-2024, 05:11 PM
» Replies: 4
» Views: 2,037
|
|
|
vtws_revise changes Salesorder amounts |
Posted by: Guido1982 - 09-12-2016, 04:46 PM - Forum: coreBOS Development
- Replies (7)
|
|
I have an AJAX action in place that updates the status of a sales order when an appointment for that sales order is made in the Calendar4You. The weird thing is: the vtws_revise function I use to do this changes all the amounts. To be specific: 4.236,00 Euro's (four thousand two hundred and thirty-six) becomes four MILLION two hundred thousand Euro's (4.236.000,000). It seems somewhere number formatting is going very wrong. Any ideas on how this can be?
|
|
|
A workflow that sends an e-mail with an overview of non-invoiced sales orders |
Posted by: Guido1982 - 09-09-2016, 12:42 PM - Forum: coreBOS Development
- Replies (1)
|
|
Take a look at this repo:
https://github.com/Luke1982/sendEmailNotInvoicedSOs
It's quite rudamentary, but does the job I needed it to do. The idea: create a workflow for sales orders that gets all the salesorders with a 'Delivered' state and that are not 'deleted', of which the duedate is in the past. Then collect all invoices made for this sales order and see it the totally invoices amount is at least the sales order amount. For each sales order that has not been completely invoiced a row in a table is made. That table is sent to an e-mail address (or multiple, comma separated) and sent these addresses. At the bottom of the table is the sum of all non-invoiced amounts. I set this as a scheduled workflow, so an administrator could get a daily, or weekly overview of the sales orders that have not been completely invoiced. In the workflow config screen there is an option to limit the years the workflow looks back in time, related to the duedate of the sales order.
From the table in the e-mail, you can go directly to the sales order in the CRM.
Now we could expand on this:
- Create 'assigned user' or just a 'users' dropdown to dynamically pick the 'send to' e-mail.
- The table heads are now all in dutch hard-coded. These could come from a language file.
- The e-mail subject could be set in the config screen.
- There is currently no check to see if the CRM uses HTTPS.
- There is no currency symbol
Woops, found out that even if you schedule a workflow and do nothing with the entity, the workflow does get executed for EVERY sales order.... I just received 1000 e-mails...
|
|
|
|