Discussion Forums

Hello everyone!I’m trying to create a Generic Inquiry that produces a report listing the materials contained in a multi-level BOM and some information about those materials. The difficult part is that many (but not all) BOMs contain BOMs within them, which themselves can also contain BOMs, and I want those material items to be listed as well.I’m able to get the first level BOM materials in one report, and I can get the second level BOM materials in another, but not at the same time in the same report.I’m looking at the tables “AMBomItem”, “AMBomMatl” and “InventoryItem”, which I believe are all the tables I need, and have Inner join types between them based on bomId and InventoryId.So, my question is this: how do I write the GI in such a way as to get all the layers of BOMs and their material constituents? Is there are way to recursively go through each BOM item to check if it contains a BOM itself and if so get those items?Any help is appreciated!

To properly account for payroll related expense, we would like to:Account for non-project (non-billable) labor in 3 distinct buckets Indirect Labor (Overhead): Supervision, Maintenance, Engineering  Direct labor (direct employees nonbillable hours) (not Labor COGs) SG&A labor Differentiate straight time, premium time, vacation time, and holiday timeIt would look something like this.  Reg Time OT Holiday Vacation Bonus Benefits Work Comp Project/ Billable Direct 61010 61020 62800 62710 61030 62110 62400 52000 Indirect 61040 61050 62800 62710 61060 62110 62410 52000 SGA 71010 71040 72810 72710 71030 72110 72410 52000

I’m working on a PO approval map. There are many approvers with various approval limits. I need to require two approvers for PO’s over 50K. I understand that a specific number of approvers can’t be specified for a single step, it’s either 1 or ALL.So, I’ve created a 2nd step for PO’s over 50K. Needs to have the same group of approvers though. This presents a problem, because having the same approvers in both steps basically causes it to skip the second step. I thought I could solve this by using “Approver ID does not equal ___” in the rule conditions. But it doesn’t work. Wondering if I’m using it wrong, or if not, what is the point of the Approval entity in approval maps?Here is a dumbed down version I tested without success. Step 1: Two rules, CEO and CFO, both with specific employee specified. No conditions. Complete step on approval. Step 2: Same as above except each rule has a condition to require employee’s approval if they did not approve in step 1 (goal anyway). Screenshot belo

Is there a better way to do this? I don’t see an option for “one-time upfront”. The best it looks like we can do is to bill a Service Contract yearly. Here’s my workaround. Please let me know if any has alternative suggestions.  Duration = x years Billing Period = Year Service Per Period - adjust line item to the x-year total  Deferral Code - add x term deferral code (e.g. 3 years/36 months)  Run Service Contract Billing  Deferral Schedule created after AR Invoice processing Should accurately recognize revenue across x terms (in this case 36 months)  For years 2, 3, etc. - modify services period and zero out prices so no billing/revenue generation occursIt’d be ideal if there was a Period option of “one time” or “only once” for upfront billing. I can submit an idea if there isn’t one already and if others believe that’s needed.  

What data tables hold the items currently in totes? I’d like to list all the totes active in the system and then display their contents. I just can’t seem to find the data tables holding this information. Anyone know where to look? Thanks!

Greetings, it is possible for the variables of Alternate ID to be reflected as for example in excel, individual columns?  example: 

We create a Sales Quote, mark lines Require Appointment;  create Field Service Order.The order is created, but the lines are marked and Nonbillable.  The detail lines are non editable. How to resolve.  

Is there a way to make the “Parent” field on Tasks editable? It would be extremely helpful to be able to add a parent to an existing task. Or change the parent task after the task is saved.  

I have added a Numbering Sequence to my changes, but I cant see how to put this in my Customization Project to have everything deployed together to other instances. Am I missing something or do I need to do it in SQL. Any suggestions please.

I want to have the Scan Move screen create a new line and serial number each time a round of scanning finished. I want this to be compatible with a printed QR code, which currently works apart from the issue with the lot number. Manual entry of lot numbers won’t work when using a static QR code.Currently, doing 2 or more rounds of scanning with the same data will combine the quantities into one line instead of creating an additional line.Ultimately, it should work in the same way Receipt or Move does, where a uniquely generated lot number will be assigned for every line, even if all of the other details of the line are identical to an existing one. I am more than willing to implement some kind of Customization since I am familiar with that interface and system, I would just need some guidance on the implementation. Also, I am doing this on a test tenant, so I can afford to break a few eggs here.Current outcome: Desired outcome: 

