+- webERP Forum (http://www.weberp.org/forum)
+-- Forum: webERP Discussion (/forumdisplay.php?fid=1)
+--- Forum: How To ? (/forumdisplay.php?fid=6)
+--- Thread: question on debtortrans (/showthread.php?tid=221)
question on debtortrans - jamie.cordingley - 05-11-2012 01:10 AM
Hi All, my company has been messing around with weberp for a couple of years now off and on to look at moving towards using it.
basically im confused with debtortrans, i understand how invoices are entered etc, but im unsure as to how they reference orders. obviously in debtortrans there is order_, but for example if we required a reprint how would it now which sales order lines are to which invoice?
Thanks
Jamie
RE: question on debtortrans - phil - 05-11-2012 12:03 PM
It links against stockmoves .... transtype=10 for invoices to get the lines. There is also a link required to orders because the order is the only place where the delivery address that the order is to be shipped to is held
RE: question on debtortrans - jamie.cordingley - 05-11-2012 08:24 PM
(05-11-2012 12:03 PM)phil Wrote: It links against stockmoves .... transtype=10 for invoices to get the lines. There is also a link required to orders because the order is the only place where the delivery address that the order is to be shipped to is held
So to join on stockmoves, it has a stockmove type of 10, and then just looks at the trans no for the invoice number and the reference field for the sales number?
is this correct sorry?
RE: question on debtortrans - phil - 05-11-2012 08:29 PM
Have a look at the script:
http://web-erp.svn.sourceforge.net/viewvc/web-erp/trunk/PrintCustTrans.php?revision=5239&view=markup