Solved

Where do the Notes in the body section from the OTHER tab appear on the mobile app? I was told these are internal notes for the Service Tech, but the notes don’t seem to appear on the mobile app. These are important as we want to communicate info to the Service Tech that we don’t want the customer to see and we don’t want to appear on the appointment documents or invoice.  

Does the Pending Approval Notification template get sent again when an approval is reassigned or delegated?

We have a client who received a double payment for an invoice in a previous month. Their customer wants to keep that prepayment/double payment on file for future use. A credit memo was created, but there’s nothing to apply it against, so bank rec is out of balance for the month in which the double payment was received. They are thinking of creating a “temporary” invoice to which they can apply the payment so that bank rec remains in balance. Then, when their customer want to use that prepayment to satisfy either new or existing invoices, they would reverse the “temporary” invoice, creating a new credit memo, then apply the new credit memo against the desired invoices. Does that make sense or can anyone suggest an alternative solution?

Scenario 2)  Vacation days must count towards weekly over time.  We have a PTO bank for vacation and must deduct any vacation hours from the bank.  My Earning Type code is setup as “Time Off”. I’m looking for ideas on how I can have vacation hours taken still count towards the weekly OT. Thanks in advance. 

I am importing BOM materials and I am required to convert certain items from LF to EA on import but the QTY Required field keeps giving me the following error “An error occurred during processing of field QTYReq: Specified cast is not valid”. Am I able to perform any math to this field? As soon as I perform any math I get this error. Take this for example: Simply doing 10/5 which should result in 2 on the BOM, but instead I receive the error regarding specified cast ...  Any help much appreciated. 

Hello,I have a client using Acumatica payroll and Construction. The client also has Union payroll. On T&M billed projects, they bill labor dependent on the 3 below items:Labor item (Journeyman, Foreman, General Foreman) Earning Type (RG, OT, DT) Union (SheetMetal, Carpenters, etc)The current Rate Tables in Acumatica only go as far as Inventory item. I know I could create a non-stock item for each rate type and union, but that’s not feasible for this client.I have created a very long IIF statement in the billing rule that works but it’s too long, the system cuts it off after 4000 characters. Is there a way to create a Rate table based off of these 3 items that I’m not seeing?

Hi, All I am trying to put notes on every customer. My login is successful but when I am trying to call put api through another script of python, its says you are not login in. I have attach my login code below. I have attach cookie in put request header but still it shows error. Any idea on this please. Thanks def login_to_acumatica():    # API endpoint    url = "http://my-company/AcumaticaSB/entity/Auth/login"    json_data = ({        "name": "ta",        "password": "Db}",        "tenat": "Store",        "branch": "",        "locale": ""        })    try:        # Send POST request with JSON body        response = requests.post(url,  json=json_data)        import re        # Check if the request was successful        if response.status_code == 204:            print("Login successful.")            print("Response:")            cookie = response.cookies              return cookie        else:            print("Login failed with status code:", response.status_code)    except Exception

After upgrading to 2023 R2, our Subcontract Audit report now adds Debit Adjustments to Paid to Date totals in addition to reducing Billed to Date total. Therefore, outstanding balance calculates incorrectly because it’s duplicating the reductions. Our implementation partner does not know when this will be fixed and is asking us to pay for them to modify the report. I don’t think we should be paying for something that was incorrectly programmed by the developers.Has anyone had the same issue? Were you able to fix it without paying a third party? If you did, would you be willing to share the fix?

I have a custom field that I created in my IN.InventoryItem table that looks like this:Previously I have this as 3 fields when I created it, published, and everything worked as expected.  I went back today to add a 4th field (EF in the first string, EFOY Trailer in the second string) Published the customization, but only get the original 3 options.  I tired to publish with clean up, but still did not get the expected results. Any ideas on what I did wrong, or what step I am missing?

gm,  , does the 1% get deducted automatically if the payment from a customer is paid within the 10 days of the invoice?

Hi, I’m a retailer with a distributor using Acumatica for their ERP. They gave me a login so I can check inventory balances in real time, but as we carry thousands of their products I need an automated way to check stock level daily.I noticed that their implementation seems to have some web services enabled via a SOAP endpoint when visiting a “Web Services” link from the SP700000 screen ([clientname].acumatica.com/(W(1))/Soap/SP700000.asmx). I’m quite familiar with developing Python apps so I’ve been working on using this endpoint to pull their catalog down into a CSV file.So far I’m able to connect and authenticate to the endpoint and run GetSchema, but when I request the fields I want the endpoint just times out. Even if I specify just one Inventory ID the endpoint just times out eventually.Here’s my code for reference:import requestsfrom zeep import Clientfrom zeep.transports import Transportimport csvimport loggingimport sysfrom datetime import datetime# Set up logginglogging.basic

I have a list of about 50-75 different Case Classes.  I want to add an attribute to all of them. Is there a way to mass update all of them?  Or do I have to do them “one at a time”?Just simply looking for an easy way.  If I have to do them one at a time that is fine.Thank you,

