Solved

Hi Sir2020 R2 New Feature VideosWe understand that account code 40000 is for sales and 57300 is for Purchase.Currently , we would like to differenciate the SALES and Purcharse under different product. Not sure how to do it in order that balance sheet it will reflected into different SALES by product.  Hope to hear from you soon.Thank you 

Recently I’ve noticed an issue that after I publish customization projects our users report that their saved filters are lost.  Has anyone else experienced this? Is this a known issue?

Going Live this week and none of our Shipments created through the Fedex carrier plugin are showing up on Fedex.com (FedEx Ship Manager).  UPS shows everything we create.We also made an error and re-opened a Shipment that is currently in transit.  The label disappeared from the shipment.  #1.  Did we void that shipment with Fedex?#2. How do we get our shipments created with the Fedex carrier plugin to show on Fedex.com so we can manage them?#3. Does canceling and/or deleting a Shipment void the shipment with Fedex?  Would be so nice if we could see these shipment to determine if they do. Thanks for any help.  UPS was a breeze to setup and Fedex has been a big headache.

Hi SirWould like to check with you something related with sub accountCurrently , our subaccount is xxx-xxxx ( Dept-Analysis),  2 segment key We would like to add in one segment key for project become xxx-xxxx-xxxx (Dept-Analyis-Project), 3 segment keyIf we add in new segment key, is is there any impact for those transaction is only 2 segment key?Any issue when we run any report , like trial balance, BS and P&Loss?Hope to hear from you soon.Thank you

Has anyone successfully set up the Procore Integration?  If you have, would you be willing to share the company that helped you set it up.  We’re looking for someone to help with our integration.Thanks! 

First time using the InStr function.  I’m simply using it within an import scenario field expression to set a checkbox field to true or false based on whether a specific character is contained within a data field in my excel spreadsheet being used as the data provider.  Seemed pretty simple, but it’s not acting at all like I’m expecting.  I’m pasting an sample of what I’m doing, I’ve been trying many different gyrations but nothing seems to be working like I would expect.  The second line is just hardcoded where it should return 0 since 2 is not in the string 1345, and then should set to checkbox to false, but it always checks the box when tested.  Maybe it doesn’t return 0 as I’m thinking?  Not sure.. Any help or suggestions would be appreciated. 

Customer is on version 2019 R2 and is wondering if this version includes the 1099 NEC changes.TanyaClient Success Manager

Out of 6 clients who went live, we encountered 2 clients having issues to export reports to PDF.1 client with 2 companies, had issue in 1 company having 5 branches, i.e all 5 branches in the 1 company are affected.This happens in 2019R2 build 19.205.0023. Anyone encountered this before?Trace on why cannot export to PDFAppreciate any valuable input.

When we send an email from our Shipment screen (SO302000) using Actions>Email Shipment, the emails that get generated are almost identical to the Notification Template it must be using (ID: ShipmentConfirmationNotification), except there is one line inserted “Track your shipment at [Tracking Link]”.  Unfortunately, that [Tracking Link] placeholder doesn’t use the tracking number to populate. I can’t determine where it is getting this change to the template.  It is the only Notification Template related to Shipping at all.  There are no changes in the customer’s Mailing Settings or the Sales Order Preferences Mailing Settings.  I’d like to delete that line, but can’t find it, plus you cannot alter the email before processing it. We are running 2020 R1 build 20.106.0005 with the Manufacturing Edition. Any help would be great!  Thanks!

Hello,       Correct me if I am wrong, I remember in previous version (before 2020R2). If the Actions--->email sales order/Quote be clicked,       The checkbox “Emailed” will be set to true.             However, in “2020R2 build203” it will not come to checked status even if the action be clicked.Did I remember wrong, or is it a glitch?            Please help me if I would like to make it true automatically to identify these been emailed orders.How can I achieve it?Thank you.

I have a simple table and a grid to add records to it.  The Account Mapping grid works.  But on the Branch Mapping grid, when I click the “PLUS” icon, the icon goes grey and no new row is available on the grid.Before clicking PLUS This is what is looks like after clicking the PLUS icon: The table is very simple.   When a Company is selected, the view for the grid is         public SelectFrom<ICSBranchMapping>            .Where<ICSBranchMapping.organizationID                .IsEqual<ICSSetup.organizationID.FromCurrent>>.View BranchMapping; The ICSSetup table is even simpler:  If I create a new record in ICSSetup, it lets me add 1 row to the ICSBranchMapping table But I cannot add another row.Here is the DAC for the ICSBranchMapping table The records in the DB all look fine after adding the 1 row it will allow me to enter.The action button is a dummy.  The code has been commented out to ensure it has nothing to do with the issue.I forgot to mention, I CAN update the exi

