Solved

I want to show a book mark history notes fetch from API call in customer screen (AR303000)I added the below grid <px:PXButton runat="server" ID="btnBookMarkHistory" Text="Book Mark History"><AutoCallBack Command="BookMarkHistory" Target="ds" /></px:PXButton> <px:PXGrid ID="PXGrid2" runat="server" DataSourceID="ds">     <Levels>         <px:PXGridLevel DataMember="BookMarkHistoryView">             <Mode AllowAddNew="False" AllowDelete="False" AllowUpdate="False" />             <Columns>                 <px:PXGridColumn DataField="Type" TextAlign="Left" />                 <px:PXGridColumn DataField="ShortNotes" TextAlign="Left" />             </Columns>         </px:PXGridLevel>     </Levels> </px:PXGrid>And my DAC is [Serializable] [PXCacheName("BookMarkHistory")] public class BookMarkHistory : PXBqlTable, IBqlTable {     #region Type     [PXString(10, IsUnicode = true)]     [PXUIField(DisplayName = "Typ

Hi Community,I have developed a report and used (BAccount.AcctName) as a parameter to filter by customer name. However, the parameter does not appear on the screen.When I configured it as a two-part key, the parameter appeared on the screen, but the lookup control did not show. I need the lookup to function correctly to display a list of customers for selection.Could someone help me on how to correctly configure the parameter.Any help or suggestions would be greatly appreciated!

Hello All,I have been working on an import scenario, where I have some blank values in Inventory ID column for which i would like to skip those rows. How can I achieve that?The data: The import scenario: 

Hi,I’m trying to create a generic inquiry to extract customer payment details (Account Number, Title of Account, Particulars, Code, and Reference) from this customer payment method screen, as displayed in be below screenshot.However, the inquiry is generating duplicate records and I’m unable to extract the correct details. I’ve attached the generic inquiry for your reference. Could someone assist me with this issue?

I’m looking for any insight into how best to get the approval date for a document. I’m currently working on getting the approval date for a PO, but I would think it would be the same for an SO eventually. Approved date looks to be in the EPApproval table, and I’m not sure how to link the PO to the EPApproval table to grab the approval date for the document. There is a refNoteID field in EPApproval that contains the po type and po number in the same field, and I can’t get it to link to that field. Anyone successfully pulled approval date before and can share how? Thanks!

We just switched our main web site to Shopify last week and we’re running into some very annoying issues with the Acumatica Shopify connector.   Customer account details on the General tab are repeatedly being overwritten when the Bidirectional customer entity is bringing customer data back from Shopify.  We’re on 23R1 and while we plan to upgrade soon, we cannot upgrade right this moment.The primary issue we’re seeing is that customer information on the general tab is being overwritten by whatever the default address is in Shopify.  This seems to usually be the address of the most recent Sales Order’s address (I don’t know if it is the billing or shipping address).  Not only does this change the address but it completely rewrites the account name. I have salespeople telling me their biggest accounts are just “gone” from Acumatica because they use the Display Name to find their orders and customers. These customers are still there but unless the person memorized the account number, the

We have encountered an issue we can’t seem to find the root cause of. SO has a Prepayment on it. Invoice is generated from ScreenId=SO3010PL (we attached to SO items to it there). Shipment is Auto Generated (Since we started from Invoice screen). Go back to the SO - it is closed but the prepayment doesn’t apply to the invoice 

Hello,  I am trying to use the primary contact email in the “To:” field in an email template based on the Request for Information Screen. Does anyone know how I indicate to use the primary contact email? I only see Relations.ContactID.Email and that keeps returning the first email in the list rather than the primary contact email.  

Setting up Process Orders screen with the goal of creating shipments 2 days prior to the request/ship date if the item is available. How do I set up the automation schedule for this scenario:Today is June 15th.SO00001 has a Request Date of June 17th.On June 15th, the shipment should get created automatically with a Shipment Date of June 17th. However, there are also scenarios where the item that is shipping is not available until the shipment date of June 17th. In these cases, the automation should run as soon as the item is available and should retain the shipment date/request date of June 17th. Current set up below: In this set up, it only works in the first example above. Today is June 15th, item is available, and the request date is 2 days from now.However, in the case this item was completed in production on June 17th, I would want the shipment to be created for June 17th. But with this automation schedule, it would create the shipment for June 19th instead. How can I create an au

Has anyone had success using an Amazon ASN as a cross reference number on the Stock Item?

I am trying to customize my dashboard widgets to only show open invoices excluding the credits, prepayments etc. I know how to go in and create filters on my reports. It would just be helpful in my collections process to have just open balances.

i want to print all the notes i have add.so how do i add this NOTES in Results Grid to my GI  

The reconciliation is balanced and ready to complete but the Release option is disabled.  There are closed reconciliation statements for this cash account dating back to 2023 and this is the first time we have encountered this problem.  Any thoughts on how to move forward?

Hello,In sales orders I change the quantity, but the discount amount field remains $10 instead of changing value due to the appropriate sales order count, in this case it must be $100. In below screenshot you can see that the discount for total amount remains the same.The percentage-based discount works correctly, but the fixed amount discount is only applied to 1 unit. When the sales order quantity changes, the total discount amount does not update accordingly.Do you have any solutions about it? Thank you in advance for your answers.

I am trying to understand the process for Scan Labor for INDIRECT labor codes. Normally MFG employees will be scanning directly into production orders for Direct labor needs, but we want to track INDIRECT labor for activities such as SWEEPING, ORGANIZING SHELVES, etc that will not be posted to any specific work orders.I was able to use the SCAN LABOR function to enter the indirect labor code, shift, elapsed labor time, and the employee ID. I was able to release that record, but there is no financial impact of this, as the labor rate and labor amount are read only and are $0. How do we impact the Labor Rate for these Indirect Labor Codes? 

Hi All, I just want to ask regarding how to restrict the visibility of all sales order records and only show my sales order records? Please refer to the screenshot below. Regards,Nadia  

I am trying to collect strings for translation. I have created a Translation Set and added some screens which I need to translate. After this, when I click “Collect”, the process shows error after running for some time “Another process has added the 'LocalizationResource' record. Your changes will be lost.”

I want to be able to create a side Panel on the Vendor Form,  In the side panel i want to view the vendor Inventory.Display this as a side panel on the above. But when i go into the customization, and try to add the vendor Inventory in the destination this view is not available in the list.What do i need to do to have the Vendor Inventory as a Side Panel on the Vendor Form?    

Good morning allI'm sure this is a simple question but currently I can't for the life of me think of what I should do.  I have 2 invoices that have been paid via BPay - so the payment has gone through as one.  It isn't letting me match the two invoices with the payment - even if I tick "Match to Multiple Payments".  Any help on this very wet and windy (Cyclone is coming) Friday morning. 

Hi!I’m wanting to use audit history to report on when a Project Task went from Active to Completed or Cancelled for example? Has anyone does this before, or can recommend the right table to use in a GI?

We are currently in the process of upgrading our Acumatica instance from 22.120.0019 to 23.109.0023.During the testing of our API integration, we have noticed that we are no longer able to push through a Sales Order that has a negative value in the Unit Price field, and we are presented with the following error: Incorrect value. The value to be entered must be greater than or equal to 0. I tried to capture a SO manually, to check if the same issue exists, and indeed it does:If I attempt to save the SO, it changes the value to 0.00 Question:Is this ability now completely removed, or is there a configuration setting relating to this that I can change to allow the negative value?PS. I searched through the release notes for 22R2 & 23R1, but I couldn’t find something specific to this.

One of our reports, the print invoice report, is now showing multiple of the same item. I assume its from a bad join, but I’m not sure where it is or how to fix it. 

Good day,I have multi branch/company environment.  I have a new Canada Company starting shortly.  Based on what I read so far is the CA Company needs a based currency of CAD and a separate ledger.  All the CA company transactions will be done in our CA Company, separate customers, vendors, etc.  Also a new cash accounts.Ledgers:  Do I need two CA Ledgers:  One for Actual and One for Reporting? Translations:  I need to be able to report in CAD and consolidate/translate into USD for consolidated reporting.My overall needs are to have CAD reports for taxes and Consolidated reports for Overall company financials by branch.Thank you in advance for your assistance.Evan

If a WC has multiple machine, I cannot stop Acumatica from scheduling the one WO in multiple machines. My customer wants to schedule only one work order per machine, so we have each machine as a WC with only one Machine.Based on Demand and capacity analysis, we have fixed machines for each SKU. the client checks the WC capacity and updates the WO’s Work center before releasing and scheduling. I am able to update the work center manually in the production details screen after putting in on HOLD. But I need to update the Work Center of open Work order via import, because at any movement I can have hundreds of work order which are open and which need WC center update.

Hi,I have problem with PXSelector on acumatica 24 R2, bql query worked fine for previous versions but not on the 24 R2. Now it gives odd message “The method or operation is not implemented”. My query looks like [PXSelector(typeof(Search2<InventoryItem.inventoryID, InnerJoin<POLine, On<InventoryItem.inventoryID, Equal<POLine.inventoryID>, And<POLine.orderNbr, Equal<Current<MyDAC.poorderid>>>>>>), typeof(InventoryItem.inventoryCD), typeof(InventoryItem.descr), SubstituteKey = typeof(InventoryItem.inventoryCD), DescriptionField = typeof(InventoryItem.inventoryCD))]