Distribution

Version 22 R1I have added custom fields to accept shipment location and ship via in the sales order and split shipment is created based on location and ship via for the selected warehouse.I have override the ARInvoiceEntryExternalTax && SOOrderEntryExternalTax GetToAddress with line parameter to get the Location address selected in the line. These changes are working fine in 20 R2 and calculate the tax based on the location selected in line, but in 22 R1 it calculates tax and failed to calculate tax in the Sales invoice and throws an error: TX Error: Failed to get taxes from the external tax provider. 

 Hello,I’m getting some issues with Creating template items: The item with the same inventory ID already exists. Change segment settings of the inventory ID. Could someone enlighten me on a method to make this work?

Hi,I would like to know if there is a possibility of not impacting the stock of an article stored according to the SiteID ? ThanksXav 

Hi all, I had this problem on last version. It still happened on 2022R1. The problem is if I have an item have more than one subitem. And also set the different barcodes for them. When I use Scan and Issue/Scan and Receive/Scan and Transfer, It always use default subitem.  As below. I scanned RDC_RCN-5 barcode. But in the system it received BRN subitem.   Scan RDC_RCN-5 but in the system received BRN subitem. 

Hi all, How do I populate all the lot/serial number and expiry date per InventoryID in Report Designer like this: The lot/serial or expiry date need to display per InventoryIDThis is the value from expression editor (InventoryID Description field)=IIf([ARTran.InventoryID]<>Null, Format( '{1}', [ARTran.InventoryID],[ARTran.TranDesc]),[ARTran.TranDesc])  I found other topics from here in community and I followed their combination in Build Schema but it’s not working for me Link: (Print Batch/Lot no. and expiry date on invoice | Community (acumatica.com)) This is my build schema:I added the ARTran Left INLotSerialStatus table and the parent field belowINLotSerialStatus.inventoryID Equal ARTran.inventoryIDINLotSerialStatus.lotSerialNbr Equal ARTran.lotSerialNbr This is all my table:  I think I missed a table to combine the relation. Can you help me with my concern?  Thanks

Hello,I have added text to various places on stock items and none of them seem to print on POs.I’ve checked preferences for settings and did not find anything.Do I have to modify the PO report to include things like notes or description from the description tab?I want to make sure I am just not missing something before I start modifying the PO form.Thanks!

If I have an order for 3 items and I have no stock on hand (non-manufactured items), I still want to allocate those items after a PO is received. How can I allocate the stock such as a mass allocation in Acumatica? I know I can go to each order but if there are many, how can that be done? Looking for any suggestions on experiences or work arounds.  

Our next Distribution Show & Tell is only a few weeks out, on June 14. The topic is: Dashboards.I’m looking for more people to share Dashboards that you have created that have solved a business problem. Send me a direct message through Community or to my email: debramignola@gmail.com.If you don’t have anything to show but you’d like to see some great ideas, you won’t want to miss this!-Debra Mignola 

Hello,I searched for this and couldn’t seem to find an exact hit.I’d like to duplicate the ‘default Sales Person’ from the Commissions tab on the sales order to the Header so that Sales Reps can see, overtly, who is being defaulted (and change it if necessary) at the header level instead of the Commissions tab.Is this achievable?Cheers,k2

Hi,Is there any possibility to link an already created AR invoice to a sales order, without creating AR invoice through sales order. Thanks,Dulanjana

Hello,       We are using 2020R2 103 version.      We encountered another shipment status issue.  We are having shipment as status “confirmed”.However, the user can not “prepare invoice” based on it. It will show error:  And, the user can not “correct shipment” . It will show error:   I checked the Database, it looks like for some unknown reason , the “confirmed” column has not been set to 1. This is the second time, our user met the status mess up issue.  Unfortunately, we do not know how to reproduce it.Can Acumatica developers do an in-depth research to solve the root cause?

HI All,Please advise which access right is allowed user to see the articles on open help (form reference) 

Any help would be greatly appreciated!I cannot prepare invoices AT ALL! I am not sure what changed but if anyone has any idea how to get this fixed i would really appreciate it, need this fixed asap :( Thanks!

In inventory preferences there is a new option to allocate items in documents on hold.  Where is more information available on this?  Which release notes can this update be found in? Thanks.

How can we add a comment to all POs?  Ex., “We are closed on …………..”

Good day everyone,We have a client who is experiencing issues with the function of correcting the Shipment.The Shipment was confirmed by Accident. No Billing or inventory transaction has been taken place.The Sales Order is Completed. When I try to recreate the problem in Sales Demo environment. (Same settings on Order type etc), it works.The User hits Correct Shipment (myself included in that environment) and it says the Operation was completed. Yet, the status doesn’t change to Open as it should: Anyone ever experienced this?

HI, I have created a Item with UOM as CTN. I need to change this to BOX. I checked this, if I have any Transactions system allow me to change Sales and Purchasing Units. Then system created a conversion between both two unit of measures.  Tested scenarios attached with screen shots. 01). As mentioned Item Base unit is “CTN” and Sales and Purchasing UOM are “BOX”.Created a sales order and Order line has taken UOM as BOX then Shipped. Shipping Lines Considered UOM as BOX.  My Questions are:(01). If I change this over to a conversion rate of 1, and change the Unit of Measure, what will the implication be when we sell and purchase this item? Is it going to create a mess in the background with regard to the costs, or the average cost? (02). Is there any other validation or concerns about the UOM changes? RegardsNethupul   

Hi, I want to ask , is it available for input batch number of product in stock items menu ?

sd

Needing to change all customer profiles FOB point to a certain ID. We were able to change the description but need to change or delete the ID. Any suggestions? Thanks!  

Customer created a Credit Memo with an Inventory Return.  They need to reverse this Credit Memo and associated inventory receipt.  Is there a way to initiate the inventory issue with a Debit Memo, or does the inventory have to be handled with a manual adjustment? Thanks!Luke

Hello everyone,I get a error on the Pick, Pack and ship screen for unit of measure items. On my Stock Item my Base unit is CANS, Sales Unit and Purchase Unit is BOX.   Created a Sales Order with BOX UOM Shipment is showing correctly The Pick pack and Ship screen defaults to CAN UOM and converts the quantity but i get the following error. Pick Pack and Ship screenIf i change the UOM on the Stock Item to be the same for Purchases and sales then i don’t get an error on Pick Pack and ship. The problem with this is that will cause problems with the Procurement dept. and Sales Dept. has they will have to change the UOM every time to BOX.  Can we have Sales and Purchasing unit of measure different from my base unit when using Pick Pack and Ship?  

When receiving on a handheld in Acumatica (receive and Put Away). There is not the ability to change the unit of measure. That would be fine - except that we find that the quantity shown on the handheld as received always show in the base unit of measurement and not the received unit of measure. This is confusing to our warehouse staff.Does anyone know if there is a way to expose on the handheld the quantity received in the purchase unit of measure - in addition to the base unit of measure?

Hello, I cannot get a KitAssembly, Type=Disassembly to create through the REST API.  I am able to create a KitAssembly, Type=Disassembly through the Acumatica Kit Assembly user interface but a similar transaction through the REST API fails.  I am also able to create a KitAssembly, Type=Production through the REST API.I am making an assumption that a Disassembly type REST API call would be rather similar to the Production type REST API call.  I am using the same data structure just changing the Type to Disassembly. There are two errors that I get back that stick out:[LocationID] ‘STERILE’ cannot be found in the system.KitAssembly.ReasonCode. ‘Reason Code’ cannot be empty.Both of the above properties are being set in my API call and they do exist.

Hi All, we updated to the latest build and now scan gun when you do scan transactions, the “set qty” is not working any more.  So you can only add qty of 1 every time.  This is very bad.  Anybody else has this issue?  know how to fix?  Thanks.  Alice