Solved

hi! is there a smartsheet integration customization available for 22r2? i see the client has one for 21R1 but im having trouble publishing that

I have created one report and it has one parameter but it does not show when i am going to its screen. Not sure what is the issue here. Visible option is also selected. My report screen looks like this. I want my text-box field there for input to run my report. Thanks.

Hello, I’m struggling with the FieldUpdated event. On the Project Quotes form (PM304500) you enter Inventory IDs on the Estimation tab. When you commit an Inventory ID on a grid row, the description, uom and unit price are returned. Very similar to entering products onto a sales or purchase order. I would like to ignore the default price returned and update the field with my own value. The screen shot above shows that when SOFTLIC was entered the unit price was defaulted to 666.00I’ve tried using the following (heavily cut back) code to update the unit price field but it’s not working, 22 doesn’t appear in the field: protected void CROpportunityProducts_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e) { var row = (CROpportunityProducts)e.Row; string val = "22"; cache.SetValueExt<CROpportunityProducts.curyUnitPrice>(row, val); }I’m pretty certain that there is another event in the Acumatica code which is firin

I added a few selector fields as UDFs in Cases. As you can see in the screenshots, when accessing in the web, the selector field works. But in the mobile app, there is no magnifying glass icon for me to select the options. Instead, it’s just a text type field… Am I missing something easy or does this functionality require customization to the mobile app?  

Hi There,I have issue to import the AR opening balance in Acumatica under migrate mode. I was able to import the data from template but not able to import the transactions. I got several errors;1)Field: Amount, Value: 871.34, Error: The document is out of the balance. Field: Balance, Value: 871.34, Warning: Enter the document open balance to this box.This is initial error message I got, however the amount is tie out. It’s in the same function currency. I tried to clear the amounts to import the transactions. However, I got another error message: “The Remove Hold button is disabled. Field: Balance, Value: 0.0, Warning: Enter the document open balance to this box. Field: Project/Contract, Value: 8SB       , Warning: The customer in the selected project or contract differs from the customer in the current document.” Attached Import scenarios details. Could you help review and advise how should I adjust to complete the import? Thank you very much!

I was hoping someone may have some insight to this question.  I am coming up with a large WIP variance in our Production Orders, and are thinking Phantom BOMs might be the cause. At the parent level, we backflush material and labor.  We also exclude the Phantom, thus allowing us to bypass the move in the production order. At the BOM for the phantom, we have run rates as if we were going to make a Production Order and backflush labor and material. Is the WIP variance related to excluding  the phantom and thus not capturing the labor?

Is there a way to access files that are attached to an invoice from outside? We have synced all invoice to a payment portal.Many customers want to access the original document that our accounting upload to the invoice in Acumatica as attachments. I cannot find the table that records the relationship for invoices and files. any advice, please. Many thanks advance. 

Hi expert.I want Show Total Line Show Pages Nbr - Convert Purchases to Assets FA504500 (same in Sale Orders Screen)Can you help me? Thank you so much.

I followed instructions for: initial Configuration/Step 1: Preparing the EnvironmentSuccessfully installed AcumaticaERP, with Debugger Tools (NOTE; I did NOT install Acumatica Framework) Acumatica was installed on my PC at C:\Program Files\Acumatica ERP\AcumaticaERPI followed the instructions for: Step 2: Deploying the Needed Acumatica EPR Instance for the Training CourseThe PhoneRepairShop instance was installed on my I PC at: C:\Program Files\Acumatica ERP\PhoneRepairShopI followed the instructions for Lesson 1: Creating a Customization ProjectI set up the downloaded Acumatica code from Github, at: C:\Acumatica\Help-and-Training-Examples-202R2 I successfully completed the step: Loading the Items to the PhoneRepairShop Customization ProjectI followed the instructions for: Step 3: Binding the Extension LIbraryI copied the PhoneRepairShip_Code folder to C:\Acumatica\PhoneRepairShop\Projects I then Opened Visual Studio (2019 Community Edition) to build the project The build failed with o

I don’t know what I did or how I ended up with this happening but when I try to edit any generic inquiry from the Customization menu (at the top when viewing the GI results) it shows the correct configuration but the name of another GI.  Always the same GI: pp-oils to convert to template.The URL at the top shows the correct Name so if I refresh the page it shows the correct details which is a workaround but as it stands if I edit it and just hit save it will overwrite that GI and not save to the one I really want to save to.I am stumped as to why this is happening. It happened after I manually added some site map entries but I’m not sure how or why.If anyone has any ideas of how to troubleshoot this I would be very grateful, Phil

Looking for help in modifying standard Acumatica forms such as the sales order and sales invoice to include all of the product configurator results data.  For those using the product configurator, have you modified your forms?  There are instructions on Acumatica Help for adding the data, along with a pdf copy of what it should look like, we would like help in doing this for our client.Please reach out if you would be able to assist. Thanks  

