Solved

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.  

Hello,     In most cases, we apply payments to invoices.       Just some times, we would like to mark the payment for Sales order before shipment.       We want to use the “load orders” function under “Orders to Apply” tab to load orders of this customer all in once.         However, if this customer has had 1 “Cancelled” Sales order, this function will pop up errors. I know at least 2 ways to work around:1，just delete that cancelled Sales order2,  select the selection date frame to skip that cancelled SO. But both take extra and unnecessary efforts.        I truely and fully understand “canelled”, “voided” Sales order can not be applied to payment.Can the system directly ignore/skip these documents when people do the “load orders” fucntion? 

Hello, When I set the value of GetExtension, the variable gets null.          foreach (SOLine soline in listOfLine1)            {                SOLine line = new SOLine();                //…. code                var lineExt = SOGraph.Transactions.Current.GetExtension<Objects.SO.SOLineExt>();                lineExt.UsrMargeLine = GetPercentMargin(line);                SOGraph.Transactions.Insert(line);                SOGraph.Actions.PressSave();            }Best regards.

I am new to developing forms in Acumatica and in Acumatica in general, my coding knowledge might be just starting to hit intermediate level, although with C# I would say I am still basic.  However my issue doesn’t seem to be code related it seems to be more of an issue of me not understanding HOW the sorting works in Acumatica.  On the Pick List form on the Detail Section 1 area (not kits the next detail area) it has 2 fields that I want to sort by,  SOShipLine.InventoryID OR SOShipLineSplit.InventoryID.  I put those 2 fields in the Schema Builder in the Sorting area, however it completely IGNORES anything I seem to put there, I tried with the out of box form and our customized form and the sorting does literally NOTHING in BOTH cases so I clearly must not understand something, I will attach the relevant pictures.  If someone could explain to me how I can get this form to sort by the InventoryID instead of the BIN location or anything else that is what I need.  I thought this would be

My company is newer to Acumatica (since April 2020) and our old software (Everest) used to be able to handle transactions in this way very easily, here is a hypothetical scenario:We are a car dealer and a customer is making a purchase of a new vehicle. The vehicle is in my inventory as a whole unit. The customer wants to upgrade the wheels on the vehicle, so we need to swap them out. We take 4 wheels out of our stock and install them on the vehicle then restock into inventory the 4 wheels that originally came on the vehicle. Then we sell the car. We can later sell the 4 original wheels to another customer.In Everest you can simply use a negative quantity (-4 wheels) on the sales order which in this case would bring 4 of the original wheels back into our inventory stock. Then put positive 4 of the new style wheels on the same sales order, effectively "swapping out" or "trading back" the wheels.This type of transaction happens ALL THE TIME, multiple times daily here at my company and I h

Hello I want to create a task when a Quote is created with for the user to follow up, i was following all from https://www.augforums.com/forums/acumatica-import-scenarios/automatic-task-creation-with-business-event-and-import-scenario/ which is working fine, when i cant find a sloution is to specfy that the start date and the due date, i

In the Acumatica Configuration Wizard - Database Configuration, when using SQL Server Authentication, the error below appears. What privileges are needed, and how are they set? 

Hello, I am using a GI as the data source of a export scenario.When in GI, if I assign the schema field, then I could get the 2 place decimals as I expected.However, when run by export by scenario, I still get more than 2 place decimals, which I don’t like. How can I make the decimals become 2 places?

I’m curious to find out if the native shipping integration services we have in Acumatica, does it have the capability to support Multi-batch shipment feature like Starship or other shipping solutions?If we integrate with EasyPost then can have have this capabilities within Acumatica or do we have to handle the multi-batch (which is multi-shipment of same order to multiple shipping address and it could be same item sent to multiple address of different quantity) Any product experts here that can verify and let us know how best to solve this real world scenario?  

Acumatica’s payroll tax set up does not allow for the entry of the mandatory SOC codes. Is anyone else needing to report to Indiana?

Is there an easy way to disable the RELEASE button in Inventory Adjustments for a specific user? If not, how do you set a role for this? I have this role shared with many users, so I’m hoping not to make a duplicate role with this single field disabled in it if possible.

My company hire me for their WMS. I did some research and found Acumatica also has WMS. My question is how can I use it? It’s a add-on or I just need to upgrade our Acumatica to 2020R1? We are using 2019R2 now. 

HelloI dont know what wrong with this code : using System;using PX.Data;using System.Collections;namespace Attributs{  public class AttributsForm : PXGraph<AttributsForm>  {        public PXSave<ZattributsPlan> Save;    public PXCancel<ZattributsPlan> Cancel;    public PXSelect<ZattributsPlan> MasterView;        public PXFilter<DetailsTable> DetailsView;    [Serializable]    public class DetailsTable : IBqlTable    {    }        public PXAction<ZattributsPlan> CalcPrice;    public PXAction<ZattributsPlan> CalcTest;    [PXButton(CommitChanges = true)]    [PXUIField(DisplayName = "Param Liste 1")]    protected void calcPrice()    {    }          [PXButton(CommitChanges = true)]    [PXUIField(DisplayName = "Param Liste 2")]    protected void CalcTest()    {    }  }} I have this Error:  

 Hello, we are using 2020R2, Build 20.203.0028. Our operation stuff report an issue, that 1 shipment is still confirmed status while the invoice and IN issue doc already been generated and released.  I don’t know the user’s steps and he could not remember. And this issue happens to only 1 shipment not all. And previously in 2020r1, we didn’t encounter this kind of issue. So my large guess it is causing by our recent upgrading from 2020r1 to 2020r2. see below:  Since this issue happened only once, the root cause might not be easily found.Can anyone firstly give me some directions to quickly fix it, I mean, might correct the shipment status to right.If I simply update it in DB to status completed? Is it a good way to go?And if the root cause could be guessed out, it would be very helpful for us to prevent this same kind of issue in the future.Thank you.

Hello,I have a shipping dashboard setup to show a list of orders that need to be shipped. This contains a basic filter based off of warehouse (either MFG or RDD) and the status of the shipment (open). However, shipments seem to disappear from the widget, this seems to happen to older shipments. I have the record limit for the widget set to 30 for this widget, and I know that we are not having more than that many records listed on it at once. Here is the filter for the particular widget:shipping widget filter  This is the list of shipments returned from the filter above, notice that #1346 and #1379 are missing.shipping widget  On the acumatica shipments page you can see that shipments #1346 and #1379 both meet the criteria from the above filter, yet they are not shown on the widget.shipments screenI am hoping that someone can assist me in fixing this. I would greatly appreciate any input! This is happening currently in 2020R1, and was previously occurring in 19R2 as well. 

Hello Ladies and Gentleman,i drove into a problem today.I created a Push-Notification which outputs through a webhook, whenever a ticket is created, or changed, or deleted. I now would like to get these informations to Discord. Discord allows you to create a webhook URL which u technically could or should be able to paste into acumatica. But whenever i trigger the webhook, nothing gets posted inside of my Discord Server. I checked if the webhook works on pipedream. So there are definitly notifications going through the webhook.Any ideas? I don’t know what i have to do at this pointInside of Acumatica i get this Error Message: Send to target Discord failed. Message: WebHook returns not success code: BadRequest; Message: {"message": "Cannot send an empty message", "code": 50006}orSend to target Discord failed: WebHook returns not sucess code

Anyone know if there is a way to print or view a report/inquiry of the GL posting of a payroll check before it is released?  I keep getting a G/L out of balance error when I go to release the check.  Not finding any answers in knowledgebase or general community search.  Any ideas are greatly appreciated.  Is there a good point person from Acumatica to ask payroll questions of or is this the best place to post questions of this type? Thanks Kathy

Using this code, accumatica create my new SOShipment from the new SOOrder. The new SOShipment is associated in New BranchId and that we need extactly.Problem : the ShipmentNbr of new SOShipment get the perfix of the Old BranchIdSOShipmentEntry soShipmentGraph = PXGraph.CreateInstance<SOShipmentEntry>();soShipmentGraph.Clear();DocumentList<SOShipment> created = new DocumentList<SOShipment>(soShipmentGraph);SOShipment sOShipment = new SOShipment();created.Add(sOShipment);soShipmentGraph.CreateShipment(newOrder,5, newOrder.OrderDate, true, SOOperation.Issue, created); 

I was able to create a custom Table + Custom FormBut when i try to save the record nothing Happen CREATE TABLE [dbo].[ZparamAttributs](    [CompanyID] [int] NOT NULL,    [TexteLibre1] [nvarchar](35) NOT NULL,PRIMARY KEY CLUSTERED (    [CompanyID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO//*************************************************************************************************<%@ Page Language="C#" MasterPageFile="~/MasterPages/FormView.master" AutoEventWireup="true" ValidateRequest="false" CodeFile="GL202599.aspx.cs" Inherits="Page_GL202599" Title="Untitled Page" %><%@ MasterType VirtualPath="~/MasterPages/FormView.master" %><asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server">    <px:PXDataSource ID="ds" runat="server" Visible="True" Width="100%"        TypeName="PlanComptable.ParamAttributs"        PrimaryView="MasterView"        &

Hi Anyone know what is the problem below?We have make fund transfer in SGD currency (CF000057,SGD200,000 exchange currency is USD146659.42, However the journal transaction’s (S20110554) amount is not tally with Fund Transfer figure. I done 5 same transaction and only one transaction is capture incorrectly. Could anyone can advise what is the problem? How to make the adjustment in order to capture the correct figure? Hope to hear frmo you all soon 

Hello，       I’d like to pass the parameters like date selection on GI to its side panel.       Is there a way to do it?       It looks like I can not put the “@DateFrom” as the navigation parameter.  

Hello,        For example, the system are having a scheduler “send all emails” at 2 minutes interval.        Yes, the execution log is helpful for troubleshooting. However, it might also cause a lot of records that are not quite useful.         Can I turn on/ turn off for each scheduler the log?        Or can system automatically clean the historical log that are more than like 30 days ago?

Hello,      We don’t generate “Back order”  in business.That is, even if the soline is not shipped in full, the soline would become completed after shipment and the OPEN QTY on soline would become 0           But I checked, this item on its shipment line would remain open qty on screen.     However, when I trying to make the conditions in GI, I can not find the SOShipline.OpenOrderQty field.      Since GI does not support the condition in formula like:  SOShipline.OrderQty - SOShipline.ShippedQty >0           How can I filter out the items that did not ship in full in daily business?        Thank you