Skip to main content

Replies posted by OrangeCloud

101 Replies
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Substring Keys from Histoy Log tble

Thanks CallumW, that works like a charm.

7
C
Sidekick (Partner)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Down Payment in IFS 8

Hi @MR10  Down payments coming from customer. (I am looking something for our  AR dept). Its customer/Purchase Order set up here.   thanks for replying

4
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Substring Keys from Histoy Log tble

Hi @CallumW  just a quick question, can you please let me know the reason of using \ with the second argument in the query. ‘\#=([^^]+)’ ‘\MIXED_PAYMENT_LEDGER_TRANS_ID=([^^]+)’   Thanks

7
C
Sidekick (Partner)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Substring Keys from Histoy Log tble

@Jur    Wow, that's cool, I was not aware of that API. Thanks for pointing. its very helpful and very simple to use :)

7
C
Sidekick (Partner)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Down Payment in IFS 8

Thanks @MR10 , Lets the reading begin :)

4
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Reprt Export to Excel removes leading zeros

Thanks every one for replying, I have already  tried  to_char() and format column in excel , both of these still does not recover leading zero’s. @alanbclark , I looked into adding tab character at the end, couldn't figure out something to fix following: ifsapp.mixed_payment_lump_sum_api.get_ledger_item_id('01',ifsapp.client_sys.Get_Key_Reference_Value(t.keys,'MIXED_PAYMENT_ID'),ifsapp.client_sys.Get_Key_Reference_Value(t.keys,'LUMP_SUM_TRANS_ID')) Payment_Doc_No   any pointers. I cant change anything in the table. I have to fix it within report   Thanks

11
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Reprt Export to Excel removes leading zeros

Hi @KHALIDU , I tested this issue and I didn’t encounter any issue.  The steps are mentioned below.  This is how I save the data in the database.   Quick report View Report         Export to excel - (Here leading zero can be visible)      By default “Number Stored as Text”     If I change above to “Convert to Number” then only I can see what you have seen in your issue.      Hope below link will help.https://support.office.com/en-us/article/fix-text-formatted-numbers-by-applying-a-number-format-6599c03a-954d-4d83-b78a-23af2c8845d0#__toc260840020     @Sandun Madola , i appreciate your help. i understand ‘ method. just dont understand how i can use ‘  with my  results coming from API like the one below: Let me know if there is a way to use ‘ in following line. Bundle of Thanks   ifsapp.mixed_payment_lump_sum_api.get_ledger_item_id('01',ifsapp.client_sys.Get_Key_Reference_Value(t.keys,'MIXED_PAYMENT_ID'),ifsapp.client_sys.Get_Key_Reference_Value(t.keys,'LUMP_SUM_TRANS_ID'))Payment_Doc_N

11
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Reprt Export to Excel removes leading zeros

@Sandun Madola , yes this is the part of statement that brings in check number and looks fine in IFS, when user export the report to excel we lose leading zeros as most of checks are started with 0. and i am trying to fix this in IFS 8.  @GPIE  we are in the process of upgrading to IFS 10 ,as you mentioned that you find a way in IFS 10 for this. i have hope now :). The process you showed me seems interesting and i tried but it gives me true xml file instead of excel.

11
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Reprt Export to Excel removes leading zeros

@GPIE Thanks for this information. its very valuable. Appreciate your and everyone else's help in this thread.

11
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
How to handle 3rd party parts for Repair in IFS

Any one having same business Model…..    

2
A
Hero
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Delete unissued material line from work order

Thanks @Dakshinie , the Manager thinks she was able to delete line in IFS 7 and just want a clear view of order. you are right it does not effect the work order. its just a preference i believe.

3
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Delete unissued material line from work order

@Dakshinie i spoke with the Manager and she told me that for Audit purposes they prefer to have a clean work order and dont want to show them mistakes. this functionality will help them.

3
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)
Restrict Drop Ship orders from Customer Master

i thought i describe it from another angle. may be get some responses. we want to disable Single Occur Flag in customer order Addresses Tab for some of our customers….. any ideas

3
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Products (Manufacturing, Products, Engineering)
Restrict Drop Ship orders from Customer Master

Thanks @RichardLinford , we are on APPS 8,

3
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
IFS Permissions and Securities

@Garak , @mess1153  Thanks for replying,  I will be compiling this document soon for our ORG. Looking for some ideas, if any, or a sample document that you think is best to understand , could be from any other software. 

5
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
IFS Permissions and Securities

Thanks @mess1153 

5
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)
Print Transport Task in Apps 10

@jabous Thanks for quick reply. I am using the same path to get to this screen. Does that suggest something is missing in our install… or any other pointers …  

7
paul harland
Superhero (Employee)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)
Print Transport Task in Apps 10

@jabous i am using IFSAPP,

7
paul harland
Superhero (Employee)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Buying (Procurement, Demand Planner, ASC, SRM)
Print Transport Task in Apps 10

@paul harland  thanks. that was the trick :)Got my menu back.

7
paul harland
Superhero (Employee)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Finance (Financials)
Disable Difference Code for further Use

Thanks @ShawnBerk , that looks good . i will surely give it a try.

2
O
Sidekick (Customer)
4 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Custom Field in Aurena - Technical documentation

Thank you @Przemek Can we add Custom field in Aurena when it already exists in IEE - IFS 10

6
O
Sidekick (Customer)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Custom Field in Aurena - Technical documentation

@anmise Thank youi mean to ask custom field on overview pages in Aurena. i am trying to add custom field on ‘AR invoices Analysis’ screen in Aurena, that already exists in IEE - IFS10- and cannot find under ‘Contents’ tab. thanks

6
O
Sidekick (Customer)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
posted in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
New User for Scheduled Jobs Only

Thanks @JULIAN  and @pwlm so we decided to create a separate User for running scheduled Jobs for Finance, Do this new User will need any special permissions or need to include in any specific tables , grants etc for it to work for scheduled jobs smoothly…. i will be testing this in next week. As i saw in some views have code that checks if the user has certain privileges like history audit tables etc.At present the finance user is able to invoice via ‘quick order flow handling’. Your tips will make my work smoother and life easier. Thanks.

4
JULIAN
Hero
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
correction Invoice Remove Button in Tax Lines

Thanks @ShawnBerk I will check Permissions.I also noticed there’s a whole new tab ‘Tax’ in Company basic data setup. look into that too..Lets hope for the best.

2
O
Sidekick (Customer)
3 years ago
O
Sidekick (Customer)
OrangeCloudSidekick (Customer)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)
Aurena Freight Tracking from Customer Order

Is there a way to create a jump from Customer Order Page to Freight Interface, in Aurena… using related pages.  Any documents

8
O
Sidekick (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings