Discussion Forums

We purchase stock materials directly for our projects. Often the materials come in with freight bills, which we historically have added as a separate line item & recognized as a separate account group to the project. However, we are looking at using landed costs to get the actual cost of an inventory item tied to that item - as sometimes we move that item into Free Stock. The question is, is there a report or clear way to show the landed cost variance just on project inventory? We would like to have a clear way to audit why materials are over budget if it is due to inbound inventory freight.

Hey Everyone,We are having quite the issue with acumatica because it seems it was not built for the way we run our business. I’m curious if anyone else has these problems. Our company very heavily relies on lot tracking and traceability. Basically, we need to know what lot was used in what, and what warehouse location it was transferred to and everything like that. And for this reason we are not able to just backflush inventory, we need to actually assign each box that we use to a production order. But in the instance of a production order, we usually issue a full 900kg of powder into a production order. That 900kg of powder has a cost to it, which is then given to the first move transaction of finished goods.The issue is that the cost (value) given to the very first move transaction is exactly the same cost of 900kg, even though in reality, we only used 50kg. Lets say we make 4 more move transactions, these next 4 have 0 value in the system. How is there not a way for the system to ac

How do i have to use PX.Data.XLSXReader to read a specific sheet of the XLSX-File?

Hello all,How much time does it take to implement & migrate the data into Acumatica for Construction Foundation license?

Good day,I have business event that updates the SO Line as Mark for PO.  It works fine.  However, we have come across an issue with it updating the SO Line when the Order has the same inventory ID.  The Business Event update only one line correct and leaves the rest.  The trigger conditions are below.Has anyone run into this situation?  My thoughts are it is due to with Raise Event selection. Thank you.  

Hello, My company has multiple cross references for each product. One is global, one is an ISBN, and another is a Customer/Vendor part number. On my SO report and Invoice report, I need to include the ISBN. I am having trouble writing the logic necessary to say that if the alternate type is GTIN/EAN/UPC/ISBN then pull the alternate ID. If null, nothing. Thanks​​​

Hello,  In the GI is there a way to add the open qty section per PO receipt number and in Acumatica report designer?  Thank you. 

Does anyone have any preferred setups for handling expenses incurred on corporate credit cards?For context: We have 40+ corporate cards held by employees, each of which tends to incur 1-3 charges per day due to the amount of travel involved in our business. A very large proportion of these charges are fuel but the rest could be anything from lodging to supplies to recurring subscriptions.We implemented the Acumatica Time and Expense Module with bank feeds to import transactions so that employees could attach receipts and code what the purchases were for. However, this has proven to be an extremely clunky system and isn’t working particularly well for us because:The charge doesn’t import on the day it was made causing employees to have to wait 1-3 days to be able to attach receipts and then it can take another 1-3 days to route through the approvals process The fact that you have to claim a receipt then create a claim for the receipts in order to submit everything is essentially giving

Hello, I am looking to create a GI that shows dead stock but includes production orders. If this is not possible, I would like to create one for production usage only. Any tips would be helpful. Thank you. 

Is there a way to copy and paste the previous Daily Field Report (DFR)? In our scenario, the foreman is responsible for entering the DFR for all field staff, including labor time and activities. Having to manually re‑enter the same information for all staff every day is time‑consuming.We attempted to use the copy‑and‑paste function for the DFR, but it results in the following error: “Sequence contains more than one matching element.”It would also be helpful if there were an option to upload the DFR instead.Thanks

Is it possible to set up a notification on the Bills and Adjustments screen so that users can understand the specific reason why a Bill requires approval? For example, when 'Remove Hold' is selected and the Bill status changes to 'Pending Approval,' the screen should display a notification explaining the underlying reason for the approval requirement.

We are implementing Acumatica and want an Inventory ID with 5 Segments. We have no Items created yet. The system will not allow me to reduce the first segment to 2 digits (see below). Can anyone help? 

Has anyone integrated Fresho with Acumatica?Our management wants to use Fresho to answer incoming phone calls and automatically create sales orders inside Acumatica. Has anyone done this implementation before?

