Hi,
could someone help me finish my allocation program, I have got to half way, but Im struggling to finish it.
What works
the program will take our GL account and search for the payment amount. (SAP 214308), when identified will then place an allocate in column W.
The amounts are then filtered then moved into a tab called Identify Documents, which is then split into individual Tabs.
The above works great.
The bit I dont know how to do.
**here
Now it needs to identify the payments in the Concur tab, Filter it, by the payment amount (column AB) and then
Clear Tab Identify documents (not stuck here)
Go back to concur tab copy all of column A into identify documents tab.
Go back to Sap 214308, filter by Match column X from formula already in
Copy all the rows to the related split tabs which are called by payment amount.
Unfilter concur Tab
Clear identify document,
get next payment amount and repeat from here **.here
In short – it identifies payments, then identifies documents making up that payment, then lists them in a seperate tab.
Note the split tabs is in a module called Split_Sheets in the Sap Connect module
There may be a better way, more organised way of the code which I have not thought about.
Its runnable through lookups tab and green smiley face button
test link file below
Thanks for your help
Dave
test file
could someone help me finish my allocation program, I have got to half way, but Im struggling to finish it.
What works
the program will take our GL account and search for the payment amount. (SAP 214308), when identified will then place an allocate in column W.
The amounts are then filtered then moved into a tab called Identify Documents, which is then split into individual Tabs.
The above works great.
The bit I dont know how to do.
**here
Now it needs to identify the payments in the Concur tab, Filter it, by the payment amount (column AB) and then
Clear Tab Identify documents (not stuck here)
Go back to concur tab copy all of column A into identify documents tab.
Go back to Sap 214308, filter by Match column X from formula already in
Copy all the rows to the related split tabs which are called by payment amount.
Unfilter concur Tab
Clear identify document,
get next payment amount and repeat from here **.here
In short – it identifies payments, then identifies documents making up that payment, then lists them in a seperate tab.
Note the split tabs is in a module called Split_Sheets in the Sap Connect module
There may be a better way, more organised way of the code which I have not thought about.
Its runnable through lookups tab and green smiley face button
test link file below
Thanks for your help
Dave
test file
