Hi there @Twilalte! Glad to have you with us today and thank you for posting your concern here in the community! ? I'm tagging our experts in workflows to help you out in this. @Jack Daryl Espiel-Oracle / @Pauline Joy Cac-Oracle, any ideas on a workflow to send a follow up email after a certain number of days? Other…

Hi there @sfsonarboy, Welcome to the community and thank you for posting your concern here! ? Allow me to tag my colleagues with expertise in SuiteScripts -- @Erick Dela Rosa-Oracle / @Mikko De La Fuente-Oracle, any ideas on this concern? Other community members who have insights on this, feel free to join in the…

Hi @JoshPNW, Is the Bill created from Purchase Order or is it a Standalone Bill? Also, kindly provide a screenshot of the Item Record showing the Accounting tab (Accounts) so we can try to reproduce the behavior on our test account. -Ivy

You're welcome, Martha! We're always glad to be of assistance! Keep safe and hope you have a great weekend ahead! ?

Hi @Martha Hakes, Here are some points I noticed upon looking at the screenshots you provided: On your search criteria, you have multiple Inventory Locations selected. Note that only the location quantity in these locations will be considered in this search. In the search results, you are using the summary type = Maximum.…

Hi @User_B1J9S, Thanks for creating another thread in our community! Regarding the concern, allow us to check on how we can help you with it. I am coordinating this with our gurus who have expertise on this matter and we will get back to you with our findings. Other members who have an idea, feel free to comment on this…

Hi @paula.courtemanche, Hope you're doing good today! Thanks for posting your concern here in the community! I'm tagging our guru who has expertise on this topic, @Shamaine Chan-Oracle. Any ideas on this one, Shamie? To our other members who faced the same scenario before, we invite you to share your solutions or…

Hi @BWM- Shem, Thanks for sharing a screenshot of the Purchase Order. I further checked on this, and was able to reproduce the greyed Close button when the PO was associated with an Inbound Shipment. When I tried to mark the item line as closed, I received a message: "Purchase order line cannot be closed when there are…

Thanks Mich! Hi Lily, There is an existing enhancement request for this functionality: Enhancement # 235637: Transactions > Purchases/Vendors > Enter Vendor Return Authorization - Inventory Returned Not Credited between Item Fulfillment and Vendor Credit - be able to clear this account just like Vendor Bill Variance…

You're welcome, Asher! ?

Hi Asher, In the Criteria tab, you can use the Inventory Location field to specify the location: While in the Results tab, you can use the field Location On Hand for the quantity on hand of the items: Hope this helps! ? -Ivy ====================================== If you find this reply to your question as helpful, others…

Thanks Emi! Hi Earmie (@BWM- Shem), I checked this one on my standard test account and noted that there was a Closed button in Purchase Orders with Partially Received status. After further checking my resources, I noted some reasons on why the Closed button might not show on the Purchase Order: There is a workflow (or…

Hi @sarahm_43874, Glad to have you back in the community and thank you for posting your concern here! Allow me to tag my colleague @Shamaine Chan-Oracle who has expertise on this topic. Any ideas on this Shamie? ? In the meantime, please check if there are custom scripts or workflows deployed that may be affecting this.…

Hi @CDuf, After extensively testing this on my account, I noted that getting the required information using only 1 saved search might not be possible at this time. This is because using the Customer: Items Purchased as a criteria will pull all customers who purchased that item even once in the past. I also checked and…

Hi Hayley, If you are unable to find the item with the internal ID in your item list, maybe it is inactive or might have been deleted. As for the lot numbers, you can also try to use the steps provided in SuiteAnswers 66956 to look for it. If there are no results on the search, then the lot number might have been deleted…

Hi @rburns515, Glad to have you back with us today and thank you for posting your concern here in the community! I have already coordinated your concern to our gurus who specialize on this topic. They will be checking this and will reply to this thread for any updates or should they require additional information. To our…

Hi @paula.courtemanche, Thank you for posting your concern here in the community! I have consulted this one with my colleagues in the SuiteCloud team, and they suggest that you reach out to the bundle owner since we don't support Celigo Connector and this is a third party bundle. We appreciate your understanding on this.…

Hi Hayley, The reference key is likely referring to the internal ID of the item record that is causing the error message. I would suggest creating a saved search to look for this item record. Here is how to do this: 1. Go to Lists > Search > Saved Searches > New 2. Click on the Item link 3. In the Criteria tab, use the…

Hi @CDuf, Please check if the items on the 2nd and 3rd customer on your screenshot are Kit/Package items which contain any of the items you set on the Customer (Main Line): Items Purchased criteria. Based on my testing, if the item is included in the criteria, the saved search will pull up the orders which include…

Hi @nag_m, Glad to have you back with us today and thank you for posting your concern here in the community. I'm tagging our gurus, @Micah Timbol-Oracle and @Camille Cagalingan-Oracle who have the expertise on your concern as they will further check this and update you on this thread. Anyone else who have any idea or…

Hi Asher, Based on my testing on this, I noted that whenever backordered items are received in the system, they are automatically committed to the orders. I tried to test for a saved search that will show the item line level changes, but it seems that this is not yet possible in the system and is logged in the following…

Hi @farrago, When you go to the Vendor record > Financial tab > Items subtab > Import Price Lists... button, a new window will appear: On the screenshot that you sent, it seems that the CSV file you are using has header rows. Please try to create a CSV file with no header rows and contain the values for the following…

You're welcome, Harika! Glad I was able to help! Have a great day! ?

Hi @sarahm_43874, Per checking, there is no standard report that shows this information. However, you can try to do a transaction saved search for Work Orders. Here is a sample search I tested, which shows the average run rate per unit of an item, based on the actual production start and end dates: Criteria tab: Results…

Hi Kyle, If we have the same criteria, then maybe you can try this: (SUM(ABS(CASE WHEN ({memo} LIKE '%Customs and Duty-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Freight-LC%') THEN {amount} else 0 END+CASE WHEN ({memo} LIKE '%Agent Fee-LC%') THEN {amount} else 0 END)))/MAX(NULLIF({quantity},0)) You mentioned…

Hi Harika @@User_YHY5Q, Based on my tests, the standard behavior of the system is that the Location in the Item Fulfillment and Item Receipt will automatically populate based on the Location set on the Sales Order and Purchase Order. For example, if there is no location set on the item line level of the Sales Order, then…

You're welcome, Asher! I'm glad that it is now working! Have a great day! ?

Which of those items is the regular inventory item? Is it the LADDER DISPLAY UNIT? Can you go to the item record and check if the Use Bins checkbox is marked for the regular inventory item?

Hi Kyle, Glad we're on the right track! ? Please make sure that the criteria on the saved search has the following (as documented in SuiteAnswers 49978): Type | is Item Receipt Account Type | is Other Current Asset Item : Track Landed Cost | is True There might be some transaction lines which are zeroing out the results.…

Hi Asher, If you have the feature Advanced Bin/Numbered Inventory Management enabled on your account, make sure that the Inventory Detail field is checked on your custom form. If the above mentioned feature is disabled, then just make sure that the Bin Numbers field is shown on the custom form. If this still does not allow…