Great video. I have tried to apply this to a case to create an invoice number using the year as the prefix. And set the on object modify on the invoice date field. However, I have my date to setup to automatically enter creation date, therefore the script is not run. Is there a way I can link this to the date or will I have to create a new button with "Add new record" + the script.
Could you set the creation of the invoice number as an Auto Enter Calculation? If you can't then either create a button or do what I always do. In most cases you will start each invoice as a quote. This is simply a type field with the values "Quote", "Invoice" or "Credit Note". Than means that there is a Quote Date field but also an Invoice Date field. This is because there can be a lot of time between when a quote is offered and the final invoice is made. The moment you change the type from quote to invoice you can create your Invoice number. Greetings Guy
Hi Stevens. I am a big fan of you. I almost download all your video from youtube. You are really cool. I have few problem about making a multiple drop down of lineitem when I create invoice systems. For example SPU: iPhone 8, iPhone X. SKU: iPhone 8 plus 64G black, iPhone 8 plus 64G silver. iPhone X 256G silver, iPhone X 64G silver. And summary amount sold of each SKU. Maybe you can help me solve this problem.
Sounds like you need to look into Conditional Value Lists. I have a few video's about those on my UA-cam channel. You can look at those for a hint on how to proceed. The main idea is to have a table for products. Like the iPhone 8 or iPhone X. Then you need a related table for the models. Where you can note all the models for a particular phone and it's price. Once you have that you can create an invoice with line items where you select first the product. And then the model from a conditional value list that shows all the models for that product. This means you will have two ID's in your line items table. The ProductId and the ModelId. This can be used to create a rapport where you sort by product and model and you use sub summary parts to summarize the data and show totals per model. Greetings Guy
The simplest thing, well explained !! Around 20:30 the leading zero technic, so simple, but never thought of that !!
Thanks Guy, as always thanks for the new ideas and a easy way to do it
i watch and learn lot of your videos
best guy on the market!
Great video. I have tried to apply this to a case to create an invoice number using the year as the prefix. And set the on object modify on the invoice date field. However, I have my date to setup to automatically enter creation date, therefore the script is not run. Is there a way I can link this to the date or will I have to create a new button with "Add new record" + the script.
Could you set the creation of the invoice number as an Auto Enter Calculation?
If you can't then either create a button or do what I always do.
In most cases you will start each invoice as a quote. This is simply a type field with the values "Quote", "Invoice" or "Credit Note".
Than means that there is a Quote Date field but also an Invoice Date field.
This is because there can be a lot of time between when a quote is offered and the final invoice is made.
The moment you change the type from quote to invoice you can create your Invoice number.
Greetings Guy
Thank you Guy. Splendid!
Hi Stevens, I am from IRAN, and can not buy your video tutorial from UDEMY, Please send a complete serial tutorial about Invoice, thank you very much.
Sure you can buy my Udemy tutorial in IRAN.
Greetings Guy
Hi Stevens. I am a big fan of you. I almost download all your video from youtube. You are really cool. I have few problem about making a multiple drop down of lineitem when I create invoice systems. For example
SPU: iPhone 8, iPhone X.
SKU: iPhone 8 plus 64G black, iPhone 8 plus 64G silver.
iPhone X 256G silver, iPhone X 64G silver.
And summary amount sold of each SKU.
Maybe you can help me solve this problem.
Sounds like you need to look into Conditional Value Lists. I have a few video's about those on my UA-cam channel. You can look at those for a hint on how to proceed.
The main idea is to have a table for products. Like the iPhone 8 or iPhone X.
Then you need a related table for the models. Where you can note all the models for a particular phone and it's price.
Once you have that you can create an invoice with line items where you select first the product. And then the model from a conditional value list that shows all the models for that product.
This means you will have two ID's in your line items table. The ProductId and the ModelId.
This can be used to create a rapport where you sort by product and model and you use sub summary parts to summarize the data and show totals per model.
Greetings Guy
excellent thank you
Thank you Guy
Thx
excellent thank you