Topics started by Manoj Balasooriya

8 Topics

M
Superhero (Partner)
Manoj Balasooriya
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to retrieve content of yellow sticky notes via SQL query

How can we retrieve content of the yellow sticky notes (i.e. tool strip, notes icon) via SQL query for any entity that could have yellow sticky notes such as Customer, Customer Order, Shipment,  Invoice, Supplier, etc.?  Searched PL/SQL for API's and the database for tables/views but could not find any viable candidates.  We’d like to be able to retrieve the sticky note text for reporting and analysis purposes.  

5
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to retrieve content of the NOTES via SQL query

How can we retrieve content via SQL query of the NOTES (not document text) for any entity that could have NOTES such as Customer, Customer Order, Shipment, Invoice, Supplier, etc.? Searched PL/SQL for API's and the database for tables/views but could not find viable candidates except for one API (basi1app.CUSTOMER_ORDER_API, that has several “get” options i.e. .Get_note_text(CO.ORDER_NO) or Get_Note_ID (CO.Order_no) .  Was unable to find a similar API for CUSTOMER NOTES, or other entities.   

4
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to set conditional formatting to a base profile

We want set conditional formatting to a base profile in below two screens.Base Profile = EquipmentTime Card > Clocking > Trans TypeHuman Resource > Employee Self-Service > Time Card – Day > Clocking tab Field = Trans Type Limit selection to In Normal only Or turn off the field being Mandatory  Customer Order Lines > Supply CodeSales > Order > Customer Order > Order Lines tab Field = Supply Code Limit selections to: Purch order trans, Invent Order, Shop order  We have tried this but have unable to apply it to a profile and have it “stick”.Below you can see we changed the options in the field but when we go back to the customer order, we can see all normal options.we reloaded the configuration and restarted IFS as well.  The print screen below shows that after applying the conditional formatting to the Base Profile Equipment and refreshing the screen, the Supply Code list isn’t limited.  We also tried logging out/logging back in but the conditional formatting

2
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Supply Chain

Supplier tax - Transaction level in Company tax control

What is the functionality of the Supplier tax - transaction level check box in Company/Tax control tab?Help text and the F1 documentation say,“ If this check box is selected and if the purchase part, purchase charge type or the no-part order line is taxable, it is required to enter tax on purchase transactions (e.g., purchase order part line, charge line, no-part order line).  Also it is required to enter tax on supplier invoices (e.g., manual supplier invoices, preliminary supplier invoices, external supplier invoices)”.“Transaction level, validate the tax code on each transaction row.”Is it validated in the PO line level and in the supplier invoice? Does that mean the application does not allow to enter a PO line in a PO without a tax code in the line? 

1
Harsha Siriwardhana
Hero (Former Employee)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Distribution (CRM, Commerce)

How to enable VAT collection in a company

We have a lab opening up in the GERMANY company that will provide services to the local customers. So we will need to collect VAT in that company. Please provide us a guideline of how to enable VAT charge in the IFS system.LCS Case: G2314177

0
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Supply Chain

Automated invoicing and payments for intercompany

We want to use the IFS standard functionality to create Customer orders for inter company stock requirements that generates the PO in the demanding site and be able to ship the stock.We want to know if there still is a way to automate invoicing and payments between intercompany. LCS Case: G2310964

0
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Buying (Procurement, Demand Planner, ASC, SRM)

Functionality of Confirming Orders with Changes on the Aurena, B2B portal

With regards to the functionality of Confirming Orders with Changes on the Aurena, B2B portal, we have 2 queries:1. We observe that the Confirm with Changes screen (attached screenshot), the supplier has the ability to change the Order Qty, Price, Discount, Delivery Date on the B2B screen. Is there a configuration option to limit which fields the supplier can modify on this screen?  2. Once the supplier confirms the PO lines with changes, this information appears on the Incoming PO Confirmation screen and the Confirmation Lines's status shows as Changed. If the supplier has made any changes, is there a way for the approver to compare the information that was on the original PO versus what the supplier might have changed? LCS Support case: G2304235

0
M
Superhero (Partner)
2 years ago
M
Superhero (Partner)
Manoj Balasooriya
asked in Distribution (CRM, Commerce)

How to Invoice block a customer order – Charge line

We would like to Invoice block a Freight Charge which is in order level. Could you please let us know if we can do Invoice block a customer order – Charge line, which is not connected to any Line? In some orders, we need to review/update our freight charges before it get invoiced. So we wanted to Invoice block the charge.If there is no way to Invoice block FREIGHT charge,  Is it possible to connect the FREIGHT to a delivered order line and Invoice block the Order line and after Freight charge is reviewed/updated then uncheck Invoice block line and remove connection line to the Freight charge? LCS Case: G2326906

0
M
Superhero (Partner)
2 years ago

Badges

Show all badges
Terms & ConditionsCookie settings