List of Contributions

Frank Simms

Contact Details

My Content

1 to 19 of 19 total

RE: Query - AP Transactions

Posted By Frank Simms 12-09-2021 12:54
Found In Egroup: Automate \ view thread
Hello Jennifer, Not really. Looking more for AP transactions that would list out invoices, vendors, PO's etc. Thanks, Frank

RE: Query - AP Transactions

Posted By Frank Simms 12-09-2021 12:54
Found In Egroup: Automate \ view thread
We are also using S4/HANA

Query - AP Transactions

Posted By Frank Simms 12-09-2021 11:00
Found In Egroup: Automate \ view thread
Hello everyone, Wondering if anyone has built a query to extract AP transactions. thanks ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

MM01 - Extend materials to additional plants

Posted By Frank Simms 11-17-2021 10:59
Found In Egroup: Automate \ view thread
Hello everyone, Has anyone built a script to extend materials to other plants? thanks, ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

RE: Trial Balance

Posted By Frank Simms 09-21-2021 11:35
Found In Egroup: Automate \ view thread
Hi Sigrid. Our reporting trial balance is a combination of natural GL account plus costs center. Can the query be modified to pull this combination? thanks, Frank ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

RE: Purchase orders - items not yet delivered

Posted By Frank Simms 08-12-2021 10:08
Found In Egroup: Automate \ view thread
Good morning, We have made some steps but getting the required data is a challenge. Thanks, Frank

RE: Purchase orders - items not yet delivered

Posted By Frank Simms 08-11-2021 17:12
Found In Egroup: Automate \ view thread
Thanks Sigrid, Looking further into the requirements, there are a couple of criteria that needs to be met: Has the amount ordered = to the amount received (ordered and received equals); and Has the amount that has been received been invoiced; Not sure if this impacts the payment, but ...

RE: Purchase orders - items not yet delivered

Posted By Frank Simms 08-11-2021 15:21
Found In Egroup: Automate \ view thread
Thanks Sigrid, The query works. I now have to figure out why it is returning one row on the PO multiple times. thanks, Frank ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

Purchase Orders - Close out old PO's at the header level

Posted By Frank Simms 08-11-2021 11:39
Found In Egroup: Automate \ view thread
Good morning, Looking for a way to close out a bunch of historical purchase orders preferably at the header level. Looking at ME22N do not see the the option to close it out. If we are closing 100 PO's and each has 20 lines each preferences is not to do this manually. Has anyone developed a script to ...

Purchase orders - items not yet delivered

Posted By Frank Simms 08-11-2021 10:53
Found In Egroup: Automate \ view thread
Good morning, We have a requirement each month to send to specific departs a list of open purchase orders to determine if the items have been received or not received. The file would need to include the purchase order data identify the items where the items have not been received or partially received ...

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-10-2021 15:34
Found In Egroup: Automate \ view thread
Hello Jennifer, For the query, what we are looking for is a list of purchase orders where the delivery of the items on the PO are not yet complete. The query is starting with BKPF which is an accounting document table. If an item has yet to be delivered it would not be in the BKPF table. Thoughts? ...

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-05-2021 19:43
Found In Egroup: Automate \ view thread
Hello Jennifer, Thanks for the update. The file attached in the email does not contain the EKKO or EBAN tables. Could you resend? Thanks, Frank

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-05-2021 15:10
Found In Egroup: Automate \ view thread
Thanks. How about the requisition number and the associated requisitioner. That would need to come from a separate table I believe.

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-05-2021 14:14
Found In Egroup: Automate \ view thread
Hi Jennifer, Forgot to mention that we also need to run it at a point in time. Thanks, Frank

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-05-2021 14:06
Found In Egroup: Automate \ view thread
Hello Jennifer, I checked out the tread and downloaded the query. It partially works. We need to get back to the PO and the PREQ and then the requester on the Preq. Not sure how to get that information. Thanks, Frank

RE: Vendor open items to a given list of accounts

Posted By Frank Simms 08-05-2021 11:38
Found In Egroup: Automate \ view thread
Hello Radoslaw, We have a similar issue where i need to extract all open items. What solution did you come up with? thanks Frank ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

RE: Trial Balance

Posted By Frank Simms 07-16-2021 10:24
Found In Egroup: Automate \ view thread
Hello Sigrid. Can this query be converted to use the HANA database table. thanks ------------------------------ Frank Simms | Controller Equinox Gold Corp | 9289193752 ------------------------------

RE: Update settlement rules - ko02

Posted By Frank Simms 10-01-2020 14:29
Found In Egroup: Automate \ view thread
Hi Sigrid, We have 200 orders to settle. Was hoping that there was a script that we could use to update the internal order with the permanent assets. One by one is OK for a couple but not efficient for large numbers. thanks​ ------------------------------ Frank Simms | Controller Equinox Gold ...

Update settlement rules - ko02

Posted By Frank Simms 09-30-2020 08:26
Found In Egroup: Automate \ view thread
Hello, would like to be able to update approximately 200 internal orders that will post to final assets. How to add the second role to the settlement rule to add the final asset? ------------------------------ Frank ------------------------------