Dear All,
I have huge transaction in SOP, in Order document balance qty is exist in 'Qty to Invoice' field, I would like to move that qty to 'Qty Canceled' field in order to control and stop the delivery of the qty from old orders.
Is there any tools to fix this at mass documents against Customer ID and document date?
GP - 9, SQL Server 2000, Windows Server 2003
Thanks
Regards
Sukumaran N.
*This post is locked for comments
Dear Leslie,
Working fine after remove the 'Type to line' from macro. Thank you very much for your help.
Regards
Sukumaran
Sorry - I left out a step,
You need to remove the TypeTo line. If you are using mail merge you could create your source to read the existing data and set the TypeTo field yourself.
Kind regards,
Leslie
Hi Leslie,
Thanks for your reply. Macro will work, macro is much more easier than manual entry.
When I tried from the macro, its working for the first line of item in the SOP windows. When I move to next line of items the value is changed. While creating macro first line of items details stored in the macro, when its move to next items macro apply the stored value which is not correct. Please check the following macro and error message:
# DEXVERSION=9.00.0068.0 2 2
CheckActiveWin dictionary 'Adsani Customization' form 'SOP_Entry' window 'SOP_Entry'
# Key 1:
MoveTo line 1 scrollwin 'Line_Scroll' field 'QTY To Invoice'
CommandExec form BuiLtin command cmdEditSelectAll
CommandExec form BuiLtin command cmdEditCopy
# Key 1: 'ROM056798', '2', '0', '114688'
TypeTo line 1 scrollwin 'Line_Scroll' field 'QTY To Invoice' , '0'
# Key 1: 'ROM056798', '2', '0', '114688'
MoveTo line 1 scrollwin 'Line_Scroll' field 'QTY Canceled'
CommandExec form BuiLtin command cmdEditSelectAll
CommandExec form BuiLtin command cmdEditPaste
# Key 1: 'ROM056798', '2', '0', '114688'
TypeTo line 1 scrollwin 'Line_Scroll' field 'QTY Canceled' , '100'
# Key 1: 'ROM056798', '2', '0', '114688'
MoveTo line 1 scrollwin 'Line_Scroll' field 'Scroll Next Button'
# Key 1: 'ROM056798', '2', '0', '114688'
ClickHit line 1 scrollwin 'Line_Scroll' field 'Scroll Next Button'
# Key 1: 'ROM056798', '2', '0', '131072'
MoveTo line 1 scrollwin 'Line_Scroll' field 'QTY To Invoice'
Error message:
1. Windows not active(Line # 18)
2. Quantity option cannot exceed total Items quantity. Please enter neq quantity.
Best regards,
Sukumaran N
Hi Sukumaran,
Since this is something done from the UI, and there is not tool to do it, then I would call on the 'Mail Merge' macro. I'm not clear if this is a single order or multiple orders. No matter, if you want to make the qty fulfilled = 0 and the Qty to invoice = 0 and the Qty Cancelled to equal whatever the Qty to Invoice used to be, you can do this with a macro. Your macro will need to:
Copy the qty to invoice to the clipboard (edit select all and then edit copy),
Change the quantity fulfilled to 0,
Change the quantity to invoice to 0 and then
Paste the qty that used to be in Qty to Invoice into Qty Cancelled (edit select all and then edit paste).
Give this a try.
Kind regards,
Leslie
Dear Richard,
No problem to do manual if there is less transaction, In our case transaction is lot, doing manual is very tough one.
Thank you for your reply.
Regards
Sukumaran N.
Dear Jegneedhi,
Override the shortage qty option will work when I transfer the Order to Invoice at that time it will work against stock available qty.
In our case balance qty in Order means is the balance qty of Purchase Order qty. Once purcahse order validity is over or some other reason to stop the delivery permanently we have to change the 'invoice to qty; status to 'Cancelled Qty'. I do not think any other third party tool is available in this issue.
Thank you for your response.
Regards
Sukumaran N.
No, sorry, it is a manual process.
Sukumar,
In my understading, during the SOP creation you have given "override the shortage qty" for balance qty. but now you
want to cancel that Qty. Or Otherwise have you created the SOP using 3rd party integration tool.
You can do it through back end . But it is not a recommended one. Otherwise you can use eConnect.I don't think any other thirty party tool are availble to this requirement.
Regards
Jeganeedhi
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (