Discussion Forums

Hi everyone,May i ask for your help/insight with regards to this kind of inquiry in Sales Order > Shipment moduleScenario:I got two different SO transactions(SO#014067 & SO#014068) in one Shipment transaction, then I made the first shipment  of SO#014068 all the way to invoicing and payment of it, then the status of shipment transaction is Partially Invoiced.Now, my question is how can I edit the Shipment QTY(because I want to ship some SO lines in a partial) or how can the CORRECT SHIPMENT field can be use in this kind of scenario?Please any insight will be appreciatedPlease see screenshot for your referenceggil SO#014067 014068 Shipment # 002064  

 I am wondering how to add the running total of amount (PMRevenvueBudget) in the report footer based on the inventory Item ClassID description of the inventory id in the detailed section. 

Hi everyone,Can anyone enlighten me what is the problem why is it when i create a dashboard for our HR manager using the the generic inquiry of Purchase Order Summary, the dashboard doesn’t have a content just a symbol of LOCK after all i set up the widget propertiesPlease see screenshot, we are currently using Acumatica 2023 R2Appreciate your replies.Thank youggil      

Hello. Im trying to remove image file from stock item using api.Trying to process DELETE request to url /entity/Default/20.200.001/files/85c85649-8fbc-4a31-b8ce-5380ac3730fbbut getting an error “You are not logged in.”. But there is access token in request present and all other requests work fine. Could you help me with it? Thanks.

Hi,To get our inventory transactions to have correct financial coding, we were told to:Set Project-Specific Inventory = True on the Enable / Disable Features (CS100000) form Activate all the warehouses on the Warehouses (IN204000) form (there already is a related bug for correcting this behaviour ) Initialize Stock on the Recalculate Project Balances (PM504000) formWith the feature enabled, the project keys are correctly filled in the inventory GL transactions and the corresponding PM transactions are generated as expected.During the change we also updated warehouse GL fields.However, transactions are erroring due to inventory going negative which is not true since we can see the inventory.Any leads would be greatly appreciated as always.Thank you,Dave Z

H there,I‘ve been giving some thought to Favicon’s (the little logo that appears in the tab bar of a site).I’m wanting the ability to make individual screens within Acumatica surface a different FavIcon, based on the tenant in use, or the screen selected, for example. I’m aware that you can customize the favicon for a whole siite by just replacing site.ico But I’m having trouble trying to figure out how to do this at a deeper level.I was looking into using TamperMonkey to override the favicon for specific sites without having to work with Acumatica code, but I’ve gotten blocked on that method. (Suggestions for how to do this would be appreciated.  I have scripts that work for _other_ sites, but while the header > icon link has been overridden with a new URL/encoded image, the page itself seems to be overriding my changes at a different level.  Ditto for overwriting the Title of pages)

We have a custom field that we’ve added to a page and the client wants to make it required, but only require it based on the company they are in. So it would not be required if they are in Company A, Company B, or Company C but it would be required if they are in Company D. Is there an easy way to accomplish something like this?

All partners are invited to join the webinar on December 3 at 2 PM ET to explore the Property Management module. Learn how to leverage it for your clients and understand its go-to-market strategy. The webinar will cover:The Property Management Market Opportunity Competitive landscape Key Discovery Questions to Qualify Potential Leads Solution overviewRegister here

Is it possible to exclude a non-stock item like Freight on the line of an AP Bill from inclusion in the cash discount calculation?

I’m looking for the ability to create a bunch of DACs that all have the same fields without retyping the fields each time. So, for example I might have 3 different DACs that I want to bind to 3 different database tables. But the actual fields should be identical. Is there any easy way of doing this? My thought was to use DAC inheritance, where I’d have an abstract base class DAC A and then all my children DACs would automatically get the fields from DAC A added but still actually reference the different database tables behind the scenes. To be clear there wouldn’t actually be a database table for DAC A.If this isn’t possible not a big deal, it just means more copying and pasting for me.

We have a report in Report Designer where the results are not matching up with the GI. The GI is called CRRelation. There is a LEFT JOIN with SOOrder.NoteID and CRRelation.RefNoteID. The GI in the attached document shows that the LEFT join works as all the data across the board matches. Using the same type of LEFT join in the Report Designer and following it through various stages (also shown in the attachment) shows that everything appears to be matched up. The issue is that in the Notes field, section listed at the bottom of the attachment, the CRRelation.TargetNoteID  and the CRRelation.Description are suppose to match the top picture in the attachment. I’ve even tried using, in the Report Designer filter, a filter for the TargetType to be Sales Order, and again, no joy. I have not linked the CROpportunity to any of this as I didn’t think it would be necessary in this case.

I have been hunting for the access right that would hide the attached image totals on purchase orders in the header for a view only user that we do not want to allow to see cost of material. I am having a hard time locating the correct access right for this to revoke. Can anyone point me in the right direction? 

We ask customers to prepay for inventory items but not freight or tariffs.  Is there a way to include shipping on the Sales Order but not force the customer to pay for it till after delivery?

Is there a way to restrict users to only be able to edit activities created by them and not be able to edit ones created by colleagues i.e. you can only edit your own activities?

Acumatica and IMAPA few months back, IMAP stopped working, and I had to reconfigure the system email account set up in Acumatica to use POP3. We are using Acumatica version 2023 R1. Are there any issues I should know about with IMAP utilizing this version of Acumatica? If not, can anyone provide a link on how to properly set up IMAP to work with the 2023 R1 version of Acumatica? Thank you. 

How do I clear out the voided payments still sitting in the bank reconciliation screen.

I’m getting a ‘Location’ can be found in the system when trying to import Proforma invoices. Any ideas as to why this is happening? See below: 

Acumatica will offer the Controlled Release of Payroll in Canada beginning with the 2023 R1 release coming in April. The initial release of Acumatica Payroll will support:Federal and Provincial Tax Calculations T4 and RL1 tax forms (T4 summary and RL1 available in 2023 R1) PD7A remittance validation report for CRA (2023 R1) Record of Employment Final Paycheck Canadian Specific features Paid Time Off calculations Deduction and Benefits calculations  Payroll related features EFT (via Canada localization) T5018 (improvements in 2023 R1, ability to separate goods/services in 2024 R1) The following features will be supported in a future release:Multiple base currencies. Customers who want to run both US and Canada payroll need to implement 2 separate tenants PTO enhancements T4A (AP report)The table below outlines the stages and timelines of the rollout.Stage Tentative Date(s) Information/Activities Acumatica Demonstrations July 2022 Acumatica supervised demos using a previ

Can someone please assist? Thanks

When invoices are dragged and dropped in the “Incoming Documents” screen in the Payables module, sometimes they turn sideways. It appears to be happening when the invoice itself is created in Landscape orientation so Acumatica is attempting to align the image so it’s in Portrait orientation even if that turns it sideways.  Is it possible to have Acumatica align invoices so the verbiage is horizontal regardless of how the paper is turned?

Can anyone assist with why this error is occurring in our our system? We are two years into implementation with SWK Technologies and are still having basic errors like this pop up as we demo the system.  An error occurred during processing of the field Location value WARRANTY IN Error: Selected Location is not valid for receipts.

Hi I want to create same screen as Scan and Count Base screen.I will ScanPI Ref Nbr. Lot serial NbrI will not scan Warehouse and Location.I am trying to customize existing base screen. But After scanning PI ref nbr. i am not able to bring Lot serial Nbr. I have attached the Code of Maint and aspx code file.   

Hello,We are implementing Shiphawk WMS and having trouble with inventory adjustments.  Our stock items are valued as FIFO method, so I believe it is because the “Receipt Nbr” field in the IN303000 screen is not able to populate from Shiphawk.  Is there a workaround for this error so that we can make inventory adjustments from the WMS?

Production detail includes backflushed non-stock items for outwork so that the value of outwork is included in finished goods. Detail Lines are marked for PO and POs will be created from the production order. This does not work unless the non-stock item is not flagged to require receipt. You can create a purchase order outside of the production order as normal. There is no need to receipt the PO, it will be matched to an AP invoice. How to create POs from production orders for non-stock items without PO Receipting ? 

Hi , I Have Attached generic enquiry for three table i have created.Notification source, Notification Receipient , Customer But the customer table am not able to join with other two to display the customer id and name Anyone can suggest and help me to resolve this issue