How do I add a Discount to a document (or line) that removes 15 cents per UNIT sold if the quantity sold is greater than 500 units? Essentially, this discount will decrease the UNIT PRICE by 15 cents on every line for this customer. I can’t use percentage because the unit prices vary. Any help is greatly appreciated.
How do I join the NotificationSource table to the Customer table in a GI? I’m trying to output all mailing settings for each customer so we can see who has overrides enabled for specific functions (like invoices etc). I’ve tried using the DAC browser for this, but I’m not finding a way to get from A to B. Anyone feeling super knowledgeable today? I’d love an assist on this one, thanks!
I have a business event calling an import scenario (Issuing out the goods on a PO). The event frequently says the Lot/Serial number can’t be found. If I go into the History, I can see the failed event, hit reprocess and it works.So... Is there a way to get this event to try and reprocess on it’s own? Maybe like breathe for 5 minutes, then retry any failed events?I’m assuming this is either a failure on Updating IN in a timely manner or my import scenario sucks and it’s probably my import. hoping for the easy method of forcing the B/E to reprocess though, since that seems to go without issue.
How do I get two screens to open at once in the Mobile App? For example, running SCAN AND TRANSFER, while also running ITEM LOOKUP to help me select the proper locations for the SCAN AND TRANSFER screen. Right now, leaving SCAN AND TRANSFER removes everything, so I can’t go check that I’m looking in the right locations etc. Any help is always appreciated!
How do I unpublish all customizations via Postman? I am a newb to the Postman platform (just installed it), but I have broken my instance, all screens come up blank, and need to unpublish via Postman if possible. If someone could send me a screenshot/walkthrough of what I’m needing, I’d be super appreciative!
I am having issues saving a Sales Quote and would love some help!When I am in my Opportunity, I have 5 attributes, 3 of which are required. I fill them in and save. From the pop-up, I just hit CREATE AND REVIEW.When the Sales Quote comes up, I hit SAVE and get this error:CR Error: There are empty required attributes: 'Market Served', 'Product Interest', 'Region' There are empty required attributes: 'Market Served', 'Product Interest', 'Region'. This makes it sound like those exist on the Sales Quote and they need a vlaue, but I don’t have an attributes tab I can see in the form. Am I missing something here? Thanks,
How do we look-up an item in the mobile app by description? The employees have no idea what the ID is, they just want to be able to search “bulb” in a selector (Preferably on Item Lookup) and then choose the proper item, but everything I am seeing expects an Inventory ID and doesn’t allow for a description.
We did a massive client upgrade from Version 19 (which only runs in Internet Explorer) to 23.113.0042 The snapshot is too large to move, so we enabled external file storage LOCALLY, moved those files into an AZURE BLOB. This works just fine for local files, this does not bring back files in the new version using the Azure Blob, even though it has the correct File ID in the file link. We CAN make new files in the new system and they do get sent to Azure and we CAN recover those contents through acumatica. If we try to access one of the other files, it claims it does not exist, but we know it exists as the File ID still points to the correct object in Azure and we can open it (for example the company logo that should display in Acumatica). Anyone have experience with this type of behavior before? Thank you for digging with me!
What field defines the default Unit Price for a STOCK ITEM on a 2-STEP Transfer? Doing international transfers and customs needs to know a value. It’s not a price worksheet (this is a warehouse, not a customer) and “Default Price” doesn’t seem to come over when making a new Sales Order of type TR.I can code around this (if price = 0, then get Default Price from Stock item), but if something already exists, I’d like to leverage that instead of attaching my Mickey Mouse code to the report. Thanks Everyone!
Can we display images from Stock Items in Power BI? I have an OData feed that sends me the image URL, but all I get are the broken image tile symbols in my Power BI Reports.I am sending over links like: https://<MY INSTANCE NAME>/Frames/GetFile.ashx?fileID=668331C4-23A0-423F-A394-FD01CC97E868I’d love to have some fancy inventory reports come out of here if possible. I’m reading some stuff about images needing to be public, but I’m passing credentials already with OData, so I’m not quite sure where to go from here or if this isn’t an option at all with Acumatica.Hopefully someone else has had success wtih drawing an image from Acumatica into Power BI.Here is my column format: Here is my broken output: Thank you for your time and assistance!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.