Distribution

2021R2 version.  We receive an EDI 850 from our customer.  Through True Commerce APIs, we create a sales order in Acumatica.  Later, we receive an EDI 860 change order from our customer.  Our business does not want this change order to be automatically applied to the existing sales order in Acumatica.Instead, our business wants us to generate an exception report that lists the content of the 860 (e.g. header info, line item data) and generate exception messages where the 860 change order is different than the sales order on Acumatica.  For example, provide exception message that the line item quantity changed, or that a new line item was being added to the sales order.  This exception report would go to the customer service rep., who would review the changes and manually enter them on the Acumatica sales order if accepted.  Has anyone already built functionality that creates custom change order tables (header, lines, notes), and then matches this to the sales order alr

When confirming a Pick List i always get the error:Another process has updated the 'SOPickingWorksheet' record. Your changes will be lost.Create Sales Order Create Shipment Create Pick Lists with “Create Single-Shipment Pick Lists” Check “Send To Picking Queue” and “Confirm Shipment on Pick List Confirmation" Start “Pick, Pack, Ship” - Next List - Scan Location, Package, Item - Confirm Package - Finish And Next ErrorSetting: PackOnly  What am i doing wrong? In 2021 R2 it worked this way.

HI all, Can you help me about my problem here in Report Designer. I created a number wording for the printing of Checks, but my problem here is how do I insert the word of “PESOS” like this output: SEVEN THOUSAND THIRTY SIX PESOS AND 19/100This is my coding in report designer = IIF([APPayment.ExtRefNbr]<>[APPrintCheckDetailWithAdjdDoc.StubNbr],'* VOID *',PadRight(UCASE(replace(replace(' ' + [APPayment.AmountToWords], '  ', ' '), ' ', ' and XX/100')), 60, ' ')) If I insert the PESOS from this codePadRight(UCASE(replace(replace(' ' + [APPayment.AmountToWords], '  ', ' '), ' PESOS ', ' and XX/100')), 60, ' ') the word PESOS is not showing (no error encountered while saving this)

Hi everyone, I want to set approval condition when PPV field is non-zero but I don't see PPV Amount field on assignment maps screen, anyone have an idea to set up I’ve already tried to set up on another screen (Bills & Adjustments) or purchase order but it doesn't work. 

Has anyone found a solution for handling secondary or overflow bin locations in warehouse management? We have several items that say, don’t fit on Shelf 1 (because we stock so much of it), so the rest of the inventory on hand might be on Shelf 2. Currently, I do not see a place where I load this information into the system, therefore the picker only knows to go to shelf 1 and pick what is there. He does not/will not know there might be more inventory in another location. Has anyone come across a solution for this?This will also cause problems with physical and cycle inventory counts.

Hi,I am trying to create an A/P Approval Workflow so it’s based off who entered a PO that is linked to a Project or Owner who created the PO under Purchases. Sometimes this workflow will require a 2 step approval process or a 1 step based on who entered the PO. I can’t get it to work. Here is my configuration. What am I doing wrong. Any guidance would be appreciated. Thanks. Here is Step 1:Here is the Condition for Step 1: Here is the Rule for Step 1: Here is Step 2: 

Hi All, Can you help me about my concern, this is the scenario we do After publishing a customization, Test some procedures from Purchase Order (PO) Select vendor, In Document Details when I select the InventoryID, and the error suddenly appears and it says “error occurred during processing of the field InventoryID: Error: An incorrect type of extension has been requested ”  I also checked in Stock Items and all the inventory items are active  What should I do next? Thanks

Hello all,Can anyone let me know from where can we display this Allocated text in the footer of the screen?The build version of the instance is 22.113.0040 Thanks in advance.

Hi All,I am trying pull kit specification information into stock items ->general tab.Suppose, a stock item is a kit and when this item is selected it would display the details of its components from kit specification screen.Is there any way to achieve that?

Hi team,I am looking for a “job traveler” or print version of the kit assembly.The folks in the warehouse need something to go by, when they assemble these kits.Thank you!Monika

