Welcome, Guest |
You have to register before you can post on our site.
|
Online Users |
There are currently 790 online users. » 2 Member(s) | 788 Guest(s)
|
Latest Threads |
[RESUELTO] - Tipo de impu...
Forum: Administrator Support
Last Post: joebordes
3 hours ago
» Replies: 13
» Views: 7,816
|
little bug trasformin LEA...
Forum: Administrator Support
Last Post: payalbatra
04-23-2024, 06:57 AM
» Replies: 4
» Views: 3,573
|
como manejar github en un...
Forum: International
Last Post: ntermacabre
04-10-2024, 03:52 AM
» Replies: 2
» Views: 1,212
|
whatsapp
Forum: User Support
Last Post: Yash
04-03-2024, 09:26 AM
» Replies: 2
» Views: 6,076
|
PRODUCTS IN ACCOUNTS BY O...
Forum: User Support
Last Post: joebordes
03-31-2024, 11:04 PM
» Replies: 1
» Views: 360
|
Attachment in e-mail not ...
Forum: User Support
Last Post: julikarole
03-13-2024, 05:59 AM
» Replies: 2
» Views: 1,142
|
Mail Manager - Options Se...
Forum: Administrator Support
Last Post: joebordes
03-06-2024, 11:52 PM
» Replies: 16
» Views: 18,348
|
Intermittent issues after...
Forum: User Support
Last Post: joebordes
03-06-2024, 11:44 PM
» Replies: 9
» Views: 1,646
|
Custom Columns in Mail Ma...
Forum: Modules/Extension Support
Last Post: joebordes
03-06-2024, 11:42 PM
» Replies: 1
» Views: 2,163
|
[Solved] Gendoc - Contact...
Forum: Administrator Support
Last Post: geraldbigot
02-10-2024, 08:32 AM
» Replies: 2
» Views: 923
|
|
|
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...
|
|
|
|