Using an instance of 25.200.0020 (clean install), I need to customise screen AP303000 to add some fields (specifically AddressLine3), but on opening the Modern UI Editor from the Customization Project Editor for that screen, I get the error message: In HTML extension “C:\..\FrontendSources\screen\src\screens\AP303000\extensions\AP303000_PersonalDataPrivacy.html” for screen ‘AP303000’ child node ‘QP-FIELDSET’ has AFTER attribute with ‘#groupAccountAddress’ but screen HTML doesn’t contain any elements that satisfies such querySelector.I can work around this locally by renaming the source files AP303000_PersonalDataPrivacy.html and .ts (adding a suffix of .x). But I’m concerned that the same hack won’t be possible in production. 

I’m editing the email template for Dunning Letters.I want to include a sentence that has the due date for the overdue balance. 14 days from the day the letter is sent=Today()+14 isn’t something that works when I add it into the template’s email body. What’s the trick to get this to work?

Hi everyone,I'm new to Acumatica and currently working on integrating Certificate of Analysis (COA) data. However, I'm having trouble finding any custom endpoints or relevant screens that store or manage this data.I've searched through the default APIs and screens, but nothing related to COA has come up. I wanted to check if anyone here has worked with COA data in Acumatica before.Does Acumatica have a built-in module or screen where COA data is typically stored?Any guidance or best practices for handling COA data in Acumatica would be greatly appreciated.Thanks in advance for your help!

When setting up integration between Acumatica and Amazon using native connector, it is required to create Encryption Certificate on the SM200530 screen. This certificate is used to encrypt customer data fetched from Amazon. I could not find clear instructions on how to do it, especially if you’re a MacOS or Linux user.1 Generate a private keyThis creates a 2048-bit RSA private key. Keep this file secure -- it's the foundation of your certificate.Open Terminal app on your Mac or Linux machine, navigate to a folder where you would like to save the certificate file. And run the following command:openssl genrsa -out key.pem 2048The output file key.pem is your private key. Never share this. 2 Create a certificate signing request (CSR)This command generates a CSR based on your private key. OpenSSL will prompt you for several fields that identify your certificate. You can press Enter to skip any optional field.openssl req -new -sha256 -key key.pem -out csr.csrYou will be asked to fill in the

What 3rd party Product will you recommend for the user-configurable certificate?

I am reviewing a customized GI that my colleagues built that is now throwing errors on a specific field in a client site. We are receiving a “Divide by Zero error Encountered” when sorting or filtering this column It is likely this issue started after upgrade, as this client was just recently upgraded and this GI was built a year agoAny advice would be welcomed :) (the goal of the field is to show the % billed for projects)   

I created a Prepayment Request for 50% of a PO and processed the prepayment payment. After that, I received the goods, created an AP Bill for the same 50%, and applied the prepayment to the bill to close it.Now I’m trying to create another PO Prepayment Request for the remaining 50% balance, but Acumatica shows $0.00 remaining and won’t let me request any additional prepayment. It looks like Acumatica is reducing the PO’s remaining amount by both the prepayment and the AP bill.Is this expected behavior? If not, what’s the correct workflow to prepay 50%, receive and bill that portion against the prepayment, and then prepay the remaining PO balance?

Using V2021 R2.  When I try to send an AR invoice via email (in the invoice screen under Printing and Emailing or from the Print Invoices and Memos screen), I get the error message.  I can print to screen and then send to email from the print screen.What setting am I missing?

We have many customers set up with term cash discounts such as 1% 10 Net30.  We do not want the 1% calculation to include freight or tax.  The 1% should be on product only.  Is there anyway to accomplish this?

I would like a report showing the invoices for customers by ship to state. 

Hi,One of my client has a requirement to have multiple lines for the same GL Account in the budget. They are not willing to go for  a subaccount structure hence the default subaccount will be used for each line.Has anyone come across this requirement and is there any workaround or appraoch we could use, Thanks!

Hi Community,I am looking for a way to allow our approvers to track their own approval history across multiple modules. Currently, we are using Expense Claims (EP), Expense Advances, Purchase Requests (RQ), and Requisitions.In Approvals (EP503000) screen, once an approver approves a document (EC or Request), the record immediately disappears from the list because it is no longer pending.Specifically, I want each approver to be able to see their own "Approved History" (Approved items only).