Hi:If somebody has a question or issue with this community portal, there should be a community contact form? I couldn’t find one. Please add one to this portal. Thanks

I can retrieve data from the POLandedCostSplit table in the database: But I can’t find a Data Access Class that will allow me to retrieve the POLandedCostSplit data: I need to retrieve the data using a Generic Inquiry and I’m trying to avoid having to create a SQL View.Does anyone have any ideas?

Does anyone what the difference is between the N and O LayerType values in the INCostStatus Data Access Class (DAC)?I’m also wondering if there are any possible values other than N and O.INCostStatus is the DAC that stores inventory costing layers and it’s used in the Inventory Valuation (IN615500) report.

Hello,       I have a requirement that set freight as $5 by default for every sales order ship from 1 particular warehouse.                   For that particular warehouse, the customers are fixed. That warehouse served customers can be identified. So, this question can turn to set fixed freight for particular customers.       I am thinking of Acumatica’s “freight calculation”, but it seems to be dynamic not fixed. It is calculated based on order’s amount, volume or weight.              We don’t need it to be complicated, we want to set it be fixed $5.          Can anyone give me some suggestions?

Is there any way to see the Adjusted Cash balance in Acumatica?  it would essentially be the the value of bank account, plus unreconciled checks, minus unreconciled receipts, plus other adjustments such as reversals?  This is especially valuable when doing cash management exercises for bill payments.   Maybe this functionality already exists, but we just don’t know about it?

Hi:I was surprised that the Scanco WMS is not anymore in the Acumatica marketplace anymore? What happened? Is the integration still available? Please let us know when an ISV application is taken out of the Acumatica market place, and why. Thanks for your helpToon SIx

I’m having an issue with an SO that was shipped and then the invoice reversed.The steps followed were:Create SOCreate ShipmentCreate Invoice from ShipmentReverse Invoice in AR module and create CMApply CM to invoiceThe invoice is generated correctly-no issue there:InvoiceBut when the credit memo is created, instead of crediting COGS and debiting Shipped-not-invoiced, it debited COGS again and credited Shipped-not-invoicedCredit MemoAnd I’m left with this that I don’t know how to fix: 

Hello,Thanks to Gabriel’s help. I can get the data I want in GI using a second filter.  like below:   The key in the join condition is that “INitemsitehistday” might only have qty in record，no sales record     So if “left join” used， might get a joined line with INitemsitehistday.Sdate as Null. This filter out  is working well in GI.However if I would like to apply the same kind of second filter by using the visibility section setting in report Designer. The “ Or [INItemSiteHistDay.SDate] Is Null” does not work.  Then can somebody help me to get the data I want in Report designer?1， Not sold in 90 days2， never sold， which left join get a NULL value

I have some payment date data for different  customer in an excel spreadsheet. How can i bring that data to ecumatica to create a dashboard where i can see the list of the customers payment due on a particular day?

I need to create an import scenario for the Transfer Order (Sales Order) screen that will select a pre-configured template from the clipboard to load the Transfer Order detail lines.Has anyone successfully done this? 

Does anyone have the Acumatica-Procore integration set up?  Does it work well?  Are there any issues we should know about before getting this set up? Thank you!

Does any one know how to recognize the last row of an import?   I am trying to have it insert a particular account number at the end of the import to balance the GL batch. Thanks 

I have a set of sales that I wish to isolate and reclass to a different account. Has anyone done this before? I’m not sure how to handle the shuffling out of one account into another, the finance segments in ACK have always been a weak-spot for me. Any help is greatly appreciated.Longer explanation: We started up a new division, but we didn’t know it would be it’s own full division until it grew. So now I need to take the sales for those items and put them to a new class to show a new profit center on our P&L. I can find the old/new accounts and sub accounts easily enough, but actually deducting from the old account and attaching everything to the new account without wrecking my system has me a bit nervous. Thanks in advance for your help!

Hi Team,Could you provide a description how I can receive Send Invoices by Email checkbox using API?I cannot fina a link to the API description.