looking for advise for duplicate a sales order record

[wei243]

Re: looking for advise for duplicate a sales order record

Oh ya...Thanks a lot~

[GGandhi]

Re: looking for advise for duplicate a sales order record

this is an interesting thread. I see in my business many times there is a button to reorder previous order and there is a position to alter previous order or cancel without proceeding, if change my mind.
the examples in this thread seems to create the duplicate without any option of cancelling. ( I could be wrong.)
I am thinking..
is it better to create a temporary table and populate a single record and dependent child, modify whatever needs to be modified and update the master table only if wanted to continue or discard the temporary table?

[Michael1954]

Re: looking for advise for duplicate a sales order record

The code is in javascript, the duplicate is in memory, you can edit before you submit. You do not need to submit.
If you look at a program like "Inflow" it creates a duplicate for every edit, this gives a full audit trail.
The downside is disk space and speed.
So it is very much horses for courses.

[wei243]

Re: looking for advise for duplicate a sales order record

Yes. Thanks Michael for sharing your knowledge.

[cptutrecht]

Re: looking for advise for duplicate a sales order record

Might this be what you are looking for (if you can use a dialog)

{dialog.object}.newRecord({cloneExisting: true, fieldsToNotCopy: 'INVOICE_NUMBER','CUSTOMER_ID'});
see http://wiki.alphasoftware.com/%7Bdia...wRecord+Method

[Michael1954]

Re: looking for advise for duplicate a sales order record

Ger

If this creates a new record, will the primary key be available to bind to the repeating section child records?
The problem I have had trying to answer this thread is populating the repeating section, I could not find a way of "automating" it, instead I opted to loop the original record set.
Can this function be used in the parent child set up?

Michael

[cptutrecht]

Re: looking for advise for duplicate a sales order record

Hi Michael,

I don't know and and haven't the time right now to figure it out..
But as so often i do something the way i can instead of figuring out what is sometimes the perfect way.

My use case was a function for countersales of different articles for the same customer.
So i created a dialog with 2 tabs
1e tab. Create new record, one at the time (with the dialog.newrecord() method)
2e tab list of created records (embedded grid) with possibility to search / filter / edit records created

For my use case this works as a charm....

Hope this helps

[-Jinx-]

Re: looking for advise for duplicate a sales order record

I have a dialog with 2 repeating sections where I give the user the option to copy/duplicate the current record. I currently use XBasic to do this along with the populate Javascript method, but I'm interested in Ger's option and will check it out for the next dialog I do that requires this.