Hi there,I try to add serial numbers to stock kit items.Do I add the serial numbers during the assembly process?Thank you!Monika

Hi everyone,I saw the “Pick,Pack and Ship” screen has a setting that is Print Shipment Labels Automatically. I want to use it with Device Hub. How do I make it work? I can’t find any docs in official guideline. Anyone knows? 

I get the following error when trying to delete matrix items from the template: Attribute 'COLOR' is required by the template but is not set Not sure what it is missing, everything seems to be set correctly, was able to create the items no problem. Has anyone come across this issue? (yes I realize Deleting is misspelled in the header. cant change it…..)

Can someone please help understand the difference between the following screens:The Invoices screen under the Sales Order section vs Invoices and Memos screen under the Receivables section. Attached screenshots below for reference. Img1: Sales Order > InvoiceImg 2: Receivables > Invoices and Memos Thanks!

Hi Everyone ,Pleaase Assist . i have client that would like to get a POR report that excludes returned receipt lines. I thought i could use the returned Quantity of receiptline DAC.However this field is not available on the report , i check the DAC and it gave me the following : the field is no-existent in the DBIs there a way i cant exclude returned receipts except for this one, please assist.

Question the article belowShould the customization go on SO301000 (from instructions) or SO302000 (from screen capture ) or SO503000 for Process Shipments or all three ?  

For audit reasons, our system admins cannot do mass actions where transactions are involved.  I need to allocate this access to a user, but I can’t seem to find any information on access when it comes to mass actions.  Please point me in the direction on some documentation in this regard!

We have multiple companies with different warehouse. Users are restricted to their own companies/WH . But for the Stock Availability checking we should be able to View (Only View) how much stock is available in other warehouses. How to achieve this without creating separate User Name.

Does anyone know how to get the Mobile App to allow the picking of inventory from a different location than what is defaulted on the shipment?  It seems you should be able to pick inventory from any location in which the item has quantity on hand, but it does not appear to allow for the scanning of any bin location other than what is specified on the shipment. 

A purchase requisition is created with the warehouse “Service”.On the shipping tab, the warehouse is identified as Service.As soon as we select a vendor on the Bidding tab, the Warehouse above changes to a different warehouse as well as on the lines within Line Details. Why is the warehouse changing as soon as we select the Vendor on the bidding tab? We have checked SKU defaults & vendor defaults and neither of these are specifying a different warehouse. 

Acumatica is working on expanding this area of the product and we are looking for customers whom are interested in working with us and piloting such functionality in their environment.  The goal is to include advanced capabilities that go well beyond simple predefined set of substitutions and upsell/cross sell possibilities for a given item.  We are looking to incorporate smart substitutions based on substitution history, cost considerations, inventory levels, user selections in prior order entry/checkout sessions, using ML technologies. If you are interested, please post here and one of our team members will get in touch with you to discuss this further.

Hello allI have a customer with large 500+ line orders and when they need to do a return that want to have a reason code on each line.  What are my options to add a reason code to 500 line ?  can I ‘upload’ via details or do I need a import ?   

Using the AP-Vendors GI I would like to add the email field from the Payments Tab on the Vendor Profile.Can you help me accomplish this please? I have tried a few tables with no luck. I have attached the GI Thanks John 

I’ve found that the non-stock kits default in a qty 0 shipped qty on the shipment. The allocation of the kit items do not occur until the shipped qty is manually updated. At that point, the items display on the pick list. Does anyone know why normal items bring over the shipped qty from the order while non-stock kits require inputting in a qty before the kit components allocate and show on the pick list? In order for the components to display, this flow is requiring users to manually updated the shipped qty on the non-stock kit item to get the components to allocate and display on the pick list.

I want to add non stock consulting item(See below figure) to invoices screen details tab when creating prepare invoice from shipments screen. I tried override shipment screen “CreateInvoice” action as well as fire Row Persisted event and override Persist method in Invoices screen too but unbale to do. I saw when fire Row Persisted event or override Persist method just executing(looping) no end point. Please give me any answer or suggestions.