Sales Order Sort Line Items
Hi,
I have a question regarding the functionality that SAP B1UP can offer in terms of automation.
I believe this is possible, but I wanted clarification.
So what I am trying to achieve is to use B1UP to sort the items in a sales order. Using macros to check a value in the sales order item matrix against the value below and then move the line down if necessary.
For example:
Line Item 1 has a UOM Code of UNIT
Line Item 2 has a UOM Code of CTN
I want the macro to check the first line and compare it to the line below.
If the first line is UNIT and the second line is CTN, then to move the line down by using the click command to click on the RSRC ButtonDown button.
Otherwise do nothing and move on to the next line.
Ideally once this is all done, the entire sales order will be sorted so all the items with a UOM code of CTN will be at the top and the items with UNIT will be at the bottom.
I believe I will need to use the line loop feature.
Please someone get back to me when they get the chance.
Cheers.
Phil
-
Hi Phil,
A few options:- You could update the Crystal Report to print the lines on the Sales Order in your custom order different than what displays.
- Your macro could cache the data from the entire order, delete the lines and re-enter them in the new order.
Keshava -
SAP has an up arrow and down arrow that allows you to move lines up and down in the Sales order window.
You can select the line you want to move and then just click on the up or down arrow and it will move the entire line either up or down.
We do this currently, just manually and it can be tedious when there are over 100 items in the order. We've seen B1UP do various other macros by controlling the mouse and clicking on buttons.
If this isn't a possibility, then I guess the best option would be the second option you mentioned. Cache the entire order and then add and delete everything.
Please sign in to leave a comment.
Comments
2 comments