Hi @CedSergiG ,We are on IFSAPP10 and very keen on solving this. I will let you know if we manage to solve it.
Hi @CedSergiG ,Have you solved your issue? I have the exact same problem.
Depending on the original data, maybe a pivot wouldgenerate the format you are looking for. A Practical Guide to Oracle PIVOT By Real-world Examples (oracletutorial.com)
@Vimukthi Mahakumbura, I did what you suggested. Inventory Transactions History: all OESHIP transactions are accounted for. There are 252 lines just like in Inventory Parts in Shipment Inventory. BUT there is one Customer Order (part of the shipment) that was marked as shipped on a different date compared to the others. So I have a shipment with 21 different customer orders 20 off which were shipped on the 2023-07-14 and the last customer order was shipped on 2023-07-17.Could this be the issue? If so, what can we do? Co Lines: all 252 lines have the status “Invoiced/Closed” and all lines have the appropriate delivered qty. If the different delivery dates are not the cultprit, what does data repair entail? Are you suggesting going in through SQL and changing the Shipped qty to the appropriate qty in the appropriate view behind “Inventory Parts in Shipment Inventory”? Or is there an utility that we can run to do the data repair?
Thanks for the late answer. We figured it out but I do not remember what the issue was.
Just click on the horizontal bar at the bottom of the modified screen and drag it up. This is meant to be moved around by users depending on the needs.
Thank you again @Thomas Peterson ! You are a great help.
Thank you @Thomas Peterson for the explanations.Where would I found the pre-posting associated to the posting control so I can correct it going forward?
@ADDMARIAE Thanks. I did create a person and attached to it the IFSAPP userID.The schedule task ran this morning and this is the result: But the accounting period is open: Am I suppose to give some business roles in accounting rules to IFSAPP like I have? I thought that IFSAPP had all the rights in IFS?
Thank you @Adam.Bereda your answer was the solution.This is what worked: Along with something equivalent for code part C.
Any ideas, I still have the problem!If I manually run the “Start time Time Reconciliation” task, it works. But it does not reset the overtime every Monday with the schedule background task under the userID IFSAPP. What am I missing?I cannot assign IFSAPP to have supervisor access over every employee since it is not a person. Should I assign the userID IFSAPP to a dummy person?
@Pawel Dworzynski I might be missing definitions for code B but the requirements for each account is not the same. I do I reconcile the various requirements? Should I modify the code B and C of the 12xx accounts so that B and C are at “CAN” instead of “BLOCKED” and then fully define the code B and C requirements for all accounts?
@cperdue I think this is what you were asking for:
If I cannot segragate the ACH related payments, are all the “check” related payments identified with “check” in the description?This way I could at least have the check related payments associated to “check” series and then have the rest, whether ACH or something else, associated to “other” series.
@GayanD I do not know if you have this in IFSAPP9, but in IFSAPP10, simply RMB on any posting control and select Copy to Companies for the RMB menu.
@gumabs yes I know that much, but which line should I amend that will correspond to an ACH payment. For example, is it Customer Payment? or Customer Automatic Payment? or Customer BOE Payement?None say specifically ACH, so I do not know which is the one that IFS will be using in the case of an ACH payment.Any help is welcome!
@Thomas Peterson so simple! Thank you, it worked perfectly!
@ADDMARIAE thanks for pointing me in the right direction.The other task is running every night. Any idea why the automatic weekly reset to 0 for the overtime balance does not happen?
Thank you very much @gumabs for your help and the additional informatio.
@gumabs It worked with manually authorize for payment!!!!!!Since we have many to do, where do I set the automatic payment authorization to “when posted”?
@Thomas Peterson THANK YOU!
@Thomas Peterson How do I delete the user “groups per voucher series”? Doing RMB on a line in the voucher series gets me to an empty screen. But if I run “select * from VOUCHER_TYPE_USER_GROUP order by voucher_type” in the SQL Querry Tool I can see 191 lines.
@Thomas Peterson thanks for all your help!Where do I find the Fixed Assets calendar periods?
External file will not work more than the Excel Migration Job since both would be using the exact same API call.This is the information that is preventing IFS from accepting my changes. Anyone know where this is kept in IFS and/or the DB? If I could change those parameters after deleting everything related to the accounting periods, I think IFS would accept it but it is just a guess on my part.
I have tried to use an Excel Migration Job to update the accounting periods for each accounting year already created and I keep getting “It is not allowed to create a new ordinary period with a date lesser than year opening period.” when I validate the lines to be imported.Same message then when I was trying manually directly in IFS.I will try to figure out the external file but I do not know how to identify the API and the function that updates these records.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
