Buying (Procurement, Demand Planner, ASC, SRM)

davidgjelstenDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Advanced SQL Search - List of UNIQUE values?

IFS 8 SP1 Page: Purchase Order Receipt Category: Advanced Search Function - SQL Hi all, This is my first post on these forums, so please guide me if I’m posting at the wrong area. Lets say I’m search all deliveries received in >2020. This is thousands of results. Is there a way to get a list with UNIQUE PART_NO values, where only the first delivery (ACTUAL_DELIVERY_DATE) of the unique part numbers are listed? I’ve tried: ARRIVAL_DATE > to_date( '20200101000000', 'YYYYMMDDHH24:MI:SS' ) and UNIQUE (PART_NO) Based on: https://www.w3schools.com/sql/sql_unique.asp

105911

4 years ago

faisal.saeedDo Gooder (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Retention Payment

Anyone knows how to create the valuation for retention amount on a sub-contract?

5764

4 years ago

RcoubrouHero (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Purchase Order Print Out - manufacturer No

Does anyone know why this extra line called “Manufacturer No” would print on your embedded purchase order print out ? It just started happening for us for all Sites PO’s (all lines regardless if part or no part line) Thank you

1161

4 years ago

ntaylorSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Purchase Order Return - Early Delivery

Morning all, We have an issue where we have certain suppliers who “chance it” and send us material that they have finished early (sometimes months early). Obviously we don’t want to be taking on this stock until we actually need it however as some of it is sent by courier i.e. FEDEX, UPS etc we get the courier dropping the item off, takes a quick signature and then they are on their way. It is only after manual inspection of the delivery later that we realise that we have something we didn’t yet need. I know what you are all thinking. just tell the supplier to stop doing it! (apparently they don’t listen) For audit obviously we have to register the purchase order arrival but after this we have 3 options. Leave the stock as registered and keep stored in a goods-in location Return for Credit Return for Rework The only one that works in the way they want is Return for Rework in so far as it halts the payment, creates a return note and upon it coming back we can just re-registe

4023

4 years ago

MTIMMDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

IFS8 - Sharing product from one project to many, but not back

Seems like this should be easy, but we are having difficulty sharing product from one activity sequence or project to many other activity sequences or projects. We don’t want the inventory from those other projects to be shared at all. We’ve messed around with a few settings in PMRP and can’t seem to get it right. Has anyone else had to do this? Like I said it seems ‘simple’. Many thanks!

1792

4 years ago

BLLBrucemoSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Mobile Purchase Order Authorisation - Touch Apps

We are currently using APPS 9 and would like to introduce purchase order authorisation via mobile. Am a little new to IFS, so wondering if that technology works in APPS 9 and if so, how can I set this up? Thanks! for all feedback!

2265

4 years ago

AbdulazizDo Gooder (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

approval template

Is there a way to connect Supplier creation to an approval template? meaning a specific approval template comes automatically every time trying to create a supplier rather than adding a template manually each time.

8963

4 years ago

MirjaKSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Inventory part - Online consumption and Customer Order Line Supply Code

What is the best way to work according system logic in the cases when you have select the online consumption in inventory part and you will get the customer order which is not matching master schedule plan (un-forecasted demand). There is two option used in our case: Modify MS before proceeding with order → Need to wait with order Changing Supply Code in order line to Not decided → Order can be entered Following IFS logic, what is the best way to proceed to not cause un-expected issues in demands in planning time fence or outside planning time fence.

2370

4 years ago

chrisplantSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

NCR Object Connections

I’ve created an object connection for PurchaseReceipt that allows me to to manually link a PO Receipt to an NCR that I created using the NCR wizard. Is this the correct process flow? Register Inspection Results, then Create the NCR, and then link the 2 together? Thanks, Chris.

6852

4 years ago

WhoopsDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Connectivity Inbox Error on INVOIC

We are working to set up inter-site processing in IFS. Everything appears to be working in the PO/CO transactions, however the INVOIC transaction is getting rejected in Connectivity Inbox with the below error. C00 in the message has an appropriate invoice type so I am confused as to the cause of the error. ORA-20124: Error.NULLVALUE: Field [INVOICE_TYPE] is mandatory for Invoice Header and requires a value. Any ideas as to where to go look?

1561

4 years ago

KatePurves

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Input UoM

Does anyone know how you can activate and therefore populate the Input UoM / Input Quantity on a purchase order line? Thanks

5251

4 years ago

abarabanDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Remove/Hide Inactive Parts in Inventory Queries

We have inactivated a bunch of inventory parts. But, they are still showing up in the inventory part queries. Is there anyway to remove/hide these inactive parts from the inventory part queries?

3432

4 years ago

BLLBrucemoSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

How can i enable supplier invoice posting substitues? Works for PO but not for invoices

I can add substitutes for purchase orders, but cant seem to add for supplier invoices. Normally, when I populate on the purchase order substitutes, the authorisers appear and I can add a valid from/to - but no functions allowed, even with IFSAPP_ALL - permission sets look good too. Any ideas what am missing here?

1791

4 years ago

JerkerDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Scheduling MS with multiple sites

Hi, Is there a way of running the “calculate MS level 1” in a smart way. We have multiple sites and we are distrubuting slaes parts betwen them all. To get the drive thrue the system now i need to run them all two times. Sie 1 Site 2 Site 3 Site 4 and then again Site 1 Site 2 etc So All sites has shared Theres needs to each other. We hare sending parts from site 1 to site 2 and 3 and we are sending parts from site 2 to 1 etc. Is this the right way or?

560

4 years ago

RcoubrouHero (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Spare Part automatic reordering

Does anyone use the Inventory Part > Planning Data set up for “Planning Method = B” order point to automatically reorder spare parts when the quantity goes below the order point? This seems to be working well except if a PO is created for a spare part reorder and the supplier has the part on back order so will be beyond the lead time, the job will keep recreating a new PO to order the part thinking it’s not in place. Aside from extending the lead time in the acquisition tab, which we do not want to do, is there another solution to prevent this from happening? We’ve tried confirming line with differences so we could change the date but the job still recreates a new PO. Thanks!

3233

4 years ago

BLLBrucemoSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

How can i set up automatic purchase order receipting by cost code/value?

I am trying to make the receipting process more efficient. We have a number of low value items we would like to automate the receipting for. These are goods that go directly from the supplier to our sites. Is there an easy way to achieve this or do I need to look at customisation? Perhaps it could be set up by cost centre rather than value

2843

4 years ago

JDKirkendollDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Purchasing Control Plans - AQL Questions

IFS Apps 9 Update 10: We’re looking at purchasing control plans, and wanting to begin to use those in lieu of the other system we currently use to do inspections on incoming parts. For most cases, we find that the purchasing control plans will work very well. We have a particular case, however, where we are wanting to drive a certain sample size based on the lot quantity, using the ASQR-20.1 (aerospace) standards. This is difficult because this particular AQL plan is based on a c=0 acceptance. Meaning, the quantity driven for inspection is presuming that there are no non-conforming items within the sample size. Using the existing acceptance sampling logic, it looks as if we’re forced to adhere to the whatever the system generated inspection quantity values are, which do not seem to be based on a c=0, but rather what the “acceptable” c= value is based on some background math that I can’t see. Given the particular constraints, we cannot simply use a sample percentage either, it would s

3810

4 years ago

KasiaSidekick (Customer)

posted in Buying (Procurement, Demand Planner, ASC, SRM)

Apps 9 - Web access B2B

Hi all, Wondering if anyone out here is using B2B Web Portal and can tell me a little more about it in terms of set up, licences, advantages/disadvantages? Exploring ideas on supplier portal in IFS to send requests for quotes to suppliers. Thanks, Kasia

1360

4 years ago

ifsplayer

asked in Buying (Procurement, Demand Planner, ASC, SRM)

ORA-20124 is coming while creating customer schedule

Dear All, I am trying to raise the customer schedule from supplier schedule. This is an inter site transfer. When I am putting the status of supplier schedule transferred. Customer Schedule should be generated but it is not generating. I checked the status of messages in “In Message Lines”, the messages are coming in rejected state. When I check the error text below is the message. ORA-20124: Error.NULLVALUE: Field [EAN_LOCATION_DEL_ADDR] is a required item because it is a mandatory item for receiving the customer delivery plan, so a value is required. does anyone where this value should be given. Thanks

22781

4 years ago

JouniSidekick (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Transport task automatically between sites

Is it some how possible to get transport task generated automatically between sites? I can setup multisite and MRP genererate distribution orders nicely. But if I have two sites in same physical location, then order handling is some cases too much. Easier would be use just Move inventory part / transport task. IFS10 upd7

3591

4 years ago

KatePurves

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Apps 10 link between Purchase order and Project Delivery Address

In apps 10 can you turn off the requirement for a Project to have a stated delivery address when linked to a Purchase order? Currently when a PO is linked to a project, the PO displays and error which can only be resolved by entering a delivery address into the project. T seems the PO delivery address does not suffice. Can this mandatory requirement be disconnected?

1631

4 years ago

TecSuraKuSidekick (Partner)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

What is the sequence of start for IFS 10 using script in Bin folder

IFS 10 core build

3453

4 years ago

ghdpDo Gooder

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Dynamic Lead time option - agricultural products

Hi folks, I was hoping to get some suggestions on how to model a lead time appropriately: we buy items that are often harvested once or twice a year in a given period so they obviously don’t always fall within a standard # of days lead time - it’s dynamic depending on where you are within the year. I was thinking of using the unlimited supply date to model this better within our system but am I missing something? Any suggestions would be appreciated!

1031

4 years ago

CINKBOLICKDo Gooder (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Report Picking of Zero On a Line in Shipments and Still Delivers Line as Picked??

Has anyone encountered the scenario where there are order lines tied to a shipment and instead of disconnecting the line from the shipment, you report picking of zero (0) on a specific line. The line is still tied to the shipment and shows 0 picked after reporting picking with a quantity of 0. When you go to finalize the shipment, selecting ONLY “Picked Quantity”, it still delivers the line as if the quantity was actually picked! See attached for example. We’ve tested this scenario multiple times and come up with the same result. Is this a bug within the Shipment module or are we missing a process step?

1190

4 years ago

jtobinSidekick (Customer)

asked in Buying (Procurement, Demand Planner, ASC, SRM)

Can items returned to supplier be combined on one document?

When returning material to the supplier, a separate document prints for each receipt. Does anyone know if there is a way to combine them into one return document?

1633

4 years ago

Page 77 / 79

Buying (Procurement, Demand Planner, ASC, SRM)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded