Distribution

Good day,We have asked this question to Acumatica pre sales and they do not have a defintive answer and say we need to test this process. The current scenario that works is that Acumatica can recommend using Zebra scanners with the mobile app and it works using WMS, however the Sales order process is different and not tested.The client would like to achieve a process whereby they install the Acumatica mobile App onto a tablet or handheld device and then raise quotes and sales orders on the app, when they need to select the item to quote on they want to be able to use that same device to scan the barcode on an item and have that pull in the stock item into the SO/Quote. This would also be true for raising an invoice.They dont want to go the tradtitional route of a POS workstation that stands at a till point with a connected canner device as they require mobility for their sales team.Anyone else with this problem or have a solution?

On the more menu of the shipping screen, there is an action labeled “Get Return Labels”.I can find no documentation on what that is supposed to do.  Is it supposed to just print a label or does it do anything to data?Also, I get an error saying “Confirmation for each and every package is required.” when I do this to an open shipment.  If I have a Confirmed shipment open in the screen, the “Get return Labels” is grayed out and unavailable. Thanks for any insight!

Does anyone knnow where in the system I might be able to find the history of a physical inventory by item?   Is there a report or  screen where I can access that or pehaps someone knows the underlying table that I could look at through the DAC browser?   Any thoughts would be appreciated.

HI All,The Screen Sales Order always shows <SPLIT> on the Lot/ Serial Number Column.There is any way that we can show the content instead of <SPLIT>?Thank you,Yên Chi

Hello, I have a client that would like to invoice the non-stock item with the last shipped stock item from the sales order. Currently the non stock item freight is added to the first invoice created for the sales order. Is there a way of control this or do we need a customization? Thanks, Patricia 

I realize that the “Sold Since” date defaults to three months from the current date: Is there a way to default this to a different amount of time? A client may want to go back further, say six months, and not have to change this date every time.

A client would like to use FIFO for their inventory valuation method.  They use Batch control and expiry.  I have ticked the “cost sep” on the Warehouse location (they only use one location).When entering a Sales Order however it is only taking the cost of the first receipted qty.Is this the way the system works? I am assuming yes bc at the Sales stage the inventory has not been allocated yet so there is no way of picking up the cost?Regards,Laura 

When I display my custom report in acumatica mobile phone it show me the error like this object reference not set to an instance of an object. But this report I can run this report in web working properly.

Client sells to Distributors, Chains, Retail Outlets. They can ship the same item in a Pallet, Master Pack, Inner Pack or Each. For the purposes of compliance, they have to provide the weight and dimension of each of the shipping methods, although the UOM on the SALE is EACH. We have Acumatica and Pace Jet and are looking to see if someone has tackled this before and is there a way to best handle this other than attributes? 

I have a bunch of Android Tablet users who would like to print .ZPL files from a Zebra Label Printer. Usually I use DeviceHub or a .bat file to get this moving, but Android doesn’t support .bat and it looks like DeviceHub isn’t supported either.How do we print .ZPL files to a label printer in the Android OS?

Just updated to version 2022 R2.  Previously inventory was automatically updated at time of invoice.  Since the update, IN updates at shipment confirmation.  Where is this change coming from?  And how do I change it back?  Thanks in advance.

Hi, when posting any Adjustment to the Stock Item with Lot/Serial Number and Expiry date, if a user accidently enters a different Expiry date,  the system updates the Expiry date on all the stock for that item and set this new expiry date. can this be prevented or tracked so the client can see the old and new dates? Many Thanks 

Trying to import sales orders but some of the lines have invalid inventory ID’s that do not exist in Acumatica. I still need to import the lines that do but they all fail because of the inventory items that don’t exist. How can I skip invalid inventory line and get the rest of the file to import.The import works if I only import inventory ID’s that are in Acumatica. 

Hi Team,I have create a new processing screen and in view delegate trying to access a Use Defined Field value from Customer screen to show on UI and I am using 22.106.0015 build version. I have referred some community posts but not been able to access the defined field value. Below are the samples I have verified:The customer’s user defined field value stored in BAccountKvExt table and in DB able to access it but in code not able to access this table. Access User Defined Field from business logic | Community (acumatica.com) from this community post tried to access using new cache object but that also does not helps. public sealed class SOLineExt : PXCacheExtension<SOLine>    {        public static bool IsActive() { return true; } #region UsrEmployer        [PXString()]        [PXUIField(DisplayName = "Employer")]        public string UsrEmployer { get; set; }        public abstract class usrEmployer : PX.Data.BQL.BqlString.Field<usrEmployer> { }        #endregion} public cl

Hello linkies,I would like to have a clarification on the Complete Order option which under More Menu of the Sales Orders(SO301000) screen.  I have been trying to modify the status of an order from Open to Completed without creating any shipments.Even when the Completed checkbox is active at the line level, the status of the Sales Order still remains to be Open as shown below: Kindly let me know the use of Complete Order option for the same. Thank you in advance.

Hi,  I have updated the Access right via Import scenario. It updated high level access security. Ex. We enabled Funds Transfers as view only, but, system allow us to do the reverse when i open the funds transfer form. Is there any possibility to restrict all the levels at once? Regards    

Hello: how create a transfer from sales order, but the item comes from secondary warehouse? Best regards

We are trying to extract and update the base sales price using either ‘Sales price’ or in the ‘Sales price worksheet’ then using the copy prices option.  When we click on the ‘create worksheet’ or ‘copy prices’ we get the below error:An error occurred during processing of the field UOM value LENGTH Error: UOM 'LENGTH' cannot be found in the system. Please verify whether you have proper access rights to this object.We have tried to change the UOM for the rows with Length but we just get the same error but with the UOM we changed it to mentioned.Any suggestions?

Hello all, The price multiplier does not seem to work when I change the UOM. I have ensured to enable it in the SO preferences, and the item has a value in the price multiplier. Am I missing anything?Item at base UOMItem when UOM is changedPrice settings in SO PreferencesConversion setupAny help would be greatly appreciated. Thanks!

Does anyone know of or have a work around for default locations for transfers? I am talking specifically for automated operations. Acumatica has a default Issue from and Receipt to but there are no other defaults that I can see.  

How do I search Inventory ID from Sales Order line to find data contained in respective Item(s) LONG Description and/or Item ID Attribute ?

Hello expert.How cant I get data field in the “details” tab screen AP301000 below image? How can i fetch data each row? Thank you so much. 

Hi Community, please assist. I have setup an Import scenario to import vendor payment details into the system, However upon import, it imports the first Record and gives me an error for all other records. I have checked the formatting on my file and i think its ok. There is no difference between the first  record and all other records. PLease assit. What is it that i am missing 

I’m trying to create a GI (for a dashboard) that lists Inventory Transfers that have not been received. I’ve used my imagination and looked at tables in the DAC browser, but haven’t found what I’m looking for. Anyone have something to share? :)

Hello,is there a way to automatically check the “mark for PO” checkbox in a sales order if the entered quantity will result in a negative stock qty? The sales staff tends to forget to check the box every now and then. I am looking for a way to make sure no items from SOs are missing in our POs. thanks for your help.