I’m trying to create and confirm a shipment all in a single Rest API call. I’m trying to do this in Postman first just to see it work. What am I getting wrong?POST URL: http://accounting/(W(1))/entity/Default/20.200.001/Shipment/ConfirmShipmentStructure:{    "entity": {        "ShipmentNbr": {            "value": ""        },        "Type": {            "value": "Shipment"        },        "Operation": {            "value": "Issue"        },        "ShipmentDate": {            "value": "9/13/2022"        },        "CustomerID": {            "value": "CUST2943"        },        "WarehouseID": {            "value": "XODUS"        },        "ShipVia": {            "value": "UPS NXT DAY AE"        },        "OverrideFreightPrice": {            "value": true        },        "FreightAmount": {            "value": 5.67        },        "Details": [            {                "OrderType": {                    "value": "SO"                },                "OrderNbr": {                    "va

I have built a GI against projects (we have an attribute called "delivery date" ) to give our delivery drivers a view of what they need to deliver to site from the facory today. The GI works nice and comes across to the mobile app real well, but I want to have it so that the delivery driver can tap on the project in his filtered view and it will open the correct project for him to upload photos of proof of delivery directly to the project. Currently they have to jump out of the delivery view and search in the project for it. Example of how today's deliveries look in the app... If only we could just tap on these … 

Migrating from Quickbooks online to Acumatica. Attempting to doi the whole process by myself. Is the any step by step  instruction or documentation on this 

Hello,Is there a way to recognize a PDF file that contains two or more invoices? (That is can it create two/more bills from a single PDF)

I’m trying to generate a GI connecting the InventoryItem table to the POVendor table.  I want to limit the results to only show the default vendor and vendor inventory ID assigned to each item. However, if an item has multiple vendors assigned the results will display multiple lines for that item.This “IsDefault” field does not appear to exist as a field by which I can filter the results: Does anyone know of another way to go about this?

I am uploading 2020 and 2021 Journal Transactions. Whereas, the 2020 entries were accurate, the 2021 entries do not appear to include opening balances. This is only happening on various Companies and GL Accounts.

I’m trying to add a the Qty. on Supply from the prepare replenishment page to a Custom GI page. I tried different ways to link the relationship but I can’t get any numbers to show up. Can any help guide me on what I did wrong in the relations?   

Hi everyone,A customer with On Hold status placed an order from BigCommerce. When we synced it, there is an error saying that the customer is not active.Is there a setting where we can allow non-active customers SO to be synced?  

All. We recently transitioned to Acumatica and in the banking module the is no Bank feed option or feature. Do i have to manually add this feature and how or is the enabling function i am missing

Hello,How do I delete or cancel an item on a Request in Purchases? I click the “cancelled” check box and it still shows up in selection for a requisition.    

How has anyone set up box barcodes in Acumatica for shipping? When using the mobile app, it asks you to scan the box when you pack. You can simply type in the box code such as A but the client would like to scan the label for the box. Any thoughts or suggestions?

Hi,Would anyone be able to give some guidance on if it’s possible to add the SO # to the account details screen. I noticed there is an account details GI (see screenshot). I know if you click the reference # for the IN module, it brings you to the Issues screen where you can see the SO number. I can’t figure out how to link those two tables (if that is even possible).Any guidance would be greatly appreciated.  

What causes Discrepancy in AP and GL account?Below Discrepancies with AP and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Payable.Items marked in GREEN are GL Journals that need to be reversed  Row Labels AP GL Grand Total (blank)   633,263,334.12 633,263,334.12 CHE005 1,385.29 1,026,146.72 1,027,532.01 CRO001   -11,135,600.00 -11,135,600.00 GIL001 3,032,803.84 22,211,198.21 25,244,002.05 JAM001 5,189,640.00 -2,062,640.00 3,127,000.00 NDU001 0.00 -10,795,608.00 -10,795,608.00 (blank)       Grand Total 387,841,130.29 252,889,529.89 640,730,660.18   

What causes Variance in AR and GL account? how can we correct such discrepancies?Below Discrepancies with AR and GL Account.Items marked in RED are as a result of Application generating unexpected Gain/Loss Amounts and Adjustments in Accounts Receivable.Items marked in GREEN are GL Journals that need to be reversedVariance Between AR and GL Customer Customer Name AR GL Grand Total           (blank) (blank)   -287,877.69 -287,877.69 AGA001 (blank)   -39,399,922.38 -39,399,922.38 LAN001 LANCET LABORATORIES TANZANIA 519,130,795.22 -519,398,673.64 -267,878.42 MIL001 (blank)   1,000,000.00 1,000,000.00 Grand Total   7,496,567,071.64 -7,535,522,750.12 -38,955,678.48