Hi All,I have a goal of getting orders out in three days. I am trying to make a dashboard view that over a given amount of time it calculates the percentage of orders that have went out in three days or under. Any guidance would be greatly appreciated on this, or feel free to ask questions if I am not being clear.Thanks!

I’m overriding the Print Shipment Confirmation menu option on the Shipments screenIn my code, I want the option to use my override, or use the base method.When I call the BaseMethod from my delegate, it is null.  I’m not sure what to do.Here is the code for my override: [PXOverride] public delegate IEnumerable PrintShipmentConfirmationDelegate(PXAdapter adapter); [PXButton] [PXUIField(DisplayName = "Shipment Confirmation")] public IEnumerable PrintShipmentConfirmation(PXAdapter adapter, PrintShipmentConfirmationDelegate BaseMethod) { try { SOShipment shipment = Base.Document.Current; string screenID = "SO302000"; string reportID = "SO642000"; string printerName; ICSPrintHubActions iCSPrintHubActions = SelectFrom<ICSPrintHubActions> .Where<ICSPrintHubActions.screenID.IsEqual<@P.AsStri

Hi, I have a requirement to record expenses for a customer contract. I see in AR invoices, there is a field to enter the contract for revenue, but in AP Bills I cant find the contract ID. Is there anyway that we can enable entering contract ID in AP bills or any other transactions similar to entering the project ID?Thank you,Dulanjana

Hi,I’m trying to make some generic inquiries available for customer portal users. All indications from the help guide make it seem possible so I suspect that I’m missing something out.The GIs appear on the portal for our admin users but not customer (contacts linked to business accounts) users. The access levels to the GIs are the same. Is there anything I’m missing out? Any help would be greatly appreciated!

.

Dear SenseI have an Acumatica 2023R1 Custome Project product, if I update this Acumatica 2023R2 or 2024R1, Do I have to recode All my custom screens or not?Thanks

Hi, When I go into Receivables→ Processes-->Print Invoices and Memos and try to email a sales order invoice it’s not picking up the same e-mail template that I linked under Sales Order Preferences Mailing & Printing called InvoiceNotification. I made changes to that e-mail template but why under Print Invoices & Memos it’s not picking up the correct template. Am I doing something wrong. Thanks, Frances 

When a production order is created from an Estimate, is there any join/link between Production operation ID and estimate operation ID?

We are in the process of converting to Acumatica and in the migration of existing employee data, we are not finding any existing systemic way to map employee Veteran status. We are surprised that the ability to indicate Veteran status does not show up within PR203000 -Tax Settings Tab. Are we missing something or do we have to create a custom field or attribute on employees to track this information?

Hi! is there a way to reserve inventory for customers without sales orders? I’m familiar with sales order allocations and transferring inventory to location holds but was wondering if there was another way. The business case is when certain product is low they need to set it aside for priority customers.

Hello! I would like to use Business Event Import Scenario to create a task automatically when an opportunity status changes to “Won.” I followed the steps in this article: Automatic Task Creation with Business Event and Import Scenario • Everything Else • Acumatica User Group Forums (augforums.com) but was not able to see the task get created. I think my import scenario might be wrong… any ideas?  Thanks!

Is it possible to add a 13th finical period after you are set up and using 12?Is this documented somewhere ?

Hi!We have started looking into ‘Clock Entries’ within the Manufacturing module with the intent of using the feature to document and track employee clock time. I understand that the entries are tied to a production order but in our use case, we don’t necessarily need to track against a production order or use it to attach labor cost to the production order. We liked the feature of being able scan in, scan out, and approve the clock entries. We only really need to capture the employee, the start time, the end time, and the duration between scans. We will then use that information for reporting.  Wanted to reach out this community to gather some thoughts on if this is suitable for my case or if I should look elsewhere.  

I have a generic Inquiry that I’m trying to filder the created date time column by date and time. Right now if I click on the column to filter it I only get filters that filter as if the value was plain text however I would like for it to recognize that its datetime and allow me to filter as such.I’ve attached an example of how I would like it to be to serve as reference.  

How do you get a Vendor bill to connect to Avalara so that use tax will calculated?