How do I delete a wiki article that I CANNOT open? I clearly added something goofy to the body of my article, now I can’t edit or do anything with it, I just get a TRACE ERROR. How do I delete this wiki?
I have a GI that refuses to output a Pivot Table. What types of things mght block pivot tables? I have full admin rights in this system. I can MAKE the pivot, but the display is empty. Here is an example: Without any parameters etc, I have data and I know that every record has a BRANCH associated with it, so at the very least, I should get a list of branches here. I have the dates rounding to YEAR, so I should see something like 2019 <> 2020 <> 2021 <> 2022 <> 2023 across the columns too. But no matter what fields I use to make the pivot, I get this empty pivot table. Anyone know what types of things inside a GI might create a block on pivots like this? Side Panels? Groupings? Mixed Aggregates? Thanks,
My Mass Update is greyed out in my GI regardless of the Entry Screen I set. I am using APTran and trying to mass update the 1099 Box form on all of them. When I go to select an entry screen, I only get Bills and Adjustments as the “PL” screen, not the actual entry screen. Using the PL screen still renders all my options as greyed out. I assume I’m missing something obvious, so any help is greatly appreciated.
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.
I’m trying to get all inventory movements through a purchases accrual account in an inquiry. I can get the APTran joined nicely. I have about HALF of my INTran records showing as expected.The issue I have is that I “think” I need to use Line Number, but the Line Number on INTran is 1, but in the GLTran it’s 2 for a record (Purchases Accrual comes in as the 2nd line, the 1st line is the offsetting account). Without the Line Number, I’m concernced that a transaction could have two rows with the same Item and Account ID, thus creating duplicate entries. The DAC Browser doesn’t have anything regarding these two tables that I can find (hopefully those get more flushed out as we go along). Joins between GLTran and INTranThanks for looking/helping everyone!
How do I find the last Date an item was physically counted in the system?For example:Item A was counted last on March 10th Item B was counted on February 14thIs there an inquiry like this? If not, does anyone know what data table would hold this information so I can make an inquiry? Thanks Everyone!
Under the SHIPPING tab in a sales order is a Shipment Date. This field is called SOOrder.ShipDate. I need to run an import scenario where I check it’s value against the inbound value. I would expect this to be Document.ShipDate, but that isn’t a valid field name. How do we check the Ship Date’s current value against the inbound value?
What format is needed to import time into a BoM? The format it exports out as, does not match up with the import. For example if you export a BoM you would get something like: 1 d 09 h 07 mIf you attempt to import that, you won’t get the same result. Anyone know how we should be importing these?
Every Purchase Order requires a Vendor. Every Item has a Vendor attached to it. How do I tell a PO to only allow line items who are set for the vendor on the PO? Example: I am buying from Bob on a PO, but Acumatica lets me try to buy an item that is only sold by Frank. If a PO is for Bob, why can’t the item selector only show me items buyable from Bob? I don’t care about the things I can buy from Frank. This would also help ensure that the vendors are attached properly (like Bob sells Milk, but I don’t see Milk on my list, so I know something is off on the item). Hopefully this is a toggle somewhere I’m missing.
Sales Orders used to have a REPORTS drop down menu where I could add in reports etc. I seem to be missing that now with the upgrade to 2021 R1. How do I re-add the reports drop down button?
I have a report who was exporting just fine to Excel and PDF. However after rolling out a large swathe of customizations changes between myself and my VAR, the report does NOTHING when I click export to PDF or export to Excel. Anyone know what might cause this or how to fix it?
Already have an account? Login
Enter your username or 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.