417PM

Hi Ivy, That worked perfectly! Thank you for the instructions and the explanation of the criteria logic. I had to go back and change a few bills and invoices where the quantities received or invoiced differed from the transactions they were created from, but I was able to run the search today and the Current Lot Number on…

in How do I create a report that shows inventory quantity by item, location and lot code? Comment by 417PM Jun 7, 2021 3:45PM

Hi Ivy, Thank you for the response! I tried to recreate your saved search, and it appears to work except for the following: -If inventory for a lot code exists at more than one warehouse, the Current Lot Number on Hand appears to be accurate for each location for All dates. However, the Total Increase, Total Decrease and…

in How do I create a report that shows inventory quantity by item, location and lot code? Comment by 417PM May 25, 2021 7:13PM

Thanks for the reply, Jeff! Just to be clear, I'm ok with the Lot Numbers and Lot Qtys showing in one column separated by "," and "(" as long as the UOMs are consistent and Qtys are by location. The examples below came from the Custom Quantity on Hand Detail. Location 1 (this worked, but it took a ridiculous embedded IF…

in How do I create a report that shows inventory quantity by item, location and lot code? Comment by 417PM Apr 30, 2021 2:05PM

Looks like that did the trick. Thanks!

in Can I search Item and Account Dropdown Lists on Transactions? Comment by 417PM Feb 13, 2020 6:04PM

updated: I tried creating an Inventory Transfer this morning, and the INCOTERM list wasn't empty anymore. I had logged out and logged back in like the Suite Answers article instructed, but apparently that wasn't enough - it needed to take a few hours to think about it. Anyway, Transfer Orders appear to be working now and…

in How do you track landed cost on inventory transfers? Comment by 417PM Feb 5, 2020 1:48PM

Thank you for the suggestion, however, I'm not able to create a Transfer Order because my INCOTERM dropdown list is empty. I followed all the instructions in SuiteAnswers "Missing Default Incoterms in Transfer Order" (Answer Id: 81529) and the incoterms are still missing from the dropdown. Do you know what else I can try…

in How do you track landed cost on inventory transfers? Comment by 417PM Feb 4, 2020 5:48PM

Thank you both for your responses. I haven't been able to make either suggestion work yet though. This is what I get when I try to add the custom element following Michelle's instructions. This form looks different that my invoice, so I can't see where I should drag the discount rate item to. The template only shows…

in How do I add Discount Rate to the printing fields in an Invoice Footer? Comment by 417PM Jan 28, 2020 11:01AM

MFA for Oracle Community

417PM Red Ribbon

Comments