Hi, all orders coming from Shopify POS generate this error: “Object reference not set to an instance of an object.” What do you think I should check?

Hi,I'm trying to add a Business Event to add a SO Line when a Payment Method is CC (Credit Card).I have tried reading all online documentation, including a (to me) substandard video on the Acumatica learning portal itself, and other online video tutorials, but am not getting that info that I need to do this.  I would appreciate if someone could walk through the steps, and give an example.  I feel I am close, but can't get it to add the line.  In history it shows it running, but nothing is ever added.   I am sure I am missing something basic - like missing 1 step somewhere.   I wish the documentation was better.  It is pretty bare bones.I code, and do customization, but have never used the Business Events feature and trying to learn. Appreciate any feedback.I can post what I have done but I was really looking for a guide.  If there is a link that would be great but I have not found any links to do what I am asking, with any explanation.

We have a set of stock items, and those items are allowed to sell to only a customer.  Is there a way we can restrict so we don’t sell to other customers?

Can a Stock Item be available for sale to only one customer? We have custom products that are made specific for one customer and we don’t want these available to other customers or to be accidently sold to other customers. 

I am trying to build an import scenario that creates external user accounts for all of our active accounts.My desired outcome is below.  The users email address is the login name and the user record is linked to the contact record. When we use this in our external system, this is how we determine the customer that this user is associated to. I made this scenario but I can’t get it to work. I am unable to get it to link to the contact linked entity.  The mapping I am using is correct (ie: the string value for the display name matches the value in the linked entity box if I do it manually. Here is the design of my scenario: Here is the error I get when trying to processes this.  My assumption is I am mapping to the User Type and/or linked entity incorrectly. I am not all that familiar with import scenarios so I am hoping this is simple and obvious.  Any help would be appreciated! Thank you :) Eric

I’m trying to set the Company/Branch field of the Load Options(Load Documents) dialog from the Payments and Applications screen to default to the whole organization as opposed to a specific branch.However, the field is configured with the OrganizationTree attribute, which doesn’t have an obvious way of overwriting the default.Since this field resolves to a the Baccount of the branch or organization, I tried appending PXDefault(1), but no dice.Anyone deal with this before? 

We have access to Kit Specifications and Kit Assembly however we are getting this error. Is this a access right or something else blocking our company from the ability to create kits in Acumatica. “Error: An error occurred during processing of the field Kit Inventory ID: Error: 'Kit Inventory ID' cannot be found in the system.”

HelloI’m trying to submit create purchase orders screen Id: PO505000 the bellow images are my endpoints structure Top-Level from CreatePurchaseOrders endpoint, screen id PO505000 and Details from Details, in order to be able to submit multiple data at a timeand the action is Processthis is my url: https://{baseUrl}/entity/GTPDefault3/20.200.001.001/CreatePurchaseOrders/processwhile submit it with POST request it return 202 accept message,this is my json code: {    "entity": {        "VendorId": {"value": "V10106"},        "VendorName": {"value": "ABC"},        "Location": {"value":"05"},        "LocationId": {"value":"05"},        "VendorRef": {"value":"09078987"},        "CreationDate" : { "value" : "05/20/2024"}    },    "Details":[        {         "LineNbr" : {"value" : 2},         "Selected" : {"value" : true},         "OrderNbr": {"value": "Code-000395924"},         "InventoryId": {"value":"1MM650WHT-S"},         "OrderQty": {"value": 1.00},         "UnitCost": {"value": 20.00 },

Hi, each month when we Run Project Billings we get a handful of “Completed/Closed” projects that get pulled in because of “unbilled” transactions incurred for miscellaneous reasons.There doesn’t seem to be a default field or parameter to control this.Is there a way to exclude projects from the Run Billing process based on Status? 

I have an item we previously made in house, but are we’re now purchasing from an outside vendor. I’ve update the replenishment parameters and assigned those to our warehouse but the item is not populating on the Prepare Replenishment screen. The item is active, the Item Warehouse status is active, the replenishment method doesn’t have any launch or termination dates. I’ve tried deleting the replenishment method and adding back. I’ve tried overriding the replenishment settings  What am I missing here? What other settings would prevent this item from displaying on Prepare Replenishment? 

I would like to run a report with the data in the APTranPostBal “table”; however, it is hidden in the DAC. Has anyone used a variation of this in a GI (preferably)?  

HiI have a client who will be using ADP for payroll that plans on bringing in project related details using Project transactions.  The client has project specific rates for items and that works great for regular hours but occasionally they have overtime rates that need to be billed to the client.  What would be the best practice to accommodate the different billable rate? is it possible to have more than one rate on a rate table for the same item? One thought was to create a second non-stock item for each of their labor items to account for the overtime rate.  The client and I weren’t loving this option but were willing to explore. i’d love to hear what the community's thoughts are and what you may have done in the past? I appreciate your help in advance!