bruning
30th October 2015, 11:33
Hi All,
How to change the Packing Slip Number if we already doing the receipt ?
Thanks and Regards,
benito
2nd November 2015, 16:31
packing slip number is normally NOT something you bother to change if you made a mistake. it's just a number, change it in your paper documents and move on. if you must, go to your test environment and TRY a dal update on whinh312.psno, then check your related tables if you are successful by invoking "print references to parent".
bruning
6th November 2015, 04:19
Hi Benito,
Thanks for your answer, I need to change the Packing Slip number because when i try to matching the Invoices the Invoices doesnt match because of different Packing Slip Number, any solutions Mr Benito ?
Thanks and Regards.
benito
6th November 2015, 15:39
what is the status of your receipt? if the receipt is confirmed, then you're out of luck. if the status is open, then you can actually edit the field manually. this is the dal function that i used to test.
function extern change.packing.slip()
{
table twhinh312
string err.msg(100)
string chg.psno(100)
domain whinh.shpm i_receipt
chg.psno = "THIS_TEST"
i_receipt = "R00000260"
select whinh312.*
from whinh312 for update
where whinh312._index1 = {:i_receipt}
order by whinh312._index1
as set with 1 rows
selectdo
ret = dal.change.object("whinh312")
if ret = 0 then
dal.set.field("whinh312.psno", chg.psno)
ret = dal.save.object("whinh312")
if ret = 0 then
commit.transaction()
else
abort.transaction()
show.dal.messages(MSG.ERROR)
endif
endif
endselect
}