Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Copy Existing Objects to new Object?
02-15-2018, 06:28 AM, (This post was last modified: 02-15-2018, 06:30 AM by VortecCPI.)
#1
Copy Existing Objects to new Object?
Is there an way in webERP to copy/clone an existing instance of Invoice, PO, or SO to a new instance of the same?

To be more specific this is for recurring monthly expenses such as rent, utilities, etc...
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-15-2018, 06:49 AM,
#2
RE: Copy Existing Objects to new Object?
I believe that I saw a recurring something or another within weberp somewhere, but I could be wrong.

I'm away from my computer at the moment, and it might be a couple of hours before I can check.
Reply
02-15-2018, 06:51 AM,
#3
RE: Copy Existing Objects to new Object?
Have you checked out the recurring sales order functionality?
Basically you create a normal order and turn it into a recurring order.
Reply
02-15-2018, 06:56 AM,
#4
RE: Copy Existing Objects to new Object?
I am aware of recurring Sales Orders but I am far more interested in recurring Invoices for expenses.

Seems like this would be a fairly easy task?
https://www.linkedin.com/in/eclipsepaulbecker
Reply
02-15-2018, 11:11 PM, (This post was last modified: 02-15-2018, 11:14 PM by VortecCPI.)
#5
RE: Copy Existing Objects to new Object?
For copy of PO we need to do the following using some data from the original PO:

1> Create entry in purchorders table
2> Create entries in purchorderdetails table
3> Increment Purchase Order in systypes table

For copy of INV we need to do the following using some data from the original INV:

1> Create entry in supptrans table
2> Create entries in gltrans table
3> Increment Purchase Invoice in systypes table

I think I can use one of the Z_Change... scripts as a template for this...

The PO copy/clone would be nice but not necessary. However, the INV copy/clone would be extremely helpful.

However... As I think about this there is no way to edit an INV so we would need a way to enter new narratives, references, etc. for the new copy prior to copy/clone...
https://www.linkedin.com/in/eclipsepaulbecker
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)