Distribution

I am trying to post a Sales Order type IN. I enter the line information, ie the inventory-id, location, quantity etc. I enter the lot/serial number. When I click plus to enter a new line the system erases my lot/serial number. I don’t know what I am doing wrong.

We’re finally starting to get a handle on Availability and Alloctions...I think We have a DEMO location with items we do not want included for normal Sales operations, but do occasionally ship to customers or distributors.  Unchecking the “Include in Qty. Available” is a necessity since we do not want these items to be considered as available for normal Sales Orders.  However, with “Sales Allowed” still checked, we can add the items from that location to a Sales Order, but we cannot create a Shipment. The documentation says this:Include in Qty. Available A check box that you select if the quantities of goods available at this location will be included in the quantities of available goods and used in shipments and transfers. Sales Allowed A check box that you select if only issues (direct inventory issues as well as the issues generated from sales orders) are allowed for the location. You clear the check box if no inventory transactions are allowed for this location, except for i

Can Landed Costs (e.g. levies that are %) be auto calculated upon products received from a supplier?

Hi,I have done Custom in Purchase Order ScreenIn POLine level am trying to update Curyunitcost according to InventoryID -(Stock Item screen-Valuation Method-Specific)equal to 0it is updating but in header order total is updating with the price cost which is defined in stock items screen..From Where it is getting updating am not knowing..Please Suggest me with the Proper solution 

 When my company went live with Acumatica in 2019 we were given access to a preview release of the carrier integration for ShipEngine.  Last week upgraded to 2021 R1 (v21.117.0037) which includes this feature out of the box.  Before the upgrade I unpublished all customizations and did not republish the early release version we had been using.  Before this upgrade everything was working for us as expected between Acumatica and ShipEngine.After upgrading to 21R1 I had to modify our carriers to use our ShipEngine Account ID instead of the API Token that the preview release required.  After that change the Test Connection button on each carrier reports success.  However, when I edit a ShipVia based on one of these carriers the service method selector no longer loads in any of the services tied to our account.Due to this configuration issue, we are not able to successfully refresh rates or shop for rates from sales orders.  We are able to create shipments successfully with update 17, so I d

Hello, We want to track transactions that are discounted, due to a misprint/reprint (we decorate our products). I’m assuming Reason Codes on the SO Line is the best way to track this, but please suggest any good alternative ideas. Is there a way to make Reason Codes required for discounted SO Lines? Our users will forget to input a code unless we require it. 

Hello,       Does anyone know is there a way to set Maximum order qty for a certain item on order line?Like we are having item A, item A is a hot sell item, so we want to set a limit that each order can only buy 3 at maximum. Is there a way to do it?

We’re using a slightly modified Inventory Balance report. Some items are being excluded from the report. Only common denominator I can find is these items all appear to show ZERO QUANTITY ON HAND and ZERO AVG COST. But I can’t figure out why that would exclude them. Like I said the file is modified from the original, so I’m attaching it here. TIA! 

I need to inquire about the do ability of having Quality Control or Check in Acumatica new version 2021 R1

Hi!If I have an attribute list type and I'm using it as an UDF within Sales Orders and I want to limit access to one of the attribute value for specific users, is it possible?Thanks!!

i want remove Quantity Control in Shipment Screen, is there a setting for that?

Is it possible to use the Mobile App and perform a spot inventory counting.Such as using the inventory lookup tool on the mobile app.Then going to that location and update the inventory on the fly?

Is there a way to do a spot inventory count without creating any Physical Count sheet.Walk up to the bin location and scan the the location, then the bar code and then enter the quantity.

I am looking to do cycle counts on our inventory however I don't seem to have the box to check on the stock items screen.. Anyone else having this issue?

Hello Everyone,One of our clients using the Pricing Analysis functionality in the Sales Order screen, but we do not want to show the Zero unit cost items on it.If anyone knows about this functionality could you please let us know how can we achieve this? Please find the some screenshots for your reference.   

Hi,Is there a way to setup cost + % pricing based on the Vendor Price that’s setup in the system?The only way I can currently think of to do this is to come up with a price file on Excel outside of Acumatica and import it through the Sales Price Worksheets for a specific customer. Are there any limitations on that screen in terms of # of rows? We need to set this up for approximately 10,000 items.Thank you!

Is there a way to increase the qty shipped on a shipment record without first having to edit the original sales order?

This is a follow up to this one:  How do I make my default value for my second UOM selector appear in the selector on page load?Here’s my DAC declaration. I also used the strategy in the referenced link to set the values for the selector dropdown on load.I added this to try to get the default value to display...but it didn’t work:         [PXUIField(DisplayName = "jUOM", Visibility = PXUIVisibility.SelectorVisible)]I also tried a few other things that didn’t work. Any thoughts on how to get a Default value to appear in the Selector at load?This part of the below referenced DAC should load the default, I think, but it doesn’t work…        [PXDefault(typeof(Search<InventoryItem.salesUnit, Where<InventoryItem.inventoryID, Equal<Current<SOLine.inventoryID>>>>), PersistingCheck = PXPersistingCheck.Nothing)]         #region juOM        public abstract class juOM : PX.Data.BQL.BqlString.Field<juOM> { }        protected String _jUOM;        [INUnit(typeof(SOLine.i

I have a need to remove the current quantity from item stock.  The quantity were incorrectly imported.  This tenant has been inactive.  We have sales or purchase transactions.  What is the best or easiest why to zero out the quantities.  I was thinking of doing an inventory adjustment or use the physical count.  There are financial issues since the tenant has not transaction.  The amounts were imported.  I appreciate any assistance or advice on the best way to handle this issue. 

I have created a second PXSelector that mimicks the behavior of the out-of-the-box UOM field in the Sales Order entry screen. I have detailed the process of creating this below; I have basically copied all the elements I can find from the existing UOM field (and renamed to jUOM as necessary). Everything works, except I get an error when saving the Sales Order document that says “Invalid column name ‘jUOM’.I am stuck trying to figure out how to create an extended field on the SOLine cache that can save the value chosen by the user for this second UOM field (called jUOM) to a field in the database.I confess to not really understanding how the out-of-the-box UOM field is being saved to the SOLine database table, which is part of my problem. I have played around with using PXDBString etc, but that breaks the UOM selector (can’t be used with the:  [INUnit(typeof(SOLine.inventoryID), DisplayName = "jUOM")] DAC field declaration).Can someone help me makes sense of what’s going on with these U

Hi everyone,We need to use different languages in Acumatica. The website is working well. I only have problem with mobile app. I checked out the mobile code as below. Does anyone have any ideas to add localization for mobile app?  

Hi, I’m relatively new to Acumatica but far from new to ERP systems and implementations.I have created an item number. That Item can exist at three warehouses. Those warehouses have replenishment relationships defined with each other. I have set safety stock, order multiples, etc. at each location. I have set an inventory level at the main picking warehouse that is significantly below the safety stock. At this point, I would expect replenishment activity to be suggested to transfer stock from the next warehouse in the chain. This does not happen.I then increased the demand at the picking warehouse by adding a sales order, in case there was some requirement for a SO to trigger the replenishment. This also did not work.Hopefully, I am missing something really straightforward.Warehouses are PICK, BOX and OFF-SITE. What I want is for transfer orders to be suggested to bring stock in from BOX to PICK when there is SO demand or when safety stocks fall below the defined parameters. Likewise,

Can anyone help me with this?It is only sending to the first email in the list 

Good dayI am import my invoice type “cash returns” and on the template I am getting the following error message“object not set to an instance of an object”There are no customizations done on the invoice screen SO303000 

We have a few items that the Vendor is requesting that we order in multiples of 10. We thought of doing a Pop-Up Note for the item so it would appear when placing on a PO, but then it appears on the Sales Order screen also.  This is confusing to the order entry users. Any other suggestion on how to accomplish ordering the correct amount on the PO?